We provide IT Staff Augmentation Services!

Business Systems Analystresume

Seattle, WA

SUMMARY

  • Thirteen plus years of IT experience with the ability to work on teams and independently
  • Experience in business analysis, system analysis, design, and development of business applications
  • Experienced gathering Business Requirements, Functional Specifications, Technical Specifications, writing Use Cases, process flows, producing ad hoc reports
  • Experience running JAR/JAD sessions, and facilitating discussions between business and technology teams
  • Extensive experience in Lotus Notes and Domino application development
  • Extensive experience with LotusScript (a dialect of the BASIC language), and Lotus Formula language (a scripting language)
  • Experience with Java, JavaScript, HTML,VBA. Familiarity with SQL.

DETAILED EXPERIENCE

December 2005 to December 2009 Business Systems Analyst
Confidential, Seattle, WA

Gathered and documented business requirements. Decomposed requirements into functional specifications. Ran JAR / JAD sessions and facilitated discussions between business and technology teams. Resolved non-feasible requirements and negotiated priorities. Functioned as liaison between business and technology teams. Documented both written and visual to-be and as-is use cases. Documented business process models. Tracked changes to requirements and functionality to final project implementation. Produced Visio documents. Produced data mapping documents. Knowledgeable of SDLC standards. Helped produce deliverables, activities lists, gap analysis.

Environment: Windows XP, MS Word, MS Excel, Visio, Toad, SQL

October 2005 to November 2005 Developer/Analyst
Confidential, Tukwila, WA (Contractor)
Designed enhancements and workflows for a Market Prominence system. Designed MS Excel Addins in Visual Basic. Developed complex reports using Crystal Reports. Developed user friendly web-based reports. VBA programming, SQL statement construction, MS Excel, MS Access. Strong communication skills.

Environment: Windows XP, Oracle 8x, PL/SQL, SQL Plus, Market Prominence, Visual Basic, Crystal Reports, MS Excel.

February 2005 to September 2005 Business/Requirements Analyst
Confidential, Seattle, WA (Contractor)

Gathered and documented business requirements and functional requirements. Interviewed and worked closely with area risk managers and business users to determine business and system needs. Documented business process flows and diagrams using Visio. Documented use cases, business rules, user interfaces, and application architecture. Developed interim software solutions and prototypes using MS Access, MS Excel, VBA. Data quality improvement and reconciliation efforts. Merged and compiled large volumes of data and generated reports. Strong communication skills. Ability to communicate and relate with technical and non-technical users. Functioned as a liason between the business owners and the development team.

Environment: Windows XP, MS Access, MS Query, MS Word, MS Excel, Visio.

August 2004 to November 2004 -- Report Writer
Confidential, Bellevue, WA (1099 Contractor)

Provided data analysis and reporting in a data warehouse environment. Used advanced SQL queries and published reports in Excel format. Analyzed report fields and traced them through the system to their table origins using data modeling techniques.

Environment: Windows 2000, SQL Server 2000, DTS, MS Excel, Prophet 21.

January 2003 to February 2005
Confidential, Bellevue, WA (Self Employed)

Virus, Trojan Horse, Internet Worm removal, prevention and analysis. Spyware and Adware removal and prevention. Firewall installation and configuration. Software installation and troubleshooting. Custom software application development.

November 2000 to January 2002 -- Lotus Notes Developer/Analyst
Confidential, Redmond, WA

Designed LotusScript agents that integrated Lotus Notes and Oracle. Gathered and documented business requirements. Designed business process flows and diagrams using Visio. Created use cases using UML. Assisted in designing tables and data modeling. Documented software functionality of the final release of the system. Tested and debugged agents described above. Created LotusScript agents to integrate Lotus Notes data and Excel spreadsheets. Created Java applets.

Environment: Windows 98, Oracle, SQL Plus, Lotus Notes (r.5.0.3), Visio, Java.

October 2000 -- Lotus Notes Developer/Analyst
Confidential, San Antonio, TX (Contractor)

Provided design and development of ODBC LotusScript agents that integrated Lotus Notes databases and Excel spreadsheets. Provided JavaScript and Notes-Domino support.

Environment: Windows 98, Lotus Notes (r.5.0.3), Domino (r.5.0) MS Excel.

June 2000 to September 2000 -- Lotus Notes Developer/Analyst
Confidential, Albuquerque, NM (Contractor)

Designed LotusScript agents that integrated Lotus Notes databases and a relational Timberline system. Performed analysis and design for a variety of modifications to existing system components. Utilized data modeling techniques.

Environment: Windows 98, Lotus Notes (r.4.6x and 5.0.1), Timberline Database.

Hire Now