SUMMARY

• 9+ years of professional experience in Data Modeling and Data Analysis as a Proficient in gathering business requirements and handling requirements management.
• Excellent ability to understand business needs and data to generate end to end business solutions.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin r7.3, Power Designer 12.0, Visio 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.
• Worked on several Ticket Management System tools.
• Having good experience with Normalization (1NF, 2NF and 3NF) and De - normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server and Teradata.
• Experience in Teradata Enterprise Data Warehouse (EDW) and Data Mart.
• Expert in user interface designing and creating screen-shots using wire frames and comps, and expert in using tools like MS Project and MS Visio.
• 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 analytical skills with exceptional ability to master new technologies efficiently.
• 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.

TECHNICAL SKILLS

Data Modeling Tools: Erwin, Visio, IBM InfoSphere, Data Architect, IBM Rational Rose, Power Designer and ER Studio

Database: Teradata, Oracle, MS SQL Server, MS Access, DB2

Business Applications: MS Word, MS Excel, MS PowerPoint, Visio

Operating Systems: Windows, Unix, Linux

Data Warehouse: OLTP Tools Microsoft Analysis Services, Business Objects, Crystal Reports, Informatica, SSIS

PROFESSIONAL EXPERIENCE

Confidential - Farmington, CT

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.
• Created OLTP, ODS and OLAP architectures
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Developed Conceptual, 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 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.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Involved in the critical design review of the finalized database model.
• 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, Informatica, Teradata, Oracle, SQL Server, MS Excel, MS Visio

Confidential, Sunnyvale, CA

Data Modeler/ Data Analyst

Responsibilities:

• Complete study of the in-house requirements for the data warehouse. 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.
• Prepared the questioners to users and created various templates for dimensions and facts.
• Conducting user interviews, gathering requirements, analyzing the requirements using Rational Rose, Requisite pro RUP
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio
• Created logical data model from the conceptual model and it's conversion into the physical database design using ERwin
• Created dimensional model based on star schemas and designed them using ERwin.
• Used ERwin for creating tables using Forward Engineering
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Responsible for identifying and documenting business rules and creating detailed Use Cases
• Defined the naming standards for data warehouse
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Maintained warehouse metadata, naming standards and warehouse standards.
• Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Collected the information about the existing ODS by reverse engineering the ODS.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Assisted in designing the overall ETL strategy
• Generated DDL statements for the creation of new Sybase objects like table, views, indexes, packages and stored procedures.
• Created DataStage Server jobs to load data from sequential files, flat files and MS Access
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements
• Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.

Environment: Erwin, Oracle, SQL server, MS Excel, MS Visio

Confidential

Data Modeler / Data Analyst

Responsibilities:

• Involved with the Business Analysts' team in requirements gathering and based on provided business requirements, defined detailed Technical specification documents.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data
• Management Architecture involving OLTP, ODS and OLAP.
• Created Logical and Physical Data Models by using Erwin r7.3 based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for banking applications.
• Analyzed the Business information requirements and examined the OLAP source systems to identify the measures, dimensions and facts required for the reports.
• Performed the data source mapping.
• Utilized Power Designer's forward/reverse engineering tools and target database schema conversion process.
• Documented logical, physical, relational and dimensional data models.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Review the data model with functional and technical team.
• Worked on the reporting requirements and involved in generating the reports for the Data Model.
• Assist developers, ETL, BI team and end users to understand the data model.

Environment: s: ERWIN, DB2, Teradata, Oracle, Microsoft Visio.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Expanded Physical Data Model (PDM) for the OLTP application using Power Designer.
• Transformed project data requirements into project data models.
• Responsible as a member of development team to provide business data requirements analysis services, producing Logical and Physical data models using Power Designer 12.0.
• Conducted data modeling JAD sessions and communicated data-related standards.
• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward Engineering.
• Involved in designing Data marts by using Star Schema and Snowflake schema.
• Closely worked with ETL process development team.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin, Teradata, Oracle, SSIS, Informatica Power Center

Confidential

Data Modeler / Data Analyst

Responsibilities:

• The Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the end-user reporting tools.
• Responsible for data modeling and building a star schema model in Erwin.
• Identified the fact tables, dimensions and the key measures.
• Installed and configured MS SQL Server
• Created and Scheduled jobs on MS SQL Server to transfer data.
• Used star schema methodology for the modeling of the data.
• Performed Data Profiling to identify data issues upfront, provided SQL prototypes to confirm the business logic provided prior to the development.
• In creation of the data mart new functionality had to be added like Trend data Inclusion, Product Profitability Calculation \ Reporting, Concept Reporting, Size Of Line Reporting, Global Brand Grouping \ Reporting etc.
• Assisted data warehouse project team in extracting business rules.
• Created an enterprise data dictionary and maintained standards documentation.
• Analysis of data requirements and translation of these into dimensional data models.
• Interacted with the end users and found out the performance of the database and also involved in developing test cases.

Environment: Erwin, Teradata, SQL Server

Confidential

Business Analyst / 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 and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.
• Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
• Used ERwin for creating tables using Forward Engineering
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Created and Scheduled jobs on MS SQL Server to transfer data.
• Used star schema methodology for the modeling of the data.
• Used SQL Loader to upload the information into the database and using UTL FILE packages write data to files.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Performed analysis and presented results using SQL, SSIS, Excel, and Visual Basic scripts.
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers.
• Designed and Populated specific tables, databases for collection, tracking and reporting of data.
• Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs.
• Documented and maintained database system specifications, diagrams, and connectivity charts.

Environment: Erwin, SQL Server, Microsoft Excel, Oracle, TOAD, Windows 7