SUMMARY

I am experienced in using VBA and SQL commands to extract data from a big database like Oracle, transfer it into a menu-driven and multi-user system in MS Access where it is processed and exported into charts and graphs in Excel or Powerpoint. Also, using VBA, I can format and write output to an Excel worksheet from another Windows application. When the user opens his Excel worksheet, it is ready for presentation and further analysis.

TECHNICAL SUMMARY

• EXCEL skills
• Formatting including conditional formatting
• Formula creation
• Pivot tables
• Charts
• Macros
• VBA language integration
• ACCESS skills
• SQL unions, joins, action queries, crosstabs, subqueries, correlated subqueries, aggregate queries, domain aggregate functions, descriptive statistics, percentile ranking, median, random sampling, frequency distribution
• VBA
• Menu creation
• Reports creation
• Charts creation
• Pivot Tables
• Batch or Scheduled jobs un-attended
• Automation manipulating EXCEL files from within ACCESS
• Optimization splitting the database into Front-end and Back-end
• Systems Analysis and Design
• Functional Design Data modeling, Data flow diagrams, Process flows, Functional diagrams, Entity Relationship diagrams, Data Dictionary
• Technical Design Data structures, Index creation, Data modeling, Program specs
• Documentation Users' Guide, Technical Specs
• Training
• Data Quality Analysis creation of Key Performance Indicators for monitoring 6 quality dimensions Integrity, Timeliness, Consistency, Accuracy, Completeness, Validity
• SQL sequel or Structured Query Language for extracting and manipulating information in databases
• Access Basic or VBA Visual Basic, C , Javascript, XML
• Diagramming and Data Modeling software such as VISIO Project management

Professional Experiences

Confidential

Access/VBA Developer

Projects for OPWDD Office for People with Developmental Disabilities

• Personnel Benefits Application Employee database for Personnel department that allows emailing of probation schedules and Status letters to new employee's supervisor allows tagging ON HOLD for positions up for promotion generates reports on counts per Line Item, per Department, per URC. Used Access database for storage, VBA for menu and table updating, CITRIX as platform for distribution. Performed systems analysis and design requirements gathering, functional design, technical design, programming, documentation and training to come with the new system. Created charts for their data.
• Aging Out Application Database for monitoring members who are aging out or growing too old to be a beneficiary. Created and modified reports generating summaries by Location and by Agency. Used VBA for table updates and coding behind the forms.
• Maintenance of existing Access/VBA code
• Creation/addition of new applications or modules for other systems
• Generated ad hoc exports to EXCEL for analysis by supervisors and managers. Used SQL queries to extract data and then export to EXCEL.

Confidential

Oracle Data Specialist

• At client site of Pension Benefits Guaranty Corporation PBGC , operated existing systems for generating actuarial reports
• Created ad hoc reports for actuarials
• Modified or debugged existing systems
• Created new systems in Access 2010 interfacing with Oracle data
• Created user manuals
• At client site in Virginia, was part of a team that created a Cost Accounting System for the government classified. Recommended the use of Access 2010 instead of Excel to deliver a menu-driven Dashboard system.. Part of the development team and we used a lot of VBA and Automation.

Confidential

Maintenance Systems Administrator

• Maintain ACCESS system develop new reports as requested.
• Gather mechanical interruptions data from M145 document
• Find and link to existing TRAX defect reports.
• Gather scheduled departures for the day per fleet.
• Compute and generate charts for Dispatch Reliability DR and
• Schedule Completion Rate SCR . for the DAY, Month-to-date,
• and Year-to-Date summaries
• Update STAR Flights monitoring charts
• Mark and record all Significant Events Aborted Take-off, Return to Gate,Return to Field, Diversions
• Send dashboard report summary emails out to VP, Directors, Vendors
• Monthly summary of delays and cancellations, summary of Hours and Cycles per fleet
• Provide 3-month Rolling Rate per 1000 Flight Hours Summary of Significant Events for the past year.
• Provide Summary of Costs per Fleet, per ATA.
• Provide Top 10 Components with Repair Costs Summary..
• Provide Transactions listings for Removals Scheduled Unscheduled, Delays Cancellations,
• Pilot Reports listing to FAA and to Vendors.

Confidential

Data Analyst I

When I came in to the Reliability Department in 2006, everything was done using Excel spreadsheets. Seeing the difficulty the previous analyst/clerk had with tabulating the daily transactions in order to come up with a summary or report. There were frequent changes to previous day's entries due to audit or corrections. With prior knowledge in programming and despite limitation of not having tools and access rights from the IT department, created the following solutions :

1. The design of a screen-scraper . A program that gathers data from what's displayed on-screen. The source document is the M145 and I could only get to it from a report on-screen.

2. The creation of a DOS database that had the power of a low-level language for importing the screen-scraped data and do complex computations. The Clipper programming language came in handy in converting each complex record which has 3 paragraphs embedded in it. Other systems can only import records with 1 paragraph. This database stores the source for all computations for DR and SCR and Significant Events.

3. The design and creation of an RDBMS in ACCESS. My database is called RAPiDD. It stands for Reliability Analysis Program Interactive Data Display. This database combines the data stored in the DOS database with all other data that comes from TRAX the company's official software for maintenance namely discrepancy text, action taken text, non-routines, scheduled and un scheduled removals, hours and cycles, costs, parts master, interchangeables, stations, and teardowns. RAPiDD is installed in more than 50 computers as a desktop application. Simple to install and maintain. It is menu-driven and allows users to query and generate reports and charts on their own. At present, RAPiDD has over 200 built-in queries and reports. An added and intentional feature is that these queries are user-customizable. The user can run a query and tweak the parameters further to fine-tune his data mining. He can then save it as his own.

4. The design and creation of batch scheduled jobs. The lengthy and tedious job of conversion of TRAX data to ACCESS format is done starting at 5am. Data is converted to ACCESS because :

• a. Software license to connect to TRAX's Oracle format directly is expensive. Around 1000 per computer
• b. We have only READ access rights on TRAX data No WRITE and we had to add a few fields for our own processing. ie. Significant Events , group part number

5. The design and creation of automatic daily and weekly scheduled back-up.

6. The design and programming of other systems using ACCESS and VBA Visual Basic for Access . The RAPiDD database has become a central repository of data usable by other systems like :

a. Task Cards Monitoring system data entry for M001 document, reports on Counts over Time YR-Mo , Average dwell times over Time, Rates over Time, Top Repeats, Distribution by Major Minor Categories, Summary of Hours by Task Card

b. EC Monitoring System allows for the gathering of data based on control points and determines compliance by computing rates for PRE and POST data. This is a sample of a customized analytics software.

c. Interactive Checks Monitoring system another example of customized analytics software. Determines performance or effect of Checks done on an aircraft based on several methodologies. Analyst can choose between :

i. Time Intervals after the check -- 50, 100, 200, 300 hours

ii. Date range with rates by ATA

iii. Days of operation PRE or POST the check

iv. Cycles of operation PRE or POST the check

Confidential

Stores Clerk, Warehouse

Confidential

Consultant

Setup data processing department with a LINUX server and Windows workstations for a nationwide billing and sales analysis system. There were 40 branches all over the Philippines. Designed their data collection procedures and consolidated sales reports daily for the central office in Manila. The application for the branches was programmed in Clipper language while the consolidating and reporting program at the head office was a combination of Clipper and Lotus Approach a Windows GUI system

Confidential

specializing in customized applications like Billing, Inventory, Payroll, Registration Grading, Project Management, Accounts Receivable, Accounts Payable, General Ledger, Cash Monitoring

Confidential

Computer Programmer