Objective: Position as Financial Business Analyst

Summary:

• 20 years' experience as an analyst in desktop and distributed systems applications
• Proven experience writing stored procedures and triggers in SQL
• Adept at analyzing business requirements and translating them into specifications for solutions
• Composed user, administrative and technical manuals which detail business and technical requirements
• Developed reporting applications in Access and Excel utilizing security analytics, performance returns
• Developed applications for Treasury / Market Risk Managers
• Expertise in software life-cycle methodology

Technical Skills:

• Languages: Visual Basic, Visual Basic for Applications, VB.net
• Windows Applications: Access, Excel, Word, Crystal Reports, Visio, Power Point
• Databases: SQL Server, Oracle, Sybase,
• Internet: XML, HTML, Active Server Pages, ADO, VBScript, ASP.net, SOAP

Accomplishments:

• Developed search forms and data cleanup forms which increased the integrity and availability of data
• Designed a tracking system for deliverables with reports and forms to correlate target dates with actual dates which organized the delivery system
• a couple of hours
• Created and developed automated systems reduced processing time from a few weeks to
• Developed call messaging system with Visual Basic including Com Objects and SQL Server including T-SQL .
• Developed commercial Excel product based on risk calculations
• Development of Excel And Access applications for Basel reporting

Experience:

Confidential

Business Analyst/Programmer/Analyst

• Development of Excel reports to examine the correlations between salary and demographic statistics for 13,000 teaching assistants in the University Of California System. .
• Gathered and documented business requirements to develop reports
• Developed system to draw data from various sources

Confidential

Business Analyst

• Analyzed the characteristics of site users designed code to extract classify the user demographics
• Designed process to store the data in a database

Confidential

Business Analyst/Developer

• Design and development of Access Database to track clients
• Responsible for all project life cycle phases, from specifications and coding through testing, debugging, and documentation
• Designed tables, reports, forms and queries

Confidential

Business Analyst

• Designed Access Database to track customers and products for fine art envelop
• Business
• Designed tables queries and reports to join customers, products, and deliverable dates and forms to produce reports with varying criteria of customers, dates and /or product type
• Database aided in determination of what to produce and in what quantities

Confidential

Report Developer/Quantitative Analyst

• Developed specialized reports for Trading desk and Senior Risk Management on counterparty exposures
• Market data for reports were extracted using Sybase stored procedures and adhoc queries
• Reports were rendered in Excel using VBA Functions and Macros
• Complied with Federal and Basel III regulatory requirements for Risk reporting
• Gathered and documented business requirements from-end users to develop reports

Confidential

Business Analyst/VBA Programmer/Analyst

• Designed and implemented End of the Day report for Traders utilizing market data
• Designed and implemented process utilizing Access2007database to store data from three data sources
• Designed process including VBA code for the treasury department to reconcile data from different sources
• Designed and implemented process with VBA code to create for liquidity reporting for 15 countries
• Analyzed business requirements, wrote business requirement documents
• Created functional requirements and specification documentations and constructed flow charts of the processes
• Created project plans, and automated the processes to manage project plans and project activities
• Analyzed financial data
• Identified opportunities to optimize business processes, and automate the processes
• Performed testing
• Perform daily business and application support
• Analyzed and planned business projects
• Created reports by using MS Excels data analysis program, solver function, statistical and financial functions

Confidential

Business Analyst

• Analyzed and planned projects to for convert 5 Access2003 databases toAccess2007 frontend with SQL Server backend
• Full Life cycle development from Requirements gathering, application design, implementation, testing/quality assurance, and end-user training
• Development of VBA code
• Creation of DSN's

Confidential

Business Analyst

• Analyzed utilization data for the Bay System Rapid Transit System
• Planned and Executed reports in Access Excel designed to support budget debates
• Full Life cycle development from Requirements gathering, application design, implementation, testing/quality assurance, and end-user training. .
• Developed and maintenance of system with VBA macros to provide reports involving analysis of data
• Development of Industry Employment Projection application in Office 2007

Confidential

Business Analyst

• Designed and developed MS Access database application to track deliverables for the Supply Chain Management group
• Responsible for all project life cycle phases, from specifications and coding through testing, debugging, and documentation
• Designed tables to join managers, products, deliverable dates and forms to produce reports with varying criteria of managers, dates and /or product type
• Created VBA code to update data from Excel worksheets and to produce reports with varying criteria of managers, dates and /or product type
• Wrote user and administrative manual with business requirements

Confidential

Business Analyst/Software Engineer

• Responsible for 2 MS Access databases used by the PFG Fully Supported Group in the ratings process.
• Designed and developed standardized and ad-hoc reports, VBA code Sybase stored procedures
• Created a system troubleshoot forms VBA code
• Created system to update data through a batch process
• Analyzed data to develop system and procedures for clean-up and validation
• Designed and developed in Access, VBA and VB an automated system to generate e-mails to external contacts , and in Excel a commercial product to estimate ratings based on risk criteria
• Wrote business requirements and specifications

Confidential

Business Analyst Access Developer

• Analyzed Capital Management data to design various Access applications data included equity, fixed income, and credit derivative products
• Designed reports, queries, forms, tables, VBA modules and links to other Access databases
• Imported data to create tables
• Used data analysis to design system and procedures for data cleanup
• Planned system and procedures for testing and documentation
• Use of market data such as performance returns and risk

Confidential

Business Analyst/Programmer

• Designed and Implemented Scorecard application in MSAccess2002 for Private Banking Team Leaders
• Conversion of Access Reporting system to SQL Server for Equities
• Designed SQL Server Database and tables, reports, queries, forms and VBA modules
• Creation of Stored procedures, Triggers and DTS Packages
• Development of applications for fixed income
• Testing and documenting of application
• Data analysis and cleanup
• Imported data to create tables
• Writing of business requirements

Confidential

Business Analyst/Programmer

• Created and maintained MS Access database for reports with a search form for Credit Derivative trades
• Designed and Implemented Production Tracking Reports for Credit Derivative trades utilizing VB.Net, MS Access, VBA
• Developed special reports for Credit Events utilizing MS Access, VBA, and Excel

Confidential

Team Lead Developer and Business Analyst

• Developed application in MS Access to create automated assessment tool for the intake of clients and
• MS Excel VBA code, formulas, table lookups, calculations to test table design and data
• Full life cycle development including proposals, diagrams, flowcharts, coding and testing
• Wrote stored procedures and triggers in SQL server
• Analyzed and planned business projects