SUMMARY

• Eight years of professional experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Implementation and Support of various Business Intelligence (BI) applications / OLTP, Data Warehousing (OLAP) applications. Well versed with Banking, Insurance, and Healthcare Domains.
• 8+ years of professional experience in Data Modeling, Data Analysis and design of OLTP and OLAP systems.
• Experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using ERwin and Power Designer.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering ERWIN diagrams, analyzing data sources and creating interface documents.
• Developed Data dictionary and maintained Metadata for each model.
• Proficient in data mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• Well versed in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
• Experience working with Agile and Waterfall data modeling methodologies, Ralph Kimball and Bill Inmon approaches.
• Proficient in data stage IBM info sphere and having experience in creation of data stage jobs and executing them.
• Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
• Experience in SQL and good knowledge in SQL programming and developed Stored Procedures and Triggers.
• Experience in Data loading using SQL Scripts and SQL Server Integration Services packages (SSIS 2005/2008).
• Experience with DBA tasks involving database creation, performance tuning, and creation of indexes, creating and modifying table spaces for optimization purposes.
• Experience in using Database Tools TOAD for Data Analyst, SQL Server Management Studio.
• Experience in Data profiling between various OLTP systems & Canonical models.
• Efficient in analyzing and documenting Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) along with Use Case Modeling and UML.
• Facilitated and participated in Joint Application Development (JAD) sessions for requirements gathering and analysis.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Hands On experience in reporting tools like Crystal Reports and SAP Business Objects Universe.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow
• Effective team worker and can carry out individual tasks to meet the deadlines effectively.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 9.x/8.x, ER Studio 7.1.1/7.5, Power Designer 12.x, 15.x, 16.x

Databases: Oracle 11g/10g, IBM DB2 UDB 8.0/7.0, MS SQL Server 2012/2008/2005, Teradata 13/14

ETL Tools: IBM Data stage info sphere, Power Designer

Reporting Tools: Cognos 8, Crystal Reports XI, Business Objects XI

Operating Systems: Microsoft Windows Vista/XP/2000/NT, Sun Solaris, Unix, Linux, AIX, MSDOS.

Programming Languages: COBOL,SQL,SAS

Defect Tracking Tools: HP ALM

PROFESSIONAL EXPERIENCE:

Confidential, Mt Laurel- NJ

Data Modeler

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
• Requirements gathering by conducting meetings and brainstorming sessions with SMEs and senior management.
• 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
• 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
• 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.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase

Environment: Erwin 9.x/8.x, Teradata SQL Assistant, SQL Server 2012

Confidential, MN

Data Analyst/Data Modeler

Responsibilities:

• Transformed project data requirements into project data models, conducted logical data analysis and data modeling facilitated JAD sessions, communicated data-related standards
• Documented data content (entities, attributes), data relationships and structure, and processes that managed or transformed data, and business rules that govern the data.
• Assisted Business owners with defining business requirements and performing use case analysis
• Prepared Use cases and identified important alternative and exceptional flows which are more prone to be missed by developers and requirements gathering. Particular emphasis was made on clearly obtaining requirements which might make an impact on the data model.
• Reverse engineered OLTP database to obtain source table diagrams.
• Reverse engineered reports and created logical dimensional data models and snow-flaked physical data models for analysis of telephone usage and billing.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model
• Developed source to transformation mapping documents.
• Created Meta Data Repository and was also responsible for defining the Data.
• Created capacity planning documents for estimating memory requirements.
• Responsible for performing in-depth quantitative data analysis. Was involved in generating Ad-Hoc queries as per the client’s requirements.
• Assisted the DBA in creating tables, indexes, views, snap shots, maintaining security of the database.
• Prepared Gantt Charts and Network Diagrams for the Analysis of data.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Defined integrity rules and defaults. Involved in data profiling.
• Helped testing teams with development of test cases in User Acceptance Testing, Production testing and also independently performed exploratory testing.
• Wrote scripts in SQL for inserting dummy data in source tables and for checking flow of data after various stages of processing in target databases.
• Contributed to impact analysis documents for bug fixes and GAP analysis for change requests.

Environment: Erwin 8.x, /SQL, Teradata SQL Assistant 6.1, SAS, Business Objects, Crystal Reports 10/11.

Confidential - Atlanta, GA

Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering meetings, brainstorming sessions and detailed design meets.
• Involved in requirement analysis and understanding of business analysis and creating a design workflow. Designed ER diagrams.
• Responsible for understanding the existing model and documenting the suspected design which is affecting the performance.
• Identified the grain, key dimensions, facts and designed star and snowflake schema.
• Analyzed the data, which is using the maximum number of resources and made changes in the back-end code using SQL stored procedures and triggers.
• Tuned SQL queries and indexed database tables wherever necessary and also partitioned databases.
• Involved in developing the business naming standards, consistent data definitions, data aliases and documenting the business rules of the enterprise
• Involved in System Integration Testing and User Acceptance Testing.
• Provide expertise and recommendations for physical database design, architecture, testing, performance tuning and implementation.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.

Environment: Erwin 8.x, SQL, XML, SQL Server 2008 IBM DB2 Mainframe

Confidential, Morrisville-NC

Data Analyst

Responsibilities:

• Gathered business requirements; interacted with DSO and business analysts to finalize requirements.
• Translated existing data bases into models to understand objects and relations using reverse engineering function using Erwin.
• Performed walkthroughs for Conceptual Data Model, Logical Data Model and Physical Data Model for validating designs for the enterprise data warehouse.
• Involved with implementing Kimball methodology to design data marts.
• Implemented primary key foreign key constraints using RI (Referential Integrity).
• Used normalization/de-normalization techniques to achieve optimum performance of the database.
• Identified SCD and categorized them under Type1, Type-2 and Type-3.
• Involved with data analysis using Teradata SQL Assist from data source.
• Design the documents which included data flow model in VISIO, data mapping documents, design document which will assist the developer, transformations rule document which is mainly used to feed the project intothe EMR (Enterprise Metadata Repository). Uploaded design data to theEnterprise Metadata Repository.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects. Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Environment: Erwin r7.x, SQL Server 2005/2008, Teradata 12, Mainframes, UML, SQL Loader.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Worked directly with users to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• 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 ERwin r7.0 and Power Designer.
• 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.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Involved in designing built Data marts by using Star Schema and Snowflake schema.
• Closely worked with ETL process development team.
• Experienced in designing the Data warehouse.
• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.
• Generated the first cut physical design.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin r7.2, ER Studio, SQL Server 2000/2005, Mainframes, Oracle 9i/10g, UML, SQL Loader, Power Designer.