SUMMARY

• 7+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management, OBIEE.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, datatypes, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions

TECHNICAL SKILLS:

• Erwin r7.1/7.2
• ER Studio V8.0.1 and Oracle Designer
• Microsoft Analysis Services
• Business Objects
• SSIS and Informatica 7.1.3
• SQL
• T-SQL
• Base SAS and SAS/SQL
• HTML
• Microsoft SQL Server 2000/2005/2008
• DB2
• Oracle 10g/9i
• MS Access
• Teradata
• Microsoft Office Suite
• Microsoft Project 2010
• SAP Business Objects
• Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Data Modeler/Analyst

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Developed a Conceptual model using Erwin based on requirements analysis
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation
• Responsible for defining the naming standards for data warehouse
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems
• 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
• 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.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation

Environment: Erwin r7.1, Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro

Confidential, Atlanta, GA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with the Business Analyst.
• Participated in creating the logical model of an online processing system for a large financial institution using Erwin.
• Worked with DBAs to generate physical model.
• Worked on Bill inmon methodologies for modeling.
• Created tables, views, procedures and SQL scripts and mapping documents.
• Worked on slowly changing dimensions (SCD) and hierarchical dimensions
• Worked on conversion process of data, which is stored in flat files into oracle tables.
• Designed and developed SQL procedures, functions and packages to create summary tables.
• Generating ad-hoc reports using crystal reports 9.
• Developed database backup and restore policy.
• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services (SSIS).
• Good Understanding in Database and Data Warehousing Concepts.

Environment: CA ERWIN r7, Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, Toad, Informatica, Power Centre 6.0, Case Management System, Business Objects

Confidential, Boston MA

Data Modeler

Responsibilities:

• Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Identified and compiled common business terms for the new health care system that become central part of communication among project stakeholders to avoid ambiguity
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Involved in exhaustive documentation for technical phase of the project and materials for all data management functions
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design
• Developed the required data warehouse model using Star schema for the generalized model
• Used forward engineering approach for designing and creating databases for OLAP model
• 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 and OLAP
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• 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: CA Erwin, MS Visio, Oracle 9i, Oracle Designer, SQL Server2000/ 2005,Informatica, Crystal Reports 9, XML, Rational Rose and SQL Server Reporting Services

Confidential

Data Analyst/Modeler

Responsibilities:

• Worked in close association with the Business Analysts and DBAs for gathering requirements, business analysis, and testing and project coordination and participated in data modeling JAD sessions.
• Interacted with end users and acquired the reporting needs.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Created logical, physical and dimension models.
• Created entity diagrams and relationship diagrams and modeled cascade to maintain referential integrity.
• Used Erwin to create tables using forward engineering.
• Generated Reports from data models.
• Reviewed the data model with the functional and technical team.
• Assisted the ETL staff, developers and end users to understand the data model.
• Maintained a change log for each of the data models created.
• Created SQL codes from data models and interacted with DBA’s to create development, testing and production database.
• Wrote store procedures and triggers.
• Added database objects (like indexes, partitions in oracle database) for performance.
• Checked to see if the data models and the databases are in sync.

Environment: C++, VC++, MFC, Java, SQL, PLSQL, Microsoft ASP.NET, SOAP, Oracle, Windows XP

Confidential

MS SQL Server Developer

Responsibilities:

• Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Organized sessions with architects, business and development teams to understand the Change Requests (CR’s).
• Involved in the generation of DDL and DML scripts.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.
• CreatedEntity Relationships diagrams, data flowdiagrams and implemented referential integrity using ERWIN.
• Star schema was developed for proposed central model and normalizedstar schema to snow flake schema.
• Worked in data mapping, enabling the extract, transform and loading of the data into target tables.
• Data mapping documents between Legacy, Production, and User Interface Systems were developed.
• Data sourcing and data staging are performed.
• Worked along with ETL team for documentation of transformation rules for data migration from OLTP to warehouse for purpose of reporting.
• Metadata repository was maintained and updated based on change requests.
• Developed operational data store to design data marts and enterprise data warehouses.
• Walkthroughs with DBA were conducted to update the changes made to the data model.
• Conducted meetings with business and development teams for data validation and end-to-end data mapping.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use.

Environment: Erwin r7.2, SQL Server 2008, Crystal reports, PL/SQL, MS Excel, Word and Access, Windows, Informatica, SSRS, Power designer.