Sr.business Objects Developer/ Data Analyst Resume
New York, NY
SUMMARY
- An energetic, self - motivated Sr.Business Intelligence Specialist/Data Warehouse Architect wif over
- 14 years of experience in Architecture and Deployment of Decision Support Systems Enterprise wide.
- Strong skills in Development of BusinessObjects DeskI/WebI Reports, Universe design and Administration. Business requirement analysis, user support, specifications design, testing, performance tuning.
- Experienced in Data Analysis, Data Modeling, Data Warehouse Architecture. Fluency in Oracle scripts, stored procedures, functions and triggers using SQL and PL/SQL. Change management tools experience.
- Works well in the team as well as independently wif minimal supervision.
TECHNICAL SKILLS
Software: BusinessObjects XIR2,3,BI4.1, IDT, Crystal Reports, Tableau, SAP BW, ORACLE 9i,10g, SQL, PL/SQL, SQL*Loader, TOAD, Teradata, MS SQL, Microsoft SSRS, MicroStrategy, MSOffice. UNIX- kShell, Data Modeling, Data Warehouse, Data Mart, ERwin, Informatica, HP Quality Center.
Operating systems: WINDOWS XP/nt/2000, UNIX HPUX-10, Sun Solaris 8,10.
PROFESSIONAL EXPERIENCE
Confidential, New York, NY
Sr.Business Objects Developer/ Data Analyst
Responsibilities:
- Create BO/Tableau reports for the Drug Safety Information System.
- Provided support for Business Users for Data validation and reconciliation.
- Participated in the QA tests for the created reports.
- Participated in the BI4 Implementation project.
- Business Objects reports upgrade: v.XIR2 to v.XIR3 to v.BI4.1
- Migrate / Rebuild 12 Deski report into new temporary environment (BOXI R3).
Confidential, New York, NY
Lead Applications Developer
Responsibilities:
- Implementation and Upgrade of BO BI v.4.x from BO XI R2.
- Migrated to the new platform 12 BO Universes and 400 Corporate Reports.
- Rebuild HR Universe to improve performance and usage as a Ad-Hoc source.
- Setup security rules and restrictions for the User’s Groups and Folders.
- Provided daily support for 1800 Business Users.
- Provided BO server administration for Prod, QA, Test and Development environmentn Windows platform utilize Oracle and SQL server 2005 databases
- Participated in the Oracle R12 Data Models testing and provided data source mapping.
Confidential, Falls Church, VA
Sr. Business Objects Developer/ Administrator
Responsibilities:
- Enterprise Architecture evaluation and improvement.
- BO Universe recreation and Oracle 10g DB tuning - 3 unv vs. 7 unv.
- Re-Engineering BusinessObjects Deski reports to improve performance and reliability.
- Set up Deski canned reports for automation distribution to the Users and File-server archives.
- BOXI Administration, User’s accounts maintenance, Security setup.
- BOXI Servers Administration, software upgrade on the UNIX/Solaris 8/10 and Windows platform.
- Provided support for Business Users.
Confidential, Commodities, Stamford, CT
Business Objects Lead / Risk DW Architect
Responsibilities:
- Technical design and deployment of the Market Risk Data Warehouse and BusinessObjects Enterprise Reporting solution.
- Installation and support BO Prod, UAT, and Dev environment based on BO XIR2/XI3.0,Win 2003.
- Created BO Universe and WebI/ DeskI Ad-Hoc and EOD automation reports for the Market Risk
- Provided Performance Tuning for BO Reports.
- Provided BO CMC Administration and Support for Business Users.
- Participated in Logical/Physical Data Modeling for Risk Data Warehouse.
- Created and deployed Star schema database utilize ErWin, Oracle 10g.
- Participated in the OLAP Cubes development using MS 2003 Server Analysis Services.
- Participated in the development and enhancement ETL processes utilize Java, Informatica.
Confidential, New York, NY
Sr. BusinessObjrcts Developer
Responsibilities:
- BO Universes upgrade and deployment.
- Reports upgrade (from v.6.5 to XIR2), enhancement and performance tuning.
- Created and deployed file-server structure for report’s storage and intuitive access.
- Implemented SSO login to improve security and maintenance.
Confidential, New York, NY
Consultant - Sr. BusinessObjects Developer
Responsibilities:
- Business Objects upgrade: v.5.1.8 to v.6.5.
- Migrated to new platform 5 BO Universes and 36 Reports.
- Rebuild ORM BO Universe to improve performance and intuitive usage as a Ad-Hoc source.
- Created two Business Objects Universes and set of BO Reports for Operational Risk divisions.
- Development and testing Logical/Physical Data Models and provided data source mapping.
- Business Objects Report Re-Engineering.
- Design Business Objects Universe from new data source - Teradata database.
- Created 10 Business Objects Financial Reports (pilot program) from Teradata database
- Provided support for Business Users and IT staff for Operational Risk divisions.
Confidential, Washington, DC
Consultant - Sr. BusinessObjects Developer.
Responsibilities:
- Designed BO Universe and set of financial, tabular, matrix, master detail reports.
- Created new database schemas utilize ERwin and Oracle9i.
- Developed procedures, triggers, indexes using PL/SQL.
- Provided training to permanent IT staff and BO Users.