AMIT KUMAR TURAN
Greater Toronto Area
SUMMARY OF QUALIFICATIONS
SAP HANA BODS BI/BW Consultant, Developer & Business System Analyst with extensive experience in technical architecture, process design, deploying solutions (to profile, to extract, to transform, cleanse, interface, convert & to load data), creating use-cases for end-to-end implementation in Health-care & manufacturing sector.
Developed a roadmap with tailored workshops, created functional specs, technical specs (low level design docs, high level design docs, source information docs).
Experience in Data-Provisioning techniques (SLT: Real-time replication, BODS: Batch process) to perform loading into HANA systems.
Experience working on HANA views (Attribute, Analytic & Calculation), SQL scripting, created decision tree and stored procedure using CE functions, Analytic privileges, importing BW info cube, DSO as analytic view, info packages & transfer rules.
Expert in business analysis & SAP BI reporting (Crystal reports, Dashboards, Web Intelligence, BEx analyzer, Lumira, universe created using IDT, Design Studio).
Demonstrated ability to align people, process, technology with strategy & vision.
Automated CO-PA data model creation. Well versed with side-car, main-car scenario.
Volunteering to providing solutions powered by HANA.
Technical architecting, data modeling (SAP HANA studio), data provisioning - ETL (SLT, BODS 4.x, DXC, SDA, Flat files), HANA views (attribute, analytic, calculation), BI/BW 7.x, SQL Scripts, jobs, star join, ECC 6.0, SD, MM, OLAP, OLTP, SDA, SDI.
SAP Business Object BI platform 4 (Crystal/Webi reports, dashboards, Explorer, IDT, BEx/ Excel analyzer), integrating Lumira, Design Studio, analysis for OLAP.
Conduct workshops for requirement gathering, planning, GAP analysis, BPMN, process automation, Profitability analysis, project management with RCA, user-role management. Agile Scrum methodology.
Self-upgrading, listener, motivated by deadlines, do well with a clear timeline in place.
Willing to learn & adapt, works in multi-cultural & multi-functional organizations setup.
Leadership, initiative, conflict management & accepts constructive criticism.
<2 sec. needed to analyze clinical indicators, compared to 1-2 months & working on a healthcare solution powered-by-HANA to reduce up-to 30% patients re-admission.
Working to reduce sales report response times from up-to 10 min. to 15 sec. or less.
Minimized planning cycles by processing calculations in-Memory with built-in HANA planning engine.
Automated processes, 100% operational efficiency, organizations go paperless.
SAP (HANA/BODS/BI/BW) Consultant, Developer 2016 – Present
CM Global Solutions, Canada (Volunteering)
Research on “SENSE & RESPONSE” application.
Identifying the business problem that data can help solve.
Developing individual roadmap, focused on business value & priorities.
Identifying the data sources, right technology with predictive analysis capability.
Planning to scale, look at “Privacy Issues”.
Monitor, analyze & automate business process with innovative solution power by HANA.
Migration of critical data from various data sources into single system using BODS.
Creating HANA calculation view based on SAP cloud platform IoTMMS table, setup to receive sensor data.
Working on solution that capture, filter, analyze & act on millions of streaming sensor events per second for continuous insight of the business with SAP HANA + SAP HANA streams.
Creating SAP HANA use-case to extract information from patient docs & perform text analysis on unstructured data from various file formats (txt, html, xml, pdf, doc, ppt, xls, rtf, msg).
Loading binary, flat & other docs directly into HANA for native text search & analysis such as classifying entities (people, company, things), identify domain facts such as (sentiments, topics, requests).
Data integration (clinical systems, administrative systems, sensors etc.)
Working on operational SAP Business intelligence, reports, dashboards & analytics.
Execution, continuous evaluation & improvement (agility).
SAP HANA BODS BI/BW Lead Consultant & Business Analyst 2015 – 2016
SAFRAN - Identity & Security
Created complex model views for sales & procurement modules as part of current POC, production orders, processed up-to 200+ millions records in few seconds.
Business requirement analysis, design of high performance architecture approach & development of advanced attribute views, Analytic views & unifying calculation views.
Worked on COPA extraction, converted key figure to account based CO-PA model.
Demonstrated results using BODS, universe in IDT for Webi users, crystal reports, BEx/ Excel analyzer for in-depth analysis of operation’s & dashboards developed on KPI’s are financial salvage reports, inventory turn analysis & shrink reports.
Co-developed advanced SQL script procedures for integrating SAP & non-SAP data into unified HANA model. Accomplished all integration via SLT replication.
Participated in high level BW on HANA strategy workshop with focus on third party integration & smart data access. Optimize objects like info cubes, DSO, transfer rule.
Documented technical solutions and automated global sales, purchase, inventory, finance & production processes of banking & telecom cards manufacturing business.
SAP HANA BODS BI Consultant & Business System Analyst 2014 – 2015
Client: National Informatics Centre
Created project plans with project manager, technical architecting, process designs, extracted, transformed, migrated & loaded data from ECC & BW to HANA using SLT, BODS, DXC, SDA, Flat files. Analytic & Calculation views for finance data, SQL scripts to call functions & execute calculation views.
Executed HANA based solutions & knowledge transfer to end-users. Provided SAP roadmap for rollout based on business needs & RCA. Created jobs in BODS.
Oversaw the end-to end life cycle implementation, created universe in IDT, crystal report Webi, Excel, dashboards for executive management (SD, operation, finance).
SAP HANA BODS BI Modeler & Business System Analyst 2013 – 2014
Accurately prepared project plans, conducted workshops to gather requirement, GAP analysis, business process management with RCA, Data provisioning (extracted, transformed, loaded data from SAP & non-SAP systems using (SLT, BODS, DXC), data models, star joins, calculation views using SQL & CE functions.
Accomplished financial transactions using universe in IDT, Web Intelligence reports, BEx/ Excel analyzer, built dashboards & finance KPI’s like project planning, SD, MM.
Programmer Consultant & Business System Analyst 2008 – 2013
Client: National Informatics Centre
Implemented strategy planning, GAP(AS-IS TO-BE) analysis, designed context Data Flow Diagram, documentations, data migrations, master data readiness, designed & published data reports (crystal report 2005) based on data analysis & SQL scripts.
Overhauled haphazard technical architecture, business continuity plan.
Developed, implemented approved model solutions for e-Governance and mission critical projects, integrated digital signature with-in application, Go-Live & support.
Post Graduate Diploma in System And Database Administration
Bachelors of Technology – Information Technology
India, New Delhi, DL - boy, speak, field, professional experience, 2005,...
Manager Customer Service
Grand Rapids, MI - claims, claim, processor, clerical, workers, 1999,...
Customer Service High School
Bakersfield, CA - fresh, joshua, present, customer service, service,...
Customer Service Manager
Edgar, WI - fda, bw, operations, responsible, manufacturing,...
Grand Rapids, MI - architect, plumber, grand, rapids, fi, ft, planner,...
India, Hyderabad, Telangana - service engineer, hydraulic, engine, brake, action,...
Philippines, Pagsanjan, CALABARZON - semiconductor, role, manufacturing, taiwan,...