We provide IT Staff Augmentation Services!

Business Analyst Resume

Bloomington, MN

ANALYST / DEVELOPER
Extensive analysis, requirements gathering, design, development, testing, and reporting experience in business and technical environments. Effectively use my technology background to communicate customer requirements to developers and assist in the development of applications when necessary. Good problem solving skills, track record of excellent customer relationships and ability to help customers define what is actually needed. Experience working with all managerial levels in an organization.

COMPUTER SKILLS

  • Databases - Oracle, DB2, MS Access, SQL Server, extensive query experience
  • Reporting Tools - COGNOS 7.4 (Transformer, PowerPlay, Impromptu), MS Access, Crystal
  • Development Tools - MS Access ,VBA, PL/SQL, SQL Server
  • Excel, PowerPoint - used extensively in conjunction with MS Access
  • Extensive mainframe experience. TSO, JCL, VSAM, Platinum, Panvalet, Fileaid, Cobol, EZTrieve
  • Proficient with Word, Excel, Outlook
  • SQL Server DBA MCTS Certification

EMPLOYMENT
Confidential, West Lakeville, MN 55044 2009
Business Analyst II

Software - Cognos 7.4 (Impromptu, Transformer, PowerPlay, report writer), Crystal Reports, SQLServer 2003, Access.

  • Developed SQL Server infrastructure, Crystal reports, Cognos Impromptu reports and PowerPlay cubes to measure how business is performing and identify future markets.
  • Work with customers to define informational needs, define benefit of requests and help set priorities.
  • Analysis of existing data to define demographics and industry trends.

Confidential, East Brunswick, NJ 2007 - 2008
Business Analyst for Best Buy and Supervalu

Software - Access, Access Reports, VBA, Cognos (administrator, Impromptu, Transformer, PowerPlay), Excel, PowerPoint. Gathering and documenting business requirements.

  • Developed project tracking application (Access, VBA, Excel and PowerPoint) that measured progress of project, time charged to project by each employee, actual task deadlines vs. planned completion date, defects and reports. Created KPI defect reports and put into PowerPoint Presentation identifying number of defects, criticality of defects and rate defects were being fixed vs. defects found.
  • Liaison between business and development teams for developing reports.
  • Worked with other departments in coordinating efforts to complete projects.
  • Requirements, analysis, design and Development of SQL Server database and Access AP application to track orders from participating vendors and create chargeback to vendors for the purchases.
  • Received stock option award for analysis of new product development issues and problem resolution ideas.
  • Analysis, design, development, DBA, testing, implementation of specialized Access applications for small groups of customers.
  • Held workshops to train customers on software usage. Held one on one training sessions for customers that did not have time to attend workshops.

Confidential, Rd. Eden Prairie, MN 55344 1997 - 2006
Senior Systems Analyst - SDLC, Documenting systems and process flows

Software - TSO, JCL, COBOL Easytrieve, Syncsort, VSAM, IDCAMS, DB2, Oracle, SQLServer, Platinum, Panvalet, Endevor, Xpeditor, Spufi, CICS, FileAid, Access, Cognos, PL/Sql, Unix, Access, VBA, Cognos (Cognos (administrator, Impromptu, Transformer, PowerPlay)

  • Special Project Lead for multi platform application where customer was contesting charges. Application processed, consolidated and compared billing information from Supervalu, sales information from stores and charges to customer (information was provided by customer).
  • Letter of commendation received for requirements gathering, analysis, documentation, design and development of application that allowed customers to identify problem trends with products they were selling. Business used results of reports to implement changes resulting in over one million dollars a year in savings.
  • Requirements gathering, analysis, design, partial development, testing and implementation of COBOL II / DB2 / Oracle / Cognos applications for Customer Service Department.
  • Lead for Y2K Customer Service system update.
  • Designed enhancement and bug fixes and assigned to programmers.
  • Mentored new people in department.
  • Analysis, design, development, DBA, testing, implementation of specialized Access applications for small groups of customers.
  • Helped convert purchased business to Supervalu Systems.

Confidential, Minneapolis, MN 55402 1994 - 1997
Senior Programmer Analyst

Software - COBOL II, DB2, CICS, VSAM, JCL, Fileaid, Easytrieve, Syncsort, VSAM, IDCAMS, DB2

  • Designed and lead development for rewrite of open enrollment system
  • Lead for benefits, payroll, HR and AP systems (Packaged Software)
  • Designed and wrote Exit routines (The software allowed the creation of external COBOL routines that could intercept data, perform processes on it and pass it back into package.)
  • Analyzed, designed, estimated manpower requirements and made assignments for current projects.

Confidential, Minneapolis, MN
Programmer Analyst 1993 - 1994

  • Installed and supported PEP+ system
  • Worked on team that developed Customer inquiry system allowing customers to link up with a Foxpro system that interfaced with our mainframe CICS system to do check inquiries.

EDUCATION

MBA MIS
Bachelors Degree in Business Administration
AA - Data Processing

Hire Now