Business Analyst Resume
Woodbridge, NJ
SUMMARY:
A Senior IS professional with over 20 years of progressive experience specializing in client - server and internet development, data and process modeling, database design, IE methodology, and software evaluation and selection. Managed projects through all phases of the system development life cycle.
TECHNICAL SKILLS:
Software: PowerBuilder, MS SQL/Server - Sybase 11, Oracle-PL/SQL, Visual Basic - ASP, ErWin, MS Access -VBA, MapInfo, Lotus Notes, MS Internet Server, HTML, JavaScript, MS Office, ClearQuest, PL/I, DB2, RACF, BAL, JCL, TSO/ISPF, CLIST, C
Operating Systems: MS/Windows, MVS/XA/ESA - TSO/ISPF, VM/CMS, UNIX, DOS
PROFESSIONAL EXPERIENCE:
Confidential, Woodbridge, NJ
Consultant
Responsibilities:
- Evaluated, modified and enhanced Terminal Information Management System (TIMS) Suite of applications for the divestiture of HESS Fuel Terminal business.
Environment: MS SQL 2005-2008, PowerBuilder 5.0, 6.0, Visual Studio.
Confidential, New York, NY
Business Analyst
Responsibilities:
- For the247Media analyzed user requirements and created Functional Requirements Documents for suite of the ZAP (Zeus Application Platform) applications.
Environment: Oracle, Netezza, Jira
Confidential, New York, NY
Senior Associate Programmer
Responsibilities:
- Developed USCMS-SC NYS courts management system.
- Designed and created new PowerBuilder.NET objects and Oracle tables, functions and stored procedures.
Environment: PowerBuilder 12.5 (Classic + .NET), Oracle.
Confidential, Oradell, NJ
Consultant
Responsibilities:
- Maintained and developed LCOS and ERD-LCOS systems.
- Designed and created new PowerBuilder objects and Sybase tables, functions and stored procedures. Performed logical and physical Database design and performance evaluations.
Environment: PowerBuilder 9.5, 11.5, Sybase 9, 11, MS SQL.
Confidential, New York, NY
Consultant
Responsibilities:
- Maintained and developed Airwave AdSales / Affiliate Relations system.
- Designed and created new PowerBuilder objects and Sybase tables, functions and stored procedures. Performed logical and physical Database design and performance evaluations.
Environment: PowerBuilder 9, 10.5, 11.5, Sybase, MS SQL.
Confidential, New York, NY
Consultant
Responsibilities:
- Maintained HotelExpert Rapid Response system, created Check In Monitor application, Fidelio Opera Business Events and TCP interfaces. Converted HE, Commentator and Alec Applications to Web interface using Appeon.
- Created new PowerBuilder objects, Designed Sybase SA tables, triggers and functions and stored procedures.
Environment: PowerBuilder 10.5, 11, Sybase, Appeon.
Confidential, Livingston, New Jersey
Consultant
Responsibilities:
- Maintained LQ Letter of Credit system.
- Created new PowerBuilder objects and Oracle, Sybase, MS SQL tables, functions and stored procedures.
Environment: PowerBuilder 6.5, 10.5, Oracle, Sybase, MS SQL.
Confidential, New York, NY
Consultant
Responsibilities:
- Designed and developed CTM (Count The Money) Agency negotiations system.
- Maintained Forecast and Winsales systems. Incorporated new modifications due to business changes and additional reports.
- Created new PowerBuilder objects and Oracle functions and stored procedures.
Environment: PowerBuilder 6.5, 9, 10.5, Oracle 7,8,9, Sybase, MS SQL.
Confidential, New York, NY
Senior Developer
Responsibilities:
- Maintained ECS, CTS and RMS (internal licensing and contract tracking systems). Incorporated new modifications due to business changes.
- Created new PowerBuilder objects, MS SQL and Sybase stored procedures.
Environment: PowerBuilder 7, 9, 10, Sybase 11, MS SQL 2000
Confidential, New York, NY
Consultant
Responsibilities:
- Modified COMCAL global compensation system to incorporate changes due to Confidential merger.
- Created new PowerBuilder objects, Oracle functions and stored procedures.
Environment: PowerBuilder 8, Oracle 8, Oracle 9
Confidential, Bedminster, NJ
Consultant
Responsibilities:
- Modified existing interfaces to CARS/Medicaid reporting system. Created new reports. Redesigned reporting application to use Oracle for report definitions and report security. Added application security for reports.
- Modified existing MAAPS application written in MS Access and VBA
Environment: PowerBuilder 7, Oracle 7, Oracle 8, MS Access, VBA
Confidential, New York, NY
Consultant
Responsibilities:
- For the HotelEXPERT system developed interfrace to ESPA (European Simple Paging) protocol compatible paging equipment and installed it at Grand Hyatt hotel in Berlin, Germany.
Confidential, New York, NY
Consultant
Responsibilities:
- Developed and maintained Sales Automation Toolkit (SAT) application for Confidential . Created an international version of the application for MTV Latin America utilizing Powerbuilder 6.5 and MS SQL Server (triggers, stored procedures, DB design)
Confidential, New York, NY
Consultant
Responsibilities:
- Developed Guest Comment Card tracking application for a major hotel chain in PowerBuilder 6.5 and Sybase SQL Anywhere.
Confidential, Parsippany, NJ
Consultant
Responsibilities:
- Developed Report Generator Application using PowerBuilder 6.5 and Oracle 7.3 Wrote procedures, functions and triggers to enforce business rules. Created web front end for it using HTML, JavaScript, and WebPB CGI and ASP interface to Oracle. Added EMG line of business to in-house Intrepid system. (PB, Oracle)
Confidential, New York, NY
Consultant
Responsibilities:
- Developed several enhancements for Investment Banking expense accounting system - FAMIS using PowerBuilder 5.0 and TSQL/Sybase System 11. Converted all datawindows, imbedded SQL and Sybase stored procedures and triggers to System 11.
Confidential, New York, NY
Consultant
Responsibilities:
- Designed and developed several line items of the GEnesys Facilities Scheduling system using PowerBuilder 5.0, ICON Enterprise Builder Class library (BCL), TSQL/Sybase System 11.
Confidential, Montvale, NJ
Application Architect
Responsibilities:
- Responsible for design, implementation and roll-out of the company wide multiplatform Time and Expense Account System using PowerBuilder 5.0, Powersoft Foundation Class library (PFC), Sybase SQL Anywhere, and Oracle.
Confidential, New York, NY
Director
Responsibilities:
- Managed the design and implementation of the Olympic Sales System, Manpower and ServeChart Systems for CBS Sports, Unwired Network System for CBS Radio and Flash Reporting System (PowerBuilder 4 and 5, Visual Basic 4.0 and SQL Server 6.5). Designed interface for the Front End Billing system.
- Managed a DBA group responsible for SQL Server administration and data modeling. Administered SQL Server 6.0 and 4.2 database servers.
- Developed and administered a reusable class library in PowerBuilder.
- Designed and implemented a Regional Game Scheduling System for CBS Sports using MapInfo Geographical Information System for Windows.
- Coordinated an evaluation of client/server products (Gupta, Sybase/Microsoft SQL Server, PowerBuilder, MDI Gateway). Was in charge of PowerBuilder and SQL/Server implementation.
- Created a customized development life cycle methodology based on Information Engineering and started implementing it within the MIS department. Originated an evaluation of upper CASE (ADW, IEF, LBMS) and coordinated vendor communications.
Confidential, New York, NY
Manager
Responsibilities:
- Implemented an IE- and Yourdon-based methodology and the ADW CASE tool in the Investment Information division. Created ADW usage guidelines and a common set of data types.
- Coordinated all ADW related education. Managed a Project Support group responsible for the methodology, the creation of Structured Design and Analysis standards, and CASE tools support.
- Evaluated CSP, APS/SAGE, and ADW/CWS code generators.
- Assisted staff in the use of project management tools. Trained managers in project planning and progress tracking techniques using Project Manager Workbench. Participated in the AD/Cycle Showcase joint effort with IBM.
- For the Tenants Lease Maintenance project, was in charge of Structured Analysis and Design (Yourdon and IE methodology), Data Modeling, Logical Database Design and the use of the ADW CASE tool.
- As a database administrator, provided database design (including data modeling, logical and physical design), security, recovery guidelines, and maintenance for Trade Order Processing Systems.
- Migrated a set of applications between development and system test environments including database objects and data. Reviewed application program SQL statements to insure acceptable performance.
Confidential, Poughkeepsie, NY
Project Leader
Responsibilities:
- For a major release of RACF, was a project leader responsible for design, analysis and implementation of Work Unit Identity, JOB Name Security, NODE Class Security, Security Level Audit and other functions. Developed and reviewed specifications and test plans. Implemented the designs using PL/S (IBM's version of PL/I) and BAL. Planned projects, including scheduling.
- Designed tools to automate phases of the development process using ISPF dialog services. Assisted in teaching the New Programmer Education course.
Confidential, Teaneck, NJ
Programmer
Responsibilities:
- Designed an interactive dump interpreter for the IBM 1130 system and implemented it in Assembler language.