SUMMARY

• Over 7+ years of Experience in Data Modeling, Database Design, Development, Implementation, Maintenance of SQL Server Database and Business Intelligence Applications - SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.
• Experience in SQL Server 2008 R2, 2012, 2014,2016
• Experience in developing applications using T-SQL Programming (DML, DDL, and DCL).
• Expertise in Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co--related sub queries, Dynamic SQL queries.
• Experience in IT, Retail, Banking, Health and Insurance environments with primary skill on the Development, Design and Implementing Client/Server application using Microsoft SQL Server and BI suite for OLAP&OLTP.
• Highly proficient in use of T-SQL for developing complex Tables, Stored Procedures, Triggers, User Defined Functions, Data Cleansing, Data Integrity, Clustered & Non-Clustered Indexes.
• Experience in enhancing and deploying SSIS packages from development server to production server and resolving complex issues and Error Handling, Precedence Constraints, Break Points, Check Points, Logging.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experienced in Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) while transferring the data to target destinations from various sources like Excel, CSV, and Oracle, Flat File, Raw file, DB2 and XML File by using Import Export Wizard, DTS SSIS utilities.
• Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in designing complex reports like Tabular, Matrix, Cascading reports, Drill-Through reports, Drill-Down reports, Linked reports, Pie Chart reports, Ad-Hoc reports, Snapshot reports.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Expert in creating Cubes and Dimensions building, deploying, processing and maintaining cubes using SSAS.
• Expert in gathering business requirements and converting them into technical requirements
• Implement/code reporting and database solutions usingclient standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture.
• Flexible, enthusiastic and project- oriented team player with excellent written, verbal communication and analytical skills to develop creative solutions for challenging client needs and business requirements in various domains.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.

TECHNICAL SKILLS

Databases: SQL Server 2016/2014/2012/2008 R2

Operating Systems: Windows XP& NT, Windows 7/8

Language: C, SQL, T-SQL, UNIX, PL/SQL, C#, VB.NET.

Database Tool: SQL Profiler, SSMS, Database Engine Tuning Advisor

Data Modeling Tools: Erwin, Red gate, Lite Speed

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling.

BI Suit: SSAS, SSIS, SSRS

ETL Tools: SSIS

Reporting Tools: SSRS, Tableau

Other Tools: Erwin, Visio, Visual Studio, MS Office Suite

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential - Memphis, TN

SQL Developer

Responsibilities:

• Data migration to transfer data from legacy to SQL Server Objects and maintaining the data.
• Developing the reports using SSRS, Tableau as per the business requirements.
• Working on SQL development environments. Writing the T-SQL queries to retrieve and manipulate data in SSMS.
• Creating the Tables, views, Stored Procedures, Functions and tuning the SQL queries for maximum efficiency and performance using SQL profiler and Database Engine Tuning Advisor.
• Creating and deploying the new SSIS Packages to extract data from legacy to SQL Server and load data to data warehouse, databases and data mart.
• Created Tables, Views, and Triggers, Stored Procedures, Functions and other T-SQL scripts.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Worked on Filtered Views, views and Base table integration between different source systems.
• Worked with different methods of logging in SSIS and created packages in SSIS with error handling.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for on-going ETL Processes.
• Modified existing ETL packages to support additional/new features based on the customer requirements.
• Modifying the existing packages and scheduling the SQL server agent jobs.
• Developing the reports using Tableau and publishing them to production server.
• Creating tabular, matrix, chart, parameterized reports in Tableau
• Taking the requirements from Business User’s and developing the reports using Tableau and SSRS.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Developed the dashboards using the calculated fields, parameters and various functions.
• Testing the report to make sure all the values are populated properly.

Environment: MS SQL Server 2016, SSIS, SSRS, Microsoft Visual Studio 2015, SQL Server Management Studio, MS Excel, T-SQL, Tableau 10.4

Confidential - Columbia, MD

ETL/ Report Developer

Responsibilities:

• Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/ SSIS Packages.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses.
• Migrated data from one server to other by cleansing the data and performing various transforms.
• Modified the existing packages after adding new columns or modifying the logic for existing columns.
• Modified facts and dimension tables and EDW packages.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Used For-Each Loop Container, Sequence Container, Script task, Expression, Execute SQL task, send Mail Task, Package Execution task to achieve business needs.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse, databases, and data mart databases.
• Modified the existing store procedures and views.
• Hands on Job Scheduling of SSIS packages through SQL Server Agent.
• Constructed complex SQL queries to retrieve and manipulate data.
• Also worked as ETL tester for this project by writing test scripts.
• Created technical documents for data mapping and database migration.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Created simple and complex SSRS reports like map reports, charts, indicators, secondary axes, custom coding etc.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Migrated reports from SSRS to Power-Bi
• Worked on Agile Methodology and Kanban.

Environment: MS SQL Server 2012/2016, SSIS, SSRS, Unix, Microsoft Visual Studio 2015, SQL Server Management Studio, MS Excel, T-SQL, Tableau, C#

Confidential - Minneapolis, MN

SQL (SSIS/SSRS) Developer

Responsibilities:

• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data, Normalized tables.
• Created Tables, Views, and Triggers, Stored Procedures, Functions and other T-SQL scripts.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Worked on Filtered Views, views and Base table integration between different source systems.
• Worked with different methods of logging in SSIS and created packages in SSIS with error handling.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for on-going ETL Processes.
• Modified existing ETL packages to support additional/new features based on the customer requirements.
• Execute an SSIS Package through a C# application by adding reference for run the DTS Package.
• Provide technical support, troubleshoot and monitor packages released for staging.
• Used Stored Procedure which is created into SQL Server. Then execute that Stored Procedure from C# Code to Execute SSIS Package.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
• Migrated existing self -service reports and ad-hoc reports to Power BI .
• Worked on Ralph Kimball Data Warehouse Methodology.
• Used .net to write code in Script mail task so that it can be used in multiple SSIS packages .

Environment: MS SQL Server 2008R2/2012, SQL Server Reporting Services 2008R2, SSIS, SSAS, Unix, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, C#, VB.net frame work

Confidential, Brenham, TX

MSBI(SSIS/SSRS) Developer

Responsibilities:

• Created and Updating, Clustered and Non-Clustered, Indexes to keep up the SQL Server Performance.
• Extracted large volumes of data feed from different data sources, performed and transformations and loaded the data into various Targets.
• Used For-Each Loop Container, Sequence Container, Script task, Expression, Execute SQL task, send Mail Task, Package Execution task to achieve business needs.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse, databases, and data mart databases.
• Hands on experience in designing PowerShell code for SSIS Project deployments in SQL Server SSISDB, Pivot tables, VLOOKUP validations in Excel
• Created SSRS reports with Dynamics AX as source and SQL Server as source.
• Developed SSAS cubes, partitions, aggregation from scratch with Star Schema.
• Created tabular, matrix, chart, drilldown reports and parameterized, cascaded reports according to business requirements.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Execute an SSIS Package through a C# application and VB.net frame work by adding reference for run the DTS Package.
• Hands on Job Scheduling of SSIS packages through SQL Server Agent.

Environment: MS SQL Server 2008, Windows XP, SSIS, SSRS, T-SQL, UNIX, Data Mart, ETL OLAP, OLTP, C#, VB.net frame work .

Confidential - Lenexa, KS

MSBI (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Implemented performance tuning T-SQL queries, Stored Procedures and SSIS Packages, Peer reviewed T-SQL code/ SSIS Packages.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Responsible for converting Client’s online reporting tool to SSRS and Business Objects based on the requirement.
• Constructed complex SQL queries to retrieve and manipulate data.
• Created documentation on configuration of the application.
• Created the SSAS cubes.
• Deployed SSAS cube solution to different servers.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc. using SSIS.
• Created simple and complex SSRS reports like map reports, charts, indicators, secondary axes, custom coding etc.
• Involved in making enhancements to the existing cube solution like adding measures, dimensions, calculated members, KPIs, MDX.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Configured Report Server and SharePoint, and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Inspected the reports and fixed bugs in stored procedures and also tuned Reporting Services to the T-SQL.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, T-SQL, MS Visual Studio, .Net framework.

Confidential, Philadelphia, PA

MSBI (SSIS, SSRS, SSAS) Developer

Responsibilities:

• Understanding the business requirements, analyzing source system, source files, setting up goals for implementing the new client.
• Assisted in complete Life Cycle including Design, Development and Testing.
• Managed the entire ETL process involving access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Created DTSX Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Created ETL packages using Microsoft Visual Studio and Microsoft SQL Server Management Studio. The ETL packages are referred to as pre-processors that process the input data to a financial services based software application.
• Optimized existing stored procedure code system processing and indexes.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Reports using SSRS.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data Marts and other Financial Reports.

Environment: Windows Server 2003, SQL Server 2008, BI studio 2008, SSIS, SSAS, SSRS, Microsoft windows XP, C#, .Net frame work

Confidential

SQL Developer

Responsibilities:

• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Analyzed business requirements and built logical and physical data models that describe all the data and relationships between the data using Erwin.
• Created and deployed new SSIS packages to extract data from legacy to SQL Server Objects. Implemented BCP for bulk inserts.
• Evaluated database performance and performed maintenance duties such as Tuning, Replication, Backup and Recovery.
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Involved in peer to peer testing and code reviews.
• Created indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.
• Created subscription of Reports in different formats like PDF, Excel etc. to be executed automatically on weekly or monthly basis.
• Responsible for the design, development and implementation of mappings/transformations based on source to target specifications, defining ETL and development standards.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Un Pivot.
• Involved in the complete Data Warehouse development life cycle. Actively supported business users for change requests.

Environment: MS SQL Server Management Studio2008/2008R2, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS).