SUMMARY

• 6+ years of IT professional experience in designing, analysis, programming and testing using Informatica Power Center 9.x/8.x/7.x/6.x.
• Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions.
• Extensive experience in Developing Informatica complex mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
• Intelligent Gathering of Business requirements to map legacy and other sources to integrate into the Warehouse.
• Experience in providing end - to-end business intelligence solution by dimensional modeling design, development, and loading, building business models, configuring metadata and validation dashboard reports.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Created UNIX Korn Shell scripts for Informatica post and pre session operations
• Hands on experience in scheduling jobs through Autosys Jobs.
• Good knowledge in writing Unix Shell & Autosys JIL scripts and PERL Scripts
• Hands on experience in maintaining the code versions using Visual Source Safe.
• Proficient in writing complex Oracle SQL, Views, for database applications.
• Very good exposure to Oracle 10g, 9i, 8.x, MS SQL Server 2000/2005, IBM DB2, Teradata databases
• Good Knowledge in Reporting Tool Business Objects Reports XI and Crystal Report
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Industrial, Insurance, Pharmaceutical industries
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS

ETL Tools: DTS in SQL Server, Informatica Power Center 8.6/8.1/7.1.3/6.2 , Business Objects XI and Cognos

Databases: Oracle, SQL Server, Teradata, Sybase, DB2 UDB, MySQL

Products: Actuate reporting, DTS packages, SSIS, BO

Programming Skills: DB2,SQL, PL/SQL, Pascal, COBOL, Perl, C, C++, JAVA,C# and FORTRAN

Scripting Languages: UNIX Shell, PERL

Operating Systems: UNIX (Sun Solaris 2.x, HP/UX), Windows, MVS,IBM AIX 4.2,MAC

PROFESSIONAL EXPERIENCE

Confidential, Brea, CA

Informatica Developer

Responsibilities:

• Single handedly developed the module by dumping the data from source to a staging area, the staging data was then cleansed and validated against the specified business rules and loaded into Intermediate layer.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Created materialized views for the better performance in reporting.
• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 9.5.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup and Expression Transformations in Informatica.
• Created staging tables from the legacy database along with the auditing information.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Involved in creating the data model and specs for the ETL development.
• Developed Informatica mappings. Unit test ETL mapping codes and validated the result set data.
• Load the data from various File systems to the DWH and DM.
• Maintain the Versioning for the objects by using VSS.
• Analyzed the compatibility of the current code base and determined the impacts of new data mart (CDM) over the existing system.
• Designed and documented the technical and functional specification of the module.
• Documented validation rules, exception processing and test strategy of the mappings
• Migrated ETL codes from Development to Test to Production.
• Supported and executed the job run cycles manually through the workflow process setup for each release.
• Performed unit testing for the developed mappings.
• Created Source to Target Mappings (STTMs) document.
• Validated and monitored daily job runs.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Studied and analyzed existing mappings/sessions and identified performance bottlenecks.
• Translate data transfer requirements into ETL solutions.
• Design, develop, test, and maintain ETL processes.
• Write complex DB2 joins and conditional DB2 logic.
• Create reusable objects.

Environment: Informatica 9.5.1, Share point, System navigator, TOAD, IBM DB2, AS400.

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Improved error handling and reduced the number of defects by implementing Audit Balance Control (ABC) using Informatica and DB2 to maximize the quality of the deliverables.
• Analyzed the data for gap analysis between source and target structure.
• Performed data profiling to understand the data pattern using Informatica
• Performance tuned the module using techniques like cache, scripting and transformation improvements.
• Wrote Unit Test Plan, Module Test Scripts, Module Test Plan, and Failure Modes & Effective Analysis.
• Understand the overall Investment Management business so that identification of processes becomes simple.
• Customization/Creation of ETL components as part of development.
• Create the Unit Test Cases and done SIT testing for ETL & Reporting.
• Performance tuning of new or existing application wherever required.
• Handled complete configuration of customized/new tasks and loading process through Control-M jobs.
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required.
• Designed logical and physical data model. Designed ETL process from source to target.
• Created database objects like staging tables, target tables, synonyms, sequences, triggers and stored procedures to move data to target.
• Developed Shell scripts to run ETL batch through Control-M schedule.

Environment: Informatica, Control-M, Rapid SQL, FileZila, Cognos, Oracle10g, Sybase, DB2,, Erwin, Shell Script

Confidential, Indianapolis, Indiana

Informatica Developer

Responsibilities:

• Worked as Technical Specialist.
• Interaction with the client and requirement Gathering.
• Preparing HLD, BRS & LLD.
• Responsible for developing ETL mapping for the reporting requirement & for data feeds
• Successfully conducted Load Testing and Performance Testing
• Automated regression test suite for actuate reporting and true portal.
• Created the ETL component and test scripts.
• Involved in client meetings for their inconsistent requirements
• Provided the best solution for their requirement
• Help the Clients in designing of the system and process to make it more robust and meaningful.
• End to end processing from the source to target.
• Resolve the issues coming from the end to end processing.
• Perform the enhancements if required by the business users.
• Responsible for developing ETL mapping for the reporting requirement & for data feeds
• Involved in preparing System Requirements and Application Design Document. Worked closely with all upstream and downstream application owners to make sure interface agreement documents are clear.
• Successfully conducted Load Testing and Performance Testing
• Automated regression test suite for actuate reporting and true portal.
• Used Peregrine Service Center, ITS and Change Synergy to track and report system defects and bugs, writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.
• Project management activities:
• Adherence to quality process
• Responsible for on time delivery
• Ensuring Reusability and continuous learning

Environment: Informatica Power Center 8, PL/SQL, Oracle 10g/9i, SQL Server 2005, Windows Server 2003, UNIX, Toad, Visual Source Safe (VSS).

Confidential, NYC, NY

Informatica Developer

Responsibilities:

• Creation of new ETL related to CR as per customer requirement.
• Unit testing and implementation in production for new CR
• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 8.6.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup and Expression Transformations in Informatica.
• Created batches to run several sessions sequentially and concurrently.
• Involved in performance tuning of Informatica mappings and sessions.
• Based on requirements, Developed Source-To-Target mapping document with business rules and also developed ETL Spec documentation.
• Did code review and unit tested ETL mappings. Mentor the developers and help them with issues.
• Created Functional Requirements Document (FRD) containing the glossary, Actors List, Functional requirements, Business Rules, QA Planning and Testing Scenarios, Current and Future Process flows.
• Developed ETL mapping for the reporting requirement and for data feeds. Changed ETL Mapping provided by vendor to suit business requirement.
• Gap analysis by mapping the functional requirements to the Business Requirements worked on the report design to create User Interface mock-ups.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.
• Verifying the deliverables of the testing performed by the QA team and provided sign-off for production.

Environment: Unix, Informatica 7.1, Windows XP, Oracle 9i, MS Access 2000, VB Script, Toad, MS Visio, MS Excel, MS Word.

Confidential, Denver CO

ETL Developer

Responsibilities:

• Impact Analysis, Detail Design, Traceability Matrix.
• Distribution of work among team members.
• Task creation for the team members and management related work for Technical Design Document, Functional document and code review for the different project.
• Created Functional Requirements Document (FRD) containing the glossary, Actors List, Functional requirements, Business Rules, QA Planning and Testing Scenarios, Current and Future Process flows.
• Developed ETL mapping for the reporting requirement and for data feeds. Changed ETL Mapping provided by vendor to suit business requirement.
• Gap analysis by mapping the functional requirements to the Business Requirements worked on the report design to create User Interface mock-ups.
• Coordination with the onsite coordinator for delivery to client.
• Verifying the deliverables of the testing performed by the QA team and provided sign-off for production.
• Unit testing and implementation in production for new CR
• Daily production supports for the scheduled job and provide the resolution related to failed job and fixed them.
• Performance tuning of the workflow which are taking time.
• Analyzed the enhancements coming from the individual Client for application and implemented the same.
• Creation of technical documents.
• To write unit test cases/integration test cases, share test cases with client and do the unit tests for the client sample data.
• Simulated real time transaction feed by fabricating transactions required for UAT and manually calculating expected results to generate expectancy going into the testing process.

Environment: Informatica Power Center 8, Workflow Manager, Workflow Monitor, Power Exchange, PL/SQL, Oracle 10g/9i, SQL Server 2005/2000, Windows Server 2003, UNIX, Toad, Visual Source Safe (VSS).

Confidential

Report Developer

Responsibilities:

• Responsible for the creating stored procedures and database triggers.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the data from data files into the staging tables.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required project.
• Understand the Business requirements and estimate the effort for the new requirements.
• Trend analysis of defects/logs for identification of problem areas and to improve productivity.
• Customization/Creation of ETL components.
• Handled complete configuration of customized/new tasks and loading process through DAC.
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Take care of CR (Change Request).
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Creation of Unit Test Cases for testing purpose.
• Performance tuning of the application wherever required
• Preparing the estimation for new CR and bug fixes.
• Doing the System improvement plan wherever required.

Environment: Informatica 8.x, Erwin, SQL, PL/SQL, Toad, File Zila, Unix/Oracle 9i.