PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Analyst II

Responsibilities:

• Specialized in Business Intelligence solutions by analyzing, coding, implementing and creating complex query reports using Toad through Oracle 10g/11g and Business Intelligence Development Studio through SQL Server 2000/2005/2008/2012 across all divisions of the organization.
• Automated multiple daily, weekly, monthly, quarterly, and annual manual processes through SQL Server Management Studio into SQL Server Reporting Services.
• In charge of deployments for reports created by other IT groups within the company.
• Created hundreds of new Tablix, Tabular, Matrix, Drill Through and Chart reports companywide through MS SQL Server Reporting Services 2012 (SSRS). Some reports were based off of existing MS Excel and MS Access reports and others reports were developed based off of business requirement gathering.
• Troubleshooting of reported problems pertaining to reports and the reporting database environment, including working closely with other IT members, especially DBAs and developers. To identify the cause, and design or develop an approach for resolution.
• Performed complex ad - hoc queries and data manipulation through Oracle PL/SQL and SQL Server T-SQL.
• Provided complex reports for USAC decision makers, the FCC, Congress, and other interested parties.
• Worked with Data Warehouse Engineer to identify reporting requirements, solve data issues, and complete mutual reporting goals.
• Created MDX coding for new cubes in place of SQL Server tables. Transcribed from SQL Server to MDX for existing SSRS reports and created new reports.
• Created SharePoint PerformancePoint dashboard to display TeamTrack ticket data to gain insight about report use.

Financial Analyst

Confidential

Responsibilities:

• Lead Disbursement tester in a UAT effort to migrate from Actuate Reporting to Microsoft Reporting Services.
• Created customized ad hoc reports especially for Schools and Libraries and Legal/FCC Enforcement based on specific criteria queried from DAS tables.
• Taught and mentored co-workers on complex MS Access relational database ideas to improve the design of tables, queries, reports and forms.
• Gathered requirements and automated several manual Disbursement and Legal Enforcement processes by creating Visual Basic for Applications (VBA) programs to cross multiple MS applications like Excel, Access and Outlook.
• Processed Schools and Libraries, Rural Health Care, High Cost Red Light releases, Low Income Red Light releases, Credit Balance Refund, Exception Payments, Stops and Reissues with one hundred percent accuracy in a timely manner.
• Participated in critical projects and initiatives like Financial Systems Overhaul and new FCC initiatives.
• Provided documentation and Disbursement support in response to inquires from Auditors and USAC Legal in support of investigations by FCC, law enforcement, and support mechanism enforcement activities.
• Prepared monthly reports such as Trend Analysis, Key Statistics, Top 20 support mechanism disbursement recipients, Kick Outs, Kick Ins, Negative Confidential, Error Log and other ad hoc management reports as required with one hundred percent accuracy.
• Used advanced MS Excel tools like VLOOKUPs and pivot tables on a daily basis for research and reporting.

Confidential

Business Analyst

Responsibilities:

• Generated weekly, semi-monthly and month-end invoices for over 100 carrier customers.
• Updated and analysed daily and monthly margin, revenue and other financial trend reports and distributed them internally via the company’s intranet.
• Performed daily revenue assurance checks through Crystal Reports and Microsoft (MS) Access databases.
• Resolved errors in reporting, billing and mediation systems.
• Maintained account data in Least Cost Routing (LCR) database, billing & accounting system.
• Resolved customer billing disputes using manual research through MS Excel and MS Access.
• Created and updated new Crystal and MS Excel reports according to internal requirements.
• Performed updates and queries in LCR database on new/existing customers, suppliers, destinations & rates.
• Created and updated MS Excel pivot tables and Crystal Reports to show company daily, weekly, monthly and quarterly financial information.

Confidential

Building Contractor

Responsibilities:

• Estimated cost of labor and building materials for a wide variety of home improvement and renovation projects.
• Wrote proposals and completed work on both modern and historic homes for clients in Virginia and Washington, DC.

Confidential

Billing Trouble Management Analyst

Responsibilities:

• Advanced SQL data queries and corrections within production tables for suspended billing traffic.
• Used SQL to generate reports and ensure validity of billing data from system tables.
• Troubleshooting, research and analysis of routine and specialized billing problems from AS/400 GUI on a Saville Convergent Billing Platform.
• Created specialized call summaries, call detail, validation and rating reports weekly and on ad hoc request for staff and executive management.
• Researched suspended billing traffic issues and coordinated corrective action between Table Implementation, Customer Services, and IT.

Confidential

UNIX Systems/Volume Tester

Responsibilities:

• Developed, maintained, and executed UNIX Shell scripts for testing purposes.
• SQL Plus for Oracle database table analysis through queries and updates.
• Volume testing of Confidential developed applications for standalone and overall system performance.
• Developed system test cases for Confidential Customer Billing to evaluate existing and newly developed code changes.
• Detailed system testing for potential Oracle database and application problems before production.

Confidential

Junior Systems Analyst

Responsibilities:

• Software System Administration: Provided operational support to The Federal Aviation Administration’s Enhanced Traffic Management System. Upgraded, monitored and tested software for over 350 workstations located at over ninety sites worldwide.
• System Administration: Help desk troubleshooting for software and hardware problems for local and remote sites.
• Database Administration: Maintained static databases that change on a 56-day cycle. Developed and maintained C and Shell script code to increase automation.
• Software Maintenance and Development: Maintained existing code and developed new code to support the operational field sites. Developed system utilities using Domain and UNIX Shell scripts.
• Developed and reviewed documentation for monthly Site Program Bulletins, System Administration Manuals, Tutorials, Reference Manuals, and in-house procedures.
• Hardware installation and procurement: Hardware installation and purchasing of workstations for Federal Aviation Administration Air Traffic Control Command Center.
• Created and maintained special event air traffic programs for Federal Aviation Administration’s Central Voice Reservation System.