SUMMARY

• Total 11 years of experience in requirements gathering, analysis, design Development, customization, testing and implementation of software Applications which includes Informatica Power Center, Data warehouse Administration Console(DAC) and Oracle Business Intelligence Enterprise Edition(OBIEE), Oracle Data Integrator(ODI),Hyperion - Essbase.
• Has very good experience on Business Intelligence reporting (10G & 11G) and Data Warehouse administration console(DAC).
• 5+ years of experience in handling BI Publisher reports.
• Extensively worked on Informatica power center 7.4.1,8.6 & 9.5.1 versions.
• Have very good experience on creating the cubes in Hyperion.
• Have extensively worked in developing program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Has experience in analyzing, building, testing, and implementing Repository, Reports and Dashboards using Oracle Business Intelligence technology platform
• Experience in developing dimensional hierarchies with drill down, aggregate tables, time series functions, and rank and shares functionality.
• Efficient problem-solver and decision maker with diverse experience in developing applications.
• Fast learner; possess keen analytical & troubleshooting skills for effective problem resolution.
• Experienced with ETL processes using Informatica Power center.
• Good experience on Structured Query Language(SQL) and Procedural Language/Structured Query Language(PL/SQL) Procedures,functions,packages,Triggers,Views Etc.
• Outstanding interpersonal skills to build a rapport with management, vendors, staff, peers and clients.
• Has sound experience in delivering the defect free product on time.
• Excellent resource balancing & leadership skills with an ability to drive initiatives through efficient team work.
• Is always driven by team spirit and we-will-work-together attitude.
• Experienced in setting up and working in multi-user development (MUDE) Environment
• Experienced in managing and coordinating Onsite/Offshore teams
• Well organized, good team player and self starter with a positive attitude. ability to quickly adapt to new technologies and business domain.

TECHNICAL SKILLS

ETL TOOL: Informatica Power center 9.5.1/9.0/8.6.1/8.1.1/7. x

ELT TOOL: ODI-ORACLE DATA INTEGRATOR

Oracle Tool: Hyperion - Essbase

OBIEE Infrastructure: Oracle Business Intelligence Enterprise Edition(OBIEE) 11g/10g

Databases: Oracle 11g/10x/9x, IBM DB2, SQL Server,VSAM,PLSQL,Teradata

Domain Skills: Retail Business Services,Insurance - Property & Casualty Insurance,PMSC5.3,Health Insurance

Tools: Data warehouse Administration Console (DAC) 10G & 11G

OPERATING SYSTEMS: OS/390, Windows 95, 98, 2000,XP,Linux,UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, Michigan

OBIEE/ informatica Lead

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Reviewed and analyzed functional requirements, mapping documents.
• Designed and developed RPD consists of Physical, BMM and Presentation layers
• Helped the client set-up Multi User Development (MUDE) Environment and provided a detail documentation of the approach to be followed by the developers.
• Re-Implemented security i.e. Object-level by creating roles & web groups.
• As per the support model, monitored daily loads through DAC scheduler. Debugged failed tasks and created/modified the execution plans in DAC.
• Implemented Custom web service in order to allow users to Change Password in OBIEE 11g.
• Responsible for migrating RPD and web catalog between different environments.
• Created tables, views in Teradata, according to the requirements.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Perform Teradata development support, including debugging, code maintenance, unit testing, change management, and promote to production methodology.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Debugged performance issues in existing Out-Of-Box RPD and implemented use of aggregate tables.
• Built BI Publisher reports for some of the projects using RTF templates.
• Built Custom dashboards for comparing data between Source and Target environments.
• Involved in User Acceptance Testing.
• Conducted POCs for the company and demonstrated some of the OBIEE 11g new features.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.2 /11.1.1.7 , BI Publisher 10g/11g, Informatica 7.4.1/8.6.1/9.5.1 , Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata12

Confidential, OHIO, Mason

Informatica developer

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Reviewed and analyzed functional requirements, mapping documents.
• Designed and developed RPD consists of Physical, BMM and Presentation layers
• Helped the client set-up Multi User Development (MUDE) Environment and provided a detail documentation of the approach to be followed by the developers.
• Re-Implemented security i.e. Object-level by creating roles & web groups.
• As per the support model, monitored daily loads through DAC scheduler. Debugged failed tasks and created/modified the execution plans in DAC.
• Implemented Custom web service in order to allow users to Change Password in OBIEE 11g.
• Responsible for migrating RPD and web catalog between different environments.
• Debugged performance issues in existing Out-Of-Box RPD and implemented use of aggregate tables.
• Built BI Publisher reports for some of the projects using RTF templates.
• Built Custom dashboards for comparing data between Source and Target environments.
• Involved in User Acceptance Testing.
• Conducted POCs for the company and demonstrated some of the OBIEE 11g new features.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.2 /11.1.1.7 , BI Publisher 10g/11g, Informatica 7.4.1/8.6.1/9.5.1 , Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata

Confidential, Columbus, OHIO

OBIEE Developer

Responsibilities:

• Analysis on Task assigned
• Discussion with the onsite members obtaining the requirements for the preparation of the document to cover the technical issues and correcting Task.
• Sending MOU (Module of understanding) to OSC.
• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Developed ETL programs using Informatica to implement the business requirements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Performed data manipulations using various Informatica Transformations.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Reviewed and analyzed functional requirements, mapping documents.
• Designed and developed RPD consists of Physical, BMM and Presentation layers
• Designed, developed and Customized reports and dashboards using different analytical views
• Configured dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Time Series.
• Developed different kinds of reports (pivots, charts, tables) using global and local filters.
• Implemented Data level and Object level security.
• Worked in Multi user development environment(MUDE).
• Code Review.
• Involved in unit testing and production support as well as documentations.
• Sending UTR to OSC.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, OBI Administration, Informatica Power center 9.0/8.6, Oracle BI publisher, Oracle Delivers, UNIX/LINUX,Oracle11g/10g,SQl, PL/SQL,Teradata.

Confidential, Fortmeyers, FL

Informatica Developer

Responsibilities:

• Designed and developed metadata consists of Physical, BMM and Presentation layers
• Designed, developed reports and dashboards as per requirements
• Implemented cache, security (Data and Object level)
• Involved in the development, migration and merging of code with the off shore team.
• Participated in various conference room pilots and User Acceptance Tests (UAT).
• Managed and coordinated offshore and onsite development teams.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Informatica 8.6, Oracle 8i, UNIX, SQL server, Windows NT 2000.

Confidential, New Jersey.

Informatica Developer

Responsibilities:

• Coordinate with application team and develop all ETL processes.
• Understand the ETL specifications and build the ETL applications like Mappings on daily basis.
• Create the mappings, sessions and Workflows as per requirement of business to implement the logic.
• Perform the Unit Testing on developed code.
• Create a mapping document based on High level design document.
• Responsible for preparing the Satyam Quality Documents.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Informatica 8.6, Oracle 8i, UNIX, SQL server, Windows NT 2000.

Confidential, Sun Prairie, Wisconsin

Informatica Developer/Oracle Developer

Responsibilities:

• Assisted in Design of physical & logical models.
• Interface with Sales and Production Management Team to capture and analyze business strategic requirements.
• Developed many mappings / mapplets using various transformations for extract and loading the sales data.
• Involved in the performance tuning of mappings.
• Provided support to report developers in developing the reports.
• Created Database procedures, Packages, functions to handle data manipulations and Computations on Server.
• Designed and developed Oracle Monthly Reports.
• Modified, Maintained and Developed the SQL,PL/SQL codes to develop new enhancements
• Develop and maintain the documentation to support the team and business
• Responsible for preparing the Satyam Quality Documents.

Environment: Oracle 9i/8i, SQL Server 2000, Informatica Power Center 7.1, UNIX Scripting (Ksh), Sun Solaris 7, Windows XP Professional.