Summary

• An experienced analytics professional, with a background in database design and development, capable of conducting multifaceted analysis in the following areas:
• Expert at writing complex SQL joins to populate tables or create views as source for Crystal Reports.
• Experienced in writing User-Defined Functions in Crystal Reports for formatting and calculations.
• Creating the views and pivot tables advanced skills and writing user-specified procedures in VBA for provisioning and maintenance reports required by upper management and the CPUC
• Proficiency building Excel models for both accounting and finance related analysis
• Responsible for preparation of periodic financial reports from data extracted from RDMBS.
• Reported monthly financial results and variance analysis, identified issues and measured results to ensure fiscal plan goals
• Excel Spreadsheets analysis, production forecasts, and return on investment reports.
• Excellent public speaking skills complemented by exceptional written and oral skills providing persuasive presentations
• Relevant skills include experience working with technology tools PowerPoint, MS Excel, Word, Access, SQL Scripts, Ad-Hoc queries, Crystal Reports UDFs and other reporting tools
• Project Management - Able to provide cost-effective and timely results, establishing delivery schedules, metrics, web tracking and documentation
• Confident and poised in interactions with individuals at all levels

Experience

Confidential

Senior Business Analyst

• Routine Work include writing sql scripts to fulfill ad-hoc data requests from various departments and groups often using sub query factoring, rewriting existing scripts to conform to new requests and conditions.
• Maintaining recurring sql scripts on which extracts for monthly and quarterly reports were based
• Consulted in the design, transition and implementation of a data warehouse to replace the Database

Confidential

Database Consultant

Contracted to implement changes to the Data Mart and associated templates created during my first stint at Gap Outlet in Access and Excel.

Confidential

Database analyst

Conducted a feasibility study to improve processing time in Inventory Look-up in Access and SQL Server.

Confidential

Database Consultant

• Converted a system of 19 reports in Excel worksheets to one based on an Access data mart using ADO and DAO on older Excel versions to populate Workbooks with data from the Access data mart.
• Automated data transformation after downloading from a MicroStrategy data warehouse.
• Wrote utility modules in VBA including one to monitor a folder using Windows handles.

Confidential

Information/Platform Analyst

• Primary responsibilities include: Providing Consumption and Cost Analysis to Facility Managers through Excel pivot tables and charts downloading energy data from multiple partner providers in XML and CSV formats, developing and applying relevant calculations to update charts on SharePoint site recommending presentation formats to Facility Managers to maximize visual impact.
• Automating worksheet updates and reformatting XML and CSV data using Excel VBA and macros.
• Furnishing Subject Matter Expertise to software designers and engineers in an Agile Scrum environment.
• Supporting Facility Managers in developing Sharepoint sites for maximum impact for their clients.
• Maintaining multiple Sharepoint sites as a Site Collection administrator.
• Downloaded, restored and made sense of provider SQL database to develop an Access data source.
• Designed Crystal Reports on specifications of Facility Managers.
• Delivered detailed data model to development team tasked with creating an automated version of the current system.

Confidential

MS Access Developer/Information Analyst

• Performed database maintenance, optimized and implemented changes based on management requests
• Created PowerPoint presentations that were presented to the Client's upper management

Confidential

Information Analyst/VB Developer

• Built Excel data models for financial related analysis and variance analysis reports
• Implemented Excel workbooks, Pivot Table payment and fee calculation programs and processes
• Features include a Summary Viewer to see how many pages are in each document, a Toggle to denote the first page of the document therefore the start of the bundle, and the bundling of the selected documents to be rendered into PDFs via AdLib
• Developed a trial document TIF viewer in VB 2005 extensively using the Datagridview object which allowed paralegals to organize and package court documents for research and archiving purposes

Database Analyst

Assisted in the functional design of a database, which tracked the software tests performed on the inventory of different IC components. The resulting reports derived from the database provided information on the different testing phases of the IC through work in progress to completion. Wrote the scripts to load the tables with initial inventory and test results. Created the views from which reports will be derived.

Confidential

Database Analyst

• Developed in-house automated candidate search database in Access segmenting skill, knowledge, experience and education
• Built Excel data models for financial related analysis and variance analysis reports
• Maintained Excel workbooks, Pivot Table payment and sale programs and processes
• Performed Excel Spreadsheets analysis, Sales forecasts, and ROI reports
• Upon receipt of Outlook from a hospital request personnel, skills required are matched with the skills set of a candidate and emailed back to the hospital

Confidential

Project Lead Business Objects and Access Development

• Created the views and pivot tables and wrote user-specified procedures in VB5 for provisioning and maintenance reports required by upper management and CPUC. The reports were created in Crystal Reports.
• Modeled business processes for Compliance Reports data transfers and transformations using SilverRun
• Optimized transfer of data from Business Objects to Access databases that produce managerial reports
• Enforced business rules in terms of value parameters and cut-off dates
• Created a data warehouse in Oracle using legacy systems' data feeds for maintenance and provisioning
• Used SQL to extract,''raw maintenance and provisioning data, transformed from Business Objects database and cleansed the data to conform with parameters and limitations as defined by the California Public Utilities Commission then loaded SQL Server tables which were used as sources for Data Analysts
• Wrote stored procedures, triggers, and special functions to comply with requirements of the CPUC
• Wrote client and server side scripts to make calls to the Access databases populating web page tables

Confidential

Sr. Database Developer/Consultant After PG E Deregulation

• Designed and implemented reports in Crystal 6.0
• Wrote MS SQL 6.5 scripts to validate and populate tables used in a Crystal Reports 6.0 System
• Built Excel data models for financial related analysis and variance analysis reports
• Migration paths from various sources Access, SQL 6.5 and Oracle into a Compliance Tracking System for PG E Corporate
• Wrote MS SQL 6.5 stored procedures to populate tables used in a Crystal Reports 6.0 System
• Wrote VC 5.0 application to for billing system in compliance with deregulation requirements and to validate address data using a third-party DLL named Perfect Address which read an Oracle 7.3 database using DAO and verified the address.
• Programmed a system that allowed users to enter Paper Bills into an Access then uploaded to Oracle
• Made enhancements to a Bill Printing system in Access '97 to specifications

Confidential

• Designed, managed and planned expected rapid expansion of proprietary IP communication software
• Converted prototype system from a microcomputer based DBMS to Oracle using PL/SQL and Pro C for large- Partner scale applications, MS-Access and VB for small to medium-sized applications
• Developed the help system in Help Magician '97
• Modeled and Prototyped the business process using Silver run
• Designed and managed the plan for the beta test, which eventually involved approximately 400 users
• Wrote a trouble tracking system using MS Access v7.0 that tracked usage problems of the beta test
• Implemented bug fixes in MS Visual C programs and VOS/VOS NT for Gamma Fax
• Designed a data warehouse for the product using Oracle 7.7.3

Purchased Receivables

Confidential

• Translated original SAS Programs into SQL Statements, wrote SAS Ad-Hoc programs for data pulls
• Developed and tested SQL scripts that imported transformed and processed billing cycle data for the Data Warehouse
• Wrote other scripts performed data validation, special calculations, extracts and groupings
• Developed an automated 'hands off' Telecom Billing System in MS SQL 6.5, C and C
• Designed and modeled ancillary subsystem fed by Data Warehouse using SilverRun
• Organized scripts into stored procedures
• Wrote DLLs for Crystal Report in C that converted to and from Julian Dates standard dates to avoid billing on holidays and calculated Payment due date when provided with a base date a cash lag factor
• Built a subsystem in C that used Crystal Reports API to automate the generation of 114 reports. Another program written in C organized and bundled the reports into files for delivery to Third Party vendors Built a remote reboot and login procedure using Windows NT Server Resource Kit and PCAnywhere
• Administered twin NT Server system for local and remote users
• Upgraded Windows NT Server and W/S from 3.51 to 4.0 and MS SQL Server from 6.0 to 6.5
• Provided both System User documentation for operation of CD-ROM writer and for downloading data from the mainframe using Connect: Direct

Confidential

Developer/Consultant

• Established a support structure to maintain and troubleshoot application problems in the Western Pacific area including Yokusuka, Japan and Pearl Harbor using PC AnyWhere
• Fixed outstanding bugs in the xBase system running on Windows NT 3.51
• Enhanced the existing Remote Order Entry system based on requirements in areas of user interface
• Consolidated multiple redundant programs into a procedure file

Confidential

Developer/Consultant

• Tasked to shake out multi-user related bugs in an Inventory Planning System written in Access for Windows in a Novell 3.11 environment.
• Rewrote the inventory planning system to avail of true multi-user access
• Redesigned database to accommodate transition to a PeopleSoft Sybase client/server system.

Confidential

Database Developer/Consultant

• Developed a subsystem in Access '95 to extract and transmit information from multiple databases according to a format and rules prescribed by WestLaw publishing
• Developed an algorithm to create an annual index for all cases for each county, case type, injury type, experts and expertise, and attorneys and law firms. Implemented complex editorial rules for displaying page numbers such as: page references for succeeding cases of three or more must have first and last reference separated by a dash, otherwise separated by a comma, trial Judges with benches in more than one county must have page references by county, trial experts and their expertise must have separate indexes, etc.

Confidential

Developer

Developed a Class Scheduler subsystem in Access and integrated it into the main HealthCare system.

Confidential

Senior Developer

• Responsible for enhancement and maintenance of Order Entry System in MS Access and developing application programs in AWK, MKS Kornshell and C
• Simulated existing production system that used XYWrite and Quattro Pro driven by AWK and MKS Kornshell using Microsoft Word, Excel and Visual Basic
• Normalized system tables to improve performance and stabilized the Order Entry environment
• Developed implemented Order Entry subsystems for Mutual Fund, International and Private Company profiles including enhancements to scripts and forms, together with the actual document generating programs and procedures in AWK, MKS KornShell Script and C
• Designed, coded and implemented modem delivery capability using ProComm Plus and MKS KornShell
• Designed remote order entry record interface to facilitate transactions between the remote parent company's Oracle System and the local Order Entry system. Wrote store procedures and functions to process the orders
• Established QA environments for more effective program testing
• Wrote a suite of programs in Access and C to import data into the system tables, update then data then synchronize system tables

Confidential

Consultant

• Converted a single-user loan-tracking system in Clipper to a multi-user application using NovLib, a third- party function library, which enabled upper management to generate reports based on data off-site.
• Confidential Completed the project that was put on hold in 1992 and implemented enhancements to the original system included Write-off and Net Bad Debt calculations, Report Bundling and uploading back on to the mainframe.

Confidential

Project Lead Assigned

• Managed Esprit Retail Systems and Personnel that consisted of two hardware specialists, one help desk person two junior programmers. Planned and coordinated personnel and purchased equipment for store openings and installation of IBM PC LANs and proprietary software at new stores. Coordinated Hardware and acquisitions with Esprit's technical staff in preparation for store openings throughout the US.
• Responsible for enhancing Esprit's Point of Sale and Back Office systems in Pascal and Clipper respectively in an IBM PC Token Ring LAN environment. Released two enhancements in one year.
• Managed inbound and outbound data traffic from stores to corporate AS/400 and on to the mainframe via 3270 emulator.
• Improved efficiency of data transmission from 18 stores nationwide to corporate headquarters by adding another Communications PC and changing the timing of the transmissions.
• Implemented a database for tech support personnel containing common problems called in by store managers. These problems provided a basis for Software/ Hardware enhancement requests.
• Confidential Performed the Analysis,Design and Coding of a Purchased Receivables System with a development team using Warnier-Orr design methodology, Paradox PAL C - The system imported text files downloaded from the mainframe via Network Data Mover, performed verification and versioning, then assigned records based on Account Code through Queries into Report Groups for each of PacBell's clients MCI, Sprint, AT T . The design called for a table-driven system in which the Account Code triggered the execution of a specific procedure embedded in the table. The report generation phase performed Month-to-date, Year-to-date and Positive Reporting calculations, then bundled the reports using AWK scripts according to third-party requirements.

Confidential

Instructor

Taught classes in DOS, dBASE, Lotus and WordPerfect. Also provided support and troubleshooting for classroom and administration office Novell 3.11 LANs.