Candidates About

 

Angel Sunayana

 

Summary:

 

·         7+ years of experience in IT industry, with primary focus in the data modeling, analysis, design, development, testing and support of Data Warehousing and Data Modeling projects.

·         Proficient in Software Development Life Cycle (SDLC), Project Management methodologies, and developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems using Erwin and ER Studio, Power Designer and IBM Data Architect.  

·         Worked with Star schema and Snowflake schema, FACT & Dimensions tables in both Data Warehousing models and normalized data models.

·         Proficient in data mart design and creation of cubes using dimensional data modeling. Well versed in Normalization and De normalization techniques for optimum performance in relational and dimensional database environments.

·         Worked in a fast paced agile approach.

·         Experience working on Industry specific Data Models to customize them as per the standards of the company.

·         Worked closely on Enterprise models for TERADATA.

·         Developed physical data models by conversion of logical models in TERADATA.

·         Worked with Data Models in MS SQL, DB2 and Oracle DB, Netezza.

·         Worked with ODS, EDW and Data Governance projects.

·         Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Micro strategy, Tableau.

·         Expertise in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS), and Informatica.

·         Experienced in working with Weblogic/webservers and Java environments.

·         Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.

·         Experience with data warehousing design methodologies using Kimball or Inmon approaches

·         Excellent Team player to work in conjunction with Business analysts, Production Support teams, Subject Matter Experts, Database Administrators, ETL team and Database developers.

·         Familiarity with the functioning of operating of Amazon web services.

·         Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions.

 

Professional Experience 

 

Kroger                                                                                                            May 2016 - Present

Blueash,OH

Data Modeler

 

The Kroger Company is an American retailer founded by Bernard Kroger in 1883 in Cincinnati, Ohio. It is the country's largest supermarket chain by revenue, second-largest general retailer, and twenty-third largest company.

 

Responsibilities:

Ø  Leading and participating in the design and implementation of large and/or architecturally significant applications.

Ø  Championing company standards and best practices. Working to continuously improve software delivery processes and practices.

Ø  Working successfully in an Agile Project across multiple feature and component teams.

Ø  Developing Erwin Data modeling specifications in Erwin and Metadata maintainence.

Ø  Completing estimates and work plans in Program Increments (PI) Meetings as appropriate for design, development, implementation and rollout tasks.

Ø  Participating in all phases of system testing.

Ø  Working collaboratively across a high functioning agile team.

Ø  Participate in Sprint Planning, retrospective, PI planning sessions

Ø  Communicating with the appropriate teams to ensure that assignments are managed appropriately and that completed assignments are of the highest quality.

Ø  Involved in collaborating with ETL/Informatica teams to source data, perform data analysis to identify gaps

Ø  Development of Data Models by employing needed transformations on ETL Data

Ø  Perform unit testing on developed models

Ø  Working with Aginity AMP, IBM Campaign/Unica  for ETL implementation.

Ø  Creation of Logical, Physical Data models

Ø  Create models in 3nf form, employ Kimball methodologies

Ø  Modeling Type 1 and Type 2 Dimensions

Ø  Worked with Slowly changing Dimensions - Type 1,2

Ø  Working with ETL Informatica job scheduling in IBM Tivoli

Ø  Reverse engineering SQL DB to get Physical data models

Ø  Forward engineer the Physical model to get DDL and implement them in DB

Ø  Working on Transactional data with multiple customer transaction data

Ø  OLAP modeling for BI reporting needs

Ø  Aginity AMP Modeling for Source to Target mapping of ETL sources

Ø  Creation of Load mappings to load data in Base structure, creation of publication mappings to publish data into Analytics, reporting and campaign marts

      

Projects : NED, Next Generation Loyalty, Customer Experience Platform

 

Environment:  Netezza, PL/SQL,  Erwin 9, Informatica 7.1, Cognos, IBM Tivoli, IBM Campaign,  SQL Server 7.0,  MS Access, MS Excel, Teradata, powerdesigner 

 

American Airlines                                                                                                               Aug 2015 - Dec 2015

Fort worth, Texas

Data Modeler/ Data Analyst

American Airlines, Inc. (AA) is a major United States-based airline, operating an extensive international and domestic network, and is the world's largest airline by fleet size and revenue, and the second-most by number of destinations, only after United Airlines. It operates from its main hub at Dallas/Fort Worth.

 

Responsibilities:

 

Ø  Translate business and data requirements into Logical data models to support of Enterprise Data warehouse (EDW), OLTP, Operational Data Structures (ODS) and Analytical systems.

Ø  Working in a fast paced agile project with 3 week sprints and targeting to provide deliverables by end of the sprint.

Ø  Worked under direction of American Airlines Data team to make changes or create new Data models.

Ø  Collaborate with DBAs to implement mitigating physical modeling solutions into the physical data base.

Ø  Worked on both OLTP and OLAP modeling environments.

Ø  Done Dimensional Data models and also 3rd NF data models.

Ø  Perform source data analysis, data discovery and data profiling in MS SQL server.

Ø  Provided data structures optimized for information entry and retrieval to application developers and DBAs.

Ø  Reverse Engineer Data Models in Erwin from MS SQL, Oracle, and DB2.

Ø  Communicate data design to other members of the team to ensure proper implementation and utilization of the designed data structures.

Ø  Support development team during design process design and during performance tuning.

Ø  Participate in both business & IT planning and in the development & management of project plans.

Ø  Support ongoing data modeling efforts for Development and Production environments.

Ø  Maintain Metadata and documentation of new metadata.

Ø  Handled change requests for DB object changes.

Ø  Map logical entities to Enterprise Canonical Data Model.

 

 

Environment:  Oracle, SQL Server, Teradata, Metadata, Erwin 7.1, Informatica 7.1, Cognos, Business Objects, SAP MDM, SAS, SQL Server 7.0, SQL Server7.0, Windows NT, SOA Architecture, Oracle8i, RDBMS, MS Access, MS Excel, MOSAIC.

 

Projects: Revenue Integration and Planning (Financial project), Network planning portal

 

 

Caresource Management Group, Dayton, Ohio                                                             March 2014 – July 2015

Data Modeler

 

Care Source is a leading non-profit public sector managed health care company, meeting the needs of health care consumers for more than 24 years. . As one of the largest Medicaid Managed Care plans in the country and the largest in Ohio, Care Source understands the challenges consumers face navigating the health system. Care Source members complete a Health Risk Assessment and have access to the Nurse Advice Line.

 

Responsibilities:

 

Ø  Business Requirement Analysis: conduct focus groups with Business users for data gathering & analysis.   

Ø  Developing Logical and Physical data models according to enterprise data management practices. 

Ø  Ensuring the quality of data submitted to regulatory agencies by developing detailed metadata for submissions.

Ø  Worked on both OLTP and OLAP modeling environments.

Ø  Done Dimensional Data models and also 3rd NF data models.

Ø  Worked on Industry specific Data model for Health Insurance.

Ø  Handled Data Model changes to create/drop or alter foreign keys, primary keys, indexes, referential integrity and column constraints.

Ø  Forward engineered the data models to generate DDLs for DBAs.

Ø  Mapped existing systems to Teradata FSDM. - Financial Services Industry Data Model

Ø  Developed data models in 3^rd normal form.

Ø  Designing of data models for reporting and analytic databases that translate business and regulatory rules and definitions into query able data structures in MS SQL environment.

Ø  Designing dimensional data models for development of new transactional systems for Webservices.

Ø  Designing data models for development of a data warehouse and data marts.

Ø  Reverse engineer data models for existing databases and systems.

Ø  Working with data analysts to identify data issues within the organization and assist in the development plans to resolve data issues.

Ø  Lead a Data governance project for redefining Naming standards to customize TERADATA model to EDM.

Ø  Worked with ETL and BI reporting teams for reporting/analysis with tools such as IBM Cognos, Business Objects, Microstrategy, Tableau.

Ø  Implemented and supported Erwin data models in production environment.

Ø  Monitoring and creation of Business Glossary.

Ø  Involved in designing architecture for the organization on an enterprise level. 

Ø  Involved in Naming standards.

Ø  Depict the flow of data within and between technology systems and business functions/operations. 

Ø  Developing and maintain detailed documentation that provides traceability for all enterprise data back to its source.

Ø  Maintained Teradata Health care Data Model.

Ø  Worked on Projects  - HEDIS, HIX, DELL FMS,Medicaid, PHI

 

Environment:  BI Microstrategy, Oracle, SQL Server, Teradata, IBM Midrange (LINUX - AIX), and IBM Mainframe DB2i, PL/SQL, Metadata, Erwin 7.1, Informatica 7.1, Cognos, Business Objects, SAP MDM, SAS, SQL Server 7.0, SQL Server7.0, ERWIN, Windows NT, SOA Architecture, Oracle8i, RDBMS, MS Access, MS Excel,Metadata, powerdesigner.

 

 

Burlington Northern Santa Fe Railway, Fort worth, Texas                                             Sep 2012 – Feb 2014

Data Modeler

 

BNSF Railway is the product of nearly 400 different railroad lines that merged or were acquired over the course of 160 years. BNSF Railway is one of North America’s leading freight transportation companies, with a rail network of 32,500 route miles in 28 states and two Canadian provinces. BNSF’s planned capital investment for 2013 is $4.1 billion. Record of Carloads shipped in 2012 totaled 9.5 million making BNSF a leader in railway logistics.

 

Responsibilities:

 

Ø  Business Requirement Analysis: conduct focus groups with Business users for data gathering & analysis.      

Ø  Physical Data Modeling to support and Maintain the Data warehouse.        

Ø  Co-ordinate with Physical Database administrators to deploy a Physical data model.

Ø  Create/Modify/drop database objects for performance.

Ø  Creation of Meta Data Repository.

Ø  Handled Data Model changes to create/drop or alter foreign keys, primary keys, indexes, referential integrity and column constraints.

Ø  Gap analysis for comparing the EDM to existing Subject areas.

Ø  Forward engineered the data models to generate DDLs for DBAs.

Ø  Worked in the Database group as a Data Modeler supporting on 5 database platforms: Oracle, SQL Server, Teradata, IBM Midrange (LINUX - AIX), and IBM Mainframe DB2. Using Erwin software to maintain data models, and BMC Remedy change software.

Ø  Development of ad hoc queries on the data base to provide critical information available in the data warehouse.

Ø  Involved in Naming standards.

Ø  Development of MSAccess DB.

Ø  Worked on both OLTP and OLAP modeling environments.

Ø  Done Dimensional Data models and also 3rd nf data models.

Ø  Engaged in translating business requirements into conceptual, logical and physical data models.

Ø  Development of a data strategy and associated polices for SOA and Weblogic

Ø  Interpreting data requirements to create canonical data model objects such as elements, complex types and data mappings within the ignite XML canonical data modeling tool

Ø  Facilitated requirements, designed master data schema, and define data transformation rules, and load data into MDM.

Ø  Selection of capabilities and systems to meet business information needs

Ø  Logical and Physical Modeling using Erwin 7.3.2

Ø  Developed Models in 3NF form and developed dimensional modeling constructs

Environment:  Oracle, SQL Server, Teradata, IBM Midrange (LINUX - AIX), and IBM Mainframe DB2i, PL/SQL, Metadata, Erwin 7.1, Informatica 7.1, Cognos, Business Objects, SAP MDM, SAS, SQL Server 7.0, SQL Server7.0, ERWIN, Windows NT, SOA Architecture, Oracle8i, RDBMS, MS Access, MS Excel,Metadata, powerdesigner.

 

 

Centric Group, St. Louis, MO                                                                                       Sep 2011 – Aug 2012

Data Analyst

 

Centric Group is comprised of several businesses that serve a variety of markets. In 1974, Enterprise Rent-A-Car ventured outside the automobile industry with the purchase of Jack Keefe Coffee Bar Sales. Keefe sold in-room pots and coffee to hotels, with annual sales of $250,000. By developing original products, finding new markets for existing products and acquiring additional businesses, Enterprise’s “non-automotive” division prospered and grew. In August 1999, Centric Group was established as a separate company.

 

Responsibilities:

 

Ø  Gathered requirements from Business Analysts for the studies to track customer behavior and determine the evaluative criteria.

Ø  Analysis of data in the data warehouse using SQL & PL/SQL.

Ø  Involved with the performance tuning of the data base.

Ø  Communicated with multiple LOB's for refining the data modeling projects for consumer credit and SCM

Ø  Managing an existing database and accompanying workflow system to manage product deletions.

Ø  Conducted meetings for the purpose of requirement gathering from the users for reporting.

Ø  Played a key role in working with the developers, making them understand the business requirements and the importance of working based on business requiremen