SUMMARY

• Around 8 years of strong IT experience in Database Design, Development and business intelligence of MS SQL Server 2014/2012/2008 R2/2005 with various business domains like Banking, Finance, Insurance and Health care.
• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies.
• Experience of Scrum, Agile Software Development projects and Waterfall projects.
• Good knowledge of Property & Casualty (auto, home, liability) and Healthcare Insurance domain.
• Exceptional hands on working knowledge with SQL ServerIntegration Services(SSIS), SQL Server Analysis Services (SSAS) andSQL ServerReporting Services(SSRS).
• Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, using Informatica 9.x, Oracle 11g/10g, DB2, SQL Server, Teradata, PL/SQL, and well versed with Data Warehousing Architecture Technology, Operational Data Store, and Dimensional Data Modeling.
• Very good knowledge in scheduling and deploying reports on report manger.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience with SSRS MDX and DAX scripting.
• Good knowledge of Operational and summary reporting framework design and development(MDX, DAX, SSRS, ProClarity, Crystal Reports)
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER.
• Experience inenhancing and deploying the SSIS Packagesfromdevelopment server to test and production server.
• Good Hands on experience resolving issues and error handling inSSIS.
• Experience with creating and dropping cluster index and non - cluster indexes on tables.
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSISservices.
• Good knowledge of MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Expert in T-SQL scripts, dynamic SQL, stored procedures, functions, triggers and SQLCMD.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Data Modeling: Data Modeling experience using Dimensional Data modeling, Star Schema, Snow-Flake Schema, FACT and Dimension tables, Physical and logical data modeling, and Erwin 4.1.4.

Databases: Oracle 9i/10g/11g, MS-Access, DB2, MS SQL Server, Teradata, MySQL

Programming: SQL, T-SQL, PL/SQL

Domain Knowledge: Banking, Insurance, Healthcare, Finance, Spend Data Analysis, Sales and Warranty Analysis

Environment: Windows 98/NT/XP, Windows 7 Professional

Miscellaneous: MS Office, SVN, Visio, Hyperion, Toad and exposure to Control M, Business Objects and Tableau

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQL Application developer

Responsibilities:

• Create entire new applications to generate required data fields as per client requirements and support existing applications and modify them as per requirements.
• Create Business - Crucial stored procedures and functions to support efficient data storage and manipulation.
• Involve in requirement gathering process with clients and work on the requirements from developing code to unit testing and moving it to test server.
• Involve in the whole encounter submission process with different clients to fulfill different requirements.
• Modify existing encounter submission processes as per new configurations provided by the clients.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Extract, Transform and Load source data into respective target tables to build the required data files.
• Understand user requirements and Data Model defined and developed by the business analysts.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Created Stored Procedures, Indexes, and Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSISservices.
• Create packages inSSISwith error handling.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files etc.) and then loaded the data into destination tables by performing different kinds of transformations usingSSISpackages.
• Perform Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Filter data from Transient Stage to destination tables by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions.
• Created Stored Procedures, Functions, Indexes, and Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Use some data conversion tasks inSSISto load the data from flat file to SQL Server database.
• Perform MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity and Query Optimization.
• Develop, monitor and deploy SSISpackages.
• Create ETLSSISpackages both design and code to process data to target databases.
• Create document for Self-Service Deployment and Execution process forSSISpackages.
• Perform unit and system testing, troubleshooting and bug fixing in development, QA and Prod environments.

Environment: SQL Server 2014, Windows Server, SVN, EDS, SSIS, SSRS, Excel, T-SQL

Confidential, Boston, MA

ETL/MSBI developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Created Business - Crucial stored procedures and functions to support efficient data storage and manipulation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSISservices.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Deep experience with the design and development of Tableau visualization solutions.
• Experience in development of Reports and Dashboard in Tableau.
• Hands on Experience in development of Reports and Dashboard in Tableau.
• Created packages inSSISwith error handling.
• Worked with different methods of logging inSSIS.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Filter data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Use some data conversion tasks inSSISto load the data from flat file to SQL Server database.
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity and Query Optimization.
• Configure Report Server and Deployed SSRS Reports, Report Models, Shared Data Sources to the Document Library of SharePoint.
• Used Informatica Power Center to create mappings for extracting data from various systems.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping s run process.
• Developed several mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer.
• Developed, monitor and deploy SSISpackages.
• Created ETLSSISpackages both design and code to process data to target databases.
• Created document for Self-Service Deployment and Execution process forSSISpackages.
• Worked on SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2008 R2/2012, Windows Server, ProClarity/PPS, EDW, ODS, EDS, SSIS, SSAS,SSRS, Excel, T-SQL, PL/SQL, Team foundation server(TFS), Informatica Power Center 9.5.1, Informatica Power Exchange 9.5.1

Confidential, Houston, TX

MSBI/ETL Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL).
• Extracted and Transformed data into Staging Servers named as P Staging Server for historical data and T Staging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Hands on Experience in development of Reports and Dashboard in Tableau.
• Designed, developed and implemented Tableau Business Intelligence reports.
• CreatedSSISpackages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by everySSISpackage that executes.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 R2 asSSISPackages.
• 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 different kinds of transformations usingSSISpackages.
• Used For - Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: SQL Server 2008 R2/2005, Windows Server, SSIS, SSRS and TFS, ProClarity/PPS, EDW, ODS, EDW, SVN

Confidential, San Francisco, CA

ETL(Data warehouse) Developer

Responsibilities:

• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Created Stored Procedures, Functions, Indexes, Tables, Views and other T - SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process usingSSISto transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and MaintainingSSISpackages.
• Responsible for gathering business requirements to create business user reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: Windows Server 2003, SQL Server 2008 R2/2005, SSIS, SSAS, SSRS, ProClarity/PPS, EDW, ODS, SVN

Confidential

SSIS/SSRS Developer

Responsibilities:

• Worked on all activities related to the development, implementation and support of ETL processes for large - scale Data Warehouses usingSSISand DTS.
• CreatedSSISprocess design architecting the flow of data from various sources to target.
• UsedSSISto create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• CreatedSSISTemplates for developingSSISPackages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle usingSSIS.
• Created ETLSSISpackages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSRS, ProClarity/PPS, EDW, ODS

Confidential

Jr. SQL Server Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Optimizing Database Queries for performance enhancements and Writing T - SQL Views and triggers.
• Worked to tune the SQL queries using SQL Profiler.
• Created new simple stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process usingSSISto transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and MaintainingSSISpackages.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: Windows Server 2003, SQL Server 2005, BI studio 2005, SSIS, SSRS, Microsoft windows XP