PROFESSIONAL SUMMARY:

• Seventeen Plus Years’ experience in Enterprise Data Architecture, Data Modeling, Data Analysis, Data Mining, Data profiling, Database Administration, and Data Facilitation. Experience includes designing and building data warehouse star schemas and snow flake schemas for BI systems, OLTP, OLAP systems, ETL projects performing Data analysis, Data cleansing/transforming, Data profiling, creating and maintaining data standards, Source to target mappings. Extensive experience creating conceptual data models, logical data models and physical data models in Erwin, ER - Studio, Oracle Data Modeler, SAP HANA Information or SAP HANA Data Modeling tool, IBM Infosphere Data Architect. Created and maintained Data Dictionary and metadata in several projects. Wrote/built Data Integration packages involving several mappings and workflows in SQL Server SSIS. I have been using Oracle RDBMS for last 17 plus years since Oracle 6, Certified Siebel 7.5 CRM Consultant. Exposure to SalesForce ecosystem and Sales Cloud. Familiar with Tableau.
• Information Modeling, Data Modeling (Conceptual, Logical, Physical, Star schema, Dimensional modeling) using ER-Win, ER/Studio, Infosphere Data Architect, ER Studio, Designer 2000, Data Analysis, database system design and analysis, testing and implementation.
• Experienced in OLTP and OLAP systems, ETL projects performing Data analysis, Data cleansing/transforming, Data profiling & standardization, Source to target mappings, and loading from several legacy systems into the TO-BE systems which includes both Oracle and SQL Server databases. Wrote/built Data Integration packages involving several mappings/workflows in SQL Server SSIS.
• Experience with all Aspects of Data Warehouse Development Lifecycle - Business Requirements Gathering, Dimensional Modeling, Data Mapping, ETL, Presentation Layer/BI Tool Build, Testing, and End-User .
• Involved in Requirements gathering, JAD sessions, Interview SMEs, conduct walkthroughs.
• Excellent communication skills, expert in communicating with business & technical stakeholders across different levels and geographic locations.

TECHNICAL SKILLS:

Domain Expertise & Solutions: CRM, ERP, Application Development, Database, Design, Data Modeling and Integration, Data Conversion, Data Migration

COTS: packages Siebel, SAP, CRM, ERP, Data Modelling (ER-Win, ER Studio, etc.)

DATABASES: ORACLE 6,7,8,9i,10g, 11g, Microsoft SQLServer, Teradata, UDB DB2, Access, Informix, SAP HANA

Case TOOLS: ERWIN, ER/Studio, Oracle Data Modeler, Infosphere Data Architect

BI TOOLS: INFORMATICA, Tableau, Business Objects, Cognos

Programming Languages & Tools: SQL, PL/SQL, Perl, PowerBuilder, UNIX Shell Scripting, HTML, VB Script, C, JavaScript, Salesforce Apex

OTH: CLEARCASE and ClearQuest, MS Office

PROFESSIONAL EXPERIENCE:

Confidential

Sr Enterprise Data Modeler

Responsibilities:

• Translated business user information requirements into data structure requirements. I was also responsible to Oversee new data development and ensures consistency and integration with existing data structures.
• I developed logical and physical database models across multiple platforms and computing environments. I possessed expert Knowledge in working with CA ERWIN CASE tool and also had to use other data modeling tools to quickly develop logical data models like in SAP HANA Information or SAP HANA Data Modeling tool.
• Ensured compliance with the organizations database standards and standards. Participated in the evaluation of new tools and techniques to improve data management for the enterprise. Participated in determining transition strategy from current to new architectures. Provided technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database. Ensured that relational designs and dimensional databases performed effectively and efficiently, logically and physically.

Confidential

Sr Enterprise Data Modeler

Responsibilities:

• I developed conceptual and logical data models for both tabular and geospatial data systems. I provided development expertise in enterprise and project level logical data models which focused on business data. I created ad-hoc database objects from the Operational Data Store to facilitate end-user data access. Provided support in the migration activities of moving from ER-Win 9.6 to Erwin 9.7 I used Informatica ETL tool to load test data into the WHB test environment database which the testing team used to run test cases. Used Informatica power center to pull data into stage area and used different transformations. Wrote SQL and PL/SQL scripts to load heterogeneous data into stage tables. Used Tortoise SVN to maintain code versions. Software used was Informatica Power Center 9.6.1, Oracle 11g and Microsoft SQL Server.
• Led the team in analysis and development of the Quantitative Research Analytical Data Support (QRADS) project. Actively participated in release 1 and release 2 planning, strategy, level of effort and work load distribution tasks.
• Designed and developed the overall approach, architecture and the technical solution for data warehouse project dealing with Hedge Fund and Investment Advisor data sets from vendors like Lipper, Eureka, Barclay, HFI, HFR, Morning Star and Pertrac into the data ware house development environment. I architected new database objects and developed data models in third normal form for both OLTP and OLAP schemas on the project and also optimized database queries to improve performance.
• Designed and developed recommendation documents for each three release of the project. First release involved involving Eureka, Barclay, HFI, Lipper Hedge Fund Data sets and Lipper Tass Investment Advisor data sets provided in text file and XML format. Second release involved Pertrac Hedge fund data set provided in SQL Server database format. Third release involved Morningstar and HFR Hedge fund data set provided in XML and text file formats.
• Used Informatica power center to load data into stage area and development schema, used different transformations. Wrote SQL and PL/SQL scripts to load heterogeneous data into stage tables. Used Tortoise SVN to maintain code versions. Helped in the research and resolution of issues/problems related to ETL, data architecture that were encountered in the project. Issues resolved were related to Informatica ETL processes, the Oracle database schemas objects, data analysis, data architecture, data modeling using Embarcadero ERStudio Data Architect X and SQL Developer Data Modeler, Oracle 11g, Red Hat Enterprise Linux Server release 6.7 (Santiago).
• Developed the AS-IS Data models which included the Conceptual Data Models, Logical Data Models and the Physical Data Models. Developed system Test Plan and over saw the system testing effort and provided recommendations that improved performance.

Confidential

Data Analyst

Responsibilities:

• Reverse engineered the ETL code (Informatica) into the BRS (Business Rules Spreadsheets)
• Delivered about 100 BRSs which included Fact and Dimension table business rule spreadsheets.
• Performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc. DB2 & SQL Server were the RDBMS.
• Developed mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping. Reports were in Microstrategy.
• Mentored junior members of the team members

Confidential

Mortgage Loan Origination/Servicing Data Analyst/Sr. Data Modeler

Responsibilities:

• Worked with identified business users to define data requirements.
• Defined corporate metadata definitions for all Enterprise Data supported databases (operational source systems, data stores and data marts).
• Performed Data Analysis, Data Profiling & Validity, Data cleansing rules etc.
• Developed mapping spreadsheets that will provide the Data Warehouse Development (ETL) team with source to target data mapping.
• Developed logical and physical data models that document source data from multiple sources (Client’s internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc.).
• Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team. Assisted in the review of database structures of proposed business application purchases.
• Reverse Engineered Data Models from the existing databases and also created data models from the DDLs. Generated DDLs from the final physical Data Models.
• The project involved working in an agile development environment.
• Supported loan origination system (LOS) which was built on SQL Server 2012, was involved in supporting, enhancing, and analyzing existing business applications like LOS.
• Worked with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.

Sr. Enterprise Data Modeler

Confidential

Responsibilities:

• Support the design and development of an ETL strategy to perform environment and system integration & validation; including ETL using Informatica, Java Data Access, and web services technology.
• Conducted JAD sessions and Requirement gathering meetings with users, stakeholders, and subject matter experts to define and document Data Modeling requirements.
• Lead and Manage Metadata, Data Dictionary and Data governance efforts. Database used was SQL Server 2012.
• Managed and coordinated deployment and testing effort for system integration and user acceptance testing.
• Supported creation and execution of ETL activities and creating source to target mapping documents. The project adopted agile software development methodology.
• Wrote T-SQL scripts for views, stored procedures and data profiling.
• Physical and Logical Data Modeling using IBM Rational Data Architect (RDA) case tool
• Reverse Engineered Data Models from the existing databases and also created data models from the DDLs. Generated DDLs from the final physical Data Models.
• Reverse Engineered the Physical and Logical Data Model from the transactional database using Data Architect (RDA) case tool

Confidential, Washington DC

Data Modeler & SQL Server DBA

Responsibilities:

• Physical and Logical Data Modeling using ER-Win Data Modeler
• Database (Oracle 11g) Table partitioning to improve performance
• Routine Database support including Data refresh, data model, database synchronization etc.
• Responsible for Data Dictionary, Metadata definitions
• Performed Data Model walkthroughs with project stakeholders and peer review with other Data Modelers

Confidential

Data Analyst/Sr. Data Modeler

Responsibilities:

• Design of the database model for System of Record (SOR), Data Migration routines and functions. Provided SQL scripts as part of these modeling effort which involved end to end testing and validating the data migration rules written by the ETL developer.
• Incorporated details for additional scenarios for each of the above mentioned test cases.
• Reverse Engineered the Physical and Logical Data Model from the transactional database tool - Centralized Screening Gateway (CSG) database using ER-Win case, arranged the entities in logical groups and provided a physical data model to the development team and data administration team.
• Wrote SQL scripts and helped in the scrubbing of Personally Identifiable information (PII) for security reasons.
• Designed, developed and tested migration of documents and letters (appeals, waiver request etc.) into the CSG system.
• Worked briefly on the reports management system (RMS), an Oracle OBIEE based Data Warehouse project to house the investigation program statistics.
• Provide technical assistance to OBIEE architecture and upgrade activities to OBIEE 11g.
• Established metadata for the data elements and the entities in the logical model with agreement from the business stakeholders.

Confidential

Data Modeler

Responsibilities:

• Reviewed BUCRS(Use Cases) & FRs to understand requirements and business processes
• Collaborated in JAD & design sessions with the stake holders
• Developed Conceptual, Logical & Physical ER-model for the project

Data Modeler/Analyst

Confidential

Responsibilities:

• Managed a team of five off-shore Siebel Development resources during Design and Analysis phase of the project.
• Responsible for the issues and risks management and resolution
• Responsible for Data Modeling for Conceptual, Logical and Physical models for PCR follow up and completion
• Responsible for the review of DADs (Data Applet Design Documents), Operational Level Processes and business requirements.
• Responsible for managing and designing of Siebel Business Components
• Responsible for updating the PMO with Consolidated weekly Status.
• Participated in requirements gathering and design sessions with the client.

Senior Software Data Modeler

Confidential

Responsibilities:

• Gathered data oriented requirements by coordinating with design, development team.
• Performed detailed Data Analysis, Data Profiling, and Data Quality checks
• Created Logical, Physical data models in Oracle 10g
• Performed Back-end testing using SQL Queries in ORACLE
• Tested the application manually by executing Test Cases
• Performed Black Box testing to check the accuracy of Data Structures
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Used HP Quality Center
• Exposed to Siebel Analytics (OBIEE) on the project

Confidential

Siebel Data Architect

Responsibilities:

• Designed and developed a data migration strategy and a detailed design document to migrate Legacy (Agent X) data into Eagle One, specifically products, accounts, service requests, employees and list of values.
• Data Analyst for the Siebel team, collected requirements as to what AS-IS entity should be mapped to what entity in the Siebel Data model (the To-BE system), helped with data mapping at the BC field and column level.
• Developed SQL scripts to extract data from the legacy system and populate staging tables.
• Developed Oracle stored procedures and packages to push data from staging tables to Siebel EIM tables.
• Executed EIM jobs to migrate products, accounts, service requests, employees and list of values.
• Performed Data modeling for the tables affected using ERWIN 4.1, built logical and physical data models.
• Co-ordinated with DBA's with respect to performance tuning, building of indexes, increasing tablespace and rollback segments.
• Built & maintained Conceptual, Logical and Physical Data Models, used ER-Win 3.5 case tool
• Reverse engineered Physical data models and Logical data models from the existing database schemas in Oracle.
• Created DDL script from the Erwin software after updating the data model as per requirements.
• Created and/or maintained database objects like tablespaces, tables, indexes, views, sequences, stored procedures, packages etc.
• Prepared Entity Mapping documents between the source and destination entities.
• Built & maintained a Logical and Physical Data Model, used ER-Win 3.5 case tool
• Reverse engineered Physical data models and Logical data models from the existing database schemas in Oracle.
• Created DDL script from the Erwin software after updating the data model as per requirements.
• Created and/or maintained database objects like tablespaces, tables, indexes, views, sequences, stored procedures, packages etc.
• Performed Data Modeling (ER-Win) and data mapping as the change of phases took place.
• Used EIM to perform various imports and merging of data related to Opportunities, Contacts, and Products.