SUMMARY:

• 9+ years of Professional IT experience as Microsoft SQL Server BI/ETL Developer in diverse Sectors like Financial/Federal Government/Insurance/Healthcare/Housing Mortgage and Experience in Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Integration and Testing, Implementation and Production support.
• Experience in analyzing, designing, developing and Performance tuning Client/Server, Business Intelligence database applications in various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2014/2012/2008 R2/2005 SQL Server Integration, Reporting and Analysis Services
• Extensive Knowledge on MSBI stack like Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS) and Data - visualization tools like Power BI, Power Pivot and Tableau
• Excellent understanding of Relational Database Systems, Normalization, De-normalization, Conceptual, logical and physical data modeling.
• Excellent knowledge in Installing of SQL SERVER enterprise edition using GUI or Command line installation or by configuration file
• Excellent knowledge in Creating Databases, Tables, Relation between tables, DDL/DML Triggers, Stored Procedures, Views, User Defined Functions, User defined data types, Cursors and Indexes using T-SQL.
• Good hands-on experience in using all kinds of SQL Server Constraints, Writing Transact SQL (T-SQL) Queries & Dynamic-T-SQL queries.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Expert in data Extracting, Transforming and Loading (ETL) process using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Designed high level SSIS architecture for overall data transfer from the source servers to the EDW
• Expert in creating ETL framework for Parent-Child or Successor-Predecessor or Parallel Processing methods.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like SQL Server, Excel, CSV, Oracle, flat file, Text file, Teradata, Sybase by using multiple transformations provided by SSIS
• Experience in migrating DTS Packages from 2000 to 2005, 2000 to 2008.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations.
• Experience in Creating and Maintaining Event Handlers, Package Configurations, Logging (Custom/Out-Of-Box), System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Implemented dynamic SSIS package creation using Business Intelligence Markup Language (BIML).
• Experience in handling Slowly Changing Dimensions while loading data into data warehouse. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive experience in creating several different professional reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up Advanced functions, dashboard, Drill-Trough / Drill-Down, KPI/Indicators, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Experience in developing custom reports and deploying them on Report server or SharePoint Server using SSRS and Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions and Security Content on the reports. Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
• Extensive experience in creating SSRS Reports on MDX Cubes developed in SSAS using MS SQL Server 2008/2012.
• Experience in creating and deploying the Tabular model into SSAS to consume it in power BI/Power Pivot and used DAX functions for the creation of calculations and measures in the Tabular Mode.
• Experience in Multi-Dimensional Modeling and involved in creation of Star and Snowflake dimensional cubes, Dimensions, Facts using SSAS and Deploying and Processing SSAS objects. Expert in creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Experience in doing Forward/Reverse Engineering and creating logical Data Model to a Physical Data Model on the actual SQL Server database and also have experience in doing Reverse Engineering with the help of ERwin tool.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in collecting data feeds from Social e-Commerce sites like Twitter and Facebook using TaskFactory and from Salesforce using Data loader.
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.

TECHNICAL SKILLS:

Languages: T-SQL, MDX, DAX, PL/SQL, C#, C, Power Shell, COBOL

RDBMS: SQL Server 2014, 2012, 2008, Oracle10g, 11g, Sybase, MS-Access, DB2.

Version Controlling Tools: Team Foundation Server(TFS), Serena PVCS Version Manager, Tortoise SVN

SQL Server Tools: SQL Server Management Studio(SSMS), SQL Server Configuration Manager, Business Intelligence Development Studio(BIDS), SSDT, SSIS, SSRS, SSAS, BIML, Data Transformation Services(DTS), Data Quality Services(DQS), Master Data Services(MDS), Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SharePoint Server

Data Modeling Tool: ERWIN 4.0,\7.2,Visio 2003\2010

Report/Data Visualization Tools: SSRS, Power BI, Power Pivot, Tableau

Operating System: Windows 2000, Windows Server 2012/2012R2/2008R2/2008/2003, Windows NT, Windows 95/98/2000 XP/Vista/7/10

Methodologies: Logical and Physical Database Design, Multi-Dimensional Model using Star Schema and Snow Flake Model, Tabular Model, UML, Database Design, ETL-Framework and Normalization

Scheduling Tools: SQL Server Agent, Control-M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, VA

Senior SQL Server DWH/BI Developer

Responsibilities:

• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Design, Development and Implementation. Knowledge on SCRUM/AGILE development methodologies.
• Gathering business requirements from business team; providing technical specifications for customizations/ implementations using Microsoft SQL Server Management Studio and Microsoft SQL Server Data tools.
• Creating and developing Databases and database objects like Tables, Stored Procedures, Functions, DDL/DML Triggers, Indexes, User defined data types, Cursors and Views using T-SQL using T-SQL and deploying them in to different environments like Development, System Integration, UAT & production using SQL Server 2014.
• Writing complex SQL statements using joins, subqueries and correlated sub queries and Following Normalization and De-Normalization process while creating the tables to make quick Write and Read.
• Designing and developing an execution ETL framework using SQL Server that process all the loans into DWH and from DWH to Downstream applications using SQL Agent. Designed to run either in batch mode or sequentially and load the batch statistics into SQL Server tables.
• Designing and developing SSIS (ETL) packages to validate, extract, transform and load data from Cassiopeia to LOP Datawarehouse and then from LOP Datawarehouse to downstream applications like EIS, LAPRO, REPO using SSIS.
• Worked with Data Analysts in completing the ICD (Interface Control Document) by converting the Business rules into Extract and transformation rules and Load into downstream applications using SSIS.
• Creating SSIS packages to pull the data feeds from linked servers (Oracle/ Sybase) and load data into Sybase servers
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Script Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column. Designing incremental load packages using CDC Control Task, CDC Source and CDC Splitter.
• Creating Data Profile documents to analyses source systems using SSIS Data profiler task and SQL Server Data Profiler.
• Creating Scheduled Jobs using SQL Agent to call the packages and Stored Procedures and configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Configuring SSIS Custom Logging and Error handling process for all the packages.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators, linked reports, sub reports, Matrix Reports & Chart reports using Microsoft SQL Server 2014 Reporting Services (SSRS) and publish them to users in online thru Report Server and SharePoint server. Creating different professional reports, utilizing Dynamic & Cascading Prompts, sub-reports, charts, dynamic parameterized and conditional reports.
• Creating complex Stored Procedures for better performance to generate reports.
• Creating SSAS Cube from POC phase to Production phase which involves in collecting requirements from Business Team, coming up with solutions and ways of implementing these features with in context of cube attributes, drill-through actions, reporting actions, mdx calculations or alternatively native reporting features residing on SSRS reports or figuring other ways of satisfying the client reporting need and presenting it to client.
• Provided guidance in showing tabular approach to the same POC and helping client in evaluating alternatives of varying development/deployment options possible with 2014 MSBI technologies.
• Experience in creating and deploying the Tabular model into SSAS to consume it in Power BI/Power Pivot and used DAX functions for the creation of calculations and measures in the Tabular Mode.
• Experience in Multi-Dimensional Modeling and involved in creation of Star and Snowflake dimensional cubes, Dimensions, Facts using SSAS and Deploying and Processing SSAS objects. Expert in creating calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Troubleshooting performance issues, fine-tuning queries & stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard to improve the performance and implement the best practices.
• Used TFS-Team Foundation Server for Version Controlling.
• Schedule Jobs daily/weekly/monthly using SQL Agent /Control-M to call the packages, Stored Procedures, Reports and Cubes and configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Implementing agile project methodology to provide estimations for each Sprint, and present status, highlight and discuss if any road blocks in Scrum meetings.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs SIT, UAT, Data Reconciliation and validation.

Environment: MS SQL Server-2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, DAX, MDX, Multi-Dimensional Model, Tabular Model, Power BI, Power Pivot, Visual Studio 2013,SharePoint 2013, TFS-Team Foundation Server Version Manager, ER-Studio, SQL Agent, Razor SQL, Office-2013, MS Excel, Cassiopeia Financials

Senior SQL Server ETL/DWH Developer

Responsibilities:

• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Design, Development and Implementation. Knowledge on SCRUM/AGILE development methodologies.
• Involved in gathering the reports used by the Business teams and breaking down the reports into smaller granular items as Columns.
• Identifying similar set of business and non-business Columns and grouping them together to create tables.
• Following Normalization and De-Normalization process while creating the tables to make quick Write and Read.
• Creating database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and in System Integration environment using SQL Server 2014.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Designing and developed SSIS (ETL) packages to validate, extract, transform and load data from Data Sources to the data warehouse.
• Creating SSIS packages to pull the data feeds from linked servers (Oracle/DB2), Twitter and Facebook as sources using TaskFactory.
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Script Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Creating Scheduled Jobs using Autosys to call the packages and Stored Procedures and configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Configuring SSIS Error handling process for all the packages using TaskFactory.
• Mapping the data elements from Encompass360 to Reporting database (EncompassRpt) and then from EncompassRpt to Datawarehouse.
• Generating all types of report formats including matrix reports, drill down, drill through, sub reports, multi parameterized reports, Chart reports, Map reports using Microsoft SQL Server 2014 Reporting Services (SSRS).
• Creating complex Stored Procedures for better performance to generate reports.
• Creating test cases in Encompass360 for testing the created Stored Procedures, SSIS packages and SSRS reports.
• Testing reports by connecting Datawarehouse through excel and querying the tables using excel.
• Used TFS-Team Foundation Server for Version Controlling.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Revisit the created production objects to improve the performance and implement the best practices.
• Providing 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule.

Environment: MS SQL Server-2014 Enterprise Edition, SSIS, SSRS, T-SQL, SSDT, Tableau, Ellie-Mae Encompass360, Ellie-Mae Encompass Reporting Database, TFS-Team Foundation Server Version Manager, TaskFactory, Autosys Scheduler, Office-2013, MS Excel

Senior SQL Server ETL/BI Developer

Responsibilities:

• Involve in complete SDLC requirement like analysis, design, development and testing the user stories.
• Created tables and database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and QA environment for SQL Server 2014.
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Created trace files on the queries and optimized the queries which were running slowly
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created SSIS packages to extract data from different systems and Scheduled Jobs using SQL Agent to call the packages and Stored Procedures.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Involved in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Created reports using Microsoft SQL Server 2014 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and deployed on report server.
• Generated all types of report formats including matrix reports, drill down, drill through, sub reports, multi parameterized reports, Chart reports, Map reports.
• Created complex Stored Procedures for better performance to generate reports.
• Developed AdHoc SSRS reports for the users for analysis purpose.
• Created test cases in Avattar for testing the created Stored Procedures, SSIS packages, SSRS reports
• Used TFS-Team Foundation Server for Version Controlling.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Revisit the created production objects to improve the performance and implement the best practices.
• Implemented agile project methodology to provide estimations for each Sprint, and present status and highlight if any road blocks in Scrum meetings.

Environment: MS SQL Server-2014 Enterprise Edition, SSIS, SSRS, T-SQL, SQL Server Agent, JIRA, Database Engine Tuning Advisor, SQL Profiler, Avattar, TFS-Team Foundation Server Version Manager, Office-2013, MS Excel

SQL Server ETL/BI Developer /Production Support

Responsibilities:

• Involve in complete SDLC requirement from analysis, design, development and testing the user stories.
• Involved in Installing of SQL SERVER enterprise edition using GUI or Command line installation or by configuration file and created automatic batch file for further installations.
• Created tables and database objects like Procedures, Functions, Packages, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created SSIS packages to extract data from different systems and Scheduled Jobs using SQL Agent/Control-M to call the packages and Stored Procedures.
• Worked extensively with SSIS transformations such as lookup, Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Designed incremental load packages with the help of CDC Control Task, CDC Source and CDC Splitter
• Configured SQL mail agent for sending automatic emails when a SSIS packages are failed or succeed.
• Involved in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Created several different professional reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports. Set up Advanced functions, dashboard, Drill-Trough / Drill-Down, KPI/Indicators, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services
• Created complex Stored Procedures for better performance to generate reports.
• Developed AdHoc SSRS reports for the users for analysis purpose
• Used Serena PVCS-Version Manager for Version Controlling.
• Worked as a 24 X 7 Production support on-call person for the SQL Server/Oracle/DB2 applications.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Revisit the created production objects to improve the performance and implement the best practices.
• Implemented agile project methodology to provide estimations for each Sprint, and present status and highlight if any road blocks in Scrum meetings.

Environment: MS SQL Server-2012 Enterprise Edition, SSIS, SSRS, T-SQL, SQL Profiler, PowerShell, Control-M, Serena PVCS-Version Manager, Office-2010, MS Excel, SQL Server Agent, IBM ClearQuest

SQL Server BI Developer

Responsibilities:

• Experience in Creating simple to complex queries involving Joins, Correlated Subqueries and Stored Procedures as per business requirements.
• Active participation in and gathering requirements from workgroup meetings and making changes to existing logic as per business requirements.
• Experienced in Analyzing the Data that is stored form the UI into the databases. Creating a detailed report using MS Excel.
• Experienced in Creating, loading, and modifying a new package or an existing package or add and configure components, making changes object by using Control Flow and Data Flow Tools and then verifying it. .
• Wrote the ETL scripts to load the data into database from various source files.
• Worked extensively with SSIS transformations such as lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail task.
• Created new tables, Constraints, altered the existing table-columns for the process of ICD conversion.
• Updated master ICD lookup table by modifying existing codes or adding new codes with the help of SCD of type 2(Historical attribute with date)
• Created new reports and updated the existing reports to take new ICD 10 codes which help in understanding the trends and performance of entities depending on Time and Area granularities.
• Created sample reports in SFDC(SalesforceDotcom) to test the ICD10 changes.
• Integrated and validated changes to upstream and downstream applications to receive/send the feed having ICD10 codes with the help of SSIS data transfer and FTP packages.
• Participated in data testing for sales portal application to make sure these ICD10 codes reflect to all entities that are eligible to diagnose.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Involved in Unit Testing and Integration testing in SSIS, SSRS
• Involved in the continuous enhancements and fixing of production problems.
• Monitored SQL and fine-tuned the queries on a case by case basis.

Environment: SQL Server 2008 R2, SSIS, SSRS, T-SQL, Visual studio 2005/2008, Salesforce, Data Loader, Tortoise SVN, SQL Profiler, Office-2010, MS Excel, SQL Server Agent, HPSM.

Mid-Level SQL Server ETL/BI /DWH Developer

Responsibilities:

• Core member of project team who worked in all stages of the project, from requirement gathering to production which includes deployment, defining requirements, project planning, development, testing, and production implementation.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Defaults and complex SQL statements
• Developed standards and guidelines to maintain and develop SSIS packages and Data Flow Diagrams
• Created SSIS packages and automated jobs to monitor, backup, import/export data to INFO-Factory data warehouse from PARIS ODS.
• Worked on Performance optimization of the SSIS packages that are built to load large flat files to the database tables.
• Implemented parallel processing in SSIS packages to reduce the package run time.
• Created Data Modeling, Multi-Dimensional Modeling & created Star Schema and Snowflake dimensional schema using ERwin tool.
• Transformed a Logical Data Model from ERwin Data Modeler to a Physical Data Model on the actual SQL Server database and also did ERwin Forward Engineering/reverse Engineering
• Developed complex stored procedures and functions to extract the data.
• Managed Linked Servers to transfer data between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Developed, and scheduled variety of reports like Parameterized reports, Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals, List, Matrix and Sub Reports with in SSRS 2008.
• Created SSRS reports using stored procedure. Involved in scheduling, creating snapshot and subscription for these reports.
• Acted as single point of contact for support of SSIS packages in production. Collaborated with external teams and partners to resolve production issues
• Designed and worked with cubes having star schema, Snow flake schema for future and current reporting using SQL server Analysis Services (SSAS).
• Created MDX queries, processed facts, dimensions and populated data through Analysis Services (SSAS) into SSRS Reports
• Manage and schedule SQL Agent jobs to import and export terabytes of data to external data warehouse from Mainframe systems
• Promoted database objects to development, test, and production environments Played Key role SQL Developer in building Enterprise Data Warehouse
• Extensively worked in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Database Engine Tuning Advisor.

Environment: SQL Server 2008/2008r2, T-SQL, SSIS, SSRS, Data Transformation Services (DTS), IBM-Lotus Notes, Query Analyzer, Control-M, PowerShell, SQL Profiler Enterprise Manager (SEM), Microsoft BI Studio 2008

Jr SQL Server BI Developer

Responsibilities:

• Supported development team to launch their new web based product called ALCHEMIS, which includes online download of data from their stations located all over the Germany. Worked as a Jr. SQL Server Database Developer.
• Responsibilities:
• Involved in planning, defining and designing data based on business requirement and provided documentation for further reference.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Designed ETL packages for extracting the data and load into the appropriate tables in the database using SQL Server Integration Services (SSIS).
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Created simple stored procedures and functions to support efficient data storage and manipulation.
• Monitored the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Monitored the performance of SQL Server using SQL Server Profiler.
• Worked with Application Teams on creating a productive Development, Test and Production environment for Application Databases.
• Helped in designing and developing the database using normalization techniques.

Environment: SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Integration Services (SSIS), Query Analyzer, Enterprise Manager, Business Intelligence Development Studio