Bhanu Prakash Reddy G

Environment : SAS, db2, PowerBI

Project : IDC Service Parts – System Interface and Automation(GCPL AND GMMCO)

Company : Caterpillar India Pvt. Ltd.

Description:
This Project helped the manufacturing facility metrics with leading & lagging indicator
• To Prioritize aged orders and shipments
• Helped to maintain health of a facility at Optimum level
• Visibility to end to end Supply Chain and key Logistics Reports
• Improve Operational efficiency and reduce cost

Environment : SAS, db2, PowerBI

PROJECT2: ASN PERFORMANCE REPORTS

Company : Caterpillar India Pvt. Ltd.

Description:
This Projects helps the facilities to Analyze Parts Receiving Effectiveness and Supplier Performance.
ASN, Receipt, Invoice, EDI data available in flat file is downloaded using SAS and reports are generated based on business logics as per the client requirements which helps in the Receiving effectiveness of Parts from the supplier to the facility.

Responsibilities:

• Developed a robust automated end to end solution for IDC facility in creating the sales order and order exceptions for the orders received from various dealers.

• Requirement gatherings and Business logics from the clients.

• Validating and collecting the required data to meet the requirements from multiple data sources like Text, excel, Oracle tables, Teradata, DB2 tables.

• Developed and created SAS Macros to access and analyze data.

• Manipulating the data according to client requirement, using various SAS statements, Functions.

• Analyze, Clean, implement Business logics to the data and load the required data to Oracle database.

• Preparing Ad Hoc reports based on the specific client requirements.

• Tuning the programs for better performance.

• Generated various reports like Inventory Trend, Consumption Pattern, Ageing of Inventory, Excess Inventory, Inventory Turns.

• Changing the Logics as and when the client has requested.

• Publishing the Power BI dashboards in Power BI server.

• Schedule the SAS jobs in JAMS scheduler once they are moved to Production.

• Developed financial models to analyze data and identify potential risks.
• Gathering Requirements and Business Logics from the Client leads.
• Generate the Reports Using SAS/EG, SAS/ACCESS, SAS/MACROS.
• Preprocessing the raw data into meaningful data, using SAS Character, Numeric functions.
• Joining data from multiple datasets, sources using MERGE, SQL JOINS.
• Loading the data into Oracle tables for Tableau and Power BI reporting.
• Sending data in the form of EXCEL in Automated emails through SAS as per the client’s request.
• Generate Ad-hoc Reports in short period as per the business logic provided
• Moving, Deleting , Copying files between folders using SAS commands.
• Capturing, Archiving historical data for further analysis and reporting purpose.
• Maintaining the Production Jobs and fixing issues when raised.
  • Enhancing the current reports based on the Customer Requirements.

• Environment : SAS and Teradata
  Role : Sr. Financial Analyst
  Project : Telstra Corp Australia(Telecommunication)
  Company : IBM India Pvt. Ltd.
  SAS® Telecommunications Intelligence Solutions enable you to quickly implement effective business strategies, retain and grow customer accounts and execute more successful marketing campaigns.
  Project involved development of sas jobs which loads data in data mart, source data getting extracted from various data sources and flat files and CRM solution.
  • Acted as a liaison between the business and the technical teams to develop an Enterprise level strategic reports for Telstra Corporation
  • Provided technical and functional support throughout the project lifecycle, including gathering business requirements, developing functional specification documents, reviewing SIT and UAT test cases, and supporting all the testing phases for Service Delivery and Billing and Credit teams
  • Partner with the development teams to facilitate the build effort (e.g. ensuring build teams understanding of the specifications)
  • Data mining, Data Analysis and providing insights to business users for making effective business decisions
  • Overcame complex business challenges and maintained the data quality as the priority and made high-stakes decisions within fast-paced, high-pressure environments. As a result of this work, Merchants were able to run their forecast reports every week on time.
  • Adapted well defined processes, quality standards, and getting peer review done before publishing the final reports.
  • Trained the team in transforming the pricing business context which helped in delivering all the pricing projects with quality and timeliness.
  • SAS Campaign Management for Telecommunications gives you a complete picture of your customers, automates complex marketing campaigns and increases their efficiency and profitability.
  • Responsible for deployment, improvement and maintenance of ETL process.
  • Responsible for creating, managing and tuning the ETL repositories.
  • Designing ETL flows using DI Studio3.4
  • Data generation process by writing automated scripts for various generic business scenarios for different SAS Telecom Intelligence solutions
  • Optimization of code for generation of high volumes of telecom data at a grain slightly higher than Call Data Records (CDR)

Company : Target Corp India Pvt. Ltd.

Environment : SAS and Db2

Role : Associate Analyst

Project :1. Inventory Project(Retail)

Inventory turns measure how effectively a retailer can move a product through the supply chain and into the customer’s basket. High turnover of inventory will not only drive sales but will also lower the total cost of carrying inventory.

Environment : SAS BI, Unix, Oracle Database.
Role : Business Analyst.
Project : 2.Pharmacy Drug Movement Analytics

Analyze marketing metrics to identify relationships between marketing actions & financial outcomes by Performing data mining and analyses using a variety of process to identify patterns, trends and/or outliers for stores, coupons & payers for driving negotiations with Third payers to boost reimbursements.

Environment : SAS BI, Unix, Oracle Database, Teradata Role : Lead Developer Project : Pricing Data warehouse Company : Target Corp India Pvt. Ltd. Responsibilities: • Assist in the upstream and downstream data management system and continuing support for good data quality measures • Communicate project status update to management and stakeholders and escalate issues as appropriate. • Preparation of “briefing documents” as needed for discussions with senior stakeholders • Spearheading the pricing (~1000) and comp shop (~1700) control-M job flow which has high visibility

Responsibilities:

• Identify the optimal pack size (for eg: 50X4 pack or 100X2 pack) for each drug and plan inventory for top selling drugs at store level.
• Reduce the service time in pharmacy store by improving the placement of drugs (on the basis of sales frequency) and thus improving the efficiency of pharmacist.
• Understanding the input and output flow, variables, join criteria of the source files for the data to be built.
• Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Oracle database and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Using SAS Options like DROP, KEEP, COMPRESS=, OBS=, etc for efficient programming and storage space saving when needed.
• Creating new segmentation and add factors to score the data.
• Using Proc SQL to create SAS datasets from in-line views using joins and automate the code by embedding in macros.
• Creating pivot tables in worksheet to compare the data using summarized functions to check for any data discrepancies. Working on manipulating data to be used as input to Microsoft Excel.
• Involved in writing Unix shell scripting to automate the SAS jobs.
• Developed and modified existing tables, views, stored procedures, functions, triggers and cursors.
• Created reports in Excel spreadsheets which are capable of doing automatic calculations.
• Developed routine SAS macros to create tables, graphs and listings.
• Extensively used the SET, Update and Merge statements for creating, updating and merging various SAS datasets.
• Participated in user requirement discussions and data quality assessment.

Results:

• Improved Forecast Accuracy
• Decreased Pharmacy Team workload for inventory management