SUMMARY

• About 7+ years of IT experience with Business Intelligence data integration, data migration, data quality, data profiling, data validation and Data Warehousing implementation across various industries.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like Informatica Power Center9.X/8.x/ 7.x
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Comprehensive technical, oral, written and communicational skills.
• Worked extensively with the Onsite-Offshore model, co-ordination with clients/users, understanding of client requirements, team management, mentoring of new resources coding batch and online programs, doing unit and integrated testing and successful releases of code in production environment.
• Exposure to complete SDLC (Software Development Life Cycle) involving User requirements study, Business requirement document, Application Design, Coding, Unit Testing & Integration Testing. Possess excellent technical, analytical & Problem solving skills.
• Worked on AGILE and Waterfall methodologies for software development.
• Sound analytical and problem solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to adapt and learn new technologies.
• Strong knowledge ofEntity-Relationship concept, Facts and dimensions tables, slowly changing dimensionsandDimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources likeOracle, DB2, SQL server and MS access andnon-relational sources likeflat filesinto staging area.
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of thePL/SQL triggers, stored procedures, functions, packages.
• Involved increating Test data, Unit testing, System testingto check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the Business users by conducting meetings with the clients in Requirements Analysis phase.
• Extensive functional and technical exposure. Experience working on high-visibility projects

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5/9.1/8.6 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SAP Business Objects4.0, Web Intelligence

Reporting Tools: Business Objects 4.0, Tableau, MS SQL Server Reporting services, Business Intelligence

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Visio

Databases: Oracle, SQL Server, DB2 UDB, My SQL, MS-Access.

Operating Systems: Windows95,98, 2000/XP/2007, IBM, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Business Intelligence /ETL Developer

Responsibilities:

• Responsible for Co-ordination with Business People, SME's, designing and Testing teams to avoid conflicts and to ensure smooth execution of project.
• Responsible for requirement gathering, Analysis and clarifications from respective stakeholders.
• Providing end to end testing support like Unit Testing, System Testing, Integration Testing, User Acceptance Testing and MAT.
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Created different transformations like Source Qualifier, Expression, Router, Filter, Lookup, Sequence Generator, Normalizer transformations for loading the data into the targets.
• Peer review of Code deliverable and Test script.
• Organizing daily scrum for the status update; keep an eye of the progress of the assigned task
• Analyze and extract data from different source systems, transform and load as per targeted Business requirements.
• Understood the Business point of view to implement coding using Informatica Power Center9.1/8.6.1
• Extensively used Informatica Power Center9.1/8.6.1 to create and manipulate source
• Developed data Models in HLD and LLD
• Developed data Models/Mappings between source systems and warehouse components.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates Business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, mappings and update processes.

Environment: Data Integration tools,Oracle, PL/SQL, Flat Files, XLS, XML, Windows.

Confidential, Warren NJ

ETL Developer

Responsibilities:

• Participated in design sessions where decisions are made involving the transformation from source to target.
• Developed new mappings for transforming data from source to target schema.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure, packages, and triggers.
• Managed and compile documentation for all ETL processes.
• Providing production support in fixing production issues in stringent timeframes.
• Creating detailed plans with solutions in identifying common production issues so that they don't re-occur.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and Business units in order to define the requirements
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Profile data using Informatica Analyst and created scorecards using IDQ rules.
• Developed data Mappings between source systems and warehouse components.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates Business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Environment: InformaticaPowerCenter9.5,Oracle, PL/SQL, Flat Files, MS Access, XML, Windows, Remedy, Synergy

Confidential, Dallas, TX

Business Intelligence /ETL Developer

Responsibilities:

• Involved Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica.
• Analyzed the source system and involved indesigning the ETL data load.
• Developed/designed Informatica mappingsby translating the Business requirements.
• Worked in various transformations like Lookup, Joiner, Sorter, Aggregator, Router, Rank and Source Qualifier to create complex mapping.
• Involved in performance tuning of the Informatica mappings using various components like Parameter Files, round robin and Key range partitioning to ensure source and target bottlenecks were removed.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Extensive SQL querying for Data Analysisand wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling.
• Extracted Business rule and implemented Business logic to extract and load.
• Worked with Teradata utilities like FastLoad and MultiLoad.
• Involved in automating retail prepaid system process. Created packages and dependencies of the processes.
• Extensively used Informatica PowerCenter 9.0.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Identified common issues in Established Dashboards and Business reports.
• Monitor & troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Tuned the mappingsby removing the Source/Target bottlenecks and Expressions to improve the throughput of the data loads.

Environment: Data Integration tools, Informatica Power Center9.1, Oracle 10g, PL/SQL, MS SQL Server,Business Objects, and Quality Center

Confidential, Warren NJ

Sr. Data Analyst/Modeler

Responsibilities:

• Developed and maintained technical documentation from Source to Target load process and ETL development.
• Created and used different sources, targets and transformations to create mappings to load the data into target systems using Informatica.
• Used most of transformations like Source Qualifier, Aggregator, Expression, Filter, Joiner, Router, Lookup, sorter, Update Strategy to load data into slowly changing Dimension.
• Optimize the performance of the queries.
• Used Sorter and Aggregator transformations in combination for performance tuning of aggregations used in the mappings.
• Developing the Informatica Mapping.
• Validating the mapping as per ETL specification.
• Developing the Session, Workflows and Worklets.
• Running, monitoring and scheduling the Workflows.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Business Objects, ETL Tools Informatica, Oracle

Confidential

ETL Consultant

Responsibilities:

• Prepared Documentation for the applications which should be migrated.
• Data validation, migration and loading data from CDW to ADW using Informatica, Oracle 10g, Control-M,UNIX shell scripts, PL/SQL packages and Harvest.
• Took the ownership of applications like PII, GAR, ECCS, PLIM and Symphony Datamart.
• Create and release packages which contain UNIX shell scripts and sql scripts through harvest to UNIX environments.
• Schedule and run the jobs through Control-m tool
• Created Unit Test case and done unit test.
• Giving support to client for UAT and Production.

Environment: Informatica 8.6, PL-SQL, CTRL-M & UNIX