SUMMARY

• About 7 Years of total experience in Information Technology Industry with an of expertise in Reports Designing, Decision Support, Data Modeling, Business Intelligence ETL - Informatica 8.x/9/x, BODI and Data Warehouse applications, Worked extensively on Oracle, Teradata and MS SQL and SQL Server
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing Reports, testing, Migrating, Administration, security management and production support.
• Experience using Informatica 8.x and 9.x or used at least 1 year experience using informatica 9.x in a data warehouse environment including familiarity with warehousing concepts, design and development of complex mappings, experience merging data from multiple source systems including but not limited to ORACLE and flat files.
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, scheduling the Workflows and sessions using Informatica Power Center 8.6./9.1
• Worked in production support project so can execute development and support at different levels as per the necessity .Strong mapping skill by using various transformations like Sorter, Aggregator, Normalizer, Joiner, Expression Lookup, Router etc
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows. Experience with using UNIX scripting language
• Experience in Dimensional Data Modeling for creating logical and physical data models using a commercial data modeling tool like ERWIN
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions
• Strong experience building Dashboards (Xcelsius, Web Intelligence, Universe Layer or IDT)
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Alerts, Filters, Ranking, Graphs and Breaks
• Understanding the functional document and writing the technical documents
• Excellent communication and interpersonal skills working within multi-diverse teams Strong analytical and communication skills and an eagerness to learn new technologies

TECHNICAL SKILLS

Domain Knowledge: Healthcare, Manufacturing alcoholic Beverage, Human Resource

Tools: Business Objects, Business Objects Data Integrator 11.7, Informatica8x

Data base: Oracle10g, SQL Server 2005, Teradata 13

Languages: PL/SQL, C, C++, Java

Operating System: Windows XP/2000/98, Vista, Unix

PROFESSIONAL EXPERIENCE

Confidential, Dublin OH

Senior ETL Developer

Responsibilities:

• Analyzed the requirements provided by various business users.
• Worked on Scheduling workflows and sessions using Informatica scheduler and have implemented decision task and email task for tracking the successful completion
• Identify source systems, connectivity, tables, and fields to ensure data suitability for mapping
• Used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Designed and developed complex Informatica mappings using different transformations like Source qualifier, Aggregators, Connected & Unconnected Lookups, Update Strategy, Filter and Sequence Generator.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Work lets
• Created flexible mappings/sessions using parameters, variables and heavily using parameter file
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions Performance tuning of the mapping where goal was to insert thousands of rows to target by identifying bottleneck at target, source, mapping and session level.

Environment: Teradata 13.10, Oracle 10g, Informatica 8.0/9.1

Confidential, CT

Senior Developer (Informatica & Business Objects)

Responsibilities:

• Extensively creating database packages, procedures, functions, cursors and triggers using PL/SQL in Oracle 10g environment.
• Created Source and Target Definitions in the repository using Informatica
• Identify source systems, connectivity, tables, and fields to ensure data suitability for mapping
• Have developed wide variety of mappings and transformations using Informatica Powercenter 8.6.1 from simple to extremely complex mappings to satisfy the requirements
• Responsible for the Source system /object identification by doing the Reverse engineering into Informatica complex mappings Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer
• Used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager
• Populate or refresh Teradata tables using Fast load, Multi-load & Fastexport utilities for user acceptance testing and loading history data into Teradata
• Created various types of reports/sub-reports and drilldown reports, standard and crosstab reports with bar chart, pie-chart and line-chart graph representation reports using Business Objects.
• Developed complex mappings in Informatica 8.0 to load the data from various sources
• Used Informatica Power Center 8 for extraction, transformation and load (ETL) of data in the data warehouse

Environment: Teradata 13.10, Oracle 10g, SAP BO-XI R3, Informatica 8.0/9.1, Xcelsius 2008

Confidential, San jose CA

Reports/ ETL Developer (Informatica)

Responsibilities:

• Designed and implemented Dashboard for the pricing and discount team for their daily and monthly analysis using Xcelsius 2008
• Participated in project planning sessions with project manager, business analysts and team members to analyze business requirements and outline the proposed solution.
• Sourced the Webi reports into Microsoft excel and used Excel formulae to trim and manipulate data. Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporter
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL in Oracle 10g
• Have developed wide variety of mappings and transformations using Informatica Powercenter 8.6.1 from simple to extremely complex mappings to satisfy the requirements
• Developed Mapping/Session/ Worklet/Workflow variables and parameters, running Informatica Workflows and identify areas of optimizations
• Wrote highly complex SQL to pull data from the Teradata EDW and create AdHoc reports for key business personnel within the organization
• Involved in comprehensive end-to-end testing- Unit Testing, System Integration Testing, User Acceptance Testing and Regression Testing
• Providing solutions in the form of Graphs like Bar graph, Pie chart of the analysis and presenting to the client in order for them to understand the trend in an easy graphical ways.
• Conducting meetings with users, developers, and database design team to deal with backend synchronization issues
• Used Desktop version (DESKI) to create Reports

Environment: Teradata, 13.10, Oracle 10g, SAP BO-XI R2(Webi,Deski), Xcelsius 2008,Crystal Reports 2008,Informatica 8.0

Confidential

Reports /ETL Developer

Responsibilities:

• Involved in understanding the Requirements of the End users/ Business Analysts and developed strategies for ETL processes
• Created Parameterized, Cross-Tab, Drill down & Summary reports, utilizing charts and graphs using formulas, parameter prompts, Sorting, Functions, Group selection, and creation of LOV’s and Views
• Created Teradata BTEQ, Fastload, Mload, and TPump. Used Cotrol M to schedule the jobs
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure
• Created complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner and Update Strategy etc
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Analyzed the existing database and designed the Universes using the Business Objects Designer Module. Defined Business Objects Classes and Objects
• Interact with client teams to obtain a full understanding of the project requirements in order to recommend the appropriate technology to accomplish requirements
• Created mappings and loaded data into using Informatica 8.0

Environment: Teradata 7.1, Oracle 10g, SAP BO-XI R3, Xcelsius 2008, Informatica 8.0

Confidential

Jr.Reports/ETL Developer

Responsibilities:

• Analysis of the functionality of the Report using Report screen shot provided by the client
• Prepared Functional and technical specification for the Resources management Observer and request management system modules
• Session Performance is improved by creating multiple connections to sources and targets and loading data in parallel lines
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
• Migrated the reports from R2 to R3 and worked on fixing the bugs.
• Responsible for overseeingtheTesting at different stages-Unit testing and integration testing
• Performed ETL jobs using BODI for generating reports batch jobs and scheduled the Jobs.
• Created Data mappings and loaded the various data like flat file, Excel into Tables using BODI.
• Created Drill-Through Reports Custom Queries to provide users with more detailed information and query linking.
• Performed scheduling of the jobs
• Worked on Post production support for RMO and RMS
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database
• Testing of Business Objects and Reports which Includes

Environment: Oracle 10g, SAP BO-XI R2, BO

Confidential

Jr.Reports/ETL Developer

Responsibilities:

• Worked in creating technical Documents like Report Requirement specification (RRS), Unit test cases, Test Log, RRD (Report Requirement Design)
• Monitored and solved the issues encountered in Universes and reports while migration from R2 to R3 Environment.
• Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS
• Porting the reports to the production environment
• Monthly scheduling the reports to over 150 clients
• Working on Regular Change Request CRs
• Testing Reports after porting from development server to Production Server

Environment: Oracle 10g, SAP BO-XI R2, BODI