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

CORE COMPETENCIES:

• Data Warehouse / Data Mart / Business Intelligence / ETL -Architect & Development
• Data Architect / Data Modeling (2NF, 3NF, 1NNF, Star) / Database Logical & Physical Design
• Product / Project Management
• Business Process Analysis & Modeling
• System Analysis, System Integration
• Application & Database performance Tuning
• Database Architectural Design & Optimization
• Application Architecture Design
• Master Data Management (MDM)

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 Tablesetc& BI Application deployment in multiple BI Servers and Presentation Servers. Deployed JManage, Windows PerformanceMonitor 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 OBIEEsuch 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 in SAP HANA data 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 and SAP HANA database using BODS 4.2.
• Extracted the data from ECC 6.0 and loaded into BW 7.4 and SAP HANA using Data Services BODS 4.2 as an ETL tool for Data Quality.
• Design of analytic, calculation and attribute views in SAP HANA to 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 and SAP 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 and SAP HANA Data source.
• Led SAP Customer Address Cleaning Project
• Identified the existing issues within business master data as well as technical master data (Connection Object and Premise) in SAP Utility IS-U
• Created and implemented master data standards bases on SAP Best 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 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

Responsibilities:

• 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

Confidential

BI Manager/EDW Architect

Responsibilities:

• Provided technical leadership, work with customers to identify requirements, design and develop robust BI and DW solutions that meet functional and performance requirements
• Architect enterprise level BI and DW solutions Participated in the development of project plans including estimates for the entire life cycle of the project. Appropriate scoping and prioritization decisions were made. Lead teams to create logical data models and map data elements from one system to another.
• Lead or Participate in Enterprise Business and Data Profiling efforts for Accelerated Growth Strategy Project. (Data Domains: Associate, Product, Location, Vendor, Device, Price, Sales & Returns, Inventory Management, Customer, Clienteling, Buy Online Pickup In store, Fulfillment, Location/Associate Productivity, Merchandise Movement, Shipping, Receiving, Carrier, Calendar, and Account)
• Worked on creation o f Master Data Management (MDM) for retail products. Worked extensive with RDBMS and parallel processing and ability to design DB schemas and interface with it using ODBC. Demonstrated proficiency in the Windows platform

Environment: Oracle 10gR2, PL/SQL, Visio, SQL Developer, Explain Plan, SQL*Plus, ERWin.