SUMMARY

• 8+ years in Information Technology with expertise in Insurance, Financial Services, Software, Financial, Pharmaceutical, Banking.
• Expertise in the development of Data Warehouse/Data Mart for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) environments.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, production support and experienced in Project Management methodologies.
• Worked with Agile and Waterfall data modeling methodologies.
• Involved in various projects related to Data Modeling, System/Data Analysis, design and development for both OLTP and Data warehousing environments.
• Experienced in developing Conceptual, Logical and Physical Data Models using ERWIN, Sybase Power Designer and E - R Studio.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution usingAb Initio/Informatica Power center 6.2/6.1/5.1.
• Expertise in the development of Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/ Teradata.
• Proficient in Normalization (1NF/2NF/3NF)/De-normalization techniques in Relational/Dimensional database environments.
• Extensively worked on Forward Engineering and Reverse Engineering.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export with the use of ETL tools.
• Experience in Testing, Data Validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling a Data warehouse in Relational, Dimensional and Multidimensional modeling.
• Implemented Slowly Changing Dimensions - Type I, II, III & IV in Dimension tables as per the requirements.
• Experience working on creating models for Teradata MDM.
• Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
• Developed mapping documents for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Conducted GAP analysis and User Acceptance Testing (UAT). Facilitated and participated in Joint Application Development (JAD) sessions, Joint Requirement Planning (JRP), white board sessions to resolve the revolving issues and facilitated the coordination between the teams.
• Experience working on creating models for Teradata master data management.
• Extensive experience with Teradata SQL
• Expertise in working on TOAD for SQL developing queries for debugging the script for optimization
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.
• Exceptional communication and presentation skills and established track record of client interactions.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT/Vista/7, UNIX, MS DOS, UBUNTU, Sun Solaris.

Databases: Oracle11g/10g, SQL Server 2000/2005/2008 , Teradata,Sybase12.5/11MSAccess2003/2000,DB2

Modeling Tools: ERWIN r 9.1/ 8.2/7.3/7.0 , ER/Studio, MSVisio, Oracle Designer, Sybase Power Designer.

Reporting Tools: Crystal reports XI, Business Intelligence, SSRS, Business Objects 5.x / 6.x,Cognos7.0/6.0.

ETL Tools: Informatica Data Quality 9.6,Informatica Power Center 7.1/6.2, Data junction, Ab-Initio, Data Stage, SSIS.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Data Modeler/ Analyst

Responsibilities:

• Participated with in a team of data management subject matter experts to identify and evolve key data management strategies and initiatives within the organization.
• Refined and standardized data modeling practices to align with application paradigm (E.g. Business Intelligence, Transactional Processing, Big Data etc.)
• Partnered with subject matter experts, architects and developers to capture and analyze business needs to complete all data modeling related artifacts including Conceptual, Logical and Physical Data Models.
• Conducted extensive data analysis to evaluate data sources to determine the best source for business information.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Performed Data Profiling for multiple sources by using SQL and Informatica Data Quality and answered complex business questions by providing data to business users.
• Created mapping specs using Informatica Data Quality and validated them by performing QA.
• Implemented business models consistent within organizations Information Architecture strategy.
• Facilitated the interaction between the development teams and the DBA staff to design physical database structures that meet performance expectations and deliver business function.
• Adhered to approved architectural standards. Recommended architectural standard improvements.
• Defined, developed and delivered consistent information and data standards, methodologies, guidelines, best practice and approved modeling techniques around data quality, data governance and data security.
• 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.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Participated in design reviews and ensure that model solutions meet database standards.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose using Erwin 9.5 report designer.
• Maintained change log and issue log.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data Models to get clear understanding of requirements.
• Worked extensively with the Dev and QA teams to plan and execute the releases.
• Worked on Master data management (MDM) and data governance for improving data quality.
• Extensively worked with QA team to resolve the issues.
• Extensively worked with MDM team to resolve issues with the downstream apps.
• Mentored junior resources as designated by team leader.

Environment: Erwin r9.6, Informatica Data Quality 9.6,Oracle SQL Developer, Oracle Data Modeler, DB2, SSIS, Business Objects, Teradata 14.0, SQL Server 2008/2012, ER/Studio Windows XP, MS Excel.

Confidential, Boston, MA

Sr. Data Modeler

Responsibilities:

• Facilitated JAD sessions for project scoping, requirements gathering& identification of business subject areas.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype.
• Extensively worked with SCD Type-I, Type-II and Type-IIIdimensions and data warehousingChange Data Capture (CDC).
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation and maintaining change log.
• 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.
• Extensively worked with the Ab Initio Enterprise Meta Environment (EME) to obtain the initial setup variables and maintaining version control during the development effort.
• Installed & Implemented Ab inito latest products like BRE, Metadata Hub, and Console.
• Involved in non-transactional data entities of an organization of MDM that has the objective of providing processes for collecting, aggregating, matching, consolidating, quality-assurance, persistence and distribution.
• 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.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user’s understanding of the data warehouse objects.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• 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.
• Worked on slowly changing dimensions.
• Worked with ETL teams to create source and target definition.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Involved in updating meta data repository while detailing on use of applications and data transformation to facilitate impact analysis.
• Used Erwin’s reverse engineering to connect to existing database and ODS to graphically represent the Entity Relationships.
• Created and maintained Database Objects (Tables, Views, Indexes and Partitions).
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements and monitoring the server.
• Responsible for integrating the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Oracle 11g, SQL Server 2012, DB2, Microsoft Transaction Server, Erwin r9.5, Teradata 14, Crystal Reports, MS-SQL server manager, Microsoft Access.

Confidential, Oklahoma City, OK

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 and 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: Microsoft SQL Server 2008, MS Access, Teradata 14.0, Oracle 11g, DB2 10.5, Erwin 7.3, Windows XP, Excel, Toad for MySQL 6.3

Confidential, Des Moines, IA

Sr. Data Modeler

Responsibilities:

• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical Data Models.
• Created data models based on the information concept and subject models provided by the information architects.
• Designed an Enterprise standard Data Model for the HLI project, specific to the company with insurance, RIS and financial work stream.
• Identified and Defined entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• 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.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Closely worked with Business Architects and Solution Architects to created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad.
• Performed extensive data analysis and data validation on Teradata.
• Created standard report templates for the data definition specification document and mapping documents and implemented standard reporting techniques enterprise wide.
• Conducted design walk through sessions with Business Architects and solution architects’ team to ensure that reporting requirements are met for the business needs.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Maintained metadata, naming standards and warehouse standards.
• Conducted GAP analyses to derive requirements for existing systems enhancements to build the target state data models.
• Knowledge transfer & documentation, work breakdowns, contribution to project planning and status reporting.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.

Environment: Erwin 7.3.6, SQL Server 2008, Oracle 10g, Informatica 7.1, Crystal Reports, MS Office, MS Visio, Erwin Model Manager 7.3.

Confidential, Portland, Oregon

Data Modeler/ Analyst

Responsibilities:

• Conducting the meetings with business users to gather data warehouse requirements and Joint Application Design (JAD) session.
• Worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Developed a Conceptual model using ERwin based on requirements analysis.
• Developed Logical Model.
• Worked with the ETL developers and DBA's to come up with the best fit Physical model.
• Created a data model for the reporting system by identifying required dimensions and facts using ERwin 8.2.
• Used forward engineering to generate DDL.
• Involved in Data Mapping from source to target (ETL logical mapping).
• Review the Data Model with functional and technical team.
• Identified Facts and Dimensions based on reporting requirements and columns available in the source system.
• Snowflaked star schemas when and where required.
• Exhaustively collected business and technical Metadata.
• Loaded Erwin Models into Enterprise wide metadata repository.
• Developed and maintained Enterprise naming standards.
• Collected and documented data quality requirements from the business.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• 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.
• Involved in extensive Data Analysis on Oracle Systems querying and writing in SQL.
• Used complete compare function to keep Erwin models in sync with production environment.
• Participated in performance tuning to optimize data retrieval.
• Worked with design and implementation teams to ensure the transition phases between design and implementation.

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

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 in corporate the changes as and when necessary.

Environment: Oracle 9i, Toad 8.1, Erwin, Microsoft Windows, SQL Plus.

Confidential

Data Modeler/ Data Analyst

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 in corporate 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: Oracle 9i, SQL Server 2005, SQL *Loader, XML, Erwin, Windows 2000/NT, UNIX.