Experience

Enercare Inc.

• Canada
• Consumer Services
• 400 - 500 Employee

• —

  • Feb 2019 - Present

  - SAP & Salesforce Implementation Project for Enercare Utilities - Data migration from multiple Legacy Systems to SAP using LTMC - Successfully implemented the migration of Corporate vendors into SAP - Working for Home Service Business to migrate into SAP and integrate with Salesforce CRM using Cozyroc Plugin / Bulk API - SAP & Salesforce Implementation Project for Enercare Utilities - Data migration from multiple Legacy Systems to SAP using LTMC - Successfully implemented the migration of Corporate vendors into SAP - Working for Home Service Business to migrate into SAP and integrate with Salesforce CRM using Cozyroc Plugin / Bulk API



Wipro

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Business Data Analyst

  • Aug 2015 - Jul 2017

  Created a new Datamart to bring the data from multiple source systems into a consolidated repository,which will transform the data according to New York State (NYS) Regulators to audit the CMS (Customer Meter service ) data by creating Reports with single layout for all the regions - Upstate & downstate .This solution avoids the existing 64 audit findings resulting in approx 1.3 M$·Interfacing with clients on regular basis to gain understanding of requirements/processes through meetings and discussions ·Interpreting business rules and requirements captured in Bus requirement document into Functional documents·Designing the data model to accommodate the data from different source system and to create new data mart for staging data·Deep dive and understand each system and create the source to target mapping sheet for each of auditor's report·Designing the SAP BO universe to create the predefined reports for auditors·Identifying the environment , compatibility of software,skills and resources needed to implement the flexible solution·Facilitated End user testing and planned post deployment activities

• Business Analyst & Module Lead

  • Aug 2014 - Jul 2015

  Deployment of a Data Quality tool – SAP Information Steward to address the master data profiling and quality assessment and monitoring for HR, Finance, Fleet and SCM streams of National Grid,USA • Created the business requirements for SCM , Fleet data quality and master data management• Analyze and Review, functional requirements captured into master data management Functional Specifications• Interprets business rules and requirements captured in master data Functional Specifications• Created the rules by writing sql scripts, profiling Tasks and generated Score Cards in SAP Information Steward tool• Defined the process for review and delivery of master data management documents• Assist the project manager in identifying the skills and resources needed to implement the master data management solution• Prepared test scenarios & test scripts of master data management for multiple cycles• Assist data governance team to plan the data quality activities and maintain the inter dependency among data Objects

• Tech Lead

  • Aug 2013 - Aug 2014

  Implemented the Data Warehouse/Data Mart with Business Intelligence infrastructure as a solution which allowed National grid ECoE (Estimating Center of Excellence) team to use historical trend analysis, financial controls to provide better reporting and, consequentially, achieving the target of cost estimation within+/-10% of actual construction project costs not only in Upstate NY, but also in the NE region preventing $2M fines imposed by NY PSC• Reviewing and finalizing the requirement • Created the cleansing rules to clean the data directly in Source system• Created the functional specs for each of the report based on technical feasibility • Designed the new DataMart in the BI/BW environment & to finalize all the queries required for reporting• Worked with the team to design the IDT Universe for adhoc reporting• Accountable for all deliverable of this project including documentation like design doc, test plan doc, test cases, LTM,CDM etc.• Implemented test protocols, review the test cases , to support business users during UAT

• Senior Developer & Module Lead

  • Nov 2011 - Jul 2013

  Was responsible for the SAP data migration for US Foundation program which aims to consolidate onto a single SAP platform from diff legacy system for all the areas like finance,supplychain and human resources.• Migrated the SCM data from PeopleSoft & Oracle legacy system into SAP ECC & SRM• created rules for Data Profiling and Data Quality requirements• defined cleansing rules and help in tracking cleansing progress• Worked on defect analysis and provide solution to Business Support for testing and implementation• Involved in the data analysis and prepared the Source to Target Mapping sheets.• Loaded data into SAP directly using BODS Idocs• Involved in designing the Technical Reconciliation job to reconcile the record counts at every stage (Legacy, Extract, Transformation and Enrich) during migration.• Conducted Training Sessions on Design/Data Migration Approach to the new members• Prepared templates like Naming Conventions, Code Review Checklists, Release Notes, and Code Execution Documents.• Involved in the Code Promotion and Packaging Activities from Development Region to QA

• Team Lead

  • Jan 2011 - Nov 2011

  It's an infrastructure project. Wipro supported the migration of all GIF related infrastructure from the IBM Hosting environment in Atlanta, GA and Raleigh, NC to the new IBM Hosting locations - Poughkeepsie (Pok) and NewRaleigh• Documented the setup of existing environment• Provided the instructions to hosting team for server building• Validated the hardware after server built• Set up the base installation for all the technologies like SRE, JCaps, ALSB, Tumbleweed etc.• Prepared & performed the testing on the validation of software installed in the servers• Created new set of Unix, Service IDs for each of the servers• Implemented the Firewall rules, DNS and VIP rules• Design & Planning of project migration from old server to new with external vendors and clients• Prepared test cases for Pre & Post migration testing• Co-ordinated with client along with the vendors while end to end testing• Maintained all documentations in the repository for reference

• Developer & TEAM LEAD

  • Mar 2010 - Dec 2010

  Designed and developed a generic framework in Java CAPS for managing file transfers between local and remote systems using secured file transfer protocol. The actual intent of the framework is to help integration projects to completely reuse the framework without writing the code and implementing them in their projects· Developed the interfaces in Java Caps· Created and Reviewed the Test cases and the Results, Provide technical support for the Project full life cycle till production deployment· Mentored the freshers in middleware tool - Seebeyond ICAN · Performed Integration of data with downstream system through Datastage – ETLs

• Senior Software Developer

  • Jun 2007 - Dec 2010

  General Motors (GM)- the world's largest automaker implemented the new Global Warranty System - a common system in multiple releases based on geography to processes and governance the rapid and continuous product improvement instead of using 13 different system• Development of the interfaces in ICAN & Jobs in Datastage.• Documentation of the requirement, design, queries, test cases and changes.• Performed proof of concepts on technically challenging areas like IDOC file reading,Automation• Performance tuning of interfaces and Database queries• Prepared the Document Guide, list of Cut Over activies before Go-Live