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. Liaoning 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.
• 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 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
• Full project life cycle, SDLC, PLC experience

TECHNICAL SKILLS:

RDBMS: ORACLE 7.x,8i.X/9i/10g/11g, MS SQL Server 7.0/2000, Oracle EBS R12, Oracle Warehouse builder (OWB), Data Junction (ETL), Developer 2000, Power Builder 4.0, IWATCH, OPS, OEM, OPD, OAS, Informatica 8.1

Hadoop: Hive, Sqoop, Flume, Mongodb, Cassandra, Couchbase

Tableau: Cognos 8.0 Analysis/Report studio, Cognos data manager

PL/SQL, SQL: Shell script, Python, JDBC, ODBC, Clipper 5.2, Dbase III, Pro*C, COBOL

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

Tools: Oracle Designer 9i, ERWIN 7.2/8./9.1, 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 5.1.1

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

EXPERTISE AREA:

• Full Project Life Cycle and Project Management
• Project Planning
• Scheduling
• Tracking
• Issue Resolution
• Resource Allocation
• Configuration Management
• QA Management
• Team Management
• User Interaction

PROFESSIONAL EXPERIENCE:

Confidential, Mountain View, CA

Sr. Data Architect / Modeler

Responsibilities:

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

Confidential, San Francisco, CA

Data Analyst / Architect

Responsibilities:

• 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

Responsibilities:

• 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, CA

Sr. Data Architect / Modeler / Analyst

Responsibilities:

• 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) database. Data Analysis of SalesForce (SFDC) 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
• 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.
• 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

Environment: Oracle 11g, ERWin 9.1, Toad, Sales Force (SFDC), MS Excel 10

Confidential, Cupertino, CA

Sr. Data Modeler / Analyst / Architect

Responsibilities:

• 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.
• Root cause analysis of data issues, ETL issues, Source system issues. Supporting BI Reporting team and escalate issues to concerned groups.
• 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, CA

Sr. Data Modeler / Architect

Responsibilities:

• 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, CA

Data Modeler / Analyst

Responsibilities:

• 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, CA

Data Architect / Modeler / Analyst

Responsibilities:

• 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, CA

Data Modeler

Responsibilities:

• Logical and Physical Data Modeling.
• Understand business requirement