- National Life of VT, Montpelier, VT 2000-2003
Responsibilities: Participated in the Commission Statement Redesign (CSD) project.
Achievements: Created a modular, flexible reporting system to provide customized statements with different levels and commission structures for the many companies under National Life's corporate umbrella. Extracted the business rules for the varied organizations. Skills used: Abend-aid, ADSO, BMS, CICS, CLIST, COBOL I/II, Compuset, DB2, File-Aid, GEAC Millennium series, IDMS, InterTest, JCL, MicroFocus COBOL, MS Office, OnBase, On-Demand Host, Panvalet, PL/I, REXX, SAS, SMS, SQL, TSO:ISPF, Visio, VSAM, Xchange.
- Fort Benjamin Harrison, Indianapolis, IN 2000-2001
Responsibilities: Participated in the Defense Joint Accounting System (DJAS) project.
Achievements: Created interfaces to provide standardized and consistent reporting for all branches of the US armed forces. Compartmentalized and stream-lined the processes and procedures. Performed DBA and QA functions. Skills used: Cognos, Impromptu, MS Office, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Process Designer, SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, VBA.
- UCLA Medical Center, Sylmar, CA 2000
Responsibilities: Accepted the Aftercare OB/GYN project on a fixed-bid basis.
Achievements: Designed and developed Aftercare in Oracle. Performed the business operations, workflow, optimization, and needs analysis. Performed the data analysis, modeling, and mapping using Designer and Developer 2000, as well as Platinum ERWin. The data entry screens were Oracle Forms. The reports were Oracle Reports and SQL*Plus. Integrated data from Access prototypes and hard-copy patient records. Designed aftercare to be scalable and expandable (breadth and depth). Identified issues to be resolved in future modules and scope expansions. Skills used: Access, Activex, Crystal Reports, Excel, FTP, HTML, Java, Lotus Notes, MS Office, MS Project, Oracle, Oracle Forms, Oracle Reports, PL/SQL, Platinum ERWin Erx, Powerpoint, SQL, SQL*Plus, SQL Server, Transact SQL, UNIX, VB (Visual Basic 6), VBA, Windows NT Server.
- BAX Global, Irvine, CA 1998-2000
Responsibilities: Participated in the migration from mainframe to Oracle Financials.
Achievements: Customized the oracle tables to meet BAX's needs. Extracted the business rules from existing applications and translated them for Oracle. Applied the masking, editing, and constraints. Set up the alarms and the user prompts. Created and added the outside collections system (CSI) to automate the referral of accounts to collection agencies, the tracking of referred accounts, and the calculation of commissions. Normalized and improved data quality controls of the accounts receivable (AR) and MSA accounting systems before extracting, transferring, and loading the oracle tables using SQL Loader. Designed custom reports and forms to add functionality to the oracle financials implementation. Skills used: Adabas, BMS, CICS, CLIST, COBOL I/II, DB2, DL/I, DWA COBOL Merge, DYL-280 II, Easytrieve Plus, Focus, FTP, IMS DB/DC, JCL, MS Office, MSA Accounting, Natural, Oracle, Oracle Financials, Oracle Forms, Oracle Reports, PL/SQL, SQL, SQL*Plus, Syncsort, TSO:ISPF/PDF, UNIX, VB, VSAM, Xpediter.
- Sharp Manufacturing Corporation of America, Memphis, TN 1998 - 2000
Responsibilities: Participated in the legacy to SAP R/3 implementation.
Achievements: Provided a blend of functional and technical analysis (80-20) for the SAP R/3 implementation (Oracle as the RDBMS). Customized and configured the installed modules. Participated in the Business Engineering (BE) and Business Process Re-engineering (BPR) for the Sharp Manufacturing Free Trade Zone in Memphis, TN. Started the database management and mining. Led the legacy process analysis including business rules extraction. Performed the data analysis and mapping; database normalization and clean-up; data extraction, transfer, and loading (ETL). Technical responsibilities included the platform and database migration, data conversion; prototyping and modeling; and data warehousing on the Oracle and non-oracle systems. Functional responsibilities included impact analysis and change/co-existence management; process alignment with the post-implementation system; gap analysis and enterprise application integration. Participated in Super User/project sponsor meetings; in Joint Application Design (JAD) meetings; in team building and user training. Designed and added the open account system of reconciling transfers between the subsidiary and the parent corporation. Created the interfaces between Oracle and other client-required software/hardware. Skills used: ABAP/4, BMS, CEDF, CEMT, CICS, COBOL, DB2, DL/I, Easytrieve Plus, Excel, Glossary (GLOS), ICCF, IMS DB/DC, Infopac, JCL, On-Line File Utility (OLFU), Oracle, PL/SQL, SAP R/3, SAPScript, SAR, Scheduler (SCHD), Spooler (SPOC), SQL, Unix, VSAM.
- LabCorp, Burlington, NC 1997-98
Responsibilities: Participated in the merging of National Health Laboratories and La-Roche business into the existing LabCorp systems.
Achievements: Enhanced the HMO eligibility system in order to reduce the redundancy of efforts and staffing, centralize eligibility processing, produce more timely and accurate billing, lower processing costs, and raise client satisfaction levels. Skills used: BMS, CICS, COBOL/370, DB2, File-Aid, FTP, Infopac, IOF, JCL, MicroFocus COBOL, MS Office, QBE, QMF, SQL, Syncsort, TSO:ISPF/PDF, VSAM, Xpediter.
- Blue Cross Blue Shield of South Carolina, Columbia, SC 1997
Responsibilities: Participated in the blending of IT streams to handle data processing for other Blue Cross Blue Shield organizations.
Achievements: Identified core issues in system integration for expanded business area and database migration from TOTL to DB2, including impact analysis and data-mapping. This led to smoother transitions and pro-active enhancements. Skills used: Abend-Aid, APS, BMS, CICS, CLIST, COBOL I/II, DB2, DL/I, DYL-280 II, Easytrieve Plus, emc2, Endevor, File-Aid, IMS DB/DC, Infopac, IOF, JCL, QBE, QMF, QUIKJOB, REXX, SAS, SQL, Syncsort, TOTL, TSO:ISPF/PDF, VSAM, VSAMUTIL, Xpediter.
- Burbank Housing Authority, Burbank, CA 1994-97
Responsibilities: Provided consulting services on a fixed-bid and fixed rate basis on multiple, concurrent projects.
Achievements: Designed an integrated database system for the Burbank Housing Authority. This resulted in better tracking of participants at every level of the program, better reporting, the detection of fraud, and lower penalties imposed by US Department of Housing and Urban Development (HUD). Skills used: Access, BMS, C/C++, CA-EZTE, CA-Librarian, CICS, COBOL I/II, DB2, DBase IV, DOS 6.2, DOS/JCL, DOS/VSE, DYL-280 II, FTP, MS Office, SQL, VSAM, Word Perfect.
- Burbank-Glendale-Pasadena Emergency Response System, CA 1993-97
Responsibilities: Participated in the collaboration of efforts involving local, state, and federal agencies, to provide a comprehensive emergency response system.
Achievements: Migrated data from various platforms; enforced referential integrity and normalization; implemented federal and county regulations, and integrated the data from several jurisdictions into the existing Geographic Information System (GIS). This led to more timely emergency response efforts and greater safety for emergency workers. Performed the data analysis and mapping. Designed and developed the hazmat tracking and permit system. Performed the data extraction, transfer, and loading from multiple sources on different database systems into oracle. Used Oracle for unix for the graphical mapping and oracle for the mainframe (MVS) for the data warehousing using embedded Oracle/SQL. Skills used: Access, ArcInfo, ArcView 2, AutoCAD, BASIC, BMS, C/C++, CA-VOLLE, CICS, CLIST, CMS, COBOL I/II, COBOL/370, CPS EasyMaps, DataEase, DB2, DBase IV, DL/I, DOS 6.2, DOS/JCL, DOS/VSE, DYL-280 II, Excel, FTP, ICCF, IEF, IMS DB/DC, Infopac, Lotus 1-2-3, Oracle, MapInfo, MVS/ESA, MVS/JCL, Netscape, OS/2, OS/390, OS/400, OS/JCL, OS/MVS, QBE, QMF, REXX, SAS, SQL, SYBASE, Syncsort, TSO:ISPF/PDF, UNIX, VMS, VSAM, Windows 3.1/95, Word Perfect, Xpediter.
- Reynolds, Kendrick, Stratton (RKS), Beverly Hills, CA 1992-94
Responsibilities: Promoted the use of appropriate technology among financial advisers.
Achievements: Programmed Quotrek (hand-held, wireless remote quotation system) for stock tracking and audible alarm for quicker response to market changes. Designed a client/contact system to ensure consistent and timely follow-through by registered representatives with prompting for referrals and feedback. Set up and trained users on the Quotron system, reducing the need for telephone-based quotations and speeding up buy and sell processing by 57%. Designed spreadsheets for risk/reward analysis aiding registered representatives in fulfilling their fiduciary responsibilities by recommending the investments most suited to clients' risk tolerance, temperament, and financial objectives. Skills used: ADSO, BMS, CICS, CMS, COBOL, DB2, DL/I, IDMS, IMS DB/DC, Powerbuilder, SQL, SYBASE, VMS, VSAM.
- Medi-Group, Los Angeles, CA 1993 Responsibilities: Evolve a heavy-volume, state-subsidized care facility from the pen-and-ink world into the computer-age.
Achievements: Converted the paper accounts receivable system to a computerized system that aged accounts and generated appropriate collection notices. As a result, collections were increased by nearly 30%, average age of accounts was reduced to 3 months from 8.7 months, and small claims court filings were increased 43%. Skills used: BMS, CA-Utilities, CEDF, CEMT, CICS, CLIST, CMS, COBOL, DB2, DL/I, DYL-280 II, Easytrieve Plus, Focus, IMS DB/DC, JCL, QBE, QMF, QUIKJOB, REXX, SAS, SQL, TOTL, VSAM, Xpediter.
- Golden State Mortgage, Alhambra, CA 1990-92 Resposibilities: Implement computerized loan processing software.
Achievements: Enhanced the loan application packaging system and tailored it to fit the regional needs of the customer population. Monitored and supported various pc-based systems reducing downtime and lost productivity. Evaluated available software and made recommendations based upon suitability, ease-of-use, and scalability. Installed software, and created macros as needed. Skills used: Abend-Aid, BMS, CA-Utilities, CEDF, CEMT, CICS, CLIST, COBOL I/II, DB2, DL/I, DYL-280 II, Easytrieve Plus, IMS DB/DC, JCL, QBE, QMF, REXX, SAS, SQL, Syncsort, TOTL, VSAM.
|
