SUMMARY

• 5 years of comprehensive IT experience in Requirements Analysis, Design, Development, Implementation & Maintenance activities.
• 5 years of experience with Data Warehousing using Informatica 9.1/8.6 (Power Center & Power Mart) as an ETL tool and Oracle 9i/10g/11g & DB2 as relational databases.
• Excellent experience in active participation of requirements analysis meetings with Business owners, Product team, Business analysts to gather requirements for a project. Experienced in creating a detailed design document to translate the requirements into technical design.
• Excellent experience in Data warehouse designing and Data modeling of physical/logical data, Facts and Dimensions, Star schema, analysis, implementation by using Erwin and Visio.
• Excellent experience in creating and maintaining database objects like Tables, Views, Materialized views, Indexes, Constraints, Synonyms.
• Experienced in working with different data sources like Oracle, DB2, XML, COBOL Files and Flat files.
• Experienced in creation of Mappings using Lookup, Expression, Joiner, Filter, Router, Sorter, Aggregator, Normalizer and update strategy Transformations.
• Excellent experience in designing and developing mapping strategies for both type - 1 & type-2 SCDs to load data into the warehouse tables.
• Experienced in creating reusable Transformation, Mapplets and Worklets.
• Extensively worked with Informatica tools like Designer, Repository manager, Workflow manager and Workflow Monitor.
• Experience with methodologies like Waterfall, Agile and Scrum with Software Development Life Cycle process.
• Experienced in writing PL/SQL Stored Procedures, Functions, triggers. Database Performance Tuning, Partitioning and Query optimization techniques.
• Experienced in developing UNIX Shell scripts to execute the workflows using third party schedulers for automation of ETL process.
• Experienced in creation of UNIT test plans, SIT Test scripts, UAT Test scripts for testing.
• Excellent experience in implementation of SDLC process for large scale projects.
• Having very good experience in Onsite/Offshore model.
• An Efficient and reliable performer with excellent communication, analytical, problem-solving, interpersonal skills, Quality conscious and Hard-Work.

TECHNICAL SKILLS

Hardware/Platforms: Windows2000, XP, Windows7, UNIX, IBM-OS/390

ETL: Informatica (Power Center 8.x/9.x, Power Mart 8.x/7.x)

Modeling Tools: Erwin & Visio

Databases: DB2, Oracle 9i/10g/11g

Languages: SQL, PLSQL

Schedulers: CA-7, Crontab

Office Tools: MS Outlook, MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Systems Engineer

Responsibilities:

• Participate in Requirements Analysis meetings with business users and business analysts to gather requirements.
• Create Detailed System Design Document with Test plan & Test cases and review with Architects & Business analysts.
• Created Mappings using Transformations like Expression, Joiner, Aggregator, Connected & unconnected lookup, Filter, Sequence generator, Router, Sorter, Update Strategy.
• Created one time mappings to update values for newly inserted fields into the existing tables.
• Analyzed existing Mappings, Transformations, Mapplets for business logics and changed them as per the requests.
• Involved in migrating the Mappings, Sessions, Workflows from DEV environment to UAT.
• Tuned ETL process for performance improvement using pushdown optimization & Dynamic partitions.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it is implemented into production.
• Provide estimate to Application change requests, Ad-hoc requests and prod fixes.
• Developed PL/SQL Procedures & Functions to calculate metrics and used in mappings for creating reports.
• Identifying and resolving the bottlenecks in source, target, transformations, Informatica mappings and sessions to improve performance.
• Involved in creating Indexes, Sequences, Views, Materialized views and database partitioning.
• Designed, developed and implemented the ETL control through Unix scripts. Automated workflows using PMCMD command.
• Extensively used Designer, Workflow manager and Monitor for creating, executing and monitoring workflows.
• Provide a status report to the Management on a weekly basis.
• Coordinate with offshore team members and provide guidance to complete their tasks.
• Help offshore team members to improve their application and technical knowledge.

Environment: Informatica Power Center 8.6/9.1, UNIX, Oracle 10g/11g, Visio, Shell Scripting and Windows.

Confidential

Systems Engineer

Responsibilities:

• Participated in requirements meetings with business users and business analysts with BRD (Business Requirement Document) and FRD (Functional Requirement Document).
• Involved in the Analysis, Design and development of Finance Data Mart and populating the data from different data sources using Informatica.
• Provided estimates after technical analysis for new development and enhancements.
• Written High-Level design documents and Low-Level Design documents and reviewed with Business Analysts and users.
• Review the technical specification with development team (offshore and onsite) and allocation of development and keeping track of development status.
• Used STAR/Snowflake Schemas in designing the Datamart for Financial reporting purpose.
• Created Transformations like Joiner, Aggregator, Connected & unconnected lookup, Filter, Sequence generator, Router, Expression, Sorter, Normalizer, etc.
• Created reusable transformations and Mapplets using Mapplets designer for common business logic to apply with trades received from different sources and used it with different mappings.
• Analyzed and changed stored procedures written in Oracle PL/SQL and DB2 as per the change requests.
• Designed and developed Procedures, Functions & Packages to handle errors and exceptions at database level using PL/SQL.
• Identifying and resolving the bottlenecks in source, target, transformations, Informatica mappings and sessions to improve performance.
• Involved in creating Indexes, Sequences, Views and performance tuning like analysing tables, creating indexing.
• Designed, developed and implemented the ETL control through Unix scripts. Automated workflows using PMCMD command.
• Extensively used Repository manager, Designer, Workflow manager and Monitor for creating, executing and monitoring workflows.
• Performed the Unit Testing and smoke testing which validate the data is mapped correctly and stored correctly in Target Tables.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Expected Results & Actual results.
• Created and maintained the detailed project documentation.
• Worked with user requests, resolved their issue with data load and answering their question regarding jobs and their load frequency.
• Identifying issues in existing mappings by analysing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Created production packages for the tested components and created Change Management tickets. Then with the necessary approvals implemented the changes into production. After implementation, thoroughly verified the changes in production.
• Followed the complete SDLC process for projects.
• Provided weekly status report to the onsite Management.

Environment: Informatica Power Center 8.6, UNIX, Oracle 9i/10g, PL/SQL, DB2 UDB, Erwin, Visio, Shell Scripting, Windows.