SUMMARY:

• Over 7.5+ years of experience as Data Modeler and Data Analyst in design and development of database and data models for various OLTP (Online Transactional Processing), OLAP (Online Analytical Processing) Systems.
• Expertise in Relational Data Models (conceptual, logical and physical data models), Dimensional Data Models, Data Dictionary and Metadata.
• Strong background in various Data Modeling tools using ERWIN, ER/Studio and Power Designer.
• Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, E - R Studio.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server and Teradata.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Well versed in Normalization (1NF, 2NF and 3NF) and De normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in modeling Kimball and Inmon Data Warehousing environments.
• Implemented slowly changing dimension (SCD) type I and type II in dimensional modeling as per requirements.
• A good understanding of Extract, Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Worked in Data Warehouse Data &ETL Architecture, Oracle Database platform, Erwin Data Modeler, Informatica Power center and SSIS.
• Experience in gathering requirements and making BRD, FSD, and SRS documents
• Exposure to data analysis using MS Excel and SAS.
• Skilled in System Analysis, E-R/Dimensional Data Modeling, Database Design and implementing RDBMS specific features.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL. Good understanding on data governance and master data management.
• Experienced in Data loading using PL/SQL, SQL Server Integration Services packages (SSIS), Oracle Data Integrator (ODI) and developed dashboard reports using SQL Server reporting services (SSRS).
• Extensive experience in business intelligence tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Involved in the forward engineering of the logical models to generate the physical tables using Erwin2.5.
• Have good Unix and Shell scripting skills.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging.
• Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors.
• Involved in projects having to deal with cross functional teams and multiple stakeholders.
• Minimum time to self-sufficiency in any environment.
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 8.0, r9.6, r9.5, 9.1, Oracle Designer, Sybase Power Designer.

OLAP Tools: MS SQL SSAS, DB2 OLAP, Cognos Powerplay

ETL Tools: SSIS, Informatica Power Center, SAS BI

Database Tools: SQL Server 2008/2012/2014/2016, Oracle 10g/11g, MYSQL, MS-ACCESS, Teradata.

Reporting Tools: SSRS, Power BI, Tableau, Report Builder, Share Point, SAS Graph, MS-Excel, SAS BI Platform

Languages: SAS, HTML, Java, .Net, T-SQL, PL/SQL, MDX, DAX, UNIX shell Scripting.

Batch Server: UNIX, Putty, SSH, SAS scripting

Web Server: MS-FrontPage, HTML, Linux, Apache Server

Networking: Windows 95/98/XP, Linux, Server+

Operating System: Windows 95/98/XP/Vista/Win 7, Unix, Linux, MAC OS, DOS, Windows NT/ 2000/2003/2008

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, IN

Sr. Data Modeler/Data Analyst

Roles and Responsibilities:

• Interacted with End user community, external vendors to understand the business requirements and in identifying data sources.
• Participated in Daily Status meeting and Weekly Status Reports of the group and meeting with Manager and Client Executives.
• Played a major role in SDLC from requirement, design, development, testing and rollout to the field user and support for production environment.
• Identified and designed business Entities and attributes and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Developed normalized Logical and Physical database models for designing an OLTP application.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Created XSD's for applications to connect the interface and the database.
• Compare data with original source documents and validate Data accuracy.
• Used Forward engineering to develop physical model with DDL based on the requirements gathered from a logical model in ERWIN.
• Created entity / process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Conducted sessions with architects, business and development teams to understand the Change Requests (CR's), and effects caused on the system by the change requests.
• Checked for all the modelling standards including naming standards, entity relationships on model and for comments in the model.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Generated a separate MRM document with each assignment and shared it on SharePoint along with the PDF of updated data models.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBAs' to apply the data model changes.
• Implemented Error Handling during ETL load in SSIS packages to identify dimensions and facts that were not properly populated.
• Performed detailed data analysis to analyze the duration of claim processes and created the cubes with Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS) 2012.
• Used JIRA to manage, track stories and defects.
• Involved in Data Mapping activities for the data warehouse.
• Extensively worked on Performance Tuning and understanding Joins and Data distribution.
• Executed DDL to create databases, tables and views.
• Generate reports for better communication between business teams.
• Assisted the ETL Developers and Testers during the development and testing phases
• Implemented RUP recommended visual models to draft requirements using business use cases.

Environment: ERWIN 9.6.1, ER/ Studio, SQL Server 2014, Oracle 11g, MS Excel, SSIS, SSRS, MS Access, SharePoint 2003, JIRA, Master Data management, Data Cleansing, crystal reports.

Sr. Data Modeler/Data Analyst

Roles and Responsibilities:

• Interact with the business partners, functional analysts, SMEs and scrum masters to gather business and technical requirements and understanding the flow of the process.
• Developed a Conceptual model using Erwin based on business requirements.
• Built conceptual, logical and physical models using Erwin.
• Involved in Analysis, profiling and cleansing of source data and understanding the business process.
• Used Normalization techniques to normalize the data in ODS.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.
• Created grid reports, graph reports, drill down and drill through reports.
• Developed normalized Logical and Physical database models to design OLTP system for finance applications. Created dimensional model for reporting system by identifying required dimensions and facts using Erwin r8.0.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Built ODS integrating the source systems for ad-hoc reporting.
• Identified facts and dimensions based on KPI and also identified the source tables.
• Involved in documentation of Data Mapping and ETL specifications for development from source to target.
• Created Indexes and Partitions to optimize the performance.
• Implemented the change Data Capture (CDC) while integrating the enterprise data sources.
• Assisting ETL Team, BI team and end users to understand the data model.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

Environment: ERwin 9.5, Oracle 11g, ODI 11.1.6, OBIEE, SQL Server 2012, SQL Developer, MS Office, Crystal Reports.

Data Modeler/Data Analyst

Roles and Responsibilities:

• Worked closely with Business, DBA team, ETL and Reporting teams and have good experience with requirements gathering, conducting JAD session to discuss overall design patterns of Conceptual, Logical and Physical data Models.
• Designed and built Data marts by using Star Schema.
• Identified and compiled common business terms for the new policy generating system and also worked on contract Subject Area.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams.
• Gathered and documented requirements of a Qlikview application from users.
• Extracted data from various sources (SQL Server, Oracle, text files and excel sheets), used ETL load scripts to manipulate, concatenate and clean source data.
• 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.
• Responsible for defining database schemas to support business data entities and transaction processing requirements.
• Used SQL tools like Teradata SQL Assistant and TOAD to run SQL queries and validate the data in warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems
• Closely worked with Business Architects and Solution Architects to created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input.
• Prepared analytical and status reports and updated the project plan as required.

Environment: Erwin 8.2.5, Informatica Power Center 8.X, Teradata 13.0, SQL Server 2005/2008, Oracle 11g, Toad, DB2, Business Objects XI 3.1, WebI, MS Office, Windows 7.

Data Modeler/ Data Analyst

Roles and Responsibilities:

• Involved in analysis of Business requirement, Design and Development of High level and Low level designs, Unit and Integration testing.
• Used Erwin for creating logical and physical data models for Oracle and Teradata database design, star schema design, data analysis, documentation, implementation and support.
• Used Erwin7.0 tool for reverse engineering and target database schema conversion process.
• Used dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Applied Data Governance rules (primary qualifier, Class words and valid abbreviation in Table name and Column names).
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin.
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Implemented the model and communicated it to end-users and stakeholders.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Used SQL Server Integrations Services (SSIS) for extraction, transformation, and loading data into target system from multiple sources.
• Created package to transfer data between OLTP and OLAP databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text files, MS Access and CSV files to data warehouse.
• Involved in mapping the load data to the target based on primary, and foreign key relationship considering the constrained based load order.

Environment: Oracle 11g, Teradata 12, MS SQL Server 2008, SQL Server 2008 Integration Services, ERwin 7.0, ER/ Studio 8, TOAD 9, XML, Microsoft Excel 2007, Access 2007, Business Objects SI, Acute reports 10, Power Designer.

Data Analyst

Roles and Responsibilities:

• Gathered and translated Business requirements into detailed production-level technical specifications.
• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Responsible for understanding design and structure of different databases. Also involved in writing ad-hoc queries for data mining.
• Create logical and physical models using best practices to ensure high quality and reduced redundancy.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Used DDL and DML commands for writing triggers, stored procedures and data manipulation.
• Involved in tuning system stored procedures for better performance.
• Configured Exchange Server for sending automatic mails to the respective people when a job failed or succeed.
• Worked with the application developers and provide necessary SQL Scripts using SQL and PLSQL.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS.
• Expertise in Generating Reports using SSRS and Excel Spreadsheet.
• Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports.
• Good Understanding in Database and Data Warehousing Concepts.

Environment: Oracle8i, SQLServer, SSIS, SSRS, ERwin, HTML, Crystalreports9, MSOFFICE, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Profiler.