EXECUTIVE SUMMARY:

• 20 plus Years of experience in IT as skilled Sr. Manager/Architect with very strong background in migration, system integration and data acquisition across companies and move data from SAP Hana to SQL Server vice versa, Creating POC, Database Modeling, Designing, Architecting, Developing, Implementing Enterprise business application, RDBMS, Data Warehouses, BI & Relational Systems and in managing large Projects with SAP HANA, SQL Server and Oracle.
• 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, 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.
• Have thorough understanding of Big Data ecosystems, Hadoop platform, application framework and architecture, performance tuning, HDFS, MapReduce and NoSQL.
• My recent experience working in the Cloud Computing Team for high performance and high-available servers, Amazon Web Services, Google Cloud Platform.
• Managed multiple teams for successful implementation of projects and products. Hands on experience with Oracle Financial Applications.
• Involved in creating Master Data Management (MDM).

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)

TECHNOLOGY PROFICIENCY:

• Windows 2000, HP/UX, Sun Solaris
• Oracle, MS SQL Server, SAP HANA
• Oracle Business Intelligence (OBIEE (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, Milpitas, CA

Sr. Enterprise Architect/ Manager

Responsibilities:

• Lead & manage a team of Big Data consultants
• Hadoop & Big Data architecture design, planning, installation, deployment
• Migration from relational databases (source systems), data warehouse (Teradata) to Big Data platforms on GCP.
• Reviewed and documented business logic in Informatica mapping, work flow to migrated to GCP.
• Build 360 view of Customer MDM (master data management) form 10 different customer source application
• Used Sqoop, Kafka to transform data from 85 different source system to cloud platform
• Responsible for creating and implementing the entire data architecture for moving 100 + source system to Hadoop big data platform in the GCP cloud
• Scope, plan and manage Big Data projects
• Direct the work and priorities of Big Data & Hadoop team
• Designed and utilized applications leveraging Google Cloud Platform

Confidential, CA

Sr. Enterprise Data Architect

Responsibilities:

• Responsible in building enterprise data model, data mapping, creating data foot print for Lam.
• Responsible in setting of standards for EAM
• Responsible in creating CDM, LDM, PDM.
• Responsible in working with the team and review the models created and guiding the modeling and development team for successful implementation of various dash board in Qlik Sense.
• Directing new data development and ensuring consistency/integration with existing EDW structure. Maintaining data architecture, metadata, master data, data management standards, data dictionaries, and data element naming conventions.
• Migrating, System integration and data acquisition of data from across companies. Migrating data from SAP to SQL Server and migrating data from SQL Server to SAP HANA.
• Responsible for delivering as part of the comprehensive data model, the data dictionary and source-to-target mapping and other metadata as required.
• Participated in data analysis and data dictionary and metadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
• Involved in analysis of source system files fields and identified master data fields and reference\metadata data fields and also identified the level of granularity of the source systems data.
• Created Efficient Metadata data model to know about the source systems, oracle staging and Mongo Systems metadata and programs.
• Mentoring team about provider and member metadata/master data/transaction data models and usage.
• Experience in SAP HANA data modeling using Attribute View, Analytic View and Calculation View and the onside and offshore team with respect to implication and performance of the front-end dash board in Qliks
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views.
• Load Flat file and Relational Database (SQL Server) to SAP BW Data Warehouse and SAP HANA database using BODS 4.2.
• Worked on creating Data profiling, identify cleanup of Equipment data in Information steward
• Design of analytic, calculation and attribute views in SAP HANA to provide data attributes for marketing dashboards, equipment for CSBG group
• Partnered with marketing business units to define functional data requirements that provided system/data functionality for new marketing platform
• Operational DataMart’s and replication using SLT from several SAP systems
• Led SAP Customer Address Cleaning Project
• Involved in POC for data lake and big data for real-time data for Machine processing data
• Identified the existing issues within business master data as well as technical master
• Created and implemented master data standards bases on SAP Best Practice for Data Governance model

Environment: SAP HANA, SAP ECC, SAP BW, MS SQL Server, Oracle.

Confidential, Bakersfield

Sr. BI Manager / Enterprise Data Architect

Responsibilities:

• 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 architecting, POC for data lake and big data for real-time data for Wells pressure and temperature.
• Involved in writing SQL scripts to create source to target mapping from Oracle, MS SQL Server
• Directing new data development and ensuring consistency/integration with existing EDW structure. Maintaining data architecture, metadata, master data, data management standards, data dictionaries, and data element naming conventions.
• Migrating data from Oracle to SQL Server and migrating data from SQL Server to Oracle.
• Responsible for delivering as part of the comprehensive data model, the data dictionary and source-to-target mapping and other metadata as required.
• Participated in data analysis and data dictionary and metadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
• 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) using SSAS, MDX, SSRS
• 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, Dallas, TX

BI Manager/Architect

Responsibilities:

• To provide metrics / business intelligence around various SE Activities tied to revenue and products to
• 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
• Profiled the source data

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

Confidential

BI Manager/Enterprise data 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.

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

Sr. BI Manager/Data Architect

Confidential, DEERFILED, IL

Responsibilities:

• 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.
• Scoped and created eCom business road map for ODS based data warehousing implementation.
• Involved in analysis of source system files and identified master data and reference/metadata data and also identified the level of granularity of the source systems data.
• Created Efficient Metadata data model to know about the source systems, oracle staging and other systems metadata and programs.
• Mentoring team about provider and member metadata/master data/transaction data models and usage.
• Gathered business requirements, created data model, developed high level and detailed Project Plans, created high level and detailed Technical Architecture.
• Adopted Kimball Lifecycle, Bus Architecture & Dimensional Modeling to create a clean and effective Enterprise Data Warehouse.
• Developed the standards / Conventions for basic Naming & location standards.
• Evaluated Pentaho BI for eCom Business unit
• Designed and Documented logical and physical data models for OLAP, OLTP and 20 different 3rd party sources.
• Designed, built, validated high level and detailed Dimensional Model, Facts, Grains with emphasis on a clean and effective OLTP, Data Warehouse that has conformed Dimensions, Atomic and Aggregate data, facilitates drill down / drill up / drill across queries at the presentation layer.

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

Confidential, Aurora, CO

Sr. BI Manager / Enterprise Data Architect

Responsibilities:

• Monitored 5 projects, with 55 developers, in India, with tasks including interfacing with team leads, writing summary reports, and coordinating development activities.
• Instrumental is Planning, designing and architecting the Database design, Data Warehouse & Data Marts for the enterprise scale Online Sales & Order Fulfillment System.
• Daily activities include the planning, participation in and monitoring of the full lifecycle of development: analysis, design, code and test
• Gathered business requirements, created data model, developed high level and detailed Project Plans, created high level and detailed Technical Architecture.
• Adopted Kimball Lifecycle, Bus Architecture & Dimensional Modeling to create a clean and effective Enterprise Data Warehouse.
• Developed the standards / Conventions for basic Naming & location standards to criterion for disk volumes / Data Quality etc.
• Designed and Documented logical and physical data models for OLAP, OLTP and EDW, and BI presentation layer.
• Migrating data from Oracle to SQL Server and migrating data from SQL Server to Oracle.
• Designed, built, validated high level and detailed Dimensional Model, Facts, Grains with emphasis on a clean and effective OLTP, Data Warehouse that has conformed Dimensions, Atomic and Aggregate data, facilitates drill down / drill up / drill across queries at the presentation layer. Designed and developed ETL Maps, PL/SQL Transformations to handle SCDs Type 1 & 2, Load Historical and Incremental Data into Facts tables, handle “Late Arriving” Data, and handle Errors etc.
• Developed SQL, PL/SQL programming standards for all ETL processes.
• Designed, Implemented and Automated Data Profiling Tasks, Workflows, automated the ETL tasks using Schedules.

Environment: Oracle 10gR2, PL/SQL, Informatica, Visio, Oracle Business Intelligence (OBIEE 10.1) - BI Publisher, BI Answers, Dashboard, SQL Developer / OEM, SQL Analyzer, Explain Plan, SQL*Plus, Exp/Imp, SQL*Loader, ERWin.

Confidential, San Jose, CA

Manager and Data Architect

Responsibilities:

• Designed the database model, dimensional model and developed several mappings to extract & cleanse data, conduct data profiling / data quality auditing, load dimensions & cubes using external tables and flat files.
• Developed data extraction from Oracle Apps / SAP / Legacy Systems using a multi-threaded, multi-processing strategy to take advantage of SMP or Multi-Processor Servers for the Historical and incremental data load as well.
• Formed and led the data quality review committee consisting of subject matter experts.
• Knowledge of databases, data warehouses, data marts, extract transform and load (ETL), BI (business intelligence) tools (including spreadsheets, reporting, OLAP and dashboards), data models, metadata, data governance, and information quality
• Experience with in-production business intelligence, decision support and/or data warehouse tools
• Designed the database model, dimensional model and developed several mappings to extract & cleanse data, conduct data profiling / data quality auditing, load dimensions & cubes using external tables and flat files.
• Oracle migration from 6.0 to 7.0 in heterogeneous environment, SUN, Sequent, Multilingual Kanji in Japan.
• Performance tuning of 100 of SQL, Size of Database of customer install base etc.,
• Support, maintained and worked on various enhancements for purchasing in Oracle Application 9.4.2
• Responsible for managing and customer support for various applications (FOC, CIB, PPD) related to pricing order fulfillment
• Interface with people soft employee data to Oracle application and vice versa
• Systems Integration process for HR and customer data between People soft to Oracle Application
• Implemented integration process Custom application to SAP, Oracle application, People Soft
• Modified entry of upgrade product number and have upgrade automatically be performed.

Environment: Oracle v6.0. SQL*Forms 2.3/3.0. Pro*C, Application Foundation 4.1, PL*SQL and SQL*Reports