Certified and accomplished SAP Business Object professional with 10+ years of total IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Retail, Aerospace, Manufacturing, Transportation, Banking, Insurance, Oil & Gas, Utilities, Pharmacy, Hospital, and Finance sectors.

Summary

• Strong experience in Data Warehousing, Business Intelligence concepts & implementation.
• Extensive experience in developing BOBJ applications using SAP BW7.0/7.3 Data sources.
• Experience in developing data models in HANA 1.0 SP4.
• Strong experience in Business Objects 4.0/XI 3.1/XIR2/6.x/5.x.
• Strong experience in Business Objects data services/Integrator XI/3.2/4.0.
• Proficient in Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2008/2005/2000/7.0, (database triggers, materialized views, Packages, stored procedures, functions, and database constraints), SQL Loader, SQL*Plus, SQL Navigator, PL/SQL and oracle DBMS Packages, oracle supplied utilities
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Objects Suite. Involved in conducting strategic evaluation (Proof of Concepts) of the use of Business Objects XI R3.1/R2.
• Experienced in ETL Methodologies using Business Objects Data Integrator/ Services XI 3.1 with Data Quality & Rapid Mart and worked on Metadata Integration (BOMM-Business Objects Metadata Manager) and EPM(Enterprise Performance Management)
• Extensively worked on creating complex workspace and analysis of data using OLAP reporting tool Voyager.
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expert in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test (UAT) and data accuracy test.
• Strong experience in carrying Functional, Integration, Latency, Performance, reliability testing for various Business Objects Enterprise suit products.
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling reports, analysis reports, data reports along with Dynamic LOV using Business View Manager.
• Have good hands on experience in ETL and Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL.
• Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high standards of quality.
• Self-starter who takes responsibility and accountability.
• Excellent time management skills and documentation skills.

Technical Skills:

• Business Intelligence: SAP Business Objects 4.0/3.1/XI R2/ 6.5/ 6.1X/ 5.X, SAP BI, Oracle BI discoverer, Xcelsius, Data Integrator, Business objects Query for Excel, ZABO Infomatica 7.x, SAS business analytics framework( SAS 8 and SAS 9), Qlickview.
• RDBMS: IBM DB2, Oracle 10g/ 9i/ 8i, SQL Server 2000/2005, Teradata 8.5/ 12, Ms Access, SAP BW 3.5, 7.0, SAP ECC 5.0 .
• OLAP: MS SQL Analysis 2000, Business Object Designer 4.1/ 5.1.2/ 5.1.4/ 5.1.5/6.0/ 6.1a/ 6.1b, 6.5/ XI R2/Xi3.0, Cognos Transformer 6.5, ER studio, LCM.
• Data Modeling: Erwin 3.5.5/ 3.5.2, Star Schema Modeling, Snowflakes Modeling, FACT & Dimensions, ER Studio.
• Development Tools: Visual Basic 5.0/6.0, Visual Interdev, Developer 2000, Forms 4.5/ 5.0, reports 2.5/ 3.0, Crystal reports and Lotus Domino, SSRS ( SQL server reporting tool), TFS.
• Languages: C, C++, Java( J2EE), PL/SQL, SQL, Unix Shell Scripting, Perl, CGI Scripting, ASP.
• Internet Technologies: JSP, XML, HTML, Javascript, HTML, DHTML, ASP, VB Script, MTS, IIS, Java Web Server 2.0, Lotus Domino Server, EJB 2.0, Web Services.
• Operating Systems: UNIX, AIX, LINUX, Windows NT, Windows 98/XP/2000/2003, Mainframes (MVS/OS390),VM ware, Citrix.
• Project Management: MS Project, Oracle ADI 11.2, MS Access, MS Visio, MS Excel, and Lotus Notes.
• ETL Tools: Informatica, SQL Data Transformation Services, Cognos Decision Stream 6.0, SSIS, and Business Objects Data Integrator/Data services.

Certifications:

• Business Objects 3.1 Certified Professional ( BOCP)

Education:

• MBA in Finance

Professional Experience:

Client: Confidential, Owego, NY Jan /2012 – Till Date
Role: BOBJ/HANA Architect

Confidential is known for building the finest military aircraft and is organized around core business areas of Aeronautics, Electronic Systems, Information Systems & Global Solutions, and Space Systems.

Responsibilities:-

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Assisted SAP Basis team in installing HANA 1.0 and integrated it with Business Objects 4.0 and BODS4.0.
• Established the best modeling and recommended strategies for BOBJ environment and architecture for SAP HANA.
• Installed BOBJ 4.0 and BODS 4.0 and configured SAP and Windows AD authentication for Business objects enterprise.
• Created Technical specifications and standard modeling documents for HANA.
• Developed testing scripts and performed UAT on SAP net weaver portal using Test ID’s for developers, super users, and end users.
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for HANA, SAP BW7.3 , BODS4.0 and BOBJ4.0
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for the operations, PP, Global sustainment, Quality management tables in HANA.
• Updated Business Objects 4.0, from Patch 2.1 to Patch 2.6.
• Performed Data migration from SQL server to SAP BW 7.3 using Data services batch jobs.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Integrated SAP Net weaver portal to Business objects content using Knowledge management, Iviews, work sets, portal roles.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Developed Webi reports and dashboards for different operations and finance KPI’S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).

Environment:- BODS 4.0, BOBJ4.0, HANA 1.0 SP2, SAP BW 7.3, SAP ECC 6.0, Linux, Ms office, Visio, MS Outlook.

Client: Confidential, San Antonio, TX Oct/2011- Dec/2011
Role: BO/BODS SME

Confidential Provides financial and insurance products and services for well-being of members of the military and their families for generations to come.

Responsiblities:

• Analyzed and created Data services ETL Jobs and Ad Hoc Universes for Consumer Lending, Mortgage, Deposits, Credit cards, Customer Product.
• Rebuild Four Dashboards Using QWAAS and optimized performance at Universe and Query level.
• Created Webi reports using BICS for SAP BW Bex queries as data source.
• Extensively in meetings and interviewing Business and Power users, to determine the flat file layouts, sources, data Layout, Business needs, and naming conventions of the column and table names.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flow’s.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Involved in writing DI/DS scripts and also used some built-in functions like Search, Replace, Lookup_ext and Custom Functions like Sending Email whenever an exception is raised.
• Performed data migration using batch jobs whichinvolved extensive useof simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc in Data flows.
• Used Data Services as an external system for ETL between ECC and BI for cleansing and conversion the data using Quality transforms like Match, Associate, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Installed BODS 4.0 on Windows and configured with Information steward platform.
• Performed Data Insight andconfigured Repository manager and server manager with Information Steward.
• Configured CMC with Information steward and worked on Metadata management tool of Information steward
• Worked with Delta records by using CDC (Change Data Capture) on both the source level and target for SCD (slowly changing dimension) of Type 1, Type 2 and Type 3
• Installed and Configured BODS4.0, BO 4.0 and Job servers on Clustered windows 64 bit servers.
• Integrated Crystal reports to Share point portal and updated Web.XML, BO Timeout sessions, Java scripts as per the installation requirement and business requirements.

Environment:- BODS 4.0 Client and Server tools , BOXI4.0 Server and Client tools, Teradata 13.0,ECC6.0, MS Outlook, SAP BW7.0, Information Steward, DB2 Configuration Tools.

Client: Confidential, Vienna, VA July/11- Oct/11
Role: BO/BI Migration Lead

Confidential is the world’s largest credit union and an armed forces bank. Serving the Navy, Army, Marine Corps, Air Force, Veterans, and DOD.

Responsibilities:

• Migrated 1500+ Crystal, Webi reports, Universes, 60+ Dashboards and BOBJ applications along with their data sources.
• Administrated six servers for 3.1 environment and three servers for XIR2 environment.
• Enabled Windows AD authentications with Kerberos along with enterprise aliases for 3.1 and created aliases script for password same as user id for enterprises aliases.
• Worked on Profiling and Auditing in migration by referencing AIO_CUSTOMER_MASTER_JOB, created the job to load into customer master segments
• Installed and configured BOXI3.1 and updated it to SP4.
• Updated webs XML, aliases, add scripts, Tomcat, HTTP Scripts as per the requirements.
• Performed data migration using data services batch jobs from DB2 to Teradata 13.0.
• Added Microsoft plug-in and java plug-in for 3.1 Environment.
• Configured SMTP, destination job servers, crystal reports servers, webi servers, RAS, Adaptive job servers, CMS servers in 3.1 dev and Production environments. Added commands and parameters in the server command line.
• Cloned WEBI servers, Crystal reports servers and Cache servers to enhance the performance in 3.1 environments.
• Customized 3.1 Infoview portals and created DSN for 32 bit and 64 bit OS.
• Developed technical documents and scripts for Migration Plan.
• Extensively used Import wizard for transporting objects and folders to new environment.
• Migrated Personal content, report instances and personal categories for 9600+ users.
• Migrated Xcelsius dashboards and deployed QWAAS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Used Query builder to query Repository and to recognize number of groups, users, active users, frequent users.
• Enabled auditors for XIR and XI3.1 and created auditing reports.
• Developed testing scripts and test cases. Extensively tested BOBJ reports, dashboards and other BOBJ Applications in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.

Environment: SQL Server 2008,IBM DB2 9.1,Oracle 11g, Teradata 12.0, BOXI 3.1 SP1, BODS 3.1,SAP BO Fix pack SP4, APOS, Xcelsius 2008, Crystal reports 2008, BO XIR2.

Client: Confidential, Schaumburg, IL Jan/11 – June/11
Role: BO/BI Architect

Confidential is the home of integrative and compassionate cancer care.

Responsibilities:

• Assist clients in managing project scope, risk, resources and budget. Developed Corporate and Hospital dashboards using Live office, QWAAS. Installing and configuring BOX13.1 SP3 and Xcelsius 2008 in windows environment.
• Designed prototype for webi and dashboard. Performed UAT, integration and performance testing for webi and dashboards.
• Designed and developed Universes, Classes, Objects, and Hierarchies for Corporate account reporting process and Management reporting process.
• Configured Mobile client, server and Mobile OTA files to Integrate BOBJ Dashboards and explorer reports to Mobile devices.
• Maintaining the enterprise repository includes security of Users, groups, predefined settings, Universes, reports, domains, and categories in the CMC.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Created complex reports and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Created and Customized Dashboards for users. Created various analytics like Speedometers, Interactive Metric Trends (IMT) and Barometers
• Extensively used the @functions and Aggregate Aware feature. Worked on back end functions, procedures, tables, views required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Implemented Object level security which helps the universe to incorporate security for sensitive information.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Applied most advanced Business Objects functionalities like conditional hiding, ranking, hyper linking, conditional sorts, alerter etc.
• Extensively used Alerts while creating the Xcelsius Dashboards and used Functions like VLOOKUP, IF ELSE Involved in Performance tuning of Universes by creating alternate views and indexes , ROUND, COUNT, CONCATENATE for while pivoting the Data to Xcelsius.
• Performed Load, UAT, and Integration testing for Dashboards.
• Full cycle implementation for 5 Hospital and Corporate Dashboard.

Environment : SQL Server 2008, BOXI 3.1 SP3 , Mobile Client, Xcelsius 2008, QWAAS, Live Office, CMC, CCM, MS Office ,MS Outlook.

Client: Confidential, Houston, TX Oct/10 – Jan/11
Role: BO/BI Lead
A top-tier oilfield service company with a century-long track record, Baker Hughes delivers solutions that help oil and gas operators make the most of their reservoirs.
Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes, Reports, and Dashboards accordingly.
• Worked with the Users and clients to identify the priorities, to know the Business Critical and complex universes and reports
• Written DS Scripts for File existence check, Daily incremental read, Daily Incremental update, workflow level Script read, workflow level Script update, workflow level Error Handling and Job Dependency.
• Debugged exsisting mapping, mapplets, and dataflows in GL Rapid marts using breakpoints.
• Extracted and audited data for SAP Tables, functions, Idocs.
• Created various Universes using Bex queries connections.
• Developed multiple navigational dashboards for different KPI’s like HSE, Procurement, OTD, MVAR, Shipment, and Finance using Xcelsius 2008.
• Created 42 webi and crystal reports based on OLAP Universes.
• Involved in Creation of Alerter with various conditions. Created Dashboards using Xcelsius.
• Created reports with high end functionalities like drill down, slice and dice, Alerts, Charts, and Crosstabs.
• Designed and maintained Universes and exported them to the repository.
• Used various components and selectors to achieve navigation, dynamic visibility, and what if analysis in the dashboards.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Performed Data profiling, US address and data cleanse using data quality and data insight configured on Information Steward.
• Created Webi reports on FI, Copa, and Operational data extracted from ECC to the BI7.0.
• Created Webi reports for Profitability Analysis based on the COPA Data sources via Bex queries Universes.
• Created and Customized executive and performance Dashboards for users. Created various analytics and components like Speedometers, Interactive Metric Trends (IMT), Charts, Filters, Selectors, and Barometers.
• Used Business Objects Data Services XI 3.1 cleansing transformations for de-duplication, house-holding and address parsing.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Extensively worked with CMC to migrated objects packages into QA and Production environments.
• Performed Unit testing and validated reports using BEX Analyzer.

Environment: SAP BW 7.0, Xcelsius 2008, SAP BO Client tools 3.2,webiInfoview, MS outlook, MS Office, Bex Analyser, Designer, VB Macros, QWASS, Live office, ECC6.0, BODS 3.1, Information Steward, GL Rapid marts, BODS 3.1

Client: Confidential, Jackson, MI Apr/10 – Sep/10
Role: Lead BO/BI Consultant

Confidential is the Michigan based second largest gas, and electric utility providing company.Providing services to more than 6 million Customers in the State’s and 10 million customers in 68 countries.

Responsibilities:

• Gathered, analyzed the requirement and build necessary specifications.
• Build the new universes as per the user requirements by identifying the required tables and defining the universe connections.
• Used management Console for administrative purposes in BODS Projects, jobs.
• Build dataflow, workflows, mapplets, variables, and customized functions in BODS Projects.
• Extracted data from flat flies, oracle tables, and performed cleansing and modeled using various transformations as per the requirement.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Designed Universe by creating the Business Objects Data Model selecting joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects
• Developed complex SQL, PL/SQL code to enable user queries to the database for data access, using triggers and stored procedures.
• Conducted end user training for basic and advanced reporting skills.
• Trouble shooting and Performance tuning of the reports and Universe.
• Used Info view for scheduling the reports, monitored and leaded the onshore team.
• Installed the SAP integration Kit and performed ETL on Oracle sources and SAP sources data on SAP authentications.
• Configured and enhanced the security of universes, Row level security, and provided privileges and rights to different users.
• Created complex views to overcome loops and contexts and Extensive analysis to design the Universes and assigned them to respective domains
• Implemented Row Level Securities and Object level security in the database level, which helps the universe to incorporate security for sensitive information
• Working on the SQL tuning and optimization of the Business Objects reports.

Environment: Oracle 11g, BOE Client tools 3.1 sp2, QC, Info view, MS Office, Lotus notes, Windows XP, WEBI, Service manager 7, SAP BW7.0, BODS 3.1.

Client: Confidential, Deerfield, IL June/09- Mar/10 Role: Lead BO/ETL Developer
Walgreens is the largest drugstore chain in the United States. The company operates about 7,034 drugstores across all 50 states, the District of Columbia and Puerto Rico.
Responsibilities:

• Manage Users (using CMC created user and assign the different level of access, delete user). Also creating folders and providing the access to users.
• Creating Folder and subfolders for different categories (Purchasing, Sales & Marketing) of reports and which will help in providing access to the users.
• Performed scheduling of reports through broadcast agent in legacy system and through CMC in new system.
• Designed, developed and maintained Universes for supporting Adhoc and canned reports
• Worked on Building Universes from Oracle for the Oracle Inventory, GL, Order Management, Supply Chain Planning, and COMS RM etc.
• Worked with the infrastructure team to define reference architecture of the various reporting tools.
• Created Hierarchies from providing drill down options for the end-user
• Created Context, Alias to resolve the Loops in the universe
• Modifying the existing universes, Adding new objects editing joins, mapping the existing objects with renamed tables
• Used the @ Functions such as @ AggregateAware, @Select, @Prompt, @Variable in designing Universe
• Resolved the fantrap and chasm traps problems and detected cardinalities and checked the Integrity of Universes
• Configured third part authentication and extensively used BIAR line commands.
• Used Import Wizard for migrating universe and reports in different environments.
• Created Dashboards using Xcelsius 2008, created QWAAS, Linked the Dashboards to webi reports and also used open document function at report levels.
• Created Database Objects such as Views, Functions, Stored Procedures with Respect to the Requirements of Universe and Reports Development.
• Populated the tables using integrated data and perform auditing and cleansing jobs.
• Created Monthly and Summary reports for the different domains like Finance Account Payable details, AP invoice and PO reports, AR activity report with SO, AR aging and Customer Trail Balance , GL Journal Lines, Sales by Product Code, Customer billing Summary etc.
• Migrated reports from 6.5 to XIR3.1 environment using Import Wizard.
• Worked on Data Insight which provides an easy to use, graphical design environment that includes data Profiling tasks
• Written DS Scripts for implementation of Recovery Mechanism for unsuccessful batch jobs execution.
• Used Business Objects Data services XI interactive debugger to test the jobs and fixed the bugs
• Developed & Distributed Web Intelligence reports and Dashboards in Excel and PDF format and Performed daily Backup through BIAR File System.
• Performed Unit test for validation and performance. Involved in all UAT phases
• Personified and agile the Webi reports and dashboards for the users by enabling them to be accessed by iphone using Roambi.
• Performed testing of reports and dashboards using Teradata SQL assistant and Quality Center.
• Created Structures, Selections, Restricted Key figures, Calculated Key figures, formulae and if-else conditions according to the requirements.
• Developed deski and webi reports on top of the OLAP universe.
• Performed GAP analysis between legacy system and new environment.

Environment: Windows Professional, SAP Business Objects BOXI3.1, data federator, Crystal reports XI, CMC, CMS, Application Foundation, Web Intelligence, Xcelsius 2008, BODI XI, Designer, SAP BW 3.5, Universe Builder, Import Wizard, Teradata 12.0,Oracle 10g, VB Macros, Teradata SQL Assistant, Quality Center, Mobile Client.

Client: Confidential, NYC, NY Oct/08 –May/09
Role: Sr. Business Objects/ ETL Consultant
AGI Americas in an Asset Management company which manages assets close to $ 70 billion. AGI deals with financial products like Mutual Funds, 529/ offshore plans and Managed accounts.
Responsibilities:

• Worked on Reports Rationalization of 120 reports based on functionality, usability.
• Installed & configured Business Object 3.1 development, production environment and DR environments.
• Implementing Vintela Single Sign on using AD Authentication.
• Built an exceedingly complex universe that encompasses different subject areas like Assets, Transactions, and Performance.
• Built the security model that includes defining customs access levels and was responsible for administration using CMC and CCM.
• Performed report bursting for group user using Business objects CMC.
• Built around 28 highly personified and cooperate reports using Web Intelligence and many full client reports across subject areas along with 3 Dashboards using Xcelsius 2008.
• Installed Integration Kit and made local gateways for integration purposes.
• Utilized Aggregate Awareness Functionality that included at least 12 aggregate tables with high volume fact tables.
• Developed REFX( Real estate contract),Terms, Contract measurement reports for mortgages and loan KPI’s Analysis.
• Used various transformations like Map Operation, Table Comparison, Row-Generation, Query History Generation, Key Generation, Pivot and Query.
• Resolving join problems in universe and optimizing the universe and Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Performed Business Objects like Slice and Dice, Drill Down, Drill Through, @Functions and formulas.
• Used QAAWS for pulling information from the universe and developing Dashboards.
• Performed tuning of data both at ETL level and DB level, optimized the disk space, eliminated the null values and updated data in the tables at database level.
• Supported/ Administrated 200 users that included 10 power users in the first phase of the project.
• Configured the security setting on universe levels and worked on enhancing the performance and tuning of universes.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Implemented backup and recovery for reports and universes in legacy system before importing to new environment.
• Analyzed requirements, Designed review reports for implementation; and Managing and testing the flat-file code to move data from Source DW to Target DW for existing and new jobs.

Environment: Business Objects Enterprise 6.5/XI 3.1 SP2, BO Designer, TOAD, Web intelligence 3.1 SP2, crystal reports, QWAAS, Xcelsius 2008, BODS 3.1, Desktop Intelligence, Bex Analyzer/ Explorer, Windows XP/2008, Windows XP/2008, Informatica 8.1, Visio, BODI 6.5, Project,oracle 10g,PL/SQL,SAP BW 7.0

Client: Confidential, Plano,TX July/07 -Sep/08
Role: Lead BO/BI consultant

RTAPS is a sub ledger for Account Payable module of Foreclosure Processing System of Recon Trust Company and the Corporate Account Report process will be a collection of standard financial reports developed in Business Objects.
Responsibilities:

• Developed complex dynamic multi linked (open document) Webi and Crystal reports.
• Designed and developed Universes, Classes, Objects, and Hierarchies for Corporate account reporting process and Management reporting process.
• Compared and edited objects for exporting to the repository using BODI.
• Maintaining the enterprise repository includes security of Users, groups, predefined settings, Universes, reports, domains, and categories in the CMC.
• Involved in Creation of Alerters with various conditions. Created Dashboards using Xcelsius.
• Developed several simple & Complex Reports (include multiple groupings, sub-reports, drilldowns, parameter fields, conditional display of sections, Running Totals, formulas and retrieving data from more than one database) using Business Objects Enterprise Crystal XI R2/Web I/ Desk I.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, Teradata and Worked on integrating data from flat files like fixed width and delimited.
• Extracted ODE-OSAT Enterprise Applications and pre build Transformation logics through Rapid Mart for OSAT ETL jobs as per ODE Requirements review
• Prepared the architectural flow of data and created pipeline partitioning to improve session performance.
• Process using the Universes & Free- Hand SQL as the main Data Providers.
• Leaded the team of 5 people on onshore for creating cooperate dashboards.

Environment: Windows XP, Oracle 10g, Business Objects XIR2/R3 Info view/ Web Intelligence/Crystal reports (XIR2, XIR3), SQL server 2005,Teradata,Teradata SQL assistant, Microsoft Sharepoint 2007, Xcelsius, Live Office, Unix, Informatica 8.1., Rapid Marts, BODI.

Client: Confidential, Middletown, CT Jan/06 - June/07
Role: Sr. BO Developer
Aetna is a healthcare insurance company which provides variety of Insurance products and services to employer groups, individuals, health plans and government sponsored plans.

Responsibilities:

• Developed and designed POC for implementation of BI.
• Played an architectural role, in establishing user access and system set up in various environments (Clustered Network).
• Involved in database development by creating PL/SQL functions, procedures, triggers, and packages and materialized views.
• Worked as an Application developer in designing Universes and Web I (XIR2) Reports.
• Involved in setting up of folders, groups, LDAP security, Object Migration and Performance tuning.
• Implemented and Involved in Onshore- Offshore Delivery model during design, development and testing phase. Implemented new XI R3 environment against Oracle Server and imported data from SQL Server sources and loaded it to the targets.
• Implemented SQL stored procedures for performance intensive reports, which also requires constant scheduling.
• Created multiple universes to support as hoc reporting environment and implemented Crystal Xcelsius 4.5 as the dash boarding tools, created links to flash files from the Web content.
• Introduced BO voyager for report development using cubes and used clear case and PVCS for versioning for the reports.
• Developed complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Leaded offshore team of 4 people for report design and development of SP’s and reports.
• Planned, Designed and scheduling the training power users on Ad – hoc reporting.
• Implemented and created a plan for XI R2 migration from 6.5.

Environment: Business Objects XI R2/6.5 , Web Intelligence, BO Voyager, Broad cast agent, Crystal Reports 11.5, Business Views, QAAWS, Windows XP, PVCS, Oracle discoverer, Oracle 9i,SQL Server 2005, Infomatica Powercenter 6.0.

Client: Confidential, UK Jan/04 -Dec/05 Role: Sr. BOBJ Consultant
TESCO is a leading retailer in UK with almost 2000 stores. The company operates stores in 13 countries.

Client: Confidential, London,UK. Jan/03 - dec/03 Role: Business Object Developer
Unilever is one of the largest global manufacturers of consumer goods, with more than 50 brands in product groups such as home and personal care, food, beverages and specifically chemicals with 200 plus suppliers and with thousands of orders in a week.

Client: Confidential, India July/02 – Dec/02 Role: Programmer Analyst
The project aims the easy accessing of transport system. This project is implemented just to come over different problems to be faced in the transport system.