Professional Summary:

• 10 years of experience in Information technology with skills in all phases of Data Warehouse lifecycle development, Client/Server and Internet Applications.
• Experienced in providing end-to-end Data Warehousing solutions in various phases of software development including System Requirements Analysis & Design, Development, integration testing, implementation, Support and End-user Training.
• Over 8 years of extensive experience in Business Intelligence tools using Business Objects 5x/6x/XIR2/R3, CMC, Supervisor, Designer, Reporter, Broadcast Agent, WebI 2.x/6.x/XI, andLiveOffice.
• Experiencedin extraction, transformation and loading (ETL) using Informatica 7.1/8.1, BODI, Oracle Warehouse Builder and Ascential DataStage EE/PX 7.0/7.5.
• Expertise in working and implementation of Crystal Enterprise, Crystal XI R2, Publishing Wizard and Crystal xcelsius.
• Expert in migrating Business Objects5x / 6x to Business Objects XI R2/XI3.
• Expertise in Installing, Configuring, Migrating, Upgrading and Administration of Business Objects products, Informatica Power Center and Data Integrator and experience in all phases of SDLC.
• Experience in Integrating Business Objects with SAP BI/BW on Windows and UNIX Platforms.
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects with Databases like Oracle, SQL Server and SAP.
• Extensive knowledge in Brio/Hyperion, SAP Bex & StarRez.
• Extensively experienced in working with Microsoft BI Studio using SSAS, SSIS and SSRS.
• Experience in designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Expertise in databases like ORACLE 8i/9i/10g, Sybase11.9/12.5, MS SQL Server2000/2005, MS-Access.
• Very good in the area of PERL programming, scripting and automation using Shell Scripts on UNIX.
• Strong technical, logical, code debugging, communication, time management and interpersonal skills.
• Effective working alone or as a cooperative team member with professional appearance and presentation.
• Aptitude to learn new things and ability to perform under stress.

Technical Skills:

BI Tools: Business Objects 5x/6x/XIR2/3.1/4.0 (CMC,Desinger,Reporter,Supervisor), Web Intelligence 2.x/6.x/XI ,Broadcast Agent, Live Office, Application Foundation 6.51, BO SDK using ASP and JSP, SSAS, SSRS, Crystal Reports XI, Xcelsius, Hyperion and Brio, StarRez, SAP BI/BW, Bex, SAP ECC/R3.
ETL: Informatica 7.1/8.1(Power Mart & Power Center), BODI, Oracle Warehouse Builder 10g, Ascential DataStage7.0/7.5.
RDBMS: DB2, Oracle 8i/9i/10G, TeraData, MS SQL Server2000/2005, Sybase 11.9/12.5.
Internet: J2EE, XML, Java Beans, Servlets, JSP, ASP, VB Script, JavaScript
Languages: Java, PERL, C++, C, VB, Shell Scripting
OS: Sun Solaris UNIX, Windows 95/98/2000 /NT/XP.
Servers: Web Logic Application Server 4.5/5.1/6.1, WebSphere , TOMCAT 3.2.1.
Scheduling Tools:AUTOSYS, CRONTAB.
Tools: ERwin 4.0/4.1, Visio, MS Project, TOAD, Remedy, Putty, SQL Navigator 4.1, ClearCase, PVCS, SMS, Mirant Tracker and SQL Query Analyzer.

Professional Experience :

Confidential, Old Tappan, NJ Oct 2011-Till Date
Sr. SAP Business Objects Admin/Developer.

• Worked on end to end Data Warehouse project lifecycle implementation.
• Interacted with Business Users to gather requirements.
• Created Webi and Deski reports.
• Created linked Universes to share common objects.
• Installed clustered BOXI 3.1 servers.
• Worked on BO Development and Admin issues based on Changepoint tickets.

Environment: Business Objects XI3.1/XIR2, Web Intelligence XI, Informatica 8.1, SQL Server 2005, Oracle, Teradata, Windows XP, Unix, Changepoint.

Confidential, San Francisco, CA April 2010-Aug 2011
Sr. SAP Business Objects Admin/Developer.

• Created Business Objects groups and users and managed user profiles as per SMS requests.
• Created/Modified License cleanup webi reports and SMS crystal reports.
• Ensured timely development completion.
• Worked on end to end Data Warehouse project lifecycle implementation.
• Created Universe on top of CCR Data Marts.
• Created Webi and Deski reports.
• Worked on Claim confirmation reports schedule using Java program.
• Installed and Configured BOXI servers.
• Setup Stage and Break Fix environments in EDI Team
• Extensively used Informatica to load data from Facets (third party application), Excel spreadsheet, and flat files into the target Oracle 9i database.
• Worked with Release Management and Change Control for Code Migration

Environment: Business Objects XI3.1/XIR2, Web Intelligence XI, Crystal XI, Informatica 8.1, SQL Server 2005, Oracle, Teradata, Windows XP, Unix, PVCS, Mirant Tracker .

Confidential, San Francisco, CA Aug 2009-Mar 2010
Sr. SAP Business Objects Admin/Developer (Corporate Properties Group)

• Interacted with Business Users to gather requirements.
• Created Business Objects groups and users and managed user profiles using CMC.
• Created views in Oracle and SQL server Databases for reporting.
• Created Universes on top of SQL server and SAP BI.
• Involved in analyzing and validating the data source.
• Migrated Universes and reports from XIR2 to XI3.
• Having significant knowledge working with Info Cubes, Multi Cubes, and Info Objects.
• Created Xcelsius and BI dashboards/reports.
• Created webi/deski canned reports and adhoc reports as per the customers perspective
• Developed documentation and training material for Naïve users
• Worked on Auditing and Publication.

Environment: Business Objects XI3/XIR2, SAPBI/BW, Web Intelligence XI, SQL Server 2005, Windows XP, Clear Case.

Confidential,Palo Alto, CA Mar 2008-Jul 2009
Sr. SAP Business Objects Developer.

Worked with Residential & Dining Enterprises (R& DE) at Stanford University in delivering the reporting needs of the Student Housing and Dining departments.

R& DE\'s Information Technology group is a team of computer professionals responsible for providing responsive, efficient technology support to R& DE\'s computer users; developing cutting-edge data solutions to enhance R& DE\'s operational efficiency throughout its diverse housing, dining, conference, marketing, and administrative operations; and aligning R& DE\'s technology infrastructure with the systems and support at the University as a whole.

Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and reports development.
• Created Business Objects groups and users and managed user profiles using CMC.
• With advanced SQL query programming, developing and migrating reports from Business Objects to StarRez, Crystal Reports.
• Helped users is developing there own proprietary reports.
• Took lead role on BO testing side when back end database got migrated from 9i to 10g
• Worked on Gap/Data analysis for migration of reports from BO to StarRez with underline databases.
• Analyzed existing Brio reports then recreated same in Business Objects XIR3.
• Created linked Universes to share common objects as per the business needs.
• Experience in Report generation using Multiple Data sources and Experience in Data Warehousing and Business Intelligence reporting using Cubes, Complex Measure Groups and Dimensions.
• Proficient in utilizing the crystal reports and Xcelsius.
• Designed Universes from different databases like Oracle 10g and SQL Server 2005.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Tuned Mappings for optimum performance. Applied Performance Tuning logic at mapping and session level.
• Providing support for operational efficiency throughout housing, dining and conference operations.

Environment: Business Objects 5x/6.5/XI3, Web Intelligence 6.x/XI, StarRez, Crystal Reports, Xcelsius, Hyperion/Brio, Oracle 10g/9i, SQL Server 2005, SAP R3, SAP BI/BW, SSAS, SSIS, SSRS, Informatica 8.1, People Soft, Toad 9.x, Win XP.

Confidential,Stamford, CT
SAP Business Objects Developer(CARE) May 2007-Jan 2008

UBS is one of the world’s leading investment banking and securities businesses, providing a full spectrum of services to institutional and corporate clients, governments and financial intermediaries globally.

The system CARE - Corporate Action Processing Engine is being developed to automate the Corporate Action business process. The CARE processes the various types of corporate events.

Responsibilities:

• Installed BO XI R2 and configured repository.
• Involved in Server Architecture and created Documents for Environment Planning
• Migrated BO Universes, Reports and User Profiles from BO 5x/ 6x to Business Objects XI R2/R3.
• Created Business Objects groups and users and managed user profiles using CMC.
• Involved in analyzing and validating the data source.
• Integrated BO with SAP BW Using SAP Integration kit and Published Reports to SAP R/3.
• Enable Auditing functionality for BO environment and troubleshoot Apache/tomcat issues.
• Configured LDAP on Business Objects Server.
• Experience in re-deploying war files for application related issues
• Having significant knowledge working with Info Cubes, Multi Cubes, and Info Objects.
• Weekend Support for major system changes.
• Created, managed and formatted standard reports, master/detail reports for the decision support system regarding to the company’s Investment.
• Created reports using Crystal Reports XI with Standard, Cross Tabs, grouping, sub reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities etc.
• Created Xcelsius reports for presentations.
• Training new developers in the team to develop BO reports.
• Developed sequence jobs using Job sequence for controlling the jobs.
• Developed many Datastage application jobs for data processing and loading, jobs are scheduled using Datastage Director.

Environment: Business Objects 6.5.4/XIR2, SAP R3, SAPBI/BW, Web Intelligence 6.x/XI, Crystal Reports, Xcelsius, DataStage 7.5,Oracle 9i, SQL Server 2005, SSAS, SSRS, SSIS, Windows XP, Clear Case, Sybase11.9/12.5, TOAD, PLSQL.

Confidential, Stamford, CT
Business Objects Developer (DOX) Aug 2006-May 2007

DOX is the primary UBS system that facilitates contract negotiation and captures contract terms for all major trading agreements. As part of legacy DOX is stored in SQL server 2000 which then is replicated in Oracle data mart through overnight process. The same is made is available for reporting.

Responsibilities:

• Migration of BO Universes, Reports and User Profiles from BO 6.5.1 to Business Objects XI R2
• Created Business Objects groups and users and managed user profiles using Supervisor.
• Developing universes as per the requirements of the universe and deploying and maintaining the universes. Trouble shooting if they raise any issues with the universes.
• Extensively created hyperlinked reports with more than two levels.
• Designed Universes from different databases like Oracle and Sybase.
• Created Crystal Reports XI with Standard, Cross Tabs, grouping, sub reports.
• Involved in creating packages, procedures, Functions & Triggers and also embedding dynamic SQL features advanced packages in PL/SQL, which generates the Flat Files.
• Created, managed and formatted standard reports, master/detail reports for the decision support system regarding to the company’s Investment.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts, Ranking, Filtering for creating Business Objects reports.
• Migration of BO Reports form 5.1.4 to 6.5.1
• Developed the VBA macro to automate the process of fetching the reports from repository, refreshing it and sending it to the Microsoft outlook through Broadcast Agent
• Scheduled and Processed Business Objects reports through Broad Cast Agent.

Environment: Business Objects 6.5.1/XIR2, Web Intelligence 6.x/XI, Crystal Reports, DataStage 7.5, Oracle 9i, Windows XP, Clear Case, Sybase, SAP BW, TOAD, PLSQL, MS SQL Server2000.

Confidential,San Francisco, CA Aug 2003-May 2006
Business Objects Developer

Actelion Pharmaceuticals Ltd is a biopharmaceutical company, dedicated to discovering and developing better ways to treat and prevent disease, improve the health and quality of life for people around the world. I developed reports as part of the Information Management department. The reports were used by multiple user groups. Patient metrics set of reports were for the worldwide sales and marketing team for tracking their product data. The company goals reports for the management in US and Switzerland for looking at corporate performance data. The HR department looked at employee data and incentives reports

Responsibilities:

• Involved in analyzing and validating the existing Database.
• Managed various modules and implementing the requirements according to the end user needs.
• Designing the Universe, Created Contexts and Aliases for resolving Loops in the Universes.
• Analyzed the existing database and designed Universes by creating Classes and Objects.
• Created objects using different Business Objects functionalities like @ prompt, @variable, @select in the process of designing the universes.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created Webi and Desktop Reports as per the requirement.

Environment: Business Objects 5.x/6.x, Designer, Supervisor, Info view, Web Intelligence 2.7, Oracle 9i.

Confidential, Hyderabad, India Jan 2002-Jun 2003

Client: Confidential

Police Department is the most important, demanded and credible functional department in the society in order to maintain the Law & Order. To integrate, maintain and execute these functionalities, the manpower required is in large number even though it is most tedious task to work most efficiently at the low rate level of easiness. But fortunately this VCOPS (Versatile Computerized Operations of Police Services) project would certainly help the system to reach the above said level with very much easiness, high degree of flexibility as well as transparency.

Responsibilities:

• Designed the Database and Created the Database
• Testing
• Database maintenance
• Backup and disaster recovery
• Installation of the database
• Software Maintenance, Customization and Enhancement

Environment: MS VB 6.0/ASP with Seagate Crystal Reports, Back end with Oracle 7.x on SUN Solaris Platform as main Database server, Java, MS Exchange server on MS advanced server as Mail server and each client with Windows 95/NT Professional.

EDUCATION:
Master of Computer Applications