SUMMARY:

• Experienced business intelligence reports developer / analyst. Has worked across a wide range of more than two dozen industries and business areas.
• Known for being a self - starter, operating alone, and collaborating in small to medium project teams.
• Has a knack for getting along with a wide range of personalities and backgrounds.
• Possesses a natural curiosity about data, and a tenacious desire to find answers.
• Strong desire to learn new technologies. Currently learning HTML and Javascript as a hobby.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, VBA, Visual Basic, HTML, CSS, Portuguese

Databases: SQL-Server, Oracle, Microsoft Access

Applications: SSRS Reporting Services, Crystal Reports, Web Intelligence, SAP Info View, Tableau, Access, Excel, Pivot Tables, Visual Source Safe (VSS), SharePoint

Industry Areas: Entertainment, Real Estate, Leasing, Telecom, Non-Profit, Municipal, Federal

Business Areas: Helpdesk, Royalties, Permitting, Finance, Accounting, HR, Budgeting, Forecasting, Ultimates, Actuals, Aging, Residuals, Participations, Performance, Sales, Marketing, Membership, Citations, Land Use, Payroll, Compensation, Benefits, Sales Commissions, Workflow, Time Tracking

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Full Background Investigation clearance level Secret.
• Focus on performance metrics and trend reporting.
• Capture requirements, design, create, manage and fulfill request for reports.
• Develop reports using SSRS, Crystal Reports, BOE Web Intelligence, Tableau, Excel.
• All reports data sourcing from Sharepoint, SQL Server, or BOE Universe.
• Analyze, interpret, and summarize data to the needs of the customer.
• Work closely with clients in presenting findings to both internal and external customers.

Confidential

Reports Developer / Data Analyst

Responsibilities:

• Converted dozens of legacy Crystal and Web Intelligence reports into SSRS reports. Optimized each report's source Oracle and SQL-Server SQL as needed.
• Gathered user requirements for several new and existing SSRS reports I developed. Troubleshot all forms of reporting issues as they arose.
• Wrote reporting specification documentation, or interpreted existing reporting documentation, for each new SSRS report I developed.
• Performed QA, formatting, and user experience testing on all reports I wrote.
• Many of the reports were in a vacuum. I spoke to users to gather requirements, perform needs analysis, write the report, test, and implement.
• Wrote a small data mart to transform legacy addressing information and load it into the new system.
• Provided a report analyzing an outside vendor’s data conversion process. Made suggestions to improve data conversion accuracy and reliability.
• The new SCI software called Accela came with minimal database documentation. I was able investigate and learn
• A data conversion of 9 legacy systems into one new vendor-supplied solution is being performed. As an outsider to the conversion project, I was asked to analyze the vendor's conversion process. I communicated my findings to management on strategies that would streamline the conversion process and to assure the legacy data was converted correctly.

Confidential

Reports Developer/Analyst

• Rewrote Crystal Reports and Web Intelligence reports to improve performance.
• Wrote new ad-hoc Web Intelligence reports as requested by users. The reports covered the business areas of finance and accounting.
• Analyzed the company’s Business Objects reporting environment and presented my findings to management on ways to improve system maintainability.

Confidential

Senior Developer / Analyst

• Was integral in two major upgrades to the Media Maestro Royalties software and database. Each involved months of regression testing, QA, report re-writes, database and application upgrades, and managing both the end-user QA process, and vendor delivery of patch fixes.
• Fox had a custom built client/server application reporting tool written in VB. I programmed in VB using the Visual Studio to maintain and improve the application as needed.
• The reporting tool delivered Crystal Reports formatted
• Each upgrade involved preparing an overall plan that would guarantee a full suite of testing while simultaneously allowing for Royalties accountants to continue their monthly period processing. Each upgrade also involved writing database scripts to ensure data integrity was not compromised.
• Much of my day to day work involved using SQL to perform root cause analysis of corrupt data. When the cause was a software bug, I communicated the issue with the vendor. I applied most of the application and database fixes that were supplied by the vendor.
• Provided production support on all aspects of royalties reporting and the Royalties application.
• Reported to the executive directors of IT and Royalties. I was the main interface between the offshore software vendor and our internal user clients.
• Maintained about 50 Oracle stored procedure driven Crystal Reports Royalties reports. Reports were written against very large tables, some approaching 100 million records.
• Wrote about 10 new reports; gathering user requirements and performing needs analysis on each.
• Wrote ad-hoc reports as needed.
• All Oracle SQL stored procedures, VB source code, and Crystal Reports objects, were secured and controlled in an instance of Visual Source Safe (VSS) that I maintained.
• Maintained and improved our in-house Visual Basic Royalties reporting application.
• Used Excel, VBA and MS Access for minor ETL, data analysis, and ad-hoc reporting.
• Maintained and improved three in-house Access databases that performed Royalties-specific functions.

Confidential

• Provided production support on our in-house Budgeting and Forecasting MS Access application. I maintained and improved this application.
• Wrote, maintained, and improved dozens of Excel/Pivot Table budgeting and forecasting reports.
• Each report’s output format was Excel pivot tables and were written by combining SQL queries, Access VBA, and Excel VBA.
• Gathered requirements from users and senior management on all new report requests.
• Performed QA on all new and existing reports.

Confidential

Contract Excel Programmer

• Wrote Excel VBA data conversion tools to extract, transform, validate, and load legacy Excel spreadsheets into SAP.
• Data converted covered the business area of Participations.

Confidential

Contract Access Programmer

• Confidential HR underwent a conversion from their legacy systems to SAP.
• Wrote Access/Excel/VBA data conversion tools to extract, transform, and validate legacy data in preparation for being loaded into Peoplesoft. Conversion accuracy of 100% was achieved.
• Legacy data came from Peoplesoft, text files, and Excel spreadsheets.
• Analyzed and understood the various HR business logic necessary to perform reconciliation in the areas of Payroll, Compensation, and Benefits.

Confidential

Contract Data Integrator

• Wrote Access database that integrated data from two sources.
• Wrote an Access report analyzing employee shipping expenses.