Team Lead Resume
5.00/5 (Submit Your Rating)
SUMMARY:
- Expertise in SAP technologies - Confidential, BO, Information Steward with SAP Data Migration, Data Warehousing and Data Quality in past 12 years and leading team since past 5 years.
- Have worked with leading technology service providers like Confidential and with High-Value clients like, Carrier
- Confidential ( Confidential Celebrates Excellence) twice for multiple clients for cost saving through Automation - 2012 and 2013.
- Client recognition for developing User Interface in MS Excel for sales reps - 2007.
TECHNICAL SKILLS:
- SAP Business Objects Data Services, Information Steward, SAP HANA modeling, SAP Business Objects BI, SAP ECC
- Informatica
- SQL Server 2012, Oracle 11g
- MS office applications(Excel, Word, PowerPoint)
WORK EXPERIENCE:
Confidential
Consultant/ SAP/DW
Responsibilities:
- Develop transformation job for Confidential to SAP data Migration.
- Support data analyst to create mapping for extraction of Confidential data for different SAP Confidential objects like Pricing, Customer Contracts, Chargebacks and more.
- Lead and support development process done from offshore.
- Plan and design Data cleansing approach for Customer Master Data using BOIS and Confidential DQ.
- Develop cleansing Package and IS rules in BO Information steward, Develop Confidential Job, Create Confidential and WEBI reports.
- Created data models on SAP HANA SP8.
- Upgrade to SAP Confidential to 4.2 and Perform Job Migration.
Confidential
Team Lead
Responsibilities:
- Create Technical Design documents for different Confidential objects Customer Master, Material Master and more, for Migration to SAP.
- Support conversion mapping from Confidential to SAP including but not limited to Customer and Material master.
- Develop Jobs to migrate data from Confidential to SAP systems.
- Optimize existing Jobs to perform faster transformation of data.
- Technical Team Lead in multiple projects. Max team size handled is of 15 members.
- Installation of SAP Confidential 4.2 on Windows server, creation of repositories and managing users and admin activity in CMC.
- Worked with business on Conceptual Data modeling and transform to Logical and Physical model.
- Use DQ tools for Implementation of Deduplication using Match/Associate and Data cleansing using Address, Data cleanse transform etc.
- Extract data from various sources like SQL, ORACLE, Flat files, XML, SAP ECC.
- Support existing Confidential daily scheduled data warehouse jobs and address any data issues reported.
- Create Real-Time Confidential jobs to extract data from xml and load to Datamart.
- Use SAP TCODEs for data Analysis to support Confidential development process. Load data in SAP using LSMW methods like BDC, Batch input, iDoc.
- Created Attribute, Analytic and Calculation views in SAP HANA.
- Create sessions, workflows in Informatica and troubleshoot production jobs.
- Modify existing Business Objects Universe as required for business needs.
- Create new and modify existing WEBI reports.
- Optimize Universes by resolving join problems, setting up aggregate awareness, defining hierarchies, Confidential Confidential, @Functions and more.
- Used Alerts, Variables, Prompts, and also generated hyperlink reports using WEBI.
Confidential .
Analyst Programmer
Responsibilities:
- Created Documents on SAP Confidential, organized several sessions on SAP Confidential .
- Created mapping documents to outline data flow from sources to targets.
- Created sessions, configured workflows Informatica to extract data from various sources, transformed data, and loading into data warehouse.
Confidential
Asst. Manager
Responsibilities:
- Support creation of Data Mart using standard Data model design.
- Developing SAP BODI ETL jobs for loading data to the Data Mart.
- Develop BO WEBI reports using Drill Down, Graphs, complex filters, prompts, sub queries and free hand SQL.
- Create Confidential on SQL Server Data source.
- Utilized Calculation contexts for several WEBI reports.
- Defined Derived Tables, Aliases, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins and Contexts in Universe.
- POCs for new Product Management/Analysts requirements.
- Analysis of DW and different live databases for implementation of reports
- Providing end to end solution on the productivity reports through analysis required by management.
- Close co-ordination with Product Team Functional requirement gathering.
- Working with IT vendors to reduce SLAs by automating the reports using Confidential
Confidential
Analyst
Responsibilities:
- Preparing the Confidential job for loading data to server.
- Maintaining Excel based tools on the intranet of Confidential which are designed using Confidential and helpful to Sales representatives to get quick access to top selling
- Analyzing revenues generated by Confidential on Confidential .Com using SQL queries.
- Allocating appropriate Product category to new and existing Confidential on the website to ensure better penetration of desired customers