PROFESSIONAL SUMMARY:

• Eight plus years of prevalent IT experience exceptionally in Data Modeling working as a Data Modeler/Data Analyst in Analysis, Design, Data Modeling (Conceptual, Logical and Physical) for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Experience in working with data modeling tools like Erwin, Informatica, Tableau, Power Designer, Oracle Designer, ER Studio and Microsoft Visio.
• Expertise in Data Integration, Data Analysis, Data Mining, Data Manipulation, Data Visualization, Data Loading, Data Validation, Data Integration, Data warehousing/ ETL, Data Governance, Data Stewardship, Data Profiling, Data Quality, Data Modeling, Data Architecture, Metadata Management, Reference Data Management and Master Data Management (MDM), Collibra Software, and Business Analytics.
• Proficient in all phases of Software Development Life Cycle (SDLC) including in - depth knowledge of Agile Methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Creation and Development of new Power BI reports and data structures setup and maintain Power BI user security and access and also created custom Power BI Dashboards.
• Extensive knowledge in ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data warehousing, OLAP tools.
• Experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using tools like Erwin 9.7/8.2/7.3, Power Designer 15,Oracle Designer, E-R Studio and Microsoft Visio.
• Worked and extracted data from various database sources like Oracle, SQL Server, DB2, regularly accessing JIRA tool and other internal issue trackers for the project development.
• Experience with the full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Experience in modeling with both OLTP/OLAP systems and Ralph Kimball and Bill Inmon Data approaches.
• Experience working with Agile and Waterfall data modeling methodologies.
• Experienced in developing Entity-Relationship diagrams and Modeling Transactional Databases and Data Warehouse using tools like ERWIN, Power Designer, ER/Studio and Microsoft Visio.
• Utilized Erwin's forward/reverse engineering tools and target database schema conversion process.
• Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and a strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD).
• Proficient in Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Designed the Data Marts in dimensional data modeling using Star and Snowflake schemas.
• Experience in supervised and non-supervised machine learning skills using large data sets
• Solid ability to write and optimize diverse SQL queries, including joins, index, profiler, aggregate functions, and string functions
• Experience in creating tables, establishment of ERD, ETL, and deduping
• Experience in T-SQL (DDL, DML), triggers, views, user defined functions and complex stored procedures Experience in creating and managing clustered indexes and non-clustered indexes and optimization of queries using execution plan.
• Proficient at creating Reports, Pivot Tables, VLOOKUP, Hook-up, Index, Graphs, and Match in MS Excel; Proficient at utilizing MS PowerPoint, MS Access, and MS Word
• Experience in database design, including design of new database systems for applications and redesign of existing database systems, relationship, keys, constraints, indexes, and other constraints for data integrity and performance
• Good working knowledge in performance tuning, index tuning, error handling, maintenance, troubleshooting, query optimization
• In a data warehouse environment, designed the staging area based on OLTP concepts, cleansed and profiled before loading into data marts.
• Expert in data acquisition strategies to extract data from different source systems, created data mappings using different transformations and executed workflows for data loads to target systems.
• Created data mappings to load data from the target using different transformations and executed workflows for data loads to target systems.
• Deployed naming standard to the Data Model and followed company standard for Project Documentation.
• Experienced in consulting with users, resolving problems and meeting specific technical and business needs.
• Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently.
• Excellent communication skills, self-starter with the ability to work with minimal guidance.
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.
• Good understanding in Educational, Banking, finance, Health care and Software industry business processes.

TECHNICAL SKILLS:

Data Modelling Languages: Erwin r7.1/7.2/7.3, Erwin r8.2, Erwin r9.1/9.5/9.6/9.7, Sybase Power Designer 15.0/16.5, Oracle Designer, ER/Studio, and Microsoft Visio.

OLAP Tools: Microsoft SQL Server Analysis Services (SSAS), Cognos, Dashboard Designer, Business Objects and Crystal Reports 10/9, Tableau, Power BI, QlikView. Excel.

Programming Languages: SQL, T-SQL, PL/SQL, Base SAS, HTML, XML, C, C++, UNIX and Shell Scripting, R Language, Python.

Database: Oracle, Microsoft SQL Server 2000/2005/2008/2012/2014, NoSQL, Mango DB, MySQL, Oracle 11g/10g/9i/8i, DB2, Sybase, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Oracle Warehouse Builder, Informatica 7.1/6.2, Tableau, Data junction, Ab-Initio, DataStage, SAS Data Management, SQL Server Integration Services (SSIS), BODS

Operating Systems: Microsoft Windows 10/2000/XP/Vista/7, UNIX, LINUX.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA.

Sr. Data Modeler/Data Analyst.

Roles & Responsibilities

• Gathering business requirements by organizing and managing meetings with business stakeholders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Analyzed the business requirements by dividing them into subject areas and understood the data flow.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Support and maintenance of Power BI reports and data structures.
• Design the View models according to the requirements of downstream users like web portals and other consumers.
• Updated existing models to integrate new functionality into an existingapplication.
• Created conceptual and logical models, logical entities and defined attributes, and relationships between the various data objects.
• Developed normalized Logical and Physical database models to design OLTP system.
• Created dimensional models for the reporting system by identifying required dimensions and facts using Erwin 9.
• Designed ER diagrams (Physical and Logical using ERwin) and mapping the data into database objects and identified the Facts and Dimensions of the business requirements and developed the logical and physical models using Erwin.
• Transformed Logical Data Model to Physical Data Model ensuring the Primary Key and Foreign key relationships in PDM, Consistency of definitions of Data Attributes and Primary Index considerations.
• Maintaining and implementing data models for enterprise data warehouse using Erwin 9.
• Designed Star, Snowflake Data Models for Enterprise Data Warehouse using ERWIN 9.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create a graphical representation (E-R diagram) using Erwin.
• Implemented data blending using various data sources and created stories using Tableau for better understanding of the data.
• Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources and proficient in Tableau 10.x/9.x/8.x (Desktop, Server, Online)
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Designed the mapping with a slowly changing dimension Type2 to keep track of historical data.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
• Responsible for defining the naming standards for the data warehouse.
• Verified the correct authoritative sources were being used and the extract, transform and load (ETL) routines would not compromise the integrity of the source data.
• Tuned the SQL Queries by breaking down the predefined queries into smaller queries for processing, Pushed Query processing up from the client to application server level.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the requirements.
• Assisted DBAs in the implementation of the data models.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.
• Conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.
• Conducted Design reviews with the business analysts and content developers to create a proof of concept for the reports.

Environment: Oracle 10g/11g, Erwin 9.5.2/9.6/9.7, SQL Server 2005/2008/2012, MSOFFICE2015, Power BI, Tableau, Crystal Reports.

Confidential, Denver, CO.

Sr. Data Modeler/Data Analyst.

Responsibilities:

• Involved in requirement gathering and analysis of data and interacted with business users to understand the reporting requirements, analyzing BI needs for the user community.
• Worked closely with management to prioritize business and information needs.
• Prepared high-level logical data models using ERwin, and later translated the model into the physical model using the forward engineering technique.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Documented the source to target mappings for both data integration as well as web services.
• Created and maintained logical, dimensional data models for different Claim types.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using Star and Snowflake Schemas.
• Involved in modelling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Normalized the database up to 3NF to put them into the star schema of the Data warehouse.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Identifying the Primary Key, Foreign Key relationships across the entities and across subject areas.
• Created Meta Data Repository and was also responsible for defining the Data.
• Connected to various data sources like SQL Server, Oracle and flat files.
• Presented the Dashboard to Business users and cross-functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Designed data flows that extract, transform, and load data by optimizing SSIS performance.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Responsible for Data mapping testing by writing complex SQL Queries using Oracle SQL Developer.
• Created complex queries to automate data profiling process needed to define the structure of the pre-staging and staging area.
• Struck a balance between the scope of the project and user requirements by ensuring that it covered minimum user requirements without making it too complex to handle.
• Worked on all data management activities on the project data sources, data migration.
• Performed data mining on Claims data using very complex SQL queries and discovered claims pattern.

Environment: Erwin 9.5/8.2, Oracle Database 11g, Crystal Reports, Oracle SQL Developer, Informatica 11.

Confidential, Coppell, TX.

Data Modeler/Data Analyst.

Responsibilities:

• Gathered business requirements through interviews, surveys with users and Business analysts.
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Analyzed business requirements, transformed data, and mapped source data using the TeraData Financial Services Logical Data Model tool, from the source system to the TeraData Physical Data Model.
• Worked on Conceptual, Logical Modeling and Physical Database design for OLTP and OLAP systems.
• Created a logical design and physical design of the centralized relational database.
• Responsible for logical and physical data modeling, database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Used Star schema methodology in building and designing the Logical data model in the dimensional Models.
• Normalized the data up to 3rd Normal form.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Conducted team meetings and JAD sessions.
• Used Rational Requisite Pro to document technical requirements and business user requirements.
• Created logical data model from the conceptual model and its conversion into the physicaldatabase design using forward engineering in Erwin 8.2.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Designed Data Marts using dimensional modeling.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• De-normalized the database to put them into the star schema of the data warehouse.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration using Informatica.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analyst to design weekly reports using a combination of Cognos Impromptu and Powerplay multidimensional.

Environment: Oracle10g/ 9i, Erwin 8.2/7.3, Rational Requisite Pro, Cognos, Crystal Reports, Informatica.

Confidential, Salt Lake City, UT

Data Modeler/Data Analyst.

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Involved in designing context flow diagrams, structure chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Designed and built Data marts by using Star Schema.
• Built and maintained a robust data warehousing system for the organization.
• Created DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from source to the warehouse.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Performed Data Analysis and data profiling using complex SQL on various sources systems including Oracle 10g/11g and TeraData, in order to ensure the accuracy of the data between the warehouse and source systems.
• Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.
• Served as a member of a development team to provide business data requirements, services.
• Utilized organizational standards for data naming, structuring and documentation.
• Responsible for defining database schemas to support business data entities and transaction processing requirements.
• Ensure the business metadata definitions of all data attributes and entities in a given data model are documented to meet standards.
• Ensure the first cut physical data model includes business definitions of the fields (columns) and records (tables) were generated.
• Integrated high - level business rules (constraints, triggers and indexes) with the code.

Environment: Data Stage 7.3/7.0, ERwin7.3/7.2, MS Visio, DB2, Oracle 10g/9i, CSV files, XML files

Confidential

SQL Data Analyst / Report Analyst.

Responsibilities:

• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin 7.0.
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for sales Data mart.
• Generated meta-data reports from data models.
• Used Erwin for creating logical and physical data models for Oracle and TeraData database design, star schema design, data analysis, documentation, implementation and support.
• Used SQL Server Integrations Services (SSIS) for extraction, transformation, and loading data into target system from multiple sources.
• CreatedSSISpackages to clean and load data to the data warehouse.
• Created a package to transfer data between OLTP and OLAP databases.
• A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Involved in mapping the load data to the target based on primary and foreign key relationship considering the constrained based load order.

Environment: ERwin 7.0, TeraData, SQL Server 2000/2005, Oracle 8i/9i.

Confidential

Database Administrator

Responsibilities:

• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Studied the Requirements Specifications, Use Cases and analyzed the data needs of the Business users.
• Implemented conceptual and logical data models using Erwin by adapting agile methodologies as per organization standards.
• Implemented Slowly Changing Dimensions Type 1, Type 2, and Type 3 methodology for accessing the full history of accounts and transaction information.
• Designed and built Data marts by using Star Schema.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Transformed project data requirements into project data models using Erwin.
• Worked with Business Analysts to design weekly and monthly reports using Cognos.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Involved in logical and physical designs and transforms logical models into physical implementations.

Environment: Windows XP/NT/2000, ERwin 7.0, Informatica 8.0, Cognos, MS Office, SQL Server 2000/2005, Oracle 8i/9i.