Solution Consultant

PAVANI PUPPALA

*** * ******** ******, *******, IL – 60601 704-***-**** ******.*******@*****.**

CAREER OBJECTIVE

A professional in Information Technology, Solution and Product services with 7 years of extensive experience in positioning solutions/products for various customers.

SUMMARY OF SKILLS:

Experience in working with agile software development teams

Skilled in analyzing and translating complex information into readable format

Highly skilled in project management tasks and multi-tasking.

Ability to adapt and implement changes

Superior innovative and leadership skills

Sharp analytical, interpersonal, communications and problem solving skills coupled with business and technical domain knowledge.

Collaborate with Agile team members and clients to identify process gaps and provide the best solution on a project.

Proficient in MS Office Excel (pivot tables, lookups, hookups, macro), Access, PowerPoint, Visio, Outlook, Word.

Strong knowledge of Software Development Life Cycle (SDLC), Agile, Scrum, Waterfall model and Project Life Cycle.

Design and maintain SQL scripts.

Experience using Tableau Desktop App in building decision-making reports.

Proficient knowledge in Hadoop MapReduce, OLAP, OLTP, ETL, SSIS, SSRS.

Involved in system maintenance, user role maintenance for each team.

Support product development and quality assurance teams.

Extracted and collected data to create needed reports.

Validated accuracy of data to ensure database integrity.

TECHNOLOGIES:

Java, SQL, T-SQL, ABAP, MS SSIS, Crystal Reports, BusinessObjects Dashboards, Universe Designer, Web Intelligence Reports, Big Data, Hadoop, HANA, SAP BI, Tableau and R Language for Data Mining.

PROFESSIONAL EXPERIENCE

Team Lead – SAP Labs Jan 2012 – April 2013

Products – Sybase SUP, Sybase Afaria, Hardware Sizing Services and Reporting Dashboards

Collaborating with business partners and cross-functional teams and supporting system documentation

Communicating necessary changes and developments to stakeholders in meetings to provide accurate reporting and information regarding the ongoing deals, risks, initiatives and budgetary details.

Providing operational/technical support for existing and new projects

Experienced in creating various Business Intelligence (BI) reports using Dashboards and Crystal reports

Involved in creating the database schema for new projects using Universe Design BI tool.

Involved in building KPI metrics dashboards across Line of Business using BusinessObjects reporting tool to monitor, manage, report and communicate project progress and resources required for measuring success metrics of the product features implemented for top management.

Experience in creating different interactive reports using different visualizations like Bars, Line Maps, scatter plots, etc.

Manage teams / user roles / LDAP authentication.

Assist end users with setting up the business / system process flow across multiple departments.

Senior Solution Consultant - SAP Labs Jan 2009 – Dec 2011

Products – SAP BusinessPlanning & Consolidation for Microsoft and NetWeaver versions

Involved in positioning product capabilities to the stakeholders and implementing them.

Involved in Requirement Gathering, Analysis, Blueprint, implementation and Product release.

Review production defects and prioritize by business impact.

Worked on the MaxDB Database to build various financial reports

Used SQL to query the database to facilitate business decisions.

Administered and developed financial reports using SSRS for numerous loan-managing applications with SQL Server. Facilitated data integrity between in-house business applications. Created procedures, triggers, views, job schedules and T-SQL scripts.

Experienced in data retrieval from multiple tables using joins, writing stored procedures,

Solution Consultant - SAP Labs Jan 2008 – Dec 2008

Project – Demo Build Request Forms and RFP (Request for Proposal) forms

Involved in customizing CRM WebClient UI for the customers using ABAP and Java.

Accountable for designing Integration scenarios using Business Process Management tool for customer use cases.

Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.

Involved in the Data Modeling phase of the application. Built InfoObjects and InfoCubes.

Increased efficiency of code, by using bulk collection techniques to handle large amounts of data

Used stored procedures for retrieving the data from the database for solving complex queries.

Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse.

Solution Consultant – SAP Labs July 2006 – Dec 2007

Products – SAP NetWeaver

Developed Adobe web Forms using Java and SQL for different modules

Deployed the web forms using Adobe LiveCycle Designer and web services.

Migrated Project code across different servers using LSMW (Legacy system migration work bench)

Worked with various clients like JP Morgan, Walgreens, Walt Disney, etc.

AWARDS AND HONORS

Awarded as the Best performer in the “Wall of Fame” in 2010 for Project Managing and Development of KPI Dashboards.

Awarded “U Rock” for being the best performer in Q3 2011 for successfully implementing and delivering the projects across multiple countries like Brazil, Singapore and India.

Received many Peer-to-Peer recognition awards for best Product Positioning and Management for the stakeholders in a very short turnaround time with complete customer satisfaction.

Certified in Big Data and Hadoop by Edureka

PROJECT DETAILS:

Monthly Report Automation Tool SAP Labs Project

Played the role of the Project Lead. Interacted with the Management / Leadership Team to prepare the Business Requirements Document. Involved in the Business Blueprint Phase, managed all the resources form the various teams and designed the project model. Successful implementation of the project was done in three months.

-Built the database schema using the Universe Designer tool.

-Created the ODBC /web service connection.

-Used Web Intelligence and Dashboard Designer tool to create reports.

-Experience in creating InfoCubes, ETL in Data Warehouse.

Budgetary Hardware Sizing Services SAP Labs Project

Worked with the Management Team in understanding the Presales requirements and identifying the gaps where additional services can be provided. Based on the requirement built the Pilot Phase Road Map for the eight countries for a month. Built all the supporting documentation and Hardware Sizing Process’s before rolling out into the Live Phase. Further also down the line expanded these services to other additional countries in 2012.

Helped the team in sizing for various customers across the globe.

Technology - Knowledge of a NetWeaver Architect and Quick Sizer tool

Washington DC Crime Analysis Report University Project

Worked with the Washington DC Crime Data File and developed a MapReduce Program to run analysis on the Big Data File. The MapReduce Program aggregated various crime offenses across different shifts from many Voting precincts. This Program helped to analyze the crime fluctuation rate in DC over the past three years.

-Created MapReduce program that can query on the data in multiple csv files and output the key value pairs.

-Created Dashboard reports which will enable authorized user to drill through the data and understand the ratio at which the crime

-Experience in Linux environment.

Technology – Java, Big Data and Hadoop

Bookmarking Sites Survey University Project

Survey comprises of information gathered from sites like reddit.com, stumbleupon.com etc. that are bookmarking sites and allow you to bookmark, review, rate, search various links on any topic.reddit.com, stumbleupon.com, etc. The data is in XML format and contains various links/posts URL, categories defining it and the ratings linked with it.

-Created MapReduce program that can query on the data in XML file and output the key value pairs which can then further be drilled using Pig, Hive.

-Used sqoop for mass migration of the data to HDFS.

-Used SQL for building reports.

Technology – Java, Big Data and Hadoop

Gaming Project University Project

Implemented Computer Graphics openGL technology to build a Gaming Project that can shoot targets in 3D space.

Technology – Java and openGL

EDUCATION:

Master of Science in Computer Science & Information Technology Aug 2014 – Dec 2015

Roosevelt University – Chicago - IL

Bachelor of Computer Science Engineering July 2001 – July 2004

Visveswaraiah Technological University – Karnataka - India

Contact this candidate