We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

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
  • Imported data to create tables
  • Data analysis and cleanup
  • Testing and documenting of application
  • Development of applications for fixed income
  • 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

Hire Now