SUMMARY:

To work in a collaborative environment that will allow me to add value by increasing effective/intelligent usage of data. Being a proven team player with 5+ years of SQL/SSRS Reporting and 10+ years of data analyst/reporting experience in business, I hope to further develop my career as a highly skilled technical resource specializing in SQL/BI Development.

SKILLS:

• SQL Server 2005/2008; SSMS; SSRS; VS BIDS; TFS
• SQL (query, stored procs, funct, ETL); MySQL; VB
• MS Excel, advanced (VBA for macros)
• MS Access, advanced (queries & macros)
• MS Office, advanced
• Project Management, Software Implementation
• Data Analysis, Advanced Technical Troubleshooting Skills
• Report/Task Automation (SQL Server, Excel, Access)
• Hyperion Essbase; Seagate Analysis
• MDX, C++; HTML; some JavaScript, PHP, Perl, Python

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

SQL Developer

Responsibilities:

• SQL Development - Query writing for Financial Reports, optimized some Stored Procs and Scripts for Relativity Reporting
• SSRS Development - Financial Reporting and some eDiscovery/Relativity reporting
• SSIS Data Imports - import monthly Accounting General Ledger Journal Entries and Credit Card Transactions into SQL db
• SQL Database Administration and Data Management - Financial database and data
• Automated Performance-Based Compensation (PBC) process and calculations (2014 - 2016) - Excel Macros (VBA)

Confidential, Los Angeles, CA

Data Analyst / Programmer

Responsibilities:

• Create new reports and update/enhance existing reports using SSRS 2005/2008 for Managed Care business managers
• Modify/enhance existing stored procedures and functions (ETL) for updated reporting requirements to various external Funding Sources (including HIV test reporting to Dept. of Public Health, Federal Medicaid reporting, etc.)
• Assist in managing existing Membership data and incorporating new data from new clinics (via SSIS)
• Ad-hoc data analysis and data systems analysis (SQL queries/Excel data analysis)

Confidential, Woodland Hills, CA

Maintenance Programmer

Responsibilities:

• Used development tools (SQL Server 2008R2, SQL Server Reporting Services, Visual Studio 2008/BIDS) to maintain and develop Confidential Group reports
• Responsible for maintenance and support of Intuit QuickBase (Project Manager Plus), SalesForce.com, Confidential Group custom software applications, reports and some 3rd party applications
• Provided first line response to internal employees and some external clients/vendors having questions or problems with said software systems
• Documented and analyzed existing systems and processes
• Assisted in the development, testing and implementation of software solutions that improve existing systems and business processes

Confidential, Huntington Beach, CA

Software Consultant

Responsibilities:

• Managed and conducted budget software ( Confidential implementation/training for new customers (regularly worked with upper mgmt. like CFO, VP Finance, City/Gov’t Budget Mgr, Controller; on-site and remote); included building budget models on SQL server, mapping current business rules and improving/streamlining processes and calculations, data import/export to/from Accounting GL systems, replication of existing and creation of new financial/budget/variance reports, detailed employee budgeting (all calculations including salaries, benefits, payroll taxes)
• Provided technical software support for existing customers (Non-Profit, Governmental, and For-Profit organizations)
• QA testing of new software releases, testing and issue-tracking of software bugs; Product documentation
• Suggested improvements/enhancements to existing software functionality from a business/end-user perspective

Confidential, Los Angeles, CA

Sr. Analyst

Responsibilities:

• Validated database data; analyzed and interpreted data (web analytics); enhanced and streamlined reporting methodologies
• Maintained consistency and timeliness of bi-weekly publisher payments using manual data validation methods in Excel to ensure accurate payment amounts (due to payment reporting software containing bugs)
• Actively monitored ticketing queue for requests; produced reports in a timely manner based on ticket requests; resolved tickets to satisfactory feedback from those supported, including the Account Manager Team members and Management
• Assisted sales team in achieving $29M+ in revenue (supported in analytical/technical capacity)
• Maintained daily, weekly, and other reporting data in an accurate and timely fashion

Confidential, Hawthorne, CA

Business Analyst

Responsibilities:

• Coordinated with management to gather, analyze, summarize and prepare recommendations regarding financial plans
• Projected future requirements and operating forecasts
• Evaluated, researched, studied and reported on rates of return, working capital requirement, investment opportunities, investment performance, lease versus buy opportunities, and impact of government regulations and requirements
• Prepared analysis and made recommendations for changes in reporting and control systems
• Created presentations for management regarding studies of costs and attainability of profit objective through alt. bus. strategies
• Formulated, designed documents, and implemented new processes, systems, methods and procedures to promote efficiency, improve the basis for decision making and prevent operational problems
• Provided technical, financial and business analysis support during budgeting

Confidential, Los Angeles, CA

Contract Analyst

Responsibilities:

• Prepared monthly financial/variance analysis, reports/billings, forecasts, statements and supporting schedules, including program matching schedules as required for assigned Agency funding source contracts/grants
• Monitored and routinely made comparison to contract/grant budgets for payroll labor distributions, cost allocations, revenue and expense accruals, and reviewed purchase orders/monitored checks issued
• Prepared, documented, and entered into General Ledger (GL) necessary correcting journal entries and revenue accruals; also imported budgets into GL (BlackBaud Financial Edge accounting software)
• Created budgeting tools (Excel worksheets and Macros using VBA), managed Agency budget files in detail, and planned, collaborated and coordinated with program management to develop or revise Program/Department budgets throughout the year
• Developed and improved upon methods and procedures for financial tracking and contract analysis
• Gained technical/working understanding of contracts, fiscal compliance provisions and related correspondence
• Engaged in proactive consultation and collaborative problem resolution with program management staff and funding source fiscal representatives, including assuring budget development, modifications, coordinating audits and related corrective action
• Identified and resolved any billing/collection problems, including performing past due receivables analyses
• Prepared written reports and correspondence to both external funding sources and for internal purposes
• Developed and maintained contract training materials/workbooks and conducted periodic contract management training