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
• Architect of Data warehouse/Business Intelligence, BI Architect, Data Architecture, Data aggregate layer, three tier data Staging layer, Landing layer /integration/DW/Presentation, Data Lake.
• Expert in ERWIN, Sybase Power Designer, ER studio, SQL scripting
• Data flow (DFD), UML class modeling, Use cases, activity diagram, Data Strategy, Data Roadmap, Data landscape
• 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 Security, Data Inflow/Outflow.
• 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
• Data Analytic using Tableau, Excel, Data Visualization, Story Telling
• Design ETL architecture, Source to target Data Mapping with pseudo-ETL code, algorithms for Data Pipelines 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, Neo4j (graph db), Tableau, Python, R, RStudio, AWS cloud source.
• Full project life cycle, SDLC, PLC experience
• Created analytical/data science Reports for Business Intelligence using Qualitative analysis and Quantitative Analysis
• Familiarity with TOGAF. Worked in Agile Environment, Confluence, JIRA

TECHNICAL SKILLS

RDBMS: ORACLE 7.x,8i.X/9i/10g/11g, MS SQL Server 2012/2016, 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, Hbase, Neo4J 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, 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, Db visualize, Jira, Confluence

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

PROFESSIONAL EXPERIENCE

Confidential, San Francisco CA

Sr. Data Architect

Responsibilities:

• 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 in data warehouse, Data Lake
• Customer segmentation analysis, behavior analysis, persona analysis.
• Created conceptual, logical unify customer data model. Embedded No SQL data Model
• Reverse engineer existing data models.
• Created 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, data security.
• 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 and Data Pipelines, Data Strategy, Data roadmap, Data Landscape sessions. Data Architecture Framework
• Presentation/Review of Data Model with Technical team, Presentation of Architectural Design Document to Various teams.
• Written Stories in Confluence.

Environment: Oracle SQL Modeler, Oracle SQL developer, Oracle 12c, MS SQL Server 2012/2016, Hadoop, Hive, Pig, scoop, DB-visualizer, Power Point, Lucid chart, Agile, Confluence, Jira, Power Point, Retail, Sql Developer

Confidential, Mountain View CA

Sr. Data Architect / Sr. Data Modeler

Responsibilities:

• 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, Data Strategy, Data road map, Data Security, Data Masking
• 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 Algorithms for Data Pipeline and Data transformation.
• Extensive data analysis using SQL programming, DDL creation.

Environment: ERWin 9.5, MS SQL Server 2012/2016, Jira, Hadoop(HIVE), Pig, scoop, Agile

Confidential, San Francisco

Data Analyst/Data 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 Mart
• Synthesized complex data analytic with MS Excel analysis using advanced features including pivot table, statistical formulas, v-lookup.
• Data Visualization using Tableau, Excel, Power Point. Story telling
• Created Graphs pie chart, Bar Chart, Line chart, Area Chart, Bubble Chart, Dashboard using data science trend analysis, heat map
• Monthly, Quarterly, Yearly reporting. Reports like % fallout, trending, top 5 best, bottom 5, Platform changes, Product changes, quarterly comparison, monthly comparison, Scheduled, Unscheduled Product releases, Weekly progress of releases. Release content analysis. etc..
• Achievements: Help them determine health of Product/Platform. Determine budgets for next quarter.

Environment: Tableau.9.5,Ms-Excel 2016, Power Point, Clearquest, RemedyPac2000, Crest, Project Management universal, Stamp

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 Hbase using Flume
• Data ingestion of flat file to Hadoop Hbase using Hive,pig
• JSON File/ Flat file analysis using Hive queries
• 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, Excel
• Data Analysis/basic statistical analysis of excel/json/xml/mysql data using R-studio,
• Dashboard creation using Tableau, Excel, Power point
• Familiarity with Cassandra, Couch base, Map reduce, Pig
• Basic file loading/parsing Python scripting,
• Data created in Neo4j, Data loaded in Neo4j from Rdbms, Json file
• Created and inserted collection in Mongodb. Data loading from json file to Mongodb
• Familiarity with Scala and Spark, redshift, cloudera

Confidential, San Ramon CA

Sr. Data Architect / Sr. Data 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
• Created Data Architecture Framework, Strategy, Roadmap for Data warehouse
• Created Data Warehouse Architecture of Multiple Layers
• 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, Data Security, Data Masking, Data Classification
• 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 Algorithms for Data Pipeline, Data transformation and Data Integration.
• 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.
• Click stream analysis, CRM analysis, Web Matrics, Channel Performance Matrics, Customer Satisfaction Matrics,
• Data Analytic reporting Performance, Operational, Customer satisfaction, Scoreboard using data science quantitative analysis, quality analysis
• Achievements: Based on Performance of channels. Some third party channels closed. Call center reduced. Failed Payment plan closed. Payment arrangement programs which were not popular closed.

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

Confidential, Cupertino CA

Sr. Data Modeler/Analyst/Data 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 Data Warehouse Architecture of Multiple Layers
• Created Data Architecture Frameworks
• 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 with Algorithms for Data Pipeline, Data transformation and Data Integration.
• 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
• 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 CA

Sr. Data Modeler /Data 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, Data Security
• 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 (BI)
• 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 with Algorithms for Data Pipeline, Data transformation and Data Integration
• 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/Data 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 (BI)
• 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
• Created ETL mapping documents with Algorithms for data pipeline, Data transformation and Data Integration
• 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

Environment: SalesForce, Erwin 7.1

Confidential, San Francisco CA

Data Architect/Analyst

Responsibilities:

• 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
• 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, Data Security
• 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
• Create reports finance reports, Payment Analysis, Media (magazines, Advertise) Revenue Analysis, Sales Region analysis, Subscriptions Analysis, Top 5 advertiser, Magazines. Media Performance analysis
• Achievements: Help making decision about which advertise, which magazine, which region it is popular and need to continue. Failed one closed.

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 CA

Data warehouse Architect/Sr. Data Modeler

Responsibilities:

• 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.
• Created 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, algorithms of data pipeline, Data transformation
• 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

Responsibilities:

• 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

Responsibilities:

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

Sr. Data Modeler /DBA

Responsibilities:

• 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

Responsibilities:

• 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

Confidential, MI

Project Leader /Architect

Responsibilities:

• Project planning; Project scheduling, Strategy/Policy/Standards Establishment, Issue resolution, Resource allocation, User interaction, Presentation to the client.
• Involved in system study, analysis, designing. (JAD), Requirement Specification,
• Logical Data Model, Data Normalization, Business Model and technical architecture

Environment: Designer 2000 VER. 1.35, Oracle 7.x, UNIX. MS Project 98, Windows