SUMMARY

• 9.5 years of IT experience focusing on Data warehousing, Data integration, Data Migration, Data analysis, ETL pro­cess and Business Intelligence. Well versed in concepts and has significant experience and practical knowledge of working in ETL Development using SSIS, Informatica, SQL SERVER Development and Report Development using SSRS.
• Proficient in design and development of customized ETL/BI solutions for clients. Experienced in support­ing the project release life cycle, working closely with development and production support teams. Focused on mid - size to large projects, employing working knowledge of SDLC, SCRUM and Agile methodolo­gies.
• Played a key role in requirements gathering, project documentations, application developments tasks and the translation of requirements for project teams both foreign and domestic. Have knowledge of entity-relationship/multidimensional modeling (star schema, snowflake schema)
• . Experienced in Data ware­housing end to end project implementation and Ap­plication management for BI project utilizing multiple tools. Excellent communication and organizational skills, technically competent and result-oriented, coupled with analytical, problem-solving abilities and ability to work independently.

TECHNICAL SKILLS

• Informatica 9.1/9.6
• SSIS (Microsoft SQL Server Integration Tool)
• Datastage
• SQL Server 2000/2005/2008/2012/2016
• Oracle
• SSRS (Microsoft SQL Server Reporting Tool)
• TOAD
• Oracle SQL Developer
• Team foundation Server
• SQL Server Profiler
• Microsoft Visual Studio
• Autosys
• ESP

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Data Analyst

Responsibilities:

Responsible for evaluating reporting analytics needs of various lines of business. Decomposed the current system and analyzed data transformations to map Business Key elements to physical data elements. Conducted workshops with report owners, documented reporting line item interpretations and calculations, defined terms, organized into business and technical definitions. Created a data dictionary with translated metadata information by report line item. Researched and analyzed dis­crepancies in the eligibility reconciliation process for different Authorized data sources and make sure required data elements are present and ties with general ledger. Organized data definitions for easy access.

Confidential, Charlotte

Senior ETL, SQL and Reporting Lead

Responsibilities:

Worked closely with Client and business team to gather and analyze requirements and come up with estimates. Responsible for preparing mapping documents, code review checklist and technical design documents for ETL and Reports. Designed and developed optimized ETL solution to load data from different types of sources to data warehouse. Generated various reports like parametrized, Cascading parameters, sub-reports, drill down, drill through using SQL Server Reporting Services (SSRS) and automated rendering of scheduled reports. Contributed in designing the databases, required tables and other related database objects like user defined functions stored procedure, writing and tuning SQL queries. Helped in building Logical and Physical data model. Built a process to tie data between different sources and provide a daily data quality check report to business team. In charge of setting up Informatica, Database and Reporting environments for testing and production deployment. Re­sponsible for code management and migrating to different environments. Responsible for unit, system testing and create test cases. Worked as deployment coordinator for production deployment. Main­tained data integrity by performing validation checks. Point of contact for all the ETL and Reporting related activities interfacing directly with clients and external project teams. Mentored/Lead team of 5 Developers.

Confidential, Chicago

Senior ETL, SQL and Report Developer

Responsibilities:

Led the ETL and Reporting team for the project to analyze and migrate applications from Datastage, OWB and Cognos to Microsoft Platform (SQL, SSIS and SSRS). Also designed and developed new ETL solution to load and transform policies data from 27 different countries data sources like Oracle, Excel, Flat files to a single data warehouse. Assisted in designing schema for new database. Analyzed stored procedures and function in Oracle environment and rewrote them in TSQL. Also replicated functionality implemented in UNIX for executing Datastage ETLs to scripts executing SSIS packages. Designed customized robust Avanade ETL Accelerator 4.1 framework for ETL packages which provides better logging and auditing mechanisms. Involved in tuning, testing and integrating the solution. In charge of deploying solution to different environments and automating the ETL Scheduling. Worked on Adhoc data requests for Clients. Provided maintenance support to legacy applications handling daily load issues. Organized and lead daily analysis and design sessions between the reporting team and the client (business side) and drove the reporting team through analysis, design, build and system test. Tuned the SQL queries for reports and ETLs for optimized results.

Confidential

Senior ETL and Report Developer

Responsibilities:

Involved in preparing proof of concepts to demonstrate SSIS and SSRS skills to the client. Docu­mented design and functional specification to identify the changes required from the current data flow/reporting system. Supported and managed various legacy systems/reporting applications for multiple clients.

Confidential

ETL, SQL and Report Developer

Responsibilities:

Developed the ETL packages with monitoring, re-startability and logging features so that audit informa­tion of the packages is captured properly. Performed incremental data load. Generated T-SQL Scripts to create database objects and wrote SQL queries to develop SSRS reports. Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing. Responsible for scheduling ETL packages using third party tool .Prepared mapping design and best practices documents.

Confidential

ETL and Report Developer

Responsibilities:

Focused on providing ON Call Support and maintenance to enterprise wide applications. Primary contact person for Support and enhancement for multiple applications. Handled critical job failures in the production environment with in the required time frame as defined in SLA. Provided permanent solutions for repetitive job failures by creating DWCR and working on root cause fixes. Developed new components as required. Conducted various knowledge transfer training sessions within the team.