PROFESSIONAL SUMMARY

• Over Seven years of experience in Information technology mostly involving Data warehousing, Data modeling, Decision Support Systems (DSS) and Client/Server and web applications.
• Over 5 years of experience in Business Objects XI/6.X with experience in Central Management Console(CMC),Infoview, Desktop Intelligence, Import Wizard, Admin Launch Pad, Supervisor, Designer, Reporter, Web Intelligence XI,6.X, Dashboard Manager and Broadcast Agent.
• Experience in Installation, Configuration, and Administration of all components of Business Objects.
• Experience in migration of BO projects from older version to XI R2
• Extensive experience in analysis to design the Universes and Business Objects Reports to support the user requirements.
• Experience in designing user defined objects and calculated objects in the universe design.
• Extensive experience in developing various kinds of reports (Cross tab, free style, graphical and KPI) reports in Web Intelligence/Desktop Intelligence XIR2.
• Experience in defining the security model in CMC as per Company landscaping.
• Extensive experience in doing multi dimensional analysis in Business Objects (Web Intelligence and Desktop Intelligence 6.5, XI R2.)
• Extensively used Crystal Reports XI on BO Universe.
• 2+ years extensive experience in OBIEE (configuring repository (.rpd), creating Intelligent Dashboards / reports, Answers, Delivers iBots / Scheduler and Publisher).
• Hands on with OBIEE install, configure and customization experience; includes Catalogued the data, Defined the metrics with the operations teams, Constructed and tested the dashboards
• Hands on experience in developing OBIEE repository development, configuring metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports).
• Experience in creating dimensional hierarchies, level-based measures and adding multiple sources to business model objects.
• Experience in modeling aggregate tables to speed processing and building calculated measures for the fact tables.
• Experience with Authorization to the external tables.
• Experience in setting up a Multi-User Development Environment (MUD) and using OBIEE Answers to run queries to test and validate the repository.
• Custom dashboards for different user groups like Planner, Super user. Finance controller.
• Proficient in using the Time-Series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts and creating pivot tables using OBI.
• Experience in loading data into data warehouse and other target tables using ETL tools dataStage and Informatica
• Experienced in Project Planning, Requirement Analysis, System Design, Construction, Implementation and Operation.
• Well versed with Software Development Life Cycle (SDLC), application design and testing.
• Experience in Dimensional Data modeling (Star Schema modeling, Snow-Flake modeling, Fact and Dimension tables), physical and logical data modeling using ERWIN 4.x
• Experience in Client Server and Web Applications using VB and ASP technologies.
• Experience in writing complex Sql queries as part of report analysis and testing.
• Experience in Oracle, MS SQL Server, MS Accessdatabases and have experience in writing, testing and implementing Procedures, Triggers and Functions using PL/SQL.
• Capability to adapt to any industry and learn any new technology/trends.
• Excellent Interpersonal and Communication Skills and desire to work in dynamic and challenging environments.

TECHNICAL SKILLS

DSS Tools: Business Objects XI R2/6.X, Web Intelligence XI R2, 6.X, Crystal Reports 9/XI, OBIEE.
ETL Tools: Informatica Power Center 7.1, IBM DataStage
Languages: C++, C, VB, SQL and PL/SQL
OS: Windows NT, Windows 2000, Windows XP and UNIX
Databases: Oracle, MS SQL Server 2000, MS Access
Data Modeling: Erwin 4.X
Web Tools: IIS, XML, HTML and ASP
Office Tools: MS Office Suite

EDUCATION & CERTIFICATIONS

• Master of Science in Financial & Management
• Received Training on Post Graduate Diploma in Computers from Systems Research Group
• Received Training on C, C++ programming from NIIT Corporation
• Received Training on RDBMS & Oracle from APTECH Limited

PROFESSIONAL EXPERIENCE

Sr.Business Intelligence Developer
Confidential, Houston,TX June 2011 - Present

Responsibilities:

• Involved in gathering requirements, analyzing and documentation of business requirements/specifications.
• Worked closely with users to maintain and troubleshoot ,enhance BI functionality and delivers.
• Interacting effectively with users ,project managers ,business analysts and other team members.
• Created High and Low level technical design documents.
• Analyzed repots for reverse engineering.
• Created Use Case and Detail Data Specification(DDS).
• Implemented Row level security in BO using external DB tables.
• Involved in Design, Development and the Implementation of the Universes and the financial reports based on the requirements.
• Designed the Universes based on reporting requirements and subject areas.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Developed customized hierarchies in the universe for drill down reports.
• Extensively used Import Wizard to deploy the reports/universes in different environments using BIAR files.
• Involved in Administration of all components of Business Objects.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Created the Production Implementation Plan, Test Plan, BO XI Regression Test Results documents.
• Involved in the Development, Testing and Migration of the Universes and Reports.
• Generated various Adhoc, Canned and Complex reports according to the User specifications.
• Developed reports, dashboards, Custom KPI\'s with different views, drill downs Dashboard to report navigation using BO.
• Written complex SQL queries for UAT testing of Business Objects reports.
• Associated with production support group in order to organize user information and profiles in Central Management Console (CMC).
• Provided troubleshooting for various problems pertaining to thin-client reporting and formatting, design of universes and other BO complexities.
• Extensively worked as a Primary to resolve the tickets (issues) submitted by the Business Users.
• Developed reports using Crystal Reports XI on BO Universe.
• Developed reports, dashboards, Custom KPI\'s with different views, drill downs, report-to-report Navigation and Dashboard to report navigation using YOTTA(HP internal reporting tool)
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs using YOTTA(HP internal reporting tool).
• Used different Views like Column Selector view to change the Overall view of the report using YOTTA.
• Developed report level and dashboard level prompts in YOTTA.
• Trained Users on developing Ad Hoc reports and building a custom dashboards.

Environment: Business Objects XI R2/6.5, Web Intelligence XI R2/R3, Crystal Reports XI, Dashboard Manager, YOTTA(HP internal reporting tool) Informatica, Oracle 10g, Windows, MS Office.

Business Objects Developer
Confidential, CA April 2009 - May 2011

Responsibilities:

• Involved in gathering requirements, analyzing and documentation of business requirements/specifications.
• Involved in Design, Development and the Implementation of the Universes and the financial reports based on the requirements.
• Extensively worked on integrity check and resolving the loops while designing the universe.
• Designed the universes based on reporting requirements and subject areas.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Developed calculated objects in the universe to re use them in number of reports.
• Designed dimensions, details and measure objects in the universe at customer, product and loan level for multi dimensional analysis.
• Developed customized hierarchies in the universe for drill down reports.
• Involved in the migration of Business Objects 6.5 to Business Objects XI R2.
• Extensively used slice and dice and drill down at required levels of dimensions for multi dimensional analysis in Web Intelligence, Desktop Intelligence.
• Extensively used Import Wizard to deploy the reports/universes in different environments using BIAR files
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Created the Production Implementation Plan, Test Plan, BO XI Regression Test Results documents during the upgrade of BO 6.5 to BO XI R2.
• Involved in the Development, Testing and Migration of the Universes, Reports.
• Generated various Adhoc, Canned and Complex reports according to the User specifications.
• Written complex SQL queries for UAT testing of Business Objects reports.
• Involved in the creation of report templates to be used as the standard throughout the department.
• Associated with production support group in order to organize user information and profiles in Central Management Console (CMC).
• Provided troubleshooting for various problems pertaining to thin-client reporting and formatting, design of universes and other BO complexities.
• Extensively worked as a Primary to resolve the tickets (issues) submitted by the Business Users.
• Created reports and custom dashboards to Display Information by Customer Corporation, Reason code, By Carrier, by lane, By Mode for On Time Delivery, On Time Pickup calculations using OBIEE.
• Developed reports, dashboards, Custom KPI\'s with different views, drill downs, report-to-report Navigation and Dashboard to report navigation using OBIEE.
• Involved in integrating various subject area RPDs to give a single presentation view across SCM scope using OBIEE.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs using OBIEE.
• Used different Views like Column Selector view to change the Overall view of the report using OBIEE.
• Developed report level and dashboard level prompts in OBIEE.
• Trained Users on developing Ad Hoc reports and building a custom dashboard
• Involved in ETL Process using DataStage.

Environment: Business Objects XI R2/6.5, Web Intelligence XI R2, Crystal Reports, Dashboard Manager, OBIEE, DataStage 7.5.2, Oracle 10g, Windows XP, MS Office.

Confidential, TX July 2007 - March 2009
Business Objects Developer

Responsibilities:

• Designed and developed Business Objects Universes to support the new sales reporting requirements of business users.
• Extensively worked with multiple data providers and linking these data providers based on the requirements.
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Extensively used Contexts and aliases to resolve the loops.
• Extensively used @prompt, aggregate aware functions while designing the objects in the Universe.
• Generated various reports with prompt functionalities at both universe and report level to enhance end-user interactivity.
• Developed row level security on Business Objects reports based on user/group level.
• Extensively worked on scheduling reports based on scheduling priorities using BCA.
• Developed SQL queries in oracle 9i and exported the data into Excel to use them as personal data providers to Business Objects reports.
• Creation of Dashboard and Score Cards using Dashboard Manager.
• Publishing reports using Web Intelligence to the various categories in the corporate documents.
• Testing the data after the ETL loads and coordinating with ETL developers and architect/designers.
• Actively involved in the Production support.

Environment: Business Objects 6.5, Crystal reports, Oracle9i, DataStage, Windows 2000/SunSolaris, Netezza 3.1

Confidential, IA Mar 2005 to June 2007
Business Objects Consultant

Responsibilities:

• Involved in gathering and analyzing the business requirements.
• Extensively used the Business Objects functionalities such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created breaks on reports based on reporting requirements.
• Generated the customized list of values to use them for user inputs of the reports.
• Used the set analyzer to create sets and subsets of the requirements to feed it into the universe.
• Resolved Loops using contexts created Dimension, Detail and Measure objects and exported Universe to the repository.
• Separate Logical and Physical models support using ERWIN.
• Analyzed and modified the data model using ERWIN.
• Design, Development and the Implementation of the Universes and the financial reports based on the requirements.
• Created ETL Informatica mappings to load data from source to target.
• Generated various Adhoc/Canned Reports.

Environment: Business Objects 6.X (BO Reporter Supervisor, Designer, Web Intelligence), Informatica, Oracle 8i, SQL\\PL-SQL, Teradata, MS-Office, Win NT.

Confidential, India Jan 2003 to Feb 2005
Software Programmer

Responsibilities:

• Involved in Design and Implementation.
• Involved in developing the web site in ASP Pages.
• Responsible for Enhancements to Graphical user interface (GUI) and incorporation additional functionality to the application.
• Designed the process flow.
• Designed the layout and templates using Dreamweaver.
• Designed tables using normalization techniques.
• Created reports in Crystal Reports.
• Created database objects like tables, stored procedures, views and triggers in Oracle and SQL Server.

Environment: Visual Basic (VB), ASP, XML, VBScripts, Java Script, HTML, SQL Server 200, Oracle 8i, MS Access, Windows2000.