SUMMARY:

Highly flexible Analyst / Technical Architect with mainframe background and strong customer focus and a record of continual achievement. Extensive background in data extracts, validating data using BTEQ, SQL, and Teradata Assistant for Terdata extraction, COBOL for data mapping programs in a data warehouse load, in addition to VSAM file processing, FOCUS reporting and database maintenance. Able to multitask and work across organizations and geographical boundaries, including offshore, to accomplish tasks. Analytical, yet able to see the larger picture. Currently learning SQL Server and SQL Server Reporting.

TECHNICAL SKILLS: Unit Testing System Testing COBOL VSAM JCL FILEAID FOCUS TSO QMF Teradata BTEQ DB2 NDM VM/CMS HTML EXCEL ACCESS Word

MANAGEMENT SKILLS: Requirements Gathering Team Builder Analytical Customer Focused Waterfall SDLC Collaborative Flexible Mediator Responsible Persistent Intuitive Coordinate Offshore

EMPLOYMENT HISTORY:

Confidential

COBOL Analyst and Developer

Responsibilities:

• Maintain and validate release updates.
• COBOL programming in VM/CMS VSE environment.
• Update profiles, analyze release information from Ingenix and McKesson, including APCs.
• Promote releases; handle ad - hoc requests, special requests for data.
• Work in a VSA/CMS environment in conjunction with MS Office/Windows environment.

Confidential, New Haven, Ct.

Development Expert

Responsibilities:

• Lead analyst and programmer on mainframe Sales Compensation in the Midwest.
• Wrote and maintained SQL scripts to handle data extracts using both BTEQ and Teradata manager (windows environment).
• Handled all phases of requirements, development. and implementation. Assisted Clients in developing overall architecture of the system.
• Provided all FOCUS queries and system reporting to clients. Utilized SQL in both Data Warehouse (Teradata) and DB2 environments.
• Provided additional support to DB2 COBOL, and VM/CMS FOCUS systems.
• Demonstrated flexibility by assuming responsibility for the Midwest sales system after the lead programmer left the company on 2 days notice.
• Brought the system into compliance, and automated the daily production. Result was a more timely output, greater reliability, and a more stable process.
• Applied process improvement and previous systems knowledge, including Data Warehouse to three different sales compensation systems.

Confidential, New Haven, Ct.

Business Manager

Responsibilities:

• Deployment manager for Enterprise Data Warehouse (EDW), providing EDW expertise.
• Participated in successful deployment of Express for EDW, completed gap analysis, mapped roles, upgraded job aids, localization of practices, worked on Software Configuration Management (SCM), and identified potential problem in Panagon migration.
• Taught EXPRESS to both clients and developers.
• Process Architecture Lead Managed all changes in the change control board.
• Responsible for managing all process change requests, waivers, exceptions, and local practices that come to the ESIS LEG team.

Confidential, New Haven, Ct.

Technical Architect

Responsibilities:

• Analyze, design, program, and test COBOL data filter programs for Southwest Bell’s Enterprise Data Warehouse.
• Create data load files for Teradata machine, using COBOL and mainframe utilities.
• Wrote SQL extracts using BTEQ and Queryman for Teradata quality assurance purposes.
• Mapped out data for database administrators.
• Verified data structures against the Multiload scripts.
• The position required great flexibility and willingness to adapt quickly to change.
• Supported Midwest billing, East Service Order system, participated in Program Leadership Team.
• Lead Programmer in PITS/WIND integration project - replaced an entire manual system with monthly and daily processes.
• Coordinated Confidential Data Center Conversion efforts for EDW, including system testing to validate a parallel cycle when the data center conversion was put into place.
• Set up a feed using Focus, which read two DB2, tables, filtered the data, loaded files into a Focus database, and created flat files, which were transferred via NDM to St. Louis. This was accomplished in one week, with minimal knowledge of SQL and DB2.
• Implemented ASI processing into SWBT billing portion of EDW

Confidential, New Haven, Ct.

Programmer Analyst

Responsibilities:

• Analyze, program, and test major projects for the Carrier Access Billing System (CABS), a COBOL, IMS, and VSAM based system.
• Provide maintenance support, in addition to key support for a FOCUS database application.
• Provided unit test, integration tests, and system tests to validate projects and releases
• Selectively chosen to CABS Usage Restructure project, a major initiative within the CABS system. Restructured an IMS database.
• Saved $500,000 annually in processing time via a coding enhancement.
• Restructured IMS database which allowed a great simplification of the CABS system.
• ASIS FOCUS support - provide support for a FOCUS database system (ASIS) used by Network Marketing and Sales.

Confidential, Hartford, CT

Programmer Analyst

Responsibilities:

• Provided reports using Information Expert on Confidential and Confidential ’s General Ledger, Fixed Assets, and Accounts Payable system.
• Tested output of programs against specified criteria and against financial reports.
• Created a FOCUS Dialogue Manager and database system, which allowed Shawmut to merge three banks in two months.
• The system included a daily file mapping for each bank, a monthly load, and a history load.
• Utilized Confidential and Confidential ’s MSA/Information Expert language to provide financial information to the Corporate Comptroller’s office.