Ranjeet Sridhar

Certified SAP / PMP Professional, SAP Consultant with 7 years experience

• Objective: Establishing my organization as a profitable Multi-National Corporation as well as achieving the privilege of listing my organization on the New York Stock Exchange, by efficiently using my extensive IT and SAP knowledge and skills as well as integrating and utilizing organization’s human resources.

• Work Exposure: Application of IT Software & Hardware Programs / Systems (7 years) w SEM / BI-IP / BIW (2.5+ years) w BI 7.0 (1+ years)

• SAP Certified Professional on SEM 4.0 and ABAP/4
• Certified PMP – Project Management Professional from PMI, USA
• OCP - Oracle Certified Professional in Oracle 9i DBA
• MCAD - Microsoft Certified Application Developer
• SCJP - Sun Certified Java Programmer

iFactorZ Inc. – Atlanta, GA (USA)

CEO (July 2008 to Present)

Job Profile:

• Managed the day-to-day activities of iFactorZ from the role of the CEO.

Infocus Tech Ltd. – Atlanta, USA

SAP Consultant (Jun 2007 – July 2008)

Implementation of SAP BI-IP (Dec 2007 – Jul 2008) Client: Beam Global Spirits and Wines (JIM BEAM), Chicago, IL
Technology: SAP ECC 6.0, BI 7.0, BI – IP
Role: SAP BI IP Consultant
Responsibilities:

• Created Planning Cubes, Planning Areas, Multi planning Areas to plan on more than one planning areas. Created Data Slices to restrict simultaneous User access for the same planning char combinations. Worked with Variables to reduce the customizing. Used Characteristic relationships for validations and derivations when generating transaction data for Char value combinations. Created different planning levels based on the level of detail planning. Created Planning Packages. Worked with Different Planning Functions
• Created customized BI reports
• Involved in gathering of requirements from Business users and developing the functional specifications and participated   in system analysis and design – pricing reports for ECC.
• Extensively worked on CO_PA Extractors, Open hub destinations, Shipments and Depletions data,  AS/400 Customer and Material Master data and Classification Masterdata.
• Generated the data source 1_CO_PA1002000 (IBeam Shipments) for Spirits which is IBeam System where Operating concern is 2000 and Client 100.
• Generated other CO_PA data source 1_CO_PA_400US10 (BWE Shipments) for Wines which is BWE system and Client 400 and Operating Concern US10.
• Worked extensively on BEx query designer and developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized to give detailed levels of information.
• Worked on Performance tuning of queries, creation of aggregates, roll up of aggregates, PSA issues and data validation.
• Developed Billing and Pricing info objects and used info objects to create custom DSOs and update the information into custom Info Cubes – right from design, enhancements to data sources to accommodate relevant /required information both for the S&D data sources.
• Developed Aggregation Level, filters, packages, functions, input template, execution with trace, sequences as a trial to demonstrate to Client – aspects of IP – carried out allocations, distribution, copy, reposting, delete in sales planning.
• Developed customized info objects for flags and pricing information and created transformation and data transfer process.
• Developed start routines and end routines and used applied constants, subroutines in transformations.
• Developed multi cubes which interacts with basic cubes with identification.
• Involved in dropping the secondary indexes before loading master data and created the secondary indexes and compressing the info cubes.
• Involved in creating the data sources for custom based requirements on business needs and development of custom DSO, info cube to extract the data at segment level.
• Involved in batch scheduling of jobs for updating info cubes with live data and program with process chains.
• Developed queries for open sales orders, sales orders for sales office, region, month. 
• Development of queries and reports using BEX analyzer, Query Designer.
• Assigned queries to users, relevant authorizations, transports for all objects relevant including BEx reports.

Implementation of SAP BI IP (June 2007 – Nov 2007) Client: Lenovo International, Beijing, China / Raleigh, NC, USA / Toronto, Canada
Technology: SAP BI 7.0, SAP ECC 6.0, ABAP/4, BEx Report, Windows
Role: SAP BI IP Consultant
Responsibilities:

• Requirements gathering from Business community working in close proximity with BT and developing the functional specifications and participate in system analysis and design – Pricing Reports for ECC and CRM.
• Developed Billing and Pricing Info Objects and used Info objects to create custom DSOs and update the information into custom Info Cubes.
• Developed Aggregation level, filters, packages, functions, input template, sequences as a trial to demonstrate to Client – aspects of IP – carried out allocations, distribution, copy, reposting, delete in Sales Planning
• Developed Customized Info Objects for flags and Pricing information and created transformation and data transfer process.
• Developed Start / End routines & used applied constants, subroutines in transformations and also Multi cubes which interact with basic cubes with identification.
• Developed Logic to arrive at the pricing reports arrived at from various complex pricing procedures both in ECC S&D and CRM – Opportunities with different types involved including Sales Agreement, Sales Contract, Spot Quote, Back End Bid both price based and discount based.
• Involved in dropping the secondary indexes before loading master data and created the secondary indexes and compressing the Info Cubes.
• Involved in creating data source for custom based requirement on business needs and development of Custom DSO, Info Cube to extract the data at segment level.
• Involved in Batch scheduling of jobs for updating Info Cubes with live data and program with process chains.

Sacred Infocom Pvt. Ltd. – Chennai, India

Project Manager (Feb 2007 – June 2007)

Job Profile:

• Led teams as per project requirement and conducted feasibility study, designed System Architecture and responsible for Technology Selection.
• Involved in the Project Development, System Implementation, Documentation and conducting In-house Training.

Achievements:

• Successfully completed the 4 Projects and coordinated with upper management to develop plans for off-the-shelf sellable projects.
• Convinced management to pursue a SAP Project (Lenovo Intl. working on BI-IP) on a profit-sharing basis.

Projects:

• Bill Board Junction
• College Chanakya
• Enterprises Document Management System
• HR Toolbar

Infocus Tech Ltd. – Atlanta, USA

SAP Consultant (Dec 2004 – Aug 2006)

Projects:

Implementation of SAP SEM (Jan 2006 – Aug 2006) Client: Callaway Golf, Carlsbad, CA, USA
Technology: BW 3.5, SEM 4.0, SD, BEx, WAD, Reporting Agent, Report Painter, Windows NT, BI 7.0
Role: SAP SEM Consultant

Responsibilities:

• Involved in implementation of SEM-BPS, including conceptualizing and building the Planning areas, Planning levels, Planning packages, planning functions and planning folders relating to Manufacturing cost planning for COGM and COGS.
• Extensively worked with Planning Areas, Multi-Planning Areas, Planning Layouts, Planning Levels, Planning packages, Manual Planning, Manual and user defined functions, Planning Profiles, Planning sequences, Planning environment and Data Slices using characteristics relationship, BPS security authorizations, Formula Extensions (FOX) and hierarchy variables.
• Worked extensively in creating both Static and Dynamic Reports as per the requirement and developed front-end queries using Query Designer & Web Application Designer (WAD) and publishing results on the web.

BI-IP

• Performed a comparative study on the effectiveness of BPS vs. BI-IP and study of functional capabilities of the MySAP Business Suite CRM solution, depicting process flows across the various software components especially with BI-IP implemented.
• Worked on preparing materials for the business users in simple business English on the differences between using BPS and BI-IP.
• Aided the business users to make an expert decision on the usage of BPS/BI-IP and CRM through presentations and demonstrations of sample scenarios.
• Sound knowledge in Real Time Cube, Standard Cube, MultiProvider, InfoProvider, Planning Modeler, Aggregation level, Filter, Input Ready Query, Web Application Designer, broadcasting in Portal.

Implementation of SAP SEM / BW (Jul 2005 – Dec 2005) Client: Hill’s Pet Nutrition, Topeka, KS
Technology: SAP R/3 4.7, BW 3.5, SEM-BPS 3.5, BEx, SAP WAS 6.20, EP 5.0, Oracle 8i, Windows / UNIX
Role: SAP SEM / BW Consultant
Responsibilities:

• Implemented and worked with the integration of SAP BW & SEM BPS in planning, reporting and simulation based on the user requirements.
• Design and use of Basic & Transactional Info-Cubes for actual / plan data comparisons.
• Extensively worked with SEM-BPS statistics to tune BPS performance and also modeled and analyzed SAP-BW cubes for SEM-BPS.
• Extensively worked with Planning Areas, Multi-Planning Areas, Planning Layouts, Planning Levels, Planning packages, Manual Planning, Manual and user defined functions, Planning Profiles, Planning sequences, Planning environment and Data Slices using characteristics relationship, BPS security authorizations, Formula Extensions (FOX) and hierarchy variables

Implementation of SAP BW (Jan 2005 – Jul 2005) Client: Hershey’s, PA, USA
Technology: SAP BW 3.1C, SAP R/3 4.6C, ABAP/4, BEx Report, Windows
Role: SAP BW Consultant
Responsibilities:

• Analyzed business reporting requirements that satisfy with SAP Business Content and installed the necessary objects for Business Content Cubes.
• Extracted data from FI, SD, MM, CO-PA, PM and QM modules of SAP R/3 and from flat files into SAP BW system using Generic, LO and CO-PA Extractors.
• Created ODS for Release Cost Estimate Summary, Cost components being summarized at material level.
• Used LO method for extracting logistics related data into BW. Extracted data from MM module and uploaded into Purchasing Data, Vendor Evaluation.
• Extracted data into COPA Info Cubes for Profitability Analysis and reported using BEx to retrieve top customers, most profitable products and best performing profitability segment.
• Established periodic data loads from R/3 full/delta enabled and legacy system (flat files) containing certain customer information and enhancement of extract structure.

Nelcast Ltd. – Chennai, India

Junior Executive (Feb 2003 – Dec 2003)

Job Profile:

• Responsible for preparing Financial Statements, carried out clerical work in the finance department and assisted the IT department for Computer Maintenance.

Scigenics (India) Pvt. Ltd. (Jan 2000 – Dec 2002)

Job Profile:

• Joined as a Trainee Financial Executive, involved in preparation of the Financial Statements and carried out various clerical jobs in the finance department.

Projects:

• Organization Computerization

Role: Project Manager
Responsibilities:

• Conducted feasibility study & quality assurance testing, designed the Computer Network, implemented LAN, provided in-house training to staff and prepared detailed documentation.
• Sales and Logistics

Role: Team Lead
Responsibilities:

• Conducted a detailed study of the organization, analyzed Sales / Distribution Contract & demand trend in the past and prepared probable future demand.
• Conducted a Market research to arrive at logistics vendors, requested for bids from various vendors and submitted detailed documentation to the Top Management.

MAIS - Masters of Accounting & Information Systems (Accountancy & IS), Middle Tennessee State University, USA (2006)
PGDFE - PG Diploma in Financial Engineering (Financial Engg), LIBA, Chennai (2004)
Bachelors of Information Technology (IT), IGNOU, Madras (2003)
HND - Higher National Diploma in Computing & Multimedia, Edexcel, UK (2002)
B.Com (Accounting), Madras University (2000)

Attended Trainings on BI-IP (BI 7.0) Training in SAP Labs, India (Nov 2007)
Undergone Internal Training on FI/CO ~ ABAP (OOPS Concepts) ~ BW & SEM from Bigtec Pvt. Ltd.

Date of Birth: 5th May 1983 w Languages Known: Fluent in English, can read French and speaks Tamil
Certified Yoga Teacher and a Meditation Teacher
Networking: PMI Member / IMA Member / ISACA Member
Maintaining a personal website – www.ranjeetsridhar.com

- Excellent References will be furnished on request -