SUMMARY:

• Understand Business function and requirements. Requirement Analysis, Data Analysis, Identify Source system, analyze existing system. Requirement Gap Analysis and Requirement validity/feasibility. Provide ongoing support/problem solution and answer to the questions raised by Business users. Liaison between Business and Technical team
• Change management and analyses impact of changes to Upstream/ Downstream / Existing Current system. Provide solution to impact of changes.
• Worked with Users and Stakeholder. Guiding them and answer their questions.
• Partner with various teams like Reporting team, BI team Business Analyst team, ETL team, QA Team, Source Team, data architect team, DBA team, Other DW team.
• Solid analytical skills and data integration knowledge, worked in team environment, Strong problem solving skill.
• Expert in conceptual (CDM), logical (LDM), Physical data modeling (PDM). ERD,3NF (OLTP), Dimension Modeling, Star/Snowflake Modeling for data warehouse and data mart, ODS, MDM, Reverse engineer existing data model.
• Familiarly with NOSQL, Key - Value model, Columnar Family modeling, Embedded Data model for big data. Schema design based on data pattern, Reference Modeling, Flat file structure designing
• Data Architecture, Data aggregate layer, three tier data Staging, Landing layer /integration/DW/Presentation.
• Expert in ERWIN, Power Designer, ER studio, SQL scripting
• Data flow (DFD), UML class modeling, Use cases, activity diagram.
• Worked with very high volume data. Data Integration from multiple sources.
• Management of Data integrity, Data standard, Data element definition, Data capture, Data migration Data enhancement, Data Quality, Meta data, Data Profiling, Data Discovery, Data Usage, Data Governance.
• Data Exception Handling process, Data Rejection process, Data publishing process, Data arrival process.
• Played key role in multiple projects and acted as a knowledge expert (Technical, Functional), SME (subject matter expertise)
• Develops standards and guidelines for the design of data architectures, data models, ETL architecture, BI architecture, Data mart architecture
• Familiarity with Data Analytic using R, R Studio, Tableau, Big data
• Design ETL architecture, Source to target Data Mapping with pseudo-ETL code and Building large Data warehouse from scratch.
• Created DDL (Tables), Indexes, Table Partitioning, Sequences, Views, Materialized views, procedure in PL/SQL, SQL programming, ETL, OLAP reporting
• Worked with Oracle, SQL Server. Hands on with NOSQL. HADOOP, HIVE, SQOOP, FLUME, MongoDb, Tableau, Python, AWS cloud source.
• Full project life cycle, SDLC, PLC experience

TECHNICAL SKILLS:

OS: Windows NT/XP/7.0/8.1, Unix (Sun Solaris) 2.7, Confidential Unix 10.X, Linux

Tools: Oracle Designer 9i, Oracle SQL Modeler, ERWIN 7.2/8./9.5, System Architecture, Power Designer15, Toad Data Modeler, ER studio, SAP HANA Modeling, Ms-Project 4.0/95/98, MS Excel, MS word, MS Power Point, Visio, TOAD, Clear Case, Visual source safe V6.0, DevTrack V6.0, DBVisulizer 9.95,Lucid chart

Methodology: SSADM, JAD, SE, RAD, CASE, Agile, Ralph Kimball/Inmon/Big Data Methodology.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Sr. Data Architect

• Requirement analysis, understand existing system and process, User Pain Points
• Understand Existing Databases and Structures.
• Data analysis and data profiling of existing 1st party, 2ndparty 3rd party data segmentation analysis
• Created conceptual, logical unify customer data model. Embedded No SQL data Model
• Reverse engineer existing data models.
• Create standard definition of customer, prospect, statuses, persona, beauty insider Segments. Business glossary. Customer Identity, Profile, Preferences, social behavior, transactions.
• Setting policy and processes for Data governance and Data stewardship, Data custodian
• Understanding current data systems and flow and Setting Data Strategy, Data Platform Roadmap.
• Created Inflow and Outflow customer data flow from various systems and customer various touch points. Customer Direct / Indirect Interaction systems with Confidential .
• Architect of 360degree view of customer and her attributes for data stitching.
• Data classification, Data security/Privacy, System and Functions/Activities.
• Participated in Data Stitching, Data Lake, Data Pipelines sessions.
• Presentation/Review of Data Model with Technical team, Presentation of Architectural Design Document to Various team.
• Written Story in Confluence.

Environment: Oracle SQL Modeler, Oracle SQL developer, Oracle 12c, MS SQL Server 2012/2016, Hadoop, Hive, DB visualizer, Power Point, Lucid chart, Confluence, Jira

Confidential, Mountain View

Sr. Data Architect / Sr. Data Modeler

• Requirement analysis, understand business functions, Business rules
• Understand source system prepare list of questions and get answer from source team, Business team.
• Perform source system analysis and data profiling. Do gap analysis between business requirements and source system. Requirement feasibility analysis.
• Created Conceptual, logical, Physical data model. Dimension modeling, star schema design for data mart, Flat file structure design.
• Creation and maintenance of data element definition, data dictionaries.
• Data analysis, data discovery, data integrity, source data quality analysis, data profiling, Work flow dependency matrix.
• Participated in establishing data policy, data standard, data architecture, ETL architecture, exception handling process, Data Rejection, Data extraction process, Data Auditing
• Requirement analysis, understand business functions, Business rules
• Partner with various teams like ETL team, QA Team, data architect team, Business Analyst.
• Presentation/Review of Data Model with Technical team, Presentation of Technical Design Document to ETL/QA/Design
• Created Technical Design Specification documents and ETL mapping documents with Pseudo codes for Data Mart.
• Extensive data analysis using SQL programming, DDL creation.

Environment: ERWin 9.5, MS SQL Server 2012/2016, Jira

Confidential

Data Analyst/Data Architect

• Collecting requirements from stakeholders. Requirement, Functional Analysis document.
• Data Source system, System of record Analysis. End to end Data Flow Data Discovery. Researching Data Integrity between various systems.
• Research and find out various options, tools, technical environment to best fits for going forward data architectures and data mart, data warehouse.
• Participated in establishing data policy, data strategy, data standard, data architecture, exception handling process, Data Rejection, Data extraction process, Data Auditing.
• Creation and maintenance of data element definition, data dictionaries, Meta data.
• Providing solution for best data collection, Integration approach for analytical reporting going forward.
• Data Analytic, Data Blending, Data visualization using Tableau, Excel
• Data collection, Data cleaning, Data Preparation for analytic
• Creating Dimension data model for data warehouse, Data Mart, Data ingestion, technical specifications.
• Monthly, Quarterly, Yearly reporting. Reports like fallout, trending, top 5 best, bottom 5, quarterly comparison, monthly comparison, Scheduled, Unscheduled Product releases, Weekly progress of releases. Release content analysis. etc..
• Creating Dimension data model for data warehouse, Data Mart, Data ingestion, technical specifications.
• Change management and analyses impact of changes to Upstream/ Downstream / Existing Current system. Provide solution to impact of changes.

Confidential

Analyst/Data Modeler

• Big data concept, Hadoop Eco System
• Installation of Hadoop, Hbase, Hive
• Data ingestion from MYSql to Hadoop Hbase using Sqoop
• Data Streaming from Twitter to Hadoop Habse using Flume
• Data ingestion of flat file to Hadoop Hbase using Hive
• JSON File/ Flat file analysis using Hive
• NOSql columnar database, Document data base concept.
• Key Value Model, Master/Reference Model, Embedded model creation
• Document data inserted/updated/deleted/viewed in Mongodb
• Data Mining/Big Data analytic/Data visualization using Tableau
• Data Analysis/basic statistical analysis of excel/json/xml/mysql data using R-studio, Tableau
• Dashboard creation using Tableau
• Familiarity with Cassandra, Couch base, Map reduce, Pig
• Basic Python scripting

Confidential, San Ramon

Sr. Data Architect / Sr. Data Modeler/Analyst

• Work with Business analyst, SME, Business user/Stakeholder and understand, Collect business/functional Requirements, business rules and changes in existing system
• Understand source system prepare list of questions and get answer from source team.
• Perform source system analysis and data profiling. Do gap analysis between business requirements and source system. Requirement feasibility analysis. Provide ongoing support/problem solution and answer to the questions raised by Business users. Worked as bridge between Business and Technical team.
• Created Conceptual, logical, Physical data model. Dimension modeling, star schema design for data mart, Data flow diagram (DFD), Flat file structure design, data architecture road map. Business function Model
• Reverse Engineer Existing data model from SalesForce (Energy Insight) AWS database. Data Analysis of SalesForce (SFDC AWS) database.
• Creation and maintenance of data element definition, data dictionaries, Meta data.
• Data analysis, data discovery, data integrity, source data quality analysis, data profiling, Work flow dependency matrix.
• Participated in establishing data policy, data standard, data architecture, ETL architecture, exception handling process, Data Rejection, Data extraction process, Data Auditing, Data Governance.
• Provide subject matter expertise in Data warehouse / Business intelligence (BI)
• Requirement analysis, understand business functions, Business rules
• Partner with various teams like ETL team, QA Team, Source Team, Reporting team, Business team, data architect team, Business Analyst.
• Presentation/Review of Data Model with Technical team/ Business user, Presentation of Technical Design Document to ETL/QA/Design
• Worked with Users and Stakeholder. Guiding them and answer their questions.
• Created Technical Design Specification documents and ETL mapping documents with Pseudo codes for Data Mart, Partner MDM. Customer MDM, Vendor MDM
• Extensive data analysis using SQL queries.
• Change management and analyses impact of changes to Upstream/ Downstream / Existing Current system. Provide solution to impact of changes.
• Supporting, Guiding ETL developers, QA team, Reporting team, Source team
• Root cause analysis of data issues, ETL issues, Source system issues. Supporting BI Reporting team and escalate issues to concerned groups.
• QA of Developed ETL code
• Make Sure Data warehouse has all attributes related to regulatory reporting requirements of California Public Utility Commission (CPUC). And they Compliance with any fed or state legislative requirements.
• MDM of Customer, Vendor. Data Integration.

Environment: Oracle 11g, ERWIN 9.1, Toad, Sales Force (Energy Insight, AWS), MS Excel 10

Confidential

Sr. Data Modeler/Analyst/Data Architect

• Requirement analysis, understand business function, Business rule
• Understand source system prepare list of questions and get answer from source team. Analyzed source system and do gap analysis, requirement feasibility analysis
• Provide subject matter expertise in Data warehouse / Business intelligence
• Created Conceptual, logical, Physical data model. Dimension modeling, star schema design for data mart, Data flow diagram (DFD). Hierarchies dimensions, Aggregates fact.
• Creation of logical schema, table(DDL), indexes, sequences, views
• Creation of Data element definition and Data dictionaries. Meta data document
• Creation of Technical Specification document, ETL mapping documents
• Supporting, Guiding with various teams ETL team, QA Team, Source Team, BI team
• Provide subject matter expertise in Data warehouse / Business intelligence (BI)
• Data analysis, data discovery, data integrity, data quality, data profiling, Work flow dependency matrix, Work flow, Bus Matrix.
• Participate in establishing data policy, data element naming standard, data architecture, ETL architecture, exception handling process, Data load batch process, data extraction process, Data auditing
• Requirement analysis, understand business function, Business rule
• Understand source system prepare list of questions and get answer from source team. Analyzed source system and do gap analysis, requirement feasibility analysis
• Provide subject matter expertise in Data warehouse / Business intelligence
• Created DDL (Tables), Indexes, Sequences, Views, Materialized views
• Involve in full project life cycle, Data integration from various sources
• Root cause analysis of data issues, ETL issues, Source system issues. Supporting BI Reporting team and escalate issues to concerned groups.
• Master Customer Data using MDM technique, Data Governance
• QA of Developed code, Unit testing
• OVSD, OVSM, OVSC, OV suite of products

Environment: Oracle 11, SQL developer, ERWin 8., ITSM, REMEDEY

Confidential, San Leandro

Sr. Data Modeler /Data Architect

• Created logical data model, physical data model Dimension modeling, star schema design
• Creation of Physical Schema, tables (DDL), indexes, sequences, views, synonyms, db links. Comparison of objects of different schema.
• Reverse Engineer Existing data model from database
• Created data dictionary with data element definitions.
• Data analysis, data discovery, data integrity, data quality, data profiling, meta data, Data dictionary
• Deployment of schema to different server. Static data creation.
• Four layer architecture. Landing, integration, semantic and application.
• Recommendation about setting up Oracle parameters
• Performance tuning query.
• Participate in establishing data policy, data architecture, data standard, exception handling process, Data load batch process, data extraction process, Data auditing, data rejection analysis
• Change management and impact of changes and change procedures
• Writing SQL / Unix scripts
• Working with Business Analyst, User and track issues and recommend resolution.

Environment: Toad 10.1, Sybase Power Designer 15.0, Oracle 10g, Clear Case 7.0, Clear Quest

Confidential, Emeryville

Data Modeler/Analyst

• Requirement analysis, understand business function, Business rule
• Understand source system prepare list of questions and get answer from source team. Analyzed source system and do gap analysis
• Provide subject matter expertise in Data warehouse / Business intelligence
• Collaboration with various teams ETL team, QA Team, Source Team, BI team
• Conceptual, logical data model. Dimension modeling, star schema design for data mart, Data flow diagram(DFD)
• Verification of requirements with data model with business requirements.
• Reverse engineer Existing Source data model
• Data analysis, data discovery, data integrity, data quality, data profiling, meta data, data dictionary, Work flow dependency matrix, Work flow, Bus Matrix,
• Create diagrams using VISIO, DW Data Flow, Technical Architecture, Server Architecture, EDW Architecture
• Creation of logical schema, table(DDL), indexes, sequences, views
• Write Technical Specification (TD), ETL mapping documents
• Participate in establishing data policy, ETL architecture, BI architecture, data architecture, data standard, exception handling process, Data load batch process, data extraction process, Data auditing
• QA of Developed code, Unit testing, Guiding ETL team.
• Business object (BO) rapid mart analysis
• Order management(OM), BOM, Shipping(WSH), Work order (WIP)

Environment: Oracle EBS R12 (Oracle Applications), SQL developer, ERWin 7.2, oracle 10g, Business Object, Visio 2003

Confidential, Mountain View

Data Architect/Data Modeler/Analyst

• Involve in full project life cycle.
• Requirement analysis, understand business function, Business rule
• Understand source system prepare list of questions and get answer from source team. Analyzed source system.
• Provide subject matter expertise in Data warehouse / Business intelligence
• Collaboration with ETL team, QA Team, Source Team, DBA team, BI team
• Conceptual, logical data model. Dimension modeling, star schema design for data mart, Data flow diagram(DFD), Reverse engineer Existing Source data model
• Verification of requirements with data model. Data Analysis, Gap Analysis, data integrity, Data quality, data profiling, Data Dictionary, Workflow, Dependency Matrix, Logical Data Map, Business Model
• Staging persistent layer data model creation.
• Creation/Alteration of physical schema, table(DDL), indexes, sequences, views, MV, Db link, Table Partitioning
• Created Data Mapping document from CDC to Staging and Staging to Data Mart
• Assigning task to ETL developers, Guiding ETL developers, QA team, DBA
• Create data dictionary, data definition, business rules, metadata
• Participate in establishing data policy, ETL architecture, BI architecture, data architecture, data standard, exception handling process, Data load batch process, data extraction process, Data auditing, data purging policy.
• Help creating project plan, task listing, work estimation
• Change management and impact of changes and change procedures
• OWB training, Develop few mapping

Environment: Oracle 10g, SQL developer, ERWin 7.2, Oracle Warehouse Builder (OWB), Visual source safe V6.0, DevTrack V6.0

Confidential, Foster City

Data Modeler

Responsibilities:

• Logical and Physical Data Modeling.
• Understand business requirement

Confidential, San Francisco

Data Architect/Analyst

• Involve in full project life cycle.
• Working with business team and collect business requirement, analyze understand business function and create specification document and finalize requirement. Requirement gap analysis, Feasibility analysis.
• Reverse engineering source system and create existing data model
• Collaboration with various source group and finalized data requirement of BI team. Data profiling source. Design flat file Requirement for source to send data.
• Create/maintain data model, data dictionary, business rules, metadata
• Establishing process for ETL, QA, Error handling
• Convert source system understanding and business requirement into Logical/ Physical Data model. Data flow diagram(DFD)
• Dimension modeling, Star Schema Design, normalization/De-normalization
• Creation of Physical schema, table (DDL), indexes, materialized views, sequences, Views
• Data mapping source to target document, ETL architecture setup
• Participate in establishing data policy, BI architecture, data Architecture, data standard, exception handling process, Data load batch process, data extraction process, Data auditing, data purging policy, Data Rejection.
• Root cause analysis of data issues, ETL issues, Source system issues. Supporting BI Reporting team and escalate issues to concerned groups. Manage Issue Tracking/resolution and provide solution.
• Data Extraction from flat files to staging using Cognos Data manager
• Created reports in Analysis studio and Report studio of Cognos
• Created ETL store Procedure, functions using PL/SQL
• Performance Tuning of SQL statements

Environment: Oracle 9i, TOAD, DBVisulizer 5.1.1, Data Manager (Cognos), ODBC, Toad Data Modeler, ER Studio, Cognos Analysis studio/report studio, oracle EBS 11i

Confidential, San Jose

Data warehouse Architect/Sr. Data Modeler

• Involve in full project life cycle (PLC) and SDLC
• Reporting requirement analysis, Data requirement analysis
• Understand source business process and data model and do data analysis and map the requirement to source system.
• Conducting meeting with source team and finalize data gathering requirements
• Build partnership with various team (ODS, Different source team, BI)
• Act as liaison between various functional teams and guiding and mentoring them
• Effort estimation and project plan
• Assigning Tasks, create road map of development and measure WIP
• System Flow, Data Flow Diagram(DFD), CRUD Matrix, Dependency Matrix
• Guiding BI team, ETL developer team and QA team. Played key role.
• Set up guidelines for ETL process for incremental/full Load
• ERD, 3NF Data model, Dimension modeling, Star Schema Design, normalization/ De-normalization for data ware house, ODS, Hierarchies dimensions, Aggregates fact.
• Convert requirement and source system understanding into Logical Data Model, Physical Data Model and presentation of model to team, Data Security/Audit Model.
• Writing Technical specification document for ETL, Source to target data mapping document with pseudo-ETL code.
• ETL architecture/ Backend architecture, BI architecture setup, Process set up
• Created Meta data, Data dictionary, Business Rule, DDL
• Creation of Physical schema, DDL, table, indexes, materialized views, sequences
• Data management of Data integrity, Data standard, Data enhancement, Data publishing, Data auditing, Data Quality, Data Exception handling process., Data Rejection Analysis, Data Governance.
• Manage Issue Tracking/resolution and provide solution.
• Risk/Impact Assessment, Gap analysis, Change Management
• Written store Procedures, Packages, Function in PL/SQL
• Data Migration Scripts in SQLPLUS, PLSQL
• SQL Query Tuning using Explain Plan, SQL Analyzer
• Export /Import, User/Role, Database Privileges, Database Link, ODBC connectivity
• Reverse engineering existing database using Designer 9i.

Environment: Oracle 9i, Oracle Designer 9i, Oracle Enterprise Manager, TOAD, Visio, BUGZILLA

Confidential

Data warehouse architect / Sr. DBA

• Business requirement gathering and analysis, source data analysis.
• Logical Data Model, physical data model, Business Model. DW road map.
• Creation of Physical schema, table definitions, indexes, views, sequences
• Designing Star Schema, Dimension Modeling, Data dictionary, Data Normalization, De-Normalization
• Data mapping, ETL Architecture using Oracle warehouse builder, BI architecture
• Data Transformation, Data Loading (flat files, SQL OADER), Data Cleansing
• Management of Data integrity, Data standard, Data enhancement, Data publishing, Data auditing, Data Quality, Data Exception handling process.
• PLSQL Store procedure to Transfer Data from staging to Data warehouse
• SQL Query Tuning, explain plan, Data Migration Script SQL PLUS, PLSQL
• Database Monitoring, Performance Tuning/ Partitioning and sizing.
• Database Replication/Refreshing/Test/ migration/ upgrade / Creation, Installation.
• Database Connectivity, SQL NET, TCP/IP, ODBC, FTP.
• Database Administrator, Database Issue Resolution, Troubleshooting,
• Database, Data transformation from SQL server to oracle
• Oracle Database Capacity Planning, Standby Database maintenance
• Database Backup (Hot /Cold), Recovery Strategy and Planning, Export/Import,
• Reverse Engineering /Re-organization of Database
• Data Encryption/Decryption, Crystal Report
• Job Scheduling, Job automation processing, Batch data loading
• Data mart, Data warehouse infrastructure setup, configuration.
• Scalability, Availability (24/7), Manageability of Database.
• OLAP cube, Slowly changing Dimension creation and OLAP reporting
• Helping and Guiding users and Stakeholders

Environment: Oracle 8i/9i, PL/SQL, oracle warehouse builder (ETL), Linux, Windows NT, ERWIN, T-SQL,MSSQL 2000, MSOLAP, MSDTS

Confidential

Sr .Data Modeler /Technical Lead

• Preparing Documents for Functional Design and Technical Design
• Dimension Modeling, Star/snow flake Schema Design for Data Warehouse
• Physical Data model, Attributes/Definition, Data Dictionary, Meta Data
• Source Target Analysis, Data analysis, Data mapping document
• Creation of Logical schema, table definitions, indexes, views, sequences
• SQL Tuning, Explain Plan, PL/SQL Store procedure
• Reverse Engineering /Re-organization of Database/Data Migration.
• Data Loading / Extracting /Transforming /Refreshing / Replication

Environment: Oracle 8i, PL/SQL, BRIO 5.X, UNIX sun 7.0, Windows NT, ERWIN, IWATCH, TOAD, SQL Loader, MS-Project, Peoplesoft

Confidential, CA

Sr. Data Modeler /DBA .

• Data Modeling (Logical, Physical), Data Normalization (3rd normal form)
• Process Design, Business Rule and integrity Constraint implementation
• Physical Data model, Attributes/Definition, Data Dictionary, Meta Data
• Database Planning, Installation, Creation, configuration,
• Creation of Logical schema, table definitions, indexes, views, sequences
• PL/SQL Store Procedure, Triggers, TCP/IP, FTP
• UML modeling, Use cases, Activity diagram
• Helping and Guiding users and Stakeholders

Environment: Oracle 8i, ERWIN 3.0.5, PL/SQL, Windows NT, UNIX, TOAD

Confidential, Texas, Delaware

Sr. Data Architect/ DBA

• Requirement Analysis and Design, Business modeling, Data flow diagram
• Reverse engineering existing system and corporate new changes to new system
• Enterprise Wide Logical Data Modeling/Physical Data Modeling(1300 Entities),
• Modules worked on Offender Intake, Initial Classification, Reclassification, Program Assignment, Housing, Disciplinary, Grievances, Treatment and Planning, Transfer and Transportation, Activity Scheduling, Time Calculation, Temporary Release, Parole Pre-Release, Parole Direct/Indirect Supervision, Parole Violation/Revocation, Discharge, Arrest, Pre-trial, Work Performance/Release, Security Model.
• Presenting Data Model to Stakeholders and explain them and correct model.
• Worked with Developer team and guiding them.
• Created Data Dictionary and Data Architectural Design Document, Data Governance
• Data Normalization (OLTP), Data Analysis
• Business Operation rule and integrity Constraint Implementation
• Backend /Database Architecture, Reconciling complex business structure
• Physical Data model, Data structure/Attributes/definition, Data Dictionary
• Creation of Physical schema, table definitions, indexes, views, sequences
• Data Change Management, Impact Analysis and Process to Change
• PL/SQL Store Procedures, Triggers, TCP/IP, SQL*NET
• Guiding DBA and Programmers for building database and building application

Environment: Oracle 8.0.5, Designer 2000 2.1.2, System Architecture 4.01, DB2