We provide IT Staff Augmentation Services!

Business Analyst Resume

Columbus, OhiO

SUMMARY:

  • Accomplished technical professional with over 20 - years practical experience in Application Development, Office Automation and Automated Ad-Hoc Reporting.
  • Outstanding customer service skills known for successfully providing custom solutions to overcome business obstacles.
  • Outstanding interpersonal and communication talents with a rare ability to convey highly complex concepts in understandable terms
  • Articulate communicator with exceptional interpersonal skills and superb record of achieving set goals on schedule and within budget.
  • Experienced in all phases of development life cycle, from user requirement interviews, through project implementation and support.
  • Self motivated, enthusiastic and committed to professional excellence.

AREAS OF EXPERTISE:

  • Visual Studio 2010,2005,2003
  • Java Script
  • Crystal Reports XI
  • Microsoft SQL
  • HP Quality Center
  • Service Now
  • Microsoft Office Suite
  • Analysis
  • Structured/Business Reporting
  • AD - HOC Reporting
  • Requirements Management
  • Application Distribution
  • Troubleshooting

CAREER CHRONICLE:

Business Analyst

Confidential, COLUMBUS, OHIO

Responsibilities:

  • Developed the QC annual system purge that removes defects, tests, requirements and release information from the system based on date and usage.
  • Created the Power User application that allows users to perform certain administration tasks without granting them full admin rights to Quality Center.
  • Rewrote and expanded the Butler application that imports data from other systems on a daily basis and provides monthly data dumps to various departments.
  • Created multiple catalog request items and workflows in Service Now.
  • Created scheduled data import jobs, transform maps and various business rules in Service Now
Business Analyst

Confidential, COLUMBUS, OHIO

Responsibilities:

  • Created a random race draw function utilizing the random number generator from Random.org
  • Developed internal applications to streamline application and SQL Stored Procedure testing and approval.
Business Analyst

Confidential, COLUMBUS, OHIO

Responsibilities:

  • My responsibilities included the rewrite of the daily automated batch processes.
  • Converted linked queries in Access databases into MS SQL Server Stored Procedures reducing the runtime from hours to minutes.
Business Analyst

Confidential, COLUMBUS, OHIO

Responsibilities:

  • Creation and/or redesign of over 40 Crystal Reports and their corresponding MS SQL Server stored procedures.
  • A number of the reports include dynamic layouts driven by the supplied data.
  • Created customized fonts to ensure all of the information would fit on the reports.
  • Developed the business and data layer routines to run and export the reportst from the eTrack web application.

Confidential

Business Analyst

Responsibilities:

  • Redesigned or in some cases rewrote current reports for efficiency.
  • Created a custom application with Visual Basic 6 to allow users to view/print/export the reports as a short term solution.
  • Built a web site using Crystal Enterprise, ASP and MS SQL to allow our users unrestricted access to run and view the reports.
  • Added a page to allow the users to add or delete projects from the list in real time
  • Built in the functionality to dynamically update parameter pick lists and certain formulas in the reports based on the current information in the reporting database.
  • This eliminated the need to modify the reports when this information would change.
  • Designed and built a database and web site for our project status reports that were in a MS Excel format. This made it easier for the project managers to make their weekly updates. Having the status report information in a database versus separate Excel workbooks helped streamline project reporting to upper management.

Business Analyst

Confidential

Responsibilities:

  • Responsibilities include the automation and production of daily performance reports along with the development and production of weekly and monthly business and systems performance scorecards.
  • I also created AD-HOC reports.
  • The primary tools in use as follows, Visual Basic 6.0, Crystal Reports 9, Access 2000, FrontPage 2000, Microsoft SQL Server and Oracle.
  • Developed a web application to allow our various Score Card data sources input their weekly and monthly data.
  • This allowed us to import the data directly into the Score Card increasing our efficiency and accuracy.
  • This was built using ASP with a MS SQL database.
  • Automation of Daily Service Level Report.
  • Created an application to run existing scripts on Attachmate Extra and store information in an Access Database.
  • Recreated existing report in Crystal Reports 9.
  • The application will now run the scripts, produce the report, export to and HTML format and upload to our department web site.
  • Automation of the original report generation process reduced the cycle time from 4 hours to 20 minutes.
  • Monthly and Weekly Business and Systems Performance Scorecard development; Streamlined processes to aid in the production of the weekly and monthly score cards resulting in a much quicker turnaround time with fewer chances for errors. Worked on a data repository for scorecard related information that provided from other sources.

Hire Now