SUMMARY

• Over 7+ years of experience in Database Design, Development and providing ETL/Business Intelligence applications using Microsoft BI stack.
• Effectively involved in all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance of projects.
• Extensive SQL Development experience in a Banking & Healthcare environment with a strong understanding of data & analytics.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSRS and T - SQL Programming using DDL, DML and DCL commands for various business applications.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Expert in using SQL Server Agent to Schedule and monitor Jobs.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMF’s and Query Execution Plans.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Expertise in conversion of DTS to SSIS packages and troubleshooting the migration issues.
• Used incremental approach in the Workflows and Data Flows to integrate source data into warehouse tables using required transformations.
• Experience in providing System and User-defined Variables, Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various SSRS Reports like Charts, Filters, Sub-Reports, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting.
• Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions ( 2005/2008/2008 R2) & features.
• Expertise in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Crosstab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports.
• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.
• Design and createdashboardreports which illustrate the data in tabular format and well formatted charts.

TECHNICAL SKILLS

Tools: /Utility Enterprise Manager, SQL Server Management Studio (SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SQL Server Data Tools (SSDT), Visual Studio 2005/2008/2012/2015/2017 , Visual SourceSafe 8.0

Programming Languages: Pascal, C, C++, Visual Basic 6.0. VB.Net, ADO.NET, ASP.NET, T-SQL, PL/SQL, HTML, XML, MDX, MDS, MDM, DAX.

Tools: DTS, SSIS, SSRS, SSAS

DATABASE: MS Access, MS SQL Server 2005/2008/2008 R2/2012/2016

Operating Systems: Windows NT/98/2000/XP/2003/2008 server

Software: MS Office Visio, MS-Project 2000

IT Processes: Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential

SQL/SSIS Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and Updating and maintaining Visual Source Safe.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.
• Documented all the work and all the process of integration and reporting services for further references
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/20014, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise Manager, Windows Server 2003/2008, DTS, Share Point Portal Server, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.

Confidential

MS SQL Server /ETL Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed, monitored and deployed SSIS packages
• Developed SSIS Templates that can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Worked on development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target and Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Using DTSX Change tool converted DTS packages to SQL Server 2005 SSIS packages.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created SSIS packages to retrieve data from Legacy sources and retrieve user data from the Flat files on monthly and weekly basis.
• Responsible for data analysis, loading data from Data feed to Data Warehouse tables.
• Involved in conversion interfaces on QNXT Member, Provider, Claims Processing, Utilization Management, Accumulators, Contracts and Benefits.
• Used techniques like backups, restore, replication, and standby databases to ensure higher availability Production Environment.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created Tabular Matrix reports, Charts and graphs as per customer requirements using SSRS.
• Good understanding of SSRS with Report authoring, Report management, Report delivery and Report security and Created reports with Analysis Services Cube as the data source using SSRS 2005/2008.
• Involved in designing the physical database models on SQL Server 2005 RDBMS using DML/DDL implementing constraints and triggers for data integrity.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Worked with development teams in the design of physical databases and in modification.
• Involved in migration from SQL Server 2005 to SQL Server 2008
• Created incremental data load task using SQL Server Integration Services

Environment: MS SQL Server 2008/2005, SSRS, SSAS, SSIS, SQL Query Analyzer, SQL profiler, Enterprise Manager, ERWIN Data Modeler, Windows Server 2003/2008, DTS, Share Point Portal Server, Visual Studio 2005, MS Access, MS Excel 2007.