EXPERIENCE OVERVIEW:

Clients interaction to understand requirements, expectations, estimations of an application also to create, configure, define & manage master data business applications.

SUMMARY:

• Offering a proven track record of supporting and influencing positive outcomes in business units and companies throughout the industry through the application of cutting - edge tools and creation of detailed, production-level technical specifications, as well as intuitive conceptual, logical, relational and physical data models.
• Adapt in delivering project requests ahead of schedule working with database architects to maintain the efficiency of the database and utilizing a wide variety of database support tools.
• Specializes in data migration and master database management.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administering, security management and Production support
• Excellent in complying with business standards and procedures and working for the improvement of data standards and their quality.
• Perform data analysis, cleansing, correction, & master data count, using ETL tools.
• Assist and part of Data Architecture team to develop standards for data flow in the MDM system.
• Excellent written and verbal communication skills and consistent academic performance.
• Effective self-management and balancing of priorities. Good command of analytical thinking and problem solver.
• Proficient in SQL, MDM, MM, Customer Master, SAP, SAP HANA, SAP BI ETL.

TECHNICAL SKILLS:

SAP: MDM, Material Master, Customer Master, IFS ERP, Salesforce, ALM, Agile Manager, Tidal Scheduling

Back Office Associates: cMass data migration tool, Data Dialysis passive reporting tool, Cransoft and cConfig security

Databases: MS Access, MSSQL Server 2005, MSSQL Server 2008 & 2012 Management Studio, Unix server, SAP HANA

Language: SQL Intermediate

ETL Tool: AltovaSpy, Data Stage, IDOC, Informatica ETL

Design Tools: Microsoft Visio

Operating Systems: SAP HANA 2.0 Confidential training, BIBW 7.0, Windows 7, Windows 8.1

WORK EXPERIENCE:

Confidential

BI/SAP HANA Admin

Responsibilities:

• Proven achievements in providing hands-on guidance with SAP BW /BI, SAP HANA and other software applications deployment.
• Strong Knowledge and expertise in SAP HANA, SAP BW 3.5, SAP BI/BW 7.x.
• Knowledge in SAP HANA implementation, SAP System Landscape transformation (SLT), SAP HANA data modeling using Attribute View, Analytic View and Calculation Views. Knowledge in using SAP BODS.
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables in SAP HANA studio.
• Involved in design, development of tables, forms, reports, data ports, code units and xml ports debugging/error fixing, testing of completed tasks, Merging, Upgrades and deployment of the whole solution in Microsoft ERP.

Confidential

MDM Developer Analyst

Responsibilities:

• Configured and maintained Confidential STEP PIM database needed to support multiple business areas for product master data and provide system support
• Coordinated data mapping and data translation activities for PIM, working to increase accuracy
• Designed, developed, and implemented data structures, data tools, and dashboards
• Worked closely with multiple IT teams and business teams within the company
• Documented and maintained database structures and defined data elements to enabled re-use of data
• Created ongoing and ad hoc reports with appropriate metadata and quality information
• Performed audits on key data elements to ensure data integrity
• Assisted with maintenance of mapping documentation
• Front line troubleshooting for internal and external PIM system users and stakeholders
• Conducted tested plans for validation of data mapping
• Produced analysis and designed of product data-centric solutions
• SQL server 2014 VS, Confidential STEP, Excel

Confidential

SAP MM Master Data Specialist

Responsibilities:

• Served as a SME for maintenance of material master data utilizing Global Data Management standards and guidelines to ensure high degree of data accuracy, consistency, and completeness.
• Acted as a liaison between the end user and the business to deliver quality master records in a timely manner.
• Prepared monthly metrics to main stakeholders, addressing any issues on timely delivery, quality concerns or special projects that will result in monthly volume increase.
• Reviewed & Lead special projects additional to regular material master volume and determine the amount of resources and all data aspects required for proper data migration in conjunction with the business.
• Worked closely with other business teams like Supply Chain and Finance to address and resolve master data issues.
• Participated in data governance and data quality/cleansing activities to ensure data accuracy and completeness.
• Created, assessed & executed load files for mass loads to the global data management system and SAP MM modules and do any validations required.
• Used SAP MM module to review data, extract reports and analyses records for data consistency and continuous improvement initiatives.
• Created training materials and provided proper training and guidance to offshore team and end users as required.

Confidential

ITMDM Consultant

Responsibilities:

• Designed, implemented & Tested user cases in the ALM for SIT/UAT - System Integration/User Acceptance Testing.
• Worked with Offshore team of developers to help with issues in production, application and user security.
• Created passive reports for ITMDM team in SQL to help business users for the data integrity validation.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Consulted off shores team of 3 members for application development, testing and configuration analysis.

Confidential

ERP Customer Master/Master Data Manager

Responsibilities:

• Defined, Designed and implemented on a small manual scale an automated MDM business process workflow in the customer domain.
• Worked closely with the business user like Finance, Treasury & Sales/Marketing teams to follow the designed workflow to create master data.
• Gathered requirements in enhancing IFS/ERP functionality to accommodate the business needs with invoicing/ordering process.
• Demonstrated workflow for the ongoing MDM customer master process.
• Assisted staff in trouble shooting technical issues with the orders, invoicing, & reporting
• Worked on building a precise workflow to determine the MDM customer master implementation process.
• Created and maintained Parent/Child hierarchy based on the data received monthly from Treasury.
• Primarily worked on data cleansing, data profiling and data quality check on the existing customers in IFS.
• Created, and updated new/existing customers upon request from business user communities in IFS.
• Configured, tested an automated email invoice functionality to help AP Finance/Operation.

Confidential

SAP MDM MM/Customer Master Assessment Specialist

Responsibilities:

• Delivered Key factors to captured As Is process maps at L4 level, Data flow maps, CTQ Tree, Risk assessment.
• Identified break-points and Challenges and Pain points.
• Analyzed Gaps, baseline/benchmark Confidential MDM performance with Market trends.
• Performed Root Cause Analysis to understand causes of Issues being identified in Discovery process using the data and process flows.
• Suggested solutions/opportunities- prioritize using a 9Blocker.
• Built implementation roadmap with a help of a business case.

Confidential

SAP MDM MM Business Process Analyst

Responsibilities:

• Monitored all Master Data workflows and processes for Variety/Material management in North America and ensured continuous improvements.
• Monitored Variety/Material master data quality in NA and related SAP systems to suggest and perform adequate quality improvement actions.
• Supported the implementation of global master data guidelines, policies and standards in NA.
• Defined the business requirements for data quality report and communicated to technical owners to develop and improve reports.
• Proactively identified data integrity and quality issues, in conjunction with other IBM infosphere MDM BPAs and develop improvement actions.
• Ensured business needs are reflected within master data environment with a proper process and working documentation.
• Implemented training for business workflow users and MDM staff.
• Lead off shores Cap Gemini team of 4 members for business process workflow implementation.

Confidential

SAP MDM Data Analyst

Responsibilities:

• Interacted with the business users, source system owners, and project team members to gather requirements to write custom report for passive data governance validation process in SQL Management Studio 2008.
• Executed Data Load Templates of MM, Customer Master Data and LSMW Load Scripts to execute the Load within SAP environment.
• Executed valid Data Quality Business Rules within BOA Data Dialysis tool to deliver Data Quality Validation Reporting capabilities, Added user accounts for cMass, Customer, Material, and Vendor modules.
• Supported, designed and built of necessary template to load Master Data and Transactional Master Data into SAP.
• Helped team in SAP implementation cycle until Go-Live, support and trouble shoot user’s security access issues.
• Wrote SAP passive data governance reports to validate Taxes based on material and customer master data.
• Worked with data warehousing team to pull data for the statistical analysis.

Confidential

CRM Functional Analyst

Responsibilities:

• Interacted with the business, source system owners, and project team members to gather requirements.
• For service operations, conducted & coordinated business analysis with business functional lead to defined definition document and developed business process flow diagrams which are input to Functional Specs.
• Interacted with configuration and PI Team Leads to help understand the business solution design and implementation of the project.
• Gained knowledge of existing legacy system to help improve designing SAP CRM environment.
• Authored functional business specification and technical design documents.

Confidential

SAP IBM infosphere Master Data Management Analyst

Responsibilities:

• Participated to discuss IBM infosphere MDM Implementation architecture, MDM style and best practices for MDM management process and tools.
• Reviewed SAP Production support issue raised by SAP support team to carry out deep support function across multiple SAP components.
• Installed MDM Server and Clients Software components including Syndicator, Console, Import Manager, Import Server and Data Manager.
• Involved in managing the Customer repository using the IBM infosphere MDM Console including operations such as loading, archiving.
• Directed ongoing master data maintenance activities adhering to governance guidelines.
• Conducted technical archiving requirements and needs across modules.

Confidential

Technology Specialist

Responsibilities:

• Guarded analytic needs of a business unit by analyzing web traffic using clickstream tools such as Click Tracks, Omniture etc.
• Applied standard BI tools, such as Crystal Report or Business Objects, to produce reports related business outcomes.
• Created holistic dashboards by pulling data from different data sources and websites for presentations to senior management team.
• Collaborated with external partners such as Interactive Agencies to assist with data collection and reporting.
• Supervised development of SQL-queries/procedures for database and backend testing.
• Managed, configured and altered queries on SQL Server 2008.

Confidential

EDI Analyst

Responsibilities:

• Managed corporate wide EDI (Electronic Data Interchange) activity including billing of all large Enterprise customers. Performed EDI production 1st level support to Trading partners and customers.
• Updated mapping functions as necessary to meet EDI X12 standards by ANSI CODE. Primary focus was day to day administration of EDI operations as well as increasing the use of HIPAA Standard EDI Transactions.
• Responsible for maintaining and monitoring of Trading Partner profile and communication mode information.
• Served as an expert on EDI and ensure that the client is in compliance with all applicable HIPAA and CPNI standards related to EDI. Coordinated testing plans with vendors. JCL missing EDI files to the customer. Prioritized, researched, tracked, and resolved EDI related issues with IT support and production team on escalations.