SUMMARY

• 8+ Years of experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications which includes strong experience in DataWarehousing (ETL & OLAP) environment as a DataWarehouse Consultant
• Expertise in Dimensional Modeling, Star and Snowflake schema
• Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements
• Expertise in Data Flow Diagrams, Process Models, ER diagrams with modeling tools like Erwin & Visio
• Proficiency in utilizing Informatica PowerCenter 9.x/ 8.x/7.x/6.x/5.x for developing the DataWarehouse loads as per client requirement
• Experience in designing and developing ETL Environment involving various source and target databases like Oracle, Flat Files, DB2 (fixed width, delimited), XML, SQL Server, Sybase
• Design/develop and manage power center upgrades from v 7.x to V 8.6, Migrate ETL code from Informatica v 7.x to V 8.6..
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Extensive experience in developing the Workflows, Worklets, Sessions and configuring the Informatica Server using Informatica Power Center.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementation the reconcile process accordingly.
• Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization
• Extensive experience with database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Excellent team player and self - starter with good ability to work independently and possess good analytical, problem solving and logical skills.
• Worked in a fast paced team environment with excellent communication skills.
• Exposure to OLAP reporting tools: Business Objects and Cognos.

TECHNICAL SKILLS

ETL: Informatica 6.2/7.1/8.1/8.6.0/9.1 (PowerCenter)

OLAP: Business Objects 5.0, Cognos 8.0

Modeling: Erwin 3.x/4.x

RDBMS: Oracle 8i/9i/10g, Sybase, Teradata, DB2, SQL Server 2000, MySQL, MS Access

Utilities: SQL *Loader (Oracle), Toad 9.7.2

OS: Windows 9x/NT/2000/XP, UNIX (Solaris, HP-UX, AIX)

Languages: Java, SQL, PL/SQL, Java Script, C, C++

Web: HTML, XML, CSS, JSP

Productivity: MS Office 97/2000/XP, Open Office Suites

Scheduling: Crontab, AutoSys, Control-M

Quality: Trillium 4.0

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Woonsocket, RI

Responsibilities:

• Determining Interface requirement for source and target systems
• Participated in designing the high level overview of the project.
• Created Datamaps at attribute level to map the source and target systems and provided the business logic to implement the functionality.
• Involved in creating Informatica mappings, mapplets, worklets and workflows.
• Prepared Low level designs that are used to develop informatica mappings.
• Tuned informatica mappings and sql queries for better performance.
• Created rules, policies and plans in ILM tool
• Generated workflows through ILM tool.
• Designed the workflow strategy and scheduled them through Control-M.
• Developed Unix shell Scripts for running informatica workflows
• Conducting the Unit testing of the module to identify the bugs.
• Carrying out root cause analysis of the bugs and provided the solutions for the same..
• Studying the existing system and conducting reviews to provide a unified view of the program.
• Bug fixes during unit testing and system testing
• Coordinated and delegated work to offshore team.
• Actively participated in clarification meeting with the Clients.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards
• Created Unit Test Cases and documented the Unit Test Results..

Environment: Informatica PowerCenter 9.1, Oracle 10g, Flat files, TOAD, Visio, PL/SQL, SQL, Unix Shell Scripting, Windows XP, ILM, Control M.

Sr. Informatica Developer

Confidential, NYC

Responsibilities:

• Met with business stakeholders and other technical team members to gather and analyze application requirements
• Designed database solutions to satisfy application (business and technical) requirements
• Implemented database solutions using available database development tools like BPM, PowerCenter
• Provided first level operational support for development and production database systems
• Providedwritten status reports to management regarding project status, task, and issues/risks
• Developed complexInformaticamappings using different types of transformations like Union transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations forlarge volumes of data
• UnitandRegressiontesting of theInformaticaMappings created according to the business requirements
• Used of SQL tools likeTOADto runSQL queriesto validate the data
• Created Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor
• DefinedMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues
• Tuned performance of Informatica code for better performance
• UsedVersion Controlprovided byInformaticaon each and every object. In this way, each and every version of the process will be available for recovery or research purposes
• DevelopedUNIX Scriptsfor updating the control table

Environment: Informatica PowerCenter 8.6/8.1, Informatica PowerExchange 8.1.1, Business Process Modeling (BPM), SAP R/3 7.1, Oracle 10g/9i, Mainframe, DB2, Flat files, TOAD, VisioPL/SQL, SQL, UNIX (AIX), Unix Shell Scripting, Windows XP

Sr. ETL Consultant

Confidential, Somerset, NJ

Responsibilities:

• Worked closely with the business units and end user to determine the business requirements
• Analyzed business requirements and worked with the various application teams and business teams to develop ETL procedures
• Involved in Dimensional modeling using Erwin to design Fact and Dimension Tables
• Designed mappings using reusable mapplets from various sources like Oracle, SQL Server and flat files and loaded it into Teradata target
• Designing technical specifications for building DataMart
• Used UNIX scripting as pre/post-session commands to schedule loads using Crontab jobs
• Worked with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and populate it in DataWarehouse
• Worked on performance tuning of ETL procedures and processes. Also used debugger to troubleshoot logical errors
• Worked with UNIX Shell scripts, PL/SQL procedures and functions
• Migrated codes from Development to Testing and from Testing to Production
• Involved in unit and integration testing for the mappings
• Assisted in generating reports using Business Objects
• Prepared documents comprising of all technical and functional specifications and created test cases for data integrity and consistency

Environment: Informatica PowerCenter 8.1/7.1, SQL, PL/SQL, Oracle 9i/10g, Teradata, MS SQL Server 2000, Sybase, Flat files, Business Objects, Crontab, Erwin, Windows XP, UNIX (HP-UX)

ETL Developer/Analyst

Confidential, Cedar Rapids, IA

Responsibilities:

• Involved with Business Analyst in requirements gathering, business analysis and project coordination
• Analyzed source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model
• Involved in dimensional modeling to design and develop the STAR Schema using Erwin
• Developed data Mappings between source systems and warehouse components
• Worked with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures
• Used Power Exchange to extract DB2 Source from mainframe server
• Used Industrial Best Practices for Error handling
• Developed and test all the backend programs, Informatica mappings and update processes
• Managed the Metadata associated with the ETL processes used to populate the DataWarehouse
• Worked on SQL, PL/SQL and UNIX Shell Scripts
• Used UNIX scripting as pre/post-session commands to schedule loads using Crontab jobs
• Removed bottlenecks for the optimum usage of sources, transformations and targets
• Used SQL*Loader to load data from flat files to Oracle target database
• Performed Unit and Integration Testing of Informatica Sessions, Batches and Target Data
• Involved in generating reports using Cognos ReportNet

Environment: Informatica PowerCenter 7.1/ 6.2, Windows XP, Oracle 8i/9i, HTML/XML, Cognos ReportNet, Erwin, Crontab, SQL Server 2000, IBM- DB2, UNIX (Solaris)

ETL Developer

Confidential, Philadelphia, PA

Responsibilities:

• Interacted with End user community to understand the business requirements
• Prepared required application design documents based on functionality required
• Worked with heterogeneous sources from various channels like Oracle DBMS, SQL Server and flat files
• Design and Development of ETL routines, using Informatica PowerCenter within Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, connected and unconnected stored procedures / functions / Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were done
• Implemented dimensional model(logical and physical)data model in existing architecture using Erwin
• Created DataMarts for both kinds of applications, CRM and financial and used effective querying and formatting tools to present the data to the end users
• Monitored sessions that are running, scheduled, completed and failed
• Used ETL to load data from flat files (Excel/Access), SQL Server to Oracle database
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired
• Cleansing and extraction of data and defined quality process for the warehouse
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data, persistent cache
• Designed ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files (Excel/Access) and XML Files to target Oracle DataWarehouse database
• Developing testing strategies for efficient and error free testing
• Used Workflow Manager for creating, validating, testing and running sequential, concurrent batches, sessions and scheduling them to run at specified time with required frequency
• Involved in Unit testing, System testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database. Created Stored Procedures to transform the Data

Environment: Informatica PowerCenter 7.1.2, Business Objects 6.5, Oracle 10g/9i, TOAD, Erwin 4.5, SQL, PL/SQL, XML, Windows XP, HP-UX, TestDirector/QualityCenter

Software Programmer/Analyst

Confidential

Responsibilities:

• Designed the E-R model and normalized the database
• Performed Database design and development
• Developed entry screens such as Agent master entry, Party master, L/c entry, Proforma entry, Amendment entry, Currency master entry, Invoice entry
• Developed reports for costing analysis, CHAs bill report, BDA report, Usance credit report, In bond report, Advance License report
• Developed in Forms 4.5 with Oracle7.3
• Developed Graphical charts for pricing analysis, sales analysis using Oracle graphics

Environment: Oracle 7.3/8.0, Forms 4, Reports 2.5, Java and Windows 95