SUMMARY

• 10 years IT experience
• Expertise in SAP Business Objects 4.0/XI R3/R2/R1/6.5/6.1/5.1
• Exposure to Web Technologies
• Experience in Desktop Support
• Hands-on experience in OpenCart and E-Commerce Website Development
• Strong background in Project Management
• Experience in E-Commerce Business and Management

• Very good understanding of Datawarehouse Concepts, Data Modeling, and Reporting.
• Efficient in SQL Queries and Stored Procedures
• Established Analytical Capabilities with Good Problem Solving Skills.
• Excellent Communication, Resolution and Documentation Skills
• Good Team Player with Organizational and Project Management skills
• Capable of Working in a Team and/or Individually with minimum supervision
• Self-Motivated. and Result-Oriented
• Flexible and versatile to adapt to any new environment
• Strong desire to keep pace with Latest Technologies

TECHNICAL SKILLS:

Business Objects Tools: Business Objects XI R3/R2/R1/6.5/6.1/5.1, Web Intelligence, Broadcast Agent, Application Foundation, Enterprise Performance Management, Desktop Intelligence, Crystal Reports XI, CMC, CCM, Crystal Xcelsius, Live Office

E-Commerce Tools: OpenCart

Database s : DB2, ORACLE 10g/9i/8i, MS SQL Server 2000/2005, MySQL, MS Access

Web/Application servers: IIS, Apache Tomcat

Data Modeling: Star Schema, Snowflakes Modeling

Programming Languages: SQL, PL/SQL, Fortran, Pascal, HTML 4, ABAP/4

Platforms: Windows 95/98/2000/2003 /NT/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Lead

• Worked with business analyst on user requirements and wrote functional and technical requirements documents.
• Modified and enhanced existing universes, and implemented aggregate awareness
• Created complex Webi and Crystal reports according to user requirements
• Created corporate dashboards to display KPI reports.
• Validated report data through datamart and Sales Page CRM front end and back end database.
• Migrated reports, dashboards and universes from Development environment to QA, Staging and Production environments.
• Mapped Windows Active Directory groups and users to Business Objects and set up Single Sign On.
• Created and maintained users, groups, folders in accordance with the requested security model.
• Scheduled reports on daily, weekly and monthly basis through a database trigger file.
• Installed Business Objects XI 3.1 on multiple servers and client machines.
• Upgraded all environments from XI 3.1 SP 3 to SP 5.
• Maintained Development, QA, Staging and Production BO XI R3.1 environments.
• Created Disaster Recovery environment.
• Trained users and developers on Business Objects applications.
• Provided support to resolve users' daily problems with Business Objects.

Technology Framework: Business Objects XI 3.1, Crystal Reports 2008, Three D Graphics, SQL Server 2008, Sales Page CRM

Confidential

Business Intelligence Consultant

Responsibilities:

• Met with business users to understand their requirements.
• Created complex reporting and metrics universes with many alias tables, contexts and derived tables.
• Implemented row level security on universes through Security Management.
• Trained business users on Webi and Crystal reports.
• Designed and developed complex Webi reports with multiple data providers, sub-queries, calculation contexts and multiple layers of drill downs.
• Created Crystal reports with cross-tabs, prompts, drill-downs, summary and sub reports.
• Built interactive dashboards on Xcelsius using live office and query as a web service.
• Created metrics and analytics using Dashboard and Analytics tools.
• Created Corporate Dashboard from interactive Xcelsius dashboards, analytics and webi reports.
• Implemented user role security model on universes, reports and dashboards in accordance with the users' requirements.

Technology Framework: Oracle 10g, Business Objects XIR3 CMC, WebI, Infoview, Dashboard and Analytics, Universe Designer, Import Wizard , Crystal Reports XIR2, Xcelsius, Live Office, Windows 2003

Confidential

Business Intelligence Consultant

Responsibilities:

• Installed Business Objects XIR2 on multiple servers
• Set up, configured and maintained BO XI R2 in Development, Staging and Production environments.
• Installed service packs and hot fixes, and also different fonts like Japanese and barcode fonts.
• Prepared SOPs Standard Operating Procedure for installation processes.
• Monitored performance, disk space, memory and CPU usage in all BO environments.
• Worked with migration team to ensure that migration from BO 6.5 is done flawlessly.
• Mapped Windows Active Directory groups and users to Business Objects.
• Worked with new project teams to initiate and help develop new projects.
• Migrated reports, dashboards and universes from Development environment to Test and Production environments.
• Maintained users, groups, folders and created new ones in accordance with the existing security model.
• Created reports out of Activity universe to keep track of user actions and application usage
• Created complex universes with derived tables and advanced features like Aggregate Awareness and Security Management
• Created complex Webi and Deski reports with sub queries, multiple linked data providers, calculation contexts, multiple level drill downs and cascading prompts.
• Maintained and modified existing crystal reports and created new ones.
• Scheduled reports for different users either through report bursting or raw level security coming from universe or database.
• Created metrics, analytics and corporate dashboards using Performance Management tools.
• Created analytics and dashboards on Xcelsius using live office and query as a web service.
• Trained users on Business Objects applications
• Provided support to resolve all kinds of problems users encountered with Business Objects

Technology Framework: Oracle 9i and 10g, Business Objects 6.5, XIR2 CMC, CCM, WebI, Infoview, DeskI, Enterprise Performance Management, Designer, Import Wizard , Crystal Reports XIR2, Xcelsius, Live Office, Windows 2003

Confidential

Business Intelligence Consultant

Responsibilities:

• Met with business users to understand and gathered requirements and created technical specification documents.
• Created Agent Reporting and CRDM universes that addressed the business requirements of the merged company.
• Used advance features in Designer like Aggregate Awareness to accommodate the aggregate tables in the datamart and Security Management to apply object and raw level security.
• Optimized existing universes and reports for shorter query run times.
• Created numerous WebI and DeskI reports using the above universes that met the end user needs.
• Validated these reports for data accuracy using other database development tools.
• Scheduled the reports to automatically refresh and distribute to various destinations.
• Developed a Corporate dashboard containing multiple analytics and reports for the executive team to monitor KPIs.
• Created analytics and dashboards on Xcelsius.
• Migrated Crystal Reports to the XI R2 environment resolved the issues encountered in the process.
• Created complex crystal reports and linked them to WebI and DeskI reports to present in the dashboard according to user needs.
• Supported the administrator in installing patches, migration, LDAP configuration, setting user privileges and access restrictions, and resolving server issues.
• Trained users about Business Objects tools and functionality and in the process of creating reports using WebI.
• Involved in customizing the Infoview home page using Business Objects Enterprise SDK.
• Provided support to resolve issues that users encounter when creating Ad-Hoc reports.

Technology Framework: Oracle 9i, Business Objects XIR2 CMC, CCM, WebI, Infoview, Dashboard Manager, Designer, Import Wizard , Windows 2000, Crystal 9/ XIR2

Confidential

Business Intelligence Consultant and Dashboard Technical Lead

Responsibilities:

• Installed Business Objects Enterprise on both server and client machines and Enterprise Performance Management on the server machine.
• Troubleshot Business Objects services' problems through Central Configuration Manager.
• Contacted users to understand the business and gather requirements for the Corporate Dashboard
• Created universes, universe objects, classes, filters and prompts.
• Mapped Windows Active Directory groups and users to Business Objects and applied different security levels
• Implemented row and object level security depending on user rights.
• Created Metrics, Goals, and various analytics based on these metrics and goals.
• Created a Corporate Dashboard with menus and sub menus using Dashboard Builder to organize the analytics in an intuitive manner.
• Provided production support for the existing crystal reports and modified them when needed.

• Created interactive WebI reports with sections and drop down filters that were used to navigate from the analytics for detailed information.
• Linked multiple Webi reports with Open Document linking.
• Scheduled the metrics, analytics, and WebI reports to refresh automatically every day.
• Used drill down feature for multiple level drilling down in WebI reports.
• Applied complex conditions and used calculation and extended contexts in WebI reports
• Migrated whole BO environment from development to test and from test to production servers.
• Backed up CMS and Performance Manager Repository schemas as well as Input and Output File Repository Folders for safety and version control.
• Tested the accuracy of data by directly querying the database by writing SQL code on SQL navigator

Technology Framework: Oracle 9i, Business Objects XIR2 CMC, CCM, DeskI, WebI, Crystal Reports Infoview, Dashboard Manager, Designer , Windows 2000

Confidential

Business Intelligence Consultant

Responsibilities:

• Interacted with users on a daily basis to gather requirements for the Corporate Dashboard.
• Created Metric universes which were a reflection of Siebel application the company used and dependent on various databases such as DB2, Oracle, SQL Server and MS Access.
• Created Metrics, Goals, and various analytics such as Interactive Metric Trends , Speedometer , Pareto Chart , Metric List , Top Slices' etc. based on these metrics and goals
• Created a Corporate Dashboard with menus and sub menus using Dashboard Builder to organize the analytics in an intuitive manner.
• Created interactive WebI reports that were used to navigate from the analytics for detailed information.
• Linked multiple full client reports, WebI reports and analytics when there is big volume of data to present at one time.
• Scheduled the metrics, analytics, WebI and full client reports to refresh automatically every day.
• Maintained and modified existing full client reports according to needs of users and created new ad-hoc WebI and full client reports.
• Used drill down feature for multiple level drilling down in WebI reports.
• Used calculation and extended contexts extensively in both webi and full client reports
• Used charts like 2D and 3D, tables, cross-tabs in the both webi and full client reports.
• Applied complex conditions both in full client and webi, combined queries and sub-queries, linked multiple data-providers
• Validated the data and tested the accuracy by running simple queries in Business Objects and directly querying the database by writing SQL code on Quest Central for DB2 and SQL Plus for Oracle databases.

Technology Framework: Oracle 9i, DB2, SQL Server 2000, Business Objects 6.5, XIR2, Windows 2000