Sap Data
Resume:
VenkatGoli
***********.****@*****.***
SUMMARY
Seasoned IT professional with 10 plus years of management/development experience in manufacturing, finance, Retail, Oil-Gas, Public Sector and healthcare domains. Proficient with SAP HANA, SAP HCM, MM, FICO, FM, SD Modules, SAPBI,SAP ETL(Data Services),SAP SLT, SAP BW / BI, Webi, Tableau, COGNOS and Several Enterprise Data Warehouse (EDW) tools. Recognized for integrating cross-functional applications and technologies built on enhancing business performance. Performance driven leader aligning Information Technology plans with strategic business objectives, including revenue growth and profitability through effective collaboration with key stakeholders.
Experienced project manager leading all phases of diverse technology projects. Expert in agile and waterfall project management methodologies.
Certifications
SAP Certified Application Consultant - SAP HANA 1.0
SAP Certified Development Consultant SAP NetWeaver 2004
Education
Master of Science in Engineering
PROFESSIONAL EXPERIENCE
Pitney Bowes, CT Feb2015 –Present
SAP HANA/BI Manager / Architect
Subject Matter expert to support development of governance structure for identifying, managing and delivering Reporting utilizing SAP HANA and BI to consolidate Company Wide Analytics System. Planned and managed multimillion-dollar projects aligning business goals with technology solutions to drive process improvements (ITIL).
KEY ACCOMPLISHMENTS / PROJECTS
Managed cross-functional teams (onshore/offshore) to design and build data-centric solutions for business intelligence and data warehousing purposes
Analyzed, designed and delivered SAP BI capabilities on the HANA EDW platform
Hands-on delivery of strategically aligned and well-designed data models to meet complex business needs including operational and BI solutions
Delivered the effective mapping of information assets as they flow from SAP ERP and other systems to HANA to ensure data integrity, optimal transparency, quality, and consistency in alignment with data architecture
Map business requirements to the SAP HANA technology, and negotiate with the business teams to maximize and adopt standard functionality
Provided technical direction and support including prototype development for functionality demos and discussion with the business units
Lead cross-functional issue resolution across teams and resources and serve as a liaison amongst IT and business teams
Established governance policies to ensure new solutions are in alignment with strategic direction for each technology platform (i.e. HANA)
Worked closely with other architects for the development and implementation of the enterprise information architecture and roadmap, standards and methodologies
Collaborated with the Enterprise Information Management team to build scalable and adaptable information solutions
Provided design leadership, close technical oversight, templates, patterns, methodological leadership and documentation standards for the delivery of operational and BI data solutions
Driven architecture & design conversations regarding enterprise Information solutions
Conducted Technical Integration Check Extended for Go Live Readiness in coordination with SAP
Analyzed Trending Data and Provide Performance Recommendation addressing Specific Application/System Performance Issues on Hana
Experienced in Sizing the System Landscapes for SAP HANA, SAP BODS,SAP SLT
Designed and Implemented High Availability(HA)/Disaster Recovery(DR) strategies
Evaluate and recommend new database software, utilities, and tools and set the strategy for implementing new technologies.
Stay informed of technology trends to help identify opportunities for improvement
Implemented Several OSS Notes and raised several OSS Incidents
Archived Warm Data to SAP Dynamic Tiering from HANA
Developed Several UI5 screens using sap.ui and sap.m libraries on top of SAP HANA Models using oData
Well Versed with HANA System administration activities
Technical Expertise
Designed and Implemented several complex models with several SAP ECC MM,SD,FI,SRM,SCM,HR Modules,
Oracle Leasing Systems, SQL Server as Data Sources
Managed Environments on Cloud(SAP HEC) and on Premise
Conducted several DR/HA tests from one data center to another for both sync and ASync replications
Implemented Integration of SAP GRC for User Creation/Role Assignment on HANA
Designed Entire Security model on HANA and COGNOS Reporting Tool
Implemented Several Dynamic Analytical Privileges for Row level Security on HANA
Implemented Single Sign On(SSO) on HANA Environment
Created Several ODBC connections for data extract into SAS,SQL Server from HANA
Integration of HANA with Dynamic Tiering for Warm Data Storage
Translated Functional Specifications into Technical Specifications
Translated the Business KPIs into HANA & Define the Reporting Layouts
Imported HANA Live Content for Several SAP Models
Leverage SAP HANA Live Out of the Box Views and Modified HANA Live Browser Tagging
Enhanced SAP HANA Live Models to suit business requirements
Well versed HANA Performance tuning
Upgrade Experience on SAP HANA from 82->85->92->102
Analyzed Trending Data and Provide Performance Recommendation addressing Specific Application/System Performance Issues of CPU, IO, and memory
Implemented DB and RFC connections to Several SAP Source and Non SAP Sources from SLT
Hands On Technical Experience in implementing Several Complex Transformations on SLT like masking/Scrambling Sensitive HR info
Implemented Parallelized replication with SLT to improve latency
Iterative performance improvement of HANA SQL/CE Script stored procedures
Good knowledge of CDC on SLT
Good Working Knowledge of SDI
Implemented Sol Manager on SLT,HANA for alerts
Hands On Experience in developing ETL Jobs on Data Stage
Well versed with COGNOS Framework Manager
Hands On developing Dashboards, storyboards and Visualizations on tableau with source as SAP HANA
Designed interaction patterns, provide low to high fidelity mockups, prototype designs, and user test prototypes using Lumira
Monitored and Tuned ETL Data Loads/Extracts from HANA using SAP BODS/Data Stage and implemented Data Quality Transformations for Inbound and Outbound data into HANA
Implemented Complex Transformation in Data Services Workflow/Data Flow for data extraction
Accenture, NY May 2014 –Jan 2015
SAP HANA Application Integrator / Manager/Consultant
Delivered consultant services to various external clients to define and implement solutions as per business requirements. Managed projects at Unilever, Phillips66, Internal HANA Strategy utilizing SAP HANA and BI to consolidate Company Wide Analytics System working with Onshore/Offshore Teams
KEY ACCOMPLISHMENTS / PROJECTS
Design and implement complex data integrations/ solutions centered on HANA working directly with SAP and other core business applications
Articulate and contribute to high-level technical designs, detailed technical designs, development, implementation and support for Data Extraction, Model Design and Front End Reporting
Work with downstream systems to design methods for data extraction (SalesForce,SAP,BW,Primavera,CMS etc.) using SAP BODS,SLT,Informatica and SRS both Real-time and Batch Loads
Participate in projects with undefined scope (agile) with very quick deliverable turnaround.
Developed blueprint and design sessions, review options and provide recommendations while communicating the benefits, risks, and constraints to both the business and IT stakeholders
Ability to work in multiple environments and be able to prioritize and multi-task with a consistent track record of meeting deadlines while optimizing client satisfaction
Involved in Developing/Presenting Several Proof Of Concepts to different business Unit within organization
Presented at Several Workshops to Accenture Clients as part of Sales pitch.
Conducted Several Accenture Internal WebCasts and SAP HANA Training Sessions
Technical Expertise
Define the Design Documents for the HANA Models
Translated Functional Specifications into Technical Specifications
Translated the Business KPIs into HANA & Define the Reporting Layouts
Leverage SAP HANA Live Out of the Box Views and Modified HANA Live Browser Tagging
Enhanced SAP HANA Live Models to suit business requirements
Defining the Metadata Import process
Design & Creation of HANA Attributes views, HANA Analytic views, HANA Calculation views
Well Versed with SQL,SQL Script and CE Script Functions
Created Several Reusable Procedure Functions
Created Views Using Currency/ as Unit of Measure Conversions
Implemented HANA Security by creating several Roles as per User Categorization, Repository Dynamic Analytical Privileges
Experience with SAP HANA Administration including managing schemas, data model objects, import/export content
Well Versed with Security Authorization, Performance Tuning, Transport Management
Well Versed with Several Reporting Tools (OLAP, Design Studio, Crystal, Webi, Dashboard, Tableau )
Experienced using Business Objects Universe Designer to create BO universes against HANA Models as a data sources.
Emerging Health Information Technology LLC, Yonkers, NY
Team Lead (SAP HANA Modeller,SAP Technical and Functional Consultant)Oct 2006 – May 2014
Environment (SAP HANA,SLT,SAP BODS, SAP BI SAP 4.6C, mySAP ERP 2005 (ECC 6.0), MM,FI,HCM)
Hands-on buildingSAP HANA Analytics, Implementation of SAP HCM, finance and materials processes and workflow. Partnered with the business owners in the main service linesto review strategic plans and define areas for improvement. Performed key project functions including translation of business requirements to technical teams, development and execution of integrated technical projects and resource planning for all phases of the projects
KEY ACCOMPLISHMENTS / PROJECTS
Successfully managed over 10 highly visible projects ranging from budgets of $100K to $3M
Managed a multi-disciplinary team of 10 through complex programs and project tasks
Successfully implemented Side Car Version of SAP HANA for Analytics
Leverage IT systems to proactively identify and manage risks through trend analysis and development of best practices
SAPupgrade from4.6C to ECC6.0– Upgrade with Unicode conversion on all programs to support multi-language exchange of text.
Developed and Managed a home-grown RF application and configuration/deployment of Symbol mobile devices for par-stocking and inventory counts to increase productivity and reduce manual processes
Lead in enhancing the process and performance of all interfaces for revenue, positive pay, bank check reconciliation, EDI for material purchases and inventory
Technical Expertise
Deep understanding of HANA technology at the application and database level
Developed several SLT transformation includes for data replication in to SAP HANA and well versed with SLT Performance tuning
Experience with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View with SAP HANA Programming including SQL, SQL Script, and CEScript
Experience with SAP ECC table data model and analysis
Developed Several Design Documents for HANA Models.
Created Several Script Based Calculation Views calling Procedures
Well Versed with SQL,SQL Script and CE Script Functions
Well Versed with SQL Script Debugger
Created Several Reusable Procedure Functions
Created Several Decision Tables for reporting purpose
Translate the Business KPIs for Dashboards & Define the dashboard Layouts
Experienced using Business Objects Universe Designer to create BO universes against HANA Models as a data sources.
Experience in developing Business Objects reports using Universe and BICS.
Created Several Font End Crystal, Web Intelligence Reports
SAP Human Capital Management (HCM) project implementation – replace the legacy HR/Payroll system Designed and developed Several RICEFW development objects in SAP
Designed Several ABAP Reports in SAP MM,FICO,FM,HCM Modules
Developed Several SAP Adobe Forms
Created write optimized DSO’s, standard DSO’s, end routine and process chains.
Created a Generic Data Source using Table/View option for a custom table using the timestamp field and loaded the same into a write optimized DSO.
Design, development, and implementation of data flows in BW to assist Accounting & Finance task force for the new reporting requirements in Billing, Financial Accounting Line Items, and New G/L.
Well Versed with SAP ESS and MSS
Developed Several Custom Extracts for feeding SAP BW System
Configured an integrated ALE solution for data flow between SAP HR, Payroll, and Finance Systems.
Configured EDI Process for Inbound and Outbound interfaces for exchanging data
Implemented RWD uPerform software– provide a knowledge management system that enhances the end-user experience by providing online content and transaction-sensitive help, document repository and training capabilities. Reduced support calls and delays in productivity.
Technical SAP upgrade from 4.6C to ERP ECC 6.0.
Improved tax reporting functionality for Accounts Payable with a 50% reduction in the delivery process
340B Drug Program Compliance implementation – to maximize reimbursement and minimize cost by expanding its participation in the federally funded 340B drug discount program
SAP Data Archiving solution – lowered storage costs, improved transaction performance, increased efficiency in data analysis & reporting
Employee Activities Committee (EAC) member responsible for brainstorming ideas for company events and coordinate planning of functions that is conducive to team building in a more social environment
SoftproSoluions /NexGen
Senior SAP ABAP Consultant Sep 2005 – Oct 2006
Technical Expertise
Data Conversions
•Used LSMW for migration of Vendor Master Data, Customer master data, EDI partner table, SD Pricing
Tables, Purchase Info Records
•Uploaded Asset Master Data and material master grids using BDC.
•Used ECATT Scripts to extend Customers to various divisions & add partner functions to the customers
•Used Bapi’s to load Sales orders, Material Master Data, Open purchase orders, and Contracts.
•Developed a program for A/P positive pay file extraction.
•Involved in extracting, cleansing, preparing conversion files and loading conversion files in to SAP from
Legacy System
Scripts and Smart Forms
• Modified standard 1099 MISC and 1042-S smart forms as per the business requirements.
• Designed and Developed Sap script forms and Print programs for Order Confirmation, Customer
Invoice, Commercial and Factory Invoice, account payable checks customer statements, return
Authorization Labels, Shipper’s Export Declaration form
Enhancements (BADI’S/User Exits) and Routines
• Developed Routines in SD using VOFM transaction for Pricing Procedures.
• Involved in Order Creation and Customer Master Record Maintenance.
• Worked on Business Add ins to copy the TAX Jurisdiction Code from Delivery address Tab to Invoice
Tab, to control rounding for Open Po’s, to enable enhanced checks for the material master table.
Implemented sales order BADI’s (BADI_SD_SALES, BADI_SD_SALES_ITEM).
Worked on sales order user exits in MV45AFZZ and MV45AFZB.
Developed Routines in SD using VOFM transaction for Pricing Procedures.
RFC
• Created an RFC to retrieve a given style and color and size combination of a material from ECC
• Created an RFC to check item/sku availability for a specified date from CRM to ECC
• Created an RFC to check ZIP CODE validation from CRM to ECC
SKILLS
Software
SAP HANA, SLT,SAPBODS,Informatica,SRS SAP BI Reporting Tools
SAP ECC 6.0 (ERP – MM/FI/CO/AP/FM) SAP Solution Manager (3.2/4.0/7.0/7.1)
SAP BW (7.0/7.3) SAP Human Capital Management
RWD uPerform Performance Support
EDUCATION
University of Idaho,Moscow, ID Aug, 2005
Masters in Engineering
Contact this candidate