Dipesh Patil

Experience

• 

  EBorn Consulting Pvt. Ltd.

  Jan 2011 - Jul 2013

  Associate Analyst

  • BI experience includes Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting and Performance Tuning.• Extensively worked on designing/creating Info Objects, Info object Catalogs, Info cubes, DSO objects, Info Sets, MultiProviders, Application Component, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP).• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design, and Analysis of reports Using BExAnalyser.• Managed, analyzed, and configured SAP Sales & Distribution module for Software Company with annual sales of $68M. Provided technical support and follow-up to SAP user community to ensure timely and profitable use of ERP system.• Full Lifecycle CRM Service Implementation. Involved in Managing the project through Design, Build and Test Cycles for the CRM Sales and CRM Service Scenarios.• Created Transaction Types, Item Categories, Status Profiles, Date Profiles, and Text Profiles in SAP CRM for the various CRM Service Transactions. Also configured relevant Partner Determination Procedures and Organization Profiles. Configured the same in ECC-SD.• Configured transactions by defining transaction types, item categories, item category determination, and copy control for transaction types and item categories, pricing and assigning various profiles to the transaction types.• Designed, tested, and implemented Suzlon S3 System, directly reducing the SLA and transportation costs• Collaborated with Project Managers, Executives, Developers, end-users, and SMEs on scope• Created/maintained material consumption, billing and revenue forecast reports and provided training, support, and assistance in using and understanding the data received. Show less

• 

  Atos

  Jul 2013 - Jul 2015

  Analyst

  • Responsible for implementation of Marketing, Service, and Sales business processes including finance and controlling integration.• Efficiently worked on Excel, power point, SAS, SAP WebI, BI/BW, PowerBI, and MSBI for reporting purposes• Worked Extensively on ABAP Objects, Object Oriented ABAP.• Implementation & Support for Sales, Marketing, Coupon Management, Integration with ECC and third-party software’s for Sales and Marketing.• Technical expertise in ABAP/4 workbench, CRM Web UI, BSP’s, BADI’s, BAPI’s, Workflow, Web Services, AET, BOL programming, developing custom reports, ABAP OOPs, User Exits, ALV Reports, Classic reports, Enhancements, SAP Scripts, RFC’s and Function Modules, Triggers.• Expertise in CRM 2007/7.0 EHP1 Web UI enhancements• Added new custom field in standard view (BSP page) by enhancing CRM WEB UI standard components and context nodes.• Extensive development and implementation experience in Business Partner, Master Data and Transactions, CRM Archiving and Overall CRM System performance.• Experience in Debugging, SQL Trace, Performance Analysis and ABAP Runtime Analysis.• Migrated data from legacy system to SAP system through SAP ABAP• Mapped business processes to SAP functionalities, generated numerous reports in SAP using SQL queries• Provided advice to business SME’s to analyze, design and deliver SAP functionalities• Configured various CRM Transaction Types, Item Categories, Item Category Determination, and Text profile, Address Profile, Status Profiles and Date Profiles for various CRM Sales Orders.• Assisted in developing new workflows and defining new procedures as needed• Responsible for development and maintenance of the project plan through MS Project, determining client requirements, monitoring progress, reporting status, resolving problems, and establishing controls to maintain the quality of the deliverables and minimized disruption to the project schedule Show less

• 

  Northern Illinois University

  Jan 2016 - May 2016

  Graduate Research Assistant

  Assisted Dr. Andrew Setterstrom from NIU’s College of Business in his research topic - “IT pollutionAbatement Strategies: An Empirical Investigation of Strategic Alignment and Project ManagementPractices”. Developed different assessment methodologies. Assessed undergraduate ERP assignments.

• 

  Parent Petroleum

  Aug 2016 - Dec 2016

  Business Consultant

  Responsibilities included:o Configuring Dynamics CRM to create a new entities and relationships for station management.o Creation of new business processes, master data management to manage products, gas stations, terminals,haulers, accounts, and contacts.o Project management included business case, team charter, communications plan, risk assessment andproject plan through MS project.o Data migration through SSIS and SharePoint integration with Dynamics CRM. Representing tech lead andsingle point of contact between client and NIU. Show less

• 

  Santander Bank, N.A.

  Jul 2017 - May 2021

  Data Quality Lead

  • Working on data profiling and data quality analysis using IDQ tool.• Doing data profiling for identified data sets and providing initial validation, testing, and post-production validation for all implemented Data quality rules.• Experience in Data Quality rule implementation, change, and report testing• Involved in creating Business rules and Technical rule.• Extensively worked on creating profiles using Informatica developer tool and Analyst tool.• Data mapping experience - mapping data sources to and from multiple applications• Extensive knowledge on IDQ metadata Repository.• Extracted various information of all IDQ entities from IDQ Metadata Repository Database.• Created complex SQL queries to validate whether the business rules are working as expected.• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions.• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.• Strong Oracle Database technical knowledge in the areas of general SQL and PL/SQL.• Extensively used Informatica Data Quality transformations – Labeler, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.• Providing recommendations for modification or creation of business rules based on data results.• Good knowledge on Informatica Data Services (IDS) Informatica Analyst and Informatica Developer.• Applied the rules and profiled the source and target table's data using IDQ.• Part of the team in upgrading Informatica version from 9.6.1 to 10.2• Production support and remediation of issues during user acceptance testing.• Developed the mappings, applied rules and transformation logic as per the source and target system requirements. Show less

• 

  Hudson's Bay

  Jun 2021 - Feb 2022

  Lead Informatica Analyst
• 

  Saks OFF 5TH

  Feb 2022 - Jun 2022

  Lead Informatica Analyst
• 

  Home Trust Company

  Jun 2022 - now

  Senior Data Quality Analyst