SUMMARY

• Eight years of IT experience as Data Modeler and Data Analyst in Banking, Insurance, Manufacturing, Airport Parking, Financial, Health Care, Pharmaceutical, Telecommunication.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• In depth understanding of Gap Analysis for AS - IS and TO-BE business processes, risk, impact and feasibility analysis.
• Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Experienced in developing Enterprise Canonical Model (ECM).
• Understanding in development of Conceptual, Logical and PhysicalModels for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Hands on experience in Financial Services data model (FSDM).
• Good understanding of Agile (SCRUM) and Waterfall technologies.
• Extensive work experience in Entity-Relationship diagrams, Dimensional Modeling (Star Schema/ Snowflake Schema) and Data Warehousing.
• Proficient in Normalization (1NF/2NF/3NF) /De-normalization techniques in relational/dimensional database environments.
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata.
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Involved in the maintenance of enterprise metadata repositories.
• Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
• Identified Slowly Changing Dimensions and hierarchies.
• Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
• Extensively worked on Forward Engineering and Reverse Engineering.
• Reverse engineered the database structure from the existing application using Sybase power designer.
• Experienced in Performance Tuning on oracle databases by leveraging explain plans, and tuning SQLqueries.
• Proficient in writing DDL, DML commands using SQL developer and Toad.
• Expertise in performing User Acceptance Testing (UAT) and conducting end user training sessions.
• Proficient in data governance, data quality, data stewardship, metadata management, master data management.
• Developed Data Migration and Cleansing rules.
• Worked in Infosphere MDM data warehouse.
• Partnered with the business to facilitate and implement technology solutions for Wealth Management.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions.
• In depth and thorough knowledge of development and design with RDBMS -OLTP, dimensional modeling usingdata modeling tool ERWIN, Sybase Power Designer.
• Involved in analysis, development and migration ofStored Procedures, Triggers, Viewsand other related database objects with solid experience inMS-SQL Server 6.x to 2008, Sybase 10.12, Sybase 4.2 and Oracle, IBM-DB2.
• Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling andDatavisualization using R and Tableau.
• Statistical Analysis including univariate, bivariate, multivariate methods & extensive use of Logistic Regression.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS

Data Modeling Tools: Erwin 9.5/8/7, MS Visio 2007/2010, ER Studio, Oracle Designer, SAP power designer 16.0/16.5.

Database Tools: Microsoft SQL Server 2008 Oracle 9g/10g/11g, PL/SQL, MS Access, Teradata.

Reporting & Other Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP (Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio, SQL BI.

ETL Tools: SSRS, SSAS, SSIS (SQL Server Integration Services), Data Transformation Services (DTS), Informatica.

Environment: Windows, UNIX, Linux.

Languages: SQL, PL SQL, T SQL, XML, HTML, VB Script, Java Script.

Packages: Microsoft Office 2007/2010, Microsoft Project 2010, Microsoft Visio, Share point Portal Server 2003/2007.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, Ohio

Sr. Data Analyst/ Data Modeler/Business Analyst

Responsibilities:

• A roving modeler, responsible for Key Home Mortgage project called MIDE (Mortgage IntegratedDataEnvironment) which integrates and standardizesdatafrom multiple sources on the Teradata platform. This platform allows to present customized views of a single set of physicaldatato various parts of KHM without the need to duplicate and distribute thatdata. A centralized warehouse environment wheredatafrom KHM sales, origination and servicing systems is integrated and standardized to provide a consistent and integrated view of the business.
• Empowered the retention and acquisition of private banking customers, which boosted deposits by 8%. Increased productivity and reduced loan processing time 2% by facilitating the sharing of data among home loans, auto loans and credit cards.
• Extracted data from Oracle, SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model which analyzes the impact of loan defaults and recoveries.
• Developed complex SQL queries, and perform execution validation for remediation and Analysis.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using ER-Studio.
• Adjusted and maintained SQL script and perform furtherdataanalysis anddataaggregation.
• Interact between technical groups and non-technical line of business partners and internal group subject matter experts.
• SME (subject matter experts) for remediation exclusion andDataDictionary.
• Involved in process improvement, infrastructure, Business Support (Remediation Process), Support Structure and Analytics.
• Analyzed requirements anddatamodels, development of cases for complex scenarios.
• Worked withdataand results; gatherdatain reports; extensively analyzedataand observations; express analysis and observation.
• Obtained information from disparate sources, including production and ad hoc systems, linking and analyzing the information, performingdataintegrity checks and exploratorydataanalysis.
• Gathered business and Technical requirements that would best suit the needs of the technical architectural development process.
• Worked with internal architects and, assisting in the development of current and target state enterprise dataarchitectures.
• Involved in defining the source to targetdatamappings, business rules anddatadefinitions.
• Comprehensively useddataanalysis techniques to validate business rules and identify low quality missingdata.
• Extensively used SQL for accessing and manipulating database systems
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Acted as a liaison between the development team and the management team to resolve anydata conflicts in terms of requirements.
• Interacted with all levels of the project team, from end users to Software Architects,datagovernance team, Database Administrators, and testers.

Environment: Erwin r9.5, Informatica 8.6.1, Oracle SQL Developer, Oracle Data Modeler, TOAD, Oracle 9i/10g, Teradata 14, DB2, SSIS, Business Objects, SQL Server 2005/2008, SQL, PL/SQL, IBM DB2, VBA MS Excel, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential, Mount Laurel, New Jersey

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Created the Source System Analysis documents and Architectural Solution documents.
• Developed the logical and physical data model for the proposed solution.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Created views to support the Business Objects.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Extensively used the dimensional modelling for the data ware house design.
• Involved in many of the integration projects.
• Created Indexes and capacity planning and worked closely with the DBA’s.
• Created Summary and Aggregate tables for better performance of the query.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required

Environment: Erwin r9.5, Oracle 9i/10g, Teradata 14, TOAD, ERWIN r7.3, Teradata SQL Assistant 13.0, DB2, SSIS, Business Objects, SQL Server 2005/2008, SQL, PL/SQL, IBM DB2, VBA MS Excel, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential, Warren, New Jersey

Sr. Data Analyst/ Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, creating robust data models, data analysis features and enhancements for this major provider of home and auto insurance in property predictive modeling.
• Participated with in a team of data management subject matter experts to identify and evolve key data management strategies and initiatives within the organization.
• Refined and standardized data modeling practices to align with application paradigm (E.g. Business Intelligence, Transactional Processing, Big Data etc.)
• Translated and transformed business requirements into Conceptual, Logical, and Physical data models.
• Conducted extensive data analysis to evaluate data sources to determine the best source for business information.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Implemented business models consistent within organizations Information Architecture strategy.
• Facilitated the interaction between the development teams and the DBA staff to design physical database structures that meet performance expectations and deliver business function.
• Adhered to approved architectural standards; Recommended architectural standard improvements.
• Defined, developed and delivered consistent information and data standards, methodologies, guidelines, best practice and approved modeling techniques around data quality, data governance and data security.
• Partnered with subject matter experts, architects and developers to capture and analyze business needs to complete all data modeling related artifacts including Conceptual, Logical and Physical Data Models.
• Worked with data integration teams to ensure that the model design and development is properly communicated.
• 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.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Participated in design reviews and ensure that model solutions meet database standards.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose using Erwin 9.5 report designer.
• Experienced in development and design of RDBMS -OLTP, dimensional modeling usingdata modeling tool ERWIN, Sybase Power Designer.
• Designed, documented and implemented common message models (XML).
• Defined message models that are ideally scalable, reflective of industry standards.
• Analyzed existing business processes and data flows and determined the most optimal level of normalization for message publication.
• Reviewed data & message Models with Architecture Review Board.
• Independently estimated work effort.
• Mentored junior resources as designated by team leader.

Environment: Erwin r9.5, Oracle SQL Developer, Oracle Data Modeler, Teradata 14, DB2, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential, Northbrook, Illinois

Sr. Data Modeler / Data Analyst

Responsibilities:

• Worked with Business Analyst for requirements gathering, business analysis and project coordination.
• Developed aConceptual Model and Logical Modelusing Erwin based on requirements analysis.
• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• 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 dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Extensively used Star and Snowflake Schema methodologies.
• Worked on Slowly Changing Dimension tables.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose.
• Experienced in data migration and cleansing rules for the integrated architecture (OLTP, ODS, DW).
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Environment: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, Teradata 14, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel.

Confidential, Indianapolis, IN

Sr. Data Modeler / Data Analyst

Responsibilities:

• Coordinated in requirements gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Developed Conceptual model using Erwin based on requirements analysis.
• Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user’s understanding of the data warehouse objects
• Implemented the slowly changing dimension (Type II) and determined the hierarchies in dimensions.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Extensively used reverse engineering feature of Erwin to save the data model with production.
• Used Erwin data model mart for storing different versions of the model.
• Involved in maintenance of models and loading models to Metadata Repository.
• Involved in data analysis of the Teradata.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, Objects, Triggers, cursors, cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Responsible for integrating the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin 8.0, SQL, SQL Server 2012, Teradata, SQL Assistant 12.0/13.11, Data stage 8.1, DB2.

Confidential, Atlanta, GA

Data Modeler / Data Analyst

Responsibilities:

• Demonstrated strong analytical skills in identifying and resolving data exchange issues.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management.
• Executed enterprise Data Governance strategies in line with the organization’s business strategies and objectives.
• Good experience in data analysis querying and writing in SQL and TOAD.
• Extensively used Data Tools to maintain consistent data.
• Performed Data Stewardship roles like implementing data standards, creating metadata and managing databases.
• Performed data conversion from multiple sources and verified validation test on the converted data.
• Good understanding and experience with the entire Data Migration process from analyzing the existing data, cleansing, validating, translating tables, converting and subsequent upload into new platform.
• Used E.F Codd’s Normalization (1NF, 2NF & 3NF) and Demoralization techniques for effective performance in OLTP and OLAP systems.
• Designed data models in Dimensional Modeling (DM) environment.
• Executed SQL queries to retrieve data from databases for analysis.
• Created Data Model Reports and Data Dictionary (DD) using ERWIN.
• Developed normalized Logical and Physical database models to design OLTP system for enterprise applications.
• Performed forward engineering operations to create a physical data model with DDL that best suits requirements from the logical data model.

Environment: CA Erwin 8, Oracle10g, SQL server 2012, IBM DB2, Informatica Power Center 8.6, SQL BI 2008, Oracle BI, Visual Studio, SSIS&SSRS, SQL server management studio 2012.

Confidential, New York

Data Analyst

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Involved in developing Conceptual Data Model and conducted controlled brainstorming sessions with project focus groups.
• Identified the Objects and relationships between the objects to develop a logical model and translated the model into physical model using Forward Engineering in ERWIN.
• Conducted logical data model walkthroughs and validation.
• Hands on experience in Financial Services data model (FSDM).
• Used Model Marts to understand different versions of data models existing in the system.
• Involved in dimensional modeling in identifying the Facts and Dimensions and different hierarchies.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Worked extensively on SQL querying using Joins, Alias, Functions, Triggers and Indexes.
• Managed all indexing, debugging andquery optimization techniques forperformance tuning usingT-SQL.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Worked with business analyst to design weekly reports using combination of Crystal Reports.
• Understood existing data model and documented suspected design affecting the performance of the system.
• Assisted in the Master Data Management strategies and process improvements.
• Experienced in data cleansing and Data migration for accurate reporting. Thoroughly analyzed the data and integrated different data sources to process matching functions.

Environment: Erwin 7.2, SQL Server 2008, SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, TOAD.

Confidential

Data Modeler

Responsibilities:

• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis.
• Identified the Entities and the relationships between the Entities to develop a logical model and later translated into physical model.
• Developed Facts & Dimensions using ERWIN.
• Used Normalization up to 3NF and De-normalization for effective performance.
• Developed Star and Snowflake schemas using dimensional data models.
• Involved in designing OLAP data models and extensively used slowly changing dimensions (SCD).
• Enforced Referential Integrity for consistent relationship between parent and child tables.
• Strong working experience in Extract/Transform/Load (ETL) design and implementation in areas related to Teradata utilities such as Fast Export and MLOAD for handling multiple tasks.
• Extracted data from databases like Oracle, SQL server and DB2 using Informatica to load it into a single repository for data analysis.
• Created source to target mapping specifications using Informatica data quality tool.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems.
• Compared data with original source documents and validated data accuracy.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Experienced in data migration and cleansing rules for the integrated architecture (OLTP, ODS, DW).
• Worked on multiple data marts in Enterprise Data Warehouse (EDW).
• Involved in generating reports and maintaining the data base.

Environment: Erwin r7.0, SQL/MS SQL Server, MS Analysis Services, Windows NT, MS VisioXML, Informatica.

Confidential

Data Modeler / Analyst

Responsibilities:

• Created documents for technical & business user requirements during requirements gathering sessions.
• Transformed project data requirements into project data models for OLAP and OLTP systems using ERWIN.
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Developed logical data model into the physical database design for data marts using Bill Inmon methodology and recommended technical approaches for good data management practices.
• Created dimensional model for the reporting system by identifying required facts and dimensions using ERWIN.
• Reverse engineered the database structure from the existing application using Sybase power designer.
• Developed Data Migration and Cleansing rules.
• Developed data mapping documents between legacy, production and user interface systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
• Experienced in data cleansing for accurate reporting. Thoroughly analyzed the data and integrated different data sources to process matching functions.

Environment: ERWIN r7.2, PL/SQL, MSSQL, SQL Server 2008, Sybase 12, Ms Visio, Business Objects, Windows NT, Linux, Sybase Power Designer.