PROFESSIONAL SUMMARY:

• Around 13 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.
• Experience in defining BI Strategy and Roadmap, helping Organizations to achieve the real value out of their BI Initiatives.
• Strong expertise in enabling BI Applications across CRM and ERP Analytics such as Order Management, Supply Chain, 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.
• Well versed with Big Data Concept and cluster setup

TECHNICAL SKILLS:

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

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

ETL Tools: Informatica Power Center 5.1, 6.2, 7.1, 8.1, 8.6,9.1 Informatica Power Exchange 5.2.2, Kinetic ETL, Oracle Golden Gate, Oracle Data Integrator 11g

Oracle BI Apps: OBIA 7.8.4, 7.9.6, 7.9.6.2, 7.9.6.3, 7.9.6.4, 11.1.7.1

Reporting Tool: Business Object 5.2, OBIEE 10.1.3.3, OBIEE 11g, Oracle BI Publisher, Tableau 8.0

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:

Financial Fraud Analytic

Confidential, Dallas, Tx

Responsibilities:

• Involved in defining the KPI’s required for risk scorecard
• Performed Gap Analysis and Data Profiling for the available data
• Developed Proof of Concept on Tableau
• Modelled Logical and Physical data model to meet current and future need
• Architected Metadata Layer(OBIEE RPD), for Fraud Analytic report/dashboard to be reported along with other Analytical application
• Worked with front end developer to design reports/dashboard
• Architected and modelled ETL(Informatica) load strategy and staging area
• Worked with team to resolve issues.

Confidential, Dallas, Tx

BI Solution Architect

Responsibilities:

• Unleashed and configured Oracle provided Out of Box HR Workforce Analytic
• Business Requirement Analysis and Feasibility Analysis with myHR(People Soft)
• Performed Gap Analysis between Oracle Out of Box HR Analytic and CBRE myHR Analytic requirement.
• Performed Gap Analysis between myHR and FPO common dimensions, like COA, Line of Business (LoB), Business Unit etc.
• Performed requirement gathering across Geo’s for data and object level security.
• Architected and Implemented data/object level security and its provisioning.
• Architected Data Model to suffice CBRE custom myHR Analytic requirement.
• Performed Data Analysis and identified data gaps in existing CBRE myHR(Peoplesoft)
• Involved in creation of data dictionary for the base and derived KPI’s
• Architected ETL Full/Incremental data load strategy, in conjunction with Financial Data analytic load
• Designed OBIEE RPD and involved in Report Design
• Reviewed Reporting and ETL technical design documented
• Planned and executed environmental setup for SIT and UAT.
• Conducted User Acceptance Testing.
• Involved in User of the application
• Application knowledge transfer to Application Support and Maintenance team.

Enterprise Fulfillment (Thunderbolt)

Confidential, Plano, Tx

Business Solution Architect

Responsibilities:

• Business Requirement Analysis along with Business Users.
• Identifying and streamlining Key KPI’s across business group
• Confidential System Analysis with respect to Thunderbolt, and helped identifying gaps
• Calling out key success measure for the program, along with business.
• Defined Report mockup/layout for different business user group
• Created Functional Specification Document, to capture functional and Non Functional Requirement
• Involved in Project planning
• Performed Gap Analysis between Oracle Out of Box Supply Chain and Order Management Application and Confidential thunderbolt requirement
• Involved in Spend Classification and segmentation upgrade
• Design of star schema leveraging Oracle Out of Box data model and Custom Model, using Erwin tool (covering all fact, aggregate fact, dimension, rule, helper and stage tables)
• Design ETL (History/Incremental) load strategy, along with the team for data extraction from heterogeneous databases DB2, SQL Server
• Design/Development of report repository (OBIEE RPD) along with the team.
• Worked along with technical team to design/develop OBIEE and OBIEE Publisher report.
• Involved in Performance tuning of reports and ETL load.
• Planned and executed environmental setup for SIT and UAT.
• Conducted User Acceptance Testing.
• Involved in User of the application
• Application knowledge transfer to Application Support and Maintenance team.

Confidential

BI Solution Architect

Responsibilities:

• 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.
• Added new logos for the organization
• Involved in account mining for some key account
• Participated and led customer workshops

Confidential

BI Solution Architect

Responsibilities:

• 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, Los Angeles, CA

Architect

Responsibilities:

• Study different source systems, across heterogeneous databases like Oracle, DB2, SQL Server
• 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
• 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

Responsibilities:

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

Confidential

BI Solution Architect

Responsibilities:

• 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, Los Angeles, CA

Solution Architect

Responsibilities:

• 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, Los Angeles, CA

Data Integration Solution Architect

Responsibilities:

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

Confidential, Mountain View, CA

ETL Lead Developer

Responsibilities:

• Study of existing source system and requirements
• Design of star schema model using Erwin tool (covering all fact and dimensional tables)
• Design and Documentation of ETL specification based on the analysis
• Study the existing Micro Strategy metadata.
• Study the existing Micro Strategy reports
• Development of ETL mappings
• Preparation of Test Plans
• Support of migration of new ETL mapping to QA and UAT environment.
• Support of UAT and system testing.

Confidential

Technical Lead

Responsibilities:

• Involved in defining process for ETL development life cycle for SEI GWMP
• Analysis of the Business Process to be implemented in close conjunction with the Business Analyst
• Co ordination between different functional & IT team of SEI GWMP
• Review of the existing Data Model and enhancement of Data Model as per the requirement.
• Design and Documentation of ETL Loading strategy
• Implemented data load from different type of source like Flat File, Relational Database, Oracle Logs using Informatica Power Exchange(Near Real Time workflows), IBM Message Queue, XML Message, Swift Messages
• Implemented data load to different type of targets like Flat File, Relational Database, IBM Message Queue, Oracle Advance Queue, XML Message
• Involved in design and development of shell script to start and stop ETL Workflows both near real time and batch workflows in different environment.
• Involved in design and development of shell script to detect any breakage of link between Power Exchange and Power Centre.
• Involved in design and development of scripts to measure the amount of latency in data replication for near real time ETL workflows.
• Involved in design of Health Report to reflect the data hygiene between two components and development of sync up process between two components of the platforms in case of mismatch.
• Involved in testing and setting environment as per the fixes provided by the vendor.
• Worked closely with DBA’s and PE team to optimize the ETL workflows
• Worked closely with the Business Analysts of the group to identify the unrecoverable scenario’s for the near real time workflows and working out the remediation process for the same.

Confidential, Atlanta, GA

Technical Lead

Responsibilities:

• Studied existing source system, requirements and designed star schema model using Erwin tool (covering all fact and dimensional tables)
• Co ordination between different functional & IT team of Confidential
• Studied existing Screen Door (Data Validation and cleaning of the source flat file).
• Designed and documented the enhancements in screen door.
• Design and Documentation of ETL specification based on the analysis
• Enhancement of Business Object Universe to develop new reports.
• Analysis and design of new Business Object Reports.
• Test Planning and supporting project management activities