Abhinay Pinisetty

Seattle, WA – ***** * 657-***-**** * adcgn6@r.postjobfree.com

SUMMARY

Innovative, passionate and versatile Software Developer and Specialist with around 7+ years of extensive experience on Cross Data warehouse SAP S4HANA, AWS & Azure Cloud data warehouse, SAP BW on Hana and MSBI, Databases (Oracle, MSSQL, Hana and DB2)

Worked on solutions for Real time, near real time and non - real time reporting Requriments

Experience with complex project circumstances including multiple vendors, high degree custom development, Multi site, multinational and onsite-offshore delivery model

Strong Experience in implementing Data warehouse solutions in Confidential Redshift; Worked on various projects to migrate data from on premise databases to Confidential Redshift, RDS and S3.

Expertise in Implementing SAP HANA, SQL SSIS, SSRS for OLAP and OLTP environments.

Expertise in planning the hyper-care and steady state operations of SAP HANA, BI reporting application environments

Strong experience in troubleshooting, debugging and supporting business intelligence applications in Confidential Business Intelligence Stack configuration.

Experience on Cloud Databases and Data warehouses ( SQL Azure, Snowflake and Confidential Redshift/RDS)

Strong knowledge in logical data modeling and source to target mapping.

Specialized in using Cloud based (Azure) data warehouse solutions.

Good insights into Internet of Things (IoT) and Big Data Analytics.

Possess working knowledge with Python and Ruby in writing scripts to automate software configuration process with SaltStack, Chef and Puppet.

Knowledge and experience on designing and maintaining NoSQL database. MongoDB (with/without Sharing), DynamoDB with Dynamo streams and Cassandra

Having good Knowledge in NOSQL data base like DynamoDB and MongoDB.

Good Exposure to Amazon Web Services cloud based Redshift data warehouse and Snowflake data warehouse solution

Experienced in developing complex Web applications using .NET, ASP.NET, VB/C# with Visual Studio 2010/2008, version control using Team Foundation Server.

Expertise in development of various reports, dashboards using various Tableau, Power BI Visualizations

Hands on experience in Integration of SAP BW Systems with MSBI

Good communication, interpersonal and managerial skills, team player with positive attitude and self-motivated to work independently and in team as well.

WORK EXPERIENCE

Nike

SAP BI Consultant, October 2018- Present

Identified, assessed and solved complex business problems for area of responsibility, where analysis of situations or data requires an in-depth evaluation of variable factors

Work with product management to create and maintain solution roadmap

Assist other team members, scrum development team, and enterprise architecture in developing solution delivery best practices

Be the strong liaison between Product Management and development to ensure a transparent and productive workflow environment

Work with teams to continuously improve product ownership and other agile processes

Perform risk management to minimize project risks

Provide sprint goal and tactical objectives to scrum team, and provide quick JIT decisions to system level questions and defect triage

Work with program management to track schedule against the roadmap, and escalate risks and issues

Defined Supply chain analytics for overall OTC from industry standard KPI’s.

S/4 Embedded Analytics Tools – View Browser/Query Browser/Custom Analytical Query/ KPI Modeler/ Report Modeler/ SAP Analysis for Office.

Identified standard SAP CDS Views/VDMs/Content available and enhance standard CDS Views delivered by SAP to fulfill customer specific reporting requirements.

Proficient with Eclipse using ABAP Development perspective to create and enhance CDS Views.

Working Knowledge of how to integrate CDS Views with Analytical Consumption Tools including KPI Modeler, Report Modeler, Analysis for Office & Fiori Multi-dimensional reporting tool

Strong analytical skills and able to define technical specifications, troubleshoot and debug CDS Views in order to fulfill business requirements.

Mentored and educated other team members on CDS View Development.

Integrating S4/HANA Embedded Analytics with Business Object Platform / AWS/Azure cloud platform

Closely followed the strategic direction set by senior management when establishing near term goals

Designing and building multi-terabyte, full end-to-end Data Warehouse infrastructure from the ground up on Confidential Redshift for large scale data handling Millions of records every day.

Optimizing and tuning the Redshift environment, enabling queries to perform up to 100x faster for Tableau and SAS Visual Analytics

Migrated on premise database structure to Confidential Redshift data warehouse

Was responsible for ETL and data validation using SQL Server Integration Services.

Defined and deployed monitoring, metrics, and logging systems on AWS.

Set up and maintained applications on Amazon Web Services.

Utilize Cloud Watch to monitor resources such as EC2, CPU memory, Amazon RDS DB services, Dynamo DB

Designed and implemented database architecture for applications using various databases (MongoDB, DynamoDB, MySQL, and Postgres).

Redesigning Designed and implemented RESTful APIs using Data Mapper to interact with a service provider that stored all personal customer information.

Implementing and Managing ETL solutions and automating operational processes.

PUGET SOUND ENERGY

SAP Consultant, March 2018- September 2018

Work directly with other product owners, system engineers, program managers, developers, testers, and customers to define features and technical user stories

Support an Agile Software Development process, working in conjunction with end users / stakeholders and technical delivery team

Work closely with counterparts in Product Management to align on the vision, program backlog, and roadmap

Acting as stakeholder of specific product backlog items, work closely with development teams to ensure the output to be aligned with expectations

Involved in gathering business requirements for prospects, accounts and contacts, activities, opportunities, groupware integration and sales pipeline reports.

Ensured that the implementation of business systems to support business goals, objectives and needs in the areas of accurate processing of quotes and orders from CRM 7.0 through to ECC 6.0..

Conducted training sessions for team members in functional areas, and impart knowledge on business context, solution design, open issues, and act as mentors to support analysts.

Core functionalities covered: Marketing - Master Data Setup, Org Model, Lead Management, Campaign Management, External List Management; Service - Business Partner, Service Product Maintenance, iBase Management, Warranty Contract, Service Contract, Service Orders, Project Ticket, Service Complaint, Repair Order, Service Billing, Work Force Management, Problem Management; Sales - Organization model, Pricing Procedures, Opportunity, Quotations, Sales Order Management, Middleware monitoring.

Very successful in the design of efficient, effective and innovative solutions

Combining analytical and methodical thinking with good communication skills.

Planning and implementation of business functionalities like Start, Stop, Transfer, Budget billing, Invoicing etc.

Provided team support for Mobile Application installations, operations and functionality.

MICROSOFT CORPORATION

SAP BI Consultant, Jun 2016 – March 2018

Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.

Synthesize current business intelligence or trend data to support recommendations for action.

Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.

Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.

Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.

Identify and analyze industry or geographic trends with business strategy implications.

Extensively involved in assisting the SAP security team in determining the required BI authorization.

Manage timely flow of business intelligence information to users.

Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.

Review technical design documentation to ensure the accurate development of reporting solutions.

SAP BW-HANA Implementation & Integration with Microsoft Business Intelligence(MSBI), Jun 2016 - Jul 2017

Explored the different architectural options including SAP HANA and HANA Live

Worked on integration of SAP BW with MSBI by writing generic data sources / extractors

Developing reports, maintaining report definitions, maintaining report manager portal using SQL Server Reporting Services (SSRS)

Developing and maintaining OLAP cubes using SQL Server Analysis Services (SSAS)

Developing ETL packages using SQL Server Integration Services (SSIS) and bulk-loading utilities

Provide guidance on use cases for SQL Server

Ability to Define and Interpret business requirements in collaboration with the product manager for complex analysis and data integration projects from an SAP to Non-SAP system to built an OLTP and Datawarehouse.

Experience with ODP framework based data extraction.

Experience with web service based ODATA Service to expose SAP ECC data for html5 clients.

Engaged in building azure based data warehouse by extracting data from SAP system

Implemented Microsoft Azure Data Factory (ADF) for Transformations.

Planning the SAP BI deliverables in line with the overall SAP deployment plan which consists of various milestones for multiple countries deployment.

SAP Activate methodology in Agile fashion.

ENERGIZER

SAP BW/HANA Consultant, Mar 2016 - Jun 2016

SAP BW on HANA platform - Managed System Landscape preparation with Basis team.

SAP BW Technical upgrade: Conversion of data flows, data sources, queries, workbooks and security objects from version 3.x to 7.x in BW DEV system and transported all through the landscape to BW Production environment.

SAP BW authorizations migration from 3.x to Analysis Authorizations.

Process Chains migration to include DTP flows.

Testing and validation of 7.x objects.

Process Chain monitoring and bug fixes after upgrade to 7.x.

Integration testing with SAP BO and Portal.

Collected statistics from Data loads and Reports Execution timings before migration to HANA.

Supported migration to SAP HANA via DMO option - SAP Notes implementation.

Plan and execute HANA post-migration activities.

Hierarchy objects dataflow/data source migration from version 3x to 7x.

System Validation and Testing after migration.

Integration testing with SAP BO and portal after migration to HANA.

System Cleanup : Deletion of unused objects from the BW DEV system and transported through the landscape.

Universe Layer removal : Replacement of SAP BO Web Intelligence reports created on top of BO Universes by creating Bex queries and consuming them to SAP BO Web Intelligence via BICS connection. This empowers webi reports with SAP HANA in-memory database.

Final validations and system health check.

Go-Live : BW-HANA migration.

Analyzed and presented SAP BW Data Model re-architecture as per LSA++ concepts to leverage SAP HANA as the In-memory database.

AURORA IT TECHNOLOGIES

SAP HANA/BI Consultant, Aug 2015 - Feb 2016

Proactively interaction with stakeholders to understand their reporting needs and gathering Business Requirements, Business Process Flow, Business Process Modeling and Business Analysis

Used (six sigma) methodology and Software Development Life Cycle (SDLC) processes.

Gathering Business Requirement, conducting GAP Analysis, Developing Use Cases, SWOT analysis, Risk Analysis, Modeling Business processes, Cost benefit Analysis and preparing Training Manuals

Gather all the Sales analysis report prototypes from the Datamodelers belonging to different Business units; Participated in JAD sessions involving the discussion of various reporting needs.

Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.

Conduct Design discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved for the Datwarehouse /OLTP

Designed & Developed custom Data Source, Info Source, Extractor, Info Cube and ODS to fulfill user requirements.

Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation.

Expert in SAP HANA extraction from SAP-ECC/Non-SAP Data sources using Informatica

Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting)

Experienced in writing HANA DB procedures and views.

Experienced in creating HANA Calc Views (Using SQL), Attribute Views and Analytic Views.

Experienced in writing HANA procedures for various merchant processes. For example, Aggregation, Annual Load Calculation, Profiling etc.

Proficient in creating interfaces between various sources with HANA. For example, Extracting data from XML file to HANA database.

Experience in executing Data service batch jobs through data services management console.

Experienced in writing and debugging data service batch jobs using SAP data service 4.0

Translation of complex utility related requirements into SAP Data Services transformations (e.g. Lookups, complex Joins, Case, functions, pivots, matching)

Creating report on customized views using SAP Lumira

Creating reports on customized views in Web Intelligence(WebI)

Experience in SAP HANA data modeling using HANA Studio

Defining the SAP HANA components (ECC Tables and Non ECC sources to replicate) Replication Process Define HANA Views (Which are basis for Data Reporting/Analysis), Defining the Data Analysis components in BOBJ Define Reporting aspects, analysis components. Reporting Decision Tree, Creating BW and HANA Use cases. Report Rationalization, Defining Strategy and Direction.

Data Integration architecture, Define Project Plan, Governance model, Identify the various teams and their responsibilities.

GOOGLE JOBS

BI Analyst & Product Owner, Jun 2013 - Jul 2015

Acted as an interface with different stakeholders of the project.

Developed a vision plan that defined the primary goals and objectives of the project.

Conducted Joint Application Development (JAD) sessions.

Developed the product catalog from various job portal sites.

Metadata maintenance on a daily, weekly and monthly basis.

Mentoring and trainings session for newly joined members.

Defined KPI for the product cycle during the development phase.

Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.

Define and initiate projects and assign Project Managers to manage cost, schedule, and performance of component projects, while working to ensure the ultimate success and acceptance of the program.

Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.

Ensured that the Business needs are understood and communicated clearly to the project team and efficiently delegated roles and responsibilities and enabled them to meet their deliverables

SoP's documented to enable business run efficiently

Set up a healthy governance to monitor KPI of operations effectively

GOOGLE MAPS

Project Lead, Feb 2012 - Jun 2013

Strong in setting up goals for reportees and also tracking the same.

Efficient in identifying SWOT of each reportee and set them to live-upto expectations by providing/enabling initiatives and playing according to their strengths

Ensured that the Business needs are understood and communicated clearly to the project team and efficiently delegated roles and responsibilities and enabled them to meet their deliverables

Stimulating quick conflict to improve the quality of strategic thinking without sacrificing significant time

Successfully ramped up pilot project teams into a fully performing auto pilot teams.

Strategic ground level checks on a timely basis were made to cater to any unanticipated issues that arise as the project progresses which evaluated performance levels

Helping the operators understand the mission of the process.

JAD sessions

Conducted weekly All Hands.

Data Analyst, Sep 2010 - Jan 2012

Quick to identify tools, building dashboards and data sources according to process requirements and document the same involving data profiling.

Efficient analyzer of Sampling, Q-Staffing & data itself for better user experience

Conducted RCA's at frequent intervals and recommending training requirements, tool changes & policy changes for better data quality. (Reduced error rate from 15% - 2%)

Set up a healthy governance to monitor KPI of operations effectively

Interpret data from primary and secondary sources using statistical techniques and provide ongoing reports.

Compile and validate data; reinforce and maintain compliance with corporate standards.

Develop and initiate more efficient data collection procedures.

ENVIRONMENT

Tools: Confidential Redshift, AWS Data Pipeline, S3, S4 HANA, SAP Analytics Cloud, SAP BW, SAP HANA, SAP BODS, SAP BO, SAP Lumira, SAP MM, SAP PS, SAP CPM, SAP CRM, SAP HR, SAP SD, CONCUR, Chronos, GRM, Atlas GIS, Azure Data Factory, Power BI, Google Analytics,

Programming Languages: SAP ABAP, SQL, C, C++, Scala, Ruby, Python, Dbase, R, XBase

Coding Languages: HTML, XML, PHP

Database: NoSQL Database, MongoDB MySQL, SAP Netweaver, Microsoft Excel, Teradata, Oracle RDBMS, HANA 1.0, HANA 2.0

Operating Systems: Windows, Linux, UnixManagement

Program Tools: Word, Excel, Access, PowerPoint, OneNote, VISIO, PMP, Jeera, Confluence, Box, SharePoint, Version 1.

EDUCATION

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY, Hyderabad, Telangana

Bachelors in Engineering, Apr 2010

ADDITIONAL SKILLS

Certified Scrum Product Owner.

Certified Business Intelligence Professional.

Contact this candidate