Shashi Reddy

Shashi P R O F I L E SHASHI “Shashi is a skilled IT professional with a wide range of experience in Software Development life cycle and excelling domain knowledge in Banking and Supply Chain. His background started in operations as a Quality Assurance Analyst and moved to software development as Functional Analyst and finally as Business Intelligence Analyst. In addition to the Client place SAP Space Development and support, Shashi has also worked for the vendor side ERP software development cycle integrating the major enhancements with SAP Materials Management (Procure-to-Pay cycle) and SAP BW, Support/Functional Analyst for the Lawson M3 Business Application and supported the client side by assisting them with the implementation, User acceptance testing, product support and end-user training to the diverse group of users. He is a quick learner, well organized where he communicates effectively in verbal and writing and possess excellent analytical skills. Shashi is an enthusiastic team player and an effective team leader where there was no difficulty working independently on specific tasks as required”. O V E R V I E W    Certified SAP MM/BI Professional with 9 years of experience, which includes Functional and Technical expertise in SAP BW/BI, SAP BOBJ, SAP Materials Management (MM) and JDA Manugistics ERP implementations and Creating Complex Reports using Business Objects, BEx Analyzer, Cognos and Tableau. Well-versed with development and enhancement of objects such as Info Cubes, DSO, Transactional cubes, Data Sources, Info Sources, Transformations, transfer rules, update rules, Process chains, Info Set queries, Batch scheduling.  Expertise in Report Generation - Worked extensively in BEX Analyzer - building Queries, Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries and broadcasted to business Users. Worked on BW upgrade from 7.0 to 7.31.  Conducted JAD workshops to determine and review the business requirements.         Assisted in determining and implementing the new features/enhancements in an Enterprise Resource Planning (ERP) system. Designed, developed and executed Test scripts (UAT) with end to end scenarios to ensure the performance of the product is within design specifications. Played a key role in demonstrating the major releases of the funded enhancements by the client Boeing Co. Managed the SCRUM activities, starting from executing a task till updates and keeping all the processes and documents updated as part of the AGILE process. Received spot awards twice in a row (A monthly performance award) and was nominated for Annual Pillar Award twice. “Everyday Heroes” Award for the excelling performance as a BW Analyst. Currently holds a SAP MM (Materials Management) certification. A team player with strong leadership abilities. Strong experience in resolving the customer reported/internal issues reported, by playing a role in Support/Service Desk team. Continued… Shashi Shashi Email-Mobile:- A R E A S O F E X P E R T I S E Business Intelligence, Enterprise Resource Planning (ERP), Quality Assurance, Supply Chain Management, Business Process Re-Engineering. C E R T I F I C A T I O N S • Certified SAP SCM - Procurement ECC 6.0 MM Consultant (ID-) T r a i n i n g • • SAP BW – BW 305 (Query Design), BW 310 (EDW), BW 330 (Modelling and implementation). SAP BO – BO100 (Reporting with SAP BO BI Solutions for SAP BW) P R E S E N T ATB Financial (www.atb.com) SAP BW Analyst II Apr 2014 – Till Date ATB Financial was created more than 75 years ago, in the darkest days of the great depression, to serve only one community “Alberta”. And today 5,065 team members help more than 730K customers in 244 Alberta communities and stands 4th in place as “Great Place to Work”. Responsibilities: • • • • • • • • • • • • • • Involved in major upgrade from BW 7.0 to BW 7.3.1. BW Analyst in BI team implementing data models for the Bank Analyzer 8 (BA 8.0), CRM, ECC R/3, and Payment Engine focusing on Modeling, Extraction and Reporting. Extensively developed and enhanced the reports using BEx Analyzer/Query Designer and published the reports on the SAP Netweaver portal and also worked broadcasting the reports to business users on the regular basis. Created moderate to complex BEx queries using restricted key figures, calculated key figures, report-toreport interfaces, exceptions, conditions, replacement, formula, text, user exit and structures. Experience with using start/end routines to customize business requirements. Worked on integrating and extracting data from different source systems BaS (Banking Services), ECC 6.0, BA (Bank Analyzer), CRM, PE (Payment Engine), FI/CO, Flat File using standard and generic extractors. Worked on enhancing the exiting DataSources to meet the requirements by analyzing the relations in the tables. Providing support on Operational activities – Monitoring EOD jobs (End of Day jobs), Process chains worked across fixing the issues in Production and Quality systems. Extensively worked on the production support activities, monitoring the data loads, fixing the issues, performance tuning and scheduling the jobs for month end, quarter end and yearend loads. Resolved the production tickets raised in HP ALM and Remedy including the Extraction, Performance issues and load failures. Worked with SAP Global Support Team to resolve the business impacted issues in Application component. Experience working with BOBJ tools (WEBI, Analysis for Office, Crystal Reports, Dashboards) Experience developing new universes and created reports on the web using web intelligence and provided access to the business users through info view portal. Created Process chains for the jobs to automate running as part of the EOD Jobs. 2 of 5 Shashi P A S T Finning (CAT) Canada (www.finning.ca) Sr. Business Systems Analyst Feb 2013 – Apr 2014 Finning (Canada) is a division of Finning International Inc., the world’s largest Caterpillars equipment dealer. It sells, rents and provide customer support services for caterpillar equipment and engines in most provinces of Canada. In 2013 Finning celebrated 80 years of success. Responsibilities: • • • • • • • • • • • • • • • • • Responsible for BEx Reporting on top of the LAWSON M3 ERP and Salesforce CRM system. BEx Reports (3.5), workbooks were migrated using new BI7.0 Tool Set. Created and enhanced the standard and custom extractors and user exits. Also worked on Direct update DSO. Created the generic extractor for order changes based on the view and replicated the data source and extracted the data in to BW and build the report based on the requirement. Worked extensively on creating new enhancements of BEx Query Designer, BEx Analyzer, BEx Broadcaster and BEx Web application designer. Developed complex queries, workbooks, and web applications. Performed Query Performance Tuning by analyzing and applying aggregates, line item dimensions, data compression, and indices. Assuring key components of the systems are effectively applied to business operations and driving the future implementations of the new or enhanced features or modules to the system. Train and support team members on system usage. Streamline the corporate process by establishing a Change Management Process and Revision process to keep track of process by process Mapping the cross functional departments using MS VISIO. Involved in business process re-engineering modeling the “Future State” or “To be” state translation to the Functional requirement document to provide inputs to the developers as part of the change management process. Establishing a process and maintain the documents at a shared location by giving access to the Users and stakeholders on SharePoint. Reviewing, analyzing and optimizing the business processes by establishing collaborative and effective partnerships with key business representatives/Stakeholders. Identifying the opportunities for automation, redesign or development of new processes. Generate reports from CUBE by Crystal Reports and SQL Server Reporting Services (SSRS) on Team Foundation Server (TFS). Resolve issues reported by the user in the Remedy tool which the Tickets are raised and sent to the Service desk and is assigned to provide analysis. Responsible to fix the issues reported by the users to the Service Desk/Support team where it is assigned directly to the queue. As part of the Support team, responsible to fix the issues as the priority based and in the timely manner. JDA Software Group (www.jda.com) Business Consultant, Intermediate JDA is a global leader in the Supply Chain Management software products market. Oct 2009 – Feb 2013 Worked on below ERP based JDA Contract Manufacturing suite of products integrating with SAP Materials Management and SAP Business Warehouse JDA Make-To-Order (MTO), JDA Maintain, Repair, and Overhaul (MRO), JDA Procurement and JDA CompassCONTRACT Job Profile Development and Support Activities:  Understanding the Business/Market Requirements. 3 of 5 Shashi       Development of Test Plan and Writing the Solution/Business Test scenarios for various business scenarios. Provide guidance to test team and incorporate team feedback into the testing process Report daily test results to management with high priority/ less priority defects observed during testing cycles in multiple browser environments. Analysis of Defects arising out of Customer-Reported Cases or Internal Development activities Executing the Test Cases (manual and Automation testing (QTP, LOADRUNNER)) and verify the test results using PL/SQL queries in the TOAD/Discoverer. Meet the expected timelines determined by the project schedule. Responsibilities: • • • • • • • • • • • • • • Understanding the client requirements and involved in preparing the functional and Non-functional (Technical) specifications document. Involved in business process re-engineering modeling the “Future State” or “To be” state translation to the requirement document to provide inputs to the developers and QA engineers. Modeling the business process through flow diagrams/charts in MS VISIO, TIBCO, BPMN and JDA Workflow Console (Developed through JBPM by JBOSS) a JAVA/J2EE application. Involved in researching business requirements and attending design walkthrough sessions (JAD) with the development team to identify the test items for the test plan input. Involved in preparing and executing the system and Business test scripts and performing regression testing. Reporting the defects arise while testing and client reported issues on the JIRA, HP Quality Centre (QC) and later moved on to “TEAMTRACK” (defect tracking tool by SERENA Software Inc) Supported resolving the issues/tickets raised by the clients through TEAMTRACK by being the part of Installed Base Engineering (IBE) Team, which in other words called as Support Team. Provided training and documentation on use of new feature/enhancement developed to the users. As a SCRUM Master managed the AGILE/SCRUM activities like Planning, sprint updates, estimations, story points and burn downs through “VERSIONONE” (A AGILE Project Management tool) on the Team Foundation Server Coordinated UAT, System Integration Testing (SIT), Pilot and Post Deployment testing effort of enhancements/features with the offshore consultants. Coordinating with US development team on various issues/functional queries concerning the design Configure and demonstrating the developed features to the Boeing, Lockheed Martin, NAVAIR Co Team. Setting up the goals in the JDA people and JDA Perform application (COBIT Framework) Involved in preparing the outline of the developed features (Processes, Standards, Procedures and Guidelines) for incorporation into User Manual/ Supporting documentation. Major Development Projects Executed in integrating various areas of Procure to Pay Project # 1 : Development of Last Approved PO functionality Client : Boeing Co. Client : Boeing Co. Client : NAVAIR, Lockheed Martin Project # 2 Project # 3 : : Development of Procurement Data Segregation Project Development of Alternate part functionality RGIS Inventory Specialists, New Castle, U.K (www.rgis.co.uk) Business Analyst Responsibilities: • Oct 2008 – Sep 2009 Implemented inventory management techniques for minimizing inventories and accurately meet demand and to ensure accuracy and efficiency by inventory and data collection solutions for supply chain optimization- from the warehouse to the store. 4 of 5 Shashi • Involved in Annual Physical counts and Cycle Count Processes to deliver accurate, timely insights about every aspect of the Customer Inventory and Supply chain. MTE Precision Components Intern Engineer (Quality Assurance) Responsibilities: • • June 2007 - May 2008 Inspected the specifications of the manufactured parts of pumps and motors Prepared quality control charts for various components, computing and tabulating results of the process S O F T W A R E  Database | SQL Server| DB2 | Oracle 11.x  Operating System | Windows 7/2003/XP | LINUX  Tools & utilities | BEx Analyzer | BOBJ Suite | QC/ALM | QTP | LoadRunner | TOAD | SQL Navigator  Skills  Application Suites | BEx Reports | BW Data Modelling | WEBi Reports | Dashboards | Ad-Hoc Reporting | MS Office | MS Excel | MS VISIO | MS Access | MS Project A C A D E M I C S  Master of Science, Engineering Management | 2010 | University of Sunderland, Sunderland, United Kingdom  Bachelor of Technology, Mechanical Engineering | 2007 | Jawaharlal Nehru Technological University, India S T R E N G T H S  Leadership Qualities  Quick Learner  Excellent Verbal and Written Communication Skills References and/or any other information may be provided on request. 5 of 5