PROFESSIONAL PROFILE

• Eleven plus years of total IT experience in supporting RDBMS based applications which involve programming with Informatica ,Oracle Pl/Sql and Project Management Skills.
• Good Knowledge in working with Informatica Power Center 9.0.1/8.x/7.x Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor .
• Well acquainted with Informatica Designer Tools like Source Analyzer, Transformation Developer,
• Mapping Designer, Mapplet Designer.
• Well versed with Relational and Dimensional Modeling techniques like Star, Snowflake Schema,
• OLAP, Fact and Dimensional Tables.
• nvolved in most phases of software development life cycle like design, implementation, testing and documentation.
• Has successfully completed several projects and quite comfortable in working with a team.
• Expert in writing procedures, triggers, packages and functions.
• Conducted Oracle basic training to new recruits in Accenture.
• Involved in conducting interviews as part of the IBM Technical Interview panel for the DBMS competency.
• Has excellent database performance analysis and tuning skills.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Worked on Manufacturing, Telecom financial domains
• Oracle Certified Associate.

TECHNICAL SKILLS

Programming Languages Technologies

• Java ,JSP, UML Hibernate JDBC Technology
• C , VC
• Visual Basic

RDBMS and Related Tools

• Oracle 8i, 9i, 10g 11g
• Terradata
• SQL Server MySql Server
• Informatica Power Center 9.0.1/8.x/7.x, Informatica Power Exchange 8.x.
• Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling,
• FACT and Dimension Tables, Physical and Logical Data Modeling,
• PL/SQL Developer Toad
• Jasper Report Tools

Operating System Other Tools

• Windows NT/2000 Server
• HP-UNIX 11.1
• Tivoli Terradata Red Scheduler
• Visual Source Safe
• Unix Shell Scripting

Oracle R12 -Trained

• Inventory
• Order Management Purchasing
• BOM ,Configurator Basics

PROFESSIONAL EXPERIENCE:

Confidential

Oracle 11g ,Toad, Informatica Power Center 9.1/8.6

Responsibility:-

• Responsible for development, testing and implementation of Business Intelligence solutions for Global Billing system Team of CITI North America.
• Responsible for leading a project team from Onsite delivering solutions to our customer
• Handled Multiple release from tbs UAT support
• Responsible for effective communication between the project team and the client.
• Provide on call monitoring status report on a daily basis to update the daily status of various project activities.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Used Informatica -Designer for developing mappings, using transformations, which includes aggregation, Updating, lookup, and summation. Developed sessions using Server Manager and improved the performance details.
• Created transformations like Aggregate, Expression, Filter, Sequence Generator, Joiner, and Stored procedure transformations.
• Creating technical spec, functional spec, Coding.
• Working as Senior Team member.

Programmer Analyst in Cerebra consultancy-In-house Project

Confidential

• Three month in-house project for database design
• Developed mappings and mapplets using Informatica Designer
• Creating technical spec, functional spec, Coding.
• Worked as Senior Programmer

Confidential

Technology used:-

Informatica Power Center 9.1/8.6,Oracle 11g ,Toad, Unix shell scripting,

Responsibilities follow:

• Creating technical spec, functional spec, Coding, Unit testing Integration testing.
• Participated in data modeling logical and physical for designing the Data Marts for finance, Sales, Billing.
• Developed standards and procedures for transformation of data as it moves from source systems to the data warehouse.
• Created Technical design specification documents based on the functional design documents and the physical data model.
• Developed mappings to extract data from Oracle, Flat files,load into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Involved in versioning the whole process and retiring the old records using the built-in's DD UPDATE, DD DELETE, and DD INSERT
• Enterprise and managed the business process.
• Involved in design and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• After Assigning the task to the team ,I Ensure that development is performed as per requirements.
• Guiding the team in Pl/SQL Technical issues. In Oracle Packages, Functions ,Data Load, Dynamic Sql.
• Reaching to right people to resolve the dependencies.

Involved in Project Management activities

• Prepared Integration Project Plans
• Dependency agreements are made available from corresponding application teams.
• Conducted regular meetings with application and client teams.
• Tracking the project status periodically.
• Prepared and published Weekly Reports to Stake Holders.
• Involved in SQA activities.

Confidential

Technology used:-

Informatica Powercenter 8.6.0, Oracle 10g, UNIX, Windows XP.

Oracle 11g ,Toad, Unix shell scripting

Responsibilities follows:-

• Extensively used Informatica to extract data from various data sources like flat files, oracle database, SQL Server to load them into the Customer Data Warehouse CDW .
• Developed the Informatica Mappings, Mapplets, Sessions and Workflows to populate the the required dates
• Created mappings using fact and dimensional tables from Data modeling.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Performed the uploading and downloading of flat files from UNIX server.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables.
• Converted the old PL/SQL Procedures to Informatica mappings.
• Installed Informatica Client tools on client machines and Created Repository as well as assigned permissions for user groups.
• Involved in Project Management activities
• Prepared Integration Project Plans
• Dependency agreements are made available from corresponding application teams.
• Conducted regular meetings with application and client teams.
• Tracking the project status periodically.

Prepared and published Weekly Reports to Stake Holders.

Involved in SQA activities.

Confidential

• Technology used:- Oracle 10g ,Toad, Unix shell scripting
• Responsible for development, testing and implementation of Business Intelligence solutions for Global Data warehouse Team of Heinz North America.
• Responsible for leading a project team in offshore delivering solutions to our customer in the Retail sector.
• Responsible for Assigning the minor enhancement to my team members and make sure team is completing the task without much delay.
• Responsible for handing minor enhancements, planning, tracking, change control aspects of the enhancements
• Responsible for effective communication between the project team and the client. Provide on call monitoring status report on a daily basis to update the daily status of various project activities.
• Translate customer requirements into formal work request form documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of
• the results.
• Utilize in-depth knowledge of functional and technical experience in PL/SQL technology and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
• Responsible in handling Production issues like Performance issues, Job failures, fixing the corrupted Indexes, data Load issues in SQL Loader.
• Worked on year end activity by writing a Oracle package which cleans the History data and adding the required departments
• Dynamically Dynamic SQL in the Oracle Procedures.
• Involved in Unix shell scripting using oracle pl/sql programming.

Confidential

Senior Team Member

• Responsible for Analysis, design, development, testing and implementation of Business Intelligence solutions for BRAINS Team of Vodafone Greece, Australia New Zealand.
• Worked with business analyst in translating business requirements into functional requirements document and created detailed design documents.
• Lead analysis sessions, gather requirements and write specification and functional design documents for enhancements and customizations and help analyze product impact.
• Coordinate and communicate with onshore Subject matter expert.
• Ensure that development is performed as per requirements.
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product.
• Communicate activities/progress to project managers, business development, business analysts and clients.
• Handled Level1 Support for Vodafone Australia and New Zealand.