View Bench List Portal

Similar candidates

• Bill Hludzinski
• Varuna Nayini
• Yuriy Usenko

Around seven years of experience in the Information Technology industry, which includes demonstrated work experience as the DATA MODELER, data analyst and ETL/Report Developer. Expertise in gathering business requirements and decision support, strategic analysis which plays a key role in software development life cycle (SDLC).

Professional experience:

Sherwin-Williams, Cleveland, Ohio                                                                                   Dec 2013 – Till Date

Sr. Data Modeler/Data Analyst

Sherwin-Williams are one of the leading fortune company in general building materials industries which engages in manufacture, distribution and sales of paints, coatings and related products to industrial, commercial and retails customers.

Roles & Responsibilities:

• Involved in gathering user requirements along with business analysts.
  
  
  • Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
  
  
  

• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.

• Transformed project data requirements into project data models.

• Responsible as a member of development team to provide business data requirements analysis services, producing logical and Physical data models using Erwin r7.0.

• Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.

• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering.

• Involved in designing built Data marts by using Star Schema and Snowflake schema.

• Closely worked with ETL process development team.

• Experienced in designing the Data warehouse.

• Extensive system study, design, development and testing were carried out in the Oracle environment to meet the customer requirements.

• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

• Generated the first cut physical design.

• Developed data mapping documents between Legacy, Production, and User Interface Systems.

Environment: Erwin r7.0, Data Maker, Model Manager, Oracle 11g, Informatica Power Center, Windows XP, Unix.