SUMMARY:

• Eight plus years of professional experience in the field of Data Modeling and Data Analysis in the domains of banking, Insurance and retail companies
• Experienced in gathering business and functional requirements with Use case modelling and UML
• Efficient in working as an AGILE team for the data move from different sources to one target Data Warehouse
• Well versed in conducting Gap analysis, Joint Application Design (JAD) session
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems
• Proficient in software development life cycle (SDLC) methodology like agile scrum, water fall analysis, development, testing and its maintenance
• Good in ER Dimensional Modeling, Database design, writing DDL, DML commands using SQL Developer and implementing RDBMS specific features
• Well - versed in modeling OLTP and OLAP systems using tools like ERwin 9.6/ 8.2/ 8/ 7.3.8, Sybase Power designer 12.1 and E-R Studio
• Used multiple platforms, Oracle/Teradata/ SQL Server/DB2 to design a physical model
• Practiced forward and reverse engineering functions in ERwin
• Good understanding of Ralph Kimball’s and Bill Inmon’s modelling techniques
• Efficient in performing Normalization and De-normalization techniques to improve the performance of a database and have performed normalizations up to 3NF (Third Normal Form)
• Good knowledge on identifying facts and dimension, Data Mart design, creation of Cubes and Coherent in modeling Star schema and Snow flake schema pertaining to dimensional data modelling. Experienced in Data warehouse design and writing data transformation rules or source to target mapping
• Experienced in using SQL for data analysis and data profiling. Well versed in writing SQL queries and performing end to end validations
• Involved in Data profiling and analysis for identifying data quality issues
• Experienced in writing technical and business data quality rules
• Well-versed in ETL design and implementation
• Experience in Data Extraction/Transformation/Loading (ETL), Data Conversion and Data Migration by using SQL Server 2005 Integration Services (SSIS) and worked with the Business Intelligence team on SQL Server Reporting Services (SSRS) and IBM Cognos to collect reporting requirements
• Performed data cleansing, data transformation and data mapping as a part of transferring the data from source to target
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment
• Involved in the maintenance of enterprise metadata repositories
• Worked with Data Governance team to maintain the master copy of the model
• Experienced in Performance tuning on oracle databases by leveraging explain plans, and tuning SQL queries
• Excellent analytical skills and problem-solving skills with ability to learn new technologies efficiently and utilize the quantitative and qualitative skills
• Excellent communication, presentation, database, team support and interfacing skills

TECHNICAL SKILLS:

Data Modeling Tools: ERwin 9.6/ 8.2/ 8/ 7.3.8 / 7.3/ 7.2, ER/Studio 9.7, Rational Rose, MS Visio 2010/2007/2006.

Languages: SQL, HTML, MATLAB, R.

Databases: MS SQL Server 2012/2008/2005/2000/7.0, Oracle 12g/11g/10g/9i, MS Access 2013/ 2010/ 2007, IBM DB2 10.5.

Reporting Tools: Power BI, Tableau Reader 8.1, Oracle Reporting, Crystal reports 9, Cognos Report Studio

ETL Tools: Informatica Data Analyst Tool, Informatica Metadata Manager, Informatica Data quality (IDQ), Informatica Power Center, Data Stage

Other Tools: SSMS, SSIS, R, RTC, RRC, MS Office, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Expertise in requirements gathering, business documentation, database analysis
• Working on Data warehousing project, involving extensive data mapping, data cleansing, data profiling activities in SQL Server Management studio (SSMS)
• Performed Gap Analysis to check the compatibility of the existing mapping documents with the new business requirements
• Worked on Data Models in ERwin to define entities and relationships
• Involved in end-to-end Data Mapping from source to DWH to DataMart’s with technical transformation rules and data load strategies
• Extensive usage of SQL and built financial views for the Actuarial department in SQL Server
• Used Query Analyzer to optimize SQL Queries
• Create/update EVF Views in SQL Server. Also, maintain the daily & Monthly views, reports in the database
• Extensive usage of Informatica Metadata Manager to maintain the Data warehouse and DataMart repositories and also Guidewire Data Dictionary
• Expertise in the usage of Guidewire Policy Center, Billing center and Claim Center
• Performing ETL activities using Informatica to transfer the data from source to data warehouse and then to KPI Data mart
• Implemented Agile Methodology for repeated development and testing using Jira tool
• Work on TFS, to maintain the views, data dictionaries and data models
• Maintain the data Quality and worked closely with Data Governance Team to contributed to Data Dictionary tasks
• Developed reports for Key Performance Indicator (KPI) Data Mart, using Power BI and SQL Server Report Studio (SSRS)
• Assisted business clients team in conducting user acceptance testing (UAT) at final phase of applications development
• Performed data analysis for complex data and files using Informatica Data analyst tool

Environment: SQL Server Management Studio (SSMS), ER Studio, ERwin 9.6, MS SQL server, R, Informatica Metadata Manager, Power BI, Guidewire PC/BC/CC.

Confidential, Scottsdale, AZ

Data Modeler, Data Analyst Lead/ Requirement Analyst Lead

Responsibilities:

• Participated in several requirement meetings to communicate with the business and the development teams, to gather the business and functional requirements
• Working efficiently as an AGILE team for the data move from different sources to one target Data Warehouse
• Involved in planning the methodology using Data Integration Framework and developed data requirements documentation for Enterprise Data Warehouse project
• Performed requirements analysis using Enterprise solution delivery Methodology (ESDM), which involves Initiate, Solution Scoping and designing activities for moving the incremental and historical data into Object Data Store (ODS)
• Lead the large initiative of Profitability Analysis project which involved the move of the Policy and Claims data of source into an Enterprise Data warehouse (target) and is consumable for Analytical needs
• Worked on Rational Requirements composer (RRC) to frame the requirements, details the use cases and make sure the traceability matrix is intact
• Used Rational technical composer (RTC) to create the user stories for the technical line development and for Data analysts work
• Worked on ERwin Data modeling tool to create the Claimcenter and Policy subject areas and also reverse engineered the existing products to perform the Data mapping process
• Contributed to analyst scoping and data mapping process development and tools, techniques and templates. Designed high level source to target mapping documents
• Worked on the Informatica Data Analyst tool to perform data profiling, data analysis which helped in the process of Master Data management
• Performed Data Analysis on WINS (WHEATLY information system) data to produce the Data Dictionary. Used SQL Server Management Studio (SSMS) and Informatica Data Quality (IDQ) for Data profiling and Data mapping.
• Lead the project, which involved the survivorship process of comparing source systems and creating a single enriched data record
• Worked on a POC to create sample reports that can be consumed by Business for Profitability Analysis using Tableau Reader 8.1

Environment: SQL Server Management Studio (SSMS), Rational Requirements Composer (RRC), Rational Technical composer (RTC), Informatica Data quality Toll (IDQ), Informatica Data Analyst tool, Tableau Reader 8.1, Oracle SQL Developer, SQL server 2014, MS Access 2013, ER Studio, ERwin 8.2, MS SQL server, Teradata SQL Assistant.

Confidential, New Jersey

Sr. Data Modeler/Data Analyst

Responsibilities:

• Participated in requirement meetings to communicate with the business analysts and to gather the business and functional requirements
• Prepared conceptual Data Model based on requirements
• Identified Entities and Attributes to build Logical and Physical data models
• Used ER studio to create logical and physical data models for an OLAP system
• Performed normalization up to 3 NF and De-normalization in OLTP and OLAP environments
• Identified facts and Dimensions, and snow flaked star schemas wherever necessary
• Identified and tracked slowly changing dimensions
• Created ODS and Data mart models
• Created DDL scripts by using CA Erwin’s Forward Engineering Utility
• Developed source to target mapping documents to support ETL design
• Worked with organization’s naming standards and used Erwin’s NSM file to convert logical model to physical model
• Worked with end users to collect business data quality rules and worked with the development team to establish technical Data quality rules
• Involved in loading the models to metadata repository and maintaining the models as well
• Worked with architecture team to get metadata approved for the new attributes
• Developed Data governance program establishing metadata registry responsibilities
• Extensively used SQL to conduct Data analysis
• Involved in Data Analysis on Teradata and Oracle Systems querying and writing in SQL
• Worked on the databases like Oracle 11g, Teradata and also interacted with the developers for optimizing the queries and accordingly change the models for faster retrieval of the data
• Interacted with DBA’s to develop a best physical data model from the logical data model
• Mapped business need to subject area models and logical enterprise model
• Proficient in model versioning based on the releases on ERwin model mart
• Implemented Reverse Engineering technique to transfer objects from database to Erwin and cleaned unwanted tables/columns as part of data analysis responsibilities and redefined attributes and relationships in the model which was reverse engineered
• Involved in Performance tuning by leveraging oracle explain plan utility, and SQL tuning

Environment: Oracle 11g, Oracle SQL Developer, SQL server 2014, MS Access 2013, ER Studio, ERwin 8.2, MS SQL server, MS Excel, Windows 8, Teradata.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering along with the business analysts group
• Coherent in all phases including analysis, designing, developing, testing and maintenance
• Involved in JAD sessions and participated in Data analysis as well
• Designed Logical Data model was based on the business requirements using ERwin
• Created physical data models from logical data models
• Discussed Physical Data Model with the ETL Developers and worked with them on day-to-day basis to resolve questions on Physical Model
• Developed entities and relationships using Sybase Power Designer
• Associated with users and several teams of the company, in order to collect the rules of data quality
• Also worked on Data migration and loading the data from tables to target data warehouse
• Developed Star Schema and snow flake schema in the process of designing
• Interacted with the database administrators and business analysts for Datatype and classwords
• Used organization’s naming standard to maintain the same standard in the logical and physical models
• Involved in designing Data marts by using Star Schema and Snowflake schema
• Expertise in using Oracle SQL developer and Toad
• Worked on different source databases like oracle, DB2 and Teradata and performed GAP analysis on Teradata
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept
• Worked with the Data Governance team to maintain the master data
• Improved the data retrieval performance by tuning SQL queries
• Involved in coordinating UAT test cases with business users
• Developed and maintained Enterprise wide logical data model
• Translated business concepts into XML vocabularies by designing XML schemas with UML
• Determined the standards of data quality for an organization and ensured adherence of the data process according to the standards
• Ensured the business Metadata definitions of all data attributes and entities in a given data model are documented to meet standards
• Involved in loading Erwin models to Metadata repository
• Performed Reverse Engineering for a wide variety of RDBMS including Oracle, MS Access in order to connect to an existing database and create ER diagrams
• Worked with Implementation team to ensure smooth transition from the design to the implementation phase

Environment: ERwin 8.2, SQL Server 2012, Oracle 11g, Informatica Power center, MS Access 2013, MS Windows 7/8, Teradata, Sybase power designer.

Confidential

Data Modeler

Responsibilities:

• Gathered and translated the requirements into detailed reporting requirements
• Used Erwin for data modelling, design, analysis, documentation and implementation
• Designed tables and implemented the naming conventions for the fact and dimension of Logical and Physical Data Model using ER Studio and ERwin
• Created and maintained Logical Data Model (LDM) for the project which includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values and codes
• Studied business logic and understood the physical system to manage the sales of data mart
• Created Architectural artifacts for the enterprise data warehouse, such as ER diagrams, conceptual data model and DDL scripts
• Used Forward engineering in Erwin for translation of logical to physical data model
• Provided the design inputs to ETL architect to come up with ETL Design output
• Used top down and bottom up approach to perform gap analysis
• Worked on data mapping process and slowly changing dimension tables in dimensions
• Also worked with technical teams to generate reports using Cognos report studio
• Experienced in Data loading using PL/ SQL Scripts
• Generated data mapping documents to define mapping from source to target
• Assisted in Query tuning by suggesting Optimal Join Conditions
• Extracted data from XML to SQL server
• De-normalized the database to put them into the star schema of the data warehouse
• Experienced in using SSIS in solving complex business problems
• Worked on SSRS in creating and managing reports for an organization
• Created documentation and test cases, worked with users for new module enhancements and testing
• Worked with business SME’s and documented the business rules for ETL development
• Created the data mapping document from source to target and the data quality assessments for the source data

Environment: ERwin 8, MS Windows 7, Oracle 11g, SQL Server, MS Office, IBM Cognos Report Studio, SSIS, SSRS.

Confidential, Basking Ridge, New Jersey

Data Modeler

Responsibilities:

• Worked with the Business analyst group to gather requirements
• Developed a conceptual model based on the requirements analysis
• Designed Logical and physical designs and transformed logical model to physical implementation using ERWIN
• Created Use case diagrams, sequence diagrams and activity diagrams
• Normalized the database up to 3NF to put them into the star schema of the data warehouse
• Used Forward and Reverse engineering tools of ERWIN and attributes, entity relationships were redefined in the reverse engineering model
• Used star schema and snow flake schema in dimensional modelling to meet the reporting requirements for designing data marts
• Experience in implementing custom slowly changing dimensions (SCD) transformations
• Designed and developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database
• Loaded data from source tables to operational data source tables using transformation and cleansing logic
• Conducted performance tuning of the database which included creating indexes, optimizing SQL statements and monitoring the servers
• Worked on reporting requirements for the data warehouse
• Developed several forms & reports using Crystal Reports
• Involved in data mapping
• Worked closely with testing team and created support documents

Environment: ERwin 7.3.8/8, Oracle 11g, PL/SQL, MS Windows 7, Crystal Reports, MS Visio, SSIS.