SUMMARY:

• Over 7 plus years of professional experience in data modeling, designing, and data analysis with Conceptual, Logical and PhysicalModeling for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Worked in many Software Development Life Cycle (SDLC) implementations, performing process - planning, documentation, functional and system design, implementation, unit, integration, regression testing, and system maintenance.
• Experience working with Agile data modeling methodologies.
• Strong Database experience using Oracle 10g/11g, XML, DB2, SQLserver.
• Strong hands-on experience in Data Modeling tools like Erwin, ER Studio and Power Designer for developing Entity-Relationship diagrams.
• Used SQL Server Integrations Services (SSIS) for extraction, transformation, and loading data into target system from multiple sources.
• Designed of the Conceptual, Logical and Physical data models to meet the business requirements and reporting requirements using Erwin.
• DevelopedData Mapping, Data profiling, Transformation and Cleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Well versed in Normalization to 3NF/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in identifying the Facts and Dimensions from the Enterprise Architecture for designing the Star and Snowflake Schema.
• Identified Slowly Changing Dimensions, Role Playing Dimensions and Hierarchies in dimensions.
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in dealing with different data sources ranging from flat files, Excel, Oracle, Sybase, and SQL Server.
• Experience in design reviewing and validation of final data models.
• Hands on experience with modeling using Erwin in both forward and reverse engineering cases
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently.

TECHNICAL SKILLS:

Modeling Tools: ERStudio, Erwin 9.5, and MS Visio 2007/2010.

Reporting Tools: Oracle Reports, Business Objects, Crystal Reports, SSIS, SSRS, Cognos 8

Operating Systems/Platforms: XP/Vista/Win7, UNIX,Linux

Databases: Oracle 9i/10g/11g, MS SQL Server 2005/2008, DB2, MS Access, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Islandia,NY

Role: Sr.Data Modeler/Data Analyst

Responsibilities:

• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements.
• Worked closely with ETL team in loading and mapping the data.
• Worked with DBA to create the physical model and database objects.
• Experience on working with Agile Methodology and involved in Sprint 1, 2, 3 & 4.
• Developed conceptual model using ERWIN.
• Worked on logical and physical model using ERWIN based on requirements.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Good working knowledge in normalizing the tables up to 1NF, 2NF & 3NF and maintain referential integrity by using triggers and primary keys and foreign keys.
• Created dimensional tables using Denormalization techniques.
• Worked on Type 1, 2 & Type 3 slow changing dimensions.
• Worked on creating dimensional tables and fact table with star schema methodology
• Implemented forward engineering and reverse engineering techniques
• Worked on developing Enterprise data warehouse.
• Worked with Business warehouses like SAP and TOPS.
• Designed tables for staging and integration layers.
• Worked on profiling source data to determine the key consistency, data type, size, etc.
• Implemented the standard naming conventions and created domains in the data model.
• Demonstrated that tables are appropriately modified.
• Updated EIW database objects like tables and views.
• Created data mart to receive project details that will be provided by SAP-BW and processed by ETL.
• Created and maintained Database Objects (Tables, Views, Indexes, Partitions, Database triggers etc).
• Implemented performance query tuning.
• Worked Extensively on ETL process using SSIS packages.
• Good Knowledge of integration services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Good communication with the project team throughout all stages of design, managing time effectively, and work on project timelines simultaneously in demanding deadline driven environment.

Environment: SQL Server Database (2008), Windows 7, ERWIN 9.0,MS Office, SSIS,SSRS

Confidential, Hoboken, NJ

Role: Sr. Data Modeler / Data Analyst

Responsibilities:

• Interacted with Business Analysts to gather the user requirements and participated in data modeling JAD sessions.
• Contributed in the database section of the technical design document.
• Worked with Health care insurance Data model.
• Developed aConceptual modelusing Erwin based on requirements analysis.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.
• Worked on data mapping process from source system to target system.
• Created E/R Diagrams, Data Flow Diagrams, grouped and created the tables, validated the data, identified PK/ FK for lookup tables.
• Normalized the data up to 3rd Normal form.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Implemented Star Schema and Snowflake Schema methodologies in modeling and designing the logical data model into Dimensional Models.
• Worked on slowly changing dimension tables and hierarchies in dimensions.
• Involved in designing fact, dimension and aggregate tables for Data warehouse.
• Involved in updating metadata repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Worked with business analyst in generating weekly reports using Cognos.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Created ODS and DataMart models.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• CreatedSSISpackages to clean and load data to data warehouse.
• Did Performance Tuning of the database which included creating indexes, optimizing SQL Statements & monitoring the server.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Proficient with design tools for XML-based vocabulary technologies.
• 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.

Environment: Oracle Database 11g, SYBASE, Linux, Windows 7, Erwin 7.3, TOAD, MS Office, SSIS, SSRS.

Confidential, Roschelle Park, NJ

Role: Sr. Data Modeler / Data Analyst

Responsibilities:

• Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements.
• Designed of the Conceptual, Logical and Physical data models to meet the business requirements and reporting requirements using Erwin 7.0.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity.
• Good understanding ofviews, Synonyms, Indexes, Joins and Partitioning.
• Enforced mandatory capture metadata during the logical phase design.
• Forward Engineering the Physical Model to generate the DDL scripts to implement on Oracle 11g database.
• Reverse engineering of the existing reports to identify the key data elements and data entities required to design the data warehouse.
• Generated ready to implement DDL for oracle DBMS implementation by the DBA group.
• Identified the data requirements, source and target databases. Created the mapping data from source to target databases.
• Involved in mapping data elements from User Interface to the Database and help identify gaps.
• Created and maintained the Data Model repository as per company standards.
• Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• CreatedSSISpackages to clean and load data to data warehouse.
• Extensively worked with DTS for Data Migration from source systems
• Developed the UML class diagrams for the proposed system using ER/Studio Software Architect ETL mapping document by.
• Involved in different team review meetings.

Environment: Oracle 11g,Teradata, SQL server 2012, Linux, Windows 7, Erwin, MS Visio, TOAD.

Confidential, New York, NY

Role: Sr. Data Modeler / Data Analyst

Responsibilities:

• Gathered and translated business requirements, worked with the Business Analyst and DBA for requirements gathering, business analysis, and testing and project coordination.
• Worked with DBAs to create a best fit Physical Data Model from the Logical Data Model using Erwin.
• In order of better understanding the requirement documents, carried out couple of JAD sessions with Management, SME (Subject Matter Expertise), vendors, users and other stakeholders.
• Worked on the conversion process of data which is stored in flat files into Oracle tables.
• Conducted team meetings and JAD sessions.
• Implemented naming standards, and warehouse metadata for fact and dimension of Logical and Physical Data Model.
• Worked on data mapping process from source system to target system.
• Identified the measures and dimensions and organizing these into facts in creating the Dimensional Model within the business requirements.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Conducted logical data model walkthroughs and validation.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse.
• Developed and maintained the central repository, populated it with the metadata.
• Developed the data warehouse model (star schema) for the proposed central model for the Project
• Design, develop and implement test plan to test the data migration process.
• Worked with business analyst in generating weekly reports.

Environment: DB2, SQL Server 2008, Windows, MS OLAP, SQL Loader, SQL Server 2008 Reporting Services (SSRS), Crystal Enterprise 10, ERWIN 7.0.

Confidential, San Diego, CA

Role: Sr. Data Modeler / Data Analyst

Responsibilities:

• Thorough understanding and hands on experience of software development life cycle from Ideation to Implementation.
• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Performed in team responsible for the analysis of business requirements and design implementation of the business solution.
• Identified and compiled common business terms for the new policy generating system and also worked on contact 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.
• Developed logical and physical data models for central model consolidation.
• 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.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• 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
• Created summary tables using de-normalization technique to improve complex Join operations
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Involved in mapping the load data to the target based on primary and foreign key relationship considering the constrained based load order.
• Used Erwin for creating tables using Forward Engineering.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Generating reports from the data models.

Environment: Teradata V2R5, DB2 UDB, SQL Server, Sybase, Windows NT, Rational Requisite Pro, ERWIN, Data Stage, MS Visio, Linux, Sun Solaris, T-SQL.

Confidential

Role: Data Modeler

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Created Entity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Developed the logical and physical data model for the proposed solution.
• Worked with DBA’s to create a best fit physical data model from the logical data model.
• Created 3NF business area data modeling with de-normalized physical implementation data and information requirements analysis using Erwin tool.
• Extensively used star schema methodologies in building and designing the logicaldatamodels into dimensional model.
• Used ERWIN’s Database Generation for generating DDL, stored procedure and trigger code for your target database
• Defined best practices for project support and detailed documentation
• Ensured delivery of results as per pre-defined quality parameters and customer satisfaction metrics. This involved the right kind of data analysis that in turn leads to close ended action plans.

Environment: SQL Server 2005, Teradata, Oracle, Erwin 8, SQL, Mercury Quality Center 9, Toad, SSRS, MS Excel.

Confidential

Role: Business/Data Analyst

Responsibilities:

• Requirements management and analysis through regular meeting and sessions with Stakeholders.
• Conducted JAD sessions with stakeholders in coming up with user requirements.
• Acquired user requirements and utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures for Banking Applications.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Conducted Functional Requirement Specification and User Requirement Specification Analysis/reviews and walkthroughs with the designers, developers and stakeholders.
• Documented Business requirements and processes, and came up with process redesign.
• Used and created Customized Templates in coming with SRS and Functional Requirements Documents.
• Data analysis and reporting using SQL.
• Induced traceability views to maintain the traceability of the requirements.
• Created Testing Artifacts, Test Strategy and Traceability Matrix.
• Ensured Quality Assurance through test phase entry and exit quality criteria, standard test Planning and execution, Performed User Acceptance Testing.

Environment: MS Project, Rational Rose, MS Office, Rational Clear Case, Java, SQL, UML.