Post Job Free

Resume

Sign in

Sap Data

Location:
Milford, CT
Posted:
August 17, 2016

Contact this candidate

Resume:

VenkatGoli

acv7q1@r.postjobfree.com

267-***-****

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