SUMMARY

• He has over 20 years of business analysis and computer programming experience.
• He has experience with technical as well as functional specifications and is very strong with MS Access, Excel, Visio and all MS Office applications (with MS SQL, Oracle, and other database back ends).
• On his last project, he partnered with clients to gather all requirements to formulate business specifications and translate into application functionality.
• He communicated the business directives, goals, and needs to the technical team and managed user expectations and client satisfaction.
• Creative, highly organized candidate; expert in design, development, and delivery of cost - effective, high-performance technology solutions.
• Extensive qualifications in all facets of project lifecycle development. Proven ability to integrate out-of-the-box thinking and problem-solving analysis to improve processes, systems and methodologies.
• Well versed in extracting application essentials from business units and communicating to programming team.

TECHNICAL SKILLS

• MS Access
• MS Project
• MS Visio
• MS FrontPage
• PowerBuilder
• Visual Basics
• SQL databases (Sybase
• MS SQL Server
• Oracle)
• PeopleSoft
• PL/SQL for Oracle
• Oracle
• TOAD
• Tableau
• TotalAccess
• Adobe Acrobat X Pro various other database design tools spreadsheets word processors

PROFESSIONAL EXPERIENCE

Confidential

Vice President - Product Manager

Responsibilities:

• Support the following departments: Wealth Management, Small Business/Consumer Loans, Trade, Foreign Exchange (Product and Sales), Credit Card, and Digital Channels. Using Microsoft Office Suite products (primarily MS Access, Excel, Word and PowerPoint), MS SQL, Oracle, TOAD and other tools to develop and maintain reporting applications. Duties include:
• Ad hoc reporting
• Work on multiple projects simultaneously
• Monthly dashboards
• Intranet site maintenance
• Manage Product Department Budget
• Regular maintenance
• Regular reporting
• Invoice/expense research
• Forecasting one, three, and five year budgets
• Marketing Campaign analysis/reporting
• Built various reporting applications
• Collect, analyze, and transmit business requirements for each project, then translate into functional specifications and detailed test plans
• Produce trend analysis reports
• Managed Product Department Business Continuity Plan (disaster planning)
• Ranking key business areas
• Identifying critical technology functions
• Performing business impact analysis
• Implementing the plan
• Testing the plan off-site abilities
• Coordinate semi-annual tragedy exercises
• Managed Annual Fee Review for Foreign Exchange and Trade departments
• Coordinate fee review process with International Departments (Operations, Product, and Sales).
• Gather and analyzed transaction volume and profit for Foreign Exchange and Trade fees considered for adjustment.
• Coordinate and chair working meeting of committees
• Make all fee schedule updates

Confidential

Systems Analyst

Responsibilities:

• Perform business/data analysis, technical specification documentation, report development/delivery and support of all internal and external projects, including metrics management.
• Collect, understand and transmit the business requirements for the project, and translate these into functional specifications and detailed test plans.
• Partner with clients to gather all requirements to formulate business specifications and translate into application functionality.
• Document workflows and results of business analysis and obtain client sign-off.
• Assist the technical team in translating application functionality into application architecture and the production of a System Functionality document.
• Communicate the business directives, goals, and needs to the technical team; manage user expectations and client satisfaction.
• Design and execute test plans to ensure that business requirements and functional specifications are tested and fulfilled.
• Understand long-term business objectives and suggesting technical strategies to meet those objectives; introducing innovation to business processes through technology.
• Assist the client in developing content or other materials; recommending enhancements and identifying new business requirements.
• Apply knowledge of system capacity to determine feasibility of projects.
• Maintain current knowledge of new hardware and software and recommend upgrading to maintain efficient operation.

Confidential

Information Technology Consultant

Responsibilities:

• Built MS Access applications to solve business reporting issues. Applications included: tables, queries, forms, reports, and functions (modules), and interfacing with SQL Server and Excel.
• MS Access database conversion from MS Access Version 97 to Version 2000 and/or Version 2002.
• MS Access database migration from MS Access Version 97 to Version 2000 and/or Version 2002 to MS SQL Server 2000.
• Wrote stored procedure and views in MS SQL Server.
• Worked on multiple projects simultaneously.
• Performed all tasks related to System Development Life Cycle and Database Life Cycle.

Confidential

Information Technology Consultant

Responsibilities:

• Performed data maintenance (inserting, updating, and deleting data) on Confidential 's Web Enrollment (online application-Oracle 9i back-end). Used PL/SQL for Oracle to perform maintenance tasks, script writing and triggering.
• Built applications in MS Access and MS Excel to perform reconciliations on data from various opposing systems. This information was used to correct errant information. Performed about 40 of these reconciliations. Trained coworker to build and maintain reconciliation applications in MS Access and MS Excel.

Confidential

Senior Business Analyst

Responsibilities:

• Developed business applications using MS Access and Excel. Applications included creation of forms, tables, queries, macros, modules, functions, application level security and automated distribution of emails and application version updates.
• As a Senior Business Analyst consulted with clients to identify business needs and create development specifications.
• Created lists of standard questions to pose to business users regarding their processes and perceived needs.
• Performed all tasks related to Systems Development Lifecycle and Database Lifecycle. Developed user specifications and translated them into programming specifications.
• Worked as liaison between development groups and user groups, making sure business needs were fulfilled.
• Translated user specs into technical specs for programmers to code from to include security access levels, data storage, and archive abilities.
• Created reporting specs.
• Developed detailed test scripts including security testing.
• Coordinated user testing to include test ids and creation of QA environments.
• Built application to maintain issue logs.
• Worked on multiple projects simultaneously.
• Created functions to perform interest calculations and projections for securities using Visual Basics, MS Access, and MS Excel.
• Developed and executed application test plans and documented results.
• Tested new software for potential use in reporting needs.
• Conducted client training sessions.
• Converted all MS Access applications to MS Access 2002/2003.
• Participated in enterprise application development.

Confidential, Los Angeles, CA

Applications Developer

Responsibilities:

• PowerBuilder, with SQL Server back-end.
• Supported large scale, on-line business applications written in PowerBuilder. Created applications in PowerBuilder.
• Developed and maintained in-house and client site applications using PowerBuilder and MS Access with SQL Server and Sybase back-ends.
• Supported Day-end transaction processing application.
• Wrote stored procedures and triggers in MS SQL Server and Sybase.
• Performed database migration from Sybase to SQL Server.