Candidates About

 

Dominic Kumar

SME - Performance Tuning, Capacity Modeling

Highly accomplished, deeply driven, Results-oriented Data Modeler / Architect with a successful 14+ years of experience in Data Architect/Modeling, NoSQL, Leading Projects, Performance Optimization, Business Intelligence, Software Development Life Cycle, SOX, Information Technology Infrastructure Library and Object-Oriented Analysis. Proven ability to tackle and succeed in all endeavors from business development to customized software development and implementation. Exceed ongoing and overlapping deadlines in fast-paced environments, handle multiple assignments simultaneously and coordinate deliverables with key stakeholders in cross-functional groups.

Bachelor of engineering, computer science

·          MCSE: Business Intelligence (SQL Server 2012).

·          MCSE: Data Platform (SQL Server 2012).

·          Oracle Certified Professional (OCP) 9i / 10g / 11g.

·          Oracle Certified Expert – Oracle 10g RAC Administrator & Oracle 11g Performance Tuning.

·          Oracle Certified Expert –Cisco Certified Network Professional (CCNP).

·          Microsoft Certified Business Management Solutions Specialist – Microsoft Dynamics SL 6.5.

·          Scrum Fundamentals Certified Credential.

 

 

o    Business Knowledge in Oil and Gas Industry - Trading, Exploration, Production & Downstream.

o    Business Knowledge in Airlines – Operations and Maintenance.

o    Logical and Physical Data Model (Reverse and Tuning)

o    Key Business Performance Improvement & Database Security.

o    Forecast Performance, Demand and Capacity based on Business Data.

o    Single-Point of Contact for Code / Performance Review.         

o    Project Management. (PMI Standards).

o    Agile Methodology.

           

 

 

 

o    Document – MongoDB, Couchbase

o    Key Value - Redis

o    Wide-Column - Apache Cassandra, Apache HBase, AWS Redshift, Google BigTable

o    Apache Hive.

o    Google BigQuery.

 

o    Erwin

o    Erwin DM NoSQL

o    Erwin Enterprise Architecture

o    Erwin Data Governance

o    ER/Studio

o    MySQL Database Workbench

 

o    Talend (Mid-Level)

o    SSIS (Expert-Level)

 

o    SSRS (Expert-Level)

o    Tableau (Expert-Level)

o    Google Analytics (Expert-Level)

o    D3.js (Mid-Level)

 

o    Data Governance Framework

o    Requirements Traceability Matrix

 

o    Google Cloud

o    AWS

 

o    HTML5 (Expert-Level)

o    CSS (Expert-Level)

o    Python (Mid-Level)

o    R (Mid-Level)

o    JavaScript (Expert Level).

o    D3.js (Mid-Level).

Schlumberger – Houston, TX

 

Solution / Data Architect (Google Cloud) 02/17 – Till date

 

Project 1 – SAP HR Enhancement (02-17 – Till date)

·         Designed the Solution / Data Architecture for SAP HR Application.

·         Per request from Enterprise Data Enablement Manager, provided Data Modeling and Process Modeling/Data Flow Diagram principles (To-do and Not To-do), included top-down and bottom-up modeling approaches and best practices

·         Created taxonomy and ontology for particular subject areas, to demonstrate how it would clarify the ambiguity of enterprise data semantics (For example, Location, Facility, …etc.)

·         Advocated enterprise data strategy to drive taxonomy and common semantics, to govern and harmonize all kinds of data (master data, reference data, transactional data, data lake, SAP data, big data…etc.).

·         Created Business Enterprise Data Model proposition, with roadmap to demonstrate Business Enterprise Data Model with taxonomy, to advocate for Data Ownership, Data Stewardship, and Data Governance.

·         Collaborated with IT Business Architect/SME from different capabilities, evangelized small victories of Enterprise Data Model as building blocks, that would facilitate common semantics, to provide enterprise data entities to enrich the reference architecture content.

·         Architected data systems, strategies and business processes operational data store and warehouse models for new reporting customer.

·         Worked with all levels of external and internal business customers for requirements development

·         Implemented data extraction tool using metadata to generate Extract, Transform and Load (ETL) loader code for large warehouse (VLRDB) and Operational Data Store (ODS).

·         Created data models, solution designs and data architecture documentation for complex information systems.

·         Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.

·         Created the SOA architect for the work flow management web portals for SAP.

·         Implemented Multi-Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure.

·         Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.

·         Conducted one-on-one sessions with business users to gather data Design requirements and created Requirements Traceability Matrix.

·         Implemented ETL for transformation of SAP HR Data into Google Cloud SQL.

 

 

Project 2 – Gap Analysis for Oil / Gas Throughput.  (03/17-05/17)

·         Conducted one-on-one sessions with business users to gather data Design requirements and created Requirements Traceability Matrix.

·         Cultivated culture change, to embrace top down data modeling approach (one subject area or capability at a time), to ensure business alignment, and govern change control process.

·         Established data strategy for downstream data integration initiative, based on current assessments and integration needs

·         Created Conceptual Data Model for 3 different downstream subject domain areas, to demonstrate how the model served as the communication vehicle, to facilitate common semantics, as the baseline for data integration

·         Provided mentoring to the Data Architecture team, using data modeling technique to facilitate the communication that translates business rules into data schema, using Erwin to create Conceptual/Logical/Physical Data Model, as well as metadata management

·         Design data architecture to integrate data from various systems for well project asset management. Leveraged PPDM to create logical and physical data model (Teradata) to contribute to the overall data warehouse environment

·         Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.

·         Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.

·         Enforced naming standards and data dictionary for data models.

·         Reviewed existing warehousing models and architecture leading to new development that improved existing warehouse loading by 22% and reporting system loading by 25%

·         Architected data systems, strategies and business processes operational data store and warehouse models for new reporting customer.

·         Implemented data extraction tool using metadata to generate Extract, Transform and Load (ETL) loader code for large warehouse (VLRDB) and Operational Data Store (ODS).

·         Designed the architecture based on Inmon, so that a central information is stored and in future various other mini-data-marts can be created. This helped minimum changes to the data model, and the app can use various data marts for information consumption.

·         Implemented Type 3 SCD Dimensional Modeling.

 

 

Facebook Inc.

 

Database Engineer 09/16 – 01/17

 

Due to NDA with Facebook, this section is intentionally left blank.

 

Washington Capital Partners

 

NoSQL Data Architect (AWS Cloud, NoSQL – MongoDB & Couchbase NoSQL) 07/16 – 09/16

 

·         Participate in Design and Architecture meetings and proposed technical solutions to Improve Database / Application Performance for Investment & Loan Applications.

·         Design Data Governance using Data Governance Framework.

·         Modelled Entities in MongoDB/Couchbase based on how the data will be related to each other.

·         Studied and Gathered requirements for the Data Design to be developed in-line with Performance, Capacity and Forecasting for Document based NoSQL.

·         Analyzed database requirements in detail with the project stakeholders.

·         Developed a Conceptual model using Erwin DM NoSQL for Document based NoSQL based on requirements analysis.

·         Developed Normalized Logical and Physical database models to design OLTP/DW system for Real Estate applications.

·         Created dimensional model by identifying required dimensions and facts using Erwin v8.

·         Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.

·         Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.

·         Responsible for defining the naming standards for data warehouse.

·         Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data.

·         Exhaustively collected business and technical metadata and maintained naming standards.

·         Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.

·         Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

·         Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)

·         Integrated the work tasks with relevant teams for smooth transition from testing to Production implementation. Technologies used – Node.js, d3.js, MongoDB, Nginx & pm2.

 

Schlumberger – Houston, TX

 

Key Roles in Schlumberger

 

1)       RDBMS & NoSQL Data Modelling.

2)       Performance Forecasting.

3)       Capacity Forecasting.

4)       KPI Reports.

5)       Data Governance.

 

 

 

Cloud Data Engineer (Google Cloud)/NoSQL DBA 05/16 – 6/16

 

Project 3a–

Capacity Management

 

·         Followed ITIL Capacity Management for Trending and Forecasting of Various Data Sources to be mapped into Google Cloud, to help management to look at the KPI for Capacity Management.

·         Designed Tables in Google BigTable for storing Capacity details of all the Sources and Destination.

·         Wrote Python scripts to extract table and present the Capacity forecasting using Regression Model as a KPI Report.

·         The KPI Reports helped to manage the budgeting of the projects ahead of time saving Cost and Time.

 

Project 3b–

Google Cloud Big Query Billing KPI

 

·         Designed a workflow that will help the Cloud-transition management decide the correct queries to by run for Google Big Query. (For each and every query executed in Google Big Query cost is applied).

·         Reduced the Cost by 40%, by identified unimportant reports / queries.

·         Created Google Analytics to gain more insight of the various reports being used by users, to reduce the cost even further.

 

 

 

 

 

 

Project 3c–

Unconventional Data Warehouse (UDW)

 

·         Implemented the UDW Solution in Google BigTable for Analytical purposes.

·         Gather the various reporting requirement from the business analysts.

·         Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.

·         Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.

·         Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.

·         Ensured the feasibility of the logical and physical design models;

·         Worked on the Snow-flaking the Dimensions to remove redundancy.

·         Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase

 

 

Big Data Architect/ Performance DBA (RDBMS & NoSQL) 01/15 – 05/16

 

Project 2

Drill Data Analytics (Hadoop Cluster – Cloudera (Client On-Premises))

 

·         Designed and Implemented Hadoop Cloudera Cluster for Oil and Gas Industry.

·         Designed and Implemented NoSQL Database/Schemas by Reverse Engineering the Oil and Gas External Public Vendors.

·         Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems.

·         Participated in brain storming sessions with application developers to discuss about various de-normalization, Partitioning and Indexing Schemes for Physical Model.

·         Created the Conceptual Model for the Data Warehouse using Erwin Data Modeling tool.

·         Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data Model with Business Users, App Dev. and Information Architects to make sure all the requirements are fully covered.

·         Created Logical & Physical Data Modes using Entity Relationship Diagrams.

·         Analyzed the existing logical model of the ODS to understand the relationships between different entities.

·         Reviewed the Logical Model with Application Developers, ETL Team and Testing Team to provide information about the Data Model and business requirements.

·         Designed and Implemented NoSQL Database /Schemas for storing Oil Drill sensor data using Time series and IoT.

·         Monitored, maintained and Tune the Performance of NoSQL Database/Schemas Cluster.

·         Designed the workflow for extracting oil and gas data from Public source and transferring them to NoSQL Database/Schemas tables as part of Data Lake using Talend and SSIS.

 

 

Project 1

Senior Application / Database Performance Lead (Oracle, MS SQL Server and NoSQL)

(SME – Oracle / SQL Server Performance Tuning / Database Architect) 02/14 – 12/14

 

·         Created Business Requirement Documents (BRD’s), such as SRS & FRS and integrated the requirements and underlying platform functionality.

·         Identify the business requirements by going over the business process and interacting with the business analyst and management.

·         Conducted Analysis and Profiling of potential Data Sources, upon high level determination of sources during Initial Scoping by the Project Team.

·         Involved in discussions with clients/users to determine the Dimensions, Hierarchies and Levels, Basic Measures, Key Metrics for Relational, Multidimensional Data Model for the system and understanding report requirements. Designing Star/Snowflake Schema Data Models.

·         Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Stewards, Data Architects, ETL Developers, and Data Modelers.

·         Interacted with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical and Physical Data Models, Designing Database, Documenting and Rolling out the Deliverables.

·         Involved in Dimensional Modeling, identifying the Facts and Dimensions.

·         Created Custom Fact Tables to track and measure specific types of transaction that customer made.

·         Updated the definitions & physical names based on the Oracle standards.

·         Created Core Fact Tables to track and measure all types of transactions.

·         Created Conformed Dimensions to allow Roll up & Drill down across to other data marts.

·         Used Degenerate Dimensions in order to create unique policy number for insurance claims.

·         Developed Logical/ Physical Data Models using Erwin tool across the subject areas based on the specifications and established Referential Integrity of the system.

·         Maintained and Enhanced Data Model with changes and furnished with Definitions, Notes, Reference Values and Check Lists.

Worked very close with Data Architectures and DBA team to implement Data Model changes in database in all environments. Generate DDL scripts for Database Modification, Macros, Views and set tables.

 

Shell Trading – Houston, TX

 

Database Performance Lead – Performance Focal Point – North America

(SME – Oracle Performance Tuning & RAC), 10/11 – 01/14

 

·         Data Modelling for OLTP and DW Projects.

·         Performance Tuning

·         Technologies used –AWS & Azure and JavaScript.

 

El Paso Corporation – Houston, TX

 

Senior Database Administrator (SME – Oracle / SQL Server – Performance Tuning), 01/11 – 10/11

 

·         Data Modelling for OLTP and DW Projects.

·         Performance Tuning

 

 

Weatherford Laboratories – Houston, TX

Senior Database Lead (SME – Disaster Recover & Performance Tuning), 09/10 – 12/10

·         Technologies used –AWS & Azure and JavaScript.

 

MXEnergy – Houston, TX

DBA Lead (SME – Oracle RAC & MS SQL Cluster / Performance Tuning), 3/08 – 9/10

 

Safeguard Properties Inc – Cleveland, OH

DBA Lead (Oracle and MS SQL Server – Performance Tuning), 8/07 - 2/08