Professional Analyst

Steven P. Pintsak

***** ***** ****** **. *** **** Foothill Ranch, CA. 92610

Home: 949-***-**** Cel: 949-***-**** email: ************@*****.***

PROFILE

Achievement oriented Data Analyst professional with diversified experience in MS Access, relational database management, financial and data reporting, and Visual Basic for Applications (VBA). Excellent multi-tasking and organizational aptitudes and proven ability to creatively influence business partners. Over eleven years of report analysis, creation of VBA applications, training manuals using Power Point and various other applications, and serving as liaison between the IT department and the company.

TECHNICAL SKILL APPLICATION:

The Capital Group – Contractor - Sept 2008 – Dec 2008

Access Developer

- Designed and rebuilt a user friendly database application using MS Access and VBA programming, for data migration project. Database allowed users to import / export data, run reports by selecting their own criteria, and use the application as a data entry program.

- Created and designed reports based on criteria supplied. Presented reports in either excel or through the MS Access report system.

- Created visual Training manual using Power Point to aid in the use of the application.

Cogent Financial 2008

Business Analyst - Contractor

- Designed and developed numerous Access Applications to streamline the manual processes. Through VBA coding, added advanced features and enhanced the application for the user experience. An increase in production from the user was immediately visible.

- Provided financial analysis reports.

Planned Parenthood 2007 – 2008

Report Specialist

- Created and designed reports for various users using MS Access and Excel for presentation.

• Financial Analysis

• Inventory Analysis

• Data Analysis

- Created visual training manual to assist staff with the IT troubleshooting website.

- Provided Remote Desktop support to numerous users, located in eight different clinics across the company, to analyze and repair computer issues.

- Provided in house computer support, installation, and repair.

CalOptima 2007

Sr. Medical Analyst

- Analyzed and gathered numerous data from multiple sources for reporting purposes.

- Enhanced and streamlined processes and appeal of reports.

- Use of Excel and Microsoft Access, ie. VBA programming and relational database querying.

Claims Processing Facility 1995 – 2006

Report Specialist / Technical Media Specialist

- Provided Financial and Data analysis for Management, Plaintiff Bar, and Trustees by way of MS Access table creation and database design.

• Received data through various sources and imported into tables for analysis.

• Graphs, reports, and presentations were created for various departments.

- Designed and developed a MS Access VBA application to increase letter creation for correspondence directed to Law Firms

• Achieved 40 – 50 letters generated per day as opposed to 40-50 per week – an increase of 500%

- Created enhancement of data entry online-process using Microsoft Access (VBA), verifying entered data to reduce the process time by 75%

- Served as liaison between the IT and company during the development of the VB.net application.

• Conducted question and answer meetings with staff to get feedback on the application.

- Designed, developed, and conducted appropriate training sessions to educate company personnel in the use of this new Claims Processing Application and Website.

- Developed and wrote a Claims Processing System training manual to a more organized user-friendly presentation, noticeably increasing user efficiency and claims’ output by each department

- Developed and wrote training manuals to assist the employees with office equipment.

- Created various VBA models using Microsoft Access to shorten various work related processes for staff, cutting user time by 50%

- Provided trouble shooting assistance for various department’s hardware and software

COMPUTER SKILLS:

- Microsoft Office Suite, MS Access VBA Programming, Paint/Design Programs (Serif, Photo Plus 6.0, Adobe Photoshop CS, Corel), Photo & Video Editing Programs, (Ulead Audio/Video, Adobe, Sony Movie Magic, Pinnacle Studio, RoboDemo), Animation Master 2006

EDUCATION:

- Eastern Illinois University – Charleston, IL

- Bachelor of Arts - Communications & Theatre

- Awarded talented Student Scholarship for computer & video

Contact this candidate