Summary

I am experienced in using VBA and SQL commands to extract data from a big database like Oracle 11g, 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

BA Developer

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.

Office of Internal Affairs Database for monitoring cases filed with the different agencies. Inputs are Excel spreadsheets from 13 different regions and sub-regions. These are emailed to central office where it is consolidated into a master spreadsheet. It is also uploaded into an Access database for more flexible reporting by Region, Agency, Dates among others. This system uses a lot of automation between Access and Excel.

• 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, Reliability dept.

• 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, Reliability dept.

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 :

• 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.
• 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.
• 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.
• 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 :
• Software license to connect to TRAX's Oracle format directly is expensive. Around 1000 per computer
• 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