SUMMARY:

• Senior Data Modeler/Analyst with 8+years of experience in Data Analysis and developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Evaluating Data Sources and strong understanding of Data warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Extensive experience inRelational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagramsusing multiple data modeling tools likeERWIN, ER Studio.
• 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, ER Studio.
• Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments.
• Implemented automated maintenance management system with ability to track.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Developed and Extending SSAS Cubes, Dimensions and data source views SSAS - Data Mining Models and Deploying and Processing SSAS objects.
• Worked in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change
• Delivered a series of metrics that enabled an increase in supplier performance management.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling aData warehouse in Relational, Dimensional and multidimensional modeling.
• Experienced in understanding the HIG proprietary ETL framework metadata to understand the current state ETL implementation.
• Performed research regarding python programming uses and its efficiency.
• Enthusiastically working on forward and reverse engineering processes.
• Good experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modifieddatabase design document with detailed description of logical entities and physical tables.
• Experienced in Strong in Source to Targetdatamapping, Standardization Document Slowly Changing Mapping Creation, Star/Snowflake Schema Mapping Creation, RDMS, BuildingData Marts and Meta Data Management
• Developed Tableau visualizations and dashboards using Tableau Desktop. Tableau workbooks from multiple data sources using Data Blending.

TECHNICAL SKILLS:

DataModeling: Erwin r9.6/8x/7x, ER/Studio 9.7/9.0/8.0/7. xDataModeling Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Databases: Oracle12c/11g/10g/9i,Teradata R12 R13, R14, MS SQL Server 2005/2008/2012, MS Access

ETL/Datawarehouse Tools: Informatica, SAP Business Objects XIR3.1/XIR2, Web Intelligence, and Tableau

Testing and defect tracking Tools: HP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, Visual Source Safe

Operating System: Windows, Unix, Sun Solaris

Tools & Software: Teradata SQL Assistant, TOAD, MS Office, BTEQ.

Programming Languages: SQL, PL/SQL, UNIX shell Scripting

PROFESSIONAL EXPERIENCE:

Senior Data Modeler/Analyst

Confidential, Bellevue, WA

Responsibilities:

• Gathered and transferred business and functional requirements.
• Analysis of various data elements for data profiling and data mapping.
• Worked on salesforce CRM tool to analyze the customer requirements.
• Using ERWIN data modeler, a STAR schema for sales data was designed that involved shared dimensions.
• Held design reviews with BA team and content developers.
• Based on the services and requirements received from back end services, the BOM was created, updated and maintained
• To incorporate physical information in the BOM, worked closely with service integration team etc.
• Assisted Data architect team to improvise the Business Object Model (BOM).
• A Logical Data Model (LDM) was developed which includes documentation of all the entities, attributes, data relationships, primary and foreign key structures, allowed values, codes etc.
• Experience in creating Physical data model.
• 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 Microsoft Visio 2010.
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.
• The created LDM’s were thoroughly validated and updated to use cases, BOM’s, System Object Model as they evolve and change.
• KIMBALL and INMONN methodologies were used for architecture.
• Worked along with architecture team to get Metadata approved for the new data elements that are added for this project.
• Performed extensive data analysis and data validation on Teradata.
• To populate the database from different sources by the developed ETL routines, DTS tools and services were scheduled to run at different intervals in SQL server.
• The phenomenon of data extraction, transformation, loading, processing in an EDW was done by using ETL methodology.
• For pulling and integration of the data from various databases, MS Access was used.
• Cube and dimension wizards were used to develop and create OLTP cubes
• Involved in SQL server analysis services to build the data warehouse that captured data from developed and existing OLTP systems.
• Involved in front end java applications for data analysis.
• To perform data analysis SAS was used.
• After the scripts are written, troubleshooting was performed along with SQL queries, data mart/data store models.
• Worked on SQL joins, aggregate functions, analytical functions, group by, order by clauses Along with indexes, partitioning and materialized views.
• Worked with ETL team using SSIS packages, to plan an effective package development process, and design the control flow within them.
• Configured report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• To remove redundancy, the dimension snow flaking was done.
• Performed various data reviews.
• Metadata repository was updated and maintained according to change requests.
• Worked on modeling for Business Objects reporting in Teradata, and also OLTP style in Oracle environment that is a source for Teradata for maintenance of dimension attributes.
• Redefined many attributes and relationships in the reverse engineered model and cleaned unwanted tables and columns using E/R studio.
• The logical and physical design models feasibility was ensured.
• Data management was done by using tools and other programs like PERL, TOAD, MS EXCEL, SQL.
• Wrote various scripts of unit, system, integration and UAT testing in projects of data warehousing
• Create and deployed reports using SSIS.
• Interacted with SSRS reporting team to gather reporting requirements, and review summary tables.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: ERWIN 9.6, PL/SQL Developer, Teradata 15, TOAD Data Analyst - 2.1,Oracle 12c,Quality Center-9.2, Informatica 9.6,Microsoft Access, TD SQL Assistant, Microsoft Visio, SQL Server 2008/2012,MS PowerPoint, MS Access, Microsoft Excel.

Senior Data Modeler/Analyst

Confidential, Plano, TX

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created a logical design and physical design in Erwin
• Created ftp connections, database connections for the sources and targets.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Maintained security and data integrity of the database.
• Developed, deployed, and monitored SSIS Packages.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Designed Physical database in the form of Star Schema for Data Mart Design.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Generated DDL Scripts from Physical Data Model using technique of Forward Engineering in Erwin.
• Identified objects and its relationship from existing database, which can be used as a reference for data mart, then transformed those objects into physical model using Reverse Engineering in Erwin.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Collections.
• Expertise in creating Perspectives, Partitions, Design Aggregations, Cell Level Security in cubes and Dashboard Reports to support end users using SSAS.
• Worked extensively with XML schema generation.
• Created DFD (Data Functional Design) artifacts that incorporated the process flow Visio, S-T Mapping document and all the specifications for proper ETL implementation.
• Used Python programming to develop a working and efficient network with the company.
• Participated in Performance Tuning using Explain Plan and Tkprof.
• Extensively used Erwin for developing data model using star schema methodologies.
• Created Unix Shell Scripts for automating the execution process.
• Created PL/SQL packages and Database Triggers and developed user procedures and prepared user manuals for the new programs.

Environment: PL/SQL, SQL, ERWIN r7.3, INFORMATICA, VISIO, Oracle, MS-Word. Tableau, Oracle, SQL Server, Python, Teradata SQL Assistant 12.0, ERWIN data modeler, ODS, TOAD, CA Erwin 7.0

Senior Data Modeler/Analyst

Confidential, Baltimore, MD 

Responsibilities:

• Provided clear and concise documentation regarding requirements management plans, functional requirements, and supplemental requirements.
• Worked with the stakeholders to elicit the business and system requirements and importing them into rational requisite pro.
• Analyzed the scope of the project and identified the major actors involved.
• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Power Designer.
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Provided key initiatives in working with users in defining project and system requirements.
• Tableau workbooks from multiple data sources using Data Blending.
• Performed preliminary analysis on multiple origination and servicing systems and assisted the sourcing team with the creation of Data Requirement Documents.
• CreatedSSISpackages for File Transfer from one location to the other using FTP task.
• Worked in Building Tabular Models using SSAS.
• Extensively used Power Designer to create Data Models for relational and dimensional modeling.
• Developed and co-authored the vision document that defined the primary goals and objectives of the project.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Used SQL assistant tool extensively to profile data and check mapping accuracy.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Experienced in Testing the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Conducted internal and final DFD reviews with the ETL team (EIS) and also FSD reviews.
• Participated in ETL Functional Specifications Document (FSD) reviews and responded to questions related to the mappings, modeling and processing logic flows. Supported ETL with the development process.
• Delivered a series of metrics that enabled an increase in supplier performance management
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Power Designer, MS Office(MS Word, MS, Access, MS Excel, MS PowerPoint, MS Visio),.NET, Teradata, Business Objects, Sybase, RUP, UML, SQL, SAS, Tableau, ETL Abinitio, SWOT analysis, GAP Analysis, Load Runner.

Data Modeler/Analyst

Confidential, Madison, WI

Responsibilities:

• Monitored and improved Identified data quality through the use of internal data tools.
• Created and ran reports, enters data as required, and conducts research inquiries as directed.
• Worked with Clients to gather and document business requirements, conduct extensive data exploration, author technical specifications and coordinate the release and acceptance testing of new development.
• Worked productively with clinical areas and call center; collaborated with cross-functional teams to identify the best effective methods to gather the required data for client reports and queries.
• Collaborated with product development and operational engineers to coordinate the implementation and QA of technical specifications
• Ability to build reporting tools, analyze large sets of data, and do analytical regression models
• Used complex SQL Queries for validating and verification ofdatastructure. Generated reports using complex joins, sub-queries and aggregate functions
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Developed multi-dimensional cubes, dimensions using SQL server analysis services (SSAS).
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Tableau workbooks from multiple data sources using Data Blending.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart.
• Spearheaded the design and development of SQL queries to collect and analyze information toward completion ofdata reporting requests
• Performed small enhancements (data cleansing/data quality).
• Implemented automated maintenance management system with ability to track.
• Performed data analysis on the existing data warehouse.

Environment: PL/SQL, SQL, ERWIN r7.3, Informatica, VISIO, Oracle, MS-Word. Oracle, SQL Server, Tableau Teradata SQL Assistant 12.0, ERWIN data modeler, ODS, TOAD, CA Erwin 7.0

Data Modeler/Analyst

Confidential, Troy, MI 

Responsibilities:

• Interacted with End user community to understand the business requirements and in identifying data sources.
• Prepared High-level logical data models and BRDs (business required documents) supporting the documents containing the essential business elements and the description between the entities.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing logical and Physical data models.
• Designed the Data Marts using Ralf Kimball's Dimension data mart modeling methodologies using ERWIN.
• Designed different type of STAR schemas using ERWIN with various Dimensions like time, services, customers and FACT tables.
• Worked with end users to collect business data quality rules and worked with the development team to establish technical data quality rules.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Coordinated with DBA's and generated SQL code from the data models using.
• Worked closely with the ETL SQL Server Integration Services (SSIS) Developers to explain the Data Transformation.
• Supported UAT (User Acceptance Testing) by writing SQL queries.
• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad.
• Managed day to day operational and tactical aspects of maintenance programs and capital improvement projects to ensure profitable and successful manufacturing operations.
• Performed extensive data analysis and data validation on Tera data.
• Worked with the Reporting Analyst and Reporting Development Team to understand Reporting requirements. Involved in Generating ad-hoc reports using crystal reports 9.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.
• Created and maintained Logical and Physical models for thedatamart, which supports the Credit, Fraud and Risk Retail reporting for credit card portfolio.
• Created the conceptual model for the data warehouse with emphasis on insurance (life and health), mutual funds and annuity using EMBARCADERO ER Studio data modeling tool.

Environment: Microsoft Windows Vista/Unix, ER Studio, ERWIN 7.x, oracle 8i, SQL, MS Excel, SSIS, DB2, TOAD from Quest software.

Data Modeler/Analyst

Confidential 

Responsibilities:

• Identified goals and objectives of projects.
• Created project plan by gathering the requirements from the management.
• Used ErwinDataModelertool for relational database and dimensionaldatawarehouse designs.
• Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting.
• Worked on creating new tables and columns to Baseldatamart.
• Extensively used Star Schema methodologies in building and designing the logicaldatamodel into Dimensional Models.
• Worked with DBA group to create Best-Fit PhysicalDataModel from the LogicalDataModel using Erwin Forward engineering.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
• CreatingDataDefinitions and the MetaDataRepository.
• Exploreddatato identify its model role and measurement level. Verifieddatafor missing values and incorrectdata. And then cleaned and structured thedatabased on the format required.
• Validated the model and ran alternate scenarios/sensitivity analysis.
• Implemented the model and communicated it to end-users and stakeholders.
• Created stored procedures using PL/SQL and tuned the databases and backend process.
• Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
• Experienced in Using CA Erwin Data Modeler (Erwin) for Data Modeling (data requirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems and data marts.
• Worked on Information Systems (FI Systems) and Maintained security anddataintegrity of the database.

Environment: Erwin, MS Excel, Oracle 9i, PL/SQL, MS VISIO, SQL*Loader and UNIX, Erwin, Win7, Oracle 10g, SQL Server, UML, OBIEE, Informatica 8.6.