SUMMARY

• Senior Data Modeler / Analyst with 7+ Years of IT professional experience in Data Modeling, 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.
• Deep Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP&OLAP).
• Experience in Data Warehouse modeling for large/complex business intelligence process including development of dimensional modeling.
• Implemented metadata standards, data governance( data cleaning, data profiling and data analysis)
• Followed different concepts in data modeling like Kimball and Inmon methodologies in designing the data models
• Strong background in developing high performance queries, view, procedures, Informatica ETL, etc.
• Extensive experience in working with tools like Erwin, Oracle Designer, Power Designer and MS Visio for creating data models.
• 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.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies).
• Worked closely with ETL teams such as Informatica to extract data from Source system to target systems and created mappings, Data Reports.
• 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.
• Experienced in master data management (MDM), Metadata management, data quality.
• Strong Knowledge in Data Transformation and Data Mapping from source to target database Schema’s and also data cleansing.
• Designed the PL/SQL procedures for getting the data from all systems to Data Warehousing system.
• The data was standardized to store various Business Units in tables.
• Expertise in creating Schema objects like Indexes, Views, and Sequences.
• 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/r5, Erwin R8.2.5, R9.5, Power Designer

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

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

OLAP Tools: Microsoft Analysis Services, 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 Tools: Bugzilla, Rational Clear Quest, JIRA, HP ALM

Testing Tools: Quick Test Professional(QTP), Quality Center(QC), Load RunnerWin Runner

RDBMS: SQL Server, Oracle, MS Access

Other Tools: VM Ware, TOAD, Putty

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

Sr. Data Modeler/ Data Analyst

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements.
• Conducted team meetings and Joint Application Design (JAD) session.
• Gathered requirements and created use case diagrams as part of requirements analysis.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for education finance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERwin r8.0.
• Modeled a database to store customer demographic and other data, produced functional decomposition diagrams and defined logical data model.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Performed data profiling in Production environment to analyze and collect the statistical information.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• 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.
• Created physical data models using forward engineering, Identified the Facts and Dimensions.
• Identified and tracked the slowly changing dimensions and determined the hierarchies in dimensions.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement and also Involved in Data Mapping.
• Participated in performance management and tuning for stored procedures, tables and database servers
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

Environment: Erwin r8.0, SQL, SQL Server 2000/2005, Toad for Data point, SQL Developer, Teradata for SQL Assistance, Windows XP, Oracle 8i, Windows/NT/2000

Confidential

Sr. Data Modeler/ Data Aanlyst

Responsibilities:

• Responsible for data mapping, metadata maintenance and enhancing existing Conceptual and Physical data models.
• Conducted sessions with architects, business and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.
• Maintained and updated Metadata repository based on the change requests
• Analyzed existing Conceptual and Physical data models and altered them using Erwin to support enhancements.
• Conducted walkthroughs with the DBA to convey the changes made to the data models.
• Utilized Rational Clear Quest to track change requests throughout the process.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, AnalysisandDesign.
• CreatedEntity relationships diagrams, data flowdiagrams and enforced allreferential integrity constraints using Oracle Designer.
• Developed the data warehouse model (star schema) for the proposed central model. Also worked on normalizing star-schema to snow flake schema to fulfil requirement.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Developed source to target mapping documents to support ETL design.
• Created tables, views, sequences, indexes, triggers, table spaces, constraints and generated SQL scripts for physical implementation.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: ERWIN r8.0, Data Modeler, Informatica Power Centre 9.5/9.1, Oracle Designer, SQL Developer, Oracle 11g, Teradata, Netezza, HP ALM, Flat files, Toad, Business Objects, OBIEE.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Built Conceptual, Logical and Physical model and implemented them on Care Synergy.
• Understanding the application and building the database accordingly.
• Participated in meeting with different teams of CMIS, MDM and CAREVIEW and took the requirements and implemented them on Care Synergy.
• Interacted with the business Analyst and getting the functional requirements.
• Gathering accurate data by data analysis and functional analysis.
• Provided 24/7 support on Database perspective in case of any issue raises.
• As this project follows Agile Methodology, I will be working with the QA people closely and load the data for Unit Testing and Manual Testing.
• Check to see data model and database are in sync.
• Data modeling, design & implementation based on established standards.
• Done Data Loading using ETL for QA for testing and also worked closely with the developers and getting the requirement for the database side.
• Forward engineer logical models into physical tables with CCNC naming standard class words.
• Data Quality, Data Migration while loading the data from one database to another.
• Has built a good knowledge on the application and gone through the each and every requirement clearly and implemented those on Database.
• Review the data model with functional team and technical team.
• Followed Data Standard Documents while building the database and participated in Database sessions for finalizing the database structure.
• Created a Data Structure document for each table and column that is implemented on database .
• Designed and developed Data Quality Reports, Chain of Trust Mechanisms for File processing.

Environment: SQL Server 2012, Windows Server 2003, Teradata, Windows XP, SQL Profiler, VSS, TFSErwin r7, DBTA, Initiate - IBM Tool for Person MDM, SQL Management Studio, DBTA, SSIS, Informatica

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Developed logical and physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Conducted data modeling JAD sessions and communicated data-related standards.
• Used Erwin r7.0 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed process methodology for the Reverse Engineering phase of the project.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin’s reverse engineering and target database schema conversion process.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and SQL Server.
• Involved in different team review meetings.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Worked with report developers for building OLAP Cubes for ad hoc reporting.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies. Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.

Environment: Erwin r7.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 serversOracle8i, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL server analysis manager.

Confidential, AL 

Data Modeler/ Data Analyst

Responsibilities:

• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Interacted with users (students, teachers, and medical Staff) using the existing system and Participated in sessions to gather and interpret business requirement and prepare DTD by attending Data Requirements sessions.
• Performed Reverse Engineering of the legacy application using DDL scripts in ERwin, and developed Logical and Physical data models for Central Model consolidation.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the reverse engineering Erwin tool.
• Conducted LDM walkthroughs and validation for EDW, EDW Staging & Data mart models.
• Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the departments.
• Developed data mapping documents for integration into a central model and depicting data flow across systems & maintain all files into electronic filing system.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Worked and extracted data from various database sources like DB2, CSV, XML and Flat files into the Data Stage.
• Worked on DB2 UDB that provides graphical administration, Java and JDBC support & provided performance tuning and capacity planning on Oracle in order to help scale the system and optimize performance techniques for parallel processing.
• Involved in building various logics to handle Slowly Changing Dimensions, Change Data Capture, Upserts and Deletes for Incremental Loads in to the Data warehouse.
• Developed number of AB Initio Graphs based on School requirements using various ABInitio Components like Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Gather, Replicate etc.
• Used Cobol-To-DML utility to generate AB Initio DMLs using mainframe copy books.
• Metadata mapping from source system to target database fields and involved in creating ABInitio DML’s using input Table components.
• Involved in designing fact, dimension and aggregate tables for Data warehouse Star Schema.
• Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Used Ab Initio to create Summary tables using Rollup and Aggregate components.
• Created Multi File Systems, Multifiles (MFS) to run graphs in parallel for better performance.

Environment: ERWIN r5, IBM DB2, AB INITIO GDE 1.12.6.1, PL/SQL, MVS, TERADATA 12.0, ORACLE 9I, DB2 7.1, HP UNIX, CRYSTAL REPORTS 10.