Arvind Sharma

Freelance Programmer & Database Designer

1532
Location:Jaipur, Rajasthan, India
Profile:https://www.freelanced.com/arvindsharma
0
Kudos
3.0
2 Skills
Ask
Rate/Hr
Arvind Banwari Sharma
Sr. Consultant

Asharma2002@gmail.com

Summary
• More than 9+ Years of experience in developing software and working with SAP/Business Objects suite of products like Designing BOBJ Architecture, writing Crystal Reports, Xcelsius Dashboards, WebI, Universe Design for major clients in industries like Retail, Manufacturing, Banking industries.
• Most recent experience includes creating complex Xcelsius Dashboards, WebI, Crystal Reports connecting to WebI, Crystal reports using Live Office, Open Document XML, Web Service and hosted on Business Objects XI 3.1.
• Experience in integration of SAP BW/BI and SAP Business Objects. Hands on experience on installation and configuration of SAP Integration kit. Developed OLAP Universe against Bex queries and reports.
• Excellent exposure on developing Bex Queries.
• Worked extensively in developing and implementing Crystal reports/WebI on Business Objects Enterprise XI, XI REL 2, 3.1, Crystal Enterprise 8.0 thru 10, Business Objects Universe Design, Crystal Reports Explorer.
• Expertise in designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI R2 SP3.
• Worked extensively in developing Procedures, Triggers, Views on database like SQL server 7.0, 2000, 2005, Oracle 9i,10g and Access
• Knowledge of processes like rule extraction, rule analysis, rule flows design.
• Experience in interacting with business users and rules analysts on multiple projects.
• Expertise over preparing report specifications, database designs to support the reporting requirements.
• Excellent knowledge of developing DHTML Web pages using tools like Home site and Dream viewer
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self motivated fast learner and good listener.
• Involved in end to end development of Business Intelligence tool TechAxes.
• Did multiple training assignments for different companies/individuals on Xcelsius (SAP Dashboards), Crystal Reports 2008, BOBJ architecture.
• In-depth knowledge of project management, implementation methodologies, business process re-engineering, as well as a worked extensively in Sharepoint Server, Visio and MS project.
• Lead project teams, provided end-user training, manual preparation and post go-live support.
• Excellent technical, logical, code debugging and problem solving capabilities.
• Excellent communication, interpersonal skills and a team-worker with good customer interaction.

Technical Skills
BI Tools: BO XI R2/R3, Crystal Reports 2008/XI/10, WebI, Xcelsius
Database: SQL Server 2008, 2005, 2000, Oracle10g/9i, MS-ACCESS 2000.
Programming Languages: SQL, PL/SQL, TSQL, Java, C#
Operating Systems: Windows 7/XP/2000/NT, Linux Enterprise 3, UNIX
Version Control: Visual Source Safe, Rational Clear Case

Professional Experience

REI Inc, Kent, WA July 10 to May 11
BOBJ Consultant

Responsibilities:
• Involved in Business Requirement meetings and Documentations.
• Worked with Business Users in designing and finalizing the reports.
• Worked on POSDM, Merchandise and Financial Reports.
• Design and Develop Universes against SAP BW/ Bex query and access data source.
• Report development in WEBI, Crystal Reports and Xcelsius.
• Developed Income statement, Balance Sheet and other financial reports in Crystal reports.
• Extensive use of Breaks, Sections, Filters and extended keywords to generate complex WebI
reports.
• Designed detailed, Cross tab, Charts, Top n, drill down adhoc reports using formulas, functions, Prompts etc in WEBI. Work extensively on extended syntax context operators.
• Developed and Deployed complex Reports. Used multiple data providers, Union, Sub Queries.
• Developed dashboard against Way Point to display the issues tracking in Xcelsius.
• Worked on Bex Queries and analyzer for data verifications.
• Developed MDX in MDXTEST command to verify data. Helped Admin to configure log generation for trouble shooting.
• Worked with BO Admin to assign authorizations and moving objects from different servers with Life Cycle Manager.
• Resolved production issues.
• Trained user on Voyager.
• Involve in organizing and imparting Trainings to Business users.

Technology: SAP Business Objects XI R3.1 SP3, SAP NetWeaver 7.0 with EHP 1, Universe, WEBI, Crystal Report 2008, Xcelsius, WEBI, Voyager, Way Point, Sharepoint Server.

Bank of America Boston Oct 09 to June 10
DW/ Xcelsius Sr. Consultant

The work involves
• Testing Center of Excellence project - Merrill Transition
a. Testing and defect management - Provide consolidated, consistent and detailed data as needed for the tracking and management of an integrated release or high rigor Merrill transition event.
First event June 2010 integrated release
b. Reporting – Provide consolidated management reporting across integrated releases and high rigor Merrill transition events
Use in-place tools where practical
c. Process Challenge – Assure that the consolidated data (Merrill and BAC) support efficient defect remediation, required process metrics, and data consistency throughout
d. Technical challenge – Implement process to extract, convert, consolidate and report test and defect data stored in different quality tools
e. Process should incorporate as much workflow automation as possible.

Responsibilities:
• Involve in Business Requirement meetings and Documentations.
• Point person between Merrill user team and Bank of America Data warehouse offshore team.
• Involved in data modeling and data mapping process.
• Designed and took sign off for end to end solution from data warehouse to end reports.
• Involved in updating ETL Stored Procedures to include Merrill Data.
• Modified Stored Procedures for Script and Defect to populate Fact tables to get the Merrill Script and Defects data in BAC data warehouse.
• Create Stored Procedures to populate Metric Tables for reports in Business Objects.
• Created Complex Views for Business Objects QAAWS which was used for reporting in Xcelsius.
• Created QAAWS to report the data in Xcelsius.
• Involved in development of SAP Business Objects Universe. Created Classes, Objects, derived tables, set cardinalities and their properties. Worked on Hierarchies and List of values.
• Resolved the loops and traps using Aliases and contexts and verified the Integrity of the Universes.
• Designed detailed, Cross tab, Charts, Top n, drill down adhoc reports using formulas, functions, Prompts etc in WEBI. Work extensively on extended syntax context operators.
• Developed and Deployed complex Reports. Used multiple data providers, Union, Sub Queries.
• Created QAAWS to report the data in Xcelsius.
• Involved in development of Merrill TCoE Xcelsius dashboards.
• Resolved production issues.
• Involve in organizing and imparting Trainings to users.

Technology: SQL Server2000/2005, SSIS, SAP Business Objects XI R3.1 Universe, QAAWS, Xcelsius, WEBI, Rational ClearCase, Sharepoint Server.

Cadbury Schweppes plc, Rockford, IL Sep 08 to Sept 09
Business Objects Consultant

Roles and Responsibilities

• Designed Industry standard Business requirement document for the reports and involved in the requirements gathering process for the reporting environment.
• Worked with database team to design the staging tables that would help make ETL process for bringing in the data and getting into data mart efficiently.
• Used Business Object Data Integrator to Create ETL jobs from SQL Server database and would put the data into staging table and transform it further to populate the data mart.
• Worked with Business Users and project manager to develop system requirements, analyze data Element and continuous end-user support.
• Coordinated with the vendors and the project team members.
• Managed a Follow-up Communication Management Process.
• Handled development of full life cycle Business Objects reporting applications.
• Worked on Administration of BOXIR2.
• Worked on BOXI CMC Security setup.
• Involved in Creating Repository, Creating Users and User Groups.
• Developing multiple reports in Crystal XI, Webi.
• Created Universes for report generation using Designer module in Business Objects.
• Created Classes, Objects, cardinalities, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Accessed SAP R3 data and SAP BW Cubes via SAP integration kit connector and deployed SAP reports on CMC.
• Managed different types of reports like Master/Detail, Cross Tab and Charts using Crystal Reports for financial reports like Trial Balance, Balance Sheet.
• Developed adhoc financial reports like Discount and payment trend analysis, late payments, top 25 invoices, aging analysis, top 10 customer by geography etc.
• Developed reports also like Material movements, Inventory, Plant Maintenance reports, sales analysis etc
• Worked on Performance metrics, created dashboard reports as a part of Performance Management team.
• Developed and Deployed complex Reports. Used multiple data providers, Union, Sub Queries and Stored Procedures.
• Created SQL procedures and returned data using ref cursors into crystal reports.
• Configured Dynamic prompts for existing reports according to requirements.
• Deployed Dashboards in an Enterprise Environment using Crystal Xcelsius.
• Extensively used Alerter and filters in reports.
• Worked on Remedy to track user requests and the developed work were well documented using clear case.
• Involved in the preparation of end user training documents and Trained Business users to build WEBI reports from the specified Universes and other aspects.

Technology: Oracle, Data Integrator, SAP Business Objects Universe, QAAWS, Xcelsius, WEBI, Sharepoint Server.

Bradley Corporation, Milwaukee, WI Dec 07 to Aug 08
Business Objects dev

Roles and Responsibilities

• Worked with Business Users to develop system requirements, analyze data Elements
• Developed multiple project plans and identify dependencies, conflicts and milestones.
• Initiated the update process and track progress against timelines.
• Managed project status reports and metric's to senior & project Mgt.
• Involved in building the data repository.
• Designed and Implemented Type 2 methodology for slowly changing dimension to maintain the history data.
• Used Business Object Data Integrator to Create ETL jobs and would put the data into staging table and transform it further to populate the data mart.
• Created Universe level objects and measures using the business rules provided.
• Involved in Administration of Business Objects.
• Maintained user security on the BO Universes.
• Created complex views to overcome loops and contexts.
• Derived Tables are used extensively.
• Used Aggregate awareness in universes.
• Web Intelligence Reports are created and deployed through Info View.
• Complex Crystal XI Summary as well as Detail reports are created based on business request.
• Customized Web I Front end.
• Created Auditor reports and tracked user access of reports and Universes.
• Created Dashboards and Speedo meters for churning analysis-using Xcelsius.
• Customized the dashboards for better manageability of overall performance.
• Extensively used Info view to share the common reports amongst users.
• Configured Crystal Xcelsius to update a model by using the XML Data Button to connect to a custom middle tier Link a model to a live data source using the XML Data Button.
• Follow-up on documentation and conduct project documentation reviews to insure documents created in accordance with the project standards.
• Performed data validation and analyzed test results.
• Maintained and applied patches to Development, UAT and Production Servers and keeping them in sync.
• Involved in creation of End User Training Documents and Manuals and in training.
• Developed an Access database to capture and report project issues and actions
• During the support phase used Crystal Report tool to produce remedy tickets reports.
• Managed and organized required meetings to ensure quick resolution to the high priority Issues

Technology: SQL Server 2005, Data Integrator, SAP Business Objects Universe, QAAWS, Xcelsius, WEBI.

Harbinger TechAxes Pvt. Ltd. Jan 03 – Sept 07
Product Manager/ Sr. Consultant

Roles and Responsibilities
• Responsible for overall development of TechAxes BI tool from requirement analysis phase
• Managed around 40 team members of development and testing team
• Involved in the hiring professionals – final interview
• Shaping up the product through understanding the needs of users and analysis of present BI tools in the market.
• Designed document templates for Development and testing team. Managed them online through Share Point Intranet Site.
• Coordinate Development team, testing team and Consultant team,
• Write product requirements document (PRD) and product roadmap – extensive use of Visio and MS Project
• Write test plans as per PRD passed it to testing team, track the results.
• Maintain different versions of product and ensure everything be in sink.
• Involved in the Product Technical Demos
• Assisting Consulting team in building Prototypes and final implementation of the Product at Client site
• Design & develop DTS mechanism & Excel loaders for data input
• Involved in various projects on Business Objects, Microsoft Sharepoint Server and Microsoft Exchange Server

Product: FinanCo (Financial Consolidation & Analytics Point Solution)

Technology Used: TechAxes BI Platform, MS SQL Server 2005, Asp.Net, Flash, MS Reporting Services

Role and Responsibilities
• Analysis of the various industries Chart of accounts (Financial accounts) for the standardization of the accounts, so that company will follow standards as per companies act 1956 (schedule 6 format)
• Meta data creation
• This project is an endeavor to develop a point solution for providing an analytical tool to help companies in the Financial Consolidation process
• Overall Project Management, leading a team of 5 members
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Administrating the Metadata creation and loading including Business Rules, Dimensions, and Web Based Templates.
• Reports visualization & document preparation.
• This model includes schedule VI format reports, analytical dashboards and scorecards

Data Modeling: TechAxes BI suite, Business Objects, Sharepoint Server 2007 - Atlas Service Link, Dallas

• This project was to install, configure and integrate Business Objects and SharePoint Server 2007 and to create Data Mart and develop financial reports with universe.

Technology Used: Windows Server 2003 environment, Business Objects, MS SQL Server 2005, Sharepoint Server 2007

Role and Responsibilities

• Overall Project Management, leading a team of 6
• Client Interaction and coordination.
• Involved in the installation, configurations and integration of Business objects and Sharepoint Server.
• Involved in the assigning authentication and authorization of users through AD.
• Prepared Business Requirement Documents.
• Based on financial reports involved in the process of creating universes
• Involved in the authoring repots in WebI and published in the Sharepoint Server
• Metadata creation and loading.
• Reports visualization & document preparation.
• Involved in the End user training.

Data Modeling: Cement Demand & Utilization Prediction using TechAxes BI Tool - Predicting the Cement Demand in the various markets & Capacity Utilization for various plants. Also calculate the Market Share of each Plant in the different markets. – Dalmia Cemant, New Delhi

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services

Role and Responsibilities
• Overall Project Management, leading a team of 4
• Requirement Gathering
• Metadata creation and loading
• Data Validation
• Reports visualization

Data Modeling: Cement Demand & Dispatch Analysis using TechAxes BI Tool - Analyzing the Cement Demand & Dispatch by Region, State or by Group, Company, by Plant on Monthly, QTD & YTD wise. We also calculate the Market Share of each State and Group in the particular Market. We also analyze plant capacity and capacity utilization during the Year. - Dalmia Cemant, New Delhi

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

Role and Responsibilities
• Overall Project Management, leading a team of 4
• Requirement Gathering
• Metadata creation and loading
• Data Validation
• Reports visualization

Data Modeling: Financial Consolidation & Analytics using TechAxes BI Tool - Dalmia Cemant, New Delhi

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

• Was a member of steering committee and the point person & account manager for this client (Dalmia Cement, New Delhi) since the inception of the project till completion.
• This Analysis could enable client to load data of different subsidiaries & consolidate on a holding company. All complex business rules were built in the Metadata. Management and statutory reporting is achieved for consolidated level as well as at each subsidiary level.

Role and Responsibilities
• Overall Project Management, leading a team of 5
• Capturing the Requirements from Client.
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Administrating the Metadata creation and loading.
• Reports visualization & document preparation.

Data Modeling: Store Credit Card Analytics using TechAxes BI Tool – GENPACT, Banglore

• Store Credit Card Analysis could enable user to compare and rank sales figures, quantities or profit margins, by customer, salesperson, product or product line, YTD, MTD or current to previous year— with hundreds of possible variations. This tool could be used to evaluate products and salespeople, determine which ones are contributing most to overhead and profit. Historical sales reports could also be produced for use in future planning.

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

Role and Responsibilities
• Overall Project Management, leading a team of 5
• Capturing the Requirements from Client.
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Metadata creation and loading.
• Reports visualization & document preparation.

Data Modeling: Insurance Policy Analytics using TechAxes BI Tool – Mahendra Kotak, Mumbai

• Analyzing the Life Insurance Business and identifying the KPI’s and built the model. This model enables the users to analyze the Premium, Sum Assured, & No. of Policies by each Agent, Manager, Branch up to Head Office. Various management reports could be produced along with one statutory report for IRDA.

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

Role and Responsibilities
• Overall Project Management, leading a team of 3
• Capturing the Requirements from Client.
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Metadata creation and loading (ETL).
• Reports visualization & document preparation.
Data Modeling: Sales Analysis (Heavy Vehicles) using TechAxes BI Tool

• Analyzing the Business Process of the client and identifying the KPI’s. This model enables the users to analyze the Sales figures by Branch, SBU, Marketing Unit up to Head Office. Various management reports could be produced.

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

Role and Responsibilities
• Overall Project Management, leading a team of 4
• Capturing the Requirements from Client.
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Metadata creation and loading.
• Reports visualization & document preparation.

Data Modeling: Agent Analytics using TechAxes BI Tool – GENPACT, Banglore

• This project was aimed at helping the client – A well known BPO, to analyze the performance of the agents working in their Loan Auditing Process. TechAxes helped this client by providing a full blown solution for data capturing & reporting on required KPIs.

Technology Used: TechAxes BI Platform, MS SQL Server 2005, MS Reporting Services, Flash, ASP.NET

Role and Responsibilities
• Overall Project Management, leading a team of 3
• Client Interaction and coordination.
• Capturing the Requirements from Client.
• Analyzing the requirements & coming up with design alternatives.
• Designing the Data Model including Analysis Dimensions & their properties as per the requirements.
• Metadata creation and loading.
• Reports visualization & document preparation.

EDUCATION
MS, Rohtak, India
Skills (2) Rating
Programming
Database Design