SUMMARY

• Almost 10 years total experience within the IT industry as an expert Business Intelligence developer (SQL/SSIS/SSRS/SSAS) in Product development, Application Development, and Data Warehousing.
• Expert in T - SQL query development skills, advanced performance tuning and query optimization.
• Almost 10 years of Data Analysis experience in various domains like Financial, Healthcare, Retail, Mortgage, Communications and Insurance etc.
• Created various ETL applications using SSIS to load the data from different sources, transform the data according to the business logic and load into different destinations.
• Worked in various data migration projects.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Expertise in developing ETL applications using SSIS.
• Strong in Data warehousing, Operations Data Store concepts, data marts.
• Worked on the entire software development life cycle (SDLC) including analysis, design, programming, testing and documentation.
• Strong MS SQL Server 2014/2012/2008/2008 R2 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Thorough understanding of the Software Development Life Cycle (SDLC), involved in various phases such as requirements, analysis/design, development and testing.
• Experienced in Business case development and presentations for senior Leadership.

TECHNICAL SKILLS

• SQL Server/T - SQL
• SSIS Packages /Lavastorm/Informatica for ETL.
• SSRS Reports.
• SSAS Cubes.
• Data Modeling (ER Studio, Erwin).
• Oracle, MySQL, PostgreSQL.
• R Programming, Python, Statistics for Data Science.
• C#, VB, Java, JSP, HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential

SSIS/T-SQL Developer

Responsibilities:

• Loading Source Data from Oracle into SQL Tables to load into Microsoft AX.
• Fetch the Source data from Oracle, perform data cleansing, transformation before loading into the final destination tables.
• Created SSIS Packages for each entity that includes Customer Bank Account, Vendor Bank Account, Subscription billing, Sales Partner etc.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

Confidential

SSIS/T-SQL /Oracle-PLSQL/Python/SSRS

Responsibilities:

• Loading Data from Claims which is in Oracle, convert into Acord XML and do incremental load into IEV XTM database. Making sure the data goes smoothly from XTM database into TDS and from TDS into ODS.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Loading the accord xml from the Oracle CA into IEV XTM using script task (C#.NET).
• Extracting Data from AS400 and loading into Sapiens using SSIS Package.
• Extracting Data from Claims and loading into Sapiens using SSIS Package.
• Create SSIS Package according to the business requirement to process claims and policy information into Sapiens database.
• Created SSIS package to find exceptions after loading claims and wins file into SSIS, then email the file to different team members of Sapiens team.
• Worked extensively on Data Analysis to solve the bugs created by business Analysts when they see the data is wrong.
• Extract the policy data, claims data from many sources like Flat files, Excel/CSV files, different relational Databases like Oracle, SQL Server etc. and load into different destinations for analyzing the data, finding trends and insights for the Client organization.
• Worked with Data Scientists and learnt Data science hands on from senior Data Scientists of the company.

Confidential

T-SQL/SSIS Developer

Responsibilities:

• Involved in the design and development of ACCME SSIS Package that loads Addition/Modification/Deletion of Modules and the information we receive from ACCME.
• Created Stored procedures to replace legacy application with Oracle PL/SQL and T-SQL Stored Procedures.
• Involved in the design and development of LDDANS SSIS Package for loading Dans Data into Oracle Database from Confidential portal.
• Involved in the modification of other SSIS Packages like LDABMS, AMA etc.
• Guided the scrum team for the successful completion of many projects.
• Involved in the performance tuning of SQL stored procedures, SSIS Packages etc.
• Involved in analyzing the data, and fix the code when the data doesn’t match the business requirement.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned T-SQL statements Using Indexes and stored procedures.