Professional Overview

• "I am a seasoned BI professional who has worked with major Business Intelligence/Data Warehousing software vendors Business Objects, Cognos, Informatica, and as an Independent Senior BI /Data Warehousing Consultant."I offer a 12 year + background delivering strategic business solutions to all levels of management. My expertise spans a variety of industries and technical platforms across core business functions.
• "Industries include Digital media, Healthcare, Telecom, Utilities/Energy, pharmaceuticals and Sales & marketing.
• "My interpersonal skills are natural. I can empathize and connect with the business vision."
• Involved in the complete SDLC of project from Design, Development, Testing and implementation.
• Strong data Analyzing experience in Designing and implementing Universes using Business Objects Designer.
• Worked in Data marts, SCD, Star / Snow Flake Schema's environment.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Expertise in translating report requirements into detailed report specifications confirm report design with business users and build actual reports.
• Strong data modeling fundamentals (dimensional, E-R modeling) schemas like Star Schema and Snow Flake Schemas.
• Experience in RDBMS. Including around Over 8 years of experience in Advanced Reporting tool Business Objects suite Designer, CMC,CMS, Crystal reports, Xcelcius (4.5 /4.0), Dashboards, Live Office, Voyager Supervisor, BCA, WEBI and Cognos (Impromptu, Power Play),knowledge of Teradata.
• Experience in retrieving data, using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Trained & Good Knowledge of SAP BW7.0 / BI.
• Trained & Good Knowledge of SAS 9.1.3.
• Experience in reporting tool Cognos in Power play and Transformer.
• Experience in ETL tools for transformation of data using Informatica.
• Experience in creating reports and managing information in a document.
• Extensive experience in Building Universes and creating Adhoc Reports using Business Objects XIR3/XIR2/6.x/5.x and Web Intelligence XI/ 6.x / 2.6, Crystal Reports, Xcelcius, Dashboards.
• Administration of Business objects CMC, CMS and Supervisor.
• Expertise in using Designer and Business object modules.
• Strong data analyzing experience in designing and implementing Universes using Business Objects Designer.
• Excellent verbal and written communication skills.

Skills:
Operating Systems: MS-Windows XP/95/NT,Unix,Linux.
Languages: SQL, SQL*PLUS, PL/SQL.
Tools: Business Objects (XIR3/R2/6.x/5.x), Designer, Supervisor, Business Objects, Web Intelligence (XI/6.0/2.6), Business Query, CMC, CMS, Broadcast Agent Server, Live Office,Cognos 5.1 Impromptu, Powerplay. Informatica 6.x, Erwin 3.5, Visio, Toad, PL-SQL Developer, MS Project, MS Office. MS Visio.
Database:Oracle8.x/9.x/10g, MS SQL Server, Teradata, DB2, MS Access.
Resource Safe: Visual Source safe.

Professional and Business Experience

Confidential, Chicago, IL. Sept 2008 - Till Date. Affiliate Reporting

Classified Ventures ("CV") is a strategic joint-venture 100% owned and funded by five large media partners whose objectives are to collectively capitalize on the revenue growth in the online classified advertising categories of automotive, apartments, and real estate.

• Requirement gathering and analysis. Functional & Non Functional requirements. Ordering of requirement. Traceability & versioning of requirements.
• Architect for automation of the existing reports to reduce the number of man hours to run the weekly/monthly reports by enabling the file based option in BO CMC.
• Created groups, users granted privilege to users and groups in BO CMC.
• Enabled specific BO servers required.
• Enabled the File based event in the BO CMC to trigger reports as scheduled.
• Enabled the Unmanaged disk option to save the report into the shared drive as .pdf format.
• Java ReportEngine sdk was used for creating dynamic folders and achieve report bursting.
• Maintain and enhance different Universe using Universe designer.
• Developed / generated Deski and Webi reports.
• Developed Crystal reports using Universes and Business views.
• Developed Use cases / Test plans for quality & data analysis.
• Crystal Xcelsius was used to improve Dashboards and Scorecard.

Environment: Business Objects XI r3 (Designer, Deski,CMS,CMC), Crystal Reports, Xcelcius 4.0, Web Intelligence XI R2, Oracle 10g,DB2 and windows XP,Data Stage.

Cardinal Health is a leader in technologies and services that help hospitals manage all medications from the moment they arrive until they are administered to the patient; store and track specialty supplies; and identify and prevent hospital-acquired infections.

• Personal achievement of getting this project approved and funded from the business user by demonstrating the advantage and features BO provides against the conventional method.
• Interacted with business users, business owners for requirements gathering, analyzing business process.
• Gathered business requirements from upper/middle management.
• Instrumental in the decision support to the business manager for analyzing the data in accordance with the client\'s requirements.
• Instrumental in the complete SDLC to ensure quality and the satisfaction of the user requirements and needs.
• Developed use case, diagram to document the requirements and ensured creation of high level business requirements documentation.
• Installed BO, created repository, Groups, users and granted privilege to the new user utilizing the BO CMC.
• Administered the BO CMC on a day-to - day basis.
• Designed, developed and maintained Universes using BO designer.
• Developed Webi Reports. Linked reports using open document functionality which passes input parameters from the parent report to the child report
• Created Universe for building metrics for designing dashboards.
• Created dashboards for user to analyze Stock outs, Vend-Refills ratio for Controlled and Non controlled substances.
• Created Metrics, Analytic, rules, alerts and goals in performance manager to create dashboards.
• Created Crystalreports in Business Objects Crystal Enterprise.
• Documented the universe and the reports for traceability.
• Mentored business users on BO.
• Interact / assist other team members for any clarification from requirement and technical specification perspective.
• Reports were published in .ppt format using live office.

Environment: Business Objects XI r2 (CMC,CMS,Designer, Deski), Dashboards, Web Intelligence XI R2, Crystal Reports, Xcelcius, Live office, SQL Server 2005 and windows XP.

Nokia Customers invokes a service request against a product. Tracking the service request at different level based on the priority and severity. Total time taken for a Service Request with status opened to Close. The service request can invoke a service order or Return to Manufacturer authorized (RMA). The entire tracking system is built on Siebel 7.8.
A survey matrix on the number of Sr's Open, closed, escalated. RMA,region and call center.
Role: BO Analyst.

• Inter acted with the different Business Users (Internal Nokia user) for requirement analysis.
• Documented requirements.
• Involved in gathering and analyzing business requirements, documenting system requirement specification, functional requirement specifications.
• Analyzed the existing Siebel analytics schema against the requirement.
• GAP analysis—Requirement vs. Existing schema. Identify the deficiencies of the current system and requirements for the change in the proposed system.
• Administered BO CMC, created new groups and associate users to the new groups.
• Designed and Developed the Universe against the Siebel Analytical OLAP schema.
• Universe was designed utilizing the star schema provided by Siebel.
• Developed webi and desktop intelligence reports.
• Developed dashboards for analytics requirements.

Environment: Business Objects XI r2 (CMC, CMS,Designer, Deski), Web Intelligence XI r2 (Info view), Oracle 9i, Toad, Siebel 7.8 and WinXP.

Confidential, Westborough, MA. July 2006 - June 2007.

National Grid US (based in Westborough, MA) is one of the world\'s largest utilities, focused on delivering energy safely, reliably, efficiently and responsibly.
DSM Project primarily focuses on Energy Efficiency programs for both Residential and Commercial Industry.
The program is divided into Energy Wise Residential (EW), Small Business System (SBS), Large & Commercial Industries (LCI) and Impacts Evaluations (Impacts).

• Drive the entire BO process and responsible for all the BO requests.
• Organize meeting with the Business users for requirement gathering, requirement analysis and sign off on the requirement.
• Mentor the Business User to effectively use BO tool to create their own ad-hoc reports.
• Assist the business users to create their own Universe and create new reports.
• Upgrade/ enhance the existing universe and reports and deploy the reports into production environment after successful testing of the reports in UAT environment.
• Maintain the entire existing universe and own these universe to ensure that the reports are available to the business users.
• Document all the existing Universe and reports.
• Lay down specifications for the enterprise reporting frame work.
• Analyzed the impact on the existing universe and reports against the data base changes for every new release.
• Laid down process and procedure for migrating the universe/reports from one domain to another.
• Designed, developed new universe and reports as per the Business users requirements.
• Complex reports were developed from different schema involving mathematical calculations.

Environment: Business Objects XI R2 (Deski) 6.x, Full Client, Webi, Oracle 10g,DB2, PL-SQL Developer tool and Win2000

Confidential, Waltham, MA March 2006- June 2006.

CTC is facilities based telecommunications company in Waltham MA.
Line Counting Project provides information on the number of phone lines Activated, De-activated and Changes in the number of lines.

• Install, administer, implement and maintaining Business Objects modules both full-client modules (Business Objects Reporting Tool, Designer) for user Community and server-side modules (Web Intelligence, Broadcast Manager).
• Upgrading Business Objects and migrating Repositories.
• Experience in designing and developing the Universe (business view of the database), developing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the Business Objects activities.
• Designed Universes, with multiple contexts for enterprise reporting frame-work.
  Interacting with business users, business owners for requirements gathering, analyzing business process and make necessary changes to schema objects.
• Experience in gathering and analyzing the requirements from end-users and trained users in Business Objects.
• Interacted with business users for report requirements and created canned, Webi and ad-hoc reports.
• Worked on reports with multiple universes and data providers to create complex reports.
  Created Complex reports with Slice and Dice, Drill Down, @Functions and Formulas.
  Scheduled reports using broadcast agent and report bursting to different users.

Environment: Business Objects 6.x, Full Client, Webi, Oracle 9i, Toad and Win XP.

Confidential, Cambridge, MA May 2005 - Feb 2006.

Financial Data Warehouse Reporting

Biogen IDEC is a Pharmaceutical company in Cambridge, MA. Worked as a BO developer to support the Finance and Accounts team for the Financial Data Warehouse to generate reports mainly comprising of oracle 11i financial modules like AP, AR and PO.

Role: BO Developer.

• Involved in group meetings to analyze & gather business requirements by close interaction, Interviews & discussions with the business analyst team.
• Analyzed the existing OLTP system and modified / upgraded the existing universe.
• Resolved Loops.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Created various financial reports required for the Accounts and the Finance team.
• Exported universes to the Repository for making resources available to the users.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Involved in creating reports using linking of multiple data providers.
• Performed UAT (User Acceptance Testing) to know bugs involved in the reports and corrected them if found any bugs in the reports.
• Created templates to customize style and structure of the report.

Environment: Business Objects 6.x/5i, Designer, Supervisor, Oracle 11i, Toad and Win2000

Confidential, Cambridge MA June 2004 - April 2005

Biomarker Data Management Information System (BDMIS):

Biogen IDEC is a Pharmaceutical company in Cambridge, MA. A matrix reporting system was built for the group of scientist, on their research on RNA/cRNA.

• Information gathering interacted with the end user to understand the requirement and business logic.
• Analyzed the end user requirement with the existing system generated documents.
• Analyzed the existing OLTP system and developed the universe.
• Resolved Loops using context.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance.
• Exported universes to the Repository for making resources available to the users.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Extensively used the Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using
• Free hand SQL, stored procedures and functionalities like Combined Queries
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent.
• Created matrix reports for Number of pass and fail of test samples RNA / cRNA with the standard deviation and % Co-efficient of variations in the samples.
• Created templates to customize style and structure.

Environment: Business Objects 6.x/5i, Designer, Supervisor, Broadcast Agent, Oracle 9i and Win2000

Confidential, Bangalore, India Apr 2001 - Mar 2004

Sales Reports

The Reporting System is to analyze the overall sales and region wise sales of the company products. The reporting would enable the company to take decision to release various scheme sales and discount offer sales. Designed, developed and maintained the reporting framework.
Environment: Business Objects 5i, Designer, Supervisor, Broadcast Agent server, Web Intelligence 2.6, SQL, Oracle, Win NT.

The client is one of the leading Automobile battery manufactures in India. Complete automation right from the order processing, Invoicing of various distributors in the country. A package was also developed for the distributors to keep track of the local customers.

The company was involved in industrial Automation using Programmable Logic Control for various Process and Engineering Industry in India. Performed customer DDL change requests.Documented all production and test database change request and enhancements.Interaction with the client, understand the requirement, write technical document.

Master in Computer Application, Computer Applications
Bachelor of Science, Physics, Chemistry & Mathematics