Sankalp Kumar Nayak

 SANKALP KUMAR NAYAK e-mail:- Phone:- Passport: H- Company Experience Company No. Duration Organization Designation 1 23rd July till 15th December 2017 SEMTECH Corporation SAP Analytics Consultant 2 20th May 2013 to 21st July 2015 Computer Science Corporation(CSC) Programmer Analyst 3 1st Aug 2010 to 13 May 2013 Tata Consultancy Services (TCS) System Engineer Experience Summary An IT professional having 10 years of Business Intelligence & Analytics experience. Experienced in BI and Trans-analytical tools such as SAP HANA, SAP BW4HANA, SAP BW, SAP BODS Experienced in Visualization tools such as Tableau, Power BI, DOMO, SAP BO & SAP BO Cloud. Experienced on 6 SAP BW Implementation Projects with hyper care support, 2 Tableau projects, 4 SAP BO projects. Worked on implementation projects, support, upgradation & rollout projects. Tableau Skills Creation of dashboards & storyboards from different sources, calculated fields, mapping and hierarchies, created quick filters, creation of dual axis bar charts with multiple measures, good knowledge of joins. Worked on different graphs and charts according to user requirements. Expertise knowledge on Labeling & annotations, data blending, data extract, publishing & re-using data sources, applying use as filter actions, quick filtering, hierarchies, conditional formatting, groups the rows and Title and Caption. Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and assignment of content access through permission rules. Personal Skills Capable of working independently with minimum supervision as well as in a team. Highly motivated, eager to learn and take on greater responsibility. Ability to take and give directions/instructions and provide assistance through completion of task. Good analytical skills supported with Strong communication, presentation, team player and team leader skills experienced with conventional and ASAP methodology, highly motivated, goal oriented team player with systematic approach and ability to work effectively in fast paced environments, along with configuration and application knowledge. Academic Details Degree Course Name of Institution Year Percentage obtained (in %) B. Tech Information Technology Kalinga Institute of Information Technology 2010 75 XII Science B.J.B Autonomous College 2006 76 X ICSE V.E.M School 2004 89 Technical Summary SKILLS TOOLS Data Warehousing SAP HANA, SAP BW/4 HANA, SAP BW 7.5 Powered by HANA, SAP BW 7.4 Powered by HANA, SAP BW 7.3 , BI 7.0, BW 3.5 Reporting/Analytics Tableau, SAP Query Designer(BEx), Webi, Design Studio , Analysis for Office, IDT , Lumira , BO Cloud Analytics, Power BI Source systems ECC(Oracle DB) , ECC(On HANA), APO, EIS & Flat file, text files & excel. Other Skills SKILLS TOOLS Programming Languages ABAP,C#,R Database(s) HANA Other Tool(s) QTP/UFT, Unity , RPA Work Experience Project Summary Project No. Duration E2E Implementation Organization Client 1 23rd July 2015 to 15th Dec 2017 Semtech Internal Business Reporting Semtech India Semtech Description: Semtech is a semi-conductor production company which has its units in 28 different countries. It uses SAP HANA & BW/BO reports for making business decisions, planning and forecasting. Responsibilities: Requirement gathering, requirement analysis, gap analysis, prototyping, design & development and testing Complete flow design from ECC to BW and the report development using SAP BO Complete flow design from APO to BW and the report development using SAP BO Leading a 3 member SAP BW team. Management of all the SAP BW projects that is assigned to the team. Performance tuning of BW flows and maintenance activities. Project Summary Project No. Duration E2E Implementation Organization Client 1 20th May 2013 to 23rd July 2015 AB InBev Implementation Computer Science Corporation(CSC) Anheuser-Busch InBev Description: Anheuser-Busch InBev is the leading global brewer. AB InBev's brand portfolio includes highly popular beer and soft drinks brands. Anheuser-Busch InBev improved demand forecast accuracy and reduced supply chain costs with a complete implementation of SAP Advanced Planning and Optimization (SAP APO) functionality for demand planning (DP) and supply network planning (SNP).  Responsibilities: Designed Technical Specifications Documents for ABIn Bev Reports Created write optimized DSO , Standard DSO , Info cube, Multi Provider & multiple Bex Report for ABIn Bev. Also created SPO(Semantic Partitioning Objects) Created custom APO BW data sources and replicated those in external BW side , experienced in creation of data source from tables/views and function module . Written start routine, field level routine, end routine, expert routine, Info package level ABAP routine(for automatically capturing selection values for the fields). Written customer exits for reporting variables and OLAP variables. Creation and maintenance of Info Spokes for sending the data from BW to Data stage Designed and developed process chains (RSPC) for master and transaction data loads with the help of Info packages. Worked on performance improvement tools such as aggregates, BI statistics and compression . Designed complex queries which involved CKF’s, RKF’s, formulae, variables and variables with customer exits. Monitoring of the process chain and prompt resolution of issues in Process Chain in the post go live activities/hyper care. Involved in Requirements gathering phase, understanding the requirements, preparation of Detailed Design Documents Involved in unit testing, peer review, pre go live activities and post go live activities. Project Summary Project No. Duration E2E Implementation Organization Client 1 July 2012 to May 2013 Hydro Tata Consultancy Services (TCS) Australian Gas and Lights (AGL) Description: AGL Hydro is constituted of a group of Hydro based power generation stations and a group of depots through which all the resource related activities are planned and coordinated. This group of power generation stations and depots come under the Merchant Operations group of AGL business. Modules:- Finance and Controlling, Plant Maintenance , Material Management Responsibilities: Identification, enhancement and replication of logistics data sources according to project requirement. Created and replicated new custom datasource . Identification of standard InfoObjects, InfoCubes, DSO’s . Created new Info Objects, InfoCubes , DSO’s. Created Info Package and DTP for Data Loading into the InfoProviders. Worked on Multiprovider and Infoset. Worked on the creation of BEx report and on the creation of WEBi report on top of the BEx report. Worked on the creation of transformation routines (start routine, field level routine, end routine). Created, maintained and monitored Process chain . Creation of reports & dashboards in tableau. Creating the Dashboard and Report level prompts. Customized Reports look and Feel using Column Formatting, Conditional formatting. Creating dimensional hierarchies as per business requirements. Creating the requests in answers and see the results in various views like table view, view selector, chart, pivot table, ticker and legend. Created the Business users Reports, saved filters and prompts to improve the performance. Project Summary Project No. Duration Support or Post Implementation Support Projects in SAP IS-U Organization Client 1 AUG 2011 till June 2012 MINT,NECEF,NEXTGEN Tata Consultancy Services (TCS) Australian Gas and Lights (AGL) Description AGL is Australia's leading renewable energy company and is Australia's largest private owner, operator and developer of renewable generation assets. AGL has major investments in hydro and wind, as well as ongoing developments in key renewable areas including solar, geothermal, biomass, bagasse and landfill gas. AGL also operates retail, merchant energy and upstream gas businesses and has over three million customer accounts. The main backbone of the retail business is implemented in SAP ISU. This includes mainly 5 modules – FICA , Device , CRM , Billing and Business Intelligence. Responsibilities: Maintenance of InfoObjects, DSO, InfoCubes as per the business requirement. Working on Process chain. Monitored Daily Chains, Weekly Chains, Monthly Chains. Analyze the errors in the data loads. Loading Master data, Transaction data and into the SAP. Worked with the RSMO in solving the data load errors. Involved in monitoring the info package groups and process chains. Monitoring of info packages and analyzing the reasons for frequent failures of info packages. Handling tickets based on priorities and maintaining the backlog with respect to the SLA. Developing new enhancements as per the user requirements Reconciliation’s to verify the data in SAP IS-U and SAP BW are same or not after the data loads. Additional Experience: Creation and maintenance of SAP BO 4.0 WEBI reports. Project Summary Project No. Duration Implementation in IS-U Organization Client 1 AUG 2010 till July 2011 MINT,NECEF,NEXTGEN Tata Consultancy Services (TCS) Australian Gas and Lights (AGL) Implementation: Creation of reports. Creation of new InfoObjects, DSO, InfoCubes as per the business requirement. Creation and replication of new custom datasource. Worked with standard datasources. Replication of generic datasource in Business Data Warehouse. Creation of InfoPackages for Extraction and Loading of data from SAP IS-U. Creation of transformation between the source and destination InfoProvider. Creation of DTP for Loading of data from PSA to infoprovider, one InfoProvider to another . Creation and scheduling of Process Chain’s. Design and analysis of Query using Query Designer and analyzer. Personal Details Name Sankalp Kumar Nayak Date of Birth- Phone- Email- Languages English, Hindi, Oriya Passport Available