Engineer Sales

Summary

• Working as BI Developer, demonstrated experience in requirement gathering, specification and executing it

• Expertise in SAP BO Suite 6.5/3.1 including BO Universe, WebI, Xcelsius, CMC plus SAP BW and BO integration

• Expertise in Mobile Dashboards using tool – RoamBI

• Hands on work experience in Microstrategy 9.2

• Familiar with ERP (SAP) package (Material Management, Production Planning, Sales and Distribution)

• Expertise in Data Analysis, Data Visualization and Dashboard development

• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals

at all levels.

• Outstanding work ethic, time management skills and consistent team player.

Educational Qualification

Master of Science, Mechanical Engineering, Villanova University, PA Aug. 2005- May 2008, GPA - 3.8

Bachelor of Mechanical Engineering, S.G.S.I.T.S, India July 2000 - June 2004, GPA - 3.83

Professional Experience

Sr Dashboard/BI Developer – Apollo Group, Phoenix, AZ Oct 2010 – Present

• Gathering Business requirements and coming with better design both visual and data backend including interaction with dba’s and modelers for fine tuning of tables and marts for better analysis and performance of BI delivery.

• Developing POC’s and white board sessions with business for analytics and serving it as requirement for modelers saving BI sprint delivery time.

• Supporting daily BO ad-hoc requests from users including adding /editing dimensions, filters, measures etc. in universes.

• Developing projects in Microstrategy including schema objects, application objects and dashboards

• Replaced live office connectivity, QAAWS dashboard with InfoBurst cache.

• Created weekly BO Webi reports for the executives.

• Involved in BI tool evaluation process to come up with analysis for best suitable BI product based on current IT Infrastructure and Business needs.

• Full lifetime projects on Xcelsius dashboards that included interaction with Mart designers, ETL Team and Business Users using AGILE methodology and earlier SDLC.

• Involved in Universe design and subsequent changes including adding new dimensions and objects to the model.

• Created Xcelsius dashboards which are getting feed from more than 50 queries at a time that included better triggering mechanism with several slice & dice & multiple levels of drill down with Alerts and several filtering parameters.

Senior Technical Analyst – InfoSol Inc., Phoenix, AZ Nov 2007 –Oct 2010

Expert in data analysis, representation, KPI analysis, technical support and training to Clients

• Data integration with Infoburst to do analysis of data pertaining to production flow

• Created Universe, reports and dashboards based of SAP BW using BEx query and implemented live dashboards, reports using it as the data source

• Analysis of inventory data to determine pricing and sales for SAP BO product Suite

• Created several webi reports and universes

• Created live connected Xcelsius dashboards which are getting feed from several data sources like webi, QAAWS, live office, Flash Variables, XML and SQL queries

• Created RoamBI mobile dashboards for IPad/IPhone delivery for executives

• Expertise in data analysis and visual representation

• Hands on training to customer by understanding there process flow and providing them inputs to maximize the output

• Dashboard, reporting and data analysis for several companies including fortune 500’s like Rockwell Collins, Mckesson, SAP

• Assisting other consultants in the area of expertise

Process Engineer – ICI America (Partner of InfoSol Inc), Phoenix, AZ Sept. 2008 – March 2009

• Dashboard analysis to pass on the key parameters affecting the process

• Created reports, universe and dashboards for analysis of data using SAP BO 3.0

• Gathering the process requirement and understanding the factors affecting the cycle

• Ensuring that all aspects of an operation or process meet specified regulations

• Managing the cost and time constraints of projects

• Got reward for the dashboard created for one of our customers which had 8 levels of drill down

Process Analyst – Take Solutions Inc. (Partner of InfoSol Inc.), Princeton, NJ Nov. 2007 – July 2008

• Gathered information (requirement), created report specifications.

• Interacted with Business Users, Business Owners to reviewing existing data to see if more research and information needs to be collated

• Created dashboard to see what parameters are affecting the process

• Provided the what-if-analysis on the KPI’s of the process to maximize the process output

• Created deliveries and invoices including route determination documents like, Item/Product Proposal, Item Categories, Quotations, Enquiry, and Orders.

Business Development Executive- HCL Infosystems Ltd., Delhi, India July 2004 – July 2005

India’s leading hardware manufacturing company, with a complete solution provider for computer and networking (sells more than HP and IBM in PC segment).

• As a business development executive, managed a team of four people, and through team effort increased sale by 6.6% in first quarter year.

• Functional experience of SAP (ERP) in the areas of production planning, material management, sales and distribution.

• Created deliveries and invoices including route determination documents like, Item/Product Proposal, Item Categories, Quotations, Enquiry, Orders, Inbound and Outbound Deliveries, Shipping, Billing, and Contracts.

• Integrated systems and processes through the supply chain to share valuable information, including demand signals, forecasts, inventory and transportation etc.

• Achieved a break through by converting a large account into company’s favor.

• Outstanding success in building and maintaining relationships with key corporate decision makers.

Academic Experience -

Graduate Research Assistant (GRA), Villanova University-Thesis (funded by U.S.Navy). Dec. 2005 – May 2008

• Kinematic and dynamic analysis of Unmanned Surface Vehicle and extend it to set point control, trajectory control and obstacle avoidance, with single controlled input

• Vibration analysis of sports grips.

Internships

Tata Motors Ltd., Delhi, India - Intern Engineer June 2003 - Aug 2003

• Conducted lab testing trough UTM (Universal Testing Machine).

• Prepared figures, data and models for different part of Light Commercial Vehicles and trouble shooting.

• Coordinated safety duties.

• Created Item proposals, bill of material for different material combinations that were frequently ordered and delivered in certain quantities.

Software Skills

SAP Business Objects Suite 3.1 (Universe, WebI, CMC, Crystal Xcelsius), Infoburst, SAP (SD, PP & MM), FORTRAN, MS Office, Solidworks, PL/SQL, SQL Server 2008,MATLAB, Win 2000, 2003, NT, XP, familiarity with QlikView, Corda, SSAS and Microstrategy 9.2

Awards and Achievement

• BO Xcelsius, BO WebI and RoamBI certified

• Several appraisals and rewards from customers regarding data analysis, dashboards and visual representation

• President of the student council, S.G.S.I.T.S, Indore, India. July 2003 -2004

• Secured first rank in 5th, 6th and 7th term during B.S (mechanical eng.), S.G.S.I.T.S, Indore

Contact

Mayank Jain

Email: ************@*****.***

Cell: 650-***-****

Blog: http://mayankjain13.blogspot.com/

Contact this candidate