SUMMARY:

• Business Analyst, Data Analyst and Project Manager.
• Access/Excel VBA, VB and VB.NET Programmer.
• Access, SQL Server and Oracle Database Developer.
• Access, Excel, Crystal Reports and Business Objects Reports Developer.
• Expertise also includes Word documentation, PowerPoint training and SQL data migration.
• Specialize in Microsoft Office automation, dashboard reporting and application integration.
• Excellent analytical and problem - solving skills with the ability to simplify the complex.
• Profound knowledge of database structure and design, optimization and normalization.
• Sound knowledge of writing queries and statements using SQL.
• Wide knowledge of quality and metrics reporting, including validating and testing.
• Ability to present, organize, trend and convey management metrics.
• Capable of working independently, as a team player and/or as a project manager.
• Extremely organized, detail oriented and committed to deadlines.

TECHNICAL SKILLS:

Languages: 10+ years of VBA, VB and VB.NET with ASP.NET and HTML

Databases: 10+ years of Access with SQL Server and Oracle

Reporting: 10+ years of Excel and Crystal Reports with Business Objects

Documentation: 10+ years of Word

Presentation: 10+ years of PowerPoint

Platforms: 10+ years of Windows and NT with UNIX and Solaris

Hardware: 10+ years of IBM PC/AT with Sun UltraSparc

PROFESSIONAL EXPERIENCE:

Confidential, San Leandro, CA

Business and Data Analyst/Project Manager/Applications, Database and Reports Developer

Environment: Access, Excel, PowerPoint, Word, VBA, VB, VB.NET, Crystal Reports, Business Objects, SQL Server, Oracle

Responsibilities:

• Managed, analyzed, designed, developed, tested, validated, automated and documented database applications and dashboard reports for a variety of Confidential clients.
• In-depth data and/or system analysis, extensive user interviews and meetings, painted a detailed picture and complete understanding of the business.
• Managed the maintenance and administration of data, providing a rigorous assessment of the accuracy, validity and reliability of the frequently gathered information.
• Refined and improved data gathering and reporting mechanisms while ensuring accuracy of all information presented.
• Duties also included supervising multiple consultants on multiple projects and the administration of contracts, time cards and client invoicing.
• Financial, insurance, health care, manufacturing, wholesale, retail, transportation, distribution, utilities, government and technical industry experience.

Confidential, San Jose, CA

VB.NET Programmer/Business Analyst

Responsibilities:

• Simplified and updated existing VB.NET Framework 2.0 to Framework 4.0 (Windows Service).
• Reduced code base 80% while adding logging functionality to SQL Server database.
• Schedules reporting jobs and assigns available server as defined in the job frequency.

Confidential, San Jose, CA

VB.NET Programmer/Business Analyst

Responsibilities:

• Simplified and updated existing VB6 application to VB.NET Framework 4.0 (Windows Service).
• Added logging functionality to SQL Server database.
• Email notifications are sent when a server has reached the disk space available ‘Warning’ threshold or the ‘Critical’ threshold.

Confidential, San Jose, CA

VB.NET Programmer/Business Analyst

Responsibilities:

• Simplified and updated existing VB.NET Framework 2.0 to Framework 4.0 (Windows Application).
• Reduced code base 80% while adding logging functionality to SQL Server database.
• Enables job to be run on the installed server.
• Once the job has been scheduled and server assigned, the assigned client executes the job.

Confidential, San Jose, CA

VB.NET Programmer/Business Analyst

Responsibilities:

• Designed, developed, tested and supported the Type Library (TLB).
• The dynamically linked library allows legacy Access applications to utilize the functionality of the Service Bureau Reporting Engine.
• Posting to SharePoint or an Enterprise Document Manager, zipping and unzipping files, etc.

Confidential, San Jose, CA

Programmer/Business Analyst

Responsibilities:

• Designed, developed and maintained Access 2013 application.
• Tables contained the necessary files and servers to be updated.
• Queries filtered the data to be displayed based on update.
• Macros and forms executed the VBA update procedures.
• Updates included the Service Bureau Reporting Engine, Service Bureau Reporting Engine Component, Service Bureau Reporting Client and Service Bureau Reporting Notification.

Confidential, San Jose, CA

Excel VBA Programmer/Business Analyst

Responsibilities:

• Designed, developed, tested, monitored and supported Excel 2010/2013.
• As Confidential purchased companies, the Workforce Data Tool aided with the transfer of employees to Confidential .
• The tool imported five different spreadsheets, identified differences within the data, updated a SQL Server database and generated an Excel report.

Confidential, San Jose, CA

VB.NET Programmer/Business Analyst

Responsibilities:

• Converted existing Access database application to VB.NET and combined existing VB.NET library to VB.NET (Windows Application).
• Added support for Business Objects Webi XI 3.1/4.0 automated reports.
• Confidential uses the Business Objects libraries to open, set or ignore prompts, refresh and save reports.
• Confidential completely eliminates the need to manually generate reports potentially saving hundreds of man hours and thousands of dollars.

Confidential, San Jose, CA

Access/Excel VBA Programmer/Business Analyst

Responsibilities:

• Enhanced, tested, monitored and supported Excel 2007/2010 dashboards.
• Reports are delivered by importing Business Objects text file extracts and summarizing the millions of records in SQL Server.
• The resulting Excel spreadsheet automatically posted to SharePoint and emailed to the users.

Confidential, New Haven, CT

Access VBA Programmer/Business Analyst

Responsibilities:

• Analyzed, designed and developed Access application.
• Nightly procedures import new and changed data from Confidential Technologies Munis, an ERP Financial Solution and Pearson School Systems PowerSchool.

Confidential, New Haven, CT

Access VBA Programmer/Business Analyst

Responsibilities:

• Created naming convention and renamed long list of queries and automated macros.
• Analyzed and developed update procedure for new and changed student information.

Confidential, San Jose, CA

Access/Excel VBA Programmer/SQL Server Database Developer and DBA

Responsibilities:

• Access application/SQL Server database with Excel imports and exports.
• Confidential ’s primary function is to provide a user-friendly interface for Account Managers to prepare customer quotes.
• Confidential gauges deals based on the customer and deal size, giving an outlook to whether the deal will be approved by finance.
• Confidential is 100% portable and requires a network connection for the synchronization of data only.

Confidential, San Leandro, CA

Project Manager/VB.NET Programmer

Responsibilities:

• Managed project, developed SQL Server database application to monitor, automate, publish and post Business Objects and Excel reports.
• Confidential uses the Business Objects libraries to open, set or ignore prompts, refresh and save reports.
• Confidential completely eliminates the need to manually generate reports potentially saving hundreds of man hours and thousands of dollars.

Confidential, Sunnyvale, CA

Project Manager

Responsibilities:

• Managed project and team, designed and developed enterprise monitoring and asset management system.
• Confidential contains highly advanced, IT system tracking and change management programs, manages costs and standardizes computer operations for Windows/Unix Servers, Microsoft/Oracle Databases and Oracle/SAP Applications.

Confidential, San Leandro, CA

Project Manager

Responsibilities:

• Managed project and team, designed and developed database (Access, SQL Server or Oracle) application template.
• JumpStartVB.NET greatly reduces development time and client cost by containing up to 80% of the needed code for a secure, easy to use, easy to develop and maintain application.
• This approach allows developers to focus on crafting the remaining 20% of the application that is truly unique.

Confidential, San José, CA

Visual Basic Programmer/Crystal Reports Developer/Oracle Developer

Responsibilities:

• Forth revision of VB 6.0/ Oracle 9i application
• SoftwarePLUS combines a product software configuration and management system with a customer software registration system within Confidential Electronics
• Broadcast and Professional Group.

Confidential, San Jose, CA

Access/Excel VBA Programmer/Data Analyst

Responsibilities:

• Minimal meetings and extensive data analysis, was able to understand each the business group’s reporting wants and needs.
• Designed, developed, validated, automated and tested interactive and static Excel 2003 dashboards
• Expense Tracking, Route to Market, Product/Service Booking, Forecast Accuracy, Renewal Rate and Quality of Bookings. 7,000 reports delivered on a quarterly basis primarily by importing Business Objects text file extracts and summarizing the millions of records in Access and/or SQL Server. resulting Excel spreadsheet automatically emailed to the users.

Confidential, San Jose, CA

Project Manager/Access/Excel VBA Programmer/Business Analyst

Responsibilities:

• Managed project, designed, developed and administered an Access 2003 application.
• Confidential primary function is to provide access to daily data and create ad-hoc pivot chart reports.
• One million plus records automatically imported daily from Business Objects text file extracts into multiple Access databases.
• All pivot chart reports can be exported on demand to Excel and/or PowerPoint.

Confidential, San Jose, CA

Project Manager

Responsibilities:

• Analyzing existing reports and weekly meetings, was able to understand each the of the different business group’s reporting needs.
• Managed project, designed, developed, validated and tested interactive Excel 2003 dashboards - Confidential, Customer Profile, Deal Management, Entitlement, Install Base, Orders and Bookings, Pricing and Discounting, RMA, Service Agreements.
• Enhanced and combined the 9 separate Excel 2003 spreadsheets into a single Executive Reporting Dashboard with multiple graphs, navigation buttons, and drill-down detail capabilities. Access engine (VBA modules) contains all the reporting logic, so the resulting spreadsheet is an extremely thin client with little or no complex formulas and pivot tables.
• All complex formulas, unnecessary pivot tables and excess data were removed, making an extremely robust reporting package.