SUMMARY

• Over 7 years of experience in IT industry in Data analysis, Data Modeling and Data Architecture.
• Expertise in creating conceptual, logical and physical data models in OLTP and dimensional models and star schema for data warehouse.
• Good Experience in Application Software Development and Design, Object Oriented Design and Analysis (OOAD), Technical Documentation, Software Testing and Debugging.
• Extensive use of Use Case Model, Use Case Diagrams, Class Diagrams, Package Diagrams and Sequence diagrams using Rational Rose.
• Having good knowledge of Oracle, MySQL and DB2 as Database. Good command in writing SQL queries, Stored Procedures and Triggers.
• Experience with data modeling tools like Power designer and Erwin.
• Experienced in working with industries including Telecom, Health Care and Software Development.
• Created Entity Relationship Diagrams to document and organize logical process and data models of the corporate OLTP system using MS Visio and Erwin.
• Involved in Testing by generating Test Plans, Test Scripts and Test Cases manually using Excel and Quality Center.
• Expertise in using Microsoft Visio to design process flow diagrams. Excellent analytical and problem solving skills.
• Hands on experience with Kimball’s and Inmon’s dimensional modeling methodology.
• Has a detailed knowledge of all the 3 techniques of Structured System Analysis (Logical Data Modeling, Data Flow Modeling and Entity Behavior Modeling/Event Modeling).

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.2/3.5/3.x, Power Designer, Rational Rose.

Databases: Oracle 10g/9i/8i, SQL, PL/SQL, MS SQL Server 2000/7.0/6.5 , MS Access7.0/2000

Programming: SQL, Transact SQL, PL/SQL, Unix Shell Scripting, C, VBScript, Visual Basic 6.0/5.0/4.0, HTML 4.0, DHTML.

Data Warehousing: Informatica PowerCenter 6.x/5.0/4.7.2, Informatica Power Mart 5.1.1/5.0/4.7.2 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations).

PROFESSIONAL EXPERIENCE

Business/ Data Analyst & Data Modeler

Confidential, Riverwood, IL

Responsibilities:

• Participate in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Create and review the conceptual model for the EDW (Enterprise Data Warehouse) with business users.
• Analyze the source system (North Star) to understand the source data and NS table structure along with deeper understanding of business rules and data integration checks.
• Identify various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Create the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ER Studio.
• Checked - in and checked-out model in the ER Studio
• Create multiple sub models which is helpful aid in the project which deals with large data models.
• Generate source code from database designs and construct graphical models from existing database or schema using forward and Reverse engineering process in ER Studio.
• Implement the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Implement the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Review the logical model with Business users, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Create the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from NS to the warehouse.
• Work with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Work on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Work on Mercury Quality Center to track the defect logged against the logical and physical model.
• Work as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Work with client and off shore team to make sure that the reports and dashboards are delivered on time.
• Participate in UAT sessions to educate the business users about the reports, dashboards and the BI System. Work with the test team to provide insights into the data scenarios and test cases.
• Work on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.

Environment: ER Studio 9.5, Microsoft SQL Server 2012, Mercury Quality Center 9, Ab initio, Teradata SQL Assistant, Oracle11g, DB2, Informix, MS Excel, Mainframes.

Data Modeler

Confidential, NY

Responsibilities:

• Completely studied the in-house requirements for the data model and data warehouse.
• Involved in identification of Facts, Measures and Dimensions.
• Created conceptual and logical (using IE methodology) data models using ERwin.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERWin.
• Created dimensional data model based on star schema using Kimball’s methodology.
• Supported in building and maintaining Data marts, Fact Tables, Dimension tables.
• Worked on relational data modeling and OLTP application using Erwin Data Modeler.
• Generated Surrogate IDs for the dimensions in the fact table for faster access of data.
• Created database tables using data definition language scripts.
• Involved in analysis, design and development and testing phases of the application development using Scrum Agile methodology.
• Involved in creating, modifying and updating database tables in Oracle Server.
• Participated in daily scrum meetings to discuss about the work done the before day, current days work and to let the team mates know if there are any road blocks.

Environment: SQL Server 2008, All Fusion Erwin 7, Visual Studio 2008, PL/SQL, .csv Files, MS Query.

Data Modeler

Confidential, San Jose CA

Responsibilities:

• Managed a development Team and involved in the implementation of the Contract Management System for the web hosting services
• Facilitated and coordinated the requirements gathering sessions with the Business users.
• Worked with the Vendors for the implementation and customization of the vendor packages.
• Maintain responsibility to ensure that system builders confirm to the information requirement gathering and technical walk-thru sessions of application specific data models.
• Help lead the efforts to coordinate development projects pertaining to data analysis, design and implementation
• Implemented the system and imparted user training
• Involved in Data Analysis, Gap Analysis, Data mapping and Data conversion.
• Development of the customer trouble ticket management to the web hosting environment using Clarify and Siebel.
• Customization of the Clarify application software to suite the as per the business needs of the Digex web hosting using Clarify e front office suite
• Worked extensively on form customization, which included adding of new text fields, buttons, drop down list boxes and tabs
• Customized the clarify GUI in Clear Support, Clear Sales, Clear Logistics and Clear Call Center, Clear Contracts, Clear Quality to fulfill the customer business requirements
• Resolving defects, based on the severity of the issues in the system.
• Doing scope change activities through client interaction.

Environment: Power Designer Data Modeler, Windows NT 4.0, UNIX Scripting, MS SQL server, PL/SQL, Sybase, MS Access, .csv Files, Informatica Powercenter 6.2, Main Frames, Rational Rose.

Data Modeler

Confidential, Overland Park, KS

Responsibilities:

• Creating & delivering data structures via logical & physical designs for IT Project teams based on a through understanding of application requirements, business requirements and database constraints.
• Creation of the logical & physical database design for small & complex application across multiple projects and applications.
• Worked on the Consolidation data of the Call center specific for all the call center applications
• Developed the Customer Global data stores to share among the different applications across the company which focus on the customer specific data.
• Used Power Designer 9.5 and Erwin 4.1 to create these models.
• Involved in the creation of the Crud matrix.
• Working directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Capture and document detailed data requirements for the strategic Initiatives and Projects.
• Facilitating the model walk thru sessions for the business and application users.
• Involved in Studying the User requirement. Involved in Installation and configuration of Web Sphere Application Server.
• Used Confidential Rational Application Developer developing GUI and deploying it on the server.

Environment: Oracle 9i, Erwin 4.1 and Power Designer 12.1, DB2, CGI AMS EO, WEB METHODS

Data Modeler/ ETL Developer

Confidential

Responsibilities:

• Conducted meetings with DBAs for preparing the database table layouts.
• Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Implemented the concept of super type/subtype using Power Designer Data Modeler.
• Defined the relationships and cardinalities among different entities.
• Created the physical data models and surrogate key tables to map the required dimensions.
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Developed various PL/SQL stored procedures, views, functions and packages.
• Wrote SQL queries using joins, sub queries and correlated sub queries.
• Involved in Object Modeling in UML Using Rational Rose 2000.
• Consulted with Subject Matter Experts and core team on new data definitions and other extensions to the existing strategies.
• Used Informatica Power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Loading the Data from Flat Files and COBOL Copybooks into the Staging area using Informatica Power Center 6.2.
• Worked on Informatica Power Center 7.1.3 tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Update, Aggregator) in a mapplet and created new mappings using Designer module of Informatica
• Extensively used incremental aggregation for CDC (Changed Data Capture).
• Performed exhaustive testing of several financial security applications.

Environment: Power Designer Data Modeler, Windows NT 4.0, UNIX Scripting, MS SQL server, PL/SQL, Sybase, MS Access, .csv Files, Informatica Powercenter 6.2, Main Frames, Rational Rose.

Data Modeler/ ETLDeveloper

Confidential

Responsibilities:

• Presented data warehouse solution architecture to the project steering committee as well as user community.
• Analyzed the project database requirements from the user. Arrived at the querying criteria and usage of the queries with respect to the aggregations.
• Defined aggregations required and granularity available and required in DW.
• Defined the partitioning of the data.
• Collected the information about different Entities and attributes. Studied the existing ODS by reverse engineering in to ERWin. Normalized the entities and demoralized for DW purposes.
• Defined the Query Views, index options, relationships and cardinalities between different entities.
• Created super type and sub type entities and Category entities. Defined the domains for the attributes and Validation rules.
• Created logical schema using ERWIN 3.x and also created the Dimension Modeling for building the Cubes. Involved in creating the physical databases. Wrote stored procedures to automate the process involved.
• Identified data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Created Use case diagrams, Class diagrams, Interaction diagrams etc. using Microsoft Visio.

Environment: Informatica Powercenter 6.2, ERWin 3.x, SQL Server, Oracle8i, Microsoft Visio, Windows NT 4.0, PL/SQL, Sybase.