PROFESSIONAL SUMMARY

• Over 8+ years of experience in various Information Technology areas involving Data Warehousing, Oracle Database Administration, design, development Business Intelligence Tools.
• Experience in Business Objects 4.0,Xir3,Xir2,Xir1,6.x/5.x/4.x tools in creating and archiving of reports using various data providers.
• Experience with Information Design Tool, Universe Design, Desktop Intelligence, Interactive Analysis, Web Intelligence, Launch Pad, BW Business Explorer Analyzer, Query Designer and Info View Administration.
• Experience in designing and developing the Universe, scheduling the processes using Broadcast Agent and administering the Business Objects activities
• Used various data providers like Personal Data Files, Excel, BEX, Freehand SQL, and VBA Procedures to make reports.
• Experience with Crystal Reports
• Maintained User Groups using BO Supervisor CMC, and scheduled documents using Broadcast agent.
• Good knowledge of database experience using Oracle 11i/10g/9i/8i/7.3, MS SQL Server 7.0/6.5/2000, MS Access 7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
• Delivered 5 Full life cycle implementations in BI.
• Experience in SAP BW, ETL tools for transformation of data using Informatica and Data Stage.
• Extensive experience in architecture design of Extract, Transform, Load environment using Informatica Power Mart, Power Center 7.1/6.1.
• Exposure in, manufacturing pharmaceutical, financial, Telecommunication, production and Sales Data Warehouses.
• Excellent team player, interfacing across business and technical groups and ability to work independently and highly motivated.
• Exceptional ability to quickly master new concepts and applications.

ACADEMIC QUALIFICATION

M.B.A (Ongoing)
M.S Computer ScienceTRAINING AND CERTIFICATES

• Oracle 9i Certified
• Data warehousing

Technical Skills

BO Client Server Tools: Business Objects 4.0/Xir3/Xir2/Xir1/6.5/6.0/5.1.x Reporter, Designer, Supervisor, Broadcast Agent, Desktop Intelligence, BEX, Web Intelligence
Application Foundation: BO v 6.0 XI Dashboard Manager, Performance Manager
Operating Systems: Windows 95/98/2000/NT 4.0 Server, UNIX, Mac OS and DOS
Databases: OracleFinancials11g/10/9i/8i/7.3,DB2,SAP BW, Teradata,
SQL server, MS Access 7.0/2000.
Languages: SQL, SQL*PLUS, PL/SQL, JAVA, ASP, COBOL, C, C++, XML, Visual Basic, HTML 4.0, Shell Scripting, Visual Basic scripting
ETL Tools: Informatica Power Center 7.1/ 6.x/5.x, Data Stage
Tools: SQL Navigator, SQL*Loader, SQL-Programmer, BEX Query Designer.
Web and Others: HTML, ASP, JSP, MS-Office Suite, Dream weaver, and Adobe Photoshop, Flash
Data Warehousing: Star Schema, Snow Flake

Professional Experience

Confidential April 2012 - Current
SAP BI Practice Lead

• Involved extensively in designing and functional specifications for all modules of Business Objects.
• Involved in gathering business requirements.
• Develop Practice on BI strategy.
• Implemented SAP BOBJ.
• Designing the architecture for BOBJ and SharePoint Integration.
• Assist Client in solutions.
• Prepared SOWs and presented demos on projects.
• Design Drill down’s and hyperlinks for reports.
• Understand and evaluate technology related to SAP BI on all its components.
• Provide best practices.
• Provide project plans, manage, design and develop projects as a technical adviser.
• Conduct knowledge sharing sessions with leadership and team.

Environment: BusinessObjects4.0,UDT,IDT,Launch Pad, SAP BW 7.0,Peoplesoft,Focus,BEX Query Designer, Analyzer ,CMC, Dashboard, Data Services, BI Workspace, Interactive Analysis, Windows 7.

Confidential October 2011 – April 2012
SAP BI Architect

• Involved in Installation and configuration of BI 4.0.
• Involved in gathering Business requirements to know their Business views in developing Reports.
• Documented user requirements, translated requirements into system solutions.
• Administrated BI 4.0.
• Created Web I reports with BEX as a data source.
• Enabled Bex queries with Allow external process to create Web I reports.
• Extensively worked on Information design tool to create OLAP connections.
• Created projects in IDT.
• Involved in giving training to Power users and Team with new components of BI 4.0.
• Involved in various discussions with end users for gathering the requirements.
• Configured Dev, QA and PROD environments.
• Work with SAP support for BI 4.0.
• Involved in applying patches (Up to 9) for BI 4.0.
• Experienced in Integrating BEX queries.
• Executed queries in BEX Analyzer.
• Used BICS (new feature) interface for BEX Queries.
• Created HLD, Technical Design Docs and Business Requirement docs for reporting purpose.
• Trained the Business on new tools of BI 4.0.
• Created proof of concepts for each module of BI 4.0.
• Created Dashboards to track sales of each region.
• Created various classes, objects, Filters, and Prompts on UDT.
• Merged the BEX queries for Interactive Analysis reporting.
• Managed the Offshore LITC team.
• Designed BOBJ 4.0 Security.
• Granted Access to Users.
• Created work flow to track the progress of projects.
• Extensively trained Residential and Commercial Power Users for UAT.
• Created various PPT’s for Business owners to introduce BI 4.0 vs BEX.
• Developed Interactive Analysis reports for each department (Heat craft, Refrigeration, Commercial and Residential).
• Supported production processes and user issues which come in through the Help Desk.
• Ensured complete documentation for design, test plans, test cases and test summary reports
• Prepared documentation of the environment, as well as migration and administration processes.
• Created an error log to track the issues for BI 4.0 and supplied it to SAP support.
• Created reports using Launch Pad and also used Facet Searching.

Environment: Business Objects 4.0,UDT, IDT ,Interactive Analysis, Launch Pad, SAP BW 7.0,SCM,ECC, BEX Query Designer, Analyzer,CMC, Dashboard,Data Services, BI Workspace Oracle 11i, Windows 2000, XP.

Confidential October 2008 – October 2011
Sr.Business Intelligence Lead Developer/Architect

• Involved extensively in designing and functional specifications for all modules of Business Objects.
• Involved in gathering business requirements, logical modeling and performance tuning.
• Involved in Migration of 6.5 to 3.1
• Worked on the Median functionality
• Worked on different oracle ERP modules like Accounts Payable, HR, Purchasing and Payroll
• Worked on OPUS, ECDW.
• Managed a development team in offshore and onsite.
• Delivered multiple projects on time.
• Experienced with Installation and Configuration of all Business Objects modules.
• Creation of Universes by retrieving the data from database, defining the necessary connections and exporting them to specific universe domains.
• Designed the Star Schema with fact tables and dimension tables.
• Created Hierarchies to provide the drill down functionality to the end-user.
• Specified Joins and checked the Cardinalities and Integrity of Universes. Measure objects and Dimension objects were created keeping in view of the end-user requirement.
• Worked on Creating Reports on Budgeting/Scheduling/Forecasting.
• Created HLD and ADD Documents.
• Worked as a Business Analyst in gathering Analyzing and Creating Business Specs for creating Report specs and also reviewed HLD and ADD.
• Used Data Integrator to load data and then get it to BO reports as Text files.
• Used Central Management Console (CCM) to enable/disable various BO servers and to add/delete servers.
• Involved in data modeling using Erwin
• Involved directly with users in gathering business requirements.
• Controlled the access of the universe through CMC
• Selected the authentication method for each user at the creation of the user’s account, using the CMC
• Published the reports using Web Intelligence and scheduled them using Broadcast Agent.
• Interacted with Project Manager, Business Analysts and End Users to understand their business needs and requirements to modify Universes and Reports.
• Developed mock up reports from mock data for evaluation.
• Developed Full client reports using multiple Queries, combination of charts and tables. Created complex reports by linking data from multiple data providers
• Creation of Universes by retrieving the data from database, defining the necessary connections.
• Generating a variety of reports based on the universes, running free-hand SQL, and also personal data files like MS Excel.
• Created Alerts using Business Objects to highlight columns based on business criteria.
• Involved in Installation and Configuration of all Components of Business Objects.
• Created reports using various data providers, including excel and text files, and made it available to users over Web Intelligence.
• Exhaustive report analysis using slice and dice/ drill methods and by creating Master detail reports.
• Worked on Query Panel, Prompts and Report Layout and re-formatting.
• Created sales dashboards for Stores, VPGM, ARSM, Markets and Sales Rep’s.
• Involved in creating an E-mail Report Communication System where reports could be sent via E-mail to all or individual users.
• Extensively worked in training users in UAT.
• Experienced in integrating BEX queries.
• Saved reports as HTML and published it to FTP.
• Involved in troubleshooting of Web Intelligence and other user issues.
• Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports to different environment within the organization.

Environment: Business Objects 3.1, 6.5, Info view, Designer, Reporter, Web-I, Rich client, SAP BW, Crystal Xcelsius Oracle 9i, 11i, Data Integrator, Teradata, SQL, PL/SQL, Windows 2000, XP.

Confidential NJ April 2008 – September 2008
Business Intelligence Lead/Architect

• Involved in Installation and configuration of BO XI r2
• Interacted with Business Users to know their Business views in developing the Universes and Reports
• Documented user requirements, translated requirements into system solutions
• Created and maintained users and groups for use within multiple Global projects for both application and data level security
• Involved in giving training to the users and the Team with new components
• Involved in various discussions with end users and gathering the requirements
• Involved in preparing the test cases for migration reports
• Involved in 24/7 production support
• Supported production processes and user issues which come in through the Help Desk needing to be addressed quickly.
• Ensured complete documentation for design, test plans, test cases and test summary reports
• Prepared documentation of the environment, as well as migration and administration processes
• Installation, Configuration and Test/Validation of Business Objects Enterprise
• Tested the universe connection with a VBA macro
• Used Central Management Console (CCM) to enable/disable various BO servers and to add/delete servers.
• Controlled the access of the universe through CMC
• Selected the authentication method for each user at the creation of the user’s account, using the CMC
• Created Alerters, Breaks, Sections, Filters and Drill Analysis
• Managed the content and data migration through Dev, QA and Prod environments
• Worked on different oracle ERP modules like Accounts Payable, HR, Purchasing and Payroll
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports
• Executed queries in BEX Analyzer.
• Involved extensively in designing and functional specifications for all modules of Business Objects.
• Involved in gathering business requirements, logical modeling, data extracting and data transformation, data loading, SQL and performance tuning.
• Creation of Universes by retrieving the data from database, defining the necessary connections and exporting them to specific universe domains
• Used the Import Wizard to import Users/Groups, documents (both Web Intelligence and Inbox), universes, folders and objects from BO 6.5 to BO XI r2.
• Worked on the Performance of the Universe and Report
• Built BO Full client and Web-I reports.
• Designed, developed and tested the reports based upon data generated by enterprise transactions
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart and Master/Detail.
• Created various standard reports and queries based on the existing classes/ objects
• Used Broadcast Agent for scheduling and distribution of reports
• Developed both Ad-hoc and canned reports

Environment: Business Objects XIr2, 6.5, Designer, Reporter, Web-I,SAP BW,Broadcast Agent, DB2, Oracle, 8i, 10g, SQL, Java, Visual Basic, ASP.NET, Windows XP,2000.

Confidential NJ October 2007 – Jan 2008
Business Objects Technical team Lead

Philips Van-Heusen is a leader in the Apparel Industry; the brands include Van- Heusen, Arrow, IZOD, DKNY, and Calvin Klein. The project scope is to design and build a warehouse for decision. The warehouse is built from data received from various brands and offers summarized view for optimized decision making.

Responsibilities

• Involved in Installation and configuration of BO XI r2
• Interacted with Business Users to know their Business views in developing the Universes and Reports
• Documented user requirements, translated requirements into system solutions
• Created and maintained users and groups for use within multiple Global projects for both application and data level security
• Involved in giving training to the users and the Team with new components
• Involved in various discussions with end users and gathering the requirements
• Involved in preparing the test cases for migration reports
• Involved in 24/7 production support
• Supported production processes and user issues which come in through the Help Desk needing to be addressed quickly.
• Ensured complete documentation for design, test plans, test cases and test summary reports
• Prepared documentation of the environment, as well as migration and administration processes
• Installation, Configuration and Test/Validation of Business Objects Enterprise
• Managed Business Objects environments
• Created Users/Groups/Sub-Groups & assigned profiles there by restricting un-authenticated access to resources
• Used Central Management Console (CCM) to enable/disable various BO servers and to add/delete servers.
• Created Alerter, Breaks, Sections, Filters and Drill Analysis
• Installed latest version of Xcelsius on the same computer with the previous version
• Managed the content and data migration through Dev, QA and Prod environments
• Worked on different oracle ERP modules like Accounts Payable, HR, Purchasing and Payroll
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports
• Involved extensively in designing and functional specifications for all modules of Business Objects.
• Involved in gathering business requirements, logical modeling, data extracting and data transformation, data loading, SQL and performance tuning.
• Experienced with Installation and Configuration of all Business Objects modules.
• Used the Import Wizard to import Users/Groups, documents (both Web Intelligence and Inbox), universes, folders and objects from BO 6.5 to BO XI r2.
• Involved in troubleshooting of Web Intelligence in Xir2.
• Developed the Implementation plan and enhanced SQL queries.
• Created multiple universes and document domains and Created Universes for different Brands
• Provided flexible data integration methods with ETL for batch and real-time data federation
• Worked with linked and derived universes
• Scheduled reports to run in Business Objects Scheduling (BOSS)
• Worked on the Performance of the Universe and Report
• Built BO Full client and Web-I reports.
• Designed, developed and tested the reports based upon data generated by enterprise transactions
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart and Master/Detail.
• Created various standard reports and queries based on the existing classes/ objects
• Used Broadcast Agent for scheduling and distribution of reports
• Developed both Ad-hoc and canned reports

Environment: Business Objects XIr2 (CCM, CMC, Info View), Crystal 11,Business Objects 6.5, Designer, Reporter, Web-I Broadcast Agent, AS 400,DB2, Oracle, 8i, 10g, SQL, SDK, Windows XP.