Programmer/business Analyst Resume
San Francisco, CA
SUMMARY:
- Programmer/Analyst (Business and Data).
- Application, Database and Report Developer.
- Access/Excel VBA, VB and VB.NET Programmer.
- Access, SQL Server and Oracle Database Developer.
- Access, Excel and Crystal 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 wif the ability to simplify the complex.
- Insightful knowledge of data modeling, schemas, mapping and flowcharting.
- Extensive experience wif database structure and design, optimization and normalization.
- Comprehensive understanding of writing queries and statements using SQL.
- Ability to present, organize, and convey management metrics, including QA and validation.
- 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: VBA, VB and VB.NET wif ASP.NET and C#
Databases: Access and SQL Server wif Oracle
Reporting: Excel and Crystal Reports
Documentation: Word
Presentation: PowerPoint
Doc Management: SharePoint
Methodology: Waterfall
PROFESSIONAL EXPERIENCE:
Confidential, San Francisco, CA
Programmer/Business Analyst
Responsibilities:
- Unstructured Data (Access, Excel, SharePoint): Primarily supported data migration tool using RoboCopy to move folders and files to a secure and structured location. Collaborated wif various business units to analyze and determine the information needs and functional requirements. Responsible for relaying both technology and business information to the technology team in easily-understood terms. Conducted user acceptance testing as it related to the technology solutions. Generated reports, charts, tables, graphs, maps and other visual aids to TEMPeffectively communicate to the business. Coordinated wif business process owners to create a needs analysis and recommend best procedures for the future state.
- Service Bureau Reporting Engine (VB.NET, Access, VBA, SQL Server, SharePoint): Converted existing Access database application to VB.NET and combined existing VB.NET dynamically linked library to VB.NET (Windows Application). Reduced code base 75% while adding logging functionality to SQL Server database and support for Business Objects Webi XI 4.0 automated reports. SBRE uses the Business Objects RESTful Web Service to open, set or ignore prompts, refresh, save and post reports to SharePoint. SBRE completely eliminates the need to manually generate reports potentially saving hundreds of man hours and thousands of dollars.
- Service Bureau Reporting Engine Component (VB.NET): 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.
- Service Bureau Reporting Scheduler (VB.NET, SQL Server): Simplified and updated existing VB.NET Framework 2.0 to Framework 4.0 (Windows Service). Reduced code base 75% while adding logging functionality to SQL Server database. Schedules reporting jobs and assigns available server as defined in the job frequency.
- Service Bureau Reporting Notification (VB.NET, VB6, SQL Server): Simplified and updated existing Visual Basic 6.0 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.
- Service Bureau Reporting Client (VB.NET, SQL Server): 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.
- Service Bureau Reporting Update (Access, VBA): 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.
- Service Bureau Reporting Engine Deski (VB6, SQL Server, Business Objects): Simplified and enhanced existing Visual Basic 6.0 application. Reduced code base 75% while adding logging functionality to SQL Server database and support for Business Objects Deski XI 4.0 automated reports. SBRE.Deski uses the Business Objects libraries to open, set or ignore prompts, refresh and save reports.
- Workforce Data Tool (Excel, VBA, SQL Server): Designed, developed, tested, monitored and supported Excel 2010/2013. As Cisco purchased companies, the Workforce Data Tool aided wif the transfer of employees to Cisco. The tool imported five different spreadsheets, identified differences wifin the data, updated a SQL Server database and generated an Excel report.
- Quality of Booking (Access, Excel, VBA, Business Objects, SQL Server): 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
Programmer/Business Analyst, Database and Report Developer
Responsibilities:
- Staff Data Management System 2.0 (Access, Excel, VBA, Oracle, SQL Server): Analyzed, designed and developed Access application. Nightly procedures import new and changed data from Tyler Technologies Munis, an ERP Financial Solution and Pearson School Systems PowerSchool.
- Discount Guidance Tool (Access, Excel, VBA, SQL Server): Analyzed, designed and developed Access application, SQL Server database wif Excel imports and exports. DGT’s primary function is to provide a user-friendly interface for Account Managers to prepare customer quotes. DGT gauges deals based on the customer and deal size, giving an outlook to whether the deal will be approved by finance. DGT is 100% portable and requires a network connection for the synchronization of data only.
- Report Automation for Business Objects and Excel (VB.NET, VB6, SQL Server, Business Objects): Managed project, developed SQL Server database application to monitor, automate, publish and post Business Objects and Excel reports. RAMBOE uses the Business Objects libraries to open, set or ignore prompts, refresh and save reports. RAMBOE completely eliminates the need to manually generate reports potentially saving hundreds of man hours and thousands of dollars.
- Zysygy (VB.NET, Access, SQL Server): Managed project and team, designed and developed a VB.NET enterprise monitoring and asset management system using JumpStartVB.NET. Zysygy contains highly advanced IT system tracking and change management programs, manages costs and standardizes computer operations for Windows and Unix Servers, Microsoft and Oracle Databases, and Oracle and SAP Applications.
- JumpStartVB.NET (VB.NET, Access, SQL Server): 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. dis approach allows developers to focus on crafting the remaining 20% of the application dat is truly unique.
- SoftwarePLUS (VB6, Crystal Reports, Oracle): Fourth and final revision of Visual Basic 6.0, Oracle 9i application. SoftwarePLUS combines a product software configuration and management system wif a customer software registration system wifin Confidential . Broadcast and Professional Group.
Confidential, San Jose, CA
Programmer/Data Analyst, Database and Report Developer
Responsibilities:
- Service Bureau Reporting (Access, Excel, VBA, Business Objects, SQL Server, Oracle): 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 and Service Booking, Forecast Accuracy, Renewal Rate and Quality of Booking. 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. The resulting Excel spreadsheet automatically emailed to the users.
- Consumer Advocate Reporting Suite (Access, Excel, VBA, PowerPoint): Designed, developed and administered an Access 2003 application. CARS 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.
- Data Integrity Reporting (Access, Excel, VBA): Analyzing existing reports and weekly meetings, was able to understand each the of the different business group’s reporting needs. Designed, developed, validated and tested interactive Excel 2003 dashboards - B2B, 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 wif 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 wif 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.
- Tool Kit System (Access, VBA, DB2): Developed and administered an Access 2000 application. Tool Kit primary function is to provide an extremely user-friendly way to “QA” the Foundation Systems DB2 database. The Tool Kit compares the data in Access tables to DB2 tables and reports all missing records and/or non-matching fields. The Tool Kit will replace the existing system of Excel spreadsheets and cut the time invested from almost 40 hours to less TEMPthan 4 hours to accomplish the same task.
- Automated Reporting Management Interface (Crystal Reports, SQL Server): Designed and developed Crystal Reports 10, SQL Server 2000 reports. ARMI is a management tool used by the pricing and underwriting department used to generate reports and create a soft and hard copy of Customer Packets and related printed information. Reports are selected from the available report libraries, downloaded as RPT source files, extracting the data from the SQL Server 2000 warehouse and generating an Adobe PDF per Crystal Reports RPT file.r
- Laboratory Management System (VB6, Crystal Reports, Access, SQL Server): Third and final revision of Visual Basic 6.0, Access 2000 application. LMS is a management and reporting tool used by the Materials Testing Lab to manage a variety of requests for their services. These services include but are not limited to the designing and recommending of materials to be used in Public Works projects as well as the scheduling, sampling and testing of materials at various job locations. LMS has been successfully tested wif SQL Server 2000.
Confidential, San José, CA
Programmer/Business Analyst, Database and Report Developer
Responsibilities:
- SoftwarePLUS (VB6, Crystal Reports, Oracle): Second and third revision of Visual Basic 6.0, Oracle 8i application. SoftwarePLUS combines a product software configuration and management system wif a customer software registration system wifin Confidential . Broadcast and Professional Group.
- Pricing Database (Access, VBA): Enhanced and completed an Access 2000 application. The Pricing application is a pricing tool for equipment service agreements. Enhancements were based on a highly complex and data rich Excel spreadsheet. Data is automatically and regularly updated from IRIS extracts and Excel reports are exported and emailed to selected recipients.
- Services Test (VB.NET): Developed a VB.NET Windows application dat interactively tests all 14 published web service methods for all environments (Development, Staging and Production) using real time data.
- Mainframe Test (VB.NET, DB2): Developed a VB.NET Windows application dat directly tests connectivity wif the CICS mainframe DB2 database and wif the SIS application.
- SunRAMP Environment and Component Builds (Perl, JavaScript, HTML, Oracle): Enhanced existing web application for the SunRAMP project using Perl, JavaScript, and HTML. GNUplot was implemented for charting, utilizing Oracle 8i and SQLplus to create and update the database. Site’s main purpose was to provide an easy to use graphical representation of Sun’s server environment and component builds used in SunRAMP.
- Martial Arts Manager (Access, VBA): Converted, enhanced and administered an Access 2000 application. MAM manages Students’ contract agreements and payments, attendance, ability level and personal information, and showcases user-friendly Accounts Receivable and Accounts Payable forms and reports. MAM has the ability to create spreadsheet like class schedules and in-house student forms and contracts. MAM also controls inventory, creates sales and purchase orders, and tracks appointments and messages along wif administrative duties. MAM was converted from File Maker Pro to Access 2000.
- SoftwarePLUS (VB6, Crystal Reports, Oracle): Converted, enhanced and administered a well-documented Visual Basic 6.0, Oracle 8i application. SoftwarePLUS combines a product software configuration and management system wif a customer software registration system wifin Confidential Broadcast and Professional Group. SoftwarePLUS was initially converted from a Visual Basic 4.0, Access 2.0 application to Visual Basic 6.0, Access 97 and is in the process of being converted to Oracle 8i for directly updating the data.
- Laboratory Management System (VB6, Crystal Reports, Access): Converted, enhanced and administered a well-documented Visual Basic 6.0, Access 2000 application. LMS is a management and reporting tool used by the Materials Testing Lab to manage a variety of requests for their services. These services include but are not limited to the designing and recommending of materials to be used in Public Works projects as well as the scheduling, sampling and testing of materials at various job locations. LMS was originally converted from dBase IV to Access 97.
Confidential, San Francisco CA
Programmer/Business Analyst, Database and Report Developer
Responsibilities:
- Inventory Logistic and Information Analysis Database (Access, VBA): Converted, enhanced, documented and administered a DataEase application to Access 97. Most of the data viewed on ILIAD originates in other systems and is accumulated on the IBM mainframe. Data batch jobs dat update the IBM mainframe are done over the weekend, resulting in an extract off the IBM mainframe.
- Engine Module Tracking (Access, VBA): Converted, enhanced, documented and administered a DataEase application to Access 97. EMT tracks the current status, location, and activity pertaining to repairs and/or regularly scheduled maintenance of aircraft engines and their modules performed by Confidential at dis or other facilities. Engines require removal from their aircraft on a regularly timed cycle or when it has a failure dat requires action during routine maintenance.
- Bill of Maintenance (Access, VBA): Converted, enhanced and documented an Access 2.0 application to Access 97. BOM is an estimate tool for overhauling electronic components. BOM estimates hours, parts quantity and cost for major and minor overhauls of listed models.
- FRB Priority Reports (Access, VBA): Designed and developed an Access 97 application. The FRB application is a reporting tool dat determines which electronic components and devices have priority for repair and which components and devices can be scrapped. Later converted to Access 2000.
- Sales Master (Access, VBA): Designed, developed and administered an Access 95 application. Sales Master is a master listing of the sales force for Sony. Sales Master catalogs their capabilities, services, contacts and management teams.
- Sony Authorized Servicers (Access, VBA): Designed, developed and administered an Access 95 application. SAS verifies and validates warranty claims from Sony’s authorized servicers and expedites locating the nearest authorized servicer for any specified product model. SAS regulates data entry by e-mailing regional updates to the corporate office on a quarterly basis. The master database is tan updated and redistributed to all regions throughout the United States.
- Contract Management System (Access, VBA): Completed, enhanced, documented and administered an Access 95 application. CMS manages SupportNET financial budgeting, customer sites and contract bookings. Streamlines the SupportNET membership and contract approval process wif a Microsoft Word mail merge. Furnishes an extensive list of complex reports based on user-defined criteria. CMS was later converted to Access 97 and tan to Access 2000.
Confidential, Cupertino, CA
Programmer/Business Analyst, Database and Report Developer
Responsibilities:
- Cookie Cutter (Access, VBA): Designed, developed and administered an Access 2.0 application. Cookie Cutter manages customer, product, shipper, user, and vendor information. Cookie Cutter includes a direct mailer dat uses Microsoft Word mail merge. Later converted to Access 97 and merged wif ChiroMan.
- Chiropractic Manager (Access, VBA): Upgraded, enhanced and administered an Access 2.0 application. ChiroMan expedites order entry and processing, inventory control and revenue collection, and includes an interactive Microsoft Word mail merge. ChiroMan was primarily designed, developed as an Access 2.0 application, later enhanced and upgraded to Access 2000.
- Bugger (VB4): Designed and developed a Visual Basic 4.0 application. Bugger was developed to confirm a file transfer protocol bug in a dynamically linked library developed by a third-party vendor. Application confirmed problem was the version of Visual C++ dat compiled the library.
- Badge Mail - City of Sacramento, Police Department (Access, VBA): Designed, developed, documented and administered an Access 2.0 application. Badge Mail provides the ability to track and document the sending and receiving of voice mail messages used to notify officers of court appearance schedules. Badge Mail simplifies the tracking of court related voice mail messages and by using FTP to automatically retrieve the information through remote access to Pacific Bell Information Systems’ network.
- Service Activity Manager (Access, VBA, Oracle): Converted, enhanced, documented and administered a File Maker Pro application to Access 2.0, Oracle 7. SAM provides the ability to manage, document and verify the setup and changing status of customer applications and the machines dat support them. SAM allows for remote access to application and machine information, stores the data in an Oracle 7 database and uses SQL to access the data.
- Product Experience (Access, VBA): Converted and enhanced a Paradox application to Access 2.0. ProdEx is a reporting tool dat documents customer complaints and product performance on hospital products. ProdEx imports data from an IBM mainframe located in Chicago to create a series of complex reports containing pie charts and bar graphs dat make up a 130-total page report.
Confidential, San Francisco, CA
Programmer/Business Analyst, Database and Report Developer
Responsibilities:
- Sales and Marketing (Access, Excel, VBA, PowerPoint): Designed and developed an Access 2.0 application. Sales Mark streamlines the cataloging, managing and building of customer contact relationships and encompasses a diversity of inquiries and reports for analysis. Sales Mark documents sales bids, sales budget and market share information, and integrates the use of Microsoft Office (Word, Excel, PowerPoint and Mail).
- Container Trace (Access, VBA): Designed and developed an Access 2.0 application. Can Trace simplifies tracing the movements of shipping and trucking containers during the process of being unloaded and contains an assortment of management decision support inquiries and reports.
- Compensation Manager (Access, VBA, Oracle): Designed and developed an Access 2.0, Oracle 7 application. CompMan integrates documenting, examining and analyzing injury claims for on-the-job accidents. dis includes management inquiries and reports to analyze performance criteria based on a variety of factors. CompMan also communicates wif the insurance carrier software, houses the data in an Oracle 7 database, and is installed in 78 sites from Alaska to Southern California.
- Invoicing and Inventory Control (Access, VBA): Converted, enhanced and administered a dBaseIV application to Access 2.0 using JumpStart. InControl highly simplifies work order entry and job processing, invoicing and revenue collection, and inventory control.
- JumpStart (Access, VBA): Managed project and team, designed and developed database application template. JumpStart 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. dis approach allows developers to focus on crafting the remaining 20% of the application dat is truly unique.