OBJECTIVE

Applications and reporting development position

PROFILE

• Detail-oriented, highly-organized, self-motivated with the application of practical day-to-day processes and the development of long-term projects for effective management that grows with the direction of the business.
• Team-player with an intense sense of loyalty and a desire to contribute to and be a part of the effectiveness and superiority of the product. Strong work ethic and commitment to excellence.

SKILLS

• Software Core
• SSMS SQL Server Management Studio Database management creating, backup, security of tables, views, stored procedures, functions as well as writing queries
• SSRS SQL Server Reporting Services basic report development
• ETL processes via Access VBA, Excel VBA, SQL script loading of external data into specific content for direct source tables and feeds into ancillary objects. Automated scheduling of processes at various frequencies.
• SQL for queries in VBA code MS Access and Excel environments and in Oracle environment via Access pass-through queries and externally includes MS Access, Oracle, and T-SQL syntax.
• MS Access - Design and maintenance of databases for personnel, accounting, inventory, billing, refund recovery, lien release and loan confirmations, bankruptcy claims, and loan servicing tax management using linked access tables and/or Oracle ODBC
• MS Excel advanced macro development and data analysis from SQL sources for business specific tools such as dashboards, dynamic criteria-driven reporting slice dice modeling , and high-level summary analysis reporting
• VBA coding for enhancement and increased functionality of MS Access databases and Excel tools as well as automation of PowerPoint presentations
• BI rendering dashboard development using PowerPivot Tableau
• Software Support
• Advanced use of MS Office 2003, 2010, 2013 Productivity Software Word, Excel, Outlook, PowerPoint
• MS Visio - Process and flow diagrams, extensive documentation
• MS SharePoint document posting, revision, and table development
• FTP hosting platforms including CuteFTP Professional, Hosted FTP
• Adobe Photoshop - Image design and editing
• Adobe Acrobat - PDF creation, setup and troubleshooting Standard, Distiller, and Reader conflict issues
• SQL Navigator Queries script for tables and associated objects indexes, triggers, and permissions
• Corporate property tax software for state and local property tax management
• Setup and hosting of web-based desktop sharing sessions for troubleshooting WebEx
• Technical Concepts
• Technical application troubleshooting
• Application design, development, testing, and deployment
• Project coordination and timeframe estimation
• Detailed technical and user documentation for developed applications
• Communication
• Formal and informal product proposal presentation and training
• Effective communication of critical data and sensitive issues in both written and verbal media
• Successful client relations and strong rapport with both internal and external contacts

PROFESSIONAL EXPERIENCE

Confidential

Category Management Analyst

Data warehouse design and implementation for the housing of category weekly and monthly data provided via ftp. Created dashboard style reporting for multiple categories with capacity to select criteria by account type, market level, OpCo, fiscal year/weeks, item attributes, and other user-defined needs. Developed ongoing complex reporting that to be run quickly and efficiently on demand. Handled ad-hoc reporting as well as contributed to the format and layout of external data provided based on data warehouse needs. Platform: Excel 2010 Front-end SQL Server Back-end

Confidential

Project Consultant

Design consulting and development of new application for global project management of hardware issues through a flexible and adaptive structural approach. Worked with virtual team to develop interface, reporting, and import functionality. Created dynamic solutions through the use of agile methodology and collaboration with a team. Platform: Access 2010 Front-end, SQL Server Back-end

Confidential

Development of new tool to manage inventory of personnel and skills for the planning of contracts via interface maintenance and reporting capabilities. Worked with team to further refine requirements of project and assist in researching deployment options. Programmed tool to maximize continuity of contracts to maximize company billing and productivity. Platform: Access 2007

Confidential

Development of existing tool for oil and gas scheduling of well drilling per rig as well as reporting for a group financial outlook to upper management. Generated technical documentation of tool including structure and explanation of code. Global functions for printing drilling schedules per region based on dynamically generated data. Implementation of user-based security with read and write access defined at a program level. Created additional tools for linking well performance and asset tracking data with the existing scheduling tool. Platform: Excel 2003, 2010 Front-end SQL Server Back-end

Confidential

Project Consultant

Designed, coded, and implemented a multi-user application to track and manage the compliance and servicing of turbines. Application designed for multiple turbine manufacturers bulletins, advisories, and technical information letters with browsers, filters, and import utility. User level documentation also written for the group. Platform: Access 2010

Confidential

Business Technologist II

• Authorship and support of prototype and reporting Access applications. Critical analyst functions for audits, compliance, and day-to-day business needs. Refining and streamlined automation of Tax Dept processes. Numerous workflow tools for use by in-house and outsourced personnel. Standardization of Insurance reporting processes. Confidential
• Design of new and enhancement of existing Access databases to improve the business processes of the tax department using Oracle back-ends. Development of scheduled and ad-hoc queries and reporting tools to assist in department reporting and data analysis. Flow diagramming and standardized process documentation of databases. Demonstration and deliberation of database functionality and implementation/deployment methodology. Troubleshooting of system breaks and reporting anomalies. Technical support of all systems and preliminary troubleshoot for hardware issues within the department. Platform: Access 2000 Front-end Oracle 10G Back-end

Confidential

Daily support of state and local property tax software for in-house and hosted clients. Coordinate implementation, installation, licensing, and new release distribution. Resolve data setup, corruption, and restore issues for assets, tax bills, and imports. Rendition forms support through explanation and correction of data mapping and regression testing. During this time, developed applications for compliance process, recovery services management and accounts receivable collections.

Confidential

Coordination of tax bill processing to insure payment by due dates, handling of inherited P I, and strategies for managing current and future workloads. Liaison for clients concerning tax bill deadlines, anomalies, and establishment of special procedures to meet client needs and exceed client expectations. Asset scrubbing and data setup for rendition processing. Final resolution for escalated tax bill issues from analysts. Assistance for current and training of newly assigned analysts and processors.

Confidential

Process tax bills requiring additional research into assessed value, tax rates, or special entity requirements. Research and acquisition of asset listings break-outs from assessors for the purpose of reconciling market/assessed value for accurate tax bill processing. Troubleshoot tax bill information setup in response to system-generated error messages. Assist BPO management with the collection and compilation of jurisdictional data.

Confidential

Development of multi-user, split Access database created by a third party. Improved response time, report formatting, screen layout, and query design with more user-friendly features on the front-end and reinforced structural integrity for the back-end. Developed integrated billing application and conducted user-level presentations and training sessions. Created and updated technical and user-level documentation. Platform: Access 2000

Confidential

Maintain academic and financial records. Establish, document, and enforce academic and billing policies. Create, process, and issue individualized curriculum orders. Responsible for student admissions, tuition collections, and promotions. Learning Center Supervisor with emphasis on high school level students.