SUMMARY

• Business Intelligence Architect / Administrator in Data Warehousing, Business Intelligence, Application Development using Client / Server Technologies
• Over 14 years of experience in Data Warehousing (DW), Business Objects and Oracle Business Intelligence (OBIEE)
• Expert in the SAP Business Objects architecture, BI suite of tools, design, development of Adhoc reports
• Expert in multiple SDLC cycle from business development, feasibility study, proposal development, system architecture and development through implementation
• Lead in the complete lifecycle of project from Requirements gathering from Business, Business analysis, design to development and implementation.
• Expert in SQL, Database Design, Performance tuning, ER diagram, Data modeling, XI R2/R3.1/R4.1 system security.
• Expert in XI R2/3.1/4.1 security administration, adding new users/groups/Folders/Universes On - call server support, Service desk ticket management and user support
• Led Conversion Business Objects Universes/Reports from Oracle to Netezza platform in the Enterprise Data Warehouse
• Dashboard Development in Xcelsius and Tableau with finance data.
• Expert in implementing best practices and procedures for formal design / code walk through, QA testing, production implementations, Data dictionary maintenance, system performance metrics and Business Objects user training
• MS (IT) / MBA (Finance) education
• US citizen with public trust and MBI clearance (eligible for security clearance)

TECHNICAL SKILLS

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

Programming Languages: SQL, SQL PLUS, COBOL, VS COBOL II, C++, CICS, Natural, Ideal, Assembler, JCL, HTML, XML

Software: 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)

Server Administration tools: RADMIN,DB2 Insight, BMC Utilities, DB2 Utilities, Change ManagerQuery Tools: Toad, Toad for Data Analysts 2.7, Aginity Workbench, SAS

Support Tools: Quality Center 9, Service desk, Software Change manager(12.0)

Other BI/ETL Tools: MicroStrategy, Cognos (8.4), Essbase OLAP, Crystal Reports, Informatica Power Center

Project Managemnt: MS Project, MS Office (Excel, Access), MS Visio

Operating Sytems: Windows XP, UNIX (Solaris, HP), Linux

PROFESSIONAL EXPERIENCE

Confidential, MD

Senior IT Specialist

Responsibilities:

• 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.
• Enterprise upgrade of XIR3.1 Business Objects Universes, folders/Users and reports to R4.1.
• Guide team members in complex Universe solutions and report development in 3.1 and 4.1, Manual SQL reports
• Detailed requirements analysis of financial data in the Finance data Warehouse by comparing two databases (Oracle and DB2), Data Mapping, Data mart development.
• Worked on end-user requirements, Informatica workflows, Business analysis, systems study, Implementation.
• Implemented Review and redesign of the universes to suit user segments and improve query performance.
• Trained Power users on XIR2/R3.1 DeskI / WebI features, database modeling and development of complex universes using best practices.
• 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/R4.1 suite of tools.

Confidential, VA

Systems 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.
• 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.
• Designed and implemented Business Objects Universes in BO 4.1/4.0/3.1.
• Developed training material for End users.
• Developed Multi-Source Universes in IDT and reports in BI Launchpad
• 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.

Confidential, VA

Senior Analyst (Sr. Developer /Administrator)

Responsibilities:

• Creating new Universe and reports for Users on the new database.
• Responsible for any modification to the application that causes an outage using the change control process.
• Worked with ETL tools like Informatica and Data Integrator.
• Created complex Auditor reports and dashboards for upper management and provided technical and training support to 400+ corporate systems users.
• 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.
• Security Viewer / Query Builder configuration and administered users through the application
• 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

Confidential, NJ

Business Objects Developer

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

Confidential, TX

Business Objects Developer

Responsibilities:

• Led the detailed requirements analysis and implementation from Super users to build the CRMS universe using Star Schema data model, which was build 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

Confidential, VA

Programmer/Analyst

Responsibilities:

• Created Oracle SQL scripts, PL/SQL procedures, Views and packages for the data loading into multiple oracle tables, updating existing ER diagram, database schema and table definition as per client requirements in database.