SUMMARY:

• 7+ years of professional experience in data modeling and data analysis as a Proficient in gathering business requirements and handling requirements management.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio Data modeling tools.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• Good in Normalization / Demoralization techniques for effective and optimum performance in OLTP and OLAP environments.
• Having good experience with Normalization (1NF, 2NF and 3NF) and Denormalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Well - versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling.
• Experienced in designing the data mart and creation of cubes.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica
• Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Efficient in analyzing and documenting business and functional requirements along with Use Case Modeling and UML.
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Well versed in conducting Gap analysis, Joint Application Design (JAD) session, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
• An excellent experience in generating ad-hoc repots using Crystal Reports 9 and T-SQL.
• A good familiarity and experience in the work environment consisting of Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently

TECHNICAL SKILLS:

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

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9

ETL Tools: Microsoft DTS/SSIS, Data Stage 7.5, Ab Initio and Informatica 7.1.3

Programming Languages: SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting

Database Tools: Microsoft SQL Server 2000/2005, MySQL, Oracle 10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1

Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio

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

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service.

PROFESSIONAL EXPERIENCE:

Confidential, Smith Field, RI

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
• 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.
• Involved in Data Mapping.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• 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)
• Worked with ad-hoc reporting using Crystal Reports 9 and T-SQL.
• Responsible in integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin r8.0, SQL, SQL Server 2000/2005, Windows XP, Oracle 8i, Windows XP/NT/2000

Confidential, Jacksonville, FL

Sr. Data Modeler

Responsibilities:

• As a Data Modeler, I'm responsible for creating database designs which will store the data for various business processes in OLTP (Transactional Systems) and Data Warehouses (Analytical Systems).
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin and ER Studio and other Data Modeling tools.
• As part of creating database designs, I follow a particular process where I first create the conceptual data model, logical data model and then finally end with a physical data model. Each type of model is used for a particular purpose, where a conceptual model will be used to capture the true business relationships of the entities of enterprise and used to converse with business
• 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 data model which will be used to resolve and normalize the data base design from conceptual model and fully attribute the conceptual model and provide a proper name/definition to the attributes. This is used to converse with the development teams to map the requirements with the data model.
• Created physical data model which will be used to generate the Data Definition Language of the model and create the structures on a database. Implemented Referential Integrity using primary key and foreign key relationships on data Model.
• Create a database design which reflects the best way of storing data on a database for optimized storage and retrieval for OLTP and Reporting systems
• Create the technical design which incorporates the best possible method of solution for a problem identified in functional requirements document.
• Using ER STUDIO 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.
• Worked with ad-hoc reporting using Crystal Reports 9 and T-SQL.
• Responsible in integrated the work tasks with relevant teams for smooth transition from testing to implementation phase.
• Implement slow changing dimension on star schema while using star schemas are much easier to use and (more importantly) make perform well with ad-hoc query tools such as Business Objects or Report Builder.
• Use star schema design to normalize the structure.
• Worked on Moving the loan data from database to downstream systems which is used to process data for Secondary Markets use it for Bank Project.

Confidential, Richfield, MN

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.
• Generating ad-hoc repots using Crystal Reports 9.
• 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.

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, Wilson NC

Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering along with the business analysts’ group.
• Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
• Gathered various requirement matrices from the business analysts.
• Participated in Joint Application Development (JAD) sessions
• Conducted Design discussions and meetings to come out with the appropriate Data Model
• Designed for the various reporting requirements
• Designed a logical data model using database tool Erwin r7.0
• Used ER Studio to create logical and physical data models for enterprise wide OLAP system.
• Developed monthly summary and downstream data marts from enterprise wide databases in accordance with reporting requirements with dimensions like time, customers, services and accounts.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse
• Modeled the dimensions and facts using Erwin for centralized data warehouse
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions
• Actively participated in data mapping activities for the data warehouse.
• Created summary tables using de-normalization technique to improve complex Join operations
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis pertaining to Loan products
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Designed and implemented a physical data model to handle marketing strategies and to satisfy reporting needs dynamically.
• Organized User Acceptance Testing (UAT), conducted presentations and provided support for Business users to get familiarized with Loan products application.
• Handled performance requirements for databases in OLTP and OLAP models.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Perform Data Loading and Transformation using Data Junction 6.0

Environment: Erwin r7.0, ER Studio, SQL Server 2000/2005, Windows XP/NT/2000, Oracle 8i, MS-DTS, UML, SQL Loader, Data Junction, Rational Rose 2000

Confidential, Kansas City, MO

Data Modeler /SQL Developer

Responsibilities:

• Interacted with users and business analysts to gather requirements.
• Understood existing data model and documented suspected design affecting performance of the system
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Developed Logical and Physical Data models by using Erwin r7.0
• Created logical data model from the conceptual model and its conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Applied second and third NFR to normalize existing ER data model of OLTP system.
• Used Denormalization technique in DSS to create summary tables and improved complex Join operation.
• Gathered statistics on large tables and redesigned Indexes.
• Installed and configured SQL Server.
• Designed and developed the databases
• Written Stored Procedures and Triggers extensively and working very closely with developers, business analyst and end users to generate various audit reports and troubleshoot their query problems and connectivity problems.
• Created integrity rules and defaults.
• Done analysis of resource intensive query and applied changes in existing back-end code (stored procedures, triggers) to speed up report execution
• Created ftp connections, database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Developed several forms & reports using Crystal Reports.
• Provided maintenance support to customized reports developed in Crystal Reports/ASP.
• Done analysis of live site issues related to database and resolved the same.

Environment: Erwin r7.0, Oracle 8i, SQL Navigator, PLSQL, Pro DB2, SQL server 7.0, MS-SQL server Analysis Manager, Sybase, Rational Requisite, Windows NT, Crystal Reports.

Confidential, Hartford, CT

Data Modeler

Responsibilities:

• Gathered and transferred business and functional requirements for enhancements in Pricing and Costing systems with documentation.
• Interacted with business users and studied available documents/application to understand the requirements.
• Worked with large sets of data to find rate flow trends and patterns, identify and fix data anomalies
• Used Erwin r7.0 for creating tables using Forward Engineering
• Designed the prototype of the Data mart and documented possible outcome from it for end-user.
• Involved in business process modeling using UML
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Identified facts and dimensions and designed the Star Schema.
• Designed logical database design and converted logical model into physical model on SQL Server.
• Cleansed, extracted and analyzed business data on daily basis and prepared ad-hoc analytical reports using Excel and T-SQL
• Done SQL Server configuration database size estimation, database creation logins & user’s creation, granting object level permission, estimation of indexes on tables.
• Wrote Stored Procedures and Triggers.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master
• Data Management Architecture involving OLTP, ODS and OLAP
• Created scheduled jobs on SQL Server to transfer data from Ingres database to SQL database through linked server.
• Generated ad-hoc reports using Crystal Reports 9
• Developed database backup & restore policy.

Environment: Erwin r7.0, SQL/MS SQL Server, MS OLAP Manager,, MS Analysis Services, Windows NT, MS Visio, XML, Informatica, Crystal Reports 9.