SUMMARY

• Total 11 years of experience in requirements gathering, analysis, design Development, customization, testing and implementation of software Applications which includes Informatica Power Center,DatawarehouseAdministration Console(DAC) and Oracle Business Intelligence Enterprise Edition(OBIEE),Oracle Data Integrator(ODI),Hyperion - Essbase.
• Has very good experienceonBusiness 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, ReportsandDashboards 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.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Training based knowledge on Rulepoint.
• 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 10.2.1/10.1.1 /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,salesforce.com

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

Tools: Data warehouse Administration Console (DAC) 10G & 11G, CA-7

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

PROFESSIONAL EXPERIENCE

Confidential, Fountain Valley, California

Informatica and OBIEE Developer

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Developed Informatica workflows/worklets/sessions associated with the mappings across various sources likeXML,COBOL,flat files,Salesforce.
• 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.
• Utilized Informatica IDQ Data Analyst,Developer for dataprofiling and matching/removing duplicate data,fixing the bad data,fixing NULL values.
• 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.
• Working on production support tickets. Monitoring the loads as part of support process.
• 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 /11.1.1.9/12.2.1 , BI Publisher 10g/11g, Informatica 7.4.1/8.6.1/9.5.1 /10.1 , Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata

Confidential, Dearborn, Michigan

Informatica developer

Responsibilities:

• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Understand and translate business needs into data models supporting long-term solutions.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Reviewed and analyzed functional requirements, mapping documents.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Involved in analyzing, defining, and documenting data requirements by interacting with the client andSalesforce team for the Salesforce objects
• Designed and developedRPD 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.
• Scheduled the tasks using Autosys.
• 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 10.2.1/10.1.1 , Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata12,salesforce,Autosys.

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.
• Developed Informatica workflows/worklets/sessions associated with the mappings across various sources likeXML,COBOL,flat files,Salesforce.
• 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.
• Utilized Informatica IDQ Data Analyst,Developer for dataprofiling and matching/removing duplicate data,fixing the bad data,fixing NULL values.
• 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 developmentenvironment(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

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