SUMMARY

• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).
• Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
• Created Analytical Privileges and Procedures for modeling
• Good understanding of various components of SAP HANA.
• Overview working knowledge with SAP BO Data services & SLT replication methods.
• Designed and Created Universe for reporting from Information models.
• Expert in SAP Business Objects XI4.0/XIR3/XIR2/6.X Web Intelligence, Crystal Reports, XCelsius Dashboards.
• Expert in using Business Intelligence Tools like Business Objects XI 4.0/XIR3/XIR2/6.X to build complex Universes and Reports, Charts on multiple databases (Data Providers) and experience in development, testing and implementation.
• Experience in building and designing Universes based on user requirement and converting the existing .unv universe to .unx format.
• Knowledge of Informatica Power Center to filter and transform the required data.
• Experience in working with Business Objects modules like CMC, CCM, Information and Universal Design Tools, Info - view, Web Intelligence, Import Wizard, Publishing Wizard, Supervisors and Broadcast Agent etc.
• Expert in Identification of Business & Data requirements as well as converting them into conceptual & logical data models. Experience in Dimensional Data Modeling (Star Schema).
• Created and Maintained complex universes that supporting multiple levels of hierarchies for drill down and drill across reports.
• Experience in Creating and maintaining Repositories, Folders, Groups, Users and Assigning privileges to users.
• Extensive hands on experience in Business Objects Reporting functionalities such as Aliases, Context, Slice and Dice, Drilling Methodology, Filters, Sorts, Ranking Sections, Graphs, Query Prompts and Breaks.
• Specialized in creating complex query reports using Oracle, SQL Server, MS Access and various RDBMS.
• Involved in planning sessions with project managers to analyze requirements and outline the solution.
• Performed Architect roles like Design, Development and Implementation.
• Involved in full life cycle of Business Objects Implementation.
• Developed Complex Reports using WEBI against OLAP Universes.
• Developed Complex Reports using Crystal Reports against SAP and non-SAP databases.
• Developed Complex Interactive Dashboards using Xcelsius with Line, Bar, Combination Charts, Selectors for What-If Analysis.
• Created new Profiles, Users, Groups and Custom Calendars, Events in CMC and Scheduled Reports based on Events and Calendars in CMC.
• Provided Security to Folders, Universes and Reports according to the User rights.
• Extensive experience in working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Ability to work effectively in a team as well as individually with excellent communication and interpersonal skills. Also has an ability to develop creative solutions for challenging client needs.
• Customization experience in various areas of IMG activities of SD module including organization structure, Logistics general, Logistics Execution.
• Worked on all major areas of SD including Organization Master, Customer Master and Document Master Data.
• Configured sales documents, billing documents and delivery documents, as well as configure copy control process between these documents.
• Configured pricing procedure by maintaining various condition tables and condition types.
• Worked on output determination and availability check.
• Configured Partner types, roles and its integration with SD account groups.
• Mapping the business process in line with the SAP functionality.
• In depth knowledge about SAP Roll out projects.
• Good understanding of ASAP implementation methodology.

PROFESSIONAL EXPERIENCE

SAP HANA Developer

Confidential, Cincinnati

Responsibilities:

• Good understanding of various components of SAP HANA.
• Worked on creating Attribute Views, Analytic Views & Calculation Views
• Provided guidance and advice to SAP Customers, Pre-sales and Solution Architect resources on the development of HANA solutions.
• Translated business requirements and high level designs into a suitable technical design using HANA.
• Determined the size and scope of technical developments for HANA projects.
• Identified the skills, roles and capabilities required to deliver the technical elements of projects and estimated the required effort.
• Leveraged knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Performed UNION & INTERSECTION between views to represent business cases.
• Expert in understanding of the complete Architecture(Database, Data loading, Data modeling & Administration)
• Good working knowledge of SAP BO Data services & SLT replication methods.
• Connected to IMCE from Reporting tools through Universe and direct interfaces to generate the reports
• Created & designed Universe for reporting from Information models
• Provided knowledge transfer to IT staff.
• Developed and foster a collaborative working relationship with clients.
• Worked collaboratively with project managers, SAP Offshore Consultants and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

Environment: SAP HANA-1.0, Business Objects Enterprise XI4.0/XI3.1 (Designer, WEBI), Information design tool, SLT replication Server, Oracle-11 G, Rational Clear Quest, Introscope, SVN.

SAP BO consultant

Confidential, Virginia

Responsibilities:

• Involved in planning sessions with project managers to analyze requirements and outline the solution.
• Performed Architect roles like Design, Development and Implementation.
• Involved in full life cycle of Business Objects Implementation.
• Involved in configuration of BW Objects like Info Cubes, Info Sources, Data Source, and Data Store Objects.
• Worked on BEx Query Designer, Calculated and Restricted Key figures, Exceptions and Conditions.
• Built the Universes as per the requirements by identifying the required tables.
• Developed Complex Reports using WEBI against OLAP Universes.
• Developed Complex Reports using Crystal Reports against SAP and non-SAP databases.
• Developed Complex Interactive Dashboards using Xcelsius.
• Developed Complex Reports such as Sub Reports, Drill Down, Drill Up, Shared Variables and Multiple Data Sources using Crystal Reports.
• Developed Interactive Dash Boards with Line, Bar, Combination Charts, Selectors for What-If Analysis.
• Created new Events, Folders, Profiles, Users and Groups in CMC.
• Created Custom Calendars, Events in CMC and Scheduled Reports based on Events and Calendars.
• Provided Security to Folders, Universes and Reports according to the User rights.
• Defined Custom Hierarchies in Universe Designer as per the business rule for the reports to be viewed at selected reporting level.

Environment: SAP Business Objects Enterprise XI4.0/XI3.1 (Designer, WEBI), SAP BI 7.0, Information design tool, Crystal Reports, Xcelsius, SQL Server 2008, Oracle-10 G, BEx (Analyzer, Browser), Rational Clear Quest.

SAP BO consultant

Confidential, Indianapolis

Responsibilities:

• Involved in planning sessions with project managers, business analysts and team members to analyze requirements and outline the solution
• Performed Architect roles like Design, Development and Implementation.
• Involved in full life cycle of Business Objects Development.
• Developed Report Template Design documents.
• Developed Complex SQL stored procedures for report development.
• Built the Universes as per the requirements by identifying the required tables.
• Developed Complex Reports using WEBI.
• Developed various DESKI Reports and created publications to distribute the reports to different Users.
• Developed Complex Reports using Crystal Reports.
• Developed Complex Interactive Dashboards using Xcelsius.
• Developed Complex Reports such as Sub Reports, Drill Down and Drill Up using Crystal Reports.
• Developed Interactive Dash Boards with Line, Bar, Combination Charts, Selectors for What-If Analysis.
• Created new Events, Folders, Profiles, Users and Groups in CMC.
• Created Custom Calendars, Events in CMC and Scheduled Reports based on Events and Calendars.
• Provided Security to Folders, Universes and Reports according to the User rights.
• Defined Custom Hierarchies in Universe Designer as per the business rule for the reports to be viewed at selected reporting level.
• Exported Universes to the Repository to make Resources available to the Users.

Environment: SAP Business Objects Enterprise XIR2/3.1 (Designer, WEBI, DESKI), Crystal Reports, Xcelsius, SQL Server 2005/2008, Oracle, PL/SQL, Data Services (Data Integrator / Data Quality), Rational Clear Case, Rational Clear Quest.

SAP SD ERP consultant

Confidential

Responsibilities:

• Worked on all major areas of SD including Organization Master, Customer Master and Document Master data
• Configured sales documents, billing documents and delivery documents
• Configured Copy control process between various documents
• Configured pricing procedure by maintaining various condition tables and condition types
• Worked on output determination
• Worked on availability check
• Configured Partner types, roles and its integration with SD account groups
• Mapping the business process in line with the SAP functionality.
• Make configuration changes, requested as per change in business process
• Interacted with key business users to understand the business scenarios.
• Developed business blue prints.
• Prepared Functional specifications.
• Debugged the SAP tables like MARA, VBAK, VBAP, LIKP, LIPS, VBRP,VBRK etc.

Environment: SAP ECC-6.0, Sales and Distribution, Oracle 9