SUMMARY

• Senior Data Modeler / Analyst with 7+ Years of IT professional experience in Data Modelling, designing, developing, and implementing data models for enterprise - level applications and systems. These models are architected at the following layers: conceptual, logical, business area, and application.
• Experience in analysis, design, and development of enterprise data warehouse models for business intelligence / reporting.
• Has overall 7+ years of experience in Interpretation of data.
• Experience in Data Warehouse modelling for large/complex business intelligence process including development of dimensional modelling.
• Strong background in developing high performance queries, view, procedures, Informatica ETL, etc.
• Has overall 6 years of experience in designing data flow diagrams.
• Extensive experience in working with tools like Erwin, Oracle Designer, Power Designer and MS Visio for creating data models.
• Provided ER diagrams in the projects using tools like Erwin and Visio.
• Has a good understanding on various business processes in all of my projects.
• Extensive experience in reverse engineering databases, Complete compare using ERwin.
• Experience with various methodologies for creation of data models for data warehouses and data marts.
• Extensive experience in working closely with End-Users, Business Users, Clients for gathering User and Business Requirements and authoring business processes with project teams.
• Designed and developed Data models for Database (OLTP), the operational data store (ODS), Data warehouse (OLAP), and federated databases to support client enterprise Information Management Strategy.
• Strong Knowledge in Data Transformation and Data Mapping from source to target database Schema’s and also data cleansing.
• Designed Data flow Diagrams, and Activity Diagrams, to support the development team and business groups.
• Extensive experience in Database Creation and maintenance of physical data models with Oracle and SQL Server data bases.
• Extensive experience in Performance tuning databases for optimum performance.
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives.
• Self-motivated diligent, ability to adapt to new environments and situations quickly, good grasping ability, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.

TECHNICAL SKILLS

Data Modeling Tools: ERwin r7.1/7.2, Erwin R8.2.5, R9.5

Project Design & Architecture: MS Visio 2000/2007/2010

Business Intelligent Tools: OBIEE, SAS, COGNOS, QLIKE View

OLAP Tools: Microsoft Analysis Services, and Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS, SSRS and Informatica 7.1.3

Programming Languages: SQL, T-SQL, HTML, CSS, XML, ASP.NET, C++. C #

Debugging/Defect tracking Tool: Bugzilla, Rational Clear Quest, JIRA

Testing Tool: Quick Test Professional (QTP), Quality Center (QC), Load Runner & WinRunner

RDBMS: Oracle, MS-Access, SQL Server

Other Tools: VM ware, Toad, Putty

PROFESSIONAL EXPERIENCE

Confidential, Sacramento,CA

Senior Data modeler

Responsibilities:

• Worked as a Data Modeler/Analyst to generate Data Models using Erwin and subsequent deployment to Enterprise Data Warehouse.
• Part of JAD sessions for defining business requirements and translating them into technical specifications
• Developed logical data models and physical database design and generated database schemas using Erwin
• Worked with DBA to create Best-Fit PhysicalDataModel from the logical Data Model using Forward Engineering in Erwin
• Generated and DDL scripts using ERWIN and assisted DBA in Physical Implementation ofdataModels.
• Performed Data analysis of existing data base to understand the data flow and business rules applied to Different data bases using SQL
• Reverse Engineered the existing Stored Procedures and wrote Mapping Documents for them.
• Used Erwin entity-attribute editor and Erwin relationship definition editor to modify, update existing primary, foreign, alternate keys and identifying, non-identifying, recursive and subtype relationships.
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NFmodel
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle, SQL Server and DB2.
• Developed / modified Oracle codes like stored Procedures, Functions, Triggers etc. based on technical and functional specification documents. Used Sub-queries, Merge statements and Joins extensively in stored procedures.
• Defined ETL framework which includes load pattern for staging and ODS layer using ETL tool, file archival process, data purging process, batch execution process
• Designed Mapping Documents and Mapping Templates for the ETL team

Environment: MS Visio, SQL Server 2012, Oracle 11g/12c, Erwin 9.6.

Confidential, Raleigh, NC

Data Analyt/Sr. Data Modeler

Responsibilities:

• Helped conduct meetings with the end users and performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.
• Provided the sequence diagrams, flow diagrams, use case diagrams and ER diagrams for various modules in the project using Rational Rose.
• Designed Logical (relationship, cardinality, attributes, and, candidate keys) and Conceptual models of database using ERwin and VISIO
• Converted the logical model to physical data model, and created objects, aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Used Star Schema and Snowflake schema methodologies in building and designing the logicaldatamodel in the dimensional Models.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created
• Normalized to 3NF to acquire least data repetition required by business.
• 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.
• Developed target mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with Data Quality issues.
• Managed the metadata repository containing data elements, semantics and business rules.
• Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes, anddatarelationships.

Environment: Oracle 12c/11g, Windows 7, PL/SQL, MS-Access, SQL SERVER, MS Office, MS Visio, Erwin 8.2, Teradata 14.10

Confidential, Guilford,CT

Data Modeler/Analyst

Responsibilities:

• Worked with users to identify the most appropriate source of record required to define the asset data for financing.
• Performed data profiling in the source systems that are required for financing.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Collaborated with ETL developers in the creating the Data Functional Design documents.
• Ensured that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Involved in migration projects tomigrate datafrom data warehouses on Oracle and migrated those toDB2.
• Responsible for Generating Weekly ad-hoc reports.
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Designed logical and physicaldatamodels for multiple OLTP applications.
• Understood business and system requirements to architect data and database solutions through logical and physical data modeling to meet project requirements.
• Utilized tools to efficiently build data models and maintain metadata and data model repository.
• Performed data auditing, validation and cleansing as well as metadata mapping and migrations. Documented, developed and implemented data retention and purging policies for centralized, full lifecycle data management. Work with others to maintain high level of system and data security through development and enforcement of security policies, roles and profiles.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin.
• Worked on building thedatamodel using ER Studio as per the requirements, discussion and approval of the model from the BA.
• Analyzed the source systems (Mainframe COBOL copybooks, DB2 and Oracle Databases) to understand the sourcedatarelationships along with deeper understanding of business rules anddata integration checks.
• Interacted with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Extensively worked on SQL in analyzing the database and querying the database as per the business scenarios.
• Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remained knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: MS Excel, MS Access, DB2, Teradata, Oracle 10g, Tableau, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Informatica, Linux, SAS.

Confidential -West Des Moines, IA

Data Analyst/Data Modeler

Responsibilities:

• Facilitated JAD sessions for project scoping, requirements gathering & identification of business subject areas.
• Identified and documented detailed business rules and use cases based on requirements analysis.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Developed Logical Model from the conceptual model.
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
• Used Forward Engineering to generate DDL from the Physical Data Model and handed it to the DBA.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
• Used ETL methodology for data extraction, transformations and loading in a complex Enterprise DataWarehouse (EDW)
• Identified and documented data sources and transformation rules required populating and maintaining data Warehouse content.
• Assisted in Informatica Server jobs to load data from sequential files and flat files.
• Involved in extracting, cleansing, transforming, integrating and loading data into different Data Marts using Data Stage Designer.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.
• Used Erwin's reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships.
• Involved in Performance tuning by leveraging oracle explain utility and SQL tuning.

Environment: Oracle 10g, SQL Server 2008/2012 DB2, Microsoft Transaction Server, Erwin, Teradata 14, CrystalReports, Informatica .

Confidential

Data Analyst/Business Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, Application architects, Technical architects and IT analysts on a scheduled basis.
• Designed and developed UseCases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using Erwin
• Normalized the tables up to 3NF.
• 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 datafrom 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 ondataprofiling anddatavalidation to ensure the accuracy of thedatabetween 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 accuracy of thedatabetween 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.

Environment: Rational Rose, MS Visio, ER/Studio 5.5, Oracle 10 g and 11g, Teradata 12.0 and Erwin 7.3.4.