­­­ ­­­­­­

EXPERIENCE SUMMARY:

• Confidential has 15+ years of experience with various Data warehousing and Business Intelligence tools like SAP Business Intelligence/Business Objects, Oracle Business Intelligence and SAP Xcelsius Dashboards.
• A senior SAP Business Objects developer / Architect in Data Warehousing, Application Development, Customization, Decision Support System and Business Intelligence.
• Managed and executed ad - hoc reporting, dash boarding and business analytics.
• Expert in SQL, Database Design, Performance tuning, ER diagram, Data modeling, XI R2/R3.1/R4.1 system security.
• Over 13 years of experience in Data Warehousing (DW), Business Objects and Oracle Business Intelligence
• Expert in multiple SDLC cycle from business development, feasibility study, proposal development, system architecture and development through implementation
• Involved in the complete lifecycle of project from Requirements gathering, Business analysis, and design to development and implementation.
• Expert in the SAP Business Objects architecture, BI suite of tools, design, development of Adhoc reports
• Led Conversion Business Objects Universes/Reports from Oracle to Netezza platform in the Enterprise Data Warehouse
• Developed and maintained Dashboards in Xcelsius and Tableau with finance data.
• Training power users in database concepts and Business Objects features

COMPETENCIES:

• Software Development (15 yrs)
• Data Warehousing (5 yrs)
• Business Objects Development (5 yrs)
• Tableau Dashboard Development (5 yrs)
• Oracle Business Intelligence (3 yrs)
• Data Analysis (15 yrs)
• Business Intelligence (BI) Tools (15 yrs)
• SDLC (15 yrs)
• BI Administration (5 yrs)
• Oracle/Netezza/Greenplum (15 yr)

TECHNICAL SKILLS:

Data warehouse and Business Intelligence: Business Objects (5.x/6.x/XI R2/3.1):- InfoView, Web Intelligence, Designer, Supervisor, CMC, Performance / Dashboard Manager, Query builder, Webi SDK, Xcelsius 4.5/2008, Oracle Business Intelligence (10.1)

ETL: MicroStrategy, Cognos (8.4), Essbase OLAP, Crystal Reports, Informatica Power Center

Databases: Oracle 11g/10 g/9i, Greenplum, Netezza 5.0, UDB 7.2/EEE, DB2V5/V6, M/S SQL Server

Others: Unix, Solaris, Weblogic, MS Visio, Oracle, Erwin,Toad, Cognos, HTML, FLASH, DREAMWEAVER, MS VISIO, SQL, RADMIN,DB2 Insight, BMC Utilities, DB2 Utilities, Change Manager, Toad, Toad for Data Analysts 2.7, Aginity Workbench, SAS

WORK EXPERIENCE:

Confidential, New Carrollton, MD

Senior Technical Analyst

Responsibilities:

• Detailed analysis of financial data in the Finance Data Warehouse by comparing two databases (Oracle and Discoverer).
• Leading the Data Dictionary maintenance.
• Developed a 360 business dashboard with multiple panels and parameters in Tableau.
• Extensively worked on end-user requirements, Business analysis, systems study, Implementation.
• Implemented Review and redesign of the universes to suit user segments and improve query performance. Planning of Upgrade Universes and reports to BO 4.1.
• Worked with ETL team on Informatica workflows and logic, architects, engineers and DBAs.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Confidential, New Carrollton, MD

Senior Business Objects Environment (BOE) developer and Technical SME

Responsibilities:

• Developed training material for End users and trained power users.
• Developed Multi-Source Universes in IDT and reports in BI Launchpad.
• Complex Webi report development in 3.1 and 4.1, Manual SQL reports.
• Participated in conversion and migration of XIR3.1 Business Objects Universes, folders/Users and reports to R4.1.
• Built dashboards for measures with forecast, trend line and reference lines using finance data.
• Published Workbooks in Tableau by creating user filters so that only appropriate teams can view it.
• Implemented Review and redesign of the universes to suit user segments and improve query performance.

Environment: SAP BI 4.1 Enterprise Suite including Information Design Tool, BI Launch Pad (aka Web Intelligence), Web Intelligence Rich Client, SAP HANA, Lumira, Qlikview 11, Tableau 9.3, Postgres db, Talend ETL.

Confidential, Herndon, VA

Business Objects Environment (BOE) developer and administrator

Responsibilities:

• Formulating, defining system scope and objectives.
• Leading the Requirement analysis, design, development, testing, implementation and documentation of ExtendSim simulation model and creating dashboards from simulation output with SAP Dashboard Design.
• Developed dashboards using Xcelsius with finance data.
• Lead in the POC of different BI tools working with Extend model, Excel, XML, .Net, PHP and MySQL and enhancements of existing applications.
• Evaluation of different BI tools, Database migration tools, user administration tools for the project.

Environment: SAP BI 4.1 Enterprise Suite including Information Design Tool, BI Launch Pad (aka Web Intelligence), Central Management Console, DB2, Sharepoint. Oracle

Confidential, Reston, VA

Responsibilities:

• Conducted an initial requirements analysis and developed the strategy for enterprise wide upgrade of Business Intelligence platform.
• Led Requirements gathering, information architecture, data models, capacity planning/sizing, performance and system usage management, disaster recovery planning.
• Led testing of Disaster Recovery preparedness for BI servers.
• Led conversion and migration of XIR2 Business Objects Universes, folders/Users and reports to R3.1.
• Supported SAP Business Objects servers and responsible for On-call server support, Service desk ticket management, Data Analysis, improvement and user support.
• Worked with Windows server team troubleshooting service error logs, fixing parameters in CMC and servers, sending out outage notifications and coordinating with server team.
• Responsible for any modification to the application that causes an outage using the change control process.
• Integration of Windows Active Directory for authentication, requesting new AD groups, adding them to Bus Obj and set up their rights. Overview of the process with new universe creators and go over the process.
• Lead in the design and development of Business Objects universes and reports, analytics and dashboards for Corporate Financial Systems using BO XIR2/R3.1 suite of tools.
• Worked with ETL tools like Informatica and Data Integrator.
• Experience in the complete SDLC lifecycle of project from design to development and implementation including formal design/code walk through, QA testing, production implementations, system performance metrics and monitoring.
• Trained Power users on XIR2/R3.1 DeskI / WebI features, database modeling and development of complex universes using best practices.
• Development of RPDs in OBIEE (Oracle Business Intelligence), Config File set up, importing database tables, merging on MUD copy in OBIEE and testing of Subject areas

Environment: Business Objects XI R2, Business Objects XI R2 Web intelligence, Business Objects XI R2 Designer, BO Designer 6.5, Business Objects XI R2 Central Management Server, Business Objects XI R2 Web Component Adapter, PLSQL, SQL, Ascential Data Stage4.2, Web Intelligence XI R2, SQL Server 2000, Windows NT.

Confidential, New Jersey

Responsibilities:

• Designed and implemented Business Objects Universes, in development of Universe by creating the Business Objects data model, creating joins between the tables, Indicating cardinalities
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, which allowed the users to analyze the data.
• Installed BCA server components and configured repository connections, scheduler parameters, BO Manager's parameters and, BCA console. Migrated users, Universes and reports during Upgrade of BO 5.1.8 to BO 6.1a

Environment: Business Objects XI R2, Business Objects XI R2 Web intelligence, Business Objects XI R2 Designer, BO Designer 6.5, Business Objects XI R2 Central Management Server, Business Objects XI R2 Web Component Adapter, PLSQL, SQL, Ascential Data Stage4.2, Web Intelligence XI R2, SQL Server 2000, Windows NT.

Confidential, Texas

Responsibilities:

• Led the detailed requirements analysis and implementation from Super users to build the Confidential universe using Star Schema data model, which was built on the Oracle 9.X as the main Data Provider
• Created Reports using the Universe, Stored Procedures and Free Hand SQL as the Data providers

Environment: Business Objects 6.5, BO Designer 6.5, Supervisor 6.5, VBA, PL SQL, SQL, Ascential Data Stage4.2, Web Intelligence 2.7, Oracle9i, MS Access 2000, Windows NT.

Confidential, VA

Responsibilities:

• Interacting with Data modeler and ETL Teams to review the dataflow in order to optimize the query results and suggest changes to indexing strategies.
• Creating documentation of data reporting requirements, and, the presentation and walk-through of data models with business units.

Environment: Business Objects 6.5, BO Designer 6.5, Supervisor 6.5, VBA, PL SQL, SQL, Ascential DataStage 4.2, Web Intelligence 2.7, Oracle9i, MS Access 2000, Windows NT.