SUMMARY:

• 9+ years’ experience in Business Intelligence & Data Warehousing working in roles such as ETL Lead, ETL architect, Business Analyst, Data Analyst.
• Extensively worked on a wide range of tools such as Informatica power center (9.x), Informatica DVO, Business objects, SSIS, PL/SQL, UNIX Shell scripting, ER Studio.
• Has strong relational Database concepts and worked on Oracle 10g, Teradata, MS SQL Server (2000,2005,2005), and MS Access while implementing many challenging DWH solutions for Confidential.
• Extensive professional Information Technology experience with expertise in the field of Enterprise Data Warehousing, Data Integration, and Data/Code Migration.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Expertise in performing Unit Testing, Integration Testing and Regression Testing.
• Knowledge with SQL Developer and SQL Navigator, Teradata utilities (SQL, BTEQ, Fast Load, Multi Load, Tpump), SQL Server Management to test, modify and analyze data, create indexes, and compare data from different schemas.
• Expertise in OLTP & OLAP systems, data marts, ODS, enterprise DWH, relational and dimensional modeling.
• Strong analytical and problem solving abilities, excellent communication, a team player, good coordination skills and had 100% successful and defect - free delivery record for all the projects deployed till date.

TECHNICAL SKILLS:

Domain Knowledge: Commercial Finance

Databases: Teradata, Oracle10g, SQL-Server2000, SQL-Server2005SQL-Server2008, MS-SQL Server, MS Access

Operating Systems: Windows 2000 Server, Windows XP

Languages: SQL, Shell Script, PL/SQL

Scripting Languages: Unix Shell Script, Bteq

Tools: Informatica power center, DVO, SQL management studio, SSIS, Citrix, Putty, Appworx, SQL Developer, Star Team, HP quality center, Citrix

Reporting Tools: Business Objects, Tableau, SSRS

PROFESSIONAL EXPERIENCE:

Confidential

Reporting Developer - Assistant Consultant, Thousand oaks, CA

Responsibilities:

• Working as a SSRS report developer.
• Developed reporting application using SQL Server Reporting Services SSRS by reverse engineering process using the sample PDF reports available from old system.
• Developed one parameterized report for 37 unit operations.
• Configured Linked Server connection from SQL Server to Oracle source database.
• Created few stored procedures for report parameterization & dynamic SQL generation.
• Used Open query for linked server better performance.

Technical Architect - ETL Lead, Norwalk, Connecticut

Confidential

Responsibilities:

• Involved in the architecture of a risk module by understanding data in the source systems & devised a solution to cater to FDIC compliance requirements. Managed & mentored a team of 10-12 members.
• Involved in gathering requirements, Client interactions and Developing Informatica mappings, Bteqs, Unix Shell scripts which will apply all business logic and load the data into Database.
• Building Informatica Workflows using Informatica client Tools. Developed Mapping using transformation like Aggregator, Update Strategy, Lookups, Source Qualifier, Joiner, Union, Expression Source/Target Definitions and complex SQL Queries.
• Performance tuning of the mappings as well as the tuning of SQL queries for better performance.
• Worked on preparing test cases for component testing, Supporting Testing Team. Prepared the transformation matrix for future reference. Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
• During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
• Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed Informatica Mappings.
• Mentoring team members in resolving day to day technical issues. Code Review including code optimization.
• Automated 25+ businesses loading process to load through a common framework which reduced the run time by 70%.

ETL Developer/Module Lead - IT Analyst, Danbury, Connecticut

Confidential

Responsibilities:

• Understand the project requirements & to Co-ordinate with various projects and help business and other users for Data conversion and retention.
• Understand the old reports, working with business for any changes required in the report, preparing documents and plan for the project execution.
• Developed mappings & automated the process using appworx tool.
• Built reusable transformations and mapplets to use in multiple mappings.
• Hands on experience using mapping variables, mapping parameters, workflow variables and session parameters.
• Preparing Unit Test cases for Unit Testing and assisted with QA team and UAT team for providing development support.
• During the UAT, interacted directly with business stakeholders, provided clarifications for their questions on the data and use cases
• Assisted UAT team and QA team in coming up with validation scripts to perform the validations as expected to cover all scenarios.

Developer - Assistant System Engineer

Confidential

Responsibilities:

• Responsible for requirement gathering from business users and GE.
• Implementation of the changes, Impact Analysis, Unit and System Testing & release of elements into production Environment.
• Was the only resource for one module which required both Mainframe & SQL skills to extract data using mainframe jobs & loading to SQL database using DTS package.
• Was involved in SQL migration from SQL 2000 to SQL 2005 & SQL 2008. Converting DTS packages to SSIS was a big challenge because of customer’s immediate requirement.