Professional Summary

• Around 10 plus years of experience on various Business Intelligence BI and Data Warehouse DW implementations, implementing Oracle BI packaged solution, Custom Warehouse and Near Real Time Analytics.
• Strong expertise in enabling BI Applications across CRM and ERP Analytics such as Sales Analytics, Trade Analytics, HR Analytics, and Financials Analytics.
• Experience and knowledge across all the phases of the implementations - requirement gathering and analysis, design, development, testing, implementation and support of BI/DW.
• Expertise in Dimensional Modeling adhering to basic Data Warehousing principles
• Strong experience in designing and architecting the BI Solutions across various industries and processes.
• Excellent communication and presentation skills. Strong team-builder with proven experience of contributing in cross-functional teams to fulfill corporate IT goals.
• Experience in leading project teams and executing various projects using the classic 4th generation onsite-offshore outsourcing model as an onsite coordinator.
• Experience in pre sales activities, responding to RFP/RFI, conducting POC, tool evaluations etc.
• Oracle appointed official trainer for OBI Apps and Oracle Golden Gate, conducted classes in North and South America.
• Worked on providing Data Warehousing solutions in Customer Relationship Management, Hiring Analytics, Financial Services, Human Resource and Manufacturing with major clients like 20th Century Fox, Google Inc., SEI Investments, Solid Works, Charles Schwab and General Electricals respectively.

Technical Skills:

OS Platforms : Windows 95/98/2000/NT, DOS, UNIX, LINUX

Database : Oracle 8i, 9i, 10g, 11g, SQL Server 2005, MS Access, My SQL, DB2

ETL Tools : Informatica Power Center 5.1, 6.2, 7.1, 8.1, 8.6, Informatica Power Exchange 5.2.2, Kinetic ETL, Oracle Golden Gate, Oracle Data Integrator Stand Alone 11.1.1

Oracle BI Apps : OBIA 7.8.4, 7.9.6, 7.9.6.2

Reporting Tool : Business Object 5.2, OBIEE 10.1.3.3

Languages : C, C , SQL, PL/SQL, Shell Script Scheduling Tool : DAC 7.8.4, DAC 10.1.3.4, Control-M

Other Tools : Erwin, PVCS, Star Team, Visio, Toad, SQL Developer, Putty, MS Office, Visio, Edit Plus, Ultra Edit.

Professional Experience

Confidential

BI Solution Architect

• Wipro's solution definition team is a dedicated team to look into the current industry trend and help organization build industry based solution and take those solutions to the customer. The team also works closely with the Sales team in analyzing and responding to customer floated RFP's, day to day activities comprises of
• Working with Business Managers to respond to RFI/RFPs
• Develop business proposals and Proof of Concepts PoCs instances.
• Provide technical/project consultancy in support of sales
• Participate in pre-sales calls
• Develop client centric demonstrations
• Deliver value-based customer presentations and demonstrations.
• Poc's Worked On:
• o Retail Executive Dashboard
• o Customer LTV
• o Hadoop Cluster Setup
• o Automation of BI Data Lineage report
• Achievements
• o Added new logos for Wipro
• o Involved in account mining for some key account
• o Participated and led customer workshops

Confidential

BI Solution Architect

• Kaiser Permanente team wanted to enhance their analytical reporting capabilities out of there People Soft HR system by leveraging OBIEE Apps out of Box Dashboard and reporting functionality for HR Analytics application.
• Key subject areas like HR Compensation, HR Sick Leave were already enabled and they wanted to extend their capabilities for HR Recruitment.
• In this phase Kaiser HR wanted to slice and dice there Recruitment data for Requisition, New Hire and Application pool around Requisition, hiring and application status, Applicant Specialty, Applicant Residency program attended by Medical School, Source of Application etc.
• Study the existing transactional source system.
• Performed gap analysis between out of box OBI solution and requirements.
• Data Model Design to extend reporting capabilities
• Involved in Analysis of performance bottleneck in reports and Database.
• Supported team in carrying out users acceptance testing, issue analysis/resolution.
• Involved in migration document review and enhancement.

Confidential

Architect

• 20th Century Fox has data related to Product/Title spread across different system. Each system has some or the other information related to the Product/Title. In order to provide one single version of truth for Product/Title it was decided to construct a master data hub which will be acting as a single source for Title level information across the organization, Informatica MDM Suite was acquired to leverage the same.
• In the first phase of project around ten source systems like WPR, JDE Vault, Air Date, Rovi Intl etc. were identified for Product/Title level information, where each sources uses different technology to store and expose data out to MDM hub.
• Study different source systems.
• Performed data profiling on different source system.
• Involved in db model design to integrate data from different source system and load into MDM Hub.
• Architected the integration from different source systems, whereas each source system uses different technology to expose data like Oracle View, DB2 tables, multi tab excel sheet, Web Services etc.
• Involved in Project planning and coordination between inter and intra team
• Supported team in carrying out users acceptance testing, issue analysis/resolution.

Confidential

BI Solution Architect

• Schwab HR team wanted to enhance their analytical reporting capabilities out of there People Soft HR system by leveraging OBIEE Apps out of Box Dashboard and reporting functionality for HR Analytics application.
• Key subject areas like Compensation, Performance Review Rating and Workforce Profile were enabled using OBI Apps adapter for People Soft. Recruitment subject area was enabled using customized/universal adapter to source data from third party recruitment vendor.
• Study the existing transactional source system.
• Performed gap analysis between out of box OBI solution and requirements.
• Designed interface to source data from third party to enable Recruitment Analysis subject area.
• Involved in Analysis of performance bottleneck in reports and Database.
• Involved in setting up failover Informatica and DAC server.
• Supported team in carrying out users acceptance testing, issue analysis/resolution.
• Involved in migration document review and enhancement.

Confidential

Data Integration Architect

• Ascentt is a leading provider of enterprise application implementation services, specializing in Business Intelligence, Data Warehousing, Customer Relationship Management and Application Integration. Ascentt recently added Oracle Golden Gate Services to its implementation portfolio and wants to demonstrate Oracle Golden Gate for OBIEE analytics reporting in the upcoming Oracle Open World 2010, San Francisco
• Involved in setting up Oracle Golden Gate server.
• Involved in setting up initial load for Siebel CRM from earlier version to Siebel 8.1.1
• Architected/Implemented Operational Reporting using Oracle Golden Gate for Siebel CRM sales planning subject area.
• Architected/Implemented Real Time BI reporting using Oracle Golden Gate for Siebel CRM sales planning subject area.
• Setup of the demo environment.

Confidential

• BI Solution Architect In early 2010 Solid Works launched an Analytics Upgrade initiative in coordination with their Siebel Application upgrade. Solid Works is in the process of upgrading from BI Apps 7.8.4 to 7.9.6.1 BI Platform 10.1.3.4.1 . In the process they have encountered some product issues as well as data issues, both, on the ETL side as well as RPD/Dashboards side. These issues need to be addressed before July 17th, 2010 Go Live with the new version of OBIEE.
• Solid Works has contracted out the management of UAT and PROD environments to a third party service provider NAVISITE .
• Study of the list of issues found while upgrade/data migration to newer version.
• Study of proposed/existing TO BE server topology.
• Involved in Analysis of performance bottleneck in reports and DAC Full/Incremental Load.
• Coordinated with Oracle product team to resolve product/process bugs.
• Worked closely with Solid works Solution Architect in resolving DAC Execution plan configuration for out of box and custom Solid works ETL jobs.
• Supported team in carrying out users acceptance testing, issue analysis/resolution.
• Involved in setting up best practices for any future enhancement and there documentation.
• Involved in migration document review and enhancement.

Confidential

Solution Architect

• Global Siebel Trade Spend provides a platform to Fox Home Entertainment to standardize and integrate trade spend processes in one system for both international and Domestic.
• Global Siebel Trade spend helps sales planning and finance to capture discounts, MDF, Placement, Rebate, it also help them to tie up trade spend with the currently running customer promotions promoted Deal and also support time based deals that are not associated with any promotions Non Promoted Deal .
• Global Siebel Trade spend also helps in capturing Claims from different system for the deals offered and help able to calculate open, disallowed, expired and overage amount at component level.
• Study new components that business wants to add as part of Global Siebel release.
• Studying the feasibility to merge the Domestic component with the existing International system
• Analysis of the Business Process to be implemented and helping business to shape business requirement
• Design of star schema model using Erwin tool covering all fact, dimension, rule, helper and stage tables
• Design and Documentation of ETL specification based on the analysis
• Designed end to end process to capture new subject area from various sources to warehouse and configuring new subject area in DAC.
• Involved in Project planning
• Created Interactive Dashboards and Reports for Trade Spend with different Analytic Views Drill-Down, Pivot Table, Chart, Column/View Selector, and Tabular with dashboard and page prompts .
• Worked on the enhancement of some of the existing reports
• Configured automated iBot queries to obtain Data Integrity check report.
• Involved in setting up the production environment and migration
• Involved in supporting and carrying users acceptance testing across different territory

Confidential

Data Integration Solution Architect

• Global Siebel Sales Planning provide a platform to Fox Home Entertainment International to standardize and integrate sales planning processes in one system for both international and Domestic, view data across all territories, allow users to easily monitor the business from a sales perspective, Provide a true bottom-up customer-specific Promotion Planning volume and revenue functionality, Provide the ability to measure and evaluate promotion actual results vs. plan and prior year, share promotional strategies and plans.
• In Global Siebel Sales Planning Siebel Analytics release is a step to integrate both International and domestic territory as one single platform.
• It also included introduction of new components like Point of Sales POS , Trade Spend, Fund Management and Golden Plan Capture.
• Study the AS IS components of Domestic system
• Study new components that business wants to add as part of Global Siebel release.
• Studying the feasibility to merge the Domestic component with the existing International system
• Analysis of the Business Process to be implemented in close conjunction with the Business
• Analysis of existing Customized OBIEE 7.3 repository in comparison to out of Box OBIEE 7.5 repository
• Design of star schema model using Erwin tool covering all fact, dimension, rule, helper and stage tables
• Design and Documentation of ETL specification based on the analysis
• Designed end to end process to capture new subject area from various sources to warehouse
• Designed/introduced new subject area data integration on a near real time basis.
• Involved in upgrade of OBIEE 7.3 custom repository and webcat to OBIEE 7.5.
• Involved in DAC configuration change in order to support real time and batch replication process handshake.
• Involved in Project planning and coordination between inter and intra team.
• Involved in supporting and carrying users acceptance testing across different territory

Confidential

Real-Time Integration Architect

• Siebel International Sales Planning provide a platform to Fox Home Entertainment International to standardize and integrate sales planning processes in one international system, view data across all international territories, allow users to easily monitor the business from a sales perspective, Provide a true bottom-up customer-specific Promotion Planning volume and revenue functionality, Provide the ability to measure and evaluate promotion actual results vs. plan and prior year, share promotional strategies and plans.
• In International Sales Planning Siebel Analytics Real Time Conversion phase Siebel data mart needs to be refreshed in a near real time basis for product and promotion planning and measures.
• Study the feasibility to convert the Siebel Warehouse refresh rate on a near real time basis
• Involved in POC/Tool Analysis, Golden Gate vs Informatica Power Exchange.
• Analysis of the Business Process to be implemented in close conjunction with the Business Analyst
• Design of star schema model using Erwin tool covering all fact, dimension and stage tables
• Design and Documentation of ETL specification based on the analysis
• Deigned the process to leverage the existing batch process along with near real time process on a need basis.
• Involved in DAC configuration change in order to support real time and batch replication process handshake.
• Involved in Project planning and coordination between inter and intra team.
• Involved in optimization of the overall real time replication process.
• Involved in supporting and carrying users acceptance testing across different territory