SUMMARY

• Experience in Business Requirements Analysis, Application Design, Development, Implementations and Testing of Data Warehousing and Database business systems for Banking Financial and Healthcare industries.
• Experience in implementing Data warehouse and database applications with Informatica ETL.
• Experience in working with Informatica Power Center, Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Expertise in implementing complex Business rules by creating robust mappings, mapplets, reusable transformations, worklet using Informatica Power Center.
• Proficiency in data warehousing techniques like Slowly Changing Dimension (SCD) (Type I, Type II and Type III).
• Extensively worked on Teradata Stored Procedures to create various reports.
• Worked with different file systems including Mainframe COBOL copybook files, CSV files to capture the data into the data warehouse.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Union, Update Strategy, Rank, Aggregator, SQL, XML, Stored Procedure, Sorter, Sequence Generator.
• Implemented various Performance tuning techniques on Sources, Targets, Mappings and Workflows.
• Have Good understanding of ETL/Informatica standards and best practices.
• Experience in testing coordination, writing test cases and executing test scripts.
• Experience in SLA and leading all phases of the software life cycle (feasibility studies, estimating, system analysis, design, development, quality assurance and implementation). Ex: Waterfall Model, V Model.
• Proficiency in Banking with extensive domain knowledge on Account Reconciliation Product (ARP) and FraudGuard (FG).
• Proficiency in Application Development and Maintenance using COBOL, JCL and Easytrieve.
• Extensively used mainframe tools/utilities such as ENDEVOR, CHANGEMAN, FILE - AID, TSO/ISPF, XPEDITOR, ABEND-AID.
• Worked on scheduling tools such as CA7.
• Expertise in creating reports using Easytrieve.
• Have involved in all the phases of Software Life cycle from requirement gathering, designing, coding, testing and implementation.
• Flexible and Versatile who can adapt to any new environment and learn fast with excellent communication & interpersonal skills.
• Experience in project planning, effort estimation, task planning and allocation, weekly status and milestone reporting.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/9.1/9.5/9.6

Databases: Oracle, VSAM

Scheduling Tools: Autosys, CA7

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, COBOL, JCL, Easytrieve

Data Modelling /Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle

Other utilities: CHANGEMAN, ENDEVOR, CA7, FILE-AID, TSO/ISPF, XPEDITOR, ABENDAID

Operating Systems: Windows, UNIX, Z/OS

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Analyzed the data model to fit in the ETL to load data into its input tables with proper link of surrogate keys
• Design and Development of ETL routines, using Informatica Designer within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Normalizer, Mapplets, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Extensively used Global Source/Targets, User Defined Function, Reusable Mapping and transformation.
• Used Incremental Aggregation technique to load data into Aggregation tables for improved performance.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, Ftp Session Parameters and Source-Target Application Connection parameters.
• Performed Risk and Gap Analysis Used Informatica -Best Practice to handle Error handling - Logging the record level errors in the metadata tables and Auditing - Capture the source/target record counts in every phase of the process flow.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse Teradata tables using Informatica Workflow Manager.
• Written SQL commands (Pre-Session & Post-Session commands) and executed them in the target database to drop the index & create the index for the target table before and after loading data into it.
• Involved in identifying bottlenecks in source, target, mappings and sessions and resolved the bottlenecks by doing Performance tuning techniques like increasing block size, data cache size, buffer length.
• Developed the UNIX shell scripts to send out an E-mail on success of the process indicating the destination folder where the files are available.
• Used Autosys for scheduling the jobs.
• Developing and reviewing Detail Design Document and Technical specification docs for end to end ETL process flow for each source systems.

Confidential

Mainframe Developer

Responsibilities:

• Actively involved in production support activities and day to day meetings.
• Involved in all the SDLC phases of minor and major enhancements.
• Analyzing the problem/root cause, preparing the impact analysis, document and fixing bug/issues/work request.
• Provided and implemented optimization ideas to the existing codes.
• Provide support in critical production support issues.
• Provided solution for production issues by implementing periodic bug fixes.
• Conduct code review to ensure the work delivered by the team is of high quality.
• Automation and optimization of the manual processes and created contingency reports using Easytrieve.
• Involved in coordinating & conducting many knowledge sharing sessions related to domain and technology.