Database Analyst Resume
Los Angeles, CaliforniA
SUMMARY:
- Proficient with database analysis, design and programming as well as consultation and training on large Linux, Unix and networked PC environments for a wide range of business applications.
- Offer superior analytical problem solving skills coupled with teaching abilities and excellent "people" skills.
- Expert with database conversions, data import/export, Unix scripting and Progress Openedge ABL code optimization.
- Author of "The TaskManager", a job scheduling product for Unix systems, written in Progress.
- Utilized my superior analytical and programming skills to simplify employees’ routine tasks by automating and simplifying their daily routines.
- Documented all systems created in order for end users to realize the maximum benefit from incorporating new features and functionality and to act as a training tool for other co - workers in the future.
- As a senior member on many large scale development projects, I led and guided fellow team members and programmers with problem solving techniques as a daily course of action.
- Led many programming teams in group efforts for many clients on many different projects, guiding and expanding the team’s talents and knowledge by sharing my additional experience on a daily basis.
- Created a remote order entry module which could be accessed from a variety of different front-ends, including webpages, and which called for the design and building of new Progress database tables to support the new features of this module. Designed, built and coded a remote invoicing module in a fashion similar to the remote order entry module.
- Designed and coded a BOM loading routine, intended to provide quotes to customers which mapped from an Excel spreadsheet submitted by potential customers.
- This routine reduced data-entry time to 1/3rd while totally eliminating typo-errors and saved the company a substantial amount in time and money. Another benefit realized was increased business with the automation of this process which reduced quoting turn-around time by at least 1/2.
- Automated manual processes for many clients which resulted in reduced time to accomplish daily tasks and eliminated errors from being introduced into the system.
- Utilized my superior skills and knowledge with Progress code optimization to help many clients. Some examples were the reduction of runtime for an inventory movement report from 12 hours for a 4 day date range to 30 seconds for an entire month date range, and also the reduction in runtime of a sales commission report from 2 hours to 6 minutes by introducing "driving files" (file “joins”) and function calls to scope down and optimize proper index bracketing in the Progress Openedge environment.
- An unexpected, gratifying and totally embarrassing moment which was published in the company’s quarterly newsletter, with photographs no less
TECHNICAL SKILLS:
Data Processing Languages: Progress Openedge ABL (Ver. 4-10), WebSpeed (w/ AppServer), HTML, JavaScript, Ajax, Unix Shell scripting expert, SQL.
Operating Systems / Network environments: Linux, Unix (HP,AIX,SCO), Solaris, SunOS, Windows, TCP/IP.
Packages: MfgPro (QAD), Dispatch-1, MXP, Royal-4 (Varnet), Symix/ Confidential, Trend (NxTrend), CreditRevue 2000 (loan brokering), ISS60 (POS), RAM (Web-based order entry system), DTS (Department of defense travel system)Discovery Travel Systems proprietary travel package, Confidential school management system.
WORK EXPERIENCE:
Confidential, Los Angeles, California
Database AnalystResponsibilities:
- Worked with Confidential, a third party servicer which provides educational institutions participating in the Confidential Title IV programs the software, reports and consulting assistance needed for the student recruiting process through student placement, including student loan default prevention, final reporting and reconciliation with the Confidential utilizing their proprietary software written in Progressversion 10.2B.
- Created many programs, utilizing the Progress Open Edge ABL language to upload data files provided by the Confidential used for reporting on a schools performance to the government in order to maintain government backing of the school through government assisted student loans.
- Designed the Progress Openedge ABL database files necessary to store and retrieve this information in the form of reports used for
- Designed and coded front - end webpage screens utilizing WebSpeed, HTML, CSS and JavaScripts to maintain the information necessary for Confidential reporting.
- Interviewed clients in order to define their custom programming needs and programmed these requests for the clients.
- Maintained and modified other programs and screens as necessary, in the Progress Openedge ABL and WebSpeed environments.
Confidential, Santa Ana, California
Database AnalystResponsibilities:
- Worked with Confidential (Ver. 5.0), Progress (Ver. 10.1B), Ajax, JavaScript and Html code on an OEM manufacturing system which had manufacturing operations located in Malaysia.
- Developed new modules in this company s CRM modules to eliminate the usage of the legacy Confidential system in favor of a more advanced web - based system.
- Taught programming team members Progress query optimization techniques with presentations and documentation.
- My best accomplishment for this period was creating a Fuzzy Search program to aid in their marketing campaign, written in Progress.
Confidential, Pleasanton, California
Database AnalystResponsibilities:
- Designed, coded, implemented and maintained a host of commercial websites utilizing mostly Html.
- Returned to this former client for a 4th tour of duty. Most assignments during this term centered around “Webifying” critical business modules in order for their various branches to be able to remotely access these modules over the internet, using WebSpeedHTML and JavaScript to update their Progress database.
- Created a remote order entry module which could be accessed from a variety of different front - ends and which called for the design and building of new Progress database tables to support the new features of this module.
- Designed, built and coded a remote invoicing module in a similar fashion to the remote order entry module.
- Re-wrote the quote and estimating system to use Webpages which could be accessed remotely over the internet. Designed and programmed all of the screens involved using WebSpeed with a heavy dose of JavaScript in order to alter each webpage s DOM in order to update figures automatically as data was entered by the user without having to refresh the web pages.
- This particular module was very complex and math intensive because it had to take a multitude of factors into consideration such as vendor price breaks across the different quantities being quoted, substitute parts pricing as well as the enforcement
- Designed and coded additional web page routines to handle the file maintenance of critical system files mostly centered around web access security.
