SUMMARY

• Over 8 Years of professional experience in Data Modeling and Data Analysis design of OLTP and OLAP systems.
• Experienced in Designing Star Schema (identification of facts, measures, and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin Data Modeler, Power Designer, Embarcadero E - R Studio, and Microsoft
• Extensive experience in languages like SQL, Python, and PL/SQL and extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin, and ER Studio.
• Experienced in working with Teradata Utilities like Fast load, Multi load, Tpump, and Fast Export Teradata Query submitting and processing tools like Bteq and Teradata SQL Assistant.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers and proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Experienced in Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting and expertise in UML (class diagrams, object diagrams, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a Business Analysis methodology for application functionality designs using Rational Rose and MS-Visio.
• Expertise with various RDBMS and No-SQL databases like Oracle, SQL Server, DB2 UDB, and Teradata, Netezza and MongoDB, Cassandra.
• Skilled in visualizing, manipulating, and analyzing large datasets and has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Lookups, Index, Match, CountIf, dashboards, etc.)
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart-Box (Drill Down, Drill Up& Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations (Detailed and filled in maps), etc.
• Skilled in Power BI and visualization of the results using Tableau to import, analyze and Create various filters and parameters for reports from various data sources such as SQL Server.
• Proficient in Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Experience transforming large, complex, unstructured data into denormalized star or snowflake schemas
• Strong analytical skills with the ability to collect, organize, analyses and disseminate significant amounts of information with attention to detail and accuracy
• Knowledge of one or more Data Visualization & Reporting tools such as QlikView, Spotfire, SSRS are essential
• Knowledge in Data Engineering, Business Analysis, Advanced Analytics, Data Analysis.

PROFESSIONAL EXPERIENCE

Sr. Data Modeler/Analyst

Confidential, ADA, MI

Responsibilities:

• Provide support in database architecture of the organization through database design, modeling and implementation and develop plans, strategies and standards for data within the enterprise
• Lead the development, validation, publishing, and maintenance of logical and physical data models required to migrate existing independent data marts into the EDW, and for new business requirements to be implemented using the EDW.
• Established method of addressing the pillars of Governance metadata management, master data management, Data Quality, Data Collections, Information Life Cycle, Data Privacy and Security, Data Warehouse and BI.
• Worked on the development of Data Warehouse, Business Intelligence architecture that involves data integration and the conversion of data from multiple sources and platforms
• Used ERWIN entity note/query/sample editor to input general notes about the entity, sample queries involving the entity, sample data instances for the entity used ERWIN report editor to generate reports for entity, attribute, relationship and constraint values.
• Involved in creating Pipelines and Datasets to load the data onto data warehouse and documented Logical, Physical, relational and dimensional Data Models, designed the Data Marts in dimensional Data Modeling using star and Snowflake Schemas.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata Database.
• Involved in analysis, development, testing, implementation and deployment and Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Worked on data pre-processing and cleaning the data to perform feature engineering and performed data imputation techniques for the missing values in the dataset using Python.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using Netezza Database.
• Involved in dimensional modeling of the data warehouse to design the business process dimensions, facts, Star Schema and Snow flake schemas.
• Comprehensive knowledge in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation and Created Complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL plus and developed common SQL*Loader script using UNIX shell script which is been used for most of the conversions.
• Analyzed data lineage processes to identify vulnerable data points, control gaps, data quality issues, and overall lack of data governance.
• Delivering Oracle Database performance-tuning services by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, EXPLAIN PLAN, TKPROF and SQ TRACE.
• Used Data Vault technique and achieved many advantages of Data Vault approach some of them are simplified the data ingestion process, removed the cleansing requirement of a star schema and easily allowed for the addition of new data sources without disruption to existing schema.

Environment: Erwin r9.6, Informatica Power Center 9.6, PL/SQL, MDM, Netezza, Teradata, Oracle 12c, SQL Server, SQL, Teradata SQL Assistant, Aginity, Microsoft Word/Excel, Tableau, T-SQL, Power BI and UNIX.

Sr. Data Modeler /Analyst

Confidential, Evansville, IN

Responsibilities:

• Involved in sessions with business, project manager, Business Analyst and other key people to understand the Business Needs and propose a solution from a Warehouse stand point.
• Standard in designing the architecture of the organization at the enterprise level and thorough understanding and hands on experience of Software Development life cycle from Ideation to Implementation.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using ER Studio.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.
• Conducted live JAR sessions to Elicit, Analyze and Document Business Requirements from the Business and conducted live JAR&JAD sessions with SMEs, and all the placeholders to develop High Level Requirement and then formalized those Requirements to Detail Level Requirements.
• Worked with SME's and other stakeholders to determine the Requirements to identify Entities and Attributes to build Conceptual, Logical and Physical Data Models and designed an Industry standard Data Model specific to the company with group insurance offerings, translated the Business Requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created a high-level industry standard, generalized Data Model to convert it into Logical and Physical Model at later stages of the project using ER-Studio.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle and Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for the Reporting Requirement.
• Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Involved in extensive DATA validation using SQL queries and back-end testing and generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures.
• Conducted design walk through sessions with Business Intelligence team to ensure that Reporting Requirements are met for the Business and developed Data Mapping, Data Governance, and Transformation and Cleansing Rules for the Master Data Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams while working on, SQL Server, Teradata to Analyze and provide solutions to Data issues and other challenges while implementing the OLAP model.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies and Extracted data from Oracle 11g and upload to Teradata tables using Teradata utilities FASTLOAD & Multiload.
• Generated ad-hoc reports using Crystal Reports 9 and Prepared Analytical and Status Reports and Updated the project plan as required.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic and create and deploy reports using SSRS.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Environment: ER-Studio, Python, Teradata, Netezza, Oracle 12c, Microsoft Office SharePoint, Cognos, MS Office (Word, Excel and PowerPoint), SQL Server, MS Project, MS FrontPage, MS Access, EDI, UML, MS Visio, Oracle Designer, SQL Server 2012, Oracle SQL developer 2012, Crystal Reports, SSRS, SSIS and Tableau.

Sr. Data Modeler/ Data Analyst

Confidential

Responsibilities:

• Worked with Business users to know the Business Requirements and Gathered the entire detail Requirements from Business for reporting.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Created data governance and privacy policies specifying contract implementation and Linked data lineage to data quality and business glossary work within the overall data governance program.
• Implemented logical and physical data modeling with techniques using Erwin in Data Mart and Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use Performed Dimensional Modeling on OLAP system using Ralph Kimball methodologies and performed gap Analysis.
• ERWIN relationship definition editor and subtype relationship editor to assist me in designing identifying, non-identifying, recursive and subtype relationship for logical design. Experience, used ERWIN column property editor to create and named physical properties, ERWIN index editor to create, named, sort and cluster for performance tuning for physical design, ERWIN physical object editor and table property editor to create named physical objects for physical design and ERWIN synchronization dialog to sync physical objects with the target environment.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model and 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 Conducted design reviews with Business Analysts, Enterprise Data architect and solution lead to create proof of concept for the reports and involved in Business process modeling using UML through Rational Rose and maintained Metadata, version controlling of the Data Model.
• Created source to target Mapping Documents for renal and immune disease Data Mart with all the upstream sources.
• Wrote SQL scripts for creating tables, Sequences, Triggers, views and materialized views and wrote SQL scripts for Loading Data from staging area to target tables and involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Did performance Analysis and Created partitions, indexes and Aggregate tables where necessary and broken down the hierarchies from the dimensions to create the roll up dimensions.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation and created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Worked on testing primary index and skew ratios before populating data into tables using sampling techniques, explain plan in Teradata before querying large tables with several joins.
• Creating data blending in case of merging two different datasets using Tableau and created Datasets in T-SQL, stored procedures for SSRS.
• Created SQL scripts for Loading the Aggregate tables and rollup dimensions and created package for automated Loading of Historical and Ongoing Data into aggregates.
• Extensively used Aginity Netezza work bench to perform various DML, DDL etc. operations on Netezza database.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.

Environment: Erwin 9.1, ORACLE, Teradata, SQL, T-SQL, PL/SQL, XML, Netezza Aginity, Teradata SQL Assistant, SQL Plus, Informatica, SSRS, SSIS, Power BI, Tableau Excel, MS Visio, Source Offsite (SOS), Windows 7, QC Explorer, Business Objects, Share point workspace 2010.

Data Modeler/Data Analyst

Confidential

Responsibilities:

• Analysis reports prototypes from the Business Analysts belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.
• Provided support to other developers in accurately mapping source attributes into the Teradata Financial Services Logical Data Model (FSLDM) and in interpreting business requirements Reverse Engineering the existing Data Marts and Identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR Schema for sales Data Involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeler.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS, Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies and created and maintained Logical Data Model (LDM) for the project and includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, Business Object Model, and system object Model as they evolve and change and ensured the feasibility of the Logical and Physical Design Models.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts.
• Worked closely with the ETL Developers to explain the complex Data Transformation Logic and provided source to target Mappings to the ETL team to perform initial, full, and Incremental loads into the target Data Mart.
• Coding using Teradata Analytical functions, BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the SQLs on UNIX environment.
• Implemented slowly changing dimensions Type2 and Type3 for accessing history of reference Data Changes.

Environment: SQL Server, SQL Server Analysis Service, SSIS 2008, SSRS 2008, Crystal Reports7.5/8.0, Windows 2000, Micro strategy 9.2, Crystal Enterprise8.0, Erwin 9.1, CSV files, XML files, Business Objects, Oracle10g, Teradata, Netezza, SAS, SSIS, Informatica, XML.

Data Modeler/Analyst

Confidential

Responsibilities:

• Engaged with Business Users Involved in gathering the related Business Requirements and documented the performance of the system by understanding the existing Data Model.
• Mapped the Business Requirements and New Databases to the Logical Data Model which defines the project delivery needs.
• Generated DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
• Designed Fact tables, Dimension and aggregate tables for Data warehouse and worked on the conversion process of Data which is stored in flat files into Oracle tables.
• Provided technical guidance for re-engineering functions of Teradata warehouse operations into Netezza and used various Teradata Index techniques to improve the query performance.
• Implemented naming Standards and Warehouse Metadata for fact and dimension of Logical and Physical Data Model.
• Developed Star Schema and Snowflake Schema in designing the Logical Model into Dimensional Model.
• Translated the Logical Data Model into Physical Data Model with Forward Engineering in Erwin tool.
• Used Reverse Engineering and Forward Engineering techniques on Databases from DDL scripts and created tables and Models in Data Mart, Data Warehouse and Staging.
• Worked on slowly changing dimension tables and hierarchies in dimensions and worked on Data Mapping process from source system to target system.
• Reverse Engineered DB2 databases and forward engineered them to SQL Server 2000 using ER-Studio.
• De-normalized the Database to put them into the Star Schema of the Data Warehouse and created documentation and test cases, worked with users for new module enhancements and testing.
• Understood existing Data Model and documented suspected design affecting the performance of the system.
• End-to-end grasp of the entire Software Development life cycle (SDLC) including Analysis, Design, Development and testing of Software applications.

Environment: ER-Studio, Oracle 10g, SQL Server, Crystal Reports, Windows 7, MS Office, Teradata, Netezza, SQL, PL/SQL, T-SQL, Informatica, SSRS, SAS, SSIS, XML, Excel, Pivot Tables, Metadata, Cogon’s.