SUMMARY

• 8+ years of Experience in Information Technology including Data Warehousing, Decision Support Systems, Enterprise Business Intelligence along with strong experience in SDLC: Analysis (Business Requirements), Application Design (Logical Design), Development (Physical Design), Testing, Implement (Documentation and Process Flow) and SQL coding.
• Strong experience in integrating new data sources into existing Data warehouse by using ETL Tools Informatica 9.x/8.x/7.x/6.x. (Power Mart/Power Center), IBM Ascential DataStage 8.x.
• Knowledge in system analysis, database design, Data Warehouse concepts (Dimensional model: Star/Snow Flake Schema), Slowly Changing Dimensions (Type1, Type2, Type3).
• Knowledge of various OLAP/DSS tool like Actuate, OBIEE, Business Objects and Cognos.
• Experience with Financial, Education and Shipping industries.
• Experience in creating the solutions Data Quality, Auditing.
• Ability to analyze source systems and business requirements.
• Extensive experience writing SQL scripts.
• Excellent working knowledge of UNIX shell scripting and job scheduling.
• Excellent trouble shooting/problem solving skills.
• Excellent team player, Quick learner and ability to meet tight deadlines and work under pressure.
• Experience with working in Waterfall and Agile Development.
• Extensive knowledge in Data Warehouse concepts.

TECHNICAL SKILLS

Operating Systems: Solaris, HP - UX, Red Hat Linux, MS DOS, Windows NT/2000/XP

Languages: C, C++, Java 2, VB, Unix Shell scripting, SQL, and PL/SQL

Data Base: Oracle 10g/9i/8i/7.0, SQL Server2000, Sybase, Teradata 13.10

ETL Tools: Informatica Power Center 9.5/8.6/8.1/7.1 , DataStage 7.5

BI Tools: Actuate 8/9, OBIEE 10g, MicroStrategy8.0

DB Utilities: SQL Loader, TOAD, TOAST, Sql Developer, Teradata SQL Assistant

Scheduling: Autosys, Cron

Web Technologies: ASP, JSP, XML, JDBC and Servlets

Scripting Languages: Shell, Perl, HTML, DHTML, JavaScript, and VBScript.

Application Servers: Java Web Server 2.0, BEA WebLogic5.1, Web Sphere 3.5.2

Packages: MS Office (MS Access, MS Excel, MS PowerPoint, MS Word)

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

ETL Developer

Responsibilities:

• Worked on Repcon, Dental on Facets, EFT and ERA and CDHP project enhancements.
• Involved in daily development standup calls.
• Worked with system analyst to understand more details about the requirement.
• Analyze the gaps between requirement and the design document.
• Developed couple of connect direct scripts to extract the file from Advantage team and transfer files to B2B team.
• Developed multiple ETL mappings using expression, filter, sorter, router, join, look up, sequence generator for Dental on Facets project and EFT & ERA projects.
• Involved in enhancements of Repcon (daily repeatable) process.
• Involved in daily defects triage, fix and validation.
• Prepared ADS, mapping design document and unit test documents.
• Wrote SQL scripts for data validations.
• Thoroughly performed unit testing.
• Coordinate with scheduling team to setup new automated jobs for CDHP project.
• Helped to run jobs for testers and talk to them to find more details about the new defects.
• Designed AccelRx Accumulator project.
• Prepare sql data scripts to modify/update/cleanup the data from DB tables.
• On call production support.

Environment: Informatica PowerCenter 9.5.1, Oracle 11, Toad, Flat Files, UNIX, Putty, Facets, WinScp, Microsoft Access.

Confidential, Columbus, OH

Informatica Developer

Responsibilities:

• Involved in daily business and infrastructure meetings.
• Worked with Data modeler to understand more about the logical data model.
• Worked with business analyst to know more about the business requirement.
• Analyze the gaps between requirement and the design document.
• Developed the different ETL mappings to load the BAIR, IES and ODJFS data.
• Designed and developed different ETL mappings using expression, filter, sorter, router, join, look up, sequence generator and update strategy.
• Developed some of the reusable Transformations.
• Developed sessions, worklets and workflows.
• Developed parameter file to parameterize the connection objects, source files details and some other parameter values.
• Implemented SCD Type2 for Insert, Updated and soft Delete.
• Used Teradata Fast Load and Multi Load Teradata utilities to load the target tables.
• Prepared mapping design document and the end of unit test document.
• Wrote shell scripts.
• Thoroughly performed unit testing.
• Coordinate with testing team in every testing phase.

Environment: Informatica PowerCenter 9.5.1, Teradata 13.10, Teradata SQL Assistance, DB2, Talend, Flat Files, TortoiseSVN, UNIX, Putty, WinScp.

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Involved in meetings to gather information and requirements from the business.
• Worked closely with the business analyst to understand the Business needs.
• Analyze and find out any gaps in functional and design document.
• Prepared ETL Design document for all of the complex processes.
• Designed the Data Mapping Document to map source data elements to the target Snow Flake Schema based DW database.
• Created unit test and integration test document for every mapping implemented.
• Developed the Migration Strategy and used the Repository Manager to maintain the Code integrity between the various repositories.
• Designed and developed complex mappings using various transformations in Designer to load data from Flat files, Oracle, XML.
• Designed and developed mappings using aggregate, join, look up, update strategy transformations to extract source data, implement business logic and o load into target.
• Created complex SCD type 1 and type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression, Update Strategy and Sequence Generator.
• Finding the bottlenecks and improving the performance of existing and new applications.
• Used Pipeline Partitioning, Persistent Cache to improve the performance.
• Supported daily loads and look for the logs for any failures.
• Scheduled the jobs in Autosys.
• Created the Unix Shell Scripts to automate the ETL jobs.

Environment: Oralce 10g, Sybase 15.x, Informatica PowerCenter 8.6, Complex Data Exchange (B2B), XML, Flat Files, VSS, Toad, Toast, Putty, WinScp, BMC Remedy, Autosys, MS Office and Apache Directory Studio.

Confidential

Informatica Developer

Responsibilities:

• Involved in complete Life Cycle of develop Data Warehouse and, develop ETL mappings using Informatica.
• Involved in the analysis, design and development of ETL Routines using Informatica tool.
• Developed multiple Informatica Mappings and Reusable Transformations to load data from Source to Target.
• Designed and developed complex aggregate, join, look up, Router, Union, Expression transformation using Informatica tool.
• Involved in validating data in every migration event.
• Involved finding the source, target, mappings and session performance bottlenecks.
• Wrote SQL and PL/SQL to extract the data based on the user requests.
• Wrote SQL scripts to extract data pre and post migration from source and target.
• Scheduled loads using Autosys.
• Scheduled scripts in Crontab to send the source files.
• Created Unit Testing Document for ETL routines.
• Involved in production environment Runbook and Errors Documentation.
• Involved in all phases of (Unit, Integrated and UAT) testing of Informatica mappings.
• Verify logs for failed jobs to find out more details when needed.
• Interacted with Business Analyst, Data Administrators and End Users.

Environment: Informatica PowerCenter 8.6, Oralce 10g, Flat Files, VSS, SQL Developer, Toad, Secure CRT, Putty, WinScp, BMC Remedy, Autosys, Crontab, MS Excel, MS Access and Apache Directory Studio.

Confidential, Princeton, NJ

Informatica Developer

Responsibilities:

• Worked closely with the business experts to understand the source data for every new project
• Analyzed the project requirements, Design Specifications and translated into design document.
• Involved in preparing field mapping document. These processes involved analyzing the target teams requirements and identifying source availability and do field-by-field analysis.
• Analyze and understand the source file structure that comes from Mainframe.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Created reusable transformations, mappings and mapplets using Informatica Designer.
• Designed various mappings using transformations like Look Up, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation.
• Used Mapplets, Parameters and Variables to implement Object Orientation techniques and facilitate the reusability of code.
• Designed and developed complex in Designer to load data from Oracle, Flat files, Excel files into the target Oracle data warehouse.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR schema techniques.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Setting of Error Logic for streamlining and automating the data loads for cleansing and trapping incorrect data on staging servers and then loading it to the data warehouse.
• In Workflow Manager created sessions, tasks, and workflows etc.
• Used Mapping Parameters and Mapping Variables.
• Developed Shell Scripts, SQL Queries and scheduled jobs under the UNIX Environment.
• Created technical documentation for mapping from source to target.
• Migrated all repositories and environment from Version 6.3 to PowerCenter 7.1.4.

Environment: Informatica PowerCenter 7.1.4/6.3, Oracle 9i, Flat files, OBIEE 10gR3, Toad, SQL, Crontab, UNIX, Windows XP.

Confidential, TN

Informatica Developer

Responsibilities:

• Responsible for extracting, transforming, and loading data from oracle, flat files and placing it into data warehouse.
• Designed, developed, and tested the mappings using Informatica 7.1
• Interacted with management to gather sources and their requirements.
• Involved in the some part of performance tuning.
• Developed simple and complex mappings using Informatica to load dimensions and fact tables as per STAR schema techniques.
• Performed Unit testing and integration testing.
• Working on data loading of fact table from dimensions and source table.
• Extensively used TOAD to write sql queries for validations.
• Created reusable transformations and Mapplets and used them in mappings.
• Fine-tuned Transformations and mappings for better performance.
• Transformed data from source system to target.
• Involved in some part as informatica Administrator.
• Migration of informatica Repositories (DEV-UAT, UAT-Prod).
• Involved and resolving the tickets related Informatica mappings.

Environment: Informatica PowerCenter 7.1, Actuate 7.0, Toad, MS Office, TeraData