SUMMARY

• 6+ years of professional experience in database design, development of MS SQL SERVER 2008/2008 R2/2012/2014 with Business Intelligence tools SQL MS Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS)
• Strong knowledge with Waterfall, and Agile/SCRUM Methodologies.
• Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL
• Experience in creating packages to transfer data between Access, Excel, CSV, Oracle, flat file, Text Data to SQL SERVER using SSIS
• Experience in developing, monitoring, extracting and transforming data using SSIS, Import Export Wizard, and Bulk Insert
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Experience in specifying issues in database, Performance Tuning, Debugging, Troubleshooting and improving database performance.
• Extensive experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS), creating various packages depending on user requirements.
• Superior experience in usage of SSIS Control Flow Tasks (For loop, For each loop, Execute SQL task) and Data Flow Tasks such using transformation (Conditional Split, Data Conversion, Loop up, Derived Column, Merge, Union all, Merge join).
• Created different types of reports such as Parameterized, Chart, Graph, Linked, Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model using Report Builder
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages.
• Using the Tableau desktop for the dashboard development activities such as creating the calculations, calculated fields, hierarchies, filters, Actions, Defining the various indicators, gauges for the various KPIs and Measures with various charts and Graphs.
• Used Tableau Desktop for the Data Analysis, Data Visualizations and for the data explorations.
• Have knowledge in Power BI and creating and developing Power BI Dashboards into rich look.
• Have good knowledge in Tableau visualization and dashboards using Tableau Desktop.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages
• Strong inclination for finishing job within project deadline and good time management skills, Able to manage changing responsibilities and deliver time critical projects on schedule.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope.
• Extensively involved in doing user acceptance testing (UAT).

TECHNICAL SKILLS

SQL Server Tools &Packages/ETL tools: SQL Server Management Studio, SSIS, SSRS, SSAS, BIDS, SSDT

Databases: Microsoft SQL Server 2014/2012/2008 R2/2008/2005, MySQL, MS Access.

Programming Languages: T-SQL, PL/SQL, C# (basic)

Reporting Tools: MS SQL Server Reporting Services, Power BI and Tableau

Version Control/Tools: MICROSOFT TF S, HP/ALM, JIRA, MS EXCEL, MS WORD, MS POWERPOINT

Scheduling Tools: Autosys, SQL Job Agent

Platforms: Windows, Windows Server, DOS

Workflow Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL/ETL/BI Developer

Responsibilities:

• Created tables, views, functions, stored procedures, and indexes and derived tables as per requirement
• Designed and Developed complex ETL packages to load the data from FTP to destination tables using transformation like Execute sql Task, For Each Loop, Variables, Derived Column, Expressions, File System Task, Look Up, and Data Profiling Task and so on.
• Created the ETL packages that will load the loans from the latest source every day, have a script task to loop through different folder within the latest folder, transform them, assign the batch number and loads them to the final table
• Created SSIS pkg to load data from Share point, Oracle, Teradata, files, Excel to sql server data warehouse
• Designed Create and deployed reports like Drill Down, Drill Through, Cascading and Drop-down menu option and Parameterized, Sub-report, and Linked reports in SSRS
• Optimized existing procedures for data load by adding batch-based loading using while loop
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts and also created parameterized reports passing parameter through report
• Extensively worked Design and develop SSIS (ETL) packages to validate, extract, transform and load data from different Sources like Oracle, Excel files, flat files to the Data warehouse using different task and transformations like Derived Columns, Execute SQL Task and Send Mail task.
• Extensively worked on Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, Copy Column, Derived Column and so on in SSIS.
• Fine-tuned queries to make the reports run faster.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and optimized the procedures.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, and Indexes
• Extensively used SQL queries for data validation and backend testing, created test plan, test cases and do the Unit testing, SIT and UAT and send them to projects lead for approval.
• Worked with product owner and scrum master to refine, design and test requirements
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explore data in a Variety of ways and across multiple visualizations using Power BI
• Published reports and dashboards using Power BI.
• Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX.

Environment: Microsoft SQL Server 2014/2012, Power BI, Microsoft Excel, SSIS/SSRS 2012/2008, Microsoft Office, SharePoint, Microsoft TFS, BIDS, Visual Studio.

Confidential, Des Moines, IA

Data Analyst/SQL/ETL Developer

Responsibilities:

• Designed develop and tested packages to extract, transform and load data (ETL) using SSIS.
• Performed query optimization for faster processing of queries, developed stored procedures, user defined functions, triggers, indexes and views.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Worked for performance tuning and optimization of SQL queries and indexes, automatic restart of SSIS packages after Failover or Failure.
• Used a variety of Data Flow Transformations, like Derived Column, Copy Column, Lookup, Data Conversion, Union All, Multicast and while developing the packages.
• Produced ad-hoc queries and developed reports to support business needs.
• Expert in creating various type of reports such as drill down, Matrix reports, Sub reports and Charts using SSRS.
• Performed sorting, formatting and grouping to custom reports in SSRS and published reports to the report server
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to the Clients.
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages.
• Collaborated with the Business and Developer to develop the Test and Acceptance plan criteria for Performance and Load Testing and thereafter generated test plan, test cases.

Environment: Microsoft SQL Server 2014/2012/2008 R2, Microsoft Excel, Tableau, SSIS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, Microsoft TFS, Visual Studio, T-SQL, SharePoint.

Confidential, Lewisville, TX

SQL/BI Developer

Responsibilities:

• Created Stored Procedures, Functions, Tables, Views and other T-SQL code and SQL joins to ensure efficient data retrieval.
• Working extensively in Power BI report, creating a tabular cube, creating a data model for Power BI Report, Validating data quality of the report.
• Participated in business and requirement gathering meeting and discussions. Worked with business users directly in collecting information for ad - hoc reports.
• Created SSRS reports deployed them to report server and created subscriptions for them as per the business requirement.
• Created SSIS packages to load the files like text, xml and excel from FTP to staging table using various task like Data Flow Task, Sequence Container, Aggregate, Derived Column, For Each Loop, Conditional Split, Lookup, Merge Join, Multicast and so on
• Worked on Requirement Analysis and Data Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Used control flow tasks like For Loop Container, for each Loop Container, Sequential Container, Execute Tasks, Email task and different Data Flow Tasks
• Designed and deployed reports with Chart reports, Drill Down, Matrix, Drill Through and Drop down menu option and Parameterized and Linked reports in SSRS.
• Created data analysis queries to troubleshoot issues reported by users
• Added notification to all my packages to notify users on success and log errors on failure and send the message.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning.
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Formulating various postproduction data quality and error handling SQL scripts
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, power BI, SSIS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, Microsoft TFS, Visual Studio, T-SQL, SQL Server Agent, SharePoint.