Summary:

• Over 8 years of experience in System Designing, Analysis, Application Development, Maintenance, Implementation, Project Management, Database Administration, Data Warehousing, Data Mining and Report Writing Solutions.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as analyzing, developing, testing, Migrating, Administrating, security management and production supporting on various platforms like Windows NT/2000/XP/98, UNIX.
• Expertise in installing, configuring, deployment and maintenance of SAP Business objects applications using Infoview, CMC, CCM, Desktop Intelligence, Web Intelligence, Voyager, Crystal Reports, Designer, Universe Builder, Import Wizard, Publishing Wizard, Translation Manager, Report Conversion Tool, Life Cycle Manager, Query Builder, Live Office, QAAWS, Crystal SAP Integration tool Kits, Planning, Data Quality, Metadata Manager, Web Admin tool.
• Experienced in Manufacturing, Healthcare, Financial, Pharmaceuticals, Retail, Logistics, and Insurance, Marketing and Commercial applications.
• Potential in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses middleware, and web applications.
• Well versed with Business Objects Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
• Managed entire project lifecycle - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents, Dimensional Data Modeling (Logical and Physical).
• Expertise in deploying OLAP tools, Materialized Views, indexing and partitioning techniques for highly responsive Decision Support Systems.
• Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.
• Hands on Programming skills in SQL, PL/SQL, Stored procedures, packages, functions, triggers.Managed all upgrades, maintenance, and support of the Business Objects System and Expertise in Migrating the Business objects from 5.1.x/6.1a/6.1b/6.1.5/XI r2 to XI 3.1.
• Good working experience in Business Objects, Supervisor, Designer, Broadcast Agent (BCA), ZABO, Web Intelligence and Business Objects SDK.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon.
• Created reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerters, Ranking and multiple data providers.
• Diversified experience in implementation of Crystal Enterprise with multiple domains.
• Having hands on experience in BI 4.0 on both SAP and Non SAP Systems.
• Designed and Developed Crystal Reports using complex Views, functions and Stored Procedures.
• Experience in designing Business Views, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.
• Assigning tasks to technical team, managing timelines, resolving issues testing solutions, training users, and maintaining communication with customers and management.
• Good Communication and Interpersonal skills. Technically sound, Result-Oriented with strong Problem solving skills. Innovative & efficient. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Education: Bachelor’s in Computer Science

Technical Skills:

Business Intelligence : Business Objects XI 3.1/XI R2/XI/6.5/6.1/6.0/5.1 (Supervisor, Designer, Reporter, BO Auditor, Infoview, CMC, CCM, Desktop Intelligence, Web Intelligence, Voyager, Crystal Reports, Designer, Universe Builder, Import Wizard, Publishing Wizard, Translation Manager, Report Conversion Tool, Life Cycle Manager, Query Builder, Dashboard builder, Set Analytics, Live Office, Widgets, SAP Integration KIT, Integration KIT for Microsoft share point portal, SAP BW,SAP GUI, BEx Analyzer, Query As A Web services, Data Federator.

Business Analysis : Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow Diagrams.

Dimensional Data Modeling : Dimensional Data Modeling, Star Schema, Snowflake, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5/3.2, Oracle Designer, Visio and Sybase Power Designer.

RDBMS : Oracle 10g/9i/ 8i/ SQL Server 2000/2005, DB2, MS Access, Teradata V2R5.

ETL Tools : Informatica 5.1/6.1/7.1 (Power Mart/Power Center), Datastage 7.5/6.x.

Operating Systems : Windows NT/XP/2000/2003/2008, Unix Sun Solaris 8/9, IBM AIX and HP.

GUI : Visual Basic 6.0. JSP, ASP, SQL Navigator, Toad.

Web Server : Apache Tomcat Web Server, Java Web Server 2.0, Web logic Server, Websphere and IIS.

Work Experience:

Confidential, Burbank, CA Sep 2011 – Present
Sr. Business Objects Developer/Administrator.

Responsibilities:

• Gathered business requirements, interacted with business analysts and the End Users.
• Installed and configured BOE XI 3.1 Environment.
• Implemented 3rd party security authentication (WINDOWS AD) in BO apart from Enterprise Authentication.
• Configured and enabled the SSO using the Windows AD Authentication.
• Implemented Migration process for Business Objects XI R2 to XI 3.1 such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and Education delivery.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created and maintained around Crystal reports and Web Intelligence reports.
• Worked on Webi reports, Prompts and Report Layout and re-formatting.
• Developed Complex Universes by linking different data sources.
• Resolved loops and Traps problems in the universe, Created Hierarchies for providing drill down options for the end-user and developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
• Reports are made user friendly by implementing user prompts, conditions and filters.
• Developed Universe on top of Bex queries.
• Created various reports with functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports.
• Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
• Developed Complex Universes by linking different data sources.
• Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
• Fine-tuned universes and reports by creating aggregate tables and filters.
• Developed the highly summarized dash boards using XCelsius and created the real time dash boards using QAAWS and BI Widgets.
• Worked with the Exova team for developing BO reports in IOS and ANDRIOD Devices.
• Configured BW Publisher service for Crystal reports migration.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Worked with the users for defining the report needs and helped designing queries using Bex.
• Created complex formulas to support various business functionalities using crystal reports.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features.
• Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.
• Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.

Environment: Business Objects XI R2 SP2,XIR 3.1 SP3, SAP GUI 7.1, SAP Integration kit, SAP BW,Designer, Info View, Web Intelligence, SQL, PL/SQL, SQL server 2008, ORACLE ,Crystal Reports 2008, Live Office, Windows Server 2003 sp 2.

Confidential, Chicago, IL. Jan’11 – Sep’11
Sr. Business Objects Developer/Administrator.

Description:
Grant Thornton is the Leading Auditing Firm. The project is to create a new environment BOXI 3.1 and migrate from the BOXI r2 environment to BOXI 3.1 environment. To redesign some of the universes and test the Applications, Reports, Processing Extensions and Universes.

Responsibilities:

• Analyzed, designed, developed and deployed a Global wide reporting solution using Business Objects and Gathered business requirements, developed Functional Specification Documents, Technical Specification Documents for Universes and reports.
• Developed various reports on top of Bex and Functional Modules using Crystal Reports.
• Worked with the Bex Team and designed the Bex Queries.
• Worked with the ABAP team in designing the Functional Modules and developed reports on top of Functional modules and core SAP Tables.
• Worked with MDX Queries, Info providers and Multi providers to create Crystal Reports as per End user requirements.
• Configured the Database configuration for the reports for a particular generic user ID for publishing reports in Portal (If coming from two different Sources).
• Scheduled and maintained the reports to various users across the world using Info view and CMC.
• Created Webi reports using Universes, stored procedure and Free hand SQL as Data providers.
• Created Business Views for the LOVs in some of the reports.
• Created the Crystal report on two different data sources using sub reports also.
• Created various Linked and Unlinked Sub Reports and managed the parameters accordingly.
• Used BI 7 Bex query designer and the Bex Analyzer for creating reports on top of SAP.
• Created Crystal reports on the Core SAP Tables and Staging Tables.
• Worked with the Production System support team and handling of opened user cases.
• Custom configuration of BW, testing, and development of user and data validation documents.
• Using Data Warehousing Workbench developed BW Info Cubes, Multi providers, Data Stores objects, Key Figures, and Transformations.
• Generated various reports with the Features like Drill down, Alerts, Data Suppressing and Change Highlighting.
• Extensively worked on migration reports using Import Wizard and Life Cycle Manager (LCM) and transporting objects between BW system environments using Transporters.
• Created users, groups and categories and developed the Voyager work space for multi-dimensional analysis.
• Worked on troubleshooting of different database connectivity issues, user issues and report performance issues and trained the End Users regarding the Tool and the reports.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.

Environment: SAP Business Objects XI r3.1, SAP Crystal Reports 2008, SAP GUI 7.1, SAP Integration kit, SAP BW, DB2, Universe Builder, Business View Manager, XCelsius, Excel 2003 and Windows 2003.

Confidential, Hartford, CT. Mar’10 – Jan’11
Sr. Business Objects Developer/Administrator.

Description:
Travelers Insurance is a leading Insurance company offering services like Auto Insurance, Business Insurance for individuals and business groups. The overall vision is to create a single Operational Data Store (ODS) with all revenue, expenses, and other financial data that is required to support Financial Reporting. Integrated Profitability Reporting is also being implemented with data sources from the ODS.

Responsibilities:

• Analyzed, designed, developed and deployed a Global wide reporting solution using Business Objects and Gathered business requirements, developed Functional Specification Documents, Technical Specification Documents for Universes and reports.
• Installed and configured CMS, Audit databases for BOE Environment.
• Implemented 3rd party security authentication (LDAP) in BO apart from Enterprise Authentication.
• Identified the KPI’s in the business to build the dashboards and Interacted with Risk Managers and analysts for Universe and reporting requirements.
• Successfully implemented BO version upgrades, Multi master clustering, NAS (Network Area Storage) implementation, automated process for Web Intelligence personal & inbox documents Audit report generation.
• Migrated reports from Desktop Intelligence to Web Intelligence.
• Used Data Federator to combine different data sources.
• Implemented Migration process for Business Objects XI R2 to XI 3.1 such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and Education delivery.
• Resolved loops and Traps problems in the universe, Created Hierarchies for providing drill down options for the end-user and developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created and maintained around Business Objects reports and Web Intelligence reports.
• Reports are made user friendly by implementing user prompts, conditions and filters.
• Developed Universe on top of BEx queries.
• Worked with MDX queries, Infocubes, Infoproviders, Infoobjects, multi providers to create Crystal reports as per End user requirements.
• Configured BW Publisher service for Crystal reports migration.
• Created complex formulas to support various business functionalities using crystal reports.
• Developed the highly summarized dash boards using XCelsius and created the real time dash boards using QAAWS and BI Widgets.
• Created users, groups and categories and developed the Voyager work space for multi-dimensional analysis.
• Created the Repository structure to manage the security and deployment options throughout the installation.
• Involved in unit testing, system testing, Component testing and product testing and training end-users on the final product.
• Custom training for end users in Desktop Intelligence and Web Intelligence.

Environment: Business Objects XI R2 SP2,XIR 3.1 SP3, Designer, InfoView, Web Intelligence, Data Stage 8.1,SAP BW,SAP GUI, SAP Integration Kit, BEx Analyzer, SQL, PL/SQL, SQL server 2008,Oracle 10g, TOAD, Crystal Reports 2008, XCelsius 2008, Live Office, UNIX, Windows Server 2003.

Confidential, Atlanta, GA. Aug’08 – Feb’10
Sr. Business Objects Developer / Administrator.

Description:
Verizon Wireless is one of the leading providers of unprecedented mobility solutions to their customers, as their services ranging from wireless communications services to IP broadband services. The scope of the project is to design and build Universes for decision support and then to generate reports for the analysis of personal phone usage data. The Application provides customers with a means for tracking their call time in the billing cycle and their liability. The generated reports provide users with their detailed customer information, Billing information, Account details and Service usages.

Responsibilities:

• Analysis of Client specifications and custom design applications.
• Involved in the design of the data warehouse by using star schema.
• Participated in business requirements analysis, report designing and modeling, development of technical specifications, testing and Implementation.
• Installed Business Objects Server components installation, applied fixes/service packs and did tuning and monitoring the server performance in AIX.
• Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.
• Implemented Migration process for Business Objects 6.5.1 to XI r2, Crystal Report 9/10.0 to XI r2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and Education delivery.
• Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• Experience migrating customers from the Crystal Reports 10 infrastructure to the XiR2 infrastructure.
• Assist with supporting one or more BI reporting infrastructures in support of application development and infrastructure migration.
• Created webi reports using the Universes, stored procedure and Free hand SQL as Data providers.
• Worked on webi reports, Prompts and Report Layout and re-formatting
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Designed various universes based on functional groups.
• Defined Security Skeleton and extensively worked in implementing the security in Business Objects Enterprise system.
• Developed Complex Universes by linking different data sources.
• Create Aliases and Contexts for resolving Loops and check the Integrity of the Universe.
• Fine tuned universes and reports by creating aggregate tables and filters.
• Provided solutions for the most complex scenarios of “linking” objects.
• Generated List of Values (LOV’s) from lookup tables.
• Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
• Experience in the development of reports for financial needs of the business using Business Objects Reports.
• Developed reports with Parameters, Sub-reports based on Stored Procedures and Queries by using Business Objects reports.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Custom hierarchies have been created for report level drilling information.
• Designing Excel sheets using Live Office by creating reports on top of universe.
• Experience in Scheduling the Reports using BOE.
• Responsible for the distribution of the reports.
• Published Reports in Business Objects Enterprise via Publishing Wizard.
• Installed and configured Crystal Reports and Created and Maintained/administer User groups in Crystal Enterprise.
• Created interactive XCelsius dashboards and charts and graphs, metric analytics with Xcelsius.
• Good exposure in developing reports with data in data warehouse and data marts.
• Promoted (Migrated) the Business Objects Enterprise content like WebI, DeskI, Crystal Reports, Business Views, Universes, Universe Connections with in the Life Cycle Environments. From Development to UAT to Production.
• Worked on troubleshooting of different database connectivity issues, user issues and report performance issues.
• Involved with the end users in UAT (User Acceptance Test).

Environment: Business Objects Enterprise XI R2, Crystal reports 2008, XCelsius, Oracle 10g, SQL SERVER 2005, T-SQL, UNIX and Windows Server 2003.

Confidential, Mettawa, Illinois. Mar’07 – Jul’08
Sr. Business Objects Developer/Analyst.

Description:
HSBC bank is responsible for banking, lending and investment services to individual consumers and small businesses, with up to $10 million in annual sales This Project is a Data Warehouse built for various HSBC branches in USA. The project involved extracting, transformation and loading of business data related profile of customers, business information, Credit analysis, wealth management and Bank Credit policies and secured stock information from different regions for business analysis on quarterly and monthly basis.

Responsibilities:

• Gathered business requirements, interacted with business analysts and users of legacy systems.
• Installed and administrated Business Intelligence Servers.
• Extensively used Import Wizard, publishing wizard for Migration of Business Views and reports to PROD, SYS and DEV environments from Crystal 8.5/9/10 to XI version to their respective domains.
• Implemented Migration process for Crystal Report 8 to XI r2 such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and Education delivery.
• Building the Meta data layer by using the Business Objects Designer.
• Created the Business Objects metadata repository and also assisted in administering a ZABO deployment of Business Objects.
• Created corporate universes and linked them to regional universes and then to the states. These universes contained the objects about gaining revenue from individuals. Complex aggregate functions were included within the Universe to calculate the ratio of revenue generated by regions.
• Solved loops in universe using contexts, aliases, cardinality, built in functions, alerts, scope of analysis, hierarchy, filters and created user objects.
• Generated reports for fixed income and bond investing.
• Created global Fixed Income research reports on High Grade, High Yield, Emerging Markets and Strategy.
• Created reports to calculate the profit/loss margin by year/quarter/month and sub reports were generated graphically (Bar charts, Pie charts, etc) to clearly explain the parameters responsible for profit/loss by year/quarter/monthly.
• Generated reports for Credit research, General Ledger, HR and budgeting systems.
• Created & tested the universe for other reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.
• Used the components Set based analysis, Predictive analysis, Statistical process control, Time series analysis, Dashboard manager.
• Dealing with dimensional modeling, OLAP with data modelers and ETL process.
• Created dashboard, score board for metrics.
• Imparted training to business users.

Environment: Business Objects XI, Web Intelligence (Reporter, Explorer, Infoview), Business Objects SDK, Web Intelligence, Broadcast Agent Publisher, Erwin 4.1.2, Informatica Power Center 5.1, Oracle 9i, PL/SQL.

Confidential, Columbus, OHIO. Apr’05 – Feb’07
Business Objects Developer/Analyst.

Description:
Honda Of America Mfg is a major American motor manufacturer. The Project is designed to provide Enterprise query, reporting, and online analytical processing (OLAP) solution for the World Wide Web implemented using Business Objects.

Responsibilities:

• Interacted with Business Users to know their requirements in developing and modifying Universes and Reports accordingly.
• Involved in translating these requirements into system solutions and developed implementation plan and schedule.
• Designed and Built the Universes, Classes and Objects.
• Specified the Joins, checked the cardinalities.
• Defined Cardinality based on the Business Requirements.
• Fine tuned the joins avoiding outer joins and implementing shortcut joins.
• Improved the performance by resolving loops using Aliases or Contexts.
• Exported the universes to the Repository to share the resources among the users.
• Created different types of reports such as Master/Detail, Cross Tab and Charts.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Good experience in working with Ranks, Alerts, Filters, Prompts on reports.
• Extensively worked with multiple data providers and linking these data providers based on the requirements.
• Worked on Application Foundation and Dashboard Manager along with creating Matrix.
• Created reports on the web using Business Objects Web Intelligence.
• Extensively worked on Broadcast Agent server and customized scheduling and publishing reports.
• Published and Retrieved documents in Corporate document repository.
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Involved in migration from Business Objects 6.x to Business Objects XIR2.
• Performing the unit testing of the universes after the development.

Environment: Business Objects XI (Designer, Reporter, Supervisor), Dashboard / Performance Manager, Web Intelligence 6.0, InfoView, ZABO, Oracle 9i and Windows 2000.

Confidential, MN. Feb’04 – Mar’05
Business Objects Developer.

Description:
Prime Therapeutics is a pharmacy benefits Solutions Company dedicated to providing innovative, clinically based, cost-effective pharmacy solutions for its clients and their members. The Project was to develop the reporting needs pertaining to Medicare Part-D and automate the reporting using Business Objects with respect to CMS regulations (Center for Medicare and Medicaid Services).

Responsibilities:

• Created and maintained around Business Objects reports and Web Intelligence reports.
• Built Cross-Tab reports.
• Added/created complex objects to the universe to enhance the report functionality.
• Built Custom Hierarchies in universe to facilitate drill down in the reports.
• Analyzed the reports using Slice and Dice, and Drill Down.
• Created graphical representation for existing reports.
• Performed data validation by creating ad hoc reports.
• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Created complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).
• Documented the deviations from the original specifications.
• Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications
• Enhanced the reports by providing event-handling features.
• Optimized the usage of user objects, conditions and universe level filters.
• Extensively used multiple data providers for building reports
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Performed Check Integrity in universe.
• Tested the universe structure to ensure the tables are properly updated along with the database.

Environment: Business Objects 6.5, Web Intelligence (Reporter, Explorer, Info View), Business Objects SDK, Broadcast Agent Publisher, Erwin 4.1.2 Informatica Power Center 5.1, Oracle 8/9i, BO Designer6.1b, Windows XP.