System Analyst Resume Format For Job Application in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

SUMMARY

Support Applications Developer - Database and Report Developer – QA Tester

An accomplished Systems Analyst with extensive experience in the entire software development lifecycle including requirement definition, technical specification, development, testing, implementation and support applications.  Strong background analyzing data, troubleshooting applications, designing and utilizing databases and creating reports. 

Known by pears as persistent, getting the job done, problem solver, customer focused and always willing to lend a helping hand. Able to work well in a team environment and as an independent contributor.  Good communication, interpersonal and team building skills.

COMPUTER EXPERTISE

Windows	C/C++/C#.Net	SQL Server	Rally software	Windows scripting
DOS	VB/VB.Net	Access	Mercury QC/Testing	Link for Windows
Unix	SQL	Oracle	WinRunner	Vscript
MVS	XML	Sybase	Crystal Reports,SSRS	RunWay
JCL	FORTE	IMS / DL/1	SM7	CRS/GDS
VSAM	PL/1	DB2	SVN	Aqua system
TSO/ISPF	COBOL	ADABAS	PVCS

PROFESSIONAL EXPERIENCE

EcoLab Corp.                                                                                                                   St. Paul, MN

SQL Developer                                                                                                          Feb – April 2011 Completed 3 month contract at EcoLab Company.

For Business Analysis team developed sales analysis reports, queries, stored procedures in Microsoft SSRS, SQL Server 2005 environment.

Carlson Wagonlit Travel Inc.                                                                                          Plymouth, MN

Systems Analyst                                                                                               1999 – November 2009

Responsible for supporting high level severity applications being on-call for troubleshooting, upgrading applications to meet changing software environment, new user requirements or acquiring new clients.

·         Supported an order publishing application that built itineraries and sent to security/risk companies. This process extracted data from Aqua system databases, utilized internal SQL Server tables/stored procedures, ran C++ program that published XML messages using Tibco Rendezvous distribution service.

o       Created new SQL server tables and stored procedures to incorporate additional services of hotels/cars/rails/limousines in published air itineraries.

o       Participated in analyzing itinerary requirements of newly acquired Fortune 500 Navigant Travel Company and upgraded an order publishing process to integrate the new clients.

·         Supported CallTrack application that accumulates travelers Emergency Center calls to provide reports for management and financial department.  Process was a package of Server/Client Visual Basic applications utilizing SQL server databases and Crystal Reports.

o   Fixed code to clean bugs.

o   Recreated reports to upgrade to Crystal Reports version 9.

·         Created and supported C language application that sent daily and monthly reports of Travel Agents errors to management using Aqua QC system database, SQL Server stored procedures / Scheduler and Windows script.

·         Created automated QA tests for a travel agent desktop Symphonie application utilizing WinRunner and Mercury QC testing tool.

·           Supported automation process of transaction corrections which extracted data from different reservation systems using Link software and VScript language, Sybase and Access databases.

o       Modified process by creating Access tables, queries, forms, and macros, which decreased user’s manual efforts.

o       Upgraded from using Equant gateway and ACSA software to the Runway gateway and Link software to meet internal requirements.

·        Worked in Agile Scrum framework as an application development team member, utilizing Rally and Mercury QC software. 

o   Resolved defects in the Forte/Oracle applications code.

o   Created demo documents for resolved defects.

o   Created and executed unit tests.

o   Performed new functionality and regression testing for the QA sprint.

o   Documented security Artifacts.

·        Supported multi applications daily process of editing travel transactions. The process extracted data from DB2 DB on Mainframe and Sybase DB, edited general errors and created statistic reports using Cobol, prepared files used by Access and ColdFusion GUI applications for manual editing, collected corrected data using C applications and SQL server database and FTP results to the Unix server for loading corrections to the master database.

o   Modified C applications to utilize Oracle DB instead of Sybase.

o   Extracted general errors reports created on Mainframe and distributed them via email to the team, who recreated the whole process to the Oracle application.

o   Created statistic report for manually corrected errors using SQL Server.

o   Modified processes not covered by the new Oracle application to eliminate Mainframe usage.

West Group, Inc., Keane Consultant                                                                                 Eagan, MN

Programmer Analyst                                                                                                         1997 – 1999

Development project team member for an application support project.

• Developed and modified batch and on-line database applications for a variety of company systems including order fulfillment, finance, marketing / sales, product, customer information which were mainframe based systems using ADABAS, TSO/ISPF and CICS, written in PL/1 and Natural.

o   Developed statements of work, user requirement definitions, and technical design specifications.

o   Coded, tested, implemented and provided post implementation support.

 

Forms of Law, Inc.                                                                                                              Hopkins, MN

Reports Developer                                                                                                           1996 – 1997

Created complex multi-page-printed Crystal Reports for a bankruptcy software application package.

KB Ministry of Education Computer Center                                                             Nalchik, Russia

Programmer/Analyst                                                                                                            1992-1994

Created educational audiovisual programs for elementary age students in a PC environment.

KB State University Computer Center                                                                      Nalchik, Russia

Programmer/Analyst                                                                                                            1990-1992

·         As a member of DBA team designed IMS databases for an automatic design system. 

·         Coded the database software and developed programs that interface with databases, wrote technical documentation, provided consultations with internal IMS users and managed interns.  Project environment included IMS, DL/1, PL/1, FORTRAN batch programs on IBM MVS Mainframe computer.

EDUCATION:

Bachelor of Science in Mathematics. Kabardino-Balkarian State University, Nalchik, Russia

Database Development certificate. Institute of Professional Skill Improvement, Leningrad, Russia

Additional Coursework:

Java J2EE, Project Management Methodology, XML Design & Implementation for Application Developers, C#.net, VB.net, ASP.net, Windows Phone 7.

Download Resume Format