SUMMARY

• 8+ year experience in Design, Coding and Development & Implementation maintenance and production support of Data Warehouse/Data Mart and Transformation various complex software systems using Informatica 9.x, Ab Initio 3.x, COGNOS and UNIX and SQL and TERADATA in Banking and Financial Stock Exchange domains.
• Around 4 Years of experience as Informatica Developer which includes onsite coordinator and business coordinator.
• Having good experience on Application support for multiple applications runs on various ETL tools like Informatica, Ab Initio and COGNOS technology in UNIX environment for production and UAT regions.
• Extensively used Aggregator, Joiner, Rank, Source Qualifier Lookup and Update strategy transformations.
• Having good exposure on tuning the informatica mappings and query tuning.
• Participated while migrating the informatica versions from 8.x to 9.x.
• Knowledge in EME Check - ins, Check-outs and code migrations.
• Well versed with Ab Initio parallelism techniques, Multi File System (MFS) techniques and various Ab Initio components.
• Used Enterprise Metadata Environment (EME) for version control, Dependency analysis and Data Lineage.
• Having good experience extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Oracle,
• Expertise in writing various k-shell Scripts for ETL process in AIX UNIX environments.
• Developed several Informatica 8.x mappings for extracting, transferring, cleansing and loading and populating various Data marts, used Informatica 8.x with Very Large Database Systems environments.
• Sound Knowledge of Data Warehouse/Data Mart, Data Modelling concepts.
• Experience in communicating and training End Users and an enthusiastic learner with good communication skills and maintain a high-level team spirit.
• Demonstrated ability in Grasping New Concepts (Both Technical & Business) and utilize as needed.
• Proficient in creating documentation related to Project Architecture, Mapping, and Design, Project end User Manual and Operations Hand off guide.
• Good working knowledge in various phases of project management and various software development methodologies.
• Experience in distributed software development - onshore / offshore model.
• Sincere, well-organized, quick learner self-motivated team player and has experience in all phases of the Systems Life Cycle including project definition, analysis, design, coding, testing, implementation and support.
• Quick Learning, Ability to adapt and strong communication skills, honest, Hardworking.
• Exposure to CMM Level 5 standards and processes

TECHNICAL SKILLS

Operating Systems: Windows, UNIX

Programming Languages: Shell Scripting

Databases: Teradata, Oracle 11g, MS SQL Server 2008/2005

Database Tools: SQL * PLUS, Toad

ETL Tools: Informatica 9.x/8.x, Abinitio 3.x/2.x

Office Tools: MS Word, Excel, Power Point

Others: Quality Center, Maestro and Autosys.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

Responsibilities:

• Working closely with Business Analysts, Data Analysts and preparing the TDDs and mapping design documents.
• Working closely with client and addressing the client concerns on high priority basis.
• Discussing with business and planning and coordination the monthly production runs and restatement runs.
• Was responsible for the development of all the mappings, performance tuning of mappings and sql queries.
• Coordinate and communicate with Business and downstream, upstream systems on the issues and working with them to resolve them.
• Involved in resource planning and cross functional training and helped in knowledge transition for the new joiners.
• Tracking the metrics such as productivity, project status and defects.
• Extensive use of SQL queries for Data Transformation and application of Business Rules to the source data while back tracking the production issues.
• Providing valued Technical and functional support and Working with different teams to resolve the issues based on issue criticality and priority.
• Written the shell scripts to automate the manual tasks around the Project.
• Potential of handling multiple tasks easily and capable of meeting deadlines.
• Implementation of automated scripts for the project requirements.
• Managing and Guiding the offshore Team and validating the outputs of Offshore.

Environment: Informatica, Teradata, oracle and UNIX

Confidential

Informatica Developer

Responsibilities:

• Monitored the monthly, weekly and daily batches.
• Providing valued Technical and functional support and Working with different teams to resolve the issues based on issue criticality and priority.
• Extensive use of SQL quiries for Data Transformation and application of Business Rules to the source data while back tracking the production issues.
• Good exposure on PL/SQL Programming, Stored Procedures and functions, views.
• Written the shell scripts to automate the manual tasks around the Project.
• Promoting the developed code to UAT and Production regions
• Monitoring daily and monthly jobs through Autosys scheduler.
• Coordinate and communicate with Business and downstream, upstream systems on the issues and working with them to resolve them.
• Involving issue related meetings with client and respected teams
• Maintaining the issue resolution and postmortem documents on production support issues.

Environment: Abinitio, Informatica 8.x/9.X, Oracle, Teradata, UNIX, Maestro and Autosys

Confidential

Informatica Developer

Responsibilities:

• Was responsible for the development of all the graphs for Regional Reporting project.
• Extensively used Partition by Key & Sort, Partition by Expression/ Round Robin, Filter by Expression, Sort, Reformat, Gather, Redefine, Replicate, Scan and components to develop the ETL transformation logic.
• Improved the performance of Ab Initio graphs by using Lookups, Max-core, In-Memory Joins and parallelism techniques for maximum usage of cache memory.
• Used Check pointing and phasing to improve reliability of the application. Developed Complex Ab Initio XFRs to derive new fields and solve various business requirements.
• Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi-files and each segment is processed simultaneously.
• Developed number of graphs and Transformations to facilitate one time and Loading of Data.
• Developed wrapper scripts to execute Ab Initio graphs and implemented Restart ability (Unix Shell Scripts).
• Scheduled the jobs using Maestro.
• Testing the graphs by Unit testing, UAT and Integration testing of ETL routines.
• Provided Technical support and hands on mentoring in the use of Abinitio.
• Overseen the quality procedures related to the project.

Environment: Abinitio, Teradata, UNIX, Maestro and Autosys

Confidential

Informatica Developer

Contribution:

• Understood the working and Domain of prestigious New York Stock Exchange
• Understanding User Requirements and Converting the user requirements in to English scripts
• Writing Automated scripts from English scripts and Enhancements in existing scripts
• Testing of scripts and Generating of scripts using DLE tool.

Environment: TCL/TK, UNIX