Samrat Kumar

• Building and assisting client with understanding the Data Conversion strategy.

• Assisted client with understanding the Data Conversion Process.

• Assisted client with understanding the DGW’s (HCM, Payroll, Benefits, Recruitment and Absence) and help with populating the same.

• Assisted clients with implementing HCM core, Benefits, Payroll, Compensation and Recruitment.

• Assisted Client with Data Conversion/Data Mappings.

• Assisted Workday Finance Data Conversion Team with conversion for Supplier Information, Supplier Invoices, Purchase Orders, Business Assets, Customer Information and Customer Invoices.

• Convert Data from legacy system (PeopleSoft) to Target Tenant values.

• Well versed with Data loads to the client tenants using aloads, iloads and EIBs.

• Created rule-based BP’s with just initiation steps for Hire, Assign Pay groups etc. for Data Load purposes.

• Created several custom reports (Advanced Reports) as per client requirements.

• Created custom fields which have complex logic and are used for the custom reports.

• Conducted and lead meetings for validation and addressing any Data conversion issues and documenting them in validation workbook.

• Performed Data loads for Compensation history, Payment History and Job history Data to the client tenant using iloads and EIBs.

• Building and assisting client with understanding the Data Conversion strategy
• Assisted client with understanding the Data Conversion Process
• Assisted client with understanding the DGW’s (HCM, Payroll, Benefits, Recruitment and Absence) and help with populating the same
• Assisted clients with implementing HCM core, Benefits, Payroll, Compensation
• Assisted Client with Data Conversion/Data Mappings
• Convert Data from legacy system to Target Tenant values
• Assisting the functional team with the C&P (configuration & Prototype) Build by assisting them with the Legacy Data values and conversion values
• Well versed with Data loads to the client tenants using aloads, iloads and EIBs
• Lead data conversion for HCM, Benefits and payroll and Recruitment
• Lead recruitment data conversion for an Automobile and Pharmaceutical client by assisting client populate the DGW
• Created Job requisitions, Positions for Position Management Organization
• Lead Conversion of Candidate data for recruitment Implementation
• Built clover graphs for Data conversion purposes
• Well versed with Config migration using migration recipes
• Created rule-based BP’s with just initiation steps for Hire, Assign Pay groups etc
• For Data Load purposes
• Created several custom reports (Advanced Reports) according to client requirements
• Created custom fields which have complex logic and are used for the custom reports
• Lead validation process post build completion
• Lead and created validation strategy for client for post builds
• Conducted and lead meetings for validation and addressing any Data conversion issues and documenting them in validation workbook
• Built clover API graphs for Data loads
• Lead Data conversion for compensation history and job history Data
• Created inbound and outbound EIB’s
• Performed Data loads for Compensation history and job history Data to the client tenant using iloads and EIBs
• Mapping the US payroll data from legacy system to Target Tenant values
• Assist the Data team with data conversion for the same for different countries included for conversion
• Worked and managed various offshore resources and assisting them understanding the scope and deliverables

• Designed and created HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Stored Procedures
• Created SQL based and HANA database tables (HDB) in HANA
• Apply advanced data modelling techniques, including currency conversion, variables and input parameters
• Performed SLT replication to migrate ECC tables to HANA for real time replication
• Created remote connection to Hadoop system and exposed virtual tables in HANA using Smart Data Access – SDA
• Performed data cleansing activity, transformation and created flow graphs in HANA using Smart Data Integration – SDI and Smart Data Quality - SDQ
• Created Logical Design Model – LDM and Physical Design Model – PDM using Power designer and created HANA tables by leveraging power designer models
• Working with different type of joins: Inner Join, Left outer join, right outer join, Referential join and Text Joins
• Created COPA related queries using BO Analysis for Office
• Pre-and-Post HANA migration activities for BW on HANA including pre-migration housekeeping tasks and post- migration issues fixes
• Worked with the business analyst to understand and document the functional requirements
• Performed modeling exercise to address the functional specifications
• Developed reports using the advance Webi functions like, merge query, context measures and ranking
• Created several calculation view and analytical view to support the functional requirements
• Worked with the SAP Basis team to setup the SLT replication for SAP source and SAP Data Services team to load the non-SAP data in SAP HANA
• Design the solution to integrate the SAP and non-SAP data using HANA Studio
• Developed analytical views to integrate different tables
• Worked on the Life Cycle Management to transport delivery unit
• Created universe (using IDT) on HANA views to expose the data in BO 4.0/4.1 Webi
• Optimized the SAP HANA view for Ad-hoc reporting using Webi and BO Explorer
• Created dashboards with dynamic data from SAP HANA
• Created dashboards with functionality and features such as What-if analysis, Alerts, Drill Down, Filtered Rows and Dynamic visibility
• Leveraged aggregate aware in the ad-hoc universes to dynamically select appropriate aggregate layer (fact table) based on the dimensions selected by the business users
• Created, maintained, and updated several universes using Universe Design tool and Information Design Tool
• Scheduled Business Object Reports to users using BI Launch pad
• Involved in performance tuning and optimization on Business objects reports and Universes

• Involved in full life cycle implementations, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Performed HANA modeling and developed Analytical views for the transactional data, Attribute views for the master data, Calculation views
• Performed traditional and non-traditional data loads from legacy systems to HANA database
• Implementation of Replication technologies SLT with ECC to HANA System
• Worked on HANA performance improvements by analyzing queries in terms of memory consumption, data transfers between nodes and time to process queries
• Performed data extractions, transformations using BODS from BW and ECC and loaded to HANA
• Migrated HANA content from development, testing environment to Production environment
• Created Universes on top of HANA calculation views and developed the Webi reports using IDT (Information design tool)
• Worked extensively to use the BODS for Project, Job, workflows, Data flows, Datastore tables, functions
• BODS debugging batch jobs, validating and tracing are used during project
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models
• SAP best practice techniques are used for entire projects on data migration, data integration and data quality

• Worked at GSK as SAP HANA Modeler and BO developer
• Worked with the business analyst to understand and document the functional and technical requirements
• Wrote functional and technical specification based on the business requirements
• Developed Attribute, Analytical and calculation views using graphical and SQL Script mode
• Developed analytical views to integrate different tables
• Worked with onshore and offshore Business model, managed off-shore team of developers and conduct daily meetings to translate business requirements to development team
• Created Master Data views for dimensional modeling keeping in mind the global usage of Master views
• Helped defined Modeling best practices and package structure for reporting with Architecture team
• Created OLAP reports on top of information views
• Created reports in OLAP analysis
• Created analytic and complex calculation views using SAP HANA modeler
• Mapping the input parameters to underlying views and pushing filters to foundation tables
• Imported analysis authorizations to HANA as analytical privileges
• Transported development objects to Quality system using developer mode
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables
• Information Modeling in SAP HANA and Report Generation for Sales and Distribution module towards Comparative Analysis for pricing conditions
• Optimized the SAP HANA view for Adhoc reporting using Webi, analysis for office and Lumira
• Developed Fix formatted, and self-service reports based on the business requirements using Webi Intelligence and Analysis for office
• Created User Prompts, Conditions and Filters to improve the report generation
• Created Webi reports Publications in CMC based on User Profile to enable report bursting

• Performed end to end SAP HANA Implementation for Several Monsanto Business units Globally
• Involved in Various requirement gathering sessions with several Monsanto Business units across North America, South America and Asia
• Worked with the business team for requirement gathering and document requirement in functional specs
• Created analytic and complex calculation views using SAP HANA Modeler
• Mapping the input parameters to underlying views and pushing filters to foundation tables
• Designed and created HANA Information Models such as Attribute Views, Analytical Views, Calculation Views and Stored Procedures
• Converted standard BW models into HANA optimized models and Imported into SAP HANA
• Performed fit gap analysis to utilize HANA live views on SAP FI, copied and leveraged standard content after performing custom modeling
• Created information models for COPA multidimensional reports that include COPA variance and COPA Actual/Plan comparison reports using HANA studio

• Worked with the business analyst to understand and document the functional and technical requirements
• Created Alerts in various reports according to user requirements
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end user
• Worked on Query Panel, Prompts, Report Layout and Re-formatting
• Worked closely with the end users to develop the transformation logic to be used in Reports
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined conditions to use in Business Objects
• Designed and developed complex Crystal reports involving Sub-reports, cascading prompts, Running Totals, Cross tabs and Charts with extensive formulas
• Designed complex Web Intelligence and Desktop Intelligence Reports
• Designed Universes for Ad-hoc reporting
• Created and tested classes and objects to organize the universe
• Created different reports containing charts showing revenue and operating income by different divisions

• Worked with Trading Table, Financial Analysis Team and Portfolio Management Team to understand the business requirements needed to incorporate the features they wanted working in the system
• Facilitated Joint Application Development (JAD) sessions to resolve urgent issue relating to requirement that were scheduled for the next release
• Worked with the different business units (Accounting, Fixed Income, Equities, Foreign Exchange) to understand the current business flow
• Used UML to create Use Case diagrams for requirements
• Scheduled meetings with developers, SAs (System Analyst) and Testers to collaborate resource allocation and project completion using MS Project
• Conducted UAT and coordinated with the QA Team in the sign-off process before deployment
• Assisted the Project Manager in creating the User Manual Documentation
• Managed relationship with programmers and bridged communication between end users and development team
• Clarified issues with developers during efforts to validate designs and functional specifications
• Preparing BRD's (Business Requirement documents), FRD (Functional Requirement Document's), SRS (System Requirement documents) and User stories etc
• Preparing Project visions documents, Project Management plans, Time lines, Mockups and Presentation
• Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements
• Prepare and review requirements, specifications, business processes and recommendations related to proposed solution
• In-depth knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall & Agile