Business Analyst / System Analyst
Resume:
Business Analyst / System Analyst
Summary:
Successful Business/Systems Analyst and QA Analyst experienced in manufacturing, retail, chemical, pharmaceutical, television/radio and banking industries. Expertise on IBM Mainframe, Unix and Web platforms. Efficient and effective in leveraging tools, such as Rumba, Lotus Notes, Netscape and MS OFFICE Products, and programming languages such as Cobol, Oracle, SQL, HTML, Access, and other industry-specific languages, to accomplish strategic objectives. Works well independently and as a team player. IT Professional with strong analytical and communication skills and verbal & written communication. Known as a problem solver, results oriented, logical, dedicated and trustworthy.
Qualifying Skills:
Technical:
• IBM Mainframe (COBOL, JCL, Procs, Telon, TSO/ISPF, FTP, IBM Utilities, CICS, IMS, IDMS, DB2, RDBMS, VSAM, MVS, QMF, Easytrieve, TCP/IP, ETI Extract, Syncsort).
• UNIX (HP, Sun), Korn Shell, ETI Extract, FTP.
• FTP (Mainframe, Unix and PC/Lan
• PC’s MS DOS, LAN, Client/Server, Microsoft Windows98/2000/NT/Office (Word, Excel, Access, PowerPoint), Microsoft Access, Microsoft Outlook, MS Project, Rumba, Lotus Notes, Internet Explorer, Netscape, Web (HTML, MSFrontpage), Visio, ABC Flowcharter. Helpdesk software: Clarify11.
• Databases: Oracle (8i) (incl. Data Warehouse), SQL Server, Access (SQL, Data Warehouse, MS Access, ODBC). Toad.
• Web – HTML, XML, JavaScript, Flash, Active Server Pages (ASP), E-Commerce, TextPad.
Experience:
RSD Software, Teaneck, NJ - Contract 2007 – Present
Systems Engineer (System Analyst/QA Analyst)
• Overview Platforms: IBM Z/OS Mainframe (Cobol, JCL, Procs, TSO, VSAM, MVS, IBM Utilities), PC’s (DOS), LAN, FTP & UNIFTP, Client/Server, Oracle, SQL, ODBC, Microsoft Windows2003/NT/XP/Office (Word, Excel, Access, PowerPoint), Microsoft Access(2003), Microsoft Outlook, MS Project, Internet Explorer, Web (HTML), MS Project, Windows XP Version 2002, MS Office Professional 2003, MS Access 2003, TextPad 4.7.3, WinZip 8.1.
• ECM (Enterprise Content Management System) Content Management System (CMS) Document/Data Management, Archive & Retrieval Systems.
• Document Data Management Software with archival and retrieval capabilities on the Z/OS Mainframe and PC Windows/LAN platform.
• Provide Support for Software System. Identify and replicate problems, if new problem create incident report and document fully, if existing problem with resolution, send resolution to business customer.
• Perform QA Analyst testing for problem resolutions, alpha/beta testing of new releases, etc.
• Create and update Technical Documents, to reflect company software.
• Worked with International teams (Switzerland and UK) and cross-functional groups to provide support of software, perform QA Testing, software upgrades.
Pearson Education, Old Tappan, NJ 2006 – 04/2007
Business/Systems Analyst/QA Analyst
• Overview Platforms: IBM Mainframe (Cobol, JCL, Procs, TSO, IMS, RDBMS, VSAM, MVS, IBM Utilities), PC’s (DOS), LAN, FTP & UNIFTP, Client/Server, Oracle, SQL, ODBC, Microsoft Windows2003/NT/XP/Office (Word, Excel, Access, PowerPoint), Microsoft Access(2003), Microsoft Outlook, MS Project, Internet Explorer, Web (HTML), MS Project, Windows XP Version 2002, MS Office Professional 2003, MS Access 2003, TextPad 4.7.3, WinZip 8.1, TOAD, Business Objects, Relational Database Management Systems (RDBMS) “Remedy” (IT Problem/Question Tracking System), Actuate, Data Warehouse, Java, Web Design, Data Mapping, File Mapping.
• Manage and work with International programming consultants both on-site, off-site and off-shore(offshore):
• Manage & work with International programming consultants on-site, off-site and off-shore to support below system applications, perform Quality Assurance (QA) testing for multiple projects/products, and develop new applications and enhancements to existing systems. Also worked with “Cross-Functional Teams” to accomplish some of these projects/tasks.
• Sarbanes-Oxley (SOX) and Audit Controls:
• Project Sarbanes-Oxley (SOX) and Audit Controls for below projects. Perform quality control best practices, QA testing and defect tracking for these projects, both tracking and reporting.
• Higher Education/College Applications and Data Management:
• Business Analysis, full project life-cycle, SDLC (Software Development Life Cycle), system life cycle (SLC) business meetings, gather requirements, create “Requirement specs”, System and Design Specs. Project timeline (MS Project), testing, QA and implementation to Production with business signoff.
• Develop and support Higher Ed/College Books applications, Data Warehouse and Data Reporting for sales, analysis, inventory, etc.
• Develop and support data transfers, (Data Transformation/Data Migration) Data Warehouse and data maintenance for above application and reports using MS Access, Actuate and Business Objects, also interfaces/feeds to Accounting/General Ledger systems.
• Create and update Technical documents, (Requirements, Design, Specifications and Technical documents) accordingly. Includes data mapping and documentation.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
• CTS – Cost Tracking System & CES –Cost Estimation System:
• Develop & support these systems which generate and monitor purchase orders inventory and production, it also provides reporting costs related to publishing title, books, etc. and enables the business to perform cost analysis and manage expenses. Develop and support Data Reporting. Develop & support feeds to General Ledger (G/L) and Accounting (A/R, A/P).
• Create and update Technical documents, (Requirements, Design, Specifications and Technical documents) accordingly.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
• Change Management – Participating member and team representative at “Change Control Meetings.
The Topps Co. Inc., New York, NY 2004 – 2006
Business/Systems Analyst/ QA Analyst
• Overview Platforms: IBM Mainframe (Cobol, JCL, Procs, TSO, IMS, RDBMS, VSAM, MVS, IBM Utilities), PC’s (DOS), LAN, FTP & UNIFTP, Client/Server, Oracle, Toad, SQL Server, ODBC, Microsoft Windows2003/NT/XP/Office (Word, Excel, Access, PowerPoint), Microsoft Access(97, 2003), Microsoft Outlook, MS Project, Internet Explorer, Web (HTML), DOS scripts/batch files, MS Project, Windows XP Version 2002, MS Office Professional 2003, MS Access 97 & 2003, TN3270 Plus Help Copyright © 1997-2000 by SDI, Release 2.1.7, TextPad 4.7.3, WinZip 8.1, Masterpiece 1.3 Mainframe Accounting/Financial Application, “ACE” – MS Access application, Monarch 4.05 – (Datawatch Corporation), Citrix Server to access Sales Analyzer database, Relational Database Management Systems (RDBMS), Data Mapping, File Mapping.
Masterpiece 1.3 Mainframe Accounting/Financial Application (System Analyst/ Security Administrator):
• Security Administrator, Maintain security profiles, users and passwords.
• Sarbanes-Oxley Project this application.
• Business/System Analyst, Full Project Life Cycle, SDLC (Software Development Life Cycle), system life cycle (SLC)for G/L (General Ledger), A/P (Accounts Payable) and A/R (Accounts Receivable). Interface Files between application and MS Access for Access queries and reports.
Monarch 4.05 – (Datawatch Corporation) – Software that convert report files into text files and excel files.
• Using Monarch software convert several reports (A/P, G/L, etc.) from reports to excel files for usage in MS Access for data analysis and reporting.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
MS Access:
• HTA (Home Team Advantage System) – Dealer/Collector Card System with interfaces from the mainframe to maintain its customer Database, with full project life-cycle, SDLC (Software Development Life Cycle), system life cycle (SLC) and Data Reporting.
• Lab D/B – Lab formula database with interfaces with other “MS Access” databases to migrate lab formulas to production environment, with full project life-cycle, SDLC (Software Development Life Cycle) and Data Reporting.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
Synectics Trade Promotions (Trade Spending) –
• Integration and interface (Data Transformation/Data Migration project) with outside Trade Spending Application. Full project life-cycle, SDLC (Software Development Life Cycle). Application controls, monitors and reports on Trade spending of brokers and dealers of the company’s products.
Asset Management Application:
• Asset Management Application Software. Full project life-cycle, SDLC (Software Development Life Cycle) from installation to implementation and support. Application controls, monitors and reports on all company assets, from furniture to computer hardware and software.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
Navision:
• Integration of financial, manufacturing, distribution, customer relationship management, and e-commerce data. To streamline distribution processes and improve inventory management and warehouse efficiency. Includes item tracking, multiple location logistics, bills of materials, transfers, item substitutions, and warehouse management ranging from internal picking to shipping and delivery. Full project life-cycle, SDLC (Software Development Life Cycle). Starting with conversion to existing applications and Data Transformation/Data Migration. Includes data mapping and documentation.
Toys R Us, Wayne, NJ 2002 – 2004
Business/Systems Analyst (QA Analyst)
• Overview Platforms: IBM Mainframe (AcuCobol -GT, Cobol, JCL, Procs, TSO, IMS, RDBMS, VSAM, MVS, DB2, IBM Utilities), PC’s (DOS), LAN, Unix (HP, Sun), FTP & UNIFTP, Client/Server, Oracle, SQL Server, ODBC, Microsoft Windows2000/NT/Office (Word, Excel, Access, PowerPoint), Microsoft Access, Microsoft Outlook, MS Project, Lotus Notes, Internet Explorer, Netscape, Web (HTML). Unix Korn Shell Programming/scripts, DOS scripts/batch files, HP Tools/Unix commands, MS Project, Relational Database Management Systems (RDBMS)
• Campaign System: (Systems Analyst/Project Leader)
• Full Project Life Cycle, SDLC (Software Development Life Cycle), system life cycle (SLC), (Development, Programming, Installation, Implementation, Maintenance) of the Campaign System, which provides data entry and control for Sales promotions and coupons for consumers. Business units would enter in sales promotions, deals, and coupon deals for consumers. The system would then feed this data down to the individual stores, each store’s database, where it would be available to the registers as the consumer checks out. Includes data mapping and documentation. Use MS Access and Excel for research, analysis and reports (Data Reporting).
• Sarbanes-Oxley Project of IT.
• Worked with internal and external personnel on Sarbanes-Oxley Project of IT application.
• Project Sarbanes-Oxley (SOX) and Audit Controls for this project. Perform quality control best practices, QA testing and defect tracking for these projects, both tracking and reporting.
• Perform QA Analyst testing for problem resolutions, alpha/beta testing of new releases, etc.
Independent Consultant, Westwood, NJ 2001-2002
• Programmer, Systems Analyst
• Independent Contractor with CSC, assigned at a Baker & Taylor (Major Booking Distribution Company) in New Jersey. Working on Mainframe with COBOL, IMS/DB2, VSAM, and PC’s and LAN with MS Office, MS Access, MS Windows/NT, MS Visio, and MS Project. Applications/projects include maintenance and enhancements to the Order Entry System and conversion from “Message Express” to”MQ Series”.
• Programmer, Systems Analyst, Instructor and Developer
• Worked on several projects, including installing software, adhoc- reporting using MS Access and MS Office, etc. Web development projects with HTML, JavaScript, etc. PC Software installation and upgrades.
• Instructor/Tutor for various courses, including PC, Windows, MS Office, Computing.
BASF Corporation, Mount Olive, NJ 1986-2001
(A manufacturing, chemical, pharmaceutical company (Knoll pharmaceutical))
Developer, Programmer, Systems Analyst
• Overview Platforms: IBM Mainframe (Cobol, JCL, Procs, Telon, TSO, IMS, RDBMS, VSAM, MVS, DB2, Easytrieve, ETL, ETI Extract, IBM Utilities), PC’s (DOS), LAN, Unix (HP, Sun), FTP, Client/Server, Oracle, Toad, SQL Server, ODBC, Microsoft Windows95/98/NT/Office (Word, Excel, Access, PowerPoint), Microsoft Access, Rumba, Lotus Notes, Internet Explorer, Netscape, Web (HTML, MSFrontpage). Unix Korn Shell Programming/scripts, VSIFAX. DOS scripts/batch files, HP Tools/Unix commands, MS Project.
• Sarbanes-Oxley (SOX) and Audit Controls:
• Project Sarbanes-Oxley (SOX) and Audit Controls for below projects. Perform quality control best practices, QA testing and defect tracking for these projects, both tracking and reporting.
Exports – Export Order Entry System:
• Full Project Life Cycle, SDLC (Software Development Life Cycle), system life cycle (SLC), (Development, Programming, Installation, Implementation, Maintenance) of the Export Order Entry System which provided order entry, inventory control, regulatory controls for Export Orders and duty drawback monetary returns exceeding $1 million in savings. Full Project Life Cycle of Application interfaces and data feeds, between IMS Database, DB2, Oracle, Access and flat files. Interfaces included Customer, Product, DataWarehouse, A/P, A/R, Relational Database Management Systems (RDBMS), etc.
• Maintenance upgrades and rollouts, which included QA Testing, unit and system tests. Upgrades included packaging several fixes/patches/enhancements into a “Release”. Reduction of Daily production by 50%.
• Customer reports using MS Access, with ODBC. Extracted data from Oracle Databases and SQL Server, & Access DB, providing results in both an Access datasheet and into MS Excel Spreadsheet for reports, analysis, measurements and charts.
• Develop and maintain ETI Extract programs to Extract data from the Oracle database to Load into the new SAP R3 System.
• Full Life Cycle (SDLC - Software Development Life Cycle)) of both Unix and LAN based data feeds for Duty Drawback System (retrieving $750,000+ in customs taxes).
• Enhanced and supported Web Reports for customer business units, enabling them to retrieve and view data in a business format.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
IBM Mainframe OPIC (Order Entry Processing / Inventory Control / Invoicing and Pricing System).
• Established customer requirements, designed, developed and programmed (Full Project Life Cycle) the Pricing System and Order Entry Processing, both Online and Batch for this IBM Mainframe system. Designed the complex Pricing System using a structured design and programming to provide pricing from the product level down to customer bill-to/ship-to level, enabling the business units to utilize various pricing strategies. Included Order Entry, Inventory Control, Pricing, Invoicing.
• Perform QA Analyst testing for problem resolutions, testing of new releases, etc.
Data Warehouse:
• Provided customer reporting using MS Access Reports (MS Access, ODBC), against Oracle (DB) Data Warehouse and SQL Server. Extracted data into an Access datasheet and into MS Excel Spreadsheet for analysis, measurements and chart.
• Helpdesk Resolver for Data Warehouse resolves questions and problem solver/eliminator and assigned tickets to the appropriate person or group.
• Production Support of Data Warehouse.
• Global Data Warehouse project leader for installation of MQ Series and CA Scheduler on Unix platform.
Instructor:
• Taught on various subjects, in different environment settings, such as, classroom, lunch & learn, and group sessions. Various subjects include, MS Windows, FTP, MS Office, MS Access, Unix Shell scripts, Remote Dial-in Access, Helpdesk scripts, PC setup for Applications. Also did PC & Software setup for these sessions.
Helpdesk:
• Worked on the Helpdesk in support of the application. Created both Installation and Problem Solving Scripts for the Helpdesk. Assisted the Helpdesk in installation, problem solving and support of software and application support.
Lan Administrator:
• Lan Administrator for Application: Provided Software installation and setup users for access to Exports, both internally and remotely; instructed other Lan Administrators on the PC installation of software; created both an Installation and Problem Solving Script for the Helpdesk and Lan Administration. Assisted both Helpdesk and Lan Administrators in installation, problem solving and support.
Change Management:
• Member of the Change Management Committee, to review, approve and communicate any and all changes, enhancements of platforms, software and hardware to the appropriate end users and management.
PC Standardization:
• PC Standardization – As a team player and group representative, organized and co-implemented a plan to insure accurate and quality rollout. Also directed, planned, set up and tested several applications in test bed environment to insure applications worked in the new environment, both standalone and with other software.
Professional Training:
• WEB Development: Web Page Development, HTML, XML, Active Server Pages (ASP), Web Animation & E-Commerce Site Development, Flash, TextPad, Object-Oriented Programming with Java, Java Script, VBScript, Java Programming Intro & Advanced.
• Mainframe: TELON. Cobol, IBM Utilities, JCL
• PC/LANs, Windows Memory Management, DOS, LAN, Microsoft Office, Lotus Notes, MS Access 97.
• UNIX: HP Unix, System Administrator,
• Oracle: Oracle SQL, Oracle Forms.
• Web: MS FrontPage, HTML, JavaScript, TextPad
Educational Training
• Bergen Community College – Computer Programming & Science.
• PSI – Programming & System Institute.
• Chubb Institute – Madison NJ.
• HP – Paramus, NJ – HP UNIX, UNIX scripting, Korn Shell, Unix Admin.
• Oracle – Iselin, NJ – Oracle, SQL.
Keywords:
AcuCobol, Active Server Pages ASP Cobol CICS Client/Server Data Warehouse Dedicated Easytrieve E-Commerce Efficient Enthusiastic ETI Extract Flash FTP HP Glance and HP’s monitor tool HP Tools Unix commands HTML IBM Mainframe IMS Database IDMS Database DB2 Database Internet Explorer JCreator JavaScript JCL LAN Logical Lotus Notes Microsoft Windows MS Access MS DOS MS Excel MS Office MS PowerPoint MS Word MSFrontpage MVS Netscape Web Novel Network utilities NT ODBC Oracle Onshore Offshore PC’s Problem solver Procs Programmer and Programmer Analyst Results, QMF Rumba Sarbanes-Oxley SQL SYNCSORT SQL Server Strong communicator System Analyst TCP/IP TextPad Telon Thorough Trustworthy TSO/ISPF Unix HP Sun Unix Korn Shell Programming VSAM VSIFAX XML
Contact this candidate