• Dashboard
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Customer Service
      • Education
      • Sales
      • Manager
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Microsoft Word
      • Professional
      • Modern
      • Traditional
      • Creative
      • View All
    • Resume Services
    • Resume Formats
      • Resume Formats
      • Chronological
      • Functional
      • Combination
    • Resume Review
    • How to Write a Resume
      • How to Write a Resume
      • Summary
      • Experience
      • Education
      • Skills
        • Skills
        • Hard Skills
        • Soft Skills
    • Resume Objectives
  • CV
    • CV
    • CV Examples
    • CV Formats
    • CV Templates
    • How to Write a CV
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Customer Service
      • Marketing
      • Sales
      • Education
      • Accounting
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Questions
  • Resources
  • About
    • About
    • Reviews
  • Contact
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Master Data SME-Manufacturing
Please provide a type of job or location to search!
SEARCH

Master Data SME-Manufacturing Resume Example

Love this resume?Build Your Own Now
SA
MASTER DATA SME-MANUFACTURING
Summary
  • 10+ Years of IT Experience in the Design, Development and Implementation of Data Warehouses, Databases, Reporting Tools and Various kinds of Operating systems using Informatica.
  • Extensive experience with ETL tools Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 10.x
  • Worked on the environment which follows Ralph Kimball's Methodologies.
  • Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
  • Excellent knowledge in Data warehouse software development life cycle and dimensional modeling, implementation of Star, Snowflake Schemas, Conforming Dimensions and extensively used Slowly Changing Dimensions.
  • Extensive Experience in data analysis of Source Systems and Warehouse systems.
  • Involved in Data modeling and developing Logical/Physical model.
  • Experienced in handling huge volumes of data with the target database.
  • Experience with Power Exchange in creating data maps & change data capture.
  • Extensive experience in design and development of ETL processes from Oracle, DB2, SQL Server, Flat files and XML sources.
  • Expertise in the QA process of ETL mappings like Functional and Integration testing.
  • Experience in carrying out Administration tasks, involved in day to day activities like Managing Users, Groups, Folders, Privileges & Deployment groups and regular maintenance of servers like bringing up the server, Shut down of servers.
  • Experience in developing universe .
  • Experience in debugging and Performance tuning of targets, sources, mappings, sessions and system
  • Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets, SQL scripts and triggers and PL/SQL stored procedures.
  • Developed test strategies and plans for the user acceptance testing.
  • Developed ETL migration procedures, production standards and best practices to be followed.
  • Strong analytical and conceptual skills in database design and development.
  • Experience in using scheduling tools AutoSys, Control-M to automate running of Informatica Workflows.
  • Worked on On-Call support and Production support.
  • Involved in Writing UNIX Shell scripts to automate various Processes.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
Skills
  • TOOLS/TECHNOLOGIES: Informatica Power Center: 10.2.1, Informatica BDM: 10.2.1, Informatica Data Quality: 10.2.1, Informatica ICS 10.2.1, Informatica Power Exchange: 10.2, JIRA, SAP Business Objects Enterprise XI 4.0, Tableau 10.2.1 , MS Office suite 2010, Project Server, QLIKVIEW, AWS, Salesforce, Big Data, Hadoop, Tivoli Work Scheduler (TWS),Quick Test Pro, Share Point, SOAP UI, SQL server, Service Manager, Visual Studio, Hadoop Distributed File System (HDFS) MobaXterm, Oxygen XML Editor 17.0 (64-bit), Ultra Edit Professional Text/HEX Editor 21.20.0.1014
  • SDLC: Agile (Scrum), Modified Waterfall, Waterfall
  • Data Modeling: Erwin
  • Databases: Oracle - OraClient12,Toad 12.10
  • Languages: SQL, PL/SQL, Perl 5
  • Agile
  • Big Data
  • Business Objects
  • Data Modeling
  • Databases
  • Edit
  • Editor
  • Erwin
  • XML
  • Informatica
  • Exchange
  • MS Office suite
  • Share Point
  • Enterprise
  • Oracle
  • PL/SQL
  • Perl 5
  • Quality
  • Quick
  • SAP
  • Scrum
  • SDLC
  • SOAP
  • SQL
  • SQL server
  • Tableau
  • Tivoli
  • Toad
  • Visual Studio
Experience
Iqvia Holdings Inc | El Monte , CAMaster Data SME-Manufacturing01/2017 - 06/2017
  • Developed the Audi Dailydoc
Volkswagen Group Of America | City , STATEMaster Data SME-Manufacturing 04/2015 - 01/2016

• Experience in designing and developing the VCI/Cloverleaf product workflows which Provides Subvention, Bonus Billing and LPA data loads into data warehouse.

Volkswagen Group Of America | City , STATEData Operations Specialist04/2011 - 04/2015

• Supporting the production support for Incident Management initiative.
• Resolve Production Issues and providing quick resolutions.
• Changing production support process in order to efficient provide resolution.
• Make sure that all the jobs are completed as per the SLA requirements
• Performance tuning of long running jobs.
• Worked as a Subject Matter Expertise (SME) on most of the Subject Areas and downstream Applications.
• Configured the MySQL ODBC connections from local environment to High Availability Environment.
• Worked with different processes of a project like Initiating, Planning, Executing, Monitoring & Controlling and Created the Conceptual Solution.
• Created the Design Documents (High Level, Technical Design) and Operational documents.
• Created the Detail Work Plan and Project Work Plan in order to coordinate concurrent development through different initiatives.
• Provided Weekly Activity Status reports to Leadership.
• Performed the Code Inspection/Review for the Coding developed by the ETL Developers to make sure the standards and the best practices are followed.
• Automated the processes from existing Manual processes.
• Analyzed the existing systems and made a Feasibility Study.
• Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
• Supporting the Informatica Administration activities involving creating and managing users, creating repositories, code migration from one environment to other etc.
• Debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Resolved performance issues by doing test runs and incorporating tuning measures like joining tables in database using pre-session SQL rather than Joiner, keeping the Filter as close as possible to the source, using unconnected lookup, optimized SQL overrides, increasing target commit intervals etc.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
• Used Tivoli to schedule the workflow process Performed Unit testing, string testing, regression testing, smoke testing and system integration testing.
• Create test cases and test the transformation/jobs.
• Developed Slowly Changing Dimension type I, II and III.
• Maintained naming standards and warehouse standards for future application development.
• Incorporated the Email feature to send Reports to the clients on job completion.
• Data Quality Analysis
• Scheduled and monitored job batches.
• Created documentation on the design, development, implementation, daily loads and process flow of the jobs.
• Translated high level design documents to low level ETL design documents.

Education and Training
MASTER OF SCIENCE INDUSTRIAL TECHNOLOGY2011
Indiana State University | | State, USABACHELOR OF MECHANICAL ENGINEERING2007
Jawaharlal Nehru Technological University | | City, India
Accomplishments
  • Master Data SME-Manufacturing - Michigan USA May 2015 - PRESENT.
  • Acted as subject matter expertise and supported different functional areas such as Vehicle, Sales, Warranty, Parts, Employee, sales Dashboard, Vendor extracts, and CarNet, Finance and Customer Compliance data.
  • Planned and created strategic roadmaps for various business units and conveyed this to leadership and technology teams.
  • Extensive experience with ETL tools Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center.
  • Involved in Data modeling and developing Logical/Physical model.
  • Extensive experience in design and development of ETL processes from Oracle, AWS, Salesforce, DB2, SQL Server, Flat files and XML sources.
  • Experienced in designed, development for the enterprise of data warehouse and Master Data Management ETL workflows and automated ETL workflows, business users can manage product content much more efficiently.
  • Conducted business requirements review sessions with application developers and created project plans and estimates.
  • Communicated timeframes to key stakeholders.
  • Analyze the source data and metadata using ETL tools to collaborate, identify data quality issues, and analyze data relationships.
  • Developed the workflows and processes, both internally and externally to create the product based on intuitive tasks and insightful dashboards.
  • Experience in collect the data from diverse data sources and perform profiling, cleansing, and matching for the data and build the business logic for the unstructured and semi-structured data and push the transformed data to the data warehouse/MDM/Big Data Management to perform business intelligence on a view of the data.
  • Experience in drill down on the inconsistent data to view results across the entire data set, discover sensitive data such as social security numbers and credit card numbers so that can mask the data for compliance.
  • Experience with Power Exchange in creating data maps & change data capture.
  • Experienced in creating the SAP BI universes for Sales objectives, Warranty parts, Chattanooga, Dealer Parts, Emission universes.
  • Created and documented test scripts in JIRA.
  • Coordinated and deployed release items to QA environment.
  • Experience in designing and developing the Parts Invoice product workflows of Dealer Management System (DMS).The Business view the data within the new universe.
  • Experience in designing and developing the VCI/Cloverleaf product workflows which Provides Subvention, Bonus Billing and LPA data loads into data warehouse.
  • Experience in designing and developing the Pace Objectives & Regional Forecasts workflows from converting multi tab excel to csv and generate the views for VW Sales Dashboard via Tableau.
  • Experience in designing and developing the Sales Objectives product workflows for Audi DailyDoc, modifying sale translation load to sale configuration to lookup on the carline code master data from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner etc.
  • The objectives in the universe are roll up to Brand, Port, and Nation, Region, Area, Dealer and Carline level.
  • Experience in-person business requirements gathering and estimating the service requests and projects.
  • Experience in designing and developing complex Chattanooga Finance mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union, Sequence Generator, Sorter, Rank, Normalizer etc.
  • Experience in designing and developing the AU/VW leads Product workflows in Data Lake Using Informatica BDM Developer.
  • Experience in designing and developing CarNet 2.0 Product workflows from AWS (Amazon Web Services) using Informatica ICS Developer into Data Lake Using Informatica BDM Developer for Enrollment report.
  • Experience in designing and developing CCPA Compliance Product workflows for data warehouse, Data Lake, and MDM.
  • As part of this calculate the Marketing Permissions to survive CCPA.
  • Experience in designing and developing "Customer Type" field (Lease, Retail, and Balloon) extract workflow, business users to append an AFS Flag (Yes/No) to records being used in Salesforce Marketing Cloud to send the first welcome email.
  • Experience in designing and developing the Warranty Parts Portal product which dealers can determine how to disposition parts they have removed from vehicles in support of warranty repairs.
  • The Warranty Parts Portal is a business critical to improve the customer satisfaction.
  • The solution provides the Audi /Volkswagen Warranty Parts Return Center to obtain the parts from the dealership to the requester of the parts.
  • Provided support for production issues and analyzed data through SQL to identify issues/gaps and came up with solutions for time sensitive issues.
  • Developed Slowly Changing Dimension type I, II and III.
  • Trained and certified in Tableau.
  • Data ops Specialist - Michigan USA, APR 2011 - APR 2015.
  • Supporting the production support for Incident Management initiative.
  • Resolve Production Issues and providing quick resolutions.
  • Changing production support process in order to efficient provide resolution.
  • Make sure that all the jobs are completed as per the SLA requirements.
  • Performance tuning of long running jobs.
  • Worked as a Subject Matter Expertise (SME) on most of the Subject Areas and downstream Applications.
  • Configured the MySQL ODBC connections from local environment to High Availability Environment.
  • Worked with different processes of a project like Initiating, Planning, Executing, Monitoring & Controlling and Created the Conceptual Solution.
  • Created the Design Documents (High Level, Technical Design) and Operational documents.
  • Created the Detail Work Plan and Project Work Plan in order to coordinate concurrent development through different initiatives.
  • Provided Weekly Activity Status reports to Leadership.
  • Performed the Code Inspection/Review for the Coding developed by the ETL Developers to make sure the standards and the best practices are followed.
  • Automated the processes from existing Manual processes.
  • Analyzed the existing systems and made a Feasibility Study.
  • Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.
  • Supporting the Informatica Administration activities involving creating and managing users, creating repositories, code migration from one environment to other etc.
  • Debugger to validate mappings and to gain troubleshooting information about data and error conditions.
  • Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
  • Resolved performance issues by doing test runs and incorporating tuning measures like joining tables in database using pre-session SQL rather than Joiner, keeping the Filter as close as possible to the source, using unconnected lookup, optimized SQL overrides, increasing target commit intervals etc.
  • Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
  • Used Tivoli to schedule the workflow process Performed Unit testing, string testing, regression testing, smoke testing and system integration testing.
  • Create test cases and test the transformation/jobs.
  • Developed Slowly Changing Dimension type I, II and III.
  • Maintained naming standards and warehouse standards for future application development.
  • Incorporated the Email feature to send Reports to the clients on job completion.
  • Data Quality Analysis.
  • Scheduled and monitored job batches.
  • Created documentation on the design, development, implementation, daily loads and process flow of the jobs.
  • Translated high level design documents to low level ETL design documents.
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

72Average
Resume Strength
  • Formatting
  • Word choice
  • Length
  • Measurable results
  • Strong summary
  • Typos

Resume Overview

School Attended

  • MASTER OF SCIENCE INDUSTRIAL TECHNOLOGY
  • Indiana State University
  • Jawaharlal Nehru Technological University

Job Titles Held:

  • Master Data SME-Manufacturing
  • Data Operations Specialist

Degrees


  • BACHELOR OF MECHANICAL ENGINEERING

Create a job alert for [job role title] at [location].

×

Advertisement

Similar Resumes

View All
Master-Data-Administrator-resume-sample

Master Data Administrator

Seneca Foods

Janesville , WI

Senior-IT-Analyst,-Master-Data-Management-resume-sample

Senior IT Analyst, Master Data Management

Livongo Health, Inc.

Kentucky , AR

IT-Applications-Analyst-II,-AVP-resume-sample

IT Applications Analyst II, AVP

Patelco Credit Union

Livermore , CA

  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Work Here
  • Contact Us
  • FAQs
  • Accessibility
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2022, Bold Limited. All rights reserved.