SUMMARY:

• Seven years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing and OLAP Environments
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various New and Existing Applications across Enterprise and Data Warehouse
• Experience in identifying entities, attributes, metrics and relationships, assigning keys and optimizing the model
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Deep understanding and experience in Relational Database Management Systems (RDBMS) like Oracle, SQL Server, MySQL, MariaDB including but not limited to scripting, querying, updating, data extraction, analysis, modeling, testing
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemas
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inmon Data Warehouse methodologies
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio
• Excellent SQL programming skills and developing Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL, Performance tuning and query optimization techniques in transactional and data warehouse environments
• Extensive experience with Normalization (1NF, 2NF, 3NF and BCNF) and Denormalization techniques for improved database performance in OLTP and Data Warehouse/Data Mart environments
• Experience in logical/physical database design & review sessions to determine and describe data flow and data mapping from source to target databases with End Users, BAs, DBAs and Application Architects
• Experience in generating DDL scripts and creating indexing strategies
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitation of JAD sessions
• A good team player with strong interpersonal skills and the capability to work with business users, project managers, team leads, clients, vendors and colleagues, thus maintaining a healthy environment in the project
• Involved in the preparation of Detailed Design and Standards Documentation and Reports

TECHNICAL SKILLS:

Analysis and Modeling Tools: ERwin, Oracle Designer, BPwin, ER/Studio, MS Visio, TOAD, MYSQL Workbench

Languages: SQL, PL/SQL, T - SQL, XML, HTML, UNIX Shell Scripting, C, C++

ETL Tools: Informatica Power Center, Data Stage

OLAP Tools: MS SQL Analysis Manager, DB2 OLAP, Cognos

Databases: MS SQL Server 2008/2005/2000, Oracle11g/10g/9i, Teradata 13.10, MS Access 2000, DB2

Operating Systems: Windows 10,8,7, Linux, UNIX (Sun Solaris 10), MS DOS (CMD)

Project Execution Methodologies: Ralph Kimball & Bill Inmon data warehousing methodology, Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Sr. Data Modeler/ Analyst

Responsibilities:

• Working on PMIX (Product Mix) project, which is designed to deliver daily sales data with accuracy and quality to be used by various departments like Marketing and Research
• Delivery and successful launch of Confidential in 12 new countries for 4 different vendors across LAC, EMEA and APAC regions by Certifying Vendor databases by doing Product Mapping, POS Testing, Database testing, Data Analysis and providing recommendation on required fixes
• Development and enhancement of the PMIX data warehouse model to accommodate new requirements and promotion structure
• Performing data analysis and data profiling using complex SQL queries on various sources systems including Oracle, MYSQL and SQL Server
• Worked on designing a TROD data model to access transactional data broken down Ticket number-wise and implemented in the DEV as well as PROD environments
• Part of the team developing the Dynamic Data Warehouse (DDW) model for Confidential International to include both, Confidential and Tim Hortons historic and current market sales data. Involved in creation of standards, Data discovery effort and providing inputs for development of the conceptual model to in corporate multiple source systems
• Worked with internal architects in the conceptualization and development of current and target state data architectures
• Working on conversion of the current Tim Hortons system to integrate with the existing Confidential data warehouse, to access daily sales data in compliance with the company standards
• Working with Vendors and Franchise to gain an understanding of information and core data concepts behind their business and holding regular joint discussion sessions for requirement gathering, development of concepts and accommodating requests for enhancements
• Working with Marketing Team to assist in creation of product standards and promotions for BK
• Post Production Validation on Live Restaurant Data including Sales Tracking and Percent Mapped Sales to determine consistency in data quality and identify discrepancy
• Extensive use of Tableau server and SQL scripts for Data extraction, visualization and discovery, for various steps of data analysis
• Creation of Graphs and reports in MS Visio for weekly and monthly reporting
• Working with Data Delivery Vendor (SICOM) on required changes in Data Poller Code and subsequent change validation and regression testing
• Current State Data Analysis on Tim Horton’s Restaurant data to understand the reporting quality and provide recommendations for enhancements
• Using Excel to dump the data and analyze based on business needs using Vlookup, Sumifs and other functions and to generate reports using Pivot Tables and Graphs
• Worked closely with the MDS (Master Data Systems) Team to develop structures and product numbers for Value Meals and Promotions
• Performed database validation and troubleshooting of issues with remote access
• Trained and mentored two resources on the current work processes, tools, requirements analysis and reporting
• Verification and enhancement of the data models for Products and Promotions
• Strategizing and developing a data model as part of the International Royalty project that will use the PMIX reporting data to help generate accurate Royalty amounts to Confidential from the respective franchises
• Ensuring that the production data is being replicated into the data warehouse without any data anomalies from the processing databases
• Worked on multiple POCs (Proof of Concept) to test and validate the code changes and databases modifications
• Handling and review of JSON files to determine code accuracy for data delivery of API systems

Environment: Microsoft SQL Server, MYSQL, MYSQL Workbench, MariaDB, Aloha (NCR), Micros Oracle, JSON, Erwin, MS Visio, Aloha (NCR), Micros, MS Excel, Tableau Server, XML

Confidential, Fort Myers, FL

Data Modeler/ Data analyst

Responsibilities:

• Conducting meetings with Business Analysts and Managers from various source systems i.e. SAP, PDM and JDE to understand and document requirements as well as the goal of the project
• Working on data analysis, data profiling, data modeling, data mapping and testing for a given task
• Working on building up a Data model (Logical and Physical Model) for Product Sync Report that would help analyze if the product related data that is being transferred from PDM to SAP AND JDE is consistent
• Worked on Unit Testing for three reports and created SQL Test Scripts for each report as required
• Worked on SAP Sales Order Project to design a model which accommodated the requirements of the Order Book and created a dimensional Data Model (Star Schema) and enhanced it to meet the growing requirements
• Worked on enhancements to the Atomic Warehouse Model on ADW that represented the enterprise wide repository of atomic data for the company that was used for information processing and to track historical changes to the business information over time for various analytical purposes
• Did extensive research and analysis in SAP BW (Business Warehouse) for Sales Order Project
• Worked on Edifice report to create a model which would track the product related data from PDM and link it to the sales and logistics data in SAP in
• ‘Integration’ and ‘Staging’ and later created a Dimensional Model in ‘Cert layer’
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships
• Developed mapping spreadsheets for ETL team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, Transformation Rules and corporate meta-data definitions
• Helped the BI, ETL Developers, Project Manager and end users in understanding the Data Model, data flow and the expected output for each model created
• Gained Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository
• Extensively used Erwin as the main tool for modeling along with Visio
• Used SQL on a wide scale for analysis, performance tuning and testing

Environment: PDM, SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2010, SQL Manager, SAP Logon, Erwin 9.0, Visio, Informatica, Teradata SQL Assistant

Confidential, Stamford, CT

Data Modeler/ Data Analyst

Responsibilities:

• Closely worked with business analysts in the process of requirements gathering for various application specific databases
• Worked on two sources to bring in required data needed for reporting for a project by writing SQL scripts
• Worked on building up the data model for Mobile Banking in the data warehouse
• Worked on building up a SQL query for extraction of data from the warehouse for a reporting schedule (Call Report) for Federal Government
• Worked on designing a Relational Model and Dimensional Model for Interactive Services such as Internet Banking, PC banking and Bill Pay for the bank
• Worked on designing the Net Loss Model for the bank which involves data regarding loans and recoveries
• Worked on building a conceptual and logical model starting from basic fields analysis spreadsheet of Credit Mart as a part of one of my projects.
• Worked on Metadata Repository (MRM) for maintaining the definitions and mapping rules up to mark
• Worked on unstructured modeling for NBO (Next Best Offer) which involved modeling of various marketing strategies involving emails, pictures and marketing material
• Was involved in fulfilling all the end users request which fell under the general maintenance work such as adding and removing columns and tables from data base not without the prior approval from BA’s and Data Modeling Team
• Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements for a project
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets
• Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER-Studio
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions model star and snowflake schemas using Kimball methodology
• Facilitated JAR/JAD sessions to determine data definitions and business rules governing the data, and facilitated review sessions with subject matter experts (SMEs) on the logical and physical data models
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata
• Used data profiling tools and techniques to ensure data quality for data requirements
• Extensively used SQL for performance tuning.
• Developed and executed queries in SQL for reporting using SQL Manager

Environment: ERStudio, Data Stage, Microsoft SQL Server 2008, IBM Data Studio, Oracle 11g, IBM DB2, Db Visualizer

Confidential, Missouri

Data Modeler/ Data Analyst

Responsibilities:

• Provided support in database architecture of the organization through database design, modeling and implementation
• Developed plans, strategies and standards for data within the enterprise
• Gathered and Translated business requirements into detailed production-level technical specifications
• Created an overall data architecture roadmap and designed a Payment Innovation project in both EDW and Cert layer which redefined the way Providers got paid
• Designed Key tables for big tables which helped in reducing the full table scan and enhanced performance
• Worked on the Pharmacy Rx project which helped in assisting customers locating their local pharmacies.
• Regularly updated the source systems with the Staging layer by reverse engineering the source model and filling in the discrepancies in the Stage
• Worked on ITS Claims Analytics Project which helped gain insight in the quality of care and at the same time bend the cost curve
• Maintained Erwin logical and physical data models of the EDW and Cert layer and used Erwin XML generator to export and generate the tables in the Database.
• Maintained and exported metadata including mappings for new and existing designs in CDMA tool
• Assisted the ETL Developers and Testers during the development and testing phases
• Reviewed ETL mapping code after each project to make sure transformation rules are as expected
• Used Model Mart of Erwin r9 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed Erwin HTML and Crystal Reports to generate reports off the designs created for documentation and review purpose
• Developed ETL mapping document after each design with Source to Target mappings and transformation rule
• Partnered with all other teams (database management team, software development team) and users to provide best solutions by maintaining the best standards of practice
• Promoted and deployed best practices concerning Data Architecture including design, development and reporting

Environment: Erwin 9, CDMA Metadata Repository, SQL, Crystal Reports, Informatica 9.6, SQL Server Management Studio

Confidential, New York, NY

Data Modeler/ Data Analyst

Responsibilities:

• Used Erwin case tool for relational database and dimensional data warehouse designs
• Analyzed clinical and financial data, run and format reports, send error reports to clients
• Communicated with clients on a regular basis via email and phone calls answering basic client questions regarding data, processing or reporting issue
• Provided written communication regarding deadlines, decisions, explanations of issues, etc.
• Creating databases for OLAP Metadata Catalog tables using forward engineering of models in ERwin.
• Created use cases, class diagrams, sequence diagrams and data flow diagrams using Rational Rose and Visio for new procedures that would help improve existing processes.
• Prepared high level logical data models and BRD (Business Requirement Document), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Developed an analysis model that included use case diagrams, use case narratives and activity diagrams using UML methodologies in Rational Rose, which provided the development team a view of the requirements for XML design and construction phases
• Monitored the data quality of the daily processes and ensured integrity of data was maintained to ensure effective functioning of the department
• Integrated with developers in utilizing necessary SQL scripting to perform various tasks such as validating and analyzing health care informatics data, to ensure no data anomalies pertaining to validity, content, format, presentation, etc. existed
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases
• Created exhaustive documentation and training tools for all data management functions that prevailed within the department

Environment: ERwin, XML, SQL Server 2005, Oracle 9i, PL/SQL, MS Visio, UNIX, MS Excel

Confidential

Database Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, Analysis, Performance and Data Quality
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats
• Developed Logical and Physical Data models for the loan Systems by using ERWin 7.2
• Conversed with Business Analysts and developers to gather information about the data models (Data Definition) to place the data dictionary in place
• Extensively used Agile methodology as the Organization Standard to implement the data Models
• Redesigned some of the subject areas and introduced some new entities and attributes as per the requirements and also supported database modifications
• Supported the DBA to physically implement the tables in both Oracle and db2 databases.
• Analyzed the physical data model to understand the relationship between existing tables.
• Performed Data Cleansing on tables and columns as per the requirements
• Established process on the work flow to create Work flow diagrams using Microsoft Visio
• Created DMR mapping spreadsheets, Source to Target mapping documents including the transformation rules
• Transformed requirements into data structures which can be used efficiently to store, manipulate and retrieve information
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects

Environment: ERwin, Windows MS Excel, MS Visio, Oracle 10g/9i, TOAD, CSV files, XML files, Cognos, UNIX