SUMMARY:

• Over 21 Years of experience in fast track career with impressive track record in architecting and building cutting edge reporting solutions using Business Objects technologies that helped clients to reduce costs and improve efficiency.
• In depth experience with Enterprise Architecture and Business Objects reporting solutions which includes Business Objects XI R2/R3 and BI 4.0/BI4.1 with Performance Manager, Crystal Reports 2008/2011/2013 , SAP HANA, BO Java and .Net SDK, Business Objects Data Integrator, Actuate, Cognos Oracle 7.x/8i/9i/10g/11g, Informatica, Portal, Unix, Shell Scripting, Automation, AIX 5.3/6.1/7.1, AIX virtualizations, Websphere 6.1/7.1 and 8.5, Willy, Tivoli, IBM IHS, iPlanet, Apache Tomcat, IIS Java and VB.Net.Database design, conceptual, logical and physical data modeling, star schema, snowflake; FACT and dimensions tables, slowly changing dimensions (SCDs)

SPECIALTIES:

• Business Objects XI R2/R3 and BI 4.0/BI41, Performance Manager, SAP HANA, Business Objects Data Integrator, Crystal Reports 2008/2011 and 2013, Xcelsius, Tableau, Qlikview, Actuate, Cognos, Informatica, Pervasive, Big Data, Hadoop, Oracle9i/10g/11i, SQL Server 2008, Unix, Linux, AIX 5.2/6.1 and 7.1, AIX virtualization, Shell Scripting, Automation, Enterprise Architecture, IBM WebSphere 6.1/7.1 and 8.5, Java, JSP, ASP, VB.Net, and more.
• Global Team Manager - Medium to large size onsite, remote onshore and offshore teams.
• Have an extensive knowledge in project management, team building experience, interpersonal and communication skills and the ability to interact with all levels of business and technical personnel

TECHNICAL EXPERTISE:

RDBMS: Oracle 7.x/8i, 9i, 10g/11g, Sybase Adaptive Server 11, SQL Server 2005/2008/2012 and DB2

Operating Systems: AIX 5.3/6.1/7.1, UNIX, Solaris8, Windows NT/XP/ 2003/2008/2012

DSS/OLAP Tools: Business Objects 5.x/6.5/XI R2/R3, BI4.0/BI4.1, Performance Manager (Supervisor, Designer, Reports), Excelcius, Crystal Reports 2008/2011/2013 , Web intelligence 2.7/6.5/XI R2/R3, BI4.0/BI4.1 with Java and .Net SDK, ZABO, ERWIN, Visio, Power Designer, Ambeo and Reflection

ETL Tools: Infomatica Powercenter 8.6, Data Services and Pervasive

Languages: C, C++, PASCAL, PL/SQL, VB.Net and Java2

Web Technologies: HTML/DHTML, VBScript, Java Script, JSP, CORBA, RMI, IIS 6.0/7.5/8.5 Apache Tomcat 5.5/6.0/7.0, WebSphere 6.1/7.1/8.5, IBM IHS, iPlanet, and ASP 2.0/3.0/.Net

Oracle Tools/Utilities: SQL*Plus, Exp/Imp, SQL*Loader, SQL*NET/NET8, INFORMATICA, Q & E Editor, TOAD and Rapid SQL

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Completed technical and infrastructure design for a 3 tier integrated Business Objects reporting solutions that process 150,000 reports per day supporting 600K users across the globe supporting 24 languages.
• Completed technical and infrastructure design for 3 tier integrated Business Objects reporting solutions for 10 applications that are medium to large size.
• Installation and configuration of near about 140 Business Objects enterprise 3.1, BI4.0/ BI4.1 on AIX servers with clustered configuration for all the applications under Confidential BO STE
• Developing of an extensive BO SDK code that enables to run, schedule and access the Business Objects reports through front-end application frame work
• Managing Business Objects infrastructure from Development through Production/ Confidential
• Managing Business Objects service packs and version upgrades.
• Supporting 57 Business Objects environments with 140 BO installations
• Supporting the development teams for all STE related tasks (content promotion, troubleshooting and fine tuning) across 57 environments
• Supporting/managing the CitiDirect E2E Business Objects infrastructure that includes Reporting Services Framework (RSF), Tibco and BSI.
• Completed the migration of Business Objects installations from one data center to another data center as part Confidential data center migration initiative from Silver Spring MD to Mid-West data center.
• Coordinating annual Confidential and internal Confidential tests
• Implementing the best practices in Business Objects implementation across the Confidential BO STE
• Implementing the monitoring standards using Tivoli, Shell Scripting and SiteScope
• Working with SAP vendor in resolving all the product related and performance related issues
• Fine tuning the CitiDirect BO configuration to handle the massive load (10 to 12K per hour peak time report runs)
• 24X7 L3 Production support

Environment: Business Objects XI 3.1, BI4.0/BI4.1, SDK, JSP, Oracle 10g/11g, SQL Server2005, DB2, Crystal Reports 2008/2011 and 2013, Solaris, WebSphere 6.1/7.1 and 8.5, TIBCO, BSI, Tivoli, Willy, Unix, Linux, AIX 5.3/6.1 and 7.1

Confidential, Livingston, NJ

Responsibilities:

• Technical Architecture - Completed technical and infrastructure design for an end to end Business Objects reporting solution that includes data collection from ED, Billing systems, and creating the metrics, analytics then delivery through standard reports and customized dashboards
• Installation/configuration of Business Objects 6.5.2/XI R2/R3.1 with Performance Manager.
• Migrated the AF customizations from 6.5.2 to XI R2 and XI R3.1
• Created data model using ERWIN for ED, Billing and Financial reports back end data
• Developed ETL jobs using Informatica, Pervasive, SQL scripts and Business Objects Data Integrator to load the data into reporting data warehouse.
• Developed nearly 500 most complex reports with drill down functionality through report linking
• Created the highly customized dashboards using Xcelsius and Dashboard Manager.
• Worked with vendors (SAP, Oracle, Informatica and Pervasive) in resolving all product related issues.

Environment: Business Objects 6.5.2, AF 3.6, XI R2/XI R3.1 with Performance Manager, SDK, JSP, Oracle 10g, Informatica, Pervasive, Data Integrator, ERWIN and Windows 2003.

Confidential, West Point, PA

Responsibilities:

• Installation and configuration of Business Objects 5.1.6
• Consolidation of multiple Business Objects into single STE model.
• Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
• Provided the first level support to approximately seven groups consisting of 6000 users
• Facilitate logging through resolution of all issues with software vendor
• Act as a primary communication vehicle
• Designed and implemented the best practices for Business Objects application
• Upgraded Business Objects platform from 5.1.6 to 6.5.2 and 6.5.2 to XI R2
• Re-defined the security in XI R2 and implemented the best security model in XI R2 using new security features
• Administration of WebI, BCA and XI R2 server environment
• Optimized BO XI R2 system performance by fine tuning the XI R2 servers
• Co-ordinated with MSI team for Business Objects full client deployment
• Providing support and guidance to development teams in building complex reports/universes
• Designed and developed a custom Infoview interface using WebI SDK in JSP version for WebI 2.7 and 6.5.2
• Managed Business Objects content deployments and Service pack upgrades.
• Implemented monitoring services on Business Objects system using HO Open View monitoring system.
• Maintaining the Ambeo infrastructure and monitoring the application databases through Ambeo
• 24X7 L2 Production support

Environment: Business Objects 5.1.6, 6.5.2, XI R2, Web Intelligence 2.7, 6.5, XI R2 Performance Manager, SDK, JSP, Oracle 9.2, VB.Net, Ambeo, HP-UNIX, AIX 5.3 and Windows NT/2003.

Confidential, Chicago, IL

Responsibilities:

• Installation and configuration of Informatica Server and Informatica Power Mart Client 5.7 tools.
• Installation and configuration of the Business Objects 6.1, BCA and Web Intelligence 2.6
• Created ETL mappings to load the data from Sybase Adaptive Server 11 and DB2 to Oracle 9.2
• Created Universe with 72 Classes, more than 2100 objects using inner/outer and equiv. joins as per requirement.
• Created the reports from Universes using Business Objects functionality’s like Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Linking the Universe between Sybase Adaptive Server 11 data base and Oracle 9.2 data base
• Migrating the Repository from Sybase Adaptive Server 11 to Oracle 9.2
• Scheduling the Documents and distributing the Documents through Broadcast Agent Server.
• Developed VBA Macro’s to export the report data into excel.
• Developed custom SDK code to access the Business Objects reports through front end application framework.

Environment: Business Objects 6.1, Web Intelligence 6, SDK, Application Foundation, ASP, Power Designer, Oracle 9.2,Sybase Adaptive Server 11, DB2, Informatica Power Mart 5.7, Reflection, Unix and Windows NT

Confidential, Manhattan, NY

Responsibilities:

• Designed campaign management data mart with the help of Erwin data modular
• Analyzed Confidential products and competitor products utilization data (Rx, Dollar Total and Unit Total) provided by IMS/NDC
• Installation and configuring the Business Objects 5.7, BCA and Web Intelligence 2.7
• Involved in Designing a Single Security Domain and Multiple Universe and Document Domain Environment for better maintenance and easy accessibility.
• Created Universes with 120 Classes, more than 3000 objects using aliases and contexts as per requirement.
• Retrieving and Publishing Documents from and to Corporate Repository. Scheduling the Documents and distributing the Documents through Broadcast Agent Server.
• Writing the VBA Macro’s to dynamically get the parameter values from the database and pass those values into prompts to create the report.
• Developed Custom Web Intelligence front end with SDK to show the documents on Web.
• Developed the dashboard application with the help of Application Foundation.

Environment: Business Objects 5.7, Web Intelligence 2.7, SDK, Application Foundation 6.x, ASP, Informatica 5.7, ERWIN, Oracle 8.1.6, Solaris and Windows 2000

Confidential, Oakland, CA

Responsibilities:

• Installing Business Objects 5.x and Web Intelligence 2.6
• Installation and configuration of Informatica Server and Informatica PowerMart Client 5.0
• Understanding the structure of Dataware House with the help of ERWIN data modular tool
• Created and maintained the Informatica Metadata repository
• Designed Data Mappings, implemented Transformations like Expression, Rank, Lookup, Sequence, Source Qualifier, Router, Aggregator etc to load data from Staging area to DW
• Involved in Designing a Single Security Domain and Multiple Universe and Document Domain Environment for better maintenance and easy accessibility.
• Developed multiple Universes for user Reporting and linked different Universes, which are from multidimensional data sources.
• Created the reports from various Universes using Business Objects functionality’s like Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Involved in writing custom scripting for batch processing

Environment: Informatica 5.0, ERWIN, Business Objects 5i, Web Intelligence 2.6, SDK, Application Foundation 3.0 ASP, Oracle 8i, Solaris and Windows 2000

Confidential, Houston, TX

Responsibilities:

• Installation and configuration of Business Objects 5.x, Application Foundation 3.0 and Web Intelligence 2.6
• Designed a Single Security Domain and Multiple Universe and Document Domain Environment for better maintenance and easy accessibility
• Developed dashboards using application foundation
• Developed multiple Universes to support user requirements.
• Created the reports from various Universes using Business Objects functionality’s like Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Managed Business Objects systems from Development through Production.

Environment: Business Objects 5i, Web Intelligence 2.6, SDK, Application Foundation 3.0, ASP, Oracle 9i, Solaris and Windows 2000, Informatica 5.0, ERWIN.

Confidential, Houston, TX

Responsibilities:

• Designing and developing Universes against HR Data Mart.
• Interaction with users in analyzing the requirements for report development
• Creating conditional objects and used Universe level security restrictions.
• Creating user-friendly objects using @ Functions at Universe Level.
• Created the reports from various Universes using Business Objects 5i functionality’s like @Prompts, Variables, and Formulas etc.
• Creating complex reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions, Intersections etc.,
• Scheduling and distribution of reports using Broadcast Agent.
• Provided support to users for resolving the issues.

Environment: Business Objects 5i, Web Intelligence 2.6, SDK, Application Foundation, ASP 3.0, Oracle 8i, Solaris and Windows 2000

Confidential, SFO, CA

Responsibilities:

• Installation of Business objects 4.0.1 and installation of Web Intelligence server version (2.0.1)
• Involved in Creating Repository, Creating Users and User Groups.
• Created Universe over 40 Classes and more than 900 objects using inner/outer joins based on user requirement.
• Created the Reports using the universes as the main data providers and also writing the complex queries including Sub Queries, Unions.
• Formatting the Reports to the Users requirements using all the requirements in Business objects .
• Used the Doc Agent server to Schedule and Monitoring the Reports.
• Involved in end user support and training.
• Extensively involved in writing PL/SQL stored procedures, database triggers. Also carried out performance tuning and optimization of critical queries using Explain Plans, Analyze etc.

Environment: Business Objects 5i, Web Intelligence 2.6, Oracle 8i, Solaris and Windows NT

Confidential

Responsibilities:

• Involved in Business Requirements identification, Preparing Functional specifications and URS.
• Designed screen layouts and created Database on ORACLE 7.3 Server, Created Libraries with critical functions and Procedures used for Interest calculation.
• Wrote Database triggers for transferring rollover amounts.
• The GUI was developed in Visual Basic 5.0
• Used RDOs, DLL’s, OLE, Class Modules, ActiveX
• Involved in testing, debugging, implementation, enhancements and user training.

Environment: Oracle 7.3, MS Access, Visual Basic 5.0, ASP, and Visual InterDev, SQL, PL /SQL (procedures, Functions, triggers, packages)