SUMMARY:

• Overall 9 years of professional experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes and canonical model.
• Solid hands on experience with administration of data model repository, documentation in metadata portals in such as Erwin, ER Studio and Power Designer tools.
• Strong working Experience with Agile, Scrum, Kanban and Waterfall methodologies.
• Capture, validate and publish metadata in accordance with enterprise data governance policies and MDM taxonomies.
• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
• Extensive experience in development of T - SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) tools.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data warehousing environments.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes.
• Conduct data analysis, mapping transformation, data modeling and data-warehouse concepts.
• Experience in designing Logical, Physical & Conceptual data models for to build the Data Warehouse.
• Experience in conducting Joint Application Development (JAD) sessions with SMEs, Stakeholders and other project team members for requirements gathering and analysis.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.
• Solid Excellent experience in creating cloud based solutions and architecture using Amazon Web services (Amazon EC2, Amazon S3, Amazon RDS) and Microsoft Azure.
• Excellent knowledge on creating reports on SAP Business Objects, Web reports for multiple data providers.
• Excellent experience in writing and executing unit, system, integration and UAT scripts in a data warehouse projects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ, and MDM
• Experience in designing Star schema, Snowflake schema for Data Warehouse, ODS architecture.
• Hands on experience in SQL queries and optimizing the queries in Oracle, SQL Server, DB2, and Netezza.
• Experience in working with RDBMS like Oracle, Microsoft SQL Server and Teradata.
• Experience in data analysis to track data quality and for detecting/correcting inaccurate data from the databases.
• Good Knowledge on SQL queries and creating database objects like stored procedures, triggers, packages and functions using SQL and PL/SQL for implementing the business techniques.

TECHNICAL SKILLS:

Cloud Management: Amazon Web Services(AWS), Amazon Redshift

Data Modeling Tools: ER/Studio V17, Erwin 9.7, Power Sybase Designer 16.6.

OLAP Tools: Tableau, SAP BO, SSAS, Business Objects, and Crystal Reports 9

Cloud Platform: AWS, Azure, Google Cloud, Cloud Stack/Open Stack

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Databases: Oracle 12c, Teradata R15, MS SQL Server 2017, DB2.

Testing and defect tracking Tools: HP/Mercury, Quality Center, Win Runner, MS Visio 2016 & Visual Source Safe

Operating System: Windows 10/8, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend, Tableau, and Pentaho 6.1.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.

PROFESSIONAL EXPERIENCE:

Confidential - Wayne, PA

Sr. Data Modeler/Data Analyst

Responsibilities:

• As a Sr. Data Modeler/Data Analyst I was responsible for all data related aspects of a project.
• Translated business and data requirements into data models in support of Enterprise Data Models, Data Warehouse and Analytical systems.
• Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.
• Developed Data Warehouse Dimensional modeling and maintain the Data Warehouse Bus Matrix Architecture.
• Worked on master data (entities and attributes) and capture how data is interpreted by users in various parts of the organization.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues to develop specifications.
• Performed rigorous data analysis and data discovery and data profiling.
• Performed GAP analysis to analyze the difference between the system capabilities and business requirements.
• Used Agile Method for daily scrum to discuss the project related information.
• Maintained Data Mapping documents, Bus Matrix and other Data Design artifacts that define technical data specifications and transformation rules.
• Worked with MDM systems team with respect to technical aspects and generating reports.
• Understand database performance factors and trends pertaining to very large database design.
• Collaborated with DBAs to implement mitigating physical modeling solutions.
• Provided data structures optimized for information entry and retrieval.
• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).
• Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches and implemented Slowly Changing Dimensions.
• Performed detailed data analysis to analyze the duration of claim processes.
• Created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
• Create and maintain data model/architecture standards, including master data management (MDM).
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram).
• Created and maintain the metadata (data dictionary) for the data models.
• Designed OLTP system environment and maintained documentation of Metadata.
• Monitored the Data quality and integrity of data was maintained to ensure effective functioning of department.
• Extensively experience in PL/SQL programming Stored Procedures, Functions, Packages and Triggers
• Managed database design and implemented a comprehensive Star-Schema with shared dimensions.
• Loaded and transformed large sets of structured, semi structured and unstructured data using Hadoop/Big Data concepts.
• Created and publish regularly scheduled ad hoc reports as needed.
• Involved in data lineage and Informatica ETL source to target mapping development, complying with data quality and governance standards.
• Wrote and executed unit, system, integration and UAT scripts in a Data Warehouse projects.
• Assisted in defining business requirements and created BRD (Business Requirements Document) and functional specifications documents.
• Supported development team & QA team during process design and during performance tuning, Test Strategy and test case development.

Environment: OLTP, Erwin v9.7, Agile, MDM, Oracle 12c, SQL, XML, AWS, Python 3.6, Redshift, PL/SQL, 3NF, SSAS, Metadata, ETL

Confidential - Greensboro, NC

Sr. Data Modeler/Data Analyst

Responsibilities:

• Massively involved in Data Modeler/Analyst role to review business requirement and compose source to target data mapping documents.
• Gather all the analysis reports prototypes from the business analysts belonging to different Business units.
• Interacted with Business Analysts to gather the user requirements and participated in data modeling JAD sessions.
• Worked with Business users during requirements gathering and prepared Conceptual, Logical and Physical Data Models.
• Extensively used Agile methodology as the Organization Standard to implement the data Models.
• Actively participated in JAD sessions involving the discussion of various reporting needs.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.
• Interacted with Business Analyst, SMEs to understand Business needs and functionality for various project solutions.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Reverse Engineering the existing data marts and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforced referential integrity constraints.
• Developed the data warehouse model (Kimball’s) with multiple data marts with conformed dimensions for the proposed central model of the Project.
• Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using E/R Studio Data Modeler.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object model, and system object model as they evolve and change.
• 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.
• Wrote PL/SQL statement, stored procedures and Triggers for extracting as well as writing data.
• Worked extensively on Data Migration by using SSIS.
• Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of the legacy application.
• Defined facts, dimensions and designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using E/R Studio.
• Involved in Data profiling and performed Data Analysis based on the requirements, which helped in catching many Sourcing Issues upfront.
• Developed Data mapping, Transformation and Cleansing rules for the Data Management involving OLTP, ODS and OLAP.
• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Normalized the database based on the new model developed to put them into the 3NF of the data warehouse.
• Created SSIS package for daily email subscriptions to alert Tableau subscription failure using the ODBC driver and PostgreSQL database.
• Designed logical and physical data models, Reverse engineering, Complete compare for Oracle and SQL server objects using E/R Studio.

Environment: PL/SQL, E/R Studio v17, MS SQL 2016, OLTP, ODS, OLAP, SSIS, Tableau, ODBC, Transact-SQL, TOAD, Teradata r15, SQL Assistant

Confidential - Newport Beach, CA

Sr. Data Modeler

Responsibilities:

• Worked as a Sr. Data Modeler to generate Data Models using E/R Studio and subsequent deployment to Enterprise Data Warehouse.
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Involved in designing and developing SQL server objects such as Tables, Views, Indexes (Clustered and Non-Clustered), Stored Procedures and Functions in Transact-SQL.
• Developed scripts that automated DDL and DML statements used in creations of databases, tables, constraints, and updates.
• Involved in modeling business processes through UML diagrams.
• Developed Logical and Physical Data models for the loan Systems by using E/R Studio.
• Conversed with Business Analyst and developers to gather information about the data models (Data Definition) to place the data dictionary in place.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Supported the DBA to physically implement the tables in both oracle databases.
• Established process on the work flow to create Work flow diagrams using Microsoft Visio.
• Developed the Conceptual Data Models, Logical Data Models and transformed them to creating schema using E/R Studio.
• Developed the Data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Forward Engineering the Data Models, Reverse Engineering on the existing Data Models and updates the data models.
• Build and maintain SQL scripts, Indexes, and complex queries for data analysis and extraction.
• Identified and documented data sources and transformation rules required to populate and maintain data Warehouse content.
• Involved in extracting, cleansing, transforming, integrating and loading data into different Data Marts using Data Stage Designer.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Worked on Data governance, data quality, data lineage establishment processes.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.

Environment: E/R Studio v13, SQL, SQL server 2014, Transact-SQL, DDL, DML, UML diagrams, OLAP, Microsoft Visio 2014

Confidential - Malvern, PA

Sr. Data Analyst/Data Modeler

Responsibilities:

• As a Data Analyst/Modeler responsible for Conceptual, Logical and Physical model for Supply Chain Project.
• Participated in JAD sessions involving the discussion of various reporting needs.
• Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
• Interacted with the Subject Matter Experts (SME's) and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Assisted in analysis and recommendations on which Reporting tools.
• Created Database Tables, Views, Indexes, Triggers and Sequences and developing the Database Structure.
• Wrote a complex SQL, PL/SQL, Procedures, Functions, and Packages to validate data and testing process.
• Generated reports using SQL Server Reporting Services from OLTP and OLAP data sources.
• Designed and Developed Use Cases, Activity Diagrams, and Sequence Diagrams using Unified Modeling Language (UML).
• Designed Star and Snowflake Data Models for Enterprise Data Warehouse using PowerDesigner.
• Developed, documented and maintained logical and physical data models for development projects.
• Identified the facts and dimensions and designed star schema model for generating reports.
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Involved in modeling business processes through UML diagrams.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Worked alongside the database team to generate the best Physical Model from the Logical Model using Power Designer.
• Developed Cleansing and data migration rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used Crystal Reports to generate Ad-Hoc Reports

Environment: SQL, PL/SQL, OLTP, OLAP, SQL Server 2012, Sybase Power Designer 16.5

Confidential

Data Analyst

Responsibilities:

• Performed Data analysis and Data profiling using complex SQL on various sources systems.
• Developed SAS macros for data cleaning, reporting and to support routing processing.
• Created SQL scripts to find Data quality issues and to identify keys, Data anomalies, and Data validation issues.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirement.
• Used MS Visio for business flow diagrams and defined the workflow.
• Performed Data analysis for the existing Data warehouse and changed the internal schema for performance.
• Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.
• Experienced in developing business reports by writing complex SQL queries using views, volatile tables.
• Extensively use SAS procedures like means, frequency and other statistical calculations for Data validation.
• Performed Data Analysis and extensive Data validation by writing several complex SQL queries.
• Involved in design and development of standard and ad-hoc reporting using SQL/SSRS
• Identified source databases and created the dimensional tables and checked for data quality using complex SQL queries.
• Responsible for data lineage, maintaining data dictionary, naming standards and data quality.
• Performed Data Manipulation using MS Excel Pivot Sheets and produced various charts for creating the mock reports.
• Used SQL Server and MS Excel on daily basis to manipulate the data for business intelligence reporting needs.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.

Environment: SQL, SAS macros, T-SQL, MS Visio 2010, MS Excel 2010, SQL Server 2010