SUMMARY

• 10+ years of IT experience in System Analysis, Design, Development and Maintenance of various software applications in client - server environment and 2 Years of Non-IT experience in structure design.
• Extensive experience in using Informatica Power Center 9.5.0/8.6.1/8.1.1/7.1.1/7.0 , Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work flow Monitor, Datamart, OLAP, OLTP, Mapplet, Transformations and SQL*Plus.
• Worked extensively with Dimensional modeling, Data migration, ETL Processes for Data Warehouses.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to warehouse using Informatica Power Center. load data from different sources systems into data
• Adept at understanding business processes / requirements and implementing them through mappings and transformations.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Strong Experience and knowledge in creating Stored Procedure and Trigger using Oracle 10g/9i.
• Highly Skilled with the Integration of various data sources like Oracle 11g, DB2, SQL Server, Flat Files, Teradata, XML and IBM Mainframe COBOL files.
• Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing.
• Actively involved in Performance Tuning, Error handling, Product support on various Platforms.
• Used Informatica debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Experience in UNIX Operating System and Shell scripting.
• Worked in Development, Production and Maintenance Support Projects
• A Very good team Player with excellent communication, analytical, verbal, writing and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.0/8.6/7.1/6.5

Business Intelligence: Cognos 7.1

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACTS and Dimension tables., Software Development Life Cycle (SDLC)

Databases: Oracle 11g,10g, 9i, 8i, DB2, Teradata, Informix 9.1, MS Access 2000, SQL Server 7/2000, Sybase9x, VSAM

Languages: SQL, PL/SQL, UNIX, Shell Scripting, Perl, COBOL, JCL, EZTRIVE,CICS

Configuration Management: RMS, Source Safe

Debuggers: Smart test, XPEDITER, IBM Debugger Informatica Debugger

Testing Tools: Roadrunner, Intertest, RSA clear case

Business Tools: Visio 2013, Microsoft Project

Environment: s: WIN95/98/NT/2000/XP, Unix, Sun Solaris 4.8, 5.6, HP-UNIX, Digital True64 UNIX, SCO UNIX, AIX UNIX, LINUX

Reporting Tools: Business Object and Cognos

PROFESSIONAL EXPERIENCE

Confidential

Consultant Specialist

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications, development, deploying and testing.
• Involved in all the phases of project (Client Interaction, Gathering requirements from Business users, Preparation of detail design, Development, Unit Testing and Production support).
• Created Informatica Mappings to load data using transformations like Sorter, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Extensively worked on tuning and thereby improving the load time.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Developed the mapping to pull the information from different tables and used SQLOveride to join the tables instead of Joiner transformation to improve the performance
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed using AutoSys. Debugged the mapping of the failed session.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
• Reviewed the ETL mappings and data samples loaded in the test environment for data validation.

Environment: Informatica Power Center 8.1, Oracle10g, SQL, PL/SQL, Microsoft SQL Server, TOAD, MKS Toolkit, MKS Scripting, Avaya CMS, Visio, Microsoft VSS, Windows 2000 Server, COBOL, JCL,DB2,CICS

Confidential

Programmer Analyst

Responsibilities:

• Co-ordination with End-users and Subject Matter Experts in requirement analysis, planning and preparing Functional and Technical specifications.
• Being responsible for co-ordination with onsite in task delivery in terms of timely query resolution, follow-up and being within the allotted deadline.
• Development and Coding
• Code Review
• Unit Testing
• Technical Documentation

Confidential

Programmer Analyst

Responsibilities:

• The Global Product Platform (GPP) is the heart of SV card business. GPP is a platform designed exclusively for Stored Value Products, which are either owned or managed by Confidential . GPP holds the entire data related to prepaid cards.
• The products subsystem within GPP controls the operation of each card. Some cards for example have the ability to use ATM machines. Some cards receive a monthly statement, while others are anonymous cards sold as gift certificates and don't receive a monthly statement. These individual properties that make a card unique are called subcomponents. A product within GPP is a grouping of subcomponents. There are over one thousand subcomponents within GPP each of which controls a specific property that can become part of a product.

Confidential

Responsibilities:

• Co-ordination with End-users and Subject Matter Experts in requirement analysis, planning and preparing Functional and Technical specifications.
• Being responsible for co-ordination with onsite in task delivery in terms of timely query resolution, follow-up and being within the allotted deadline.
• Process reengineering and documentation.
• Creation of FUDs, process flows and K245s

Confidential

Software Engineer

Responsibilities:

• Co-ordination with Team members and Subject Matter Experts in requirement analysis, planning and preparing Functional and Technical specifications.
• Development/Coding
• Unit Testing
• Technical Documentation