PROFESSIONAL SUMMARY:

• IT professional with over 7 years of experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems.
• In depth Knowledge in Data Warehousing, ETL and Business Intelligence Reporting Architecture.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin 7.0/4/0, Power Designer, Embarcadero ER Studio and Microsoft Visio.
• Well versed in Normalization and De - Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience working with Agile and Waterfall data modeling methodologies.
• Experience working with Requirement Gathering.
• Well versed in Normalization (1NF, 2NF, 3NF and BCNF)/ De-normalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Experience working with Zachman framework.
• Experience in designing a canonical model.
• Experience in Ralph Kimball and Inmon approaches.
• Strong experience in ER Diagrams, Conceptual, Logical and Physical Data modeling that involved requirement analysis with business team and translating them into Technical Specs.
• Experience in OA Framework personalization for Self Service Web pages.
• Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development (JAD) sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Involved in the critical design review of the finalized database model.
• Worked on various domains like Retail, Insurance, Banking and Health care.
• Worked extensively with XML schema designing and XML data.
• Expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Worked with various RDBMS like Oracle 9i/10g/11g/12c, SQL Server 2005/2008, DB2 UDB, Teradata.
• Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Experienced in Data loading using PL\SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.
• Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.
• Very Good exposure to ETL tools like Informatica, Micro Strategy and IBM Data Stage andSSIS2008/ 2005.
• Building reports using SQL SERVER Reporting Services (SSRS 2005/2008), Crystal Reports, Micro strategy, Business Objects and Cognos.
• Experience in using and maintaining Metadata Management Tools for maintaining Business and Technical Metadata.
• Have extensive experience, coordinating with testing teams for Integration Testing, User Acceptance Testing (UAT) and also with Production Support Teams on critical and urgent Production Issues.
• Excellent verbal, presentation and written communication skills. Able to communicate with technical, non-technical and senior management audiences. Have played a significant role in requirements planning, client interaction and documenting.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Data Modeling Tools: CA ERwin 7.2/8.2.05/9.5, System Architect 11.3, Rational Rose 2000, MS Visio 2000/2007/2010, ER Studio, ER Studio and Oracle Designer, SAP PowerDesigner.

Databases & Database Tools: MS & SQL servers 2000/2005/2008, Oracle 9i/10g/11g/12c, MS Access 2003/2007/2010, Teradata, DB2,TOAD 9, Data Stage XE 390, Kalido 7, Queryman 5/6, Informatica 9.1,8.x, SQL*Plus,TD SQL Assistant.

Reporting Tools: Cognos 8, Business Objects XI, Crystal Reports 2008, Actuate Reports 10, OBIEE, Qlikview, MicroStrategy, Tableau.

Programming Languages: UML, XML, XSD, XSLT, HTML, JavaScript, .NET 2.0/3.0/4.0 based C# and VB, ASP .NET, C, C++, Python, R, MATLAB.

PROFESSIONAL EXPERIENCE:

Confidential, Pataskala, OH

Sr. Data Modeler

Responsibilities:

• Assisted the business analyst in gathering functional requirements and creating BRDs (Business Requirement Documents) and supporting documents containing the essential business elements and detailed definitions.
• Prepared High Level Logical Data Models with descriptions of the relationships and documented business data requirements as well as worked with the team in the generation of Physical data model.
• Mapped business need to subject area models and logical enterprise model.
• Identified facts and worked on dimensional modeling necessary to support business requirements.
• Identified & tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Developed source to target mapping documents to support ETL design.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Ensured production data being replicated into the ODS and the data warehouse without any data anomalies from the processing databases.
• Provided data modeling support for numerous strategic application development projects.
• Reverse engineered from Toad database to Erwin and generated SQL script through forward engineer in Erwin.
• Worked along with architecture team to get metadata approved for the new data elements that are added for this project
• Assisted the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes
• Involved in extensive Data Analysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to all company products.
• Used SQL joins, aggregate functions, analytical functions, group by, order by clauses and interacted with DBA and developers for query optimization and tuning.
• Worked on indexes, partitioning and materialized views by interacting with DBA
• Worked with ETL team using SSIS packages, to plan an effective package development process, and design the control flow within the packages.
• Interacted with SSRS reporting team to gather reporting requirements, and review summary tables.

Environment: CA ERwin 9.5, PL/SQL Developer, TOAD Data Analyst - 2.1,Oracle 9i,Quality Center- 9.2, Informatica Powercenter 9.1, Qlikview 11.2 SR3, Microsoft Access, TD SQL Assistant, Microsoft Visio, SQL Server 2000, Tableau, MS PowerPoint, MS Access, Microsoft Excel.

Confidential, Duluth, GA

Data Modeler/Analyst

Responsibilities:

• Gathered the business requirements document and analyzed the data.
• Created logical data models from the conceptual data models and its conversion into physical data model design using Erwin.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in Erwin, and worked with the naming standards utility. Interacted with the database administrators and business analysts for data type and class words.
• Worked on Bill inmon methodologies for modeling.
• Design discussions and meetings to come out with the appropriate data mart at the lowest level of grain for each of the dimensions involved.
• Involved in the creation of the solution definition document (SDD) which was the basic source of information for the project requirement document.
• Worked with the production engineer, business team and ETL engineers for designing the high level analysis and design document (HLD).
• Worked on different source databases like oracle, DB2 and Teradata and performed GAP analysis on Teradata.
• Created the logical model in third normal form and created the Type 1 and Type 2 slowly changing dimensions (SCD) and hierarchical dimensions.
• Data profiling and analyzing the requirements and developing models using reverse engineering.
• Used denormalization techniques to create summary table and improved complex join operations.
• Worked on Master data management (MDM) and data governance for improving data quality.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Worked in supporting, promoting and documenting all data management processes and procedures related to company data
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies
• Worked with the global technical data community and assist with implementing the global data management strategy.
• Worked with Oracle SQL Developer to develop the SQL scripts.
• Created tables, views and SQL scripts and mapping documents.
• Conducted performance tuning of the database, which included creating indexes, optimizing SQL statements and monitoring the servers.
• Performed integrated testing for various mappings and tested the data integrity among various sources and targets.
• Interacted with the teams working on OBIEE and crystal reports for troubleshooting their report discrepancies.
• Designed sales hierarchy dimensions to handle sales hierarchical reporting both historically and dynamically
• Prepared analytical and status reports and updated the project plan as required.

Environment: CA ERwin 9.5, PowerDesigner 16.0, Teradata, TD SQL Assistant, MS SQL Server 2008, Toad Data Analyst SSIS/SSAS/SSRS 2008,MSTR, SQL Server Profiler, Informatica 9.1, MicroStrategy, CA ERwin Data Modeler 8.2, SQL Server Management Studio.

Confidential, Tulsa, OK

Data Modeler/Analyst

Responsibilities:

• Interacted with the Business analyst for gathering requirements.
• Identified the key facts and dimensions necessary to support the business requirements to develop the logical dimensional models.
• Used UML for creating Activity diagrams, Sequence Diagrams.
• Defined and processed the facts and dimensions.
• Used ER/Studio for relational database and dimensional data warehouse designs.
• Translated the logical model into physical model using Forward Engineering technique in ER/studio tool for both OLAP and OLTP systems.
• Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
• Conducted and participated in joint application design (JAD) sessions with the users, modelers, and developers for resolving issues.
• Conducted design discussions and meetings to come out with the appropriate data mart using Bill Inmon methodology.
• Worked with Master Data Management architects to develop data models.
• Worked on databases like oracle 11g, DB2 and Teradata and also interacted with the developers for optimizing the queries and accordingly change the models for faster retrieval of the data.
• Used BTEQ for SQL queries and TPump for loading data from source into Teradata tables.
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Performed source data quality assessments.
• Interacted with the teams involved in Data Transformation and data cleansing.
• Created Data Definitions, naming standards and help maintain Metadata repository.
• Created DDL scripts for static dimensions.
• Utilized ER/studio for reverse engineering the database from DDL scripts.
• Assisted the Data Acquisition Architect to ensure the Data Architecture is applied properly.
• Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Experience in using SSIS in solving complex business problems.
• Experience in using SSRS and Cognos in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.

Environment: CA Erwin 9.5, CA Erwin8.2.05, Tortoise SVN, Toad Data Analyst, Business Object XI Informatica 8.1, Oracle SQL developer, MS Visio, MS Excel.

Confidential, Summit, NJ

Data Modeler

Responsibilities:

• Involved in a team conducting data modeling joint application design (JAD) sessions and logical data analysis, communicated on data-related standards.
• Transformed project data requirements into project data models for OLAP and OLTP systems using Erwin.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Created entity relationship diagrams, functional and data flow diagrams. Developed the data mart for the proposed project.
• Conducted logical data model walkthroughs and validation.
• Facilitated transition of logical data models into the physical database design for data marts using Inmon methodology and recommended technical approaches for good data management practices.
• Worked with DBA group to create Physical Data Model from the Logical Data Model using Forward engineering in Erwin.
• Created documentation for Technical & Business User Requirements during requirements gathering sessions using Rational Requisite Pro.
• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Performed the activities necessary to support the standardization of facts and dimensions.
• Used Sybase power designer tool for relational database and dimensional data warehouse designs.
• Built Fast Load and Fast Export scripts to load data into Teradata and extract data from Teradata.
• Analyze the existing data model and document suspected design affecting the performance of the system.
• Reverse engineered the database structure from the existing application using Sybase power designer.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Documented data content, data relationships and structure, and processes the data
• Prepared prototype models to support the development efforts. Assisted the ETL team in mapping the data from source to target.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Tuned SQL queries to make use of database indexes, and analyzed the database objects.
• Crystal report was used for solving business problems and creating reports in organization.
• Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
• Worked on modeling for Business Objects reporting in Teradata, and also OLTP style in Oracle environment that is a source for Teradata for maintenance of dimension attributes.
• Expert in data cleansing for accurate reporting. Thoroughly analyze data and integrate different data sources to process matching functions

Environment: CA ERwin 8.2, Sql-server 2008,DB2, ER studio 8.2, Informatica V 8.6, Microsoft Access, DB2, Sybase 12, Business Objects, Microsoft Visio, SQL Server 2000,MS PowerPoint, MS Access, Lotus Notes, Microsoft Excel.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system
• Wrote Requirement and Design document for Master Data Entities. Used Corporate Modeler to design the Process
• Conducted controlled brain-storming sessions with project focus groups
• Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in Rational Rose.
• Conducted joint application design (JAD) sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications
• Participated in the to generate target database layout use for the data marts
• Generated data mapping documents to define mapping from source to target
• Reviewed the business requirements or use cases, and convert them to logical data models after analysis
• Participated in high-level and low-level design sessions including writing technical project documentation.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content
• Helped define the data definitions, naming standards and create the target tables in the database.
• Mapped the source and target databases by studying the specifications and analyzing the required transforms
• Worked on SQL queries by writing new and editing already existing codes using SQL Plus.
• Helped the team for data modeling support for numerous strategic application development projects.
• Documented the Purpose of mapping so as to facilitate the personnel to understand the process and incorporate the changes as and when necessary.

Environment: SQL Server 2000, UML, Business Objects 5, Teradata, Windows NT/2000, SSIS, SSRS, ER studio, Erwin, Informatica, Data Stage, Clear Case forms, Unix and Shell Scripting.

Confidential

Data Modeler

Responsibilities:

• Involved in the entire system study, analysis and design.
• Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system.
• Provide ER diagrams via Erwin.
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.
• Involved in writing the SQL codes and utilizing analytical, aggregate functions.
• Used different types of joins, helped build indexes, partitioning of the tables, etc.
• Performed user unit testing and interacted with the testing team and helped debug the code.
• Interaction with the developers and business teams for writing the technical specification document (TSD).
• Used SQL *Loader for data transfer to the oracle databases.
• Was involved in the query optimization.
• Involved in testing the database for queries that were generated and handled the performance issues efficiently.
• Involved in documenting the entire technical process.
• Supported technical teams involved with Oracle issues and operations.
• Involved in the maintenance of the database.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to incorporate the new calculations.
• Designed XML schemas using Unified Modeling Language (UML) - translating business concepts into XML vocabularies
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Experience in SSIS, SSRS in solving business problems and managing reports in organization.

Environment: SQL server 7.0, Erwin 2.5, Windows NT, Crystal Reports, XML, UML, C#.