PROFESSIONAL SUMMARY:

• Overall 10+ years of experience in IT industry where involved in Design, Development, Unit testing and Enhancement of various project using Informatica Powercentre 9.1.1&Reporting Tools.
• Having 6 Years of extensive experience in Banking and financial Domain - Investment banking, & Regulatory reporting
• 2+years of experience in AXIOM SL Regulatory Reporting Tool - Controller View, to develop reports for US region
• 5 years of experience in ETL development using Informatica Power center 9.1.1 and BI Tool( Business Objects XIR2/ 3.1)
• Expertise in preparing SQL queries in SQL server (2005/2008)
• Good Knowledge and experience in Autosys 4.5/UNIX.
• Expertise in VB scripting and developing Excel Macros.
• Expertise in preparing weekly and daily status reports.
• Conducted Triage calls with Product support teams and Business Analysts for discussions on application issues
• Experience in building unit test cases, class diagrams, functional flows & data flow diagrams and Project PPTs.
• Participated in implementation and post implementation defect testing and support.
• Ability to easily grasp and put into application new ideas, concepts, methods and technologies into the application.
• Well organized and able to prioritize, organize, and coordinate tasks and projects.
• Excellent communication, interpersonal skills, customer focus skills along with a good understanding of business processes.

TECHNICAL SKILLS:

Operating Systems: Windows NT, Windows XP, Windows 7

ETL Tools: InformaticaPowercenter v 9.1.1/8.x

Reporting Tools: Axiom SL Controller view 8.6,SAP Business Objects XIR2/3.1

Scheduling tool: Autosys 4.5

Defect Management: HP Quality Center v9.x

Servers: IIS, Apache, Web logic, Web sphere, SQL Server.

Databases: SQL Server 2000/2005, Sybase 12.1

Others tools: Unix,BO SDK, Java EE5, JSP 2.1

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Development &Automation of regulatory reports (FRY15 and FR2900 part of Dodd and Frank section 165) using AXIOM SL Controller view.
• Suggesting innovative ideas so as to make simpler designs and hence reduce the time of development, making the maintenance easier and hence reducing the cost of developing and maintaining the application.
• Interacting with business users for requirement understanding
• Creating and Reviewing the Technical Design Documents (TDD).
• Build data sourcing, data models, loading and extraction interfaces for Axiom Controller view
• Develop portfolio, Short hands, favorites and aggregation modules, free-form and tabular reports.
• Implementation of the design within the stipulated timelines.
• Perform Unit Testing, generate results and support QA and User Acceptance Testing
• Offer production support for the Axiom platform for filing activities
• Automate the batch process using Autosys scheduling tool
• Handling of SDLC throughout requirement, estimation, implementing, testing, and deployment

Environment: AXIOM Controller View 8.x, InformaticaPowercentre 9.1.1, Business Objects XI R3.1, UNIX and SQL Server 2008.

Confidential

Responsibilities:

• Requirement gathering and Estimation. Conversion of functional requirements into technical requirements and stake holder handling.
• Reports and dashboard development based on the user’s Request.Research on the existing Universe.
• Involved in development, Enhancements, and testing coordination for both universe and Reports.

Environment: Business Objects XI R3.1, InformaticaPowerCenter 9.1.1, Autosys 4.5, UNIX and SQL Server 2008.

Confidential

Systems Analyst

Responsibilities:

• Modified Crystal Reports based on the user’s Request in Crystal Reports 9.
• Involved in Issue Analysis and Research on the existing Report templates.
• Understand the functional specifications and Use cases.
• Involved in Enhancements, and testing coordination for crystal Reports.

Technologies: Crystal Reports 9, InformaticaPowerCenter 9.1.1, Squirrel 3.1.1 and Teradata 13.10.

Confidential

Technical Lead

Responsibilities:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Used various transformations like Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.

Technologies: InformaticaPowerCenter 9.1.1,Business Objects XI R3.1, Web Intelligence Reports, Desktop Intelligence reports and SQL Server 2008.

Confidential

Senior Software Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: InformaticaPowerCenter 8.6.1, Business Objects XIR 3.1/2, Crystal Reports2008, VB Script with SQLServer 2005 and Sybase 12.0

Confidential

Software Developer

Responsibilities:

• Understanding the client’s request.
• Involved in coding for communicate Java EE5, JSP 2.1 with RDBMS.
• Done Unit testing.

Environment: Java EE5, JSP 2.1, JAVA SCRIPT with SQL SERVER 2000.

Confidential

Responsibilities:

• Understanding the client’s request.
• Involved in coding for communicate Java EE5, JSP 2.1 with RDBMS.
• Involved in unit testing

Environment: Java EE5, JSP 2.1, JAVA SCRIPT with SQL SERVER 2000.