SPECIALIZED SKILLS:

Proficient: BMC Tool Suites including CATALOG, CHANGE, COMPARE, RECOVERY, DASD Manager, Hi - Speed Apply, MAINVIEW, APPTUNE, Confidential DB2 Automation Tool for Z/OS, Confidential DB2 Administration Tool, Confidential Optimization Service Center/OPTIM Query Tuner, FILE-AID for DB2TSO/ISPF, REXX, COBOL Programming, IMS DB/DC, MFS, OS/Pattern JCL, Confidential Advanced Function Printing (AFP), XPEDITER, SMARTEST, BTS, DB2 EXPLAIN, SPUFI, QMF, IMS XPERT, PLATINUM, CANDLE, OMEGAMON, TMON, PRINCETON MOVE/ACCESS, ENDEVOR/PANVALET.

Trained: DB2/IMS DATABASE ADMINISTRATION, DESIGN AND PROGRAMMING.

Experienced: Group Technology, Work Flow Analysis, Artificial Intelligence, Investment Portfolio, Inventory Control, Financial Systems, Health Claims ProcessingRetirement, Investment and Benefit Systems, Policy and Claim Processing.

EXPERIENCE:

Confidential, Jacksonville, FL

Fulfillment Associate

Responsibilities:

• Stowed items in robot pods to be used for customer orders.

Confidential, Jacksonville, FL

E - Commerce Lister

Responsibilities:

• Listed Donations on website and built advertisements for auctions.

Confidential, Cheshire, CT

Warehouse Associate

Responsibilities:

• Operated and certified to operate high lift fork lift.
• Utilized scan gun to log inventory in warehouse locations.

Confidential, New Britain, CT

Warehouse and Delivery Driver Associate

Responsibilities:

• Stocked and delivered auto parts at customer locations.
• Received shipments and operated fork lift to unload and store inventory.
• Collected payments from customers.

Confidential, Rocky Hill, CT

Sales Associate

Responsibilities:

• Entered customer orders for kitchen remodeling, refacing cabinets and countertops.
• Visited customers at their homes and gave product, installation and warranty demonstrations.
• Estimated prices based on square footage and linear feet.
• Used computer to enter orders and quote prices.

Confidential, Newington, CT

Sales Associate

Responsibilities:

• Entered customer orders and maintained showroom.
• Recorded days register count and made nightly deposits of cash.
• Sales tagged merchandise .
• Took inventory counts of merchandise and verified/reported discrepancies.

Confidential, Newington, CT

Sales Associate

Responsibilities:

• Entered customer orders for household appliances and power equipment repair.
• Assisted customers with do it yourself parts lookup and general repair questions and concerns.
• Sales tagged merchandise for sales and clearance.
• Maintained warehouse cleanliness and stock inventory.

Confidential, West Hartford, CT

Backroom Associate

Responsibilities:

• Unloaded semi-trailers of consumer goods.
• Unloaded and unboxed consumer goods for sales floor stock replenishment..
• Operated carton baling machine.
• Stocked and security tagged products for sale.

Confidential, Bloomington, IL

Data Specialist / Data Services

Responsibilities:

• Implemented mainframe OS/390 Z/OS production DB2 databases for Property and Casualty Systems. Resulted in increased performance efficiency thru DB2 Data Propagation methods for online/batch systems.
• Utilized Confidential ’s to automate data replication across DB2 subsystems.
• Implemented Global Temporary Tables and assisted the test centers in environment setup and RUNSTATS automation.
• Supported Systems Analysts with DB2 database structures and user testing environments.
• Maintained logical and physical database designs in EMBARCADERO ER/Studio data repository.
• Utilized Confidential numbers to allow state to state data transfers across DB2 subsystems.

Confidential, Jacksonville, FL

Consultant Database Analyst / Data Services

Responsibilities:

• Maintained mainframe OS/390 Z/OS production DB2 databases and tested PEOPLESOFT version upgrades with line of businesses. Resulted in increased performance efficiency for online/batch systems.
• Tuned SQL for PEOPLESOFT application areas during version upgrade testing.
• Supported Application Programmer Analysts with DB2 database structures/versions.
• Utilized Confidential ’s VISUAL EXPLAIN, QUERY MONITOR and SQL ANALYZER software to tune SQL.
• Assisted DBA’s with Confidential ’s DB2 ADMINISTRATION and AUTOMATION Tools for Z/OS.

Confidential, Windsor, CT

Senior Database Administrator

Responsibilities:

• Maintained mainframe OS/390 Z/OS production DB2 databases and coordinated changes with line of business DB2 database analysts. Resulted in decreased run times, I/O and DASD utilization and increased performance efficiency for online/batch systems.
• Monitored tablespaces and indexes to ensure that applications operate at peak efficiency.
• Audited test systems to ensure production problems did not exist upon implementation.
• Supported Application Programmer Analysts with DB2 databases, testing and debugging.
• Assisted Project Teams with BIND procedures including DRDA protocol on DB2 cross subsystem Applications.
• Worked with Confidential 's DB2 Products Group/MVS/ESM/ Confidential with analysis, testing, problem reporting and resolution during DB2 Version upgrades.
• Represented the DBA Area in the implementation of CLOB data, testing and procedures for DB2 utility maintenance.
• Responsible for maintaining Confidential 's Information Management DATAMART Warehouse storing over 14 terabytes of data.
• Coordinated, developed standards and procedures and tested Confidential DB2 Automation Tool for Z/OS.

Confidential, Hartford, CT

Consultant Database Analyst

Responsibilities:

• Maintained mainframe OS/390 DB2 test systems and coordinated changes with production DB2 database analysts.
• Resulted in decreased run times, I/O and DASD utilization which increased performance efficiency for online/batch systems.
• Evaluated performance and created/altered indexes to improve access path strategy and eliminate tablespace scans.
• Supported Systems/Programmer Analysts with database design, testing and debugging.

Consultant

Confidential

Responsibilities:

• Supported mainframe production environment and changes to Benefits Administration and Customer Services Chargeback Systems. Resulted in minimal down time for online/batch systems.
• Enhanced CICS, DB2 and IMS programs to user specifications, tested and implemented into production.
• Setup SQL queries and utilities for DB2 data analysis, updated DB2 table data in test environments and worked with clients to ensure a smooth transition into production environment.

Consultant

Confidential

Responsibilities:

• Remediated pension batch processing system for Year 2000.
• Resulted in no interruption to processing of data and reports on holidays, leap years and millenium run dates.
• Reviewed current date routines and added century.
• Setup VSAM files, IMS databases and test environments.
• Adjudicated batch jobs and resolved problems.
• Compared results to production jobs and explained all discrepancies for auditors.

Confidential, North Haven, CT

Database Analyst / Database Tech Services

Responsibilities:

• Automated Confidential ’s, DASD space management, compression, image copy/backup, DBD/PSB/ACB GENS, DB2 data definition language, plan/package and security creation and maintenance, performance monitoring, SQL explains and data integrity.

Applications Technical Support / Claims Processing

Confidential

Responsibilities:

• Designed online debugging tools to assist programmers with abends, DB2 utility generation.
• Designed automated production to test ENDEVOR-based turnover system.
• Assisted ENDEVOR administrator with testing and procedures as they relate to application test environments.
• Resulted in efficient troubleshooting and decreased downtime.

Confidential, Stamford, CT

Consultant, Inventory Accounting/General Ledger

Responsibilities:

• Trained five-programmer task force in conversion and testing.
• Converted 20 driver programs for transaction editing, error and suspense reporting.
• Eliminated mainframe, service lease, and support personnel costs.

Consultant, Inventory Control and Management

Confidential

Responsibilities:

• Wrote specifications for, programmed, and tested system.
• Provided technical assistance and processing assistance to support staff.