SUMMARY:

• Over 8 years of experience as a Sr. Enterprise Data Warehouse/SQL BI, Power BI developer that includes migration of data and reports using SQL server 2012/2008R2/2008and Visual studio 2010/2008/2005.
• Experience in various industrial domains such as Finance, Insurance, and Health Care.
• Expert in Database Design, Data modeling, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/2012 with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) especiallyAgile, Scrum, involving business process analysis, requirements gathering and analysis, detailed design, development, testing and post implementation support.
• Strong knowledge of Data Warehouse concepts - EDW, Datamart and ODS, ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key generation.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Strong expertise in Data modeling using Erwin Data Architect, Erwin 9/8/7.2 with good understanding of Relational Database Management Systems (RDBMS).
• Expert in Logical and Physical Database design & development and Data modeling using the Erwin Data Modeler tool. Performed consistency checks using DBCC utilities to ensure the physical consistency of the database and objects.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS) and Power BI solutions.
• Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R2/2012 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP.
• Widely used VB scripts, C# in the script task in SSIS packages.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Scheduled & distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business Intelligence Development Studio.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experienced in creating Jobs, alerts, SQL Mail Agent, scheduling packages using SQL Agent.
• Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Extensive experience in database activities like Data Modeling, Database Design & Development, Coding, Implementation, Maintenance and Performance Monitoring & Tuning using tools such as Index Tuning Wizard, SQL Profiler and Replication.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.
• Created interactive dashboards using reporting tools like Qlikview, Tableau and PowerPivot Models.

TECHNICAL SKILLS:

• MS SQL Server 2005/2008/2008 R2/2012
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
• BIDS
• Reports11/10/9/8.5
• Qlickview
• Tabelau
• PowerPivot
• Sharepoint
• Visual Basic 6.0
• Visual Basic.NET
• HTML
• XML
• Oracle 7.x/8i/9i
• SharePoint Technologies 2007
• MS Visio
• DTS
• Import/Export Data
• Bulk Insert
• BCP
• SQL Profiler
• SQL Query Analyzer
• Enterprise Manager
• Management Studio
• Replication
• SQL Agent
• Oracle 10g/11g
• SQL Developer
• Toad
• Unix
• Linux
• MS Visual Source Safe 6.0/8.0/2005
• Visual Basic 6.0
• T-SQL
• PL/SQL
• HTML
• CSS
• XML
• VB.Net
• ASP.NET
• Erwin
• JIRA
• ALM
• TFS
• Microsoft Productivity Software (Word Excel Outlook PowerPoint Visio)
• Healthcare
• Healthcare Insurance
• Supply chain Management
• Mobile
• Asset Management
• Banking.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Senior Application Developer (EDW/MS SQL Server/SSIS)

Responsibilities:

• Responsibilities included analysis, mapping, cleansing, transforming and Developing code for processing of the incoming Eligibility, Claims, Member, Provider and Accums data which we received in various file formats (NCPDP, C4, ABF ) in flat files(delimited or ragged right format) based on the Finalized and approved Business Documents (BRD/IRD’s) with file format specifications and Master data appendix
• Gathered business requirements, IRD documents, Data mapping as per company standards, incoming and existing data quality analysis, working in conjunction with the data warehouse architect.
• Designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of Visio and Implemented.
• Designing and developing SSIS packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and Triggers.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Responsible for the deployment of the SSIS packages jobs and Configs on the Dev and Test environments perform Unit testing.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Created and presented POC for performance improvement of existing EDW/DataMart ETL with time and budget estimates.
• Analysis and improve performance of existing Stored procedures and views.
• Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques
• Followed Agile scrum methodology.
• Participated in scrum planning sessions and Daily scrum calls and provided estimations, points and updates for tasks and stories.

Environment: MS SQL server 2012, BIDS, T-SQL, .NET, C#, Power pivot, Visual Studio, SSMS, PowerPoint, MS Project, MS Server Integration services (SSIS), TFS, ER Studio Data Architect, Red Gate, Rally Agile Central, Crystal Reports, HP - ALM.

Confidential, Montvale, NJ

Lead EDW / MS SQL Server/ETL Developer

Responsibilities:

• Involved in EDW Framework Build process, discuss design options and preparing POC’s to present to the team and come up with new ODS, DM Model and worked on the ETL Design and Framework.
• Created data flow mapping documents, Data Flow Diagrams, Entity Relationship Diagrams using Visio/MS Excel.
• Following daily tasks using Agile methodology, attending daily scrum for updates and progress.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and Triggers.
• Designed SSIS Packages to transfer data from various sources like SAP HANA, Hyperion, Oracle, Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Scheduled ETL Jobs using Sql Server Agent and verified the data load in different environments.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created Stored procedures and ETL packages for Data Reconciliation and triggering the Qlikview Dashboard based on the reconciliation result.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time frame.
• Created Config Files and maintained the SQL Server Config Table in Dev and QA environment and provided necessary documentation to the DMG team to deploy SQL Server objects, packages and Config files in Prod Environment.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.
• Using SSRS expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions and report delivery.
• Also performed optimization on new and existing reports.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, Power pivot, Visual Studio, SSMS, PowerPoint, MS Project, MS Server Integration services (SSIS), TFS, ER Studio Data Architect, JIRA.

Confidential, NYC

Sr.MS SQL Server ETL Developer

Responsibilities:

• Involved in gathering requirements and Data Mapping and analysis with team lead for efficient Reporting of the database.
• Worked on Agile Scrum Methodology and designed Logical and Physical Data model for data transfer from the Client DataMart’s to DataMart -EDW with the help Sybase Power Designer.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Widely used SSIS transformation such as Derived Column, send mail task, fuzzy lookup, fuzzy grouping, data conversion and aggregate.
• Prepared Jobs and auto generated system using SQL Server Agent to schedule the packages.
• Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.
• Involved in migration planning from Sql Server 2008 to SQL Server 2012 and prepping the packages and Config’s for initial deployment.
• Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.
• Created reports and Dashboards using Power BI for analysis and deployed to SharePoint and scheduled refresh and provided access to end users along with documents.
• Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.
• Prepared ETL understanding documents like mapping documents and Technical Specification Documents.
• Coordinating with the Architect and Offshore DBA’s to schedule UAT and Prod Deployment and provided necessary scripts, packages and Configfiles and documents.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, Power BI, Power pivot, Visual Studio, SSMS, PowerPoint, MS Project, MS Server Integration services (SSIS), TFS, ER Studio Data Architect, Power Designer.

Confidential, Parsippany, NJ

Sr.MS SQL Server EDW/BI Developer

Responsibilities:

• Involved in gathering requirements with from business and analyzing the necessary design change along with the Architect for new CAB EDW project.
• Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.
• Designed FRD’s - Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures using Visio and presented to the team for review.
• Prepared RCA’s (Root Cause Analysis) to enhance the old logical and physical database design to fit new business requirement, and implemented new design for the Commissions and Billing Project.
• Understanding the existing Avanade Framework, designed and developed packages for Data Warehousing and Data Migrations projects using Integration services (SSIS).
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel, OLEDB and Access to SQL Server.
• Developed Stored Procedures to handle slowly changing dimensions to maintain historical data of the EDW for BO reporting and analysis purposes.
• Used various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column
• Designed, reviewed and created primary objects (Tables, Views, stored procs, Indexes, etc.) based on logical design models, user requirements and physical constraints.
• After package development, created TSD for high level understanding of the package process, also for documentation and review purposes.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations.
• Optimized the Views, Queries and Stored Procedures to enhance the SSIS packages and reduce the run time of the master package and the Zena Job process.
• Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services.
• Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.

Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft SQL Server 2008R2, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010, MS Visual Studio, ALM.

Confidential, Chester, NJ

Sr. MS SQL BI Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in designing ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.
• Designed database, tables and views structure for the new data mart required for Healthcare Insurance client.
• Developed and modified sub reports, drill down, drill through, cascading parameterized in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation.
• Developed various Charts and Graphs like bar charts, line charts, pie charts by using SQL Reporting Services.
• Created SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into MS SQL Server 20012 using SSIS Packages and SSIS logs.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Developed SSIS tasks to download Encrypted files from remote SFTP server, decrypt and stage data in Staging DB.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination
• Performed transformations using various SSIS components such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Used VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.
• Created Error logs and stored procedures to capture data discrepancies and send mail to the appropriate technical end user.
• Created Views to reduce database complexities for the end users.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Scheduled Jobs for executing the stored SSIS packages/Master Packages which were developed to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.
• Involved in design, code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Built the dimensions and fact tables with star schema using SQL Server Analysis Services (SSAS)
• Scripted MDX queries for populating datasets.
• Implemented SSAS Cubes, Fact and Dimension tables to perform analysis.
• Deployed Cubes on Development Server and Production Server.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, PowerPivot, Visual Studio, SSMS, PowerPoint, Power BI, MS Project, Unix, MS Server Integration services (SSIS), MS Server Reporting services (SSRS), MS Server Analysis Services.

Confidential, New Brunswick, NJ

Sr.MS SQL SSRS/SSIS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Created and managed schema objects such as Tables, Views, Indexes, Stored Procedures and Triggers.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Oracle and Text files and Excel files and MS word 2007 files) to SQL Server.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Responsible for the deployment of the reports on the reporting server and scheduled subscription for the windows file share.
• Developed different types of reports like Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Drill through reports.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Build packages and handled slowly changing dimensions to maintain the historic data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created and Configured OLAP Cubes using SQL Server 2012 Analysis Services and Performance tuning and scaling to large numbers of users.
• Evaluate business performance with key performance indicators ( KPI) using SQL Server Analysis Services.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time frame.
• Deployed reports on Microsoft Office SharePoint (Moss).
• Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS) and created SSRS reports.

Environment: MS SQL server 2012, BIDS, T-SQL, Oracle 11g, PL/SQL, .NET, Power pivot, Visual Studio, SSMS, PowerPoint, MS Project, MS Server Integration services (SSIS), MS Server Reporting services (SSRS).

Confidential, Jersey City, NJ

Sr.MS SQL Server BI Developer

Responsibilities:

• Involved in gathering requirements with team lead for efficient Reporting of the database.
• Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of SSIS.
• Worked on various tasks and transformations like Execute Sql task, Execute Package Task, Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Widely used SSIS transformation such as Derived Column, send mail task, fuzzy lookup, fuzzy grouping, data conversion and aggregate.
• Developed auto generated system using SQL Server Agent to schedule the packages.
• Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.
• Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation.
• Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services.
• Used various SSRS expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions.
• Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.
• Integrated MS SSRS with SharePoint Foundation 2010/SharePoint Server 2010 by configuring a report server to run in SharePoint integrated mode
• Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services.
• Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.

Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.

Confidential, Matawan, NJ

MS SQL Server Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2008.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, Excel, OLEDB and Access to SQL Server.
• Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations.
• Handled slowly changing dimensions to maintain the history of the data.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Created User Defined Functions, Triggers, Indexes Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Environment: MS SQL Server 2005/2008, T-SQL, Windows 2000/2003, Crystal Report 8.5, MS SQL Server Integration Services, MS Share Point, MS Excel, HTML