SUMMARY

• Total 5 years of IT experience with 3+ years of experience as Data quality analyst and master data management (MDM) business analyst
• Worked as a Data analyst and MDM business analyst for ERP and Master data management (MDM) implementation projects
• Understanding of Waterfall and Agile implementation
• Expertise with different sets of data across different line of business (ecommerce, Food Industry, and CPG)
• Worked with business owners and category managers to define data governance standards and policies ensuring data integrity is maintained
• Conducted requirement workshops with cross functional teams to analyze data pain points (duplicates, inconsistency, inaccurate, invalid, nonstandard, missing information) and provide solutions and recommendations improving data quality
• Extensively used excel for generating reports using pivot table, built in functions, dashboard, charts and graphs
• Documented data mapping sheets with upstream and downstream table - column relationships and transformational logic
• Experience with data modelling involves creation of domain, relational and reference master and defining their structure
• Have experience working with ETL and data quality tools for data profiling, cleansing, standardization, validation and enrichment activities
• Provided trainings, facilitated meetings, prepared functional documents, and reported stakeholders for project status
• Responsible for creation, maintenance and migration of information as per the requirements
• Strong analytical and problem solving skills
• Have interest reading latest trends and technology including Data management, Marketing automation, Data analysis, Data Visualization, Reporting, Big data, Social media etc.
• 2+ years of work experience in application development and support projects

TECHNICAL SKILLS

• SAP BODS data objects 4.2 (ETL)
• Vin MDM 3.x
• SQL
• PLSQL
• UNIX
• SAP business one Hana ERP
• Shell Scripting
• Oracle database
• Toad
• CVS (version control)
• MS Excel
• MS Outlook
• MS PowerPoint
• MS Word
• Data Mining
• Data Cleansing

PROFESSIONAL EXPERIENCE

Confidential

Data Migration Analyst / Data Quality Analyst

Responsibilities:

• Worked with business users to understand the data migration requirements and documented the business rules in the data quality document
• Used SAP BODS (business objects) for ETL, data cleansing, validation and enrichment activities
• Created data stores to connect to different systems
• Worked on repository, job server, access server, and management console.
• Created jobs, work flows, data flows and scripts to pull data from the different databases and load the data into target database
• Executed data profiler jobs and analyzing results to gain insight into source data to access data quality for projects
• Reused workflows and data flows to run ETL process
• Worked on various data integrator, data quality, data platform transformation.
• Performed query transformation, XML map and XML pipeline converting XML data to flat file format
• Validated jobs and resolved error in case of a job failure
• Used data management console for documentation, data validation, impact and lineage analysis and generating data quality reports
• Performed data validation checks and corrected the same ensuring mandatory and standard formats are maintained
• Provide the business and IT users with the pre-load and post validation reports after validation on source data and transformation
• Used data quality transformations like match and merge for de duplicating master data
• Improved performance by emphasizing operations like joins, aggregate and lookup functions using SQL
• Tested data flows and scripts against sample data and real data

Confidential

MDM Business Analyst

Responsibilities:

• Conducted requirement workshops gathering workflow implementation requirements and documenting the same in business requirement document
• Documented business requirement with as is and to be scenario
• Analyzed data using ETL tool and created data profiling and mapping documents
• Performed data profiling and cleansing activity using SAP BODS tool
• Defined Validation rules in MDM system by analyzing excel sheet part master data and input from the business users
• Configured workflow rules as per the process of gathering part master information from various department with stages of approvals
• Involved in activities ensuring data quality improvement, use of standard definitions and business terms
• Defined and configured service level agreement (SLA) for stakeholders involved in creating and maintaining master information
• Defined business glossary with inputs from business owner and cross functional teams
• Involved in master data mapping and data system integration activities
• Created test plans and tested functionality in MDM should be as per the business requirement document
• Provided training to business user.

Confidential

MDM Business Analyst

Responsibilities:

• Worked with business partners/stakeholders to define data governance standards, policies ensuring data quality, integrity and consistency
• Conducted requirement workshops with business and IT, identified configuration and customization requirements and documented the same in functional document
• Prepared functional document with AS IS and TO BE scenario
• Worked with development team communicating specifications, acceptance criteria and ensuring deliverables
• Involved in defining activities, status reports, delegating activities to the team, and managing stakeholders
• Analyzed product master information existing in content management system to find out issues (duplicate, unstructured, missing, inaccurate, inconsistent information, incorrect classification, missing standards) with their master information
• Compared product information pattern with different market place having same line of business and suggested ways to improve data quality
• Have experience working with large data sets
• Worked with business owners to define service level agreement, business glossary and standard definitions
• Used data services tool for data cleansing, data enrichment and de duplication (using merge and match logic) activities
• Maintained reference master such as color, size, country, currency etc. for users to look up for standard values to be entered avoiding incorrect entry
• Configured MDM system includes configuring data model, hierarchy, business rules, workflow rules, process model, and UI model
• Involved in data modelling includes table definition (Including domain, reference and relational master) and types of values to be defined for the tables
• Created product hierarchy and configured business rules as per the hierarchy
• Worked extensively in documenting Source to Target Mapping documents with data transformation logic
• Identified opportunities for business process improvement, including changes / enhancement
• Prepared test plans and tested functionality and communicated for any issues / defects to the development team
• Provided training to the business users and data stewards
• Prepared Training/ User Manual document

Confidential

Application Support Analyst

Responsibilities:

• Successfully completed the transition of the Applications from Confidential &T to Confidential in one month of time
• Led a 4-member team for the transition and production support phase of the project
• Provided support post transition including daily checking of logs, monitoring the application, resolving issues related to bugs, configuration management and creating change request.
• Verified session logs to identify the errors occurred during the ETL execution
• Extensively worked on debugging packages, procedures, functions and triggers
• Worked with data validation, constraints, record counts, and source to target, row counts, and error processing
• Performed testing based on change requests and defects resolved.
• Identified enhancement/improvement opportunity and acquired approvals from senior management for enhancement implementation
• Involved in extensive data validation using SQL queries
• Responsible for ensuring all the services are delivered per the customer SLAs.
• Applied understanding of SQL and UNIX to resolve the issues and implement the change in the code.
• Reported senior management for weekly status update
• Conducted daily meetings with the team members to discuss the status of open tickets which led to the improvement in efficiency of resolving issues by 50%.

Confidential

Senior System Engineer

Responsibilities:

• Analyzed the business requirement and created high level design documents to provide business solution to the client.
• Involved in developing software for maintaining master and transaction information of Confidential Canada dealers
• Created entity relationships diagram for storing dealers basic and other information related such as Contacts, Stores, Location, type of business and services provided etc.
• Developed code in PL/SQL and Unix Shell scripting for ETL process and hence extracting data from up streams, transforming and sending it to downstream systems.
• Developed unit test cases which led to reduction in defects by 40% in the early phase.
• Optimized existing code leading to reduction in the process run time by 4 hours.
• Spearheaded the automation of testing of daily modules which eventually saved 2 man days per month.
• Mentored and Trained team members.