Objective

To obtain a position as Business Intelligence/Data Warehouse Designer that utilizes my experience and knowledge to develop useful and powerful solutions

Summary

I am Business Intelligence professional with expertise in all phases of the software development life cycle. Skills include data analysis, dimensional data modeling, design and development. I have experience developing I have experience with a wide range of business intelligence tools for financial, retail and federal business systems solutions.

Experience

Confidential

Accomplishments

• Provide support to the ConfidentialTrustee Program USTP program within the Department of Justice DOJ to facilitate reporting across 12 stovepipe applications. Support a Business Intelligence BI environment with 2000 reports and 14 universes to enable users to report easily and efficiently, by creating users, resolving user issues and helping to educate users on the features of Business Objects.
• As task lead, I planned and oversaw the completion of assigned projects. I supervised a group of people, checked in with them to gauge progress and reported the project status to higher level managers.
• Experience using Business Objects XIR3 and BI4.1
• Developed dimensional data models to support the reporting for several Bankruptcy reporting applications.
• Created data model and universe requirements to allow reporting across multiple applications within Enterprise Data Warehouse EDW .
• Designed and implemented a Data Mart to enable the reporting of Trustee Final Reports and Internal Case Data.
• Experience installing, configuring and administering Data Services 4.2
• Experience developing ETL scripts in Data Services 3.2 and Data Services 4.2 to load data into a dimensional model
• Experience with the implementation of BOXI R3 and BI 4.1 in a multi-server environment
• Experience developing and modifying Business Objects universes to support reporting requirements
• Developed and unit tested application reports.
• Created adhoc reports in Webi Intelligence to support the administration of Cases managed by the program

Confidential

Accomplishments

• Performed Operations and Maintenance support for Business Objects XI installation in a Linux environment.
• Report universe Development, deployments ETL scripts, universes and reports.
• Automated several manual tasks by creating scripts to cleanse data, and maintenance procedures such as Restarting processes.
• Provided formal and informal training to end users.

Confidential

• Provided support the United States Trustee Program USTP program within the Department of Justice DOJ to facilitate reporting across 12 stovepipe applications. Support a Business Intelligence BI environment with 2000 reports and 14 universes to enable users to report easily and efficiently, by creating users, resolving user issues and helping to educate users on the features of Business Objects.
• Developed Data models to support the reporting for several Bankruptcy reporting applications.
• Experience developing ETL scripts in Data Services 3.2
• Experience installing, configuring and administering Data Services 3.2
• Experience with the implementation of BOXI R2/R3 in a multi-server environment
• Experience with BO 6.5, XIR2, and XIR3 SP1
• Experience in setting up a clustered BOXI R2 environment and migrating that to R3
• Supported several multi-day Business Objects training sessions.
• Experience developing and modifying Business Objects universes to support reporting requirements
• Created reports to track and audit debtors' activities.

Confidential

Accomplishments

• Led the design and implementation of multiple load test scripts at several clients. Analyzed the test results, and suggested configuration changes to remedy performance bottlenecks in a MicroStrategy 8.0 environment.
• Developed the data model, table views, and schema objects needed to support a MicroStrategy 8.0 project that allowed for reporting on program rewards data.
• Developed complex reports and report service documents while supporting multiple projects.

Confidential

Accomplishments

• Documented, setup and tested the sub-ledger needed to accommodate a major merger and acquisition M A integration this included documenting the approval hierarchy, creating purchase orders, and transferring journal entries to the General Ledger GL . Organized and monitored user acceptance testing UAT . Created a data conversion and load process used to move check data from external source into the AP sub-ledger.
• Supported the General Ledger reporting application built within Hyperion Essbase. Developed a daily reconciliation plan to provide quick and thorough resolution to various data errors and user issues. Additionally, Designed and implemented changes to the General Ledger reporting cube to allow for an additional dimension. Found the approach that impacted load and calculation time the least.
• Created a planning application for the financial planning team that required outline modifications, data load rules, and MAXL scripts to be created. Additionally, the creation of custom calculation scripts to calculate fringe benefits was also necessary.
• Reconciled reporting data to the transactional systems on a monthly, as well as ad hoc basis. Used SQL, Access, and Excel to research, analyze, and report data to the revenue assurance team. Developed process to audit cash receipts.
• Created procedures for monthly reporting of all partner activity. Utilized both MicroStrategy desktop and SQL to analyze historical partner billing and domain inventory.
• Developed Ad-Hoc reports using both SQL and MicroStrategy based on requirements from finance staff.

Confidential

Accomplishments

• Key responsibilities included writing table specifications and editing statements, reviewing questionnaires and tabulation plans, and manipulation of collected data utilizing Quantum scripting and Microsoft Excel.
• As an instrumental member of the Quality Assurance team, ensured timely and accurate reporting of data to clients.