SUMMARY:

• Around 8 years of experience in IT industry in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial & Banking, Telecom Sectors.
• Strong Data Warehousing ETL experience of using Informatica 8.6 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Main area of experience has been in development, testing, deployment and monitoring of EAI projects TIBCO Active Enterprise suite of products.
• Developed Repos to reduce manual effort in rectifying CRM to BP rejects.
• Worked on several pallets including Http, File, Ftp, General, etc.
• Good Knowledge in Information Life Cycle Management using Solix EDMS 6.5 - Application Retirement.
• Expertise in ETL process using Informatica PowerCenter Designer, Workflow manager, Workflow monitor.
• Experience in developing Reports on Solix APM for the retired applications for legal and audit purposes.
• Good Knowledge on Teradata architecture and loading utilities.
• Extensive experience in Extract, Transform, and Load data into DataWarehouse/DataMart from different sources like Flat files, Oracle and Db2 tables.
• Hands on experience in mapping development using various transformations.
• Working knowledge on SQL and PL/SQL programming.
• Experience in Autosys for job scheduling, monitoring and provided production support on Autosys related issues.
• Experience in problem management involving problem managers and RTB Teams.
• Experience on UNIX commands, shell scripting.
• Hands on experience in tuning mappings, identifying and resolving bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experienced in creating technical specification documents like System design, Detail design, and Migration and Test Case documents.
• Experience in Code Review, Testing, Debugging and Error handling of Informatica
• Expertise in Production support, UAT support including error handling, system enhancements and fine tuning for performance improvement and also Skilled in Root cause Analysis and Problem solving skills.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, design, development, unit testing, systems integration and user acceptance testing and deployment.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business users, developers, teams across multiple disciplines.
• Have good knowledge of domains like Telecom, Finance & Banking.

TECHNICAL SKILLS:

DW Tools: Informatica Power Center 8.6, TIBCO Business Works 5.6,Solix EDMS 6.5, IBM WebSphere MQ.

Tools: TOAD, Quality Center, MS OFFICE, CCM.

Scheduling: Autosys.

Databases: Oracle 9i/10g/11g, MYSQL 4.6, Teradata, MS SQL.

Languages: PL/SQL, SQL, UNIX Shell Scripting, C++.

WORK EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Worked with Business to Understand and Analyze functional and technical requirements, Upstream and Down Stream systems.
• Created mappings for load in PowerCenter Designer using the transformations Expression, Connected Lookup, Unconnected Lookup, Aggregator, Union, Sorter, Joiner, Update Strategy, Sequence Generator, Router, Filter and Source Qualifier.
• Created Mapplets to reuse all the set of transformations for many mappings.
• Created work flows and sessions for each mapping that we are extracting from source systems to target.
• Coding, Code Reviews, Code Promotions to higher environments, Unit Testing for the code developed and deployment of the same in higher environments.
• Documented Functional Requirement, ETL Design, Code review, Unit Testing and Best Practices including Naming Conventions.
• User Acceptance Testing Support, Regression Testing Support and Post Production Deployment Support.
• Responsible to provide resolutions for production incidents/failures, user requests and problem tasks.
• Need to interact with business users, L1,L2,Upstream and downstream applications and ensure the smooth functioning of the application
• Responsible for L3 activities like providing RCA, Fix tasks, status reports, Knowledge transition.
• Responsible to fix the Production issues on an emergency Basis via Fire call access/emergency requests.

Assistant Systems Engineer

Responsibilities:

• Implementation of changes in CRM-Billing interface for any functionality Change Requests
• Developed Repos to reduce manual effort in rectifying CRM to BP rejects.
• Worked on several pallets including Http, File, Ftp, General, etc.
• Designed the Starter processes and sub processes by using TIBCO BW.
• Production Support and maintenance activities for the interface between CRM and Kenan FX Arbor BP (Billing Product).
• Casual Analysis and providing permanent solutions to the critical billing problems identified
• Provided quick resolution to the billing errors so as to ensure zero loss of revenue to the client.
• Playing a key role in SLA compliance reporting & monitoring
• Liaison with Solution Design and Development teams for resolution of critical production issues requiring design changes
• Worked with Business Unit representatives and Central Billing Operations for resolution of recurring issues
• Mentored the team of 5 members.
• Deployed and managed the engines in TIBCO Administrator.
• Identified potential problems due to CR rolled outs and suggested possible solution to mitigate the risk involved with rollouts.
• Code review for production fixes.
• Given Sessions to all team members and new joiners on complete Billing system.

Assistant Systems Engineer

Responsibilities:

• Activity involves migration of Backend and Host end code from current PA - RISC system to Itanium system Porting Application 32 bit to 64 bit.
• Backend involves migration from Oracle 9i to Oracle 10g.
• Host end involves migration from HP - UX 11.11 - HP UX 11.31 and up gradation of IBM MQ Series 5.3 to IBM MQ Series 6.0 as middleware MQ server application

Assistant Systems Engineer

Responsibilities:

• Worked with Business to Understand and Analyze functional and technical requirements, Upstream and Down Stream systems.
• FSS interfaces with the other systems in CCIL, i.e. Trading System and Clearing & Settlement System.
• FSS handles Funds settlement of CBLO for RBI and Non-RBI members. It handles intraday and overnight fund shortages for all settlement modules.
• It also manages LOC (Line Of Credit) of various designated banks which provides Line of Credit facility to CCIL to handle shortages for guaranteed funds settlement.
• FSS interfaces with non-RBI settlement banks for internet members in CBLO.
• FSS also prepares SWIFT files In MT format for CCIL and CLEAR CORP dealing members for charge transactions and Cash Withdraw/Deposit notice

Developer

Responsibilities:

• Study the existing system, worked with Users to Understand and Analyze functional and technical requirements and found the limitations of the current system.
• Requirements Gathering, Analysis and Designing.
• Programming using PHP, Html, JavaScript, CSS and MySQL.
• Completed testing the code and received signoff from the users.