SUMMARY

Business Analyst:

• Requirements gathering, testing, and documentation.
• Software Engineer: Data Mining using SAS, Teradata, Microsoft ACCESS, Oracle, SQL Server.
• Migration from MS ACCESS to SQL Server.
• Microsoft Office Automation using ACCESS, EXCEL, WORD, and PowerPoint.
• Seeking a Business Analyst opportunity to deliver solid business solutions.
• Skills included data mining, process improvement, data analysis, system processing analysis, testing, data compares, data reporting, communication, meeting deadlines, and the ability to work with the Business Community as well as the IT Community.

TECHNICAL SUMMARY:

Confidential

• Tools: SAS EG, SAS 9.2, Teradata Studio, IBM Cognos Transformer
• Microsoft: SQL Server, Access, Excel, Word, PowerPoint
• Building solutions using Office Automation
• Language s : VBA

WORK EXPERIENCE:

Business Analyst / Software Engineer

ACCESS Databases

• Currently working with DB2PD and Teradata databases to mine Pharmacy Claim data.
• Tools: SAS EG, SAS 9.2, Teradata Studio, IBM Cognos Transformer
• ACCESS SQL: Created SELECT, UPDATE, INSERT, and DELETE queries.
• Worked with pass through queries for best performance.
• Also developed a method to store and execute queries for processes.
• Teradata: Created a temp table in Teradata Sandbox database for data mining.
• SAS: Created a SAS temp table for data mining. Created explicit pass through queries.
• Documentation: Created several HOW TO documents.
• Created a Cheat Sheet for Database Tools.
• Previous work experience included analysis of current processing and producing technical specifications.
• Data: Previous work experience included data mapping to load eligibility data for 300K lives.
• Analyzed data for quality and completeness.
• Testing: Previous work experience included test plans for pass / fail with screen prints and summary for failures.

Preferred Drug List ACCESS Database

• Created an ACCESS database to provide Pharmacy Rebate opportunities. This database extracts data from two DB2 databases and creates Excel and PowerPoint files for each Client ID from a list of Clients. The end result is with a click of a button, this database builds 500 Excel files, 500 PowerPoint files and one Index file with hyperlinks to the Excel / PowerPoint files. This process runs on a laptop in 2 hours for 250 Client ID's. There are two Excel templates and two PowerPoint templates for the output of 'Value Preferred Drug List' and 'Rebate Model' data.
• Created a GUI form to allow User to select one or more Client ID's to run on a monthly basis against Claim data.
• Also drafted Technical Specification which includes a one page overview of the process.

Repricing / Network Disruption / Formulary ACCESS Database

Assisted a team member with automation for query execution of multiple query groups. Created the VBA code to automate query execution with capturing run time for each query and displaying the query being executed. Worked to reduce query run times and streamline process. Had to review and comprehend the existing process within a tight timeframe. VBA code created is reusable in any ACCESS database that needs to automatically execute queries.

Drug Interchange ACCESS Database

• Created an ACCESS database to automatically create 'Drug Interchange' Excel files.
• Created a GUI form for the User to enter required data, run queries, and create the Excel output files.
• Other
• Assisted Team members with questions on ACCESS, queries, existing processes, and design techniques.

ACCESS Database Migration to SQL Server

• Responsible for migrating several ACCESS databases to SQL Server. Created several DB ID's for Read Only and Read / Write access. Created ODBC connections and relinked ACCESS tables.
• User testing completed successfully with a few minor performance issues that were resolved using pass through queries.

Invoice Analysis ACCESS Database

• Took over responsibility for this existing ACCESS database that had no structure, many poor performing queries and processes. One process ran for over 9 hours. I reduced the run time to under 1 hour. Added forms and additional functionality. This database uses back ends in
• Oracle, ACCESS and SQL Server databases.

FMG Chart ACCESS Database

• Took over responsibility for this existing ACCESS database with many issues.
• Added functionality to this database to automatically produce over 200 EXCEL Charts for many customers.
• Also added process to automatically generate a single WORD document for all chart images. The WORD document was created to show chart images in a certain sort order.
• For one process, reduced VBA coding from 60 pages to under 10 pages with additional functionality. Redesigned to streamline processes.

Tool Proposal ACCESS Database

Enhanced an existing ACCESS database to generated Tool Proposal pages output as PDF documents from a VBA module. Process created 700 pages in 6 minutes. Assisted in getting the tool pages printed as a book. Made form changes for new fields. Created EXCEL VBA code to update hyperlinks.

Imported data from an old R2 ACCESS database.

Action Item ACCESS Database

Developed ACCESS database to track and manage Action Items such as Server Requests, Customer requests. Built a Dashboard form to show open Action Items assigned to employee and unassigned Actions Items. When a new Action Item is created, the database creates an email for User to send to Requester. Developed EXCEL charts, and reports.

Miscellaneous

• Built EXCEL tool to compare data from 3 different sources and highlight the differences.
• Built an ACCESS tool to perform calculations. Used by Testers to verify application was correct.

Confidential

Referral Account Balancing System ACCESS Database

• Developed ACCESS database to balance and book to General Ledger all transactions from a
• Mainframe Application. This involved importing nine transaction files, grouping transaction
• types by date and then applying GL Accounts. Created forms to perform balancing, summing dollars to a transaction/account level for an Accounting Summary, and then summing to an Account level for booking to the General Ledger. There are approximately 40,000 transaction records a month that are processed by this database.

Joint Underwriting Review ACCESS Database

Developed ACCESS database to store audit information produce an Audit Form using WORD.

Request Form ACCESS Database

• Developed ACCESS database to track and manage Requests for Policy information. Developed
• an import process read email from a generic mailbox. All email WORD attachments are opened
• to check for the Request WORD form. The form information is saved in the database and a control number is assigned and stored on the Request form. All attachments saved to a shared drive. Database allows visibility for reading / printing of all attachments. Requests are put into a queue and staff requests next available task. Emails can have 0 to many Request forms, Request forms can generate 1 to many tasks, a task can be assigned to 1 to many Units/Sub Units.

Confidential

F119 Engine Repair Conference Slide Automation ACCESS Database

• Developed process to generate slides for bi-annual conference to brief Customer on status of 350 repairs.
• This process uses Microsoft Automation to interface with WORD and EXCEL to generate the presentations.
• Five databases are accessed to mine data two ORACLE and three ACCESS databases.
• The run for the Oct-09 Conference resulted in 1500 slide pages that ran in under two hours.
• Created three methods for generating slides: a. for a single repair, b. all repairs for a Presenter c. all repairs
• Although a cost versus benefit analysis was not done, it was mentioned many times that this process saves many hours of
• manually creating / updating slides.

MATRICS Reporting ACCESS Database

• Redesigned report selection form. Added data filters to limit the data included in reports.
• Rewrote many reports and SQL statements.
• Added functionality to check application version, collect Users logon information, etc.
• The database backend is Oracle. Supported Oracle connection issues.

Employee Proficiency ACCESS Database

Developed new database to maintain and report on employee proficiencies to determine a team's health.

Track Milestone Date Changes ACCESS Database

Developed database to capture and report on date changes. Management uses reporting to help when dates change and may cause slippage for task completion.

Other Functions

• 1. Automate SQL execution based on EXCEL input file. This effort supported data cleansing for ACCESS to ORACLE database conversion project.
• 2. Development support for Additional Databases
• 3. Developed automated process to produce EXCEL charts to review task turnaround time.

Confidential

Workloading ACCESS Database

Rewrote application to eliminate redundant coding, queries and reports. Reduced several VBA programs from thirty pages of code to six pages of code. Rewrote reports and reduced the number of reports from twenty to five.

Skills Inventory ACCESS Database

• Developed programs to normalize all data. Developed form with several sub-forms to allow updating of employee skills by skill type. Since database was normalized, needed to rewrite reporting objects.
• The normalization of data reduced the number of reports and allowed flexibility to add new skill types and skills.

Schedule A ACCESS Database

• Implemented two new Mainframe batch jobs to extract policy cash values from five Mainframe Administrative systems.
• These two batch jobs include steps to FTP data files between the Mainframe environment and the network server for the database.
• Wrote a Rumba screen scraping process to extract policy cash values from the Mainframe Product Engine Administrative system. Developed a process to Auto Install the latest ACCESS client front-end. This eliminated the need to manually install the latest client version on twelve to fifteen computers.

Confidential

Process Certification ACCESS Database

• Brought in to take over development and deployment of the Process Certification Database. Database mission was to provide a means for twenty Pratt Whitney locations to enter their progress on the Process Certification task.
• This database is an ACCESS / Visual Basic application that utilizes treeview and listview controls, similar functions to Windows Explorer, to manage data.
• For the first version deployed, added two ACCESS reports, rewrote backend database link logic, drafted training documentation, and drafted installation documentation.
• For the second version deployed, developed forms and modules to support reporting, enhanced version 1.1 logic to support functionality for data changes and deletions, and logic for drag / drop functionality.
• Also built logic to combine data from all twenty locations and produce reports.