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, 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 optimizing the model
• 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 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 therepositories 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

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, DB2, Greenplum

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

PROFESSIONAL EXPERIENCE

Confidential, 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
• Designing 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 scratch
• 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
• 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 9.0,Visio, Informatica, Business Objects XI, 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 extracts
• 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 9.1.0,, Data Stage, Microsoft SQL Server 2008,IBM Data Studio, EMC Greenplum, Oracle RAC 11g, IBM DB2, Business Objects XI 3.1,pgAdmin III, Db Visualizer 8.0.10

Confidential

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
• Create an overall data architecture roadmap and designed 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
• Partner 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, FACETS, SQL, Sybase, 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.
• Analyze clinical and financial data, run and format reports, send error reports to clients.
• Communicate with clients on a regular basis via email and phone calls answering basic client questions regarding data, processing or reporting issue.
• Provide 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 includes 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 ensure integrity of data was maintained to ensure effective functioning of the department
• Integrated with developers in utilizing necessary PL/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 r7.0, Rational Rose, XML, SQL Server 2005, Oracle 9i, PL/SQL, MS Visio, MS Access2000, UNIX, Windows XP/NT

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Interviewed the end users for gathering information to determine requirements, data, report requirements, Analysis, metadata, 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 7.0, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, TOAD, CSV files, XML files, Cognos, UNIX