SUMMARY:

• Over 7 years of experience in data modeling, business and data analysis, production support, database management, strategic analysis, requirements gathering, application and decision support.
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
• Proficient in data martdesign and creation of cubes using dimensional data modeling - identifying Facts and Dimensions,Star Schemaand Snowflake Schema. Well versed inNormalization / De normalizationtechniques for optimum performance in relational and dimensional database environments.
• Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica.
• Extensive hands-on experience in ER modeling and OLTP/OLAP Systems Analysis
• Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and Microsoft SQL Server database management.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience working on creating models for Teradata master data management.
• Well versed in conducting Joint Application Design (JAD) and Joint Requirement Planning (JRP) sessions, User Acceptance Testing (UAT), Gap analysis, Cost benefit analysis and ROI analysis.
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Excellent Team player to work in conjunction with Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin r7.1/7.2, Erwin R8, ER Studio and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS and Informatica 7.1.3

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, VB.NET

Database Tools: Microsoft SQL Server 2000/2008, Teradata, SQL Assistant, Studio Express, Oracle 10g/9i, and MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Operating Systems: Microsoft Windows 9x / NT / 2000/ XP / Vista/7 and UNIX.

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester.

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Sr. Data Modeler

Responsibilities:

• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Designed an Industry standard data Model specific to the company with group insurance offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling
• Identified and compiled common business terms for the new policy generating system and also worked on contract Subject Area.
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio
• 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.
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business.
• Developed Data Mapping, Data Governance, Transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Generated ad-hoc reports using Crystal Reports 9.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• 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 R8.2.5, MS Visio, Oracle 11g, Toad, Oracle Designer, SQL Server 2008, Oracle SQL developer 2008, Crystal Reports 9.

Confidential, Portland, ME

Sr. Data Modeler

Responsibilities:

• Worked with a variety of levels of Information Services personnel to independently analyze complex data requirements, develop/manage/updated data models, and develop database designs.
• Interacted with the group of business analysts and architects and finalized the data requirements.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using ER Studio.
• Conducted logical data model walkthroughs and validation for EDW, EDW Staging and Data mart models.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Actively involved in Normalization & De-normalization of Database. Identified & tracked slowly changing dimensions and determined the hierarchies in dimensions. Conducted Design discussions and meetings to comeout with the appropriate Data Mart. Maintained warehouse metadata, naming standards, class words for column names and warehouse standards.
• Extensively used data mining for data analysis.
• Documented the source to target spread sheets which have all the information of source and target data types and allthe necessary transformation rules which are in turn used for their metadata updates.
• Assisted the application team in determination and clarification of business data requirements and also identified problems at the data modeling/design level and recommend solution to problems.
• Maintained and enforce data architecture/administration standards, as well as standardization of column name abbreviations, domains and attributes.
• Created tables, views, procedures and SQL scripts, mapping documents.
• Utilized organizational standards for data naming, structuring and documentation.
• Ensure the business metadata definitions of all data attributes and entities in a given data model are documented to meet standards.
• Integrated high - level business rules (constraints, triggers and indexes) with the code.
• Implemented the model and communicated it to end-users and stakeholders. Conducted Design walkthroughs which better helped the developers to understand the design. Generated the DDL and assisted in designing the overall ETL strategy. Maintained security and data integrity of the database.

Environment: Informatica Power Center, Teradata, SQL Server 2008, ER Studio, Windows 7, Oracle 10g, RDBMS, MS Access, ETL, DB2, Mainframes.

Confidential, Beaverton OR

Sr. Integration Data Modeler

Responsibilities:

• Gathering requirements from the SME’s and BSA’s and documenting the requirements in the data definition specification documents.
• Data profiling and analyzing the requirements and developing models using reverse engineering documents.
• Translate business requirements into conceptual, intermediate/logical/canonical data models and integration data models (incl. XML notations), Model databases for integration applications in a highly available and performance configuration.
• Contribute to the definition and design of data integration interfaces; work with database administrators to create physical database designs, as well as in production support escalation, as required.
• Facilitate requirements elicitation and modeling sessions including use of interviews, document analysis, workshops etc.
• Worked in close relationship with SOA and fusion developers in helping them understand mapping rules and Canonical Data Models.
• Collaborate with project teams on solution design; provide guidance and partner with project leadership, development, platform and QA teams by applying knowledge of database design.
• Responsible for modeling of solutions including operational reporting of integration metrics from databases, assist with the development and enforcement of data modeling standards, participate in data definition and data management reviews.
• Establish and maintain processes to support and grow data modeling practices, conceptual, intermediate logical/ canonical and physical data models per company direction, Solution designs, options and recommendations relating to data models and databases.
• Knowledge transfer & documentation, work breakdowns, contribution to project planning and status reporting.
• Maintaining requirements documents, creating reports and spread sheets readable by the users and developers.

Environment: SAP, Oracle 10g, PL SQL, SQL Server, ERWIN R7 and ERWIN R8, Windows NT, UNIX, ETL, Fusion, XML schemas, SCRUM/XP, JAVA.

Confidential

Sr. Data Modeler

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager, Production Support teams, subject matter experts, Database Administrators and Database developers.
• Conducted extensive requirement analysis using rational requisite pro.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Created a high-level generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Serve as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin 7.3.11
• Performed GAP analysis with Teradata MDM and Drive (SQL) data Models to get clear understanding of requirements.
• Created data design documents, logical and physical data models, maintained RTM, and requirements tracker documents.
• Documented the source to target spread sheets which have all the information of source and target data types and allthe necessary transformation rules which are in turn used for their metadata updates.
• Design documents included data flow model in VISIO, data mapping documents, design document which will assist the developer, transformations rule document which is mainly used to feed the project intothe EMR (Enterprise Metadata Repository). Uploaded design data to theEnterprise Metadata Repository.

Environment: SAP MDM, SAS, Teradata, SQL 2008, SQL Server 7.0, SQL Server7.0, ERWIN, Windows NT, Oracle8i, RDBMS, DB 2, Agile SCRUM, MS Access, ECC5 and ECC6, Legacy data bases.

Confidential, GA

Business Analyst / Data Modeler

Responsibilities:

• Conducted JAD sessions, wrote meeting minutes and also documented the requirements.
• Collected requirements from business users and analyzed based on the requirements.
• Designed and built Data marts by using Star Schema.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Serve as a member of a development team to provide business data requirements analysis services, producing logical and Physical data models using ERwin.
• Maintained current documentation for all primary and backup responsibilities.
• Worked as part of a team of Data Management professionals supporting a Portfolio of development projects both regional and global in scope.
• Applied organizational best practices to enable application project teams to produce data structures that fully meet application needs for accurate, timely, and consistent data that fully meets its intended purposes.
• Conducted peer reviews of completed data models and plans to ensure quality and integrity from data capture through usage and archiving.

Environment: ERwin 4.0, Power Designer, Sybase12, Windows NT, MS Excel, MS Visio, DB2, Oracle 10g/9i, XML files, Agile SCRUM, Embarcadero, SCRUM/XP, ER studio, Cognos Impromptu and Power Play, Business Objects.

Confidential

Data Modeler/ Data Analyst

Responsibilities:

• Identified goals and objectives of projects. Created project plan by gathering the requirements from the management.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs
• Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting.
• Identification of risks in schedule and marking them in the Use Cases.
• Worked on creating new tables and columns to Basel data mart.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERWin
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Creating Data Definitions and the Meta Data Repository
• Worked with third party data base to store the required data for the client (Remedy A R Systems)
• Explored data to identify its model role and measurement level. Verified data for missing values and incorrect data. And then cleaned and structured the data based on the format required.
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Implemented the model and communicated it to end-users and stakeholders.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Assisted reporting team (Cognos).
• Created integrity rules and defaults.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Used SQL to run ad-hoc queries and prepare reports to the management.

Environment: SQL Server 2000, Sybase12, Sybase Power Designer, UML, Business Objects 5, Teradata, Windows NT/2000, SSIS, SSRS, Embarcadero, ER studio, Erwin, DB2, Informatica, Query Management Facility (QMF), Data Stage, Clear Case forms, Unix and Shell Scripting.