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).
• 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/StructuredQueryLanguage(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

ODI: ORACLE DATA INTEGRATOR

Hyperion: Essbase

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

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

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, OHIO, Mason

Technical Lead-OBIEE

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

Confidential

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 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.

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

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.