SUMMARY:

• Business Intelligence Consultant with more than 10 years of experience in IT, primarily in data warehousing and BI projects
• Expert experience in designing, implementing End to End BI solutions on Microsoft Business Intelligence Suite (SSIS, SSRS and SSAS)
• MSBI ETL Architect determining the optimal approach for obtaining data from diverse source system platforms and moving it to the BI
• Good knowledge in Design of data marts using the Ralph Kimball’s Dimensional Data modeling techniques.
• Experience in Data Profiling & Data Analysis in a DW environment.
• Involved in designing and development of Relational Databases and Multidimensional Cubes (SSAS)
• Experience in leading teams of technical resources from Onsite/Offshore, Onsite Lead and participated in effort estimation, project planning and team planning activities
• Worked in various domain like Health Insurance, Insurance (General Insurance) and Information
• Ability to identify the solution needs by transforming them into appropriate and balanced technical solutions
• Extensive knowledge in tuning T - SQL queries to improve the database performance and availability. Good experience in using performance monitor, SQL profiler and optimizing the queries to solve dead locks and long running queries
• Expert in designing, development of SQL Server Integration Services (SSIS) packages. Experience in creating jobs, alerts and scheduling SSIS packages using SQL Server Agent
• Experience in SQL Server 2014 In-Memory concepts and ETL processes
• Good experience in developing various types of complex reports like reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on requirements
• Experience in developing, implementing strategies with self-service tools with the help of SQL Server Integration services, Reporting Services and Analytic Services (SSIS, SSRS, and SSAS) to allow end users to access and analyze data to provide useful information for business decisions
• Expertise in scheduling, monitoring jobs in Tivoli Work Scheduler (TWS) and Electronics Communications Gateway (ECG), Axway agent - secure file transfer service
• A well-organized, goal-oriented, highly-motivated effective member/team leader with excellent analytical, troubleshooting, and problem solving skills
• Knowledge in Big Data platform fundamentals, Hadoop, Hive, NoSQL, DaaS, Pig and HBase through self-learning/training.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2014/2012/2008 R2

Designer: MS Visio

Database Technologies/BI Tools: SSIS, SSRS, SSAS, Performance Point Server (PPS), Power Pivot

Job Scheduling: Tivoli Work Scheduler (TWS), SQL Agent

File Transfer Service: Electronics Communications Gateway (ECG), WinSCP/ SSH File Transfer Protocol

Source Control: Team Foundation Server, SVN

Languages/Scripting: SQL, MDX, Java Script, VB Script

Web Technologies: HTML, ASP, XML, XSL, XSLT

Operating Systems: Windows Server 2012, Windows Server 2008, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Optum, Minnesota

Lead ETL Developer, BI Developer, Data Analyst (Data Analytics Developer)

Responsibilities:

• Extensive data analysis and writing complex SQL scripts
• Designing and preparing mapping (STM) for the new requirements
• Designing the ETL jobs to extract the data from scanners or the source files from different downstream applications
• Creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism
• Implementing an unique framework for the error handling and logging mechanism
• Creating an unique tools to validate the source file formats and definitions in the common format defined for the consumption
• Building the reports and dashboards to report on vulnerability risks, remediation charts and trend reports
• Creating tools, writing procedures to check the data quality of different subject areas

MSBI ETL Architect / Lead BI Developer / Data Analyst (Senior Systems Analyst)

Responsibilities:

• ETL & Cube Developer/Lead for offshore resources (including Web/BizTalk)
• Defining DWBI strategies, operations for new processes
• Data analysis, Data elements mapping and Dimensional modeling
• Designing, Developing and maintaining the Cubes
• Extensive data analysis and writing complex SQL/MDX queries
• Performance tuning and rewriting of queries to improve the performance
• Analyzing/increasing the performance of SSIS jobs using various techniques and SQL Server monitoring tools

BI Consultant, ETL Architect, Lead BI Developer, Data Analyst, Data Modeler (Senior Systems Analyst)

Responsibilities:

• ETL Senior Developer/Lead for the programs named HealthCare Economics, DataRap, Sampson and EODS in Collaborative Care
• Developing ETL jobs for Provider, Member, Medical Claims, Rx Claims, Lab and Supplemental data
• Data analysis, Data elements mapping and Dimensional modeling for various projects with in Collaborative Care
• Defining standards and best practices for ETL and reporting
• Extensively worked on Informatica PowerCenter 8.1 as an ETL tool to Extract
• Creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism
• Developed several mappings in Informatica by using the transformations like Unconnected and Connected lookups, Source Qualifier, Expression, Router, Filter, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Rank, Sorter, Normalizer, Transaction Control etc.
• Designing/Rewriting the ETL jobs in SQL Server 2014 In-Memory concepts to generate source files for different downstream applications
• Implementing an unique framework named - Process Improvement Management (PIM) for error handling and logging mechanism
• Extensive data analysis and writing complex SQL scripts
• Performance tuning and rewriting of queries to improve the performance
• Analyzing/increasing the performance of SSIS jobs using various techniques and SQL Server monitoring tools
• Developing ad-hoc/canned reports for Product Group Reports (PGR), Hospital Information Reports (HIR)
• Creating dashboards for Hospital Information Reports (HIR) by using PPS and Power Pivot
• Developing ad-hoc/canned reports for Product Group Reports (PGR), Hospital Information Reports (HIR)

Senior Database Developer, Senior CRM Developer (Delivery Senior Software Engineer)

Responsibilities:

• Requirement Analysis, Designing, Integration Testing, Coding, Deployment and Production support
• Data analysis, designing and preparing mapping (S2T) for the new requirements
• Data modelling and creating database objects - tables, indexes, stored procedures, functions and views
• Rewriting the stored procedures with additional data elements to improve data quality
• Tuning database indexes, stored procedures and to improve performance
• Creating tools, writing procedures to check the data quality of different subject areas
• Integration testing, Release coordination and Production support from on-site (Seoul, South Korea)