**** ********** ****** ******** ***, New York ****0

518-***-****

email: ac3fym@r.postjobfree.com

James M. Janczykowski

Applications Programmer/Business Analyst with over 10 years experience in many levels of technology. Excellent research and troubleshooting abilities, quickly identifies areas in need of repair on 24/7 basis. Strength in batch testing, conversion of unlike systems and application integration. Team participant with effective communication skills in working with end users.

Six Sigma Certified

Technical Expertise

SSP JAVA – 5 yrs. SQL – 5 yrs SDLC C++ - 6 yrs.

HTML – 5 yrs. Merlin Oracle – 5 yrs. CMM Visual Basic – 5 yrs.

PowerBuilder – 5 yrs. PL/SQL – 5 yrs JIRA Ticketing System

SalesForce Confluence/SPS

EDISIM tool set - create and edit and debug various EDI documents based on requirements

SCRUM application - Agile Chat room ( track progress of projects etc. )

Professional Experience

Commerce Technologies Inc. 2008

02/2008 – 12/2016

Business Analyst - requirements gathering, release management.

Documentation - creating documents based on SOWs to be used by various applications.

SME,QA Pilot test new software products/enhancements to existing applications prior to their production release, SQL Server upgrade support . Oversee software upgrades into production - run/create test scripts and report results to upper management prior to giving go/nogo for production release.

Internal Tool design - design of new tools and enhancements to existing tool set

COMMs support and UPGRADES - AS2 VL Trader, VAN, sFTP

Product modeling - decision design matrix to develop business requirements matrix Develop new processes or enhancement existing processes to improve performance for existing applications.

\

Vendor Implementation Specialist

File Analysis – EDI (various documents based on requirements), FTP, XML, SQL

Tools - Rational Clear Quest, XML SPY, EDISIM Toolset, SQL Server

Various small company contracts 2006-2007

Business Analyst 2006-2007

Functioned as a Business Analyst gathering requirements for enhancements to existing systems.

Completed Web based courses in XML (Extended Markup Language) and CSS (Cascaded Style Sheets).

UML Data Modeling theory

Bank of America, (formerly Fleet Bank Boston), Albany, NY 1994-2005

Applications Programmer Analyst 2004-2005

Functioned as Subject Matter Expert for banking applications. 12 yrs.

■ Programmed in Merlin Applications; applied SSP (Standard Software Process) 3.0 to all projects.

■ SDLC (Software Development Life Cycle) oriented, CMM (Capability Maturity Model) process oriented.

■ Implemented Business Requirements documents, transformed into High Level Design document, then to Low

Level Design document. 12 yrs.

Application Programmer/Analyst 1994-2004

Responsible for prototype design, unit testing, integration testing. Performed in a highly energetic, successful team environment. 12 yrs.

Worked in various programming environments: VB.NET, C++, Java, Oracle, PowerBuilder, Merlin, TSO, ChangeMan, Client/Server, etc. 5+ yrs.

Distributed Data Environment SQL Server – 5 yrs.

Provided application analysis for projects involving SQL Server on a distributed environment. Utilized the following tools to determine where changes would be required to the system:

Remote Procedure Calls, Stored Procedures, Distributed Transaction Coordinator, Linked Servers, ODBC (Open DataBase Connectivity), JDBC (Java DataBase Connectivity)

Determined and coordinated changes required to existing stored procedures or creation of new stored procedures where required on servers distributed across the network. Changes would provide the user with the ability to query and update multiple databases tied to different servers over the network.

Provided Platform level analysis (MS Visual Basic Studio) and coordinated code changes (existing queries or new functionality, SQL calls to stored procedures – SELECT, UPDATE/COMMIT/ROLLBACK) which would be required to update databases tied to servers over the network

Coordinated with development group that all Business Rules/Logic were to reside at the server level.

Bank of America Distributed System

Servers held all Business Rules/Logic utilizing Host PCDs (Process Control Data).

All bank specific data and messages were stored in databases at the server level and updatable utilizing PCDs. All changes made would be reflected across the environment without any changes being required at the client/application level.

Security (Database connectivity), userid, and password were dictated by values in INI file.

The master Repository Server updated all environment servers

Utilized tools to provide the capability to login to remote servers to examine/change files if necessary.

Production Support Experience

Perigrine and FixIt database environments.

Users report problems and logs them to database and notify analyst that a problem has been reported.

Analyst recreates/reviews problem and determines (reviewing trace files and log files) as to which application (database, mainframe app, front end app) is currently causing the problem.

Provides information to application as to what code module is causing the problem.

Help determine the best fix scenario based on the severity of the problem (if the problem was the front end a software release would be required so the alternative would be to look at a temporary host application fix to the problem). In the interim, do analysis to see if there is a temporary workaround for the user.

Test fix in pseudo production environment and also regression test to ensure that fix did not create other problems.

Have users test fix and if approved, close the problem in the database.

WEB Design – 2 yrs.

Utilized VB.NET to design WEB pages (HTML, scripting, Active Server Pages).

Provided ability to access Data Bases from multiple servers and provide filtered data for users if required.

Implemented ATM Branch Locator and Commercial Loan Application as a JAVA based web application.

Designed JAVA executables to provide pattern rules logic for not allowing P.O. boxes to be entered as an address for non-resident aliens (Patriots Act Regulation).

■ Worked with lines of business to implement projects through Cross-Sell/Merlin, enhancing customer service and

satisfaction. 12 yrs.

■ Ability to take requirements document and transform it into a technical design specification, to be implemented

by any team member. 12 yrs.

Experienced Analyst with proven skills in all aspects of software development (SDLC, SSP, CMM, SQA, JAD sessions), including business process analysis, requirements development (worked extensively with lines of business to ensure that requirements were feasible and made recommendations as to what was feasible in respect to budget – High level design document would be provided giving an overview of all systems which would require changes), modeling (provided screen designs with appropriate fields and controls for collecting and validating data prior to data store update – would conduct user walk through prior to getting user signoff), data design ( provided Pseudo code for front end development team specifying what modules/screens would need to be created if new or where changes would be required to existing modules/screens – Low level design document would be provided showing all changes to all systems along with all interfaces between systems), testing (testing phases included unit testing (independent system testing), integrated testing(testing with other systems effected), user acceptance testing (testing by users with problems recorded to fixit database), provided test scripts designating required input and desired output from user front end and coordinated data manipulation when required, and QA ( SQAs where required during each phase of the SDLC with problems recorded to a traceability matrix). Have used UML (in house version – provided data flow diagrams between all systems effected by new projects or project enhancements). etc.

■ Performed accurate, concise estimates for project delivery. 12 yrs.

■ Key accomplishments utilizing the new Cross Sell Windows environment included: streamlining of New Account

Opening process, Implementing Asset Management Account process, enhancing Customer Profile Screen,

Introduction of concept of Package Products. Strong background in Deposits and Combined Statements systems. 12 yrs.

Familiar with all aspects of the Banking Industry in respect to regulations and compliance (Team member for implementing the U.S. Patriots Act regulation). Changed code to house all Business Rules at the Server Level for the purpose of security and code compatibility (allowed changes to be made on Host databases and immediately and update server programs once Change Management was approved). 12 yrs.

■ Understanding of how Cross/PPS interact with backside interfaces when specific transaction is performed. 12 yrs.

■ Created program enhancements to LoanCalc using C++. 6 yrs.

■ Member, FOCUS project (circa 1994) where Cross Sell was rewritten from screen scraping application to data

stream application using PPS as middleware. 5 yrs.

■ Implemented pilot programs to branches for pilot testing, provided support 24/7. Provided maintenance support once software was implemented into production. 12 yrs.

■ Functioned as support for users through customer acceptance. 12 yrs.

■ Functioned as Software Release Coordinator – Worked with lines of business in coordinating application batches

in order to complete test cycle. 12 yrs.

■ Verified according to test scripts that batches were correct–responsible for all problem logs issued–conducted

research/assigned to appropriate applications. 12 yrs.

■ Coordinated changes to Quality Assurance Group to ensure system changes were incorporated into automated test system. 12 yrs.

■ Ensured that new functionality was documented in training materials so that users would be aware of changes to existing systems and how to utilize the new functionality. 12 yrs.

■ Successful Moments recognition – 2000, 2001.

James M. Janczykowski Page 2

Northern Industrial Services, Albany, NY 1992-1993

Programmer/Analyst-OOP Project Design

■ Implemented data collection system using C++, gathered electrical data from instrumentation, loaded into

Microsoft Access Database. 2 yrs.

IBM, East Fishkill, NY 1982-1992

Electronic Design Specialist/Programmer – Research

■ Designed, built test instrumentation used to measure properties of integrated circuits. 10 yrs.

■ Programmed IEEE instrumentation in BASIC to control instrumentation, gathered data for analysis. 10 yrs.

■ Applied Six Sigma concepts to projects. 10 yrs.

■ Chosen to be part of selected task forces to address site critical problems. 10 yrs.

Education

Marist College, Poughkeepsie, NY

B.S., Computer Science

Schenectady Community College, Schenectady, NY

A.A.S., Electronic Technology

Contact this candidate