SUMMARY

• A long and successful career spanning analyzing business requirements and designing effective Data modeling, User Interface design for relations database / Data Warehouses / Systems, reporting solutions / BI Solutions that facilitates an organization to detect and respond immediately to opportunities and issues.
• Hands - on development experience in implementing more than 50 business application for OLAP and OLTP Systems, DW/BI Systems using Oracle, ETL, SQL, PL/SQL, Business Objects, Oracle Business Intelligence (OBIEE 10.1), ERWin.
• Excellent Project Management skills using Agile, Waterfall methodologies; Managed medium to large size Web / Data Warehouse Projects involving Million+ lines of code, project team sizes varying from 10 to 75+.
• Outstanding communication and liaison skills proven by effective interaction with clients, business stakeholders, management, and team members. Involved in Architect, design development and implementation of various business applications and products for many industries.
• Managed multiple teams for successful implementation of projects and products. Hands on experience with Oracle Financial Applications. Involved in creating Master Data Management (MDM).
• Managed global requirements, licensee support, system enhancements, competitive product analysis, market field trials, cost improvements, and customer satisfaction initiatives Managed Software and SOC product development, qualification, product introduction & project support to several Global Customers with product releases. Develop and Implement processes for test planning, development, automation, execution, and SQA of System Design Automation products and tools.
• Demonstrated project management ability to ask questions of business leaders and stakeholders in order to understand information need and leverage answers to design, develop and implement the right technical solutions
• Technical experience with very strong background in Database Modeling, Designing, Architecting, Developing, Implementing Enterprise business application, Data Warehouses, BI & Relational Systems and in managing large Projects.
• 2 plus years work experience in building Enterprise Data Warehouse using SAP HANA.
• A skilled Sr. Manager/Architect with very strong background in Creating POC, Database Modeling, Designing, Architecting, Developing, Implementing Enterprise business application, RDBMS (Relational DataBase Management Systems), Data Warehouses, BI & Relational Systems and in managing large Projects.

TECHNICAL SKILLS

• Windows 2000
• HP/UX
• Sun Solaris
• Oracle 8i/9i/10g
• Oracle Business Intelligence (OBIEE 10.1) (BI Publisher, BI Answers, Dashboard)
• Business Objects
• Oracle Forms
• Reports
• PL/SQL (Stored Procedures, Triggers)
• OCI, Pro*C
• SQL*Loader, Exp/Imp, SQL*Plus
• Query Analyzer
• Explain Plan
• Java, C/C++
• PowerBuilder
• Stored Procedures
• Triggers
• Unix Shell Scripting
• MS project
• ERWin
• Oracle Designer
• Visio
• MS Office Applications
• OLAP - Kimball Life Cycle / Dimensional Star Schema
• Inmon
• Project Management - Agile / Waterfall Methodology

PROFESSIONAL EXPERIENCE

Confidential

Sr. Enterprise Data Warehouse Architect

Responsibilities:

• Instrumental is designing and architecting the Data Warehouse & Data Marts for the enterprise scale Financials, Online Sales & Order Fulfillment System to generate multi-dimensional business analytics.
• Project Management, budget management, Risk Management / Risk mitigation, gathered business requirements, developed high level and detailed Project Plans, prioritizing / Scheduling, mentored, led a 30+ onsite / offshore project team.
• Adopted Kimball Lifecycle, Bus Architecture & Dimensional Modeling to create a clean and effective Enterprise Data Warehouse and created high level and detailed Technical Architecture.
• Performed OBIEE Administration, BI Server upgrade / migration, designed and created RPDs, Presentation Catalogs, Usage and Login Tracking, Catalog / RPD merging, BI Server Performance tuning using Connection Pool, Cache, Aggregate Tables etc & BI Application deployment in multiple BI Servers and Presentation Servers.
• Deployed JManage, Windows Performance Monitor etc. to manage and optimize BI Servers Performance.
• Designed and Deployed an optimal BI Server Configuration, Hardware Load Balancer, DMZs, and OC4J on SSL etc.
• Used OBIEE’s BI Answers, Publisher to create various interactive Sales, Marketing, Order related reports drillable by Region, Time, Product, Volume, Dollar, Customer and built several Data Mining solutions. Reports were provided in several intuitive and visually appealing formats such as Charts, Graphs, Tables, Pivot, PDF. Designed and implemented an interactive Dashboard to launch these enterprise reports based on user privileges.
• Used several features of OBIEE such as Initialization Blocks, Session and Repository Variables to track User specific values, Time Series measures, % Change, Image Prompts to implement visual filters etc.

Confidential

Enterprise Data Warehouse Architect/Scientist/SAP HANA

Responsibilities:

• Experience inSAP HANAdata modeling using Attribute View, Analytic View and Calculation View
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Load Flat file and Relational Database (SQL Server 2012/2008 R2 and Oracle 11g) to SAP BW Data Warehouse andSAP HANA database using BODS 4.2.
• Extracted the data from ECC 6.0 and loaded into BW 7.4 andSAP HANAusing Data Services BODS 4.2 as an ETL tool for Data Quality.
• Design of analytic, calculation and attribute views inSAP HANAto provide data attributes for marketing dashboards.
• Partnered with marketing business units to define functional data requirements that provided system/data functionality for new marketing platform consisting of SAP-CRM, SAP andSAP HANA applications.
• Operational datamarts and replication using SLT from several SAP systems
• Experience in designing, creating and maintaining Universe from Relational data source, OLAP SAP BW Data Source andSAP HANAData source.
• LedSAPCustomer Address Cleaning Project
• Identified the existing issues within business master data as well as technical master data (Connection Object and Premise) inSAPUtility IS-U
• Created and implemented master data standards bases onSAPBest Practice for Data Governance model

Environment: SAP HANA1.0, SAP ECC6.0, SAP BW7.4, Solution Manager, Oracle.

Confidential

Sr. BI Manager / EDW Architect

Responsibilities:

• Involved in completion estimation (expert and statistical) of the project right from interception to deployment in MS project and using agile methodology (adopted sprint and scrum process)
• Created and implemented project plan that included schedule, cost, scope, quality and risk.
• Followed System Implementation Process for managing the project.
• Liaison with business unit heads, senior management and infrastructure managers to collect generic requirements.
• Preparing Risk Management plan, managed and implementing risk mitigation strategies.
• Maintained project and resource estimates and was balancing the resources.
• Worked with different people to gather business and functional requirements and documented.
• Worked on Creation of Master Data Management (MDM) for email customers.
• Influenced and managed change requests.(change management)
• Involved in creating E-R Diagram for FDS for various subject area (which has more than 1000 entities and 0.5 billon rows)
• Involved in writing SQL scripts to create source to target mapping from Oracle, MS SQL Server
• Involved in provide a complete solution using (Service Oriented Architecture) SOA for enterprise data ware housing for entire Confidential and road map for transition 300’s of system which has 3000+ table in some of the system (Energy Component, LOWIS, Catalyst)
• Involved in consolidating 1200 to 300 reports for RBI (Reporting Business Intelligence)
• Involved in setting up standards for code and process
• Worked on building concept information Model (CIM) with Foundation Data Store
• Worked with BI and ETL lead to creating source to target mapping Review the code
• Profiled the source data for accuracy and consistency and to identified trusted source data

Environment: MS SQL Server, Oracle 10g, Erwin 7.1

Confidential

BI Manager

ResponsibilitiesL

• To provide metrics / business intelligence around various SE Activities tied to revenue and products to
• Pro-actively manage business
• Justify resource needs and
• Increase visibility into SE activities
• SE Activity data from SFDC
• Opportunity Data from SFDC (already exists in VMDash)
• Bookings Data from Bookings DB (already exists in VMDash)
• Worked the Fast BI to gather requirement and updated the FRD from the BRD
• Worked on building facts and dimensional data model using Erwin diagram
• Worked with BI and ETL lead to creating mapping and converted the FRD to TDD and ETL mapping and provided SQL scripts for ETL and BI team
• Worked the Salesforce source team to bring the data to sales data mart
• Responsible for technically managing the project with onsite and offshore model
• Support and maintained TSBI sales data mart
• Review the code in OBIEE and informatics
• Profiled the source data

Environment: OBIEE 10g, Informatica 8, Oracle 10g, Erwin 7.1