SUMMARY:

• 7+ 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, OLAP and ETL Environment
• Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse.
• Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimising the model.
• Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes
• 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 developed 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.
• Involved in the maintenance of the repositories for the metadata
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Experience in generating DDL scripts and creating indexing strategies.
• Oracle administration on 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and other data migration strategies.
• Proficient in Data Cleansing and Data Profiling based on standards.
• Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
• Good interpersonal and human relation skills to interact with clients and co - workers
• Involved in the preparation of Detailed Design Documentation

TECHNICAL SKILLS:

Analysis and Modeling Tools: ERwin 4.1/7.2/7.0,8.0,r9, Sybase Power Designer, Oracle Designer, BPwin, Rational Rose, ER/Studio, MS Visio

ETL Tools: Informatica Power Center 8.6.1/8.1/7.1, Data Stage 7.5, Ab Initio

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

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

Databases: MS SQL Server 2008/2005/2000, Oracle11g/10g/9i/8i, DB2 V9.5, Teradata V2R6.1, MS Access 2000

Operating Systems: Windows XP/2000/98, UNIX (Sun Solaris 10)

Project Execution Methodologies: Ralph Kimball and Bill Inmon data warehousing methodology, Rational Unified Process (RUP), Rapid Application Development (RAD), Joint Application Development (JAD)

PROFESSIONAL EXPERIENCE:

Confidential, Boca Raton-FL

Sr. Data Modeler

Responsibilities:

• Lead the development and implementation of various strategic data architecture initiatives around Master Data Management, Data Quality, Data Architecture Policies, Standards, Governance, Privacy and Metadata Management.
• Worked closely with project teams, application architects, database administrators and Business Intelligence teammates to ensure consistency in data definitions and data usage across systems and tools
• Architected and maintained Er-Studio logical and physical data models of the data warehouse and data marts.
• Architected and designed UID Store that hosted data for Customer Analytics and also served as a platform for Big Data.
• Worked on Master Data Management(MDM) project in discovery and implementation phase as the DA
• Architected and designed the integration of OMS (Order Management System) and Salesforce.com into the Data Warehouse and Data Mart
• Have been involved with various Vendors to explore the idea of Data Virtualization to see if or how it can be used at ADT
• Developed ETL Mappings in Informatica for multiple reports along with being the DA on the project
• Designed HOA Fire Inspection Report, AR Aging Report, Order and Lead Life Cycle report, lead and Sales Appointments report, Sales Rep Head Count
• Worked on Decommissioning old source systems and replacing them with new, while simultaneously worked on impact analysis and redesigning the impacted Data Warehouse and Data Mart Mappings.
• Lead the development and implementation of various source system integration projects into the Warehouse and Mart
• Worked on Integrating Oracle Supply Chain Data into the Warehouse and Mart for Inventory Turns report.
• Architected dimensionally Sales Appointments Data Mart that tracked Sales Appointments done by Reps with potential customers
• Worked on Service Power Upgrade project and Oracle R12 Upgrade
• Also worked as a backup Database Administrator
• Worked with the Project Managers to create LOE’s (level of Effort) for various projects incorporating the timelines and the resources.
• Actively resolved production support issues on Data Warehouse and Big Data Environment
• Promoted and deployed best practices concerning Data Architecture and served as central 'source of truth' regarding data definitions at data element and entity levels. This covers physical and logical data models, as well as in the reporting object and business glossary levels.
• Was accountable for data architecture design and review processes, including planning and monitoring efforts, reviewing deliverables and communicating to management.

Environment: ER Studio 9.6.1, Oracle 11g/12c, Salesforce.com, DB2, Tableau 9.0, Informatica 9.6, OBIEE, TOAD 11.6, SQL Developer, EBS, PeopleSoft, Service Power, Informix, Mastermind, Temelar, CPQ, OMS (Order Management System), JIRA, SVN

Confidential, Beaverton-OR

Data Modeler/Data Analyst/Testing

Responsibilities:

• Conducted meetings with Business Analyst 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
• Worked on data analysis, data profiling, data modeling, data mapping and testing for a given task
• Original creator of Confidential ’s Enterprise wide Model EDM (Buy Ready Project) for products and services in Teradata Environment based on the data from PDM. Conceived, designed, developed and implemented this model from the scratch
• Worked 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 SAP Sales Order Project to design a model which accommodated the requirements of the Order Book and created a Multi Dimensional Data Model (Star Schema) and enhanced it to meet the growing requirements
• 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 Teradata ‘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 2012, SQL Manager, SAP Logon, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant

Confidential, Minneapolis-MN

Data Modeler/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 extracts
• Worked on building a conceptual and logical model starting from basic fields analysis spreadsheet of Credit Report Mart as a part of one of my projects.
• Worked on Metadata Repository for maintaining the definitions and mapping rules up to mark
• Worked on unstructured modeling for Business Analytics Mart 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
• Used Financial Service Logical Data Model(FSLDM) for referencing my design work
• 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: ER Studio 9.1.0, Informatica, Microsoft SQL Server 2008,IBM Data Studio,, Oracle 10g, IBM DB2, Business Objects XI 3.1,pgAdmin III, Toad, Essbase Studio

Confidential, New York, NY

Data Modeler / Analyst

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Conducted logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Used Model-Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Extracted data from the databases (Oracle and SQL Server) using Informatica to load it into a single data warehouse repository of Teradata
• Created data mapping documents from source to target systems.
• Used Star Schema and Snow flake schema methodologies in building and designing the logical data model in the dimensional Models.
• Developed Conceptual, Logical and Physical data models for Central Model consolidation.
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part of Data Analysis responsibilities.
• Identified and processed the facts and dimension tables.
• Worked with report developers for building OLAP CUBEs for ad hoc reporting.
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation phase
• Assisted end users, operations and testing teams by providing them with the necessary documents

Environment: Erwin r7.1, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000, SQL Server 2000/2005, SQL, Oracle RAC 10g, MS Excel, MS Visio, Rational Rose, Requisite Pro

Confidential, Pittsburgh PA

Data Modeler

Responsibilities:

• Involved with the Business Analysts’ team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Performed the data source mapping.
• Utilized Power Designer’s forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assist developers, ETL, BI team and end users to understand the data model.

Environment: s: ERWIN 4.1.4, DB2 Version 9.0, Teradata 6.2, Oracle 10g, Microsoft Visio, Rochade Metadata Repository

Confidential, Huston TX

Data Modeler/Data Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, Analysis, meta data, 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 Analyst 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.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Interacted with Business analysts and Developers to gather the Data Definitions for the Data Models to get the Data Dictionaries in place.
• 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. Cleansed the unwanted tables and columns as per the requirements as part of the duty being a Data Analyst.
• Established process on the work flow to create Work flow diagrams using Microsoft Visio.
• Trained the team members on ERwin 7.2.
• 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: Data Stage 7.5, ERwin 4.0, PowerDesigner, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, TOAD, CSV files, XML files, Cognos, UNIX, Linux, AWK

Confidential, Lincoln, RI

Data Modeler

Responsibilities:

• Worked with business analyst to gather information on requirements
• 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.
• Involved in modeling business processes through UML diagrams.
• Maintained and build data models based on ACORD standards
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Conducted model walkthroughs and validation sessions.
• Used IBM framework (IAA) for developing the conceptual design for my models
• 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 ERwin
• 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: Erwin, Data Maker, Model Manager, SQL-Server, DB2, Oracle, SSIS, Informatica, Power Center, Cognos, Windows XP, Sun Solaris, Unix, Linux