SUMMARY:

• Data Modeler/Analyst with 6 years of experience in ODS and data warehouse, Conceptual, Logical and Physical modeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP) systems.
• Detailed understanding of principles and practices of Data Modeling including entity - relationship data modeling techniques; Ralph Kimball's and Bill Inmon methodologies.
• Evaluating Data Sources and strong understanding of Data warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Proficient in identifying Facts and Dimensions and building Star Schema and Snow Flake Schema for modeling a Data warehouse in Relational, Dimensional and multidimensional modeling.
• Worked on Data Profiling, Data Mapping, Data Validation and Data Cleansing for data accuracy between the data warehouse and the source systems.
• Well versed with the concepts of Forward Engineering and Reverse Engineering for the existing databases for Physical models using ERwin tool.
• Demonstrated experience gathering and translating data requirements into data models using modeling tools such as Erwin, ER-Studio. Used Normalization / Denormalization techniques to achieve optimum performance in relational and dimensional database environments.
• Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server 2005 Integration Services (SSIS)
• Experience in using and administering corporate metadata repository standards and best practices.
• Good Knowledge on SQL queries, Dynamic-queries, Sub-queries and creating database objects like Stored Procedures, Triggers, Packages, Cursors and Functions using SQL and PL/SQL for implementing the business techniques.
• Developed Tableau visualizations and dashboards with interactive views, trends and drill downs along with user level security using Tableau Desktop.
• Adept in formulating Test plans, Test cases, Test Scenarios, Test Approaches, Setting up Test Environments in conjunction with the Testing team and expertise in formulating test approaches with Load Testing, Integration Testing, Functional Testing, and User Acceptance Testing (UAT).
• Good Knowledge in creating, managing a new/older Change Records (CR) to approvals and implement: facilitate them across in QA, UAT and PROD environments.
• Identified, documented and communicated CRM configuration and development best practices to the upper management.
• Strong analytic skills with full SDLC understanding (waterfall and agile) including business requirements analysis, functional/detailed design, coding, testing, software release management, post-implementation, business process re-engineering, change management and training.
• Excellent problem solving and decision making capabilities with effective communication, inter personal and project management skills; a self-starter with ability to work independently & adapt quickly to the needs of the team.

TECHNICAL SKILLS:

Data Modeling: Erwin r9.0/8x/7x, ER/Studio 9.7/9.0/8.0/7. x Data Modeling, Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Databases: Oracle 11g/10g/9i, Teradata R12 R13, R14, MS SQL Server 2005/2008/2012, DB2, NoSQL, MS Access

ETL Tools: Informatica, Microsoft SSIS

Reporting Tools: Crystal Reports, Tableau

Operating System: Windows 7/XP, Unix

Tools: & Software: Teradata SQL Assistant, TOAD, MS Office suite

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PHP 5, Java, Javascript, HTML, XML

PROFESSIONAL EXPERIENCE:

Senior Data Modeler / Data Analyst

Confidential, Wilmington, DE

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Establishing best practices for data management while adhering to enterprise standards.
• Conducted JAD sessions and created/maintained database design documentation including logical/physical data models, data dictionaries.
• Created ftp connections, database connections for the sources and targets.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Maintained security and data integrity of the database by building view layer.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical database in the form of Star Schema for Data Mart Design.
• Used Kimball Dimensional Modeling in the design and architecture of a new data warehouse.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
• Created DFD (Data Functional Design) artifacts that incorporated the process flow Visio, Mapping documents and all the specifications for proper ETL implementation.
• Created Unix Shell Scripts for automating the execution process.

Environment: PL/SQL, SQL, INFORMATICA 9.5, Oracle 10g/11g, MS Office Suite 2010, Tableau 8.3, Crystal Reports 2008, SQL Server 2012, Teradata SQL Assistant 12.0, ODS, REDGATE - SQL Compare, TOAD 12.5, CA Erwin 9.0

Senior Data Modeler/Analyst

Confidential, Washington, DC

Responsibilities:

• Gathered requirements, analyzed and wrote the design documents.
• Confidential ended requirements definition meetings with end users and document system/business requirements.
• Developed an in-depth understanding of the business processes and data in the corporation and apply the knowledge towards developing and maintaining the Corporate Data Model and a Metadata Portal
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Responsible for defining the key identifiers for each mapping/interface.
• Documented, and communicated requests for change requests with the requestor and coordinate with the development and testing team.
• Developed data mappings for reports, to correlate data elements on reports to tables/fields in the underlying physical data model.
• Performed analysis of system data to identify p Confidential erns, exceptions and erroneous data
• Reverse engineered all the Source Databases using Erwin.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Trouble shooting issues in Production environment.

Environment: Oracle 10g/11g, Erwin 9.0, Informatica Power Center 9.1, Teradata, Crystal Reports 2008, MS Office 2010, Windows 7.

Data Modeler / Data Analyst

Confidential, Charlotte, NC

Responsibilities:

• Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
• Ensure data design follows the prescribed reference architecture and framework.
• Ensure design reflects appropriate business rules, and facilitates data integration, data conformity and data integrity; Ensure data structures are designed for flexibility to support future business needs and enhancements.
• Develop 3NF modeling and dimensional modeling constructs.
• Worked at conceptual/logical/physical data model level using ERwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and training materials for all data management functions.
• Used Reverse Engineering approach to redefine entities, relationships and Confidential ributes in the data model as per new specifications in ERwin after analyzing the database systems currently in use.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Developed the required data warehouse model using Star schema for the generalized model.
• Used forward engineering approach for designing and creating databases for OLAP model.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Design and govern data services messaging constructs in XSD format.
• Applied conditional form Confidential ing in SSRS to highlight key areas in the report data.
• Understand the relationships across business information and units of data; collaborate with Business Analysts, Data Stewards and Business Customers to identify data usage p Confidential erns and to formulate Business names, definitions and data quality rules for data elements.
• Worked on all data management activities on the project data sources, data migration.
• Worked on creating DDL, DML scripts for the data models.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Understand database performance factors and trends pertaining to very large database design and collaborate with DBAs to implement mitigating physical modeling solutions; provide data structures optimized for information entry and retrieval.

Environment: ERwin 8.2, Oracle 10g, SQL, MS Office, MS SQL SERVER 2008, DB2.

Data Analyst

Confidential

Responsibilities:

• Gathered and analyzed business requirements through continuous discussions with the business analysts, data analysts, and performed GAP analysis of the business rules, user administration and requirements.
• Involved in the study and understanding of existing system and data architecture and proposed changes necessary to in corporate the new data models.
• Reverse Engineered the existing database structure to understand the existing data models so that any changes in corporate would synchronize with current model.
• Created conceptual models and conducted several walkthrough meetings with Architects for approvals and also conducted team meetings for creating logical and physical models from the conceptual model.
• Created physical and logical models using Erwin to effectively translate conceptual model into logical and physical models conforming to the business and data requirements.
• Created a family of stars to effectively translate the physical model into a dimensional model using conformed dimensions, role playing dimensions mini and sub dimensions and fact less fact tables.
• Incorporated enhancements into DW in accordance to Ralph Kimball Design specifications and adhering to the business needs and industry standards.
• Development of Daily and Weekly inventory and sales reports using Micro strategy.
• Worked on integrating data from disparate sources and the was involved with data cleansing, validating and loading, client user and account information
• Implemented performance tuning strategies like sub query fl Confidential ening, view merging and recreating indexes to speed up the performance of highly resource intensive queries.
• Performed logical and physical data modeling and database design for an Oracle Retail Data ODS designed to enable Retail LOB fraud detection data mining with the use of analytics tools.

Environment: Erwin 8, Oracle 10g, DB2, Toad, Windows XP, SQL Server 2005, XML, MS Office Suite.