Venkateshwar Reddy Chilukuri ******.*********@*****.***
Professional Profile:
• 1.11 years of IT experience and development in SAP BO Crystal Xcelsius dashboards for Financial, Banking, Insurance, Manufacturing and Healthcare industries.
• Experience in Business Intelligence Tools like Crystal Xcelsius 4.5, Xcelsius 2008, and Crystal Reports XI, Business Objects XIR2.
• Knowledge on Data Warehousing Concepts and writing SQL Queries.
• Expertise in Analysis Design, Development, Testing and Data Connectivity through database, xml, live office, QAAWS, Web services.
• Hands-on experience in creating Interactive Dashboards using Xcelsius.
• A dedicated individual with excellent communication and interpersonal skills, and the ability to interact with individuals at all levels.
• Good Team Player and Active Listener.
Professional summary:
• Jun - 2010 – To Date: Working as a Software Engineer in BIR solutions INDIA Pvt. Ltd, Hyderabad
Educational Summary:
• Bachelor of Technology from JNTU.
Technical Skill Set:
Operating Systems : Win 2K Series / XP
Database : SQL, Oracle 8i, 9i, 10g
BI Tools : Crystal Xcelsius 4.5/Xcelsius 2008,
Crystal reports XI, Business Objects XIR2
Project Details:
Project#1:
Project Name : Global VBU Marketing Dashboards
Period : May -2011 to till date.
Client : SAP, Canada
Team Size : 2
Role : Team Member (Xcelsius Developer)
Environment : Xcelsius 2008, Excel 2003
Description:
SAP is the world's Leader in Collaborative business software. SAP Marketing Department has requested us to create a dashboard with their internal email marketing Data. This Dashboard is meant for SAP Sales Head & Senior Sales Managers to track the web Inquires, Leads and Sales Performance by Region, Product and Time along with evaluation copies download summary. Requirements are gathered from various people of SAP Marketing Department and Dashboard is developed by using different major KPIs like "Unique Visitors", "Responders", "Revenue by Electronic Downloads/ CDs", "Impressions, Clicks, Opens, CT%, Open%, CPC, Name Capture%" etc. Also provides a section for Campaign Analysis to analyze Campaigns data in different ways.
Responsibilities:
• Responsible for the logical design of the dashboard.
• Responsible for the Development of the Dashboard.
• Responsible for preparing the style guides
• Responsible for the unit testing & Data Validations of the dashboards.
Project#2:
Project Name : Loss Prevention Dashboards
Period : Mar -2011 to May -2011
Client : PETCO, USA
Team Size : 3
Role : Team Member (Xcelsius Developer)
Environment : Xcelsius 2008, Excel 2003
Description:
PETCO is a chain of retail stores that offers pet supplies and services such as grooming and dog training.
The main aim of this Project was to know the active and closed petco stores information. This dashboard gives complete analysis on Trend of Inventory Adjustment as a %
To perpetual inventory of individual store by fiscal month and also comparison of this trend to the Average of Regional Trend and Average of Country Trend. This Dashboard gives the information of the Best 10 stores by Shrink (%), Worst 10 stores by shrink (%) by region.
.
Responsibilities:
• Involved in analyzing the client Requirements.
• Involved in preparing the Dashboard specification Documents.
• Involved in conceptual design of the dashboard.
• Involved in Data connectivity to the data bases by using different methods like WSDLs,
XML Buttons, Live Office Buttons, XML Maps and Flash Variables.
• Conducted Unit Testing of the dashboard.
• Involved in performance tuning of the Dashboard.
• Involved in Resolving the Data Connectivity Errors.
• Involved in Designing of the Dashboard according to color guide given by client.
• Involved in Change Requests of the Existing Dashboards.
• Involved in writing Complex formulas in excel sheet to solve client requirement.
*** I can handle all type of development problems in creating dashboards. I can say this is my speciality.