Objective

A Highly dynamic, team-spirited, and results-oriented individual seeking further challenges as Dataware house Developer. Or related position where a diverse background and proven technical expertise will be utilized and advanced.

Professional Summary

A Versatile, Self- Motivated, Accomplished, and Creative Professional with 3.8 Years of Total IT experience which includes around 1.8 Years with Deloitte Consulting and 2 years with Tata Consultancy Services Ltd.

My main area of experience has been project delivery of various sizes. I have worked primarily in the domain of financial services and banking.

Expertise includes Competence in:

• Excellent Analytical, Problem-solving, and Troubleshooting ability
• Excellent in Informatica 8.1 PowerCenter.
• Performance Monitoring and Improvements
• Proficient in writing SQLs and PL/SQL.
• Excellent Experienced in performance tuning of mappings and sessions.
• Experience in Data Modeling using Kalido.
• Experience in Reporting tools using Hyperion and Cognos.
• Proficient in writing Shell Scripts.
• Strong analytical, communication, and interpersonal skills.

Software Skills

Programming Languages: Informatica, SQL, PL/SQL, Unix, Shell Scripting.
Operating Systems: HP UNIX, Windows Family.
Database: Access, Oracle 9i – SQL, PL/SQL
Tools: Informatica Power Centre, Toad, PL/SQL, Hyperion, Cognos, Kalido.
Certifications: Oracle Certified Associate (OCA) with 92%,
FTC certified in Banking competency and Investment banking.

Education: Bachelor’s in Information Technology.

Key Achievements

• Developed \'PACE\' tool which acts monitoring tool for reports and other jobs
• Developed multithreading concept in jobs for the first Time.
• Won accolades for having mastered the product and gaining excellent domain knowledge in a very short span of time. Considered one of the top performers in the project.
• Received appreciation award from Client for outstanding contribution as a Team member for the Agilent Project.

Professional Experience

Client: Confidential.
Role: Team Lead.
Mar 2009 – Jun 2009.
Informatica with Oracle and Flat File as Sources, Oracle, Kalido as Data modelling tool and Cognos reporting tool.

Worked as Analyst and support professional for maintaining EDW, Informatica tool was used by all developers for managing Data. Reporting is done using Cognos tool. Data modeling done using Kalido tool.
Main responsibilities are:

• To work on Source Data Analysis to validate the feasibility of Model and give suggestions to improve/modify the Business Model.
• To help in bringing the Business Model Design completion.
• To Design Informatica & Kalido Mappings and document them.
• To decide the loading strategy for Facts & Dimensions.
• Develop Informatica & Kalido Mappings.
• Review and Unit test the developed code.
• Preparation of Automation scripts.

Confidential,Client: Confidential,
Role: Analyst.
May 2008 – Mar 2009.
Informatica with Oracle, Flat Files and SAP as Sources, Oracle and Hyperion reporting tool.

Worked as Analyst and support professional for maintaining EDW, Informatica tool was used by all developers for managing Data. Reporting is done using Hyperion tool.

Main responsibilities are:

• Develop, test and Support Customer facing reports.
• Developed new functionalities for alerting customer about the failure of processes and ways to automate it.
• Analyze functional design documents for technical feasibility
• Understand business process and draft technical design documents based on the functional documents.
• Involved in the Change Management process of the move to production.

Confidential,Client: Confidential,
Role: Assistant System Engineer.
Nov 2005 – May 2008.
Informatica with Cobol, Oracle on Unix OS, Shell Scripting.

Worked as Data Warehouse developer using Informatica Power Center/Power Mart (8.1) for ETL (Extraction, Transformation and Loading) of data from multiple source database systems to Data Warehouses in UNIX/Windows environment. Involved in OLAP data modeling,for both Star Schemas and Snowflake Schemas.
Main responsibilities are:

• Designed data mart for large database and developed ETL in Informatica 8.0 Tool which extracts 100GB per hour. Updated all COBOL programs to ETL tool(Informatica) and PL/SQL.
• Developed mappings for Customer, Product, Premise and Campaign dimensions, implementing the ETL logic provided as part of the Technical Specifications.
• Created UNIX shell scripts to automate the generation of parameter files for the various mappings and sessions, and to execute various SQL/PLSQL Scripts
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Worked Extensively in the development of Core Banking project, which is a centralized banking solution for State Bank of India, the world’s largest bank with over 9000 branches.
• Involved in new development, performance tuning and application support.
• Developed multithreading concept in jobs for the first Time.
• Developed ‘PACE’ tool for SBI which acts monitoring tool for reports and other jobs. Tools: Perl, HTML.

Trainings undertaken:

• Training on various tools of informatica, including Power center, Power Analyzer.
• Training on Banking Concepts, Core Banking software and COBOL organized by Tata Consultancy Services.
• Initial Learning Program (ILP) in Trivandrum organized by Tata Consultancy Services.