SUMMARY:

While I am technical and love to develop programs in any language, I have a strong affinity for Business Analysis. I am adept at picking up new languages, tools, and techniques, but I will provide support for any legacy application regardless of age or environment. I have experience with a variety of old and new technologies allowing me to apply the best solution to any situation. I am able to work collaboratively with other specialized technicians, and perform extremely well with minimal supervision. I anticipate next steps, have no fear of making decisions and have a reputation for solving very complex and difficult problems. I prefer fast - paced, collaborative, multidiscipline technical environments, possess excellent verbal and written communication skills and have management and team leadership experience both onshore and offshore.

TECHNICAL SKILLS:

Applications and environments: Financial, Retirement Benefits, Banking and Credit Cards, Healthcare, Wholesale and Retail Sales and Inventory, Telecommunications, Automotive, Manufacturing, Construction.

Exceptional experience with: Application support and Maintenance, Conversions, Business Requirements and Systems Analysis, Cost Analysis and Estimating, Project Planning and Control, Relational Database Design, Outsourcing ( Managed Services), Data Modeling, Performance Tuning, Quality Assurance.

System Development Life Cycle: Requirements, Feasibility Studies, Sizings, CMM Methodology, QA, Regression Testing, User Acceptance Testing, Implementation, Training and Production Support.

Case and Cost Estimating Tools: PowerDesigner, ERWin, Constructive Cost Modeling, FPA, and Brackets.

Hardware and software: IBM z/OS, OS/390 using MVS, COBOL/II, Easytrieve, DB2, SQL, Stored Procedures, QMF, SPUFI, IMS DB/DC, TSO/ISPF, JCL, VSAM, CICS, Fileaid, Xpediter, Platinum, NDM, MQ, TELON, ChangeMan, Endevor, Panvalet and Librarian. Visual Studio, .Net Framework 4, TFS, VB.Net, Access 2010, SQL Server, VBA, Excel, VB6, Lotus Notes, C/C#/C++, ASP.Net, ColdFusion 8.0, HTML, XML, Java (J2EE), BI, WebSphere, JavaScript, Teradata, FTP, T-SQL, ADO, ODBC, SSRS, SSIS/DTS, SSAS, Nomad, Connect Direct (NDM), MS Office, Clarity, BMC Remedy.

PROFESSIONAL EXPERIENCE:

Programmer/Analyst, Mainframe .Net Developer

Confidential, Cypress, CA

Responsibilities:

• Analyzed and documented business requirements for the Confidential Inc to Confidential (Rockwell-Collins Retirement Benefits System).
• Imported and converted Confidential Inc Employee imported data into Confidential (Retirement Benefits System).
• Revised 20 Mainframe Jobstreams to automate the importation of active Confidential Inc employees from Confidential (Payroll system) into Confidential .
• Updated DB2 and IMS DB/DC COBOL programs and procs to support changes to Employee Benefit Options in Confidential and Confidential .
• Modified Confidential eBenefits & Pay Portal ColdFusion 8.0 modules to support changes to the Employee Benefit Options.

Technology: zOS, Cobol, IMS DB/DC, DB2, SQL, VSAM, JCL, QMF, SPUFI, ColdFusion 8.0, VB.net 2008, Excel, Access 2010, VBA, BMC Remedy, Word 2010, PVCS, Windows 7.

Programmer Analyst, Developer

Confidential, Carson City, NV

Responsibilities:

• Updated the cursor logic residing in the main zOS COBOL program to a CTE that extracted data from a DB2 database. Removed built-in data fields by adding a Session table to the main extract program, populating the new temp table from DB2 and adapting the new cursor logic to the existing TSQ (CICS) process.
• Added index tax to fuel loads to be used on worksheets, and statistical reports for the Confidential .
• Added required functionalities to the Motor Fuel Tax Application (an ASP.NET web application built using VB.NET and JavaScript) as per AB413, for the Nevada DMV.

Technology: Cobol, DB2, SQL, QMF, VSAM, JCL, CICS, VB.net 2010, with .NET Framework 4.0, TFS, Excel, SQL Server 2008, Windows XP.

Confidential, Naperville, IL

Programmer Analyst, Cobol Developer

Responsibilities:

• Analyzed and updated custom Cobol.Net and VB.Net modules and SQL Server queries and tables to the latest release of the QicClaims application for a wide range of Confidential Healthcare programs .
• Modules included: Claims Maintenance, Claims Adjudication, Claim Workflow Maintenance, Application Processing, Enrollee, Member and Group Maintenance, Benefits by Provider Analysis, Background Processing, Agent 1099 printing process, Claims Open Mail Listing, Billing Reinsurance, Disability History and more.

Technology: Visual Studio, TFS, VB.Net, SQL Server 2008, Fujitsu Cobol (Cobol.Net), Windows 7, Windows XP (VM).

Confidential, Chicago, IL

Business Analyst, and Access Developer

Responsibilities:

• As Technical Business Analyst, I was the primary liaison between the business partner and the programming group. Conducted meetings with business partners to analyze, define and document detailed business and functional requirements for Version 2.2 of the ASO Group Configurator (ASOGC) application and Cognos Reports for the Confidential Administration Services Marketing Group.
• Drafted Business Requirements and Impact Analysis for the restructuring and redesign of the Managed Content version of the ASOGC Application “ASOGC Proposal for Future State SOA Architected Readiness.
• Developed Data Analysis queries and SSIS Packages to extract data for a Confidential managed SalesForce marketing campaign.

Technology: Access 2010, VBA, Excel, SQL Server 2008, SSMS, SSIS, SSRS, Visio, PowerPoint, Serena Dimensions, Cognos, Word 2010, Windows XP.

Confidential, Cypress, CA

Analyst, .Net Developer

Responsibilities:

• Data Analysis of DB2 tables to determine Plan usage. Enhanced the Confidential Employee Retirement Benefits Application ( Confidential ) for the Payroll and Benefit Solutions group.
• Extracted the formulas of over 20 non Mechanized Plans contained in Excel spreadsheets and moved them into DB2 and Access Tables, using VB.Net, VBA modules, and Word documents. This lowered the error rate on participants forms and documents providing more accurate calculations, thereby saving the Retirement Benefits support group time and effort .

Technology: zOS, Cobol, DB2, SQL, VSAM, JCL, QMF, SPUFI, VB.net 2008, Excel, Access 2010, VBA, Word 2010, PVCS, Windows.

Confidential, Libertyville, IL

Business Analyst and Excel, Access Developer

Responsibilities:

• Analyzed all of the business related Excel Spreadsheets that contained the formulas and macros for RPC’s Compliance Analysis and Reporting for Qualified 401K and Profit Sharing Plans,
• Set up an automated method to import client data from Excel to Access further simplifying and speeding up the process.

Technology: Access 2007/2010, VBA, Excel 2007, Windows XP.

Confidential, Oakland, CA

VB, Access, Excel Applications Developer

Responsibilities:

• Analyzed VB and Stored procedures to find and correct major discrepancies in financial calculations that had been wrong for years in the Cost Model application.
• Added functional enhancements and fixes including major procedural changes to the VB6/.Net modules and UniVerse DB Stored Procedures.
• Created Access and Excel Reports with Charts and Graphs for the Compliance Risk Tracking System.

Technology: Visual Basic 6, IBM Universe DB, U2 Basic (Stored Procedures), Access 2003/2007, Excel, VBA, Outlook.

Confidential, Hoffman Estates, IL

Business Requirements Analyst, Offshore Team Lead, Applications Support

Responsibilities:

• Developed coding and SQL scripting requirements for the Confidential offshore programming group.
• Supported Production for Confidential for Customer Care & Billing IT Solutions group.
• Set in motion a process that instituted full unit and functional testing by the Confidential offshore group. By the time I left we had corrected 10 failed promotions affecting thousands of AT&T customers.

Technology: VB6, SQL, Teradata, Citrix, Connect:Direct (NDM), FTP, Teradata SQL Assistant, z/OS and MVS, DB2, Cobol, SQL, QMF, SPUFI, JCL, TSO, ISPF, VSAM, Outlook, Windows XP.

Confidential, Chicago, IL

VB.Net and Mainframe Support Contractor

Responsibilities:

• Supported Pricing and Unit of Measure process in the Order Fulfillment system.
• Analyzed the Pricing and Unit of Measure process in the (Mainframe) DB2 Order Fulfillment system to design and document a proposal to provide a method for early Pricing and Unit of Measure error detection.
• Modified an SSIS process to use DB2Link for the Stored Procedures and reports and created the Batch scripts to initiate the data download.
• Designed and developed a new Accounts Receivable Rebate Summary Report (SSRS) along with Stored Procedures, UDFs and Views to support the report.

Technology: VB.Net 2005, ASP.Net, AJAX 2.0, JavaScript, SSRS, SSIS, T-SQL Stored Procedures, Sharepoint, DB2/Link, SQL Server 2005, z/OS, JCL, TSO/ISPF, CICS, DB2, QMF, SPUFI, COBOL, Outlook, Panvalet.

Confidential, Chicago, IL

Mainframe Application Developer

Responsibilities:

• Designed, coded and tested new DB2 Modules (Stored Procedures) for Global Services New Accounts Setup.
• Extracted XML data from a variety of DB2 tables for new Account setup, “Copy Account” function.

Technology:, z/OS DB2, XML, SQL, QMF, SPUFI, COBOL, JCL, TSO, ISPF, SCLM, DB2 Connect, SDLC, Sharepoint.

Confidential, Concord, CA

Systems Analyst and Application Developer

Responsibilities:

• Designed, coded, tested and implemented a complex data mapping and conversion process (close to 1000 data elements) from Access 2003 to SQL Server 2000 processes for migration to import Northwest (Seafirst) customer applications into the Sales Fulfillment database.
• Developed SQL Server Stored Procedures, VB6 classes and ASP to import data from a variety of sources, including email (Outlook) XML feeds, NOMAD, PGP encrypted sources and more.
• Developed and implemented changes to Hogan IDS online processes for Confidential (subsidiary of Confidential ).
• Coded and tested Batch and Websphere J2EE Modules for the RUN (Recycle Unassigned Accounts) initiative for all Confidential Account numbers including all those used for DDA/SDA (Direct Deposits/Savings accounts) and TDR/IRA (Time Deposits/IRAs). Developed C/C++, DB2 Stored Procedures and COBOL programs.
• Set up Entity Relationships (ERWin) for the RUN DB2 database including all business rules, Primary and Support Tables, Normalization, and coded all IBM Utilities and Scripts to create the RUN tables.
• Conducted User meetings and program walkthroughs and worked with DBA to set up tables and Stored Procs.
• Designed and coded all Stored Procedures and Batch programs, and set up the process for the Java modules to use DB2 Connect to access the stored procedures. Also created the test links prior to implementation.
• Coded and tested Batch and Online Enhancements for IMPACs (CIS) Relationship Pricing initiative. Coded IMS DB Transaction Definition and Update Modules from prepared Requirements documents.
• Prepared Unit Test data and set up CICS and IMS Unit Test Regions. All code was tested and delivered early.
• Designed, coded, tested and implemented LRS Online Liability Risk Simulator, interfacing with ADAP, POS, TELLER and COIN using Daily Journal file.
• Developed a Delta process for the LRS Online Liability Risk Simulator to recalculate each Journaled online transaction instead of trapping months of production data. Delivered completed application in 4 months saving Confidential close to $6m.

Technology: z/OS, COBOL, IMS/DB, Easytrieve, ISPF/TSO, VSAM, ChangeMan, JCL, TSO/ISPF, DB2, QMF, SPUFI, SQL-PL (DB2 Stored Procedures), DB2 Connect, WebSphere, Platinum, MQ, Easytrieve, CICS, IMPACS, Hogan, VB6, Access 2003, Visual Basic Scripting, VS.Net, T-SQL, SQL Server 2000, DTS, SSRS, SSAS, CMM 3.0 SDLC Methodology. Lotus Notes, C/C++, J2EE (Java), HTML, XML, JavaScript, Clarity.

Confidential, San Francisco, CA

Systems Analyst

Responsibilities:

• Deconstructed the entire GUS application; provided full documentation of migration requirements and conversion to new KC environment.

Technology: OS/390, COBOL, ISPF/TSO, JCL, PowerBuilder, Sybase (SQL Anywhere) 9, CICS, DB2, SQL, QMF, SPUFI, Endevor, Lotus Notes, NDM, Insync.

Confidential, Cupertino, CA

Business Analyst, Access Application Developer

Responsibilities:

• Designed and implemented Full Function Access Database using SQL Server backend and Access frontend. Included Purchase Orders, Inventory, Customer Sales Orders, Parts Distribution and Tracking, and WIP/Bill of Materials.
• Developed over 30 Access reports and Pro Forma Invoice.
• Developed Invoicing and Purchase Order Tracking Application using Access, VB.Net and SQL Server.

Technology: Access 2000/2002, SQL Server, Sybase PowerDesigner, Outlook, Windows XP.

Confidential, Concord, CA

Sr. Software Engineer

Responsibilities:

• Designed, coded and tested IMS DB/DC online and batch programs for ECP, CDA to IDS conversion and Checkfree projects.
• Provided production Support for IBO Item Processing online and batch (BMP) systems.

Technology: OS/390, IMS Fastpath Databases, IMS DB/DC, COBOL, Easytrieve, JCL, TSO, ISPF, MVS, ChangeMan.

Confidential, Concord, CA

Team Lead, Sr. Analyst and Software Developer

Responsibilities:

• Analyzed all of the business related functions and processes for the CMF Master files Outsourcing.
• Did Data Analysis and Mapping for the outsourcing of CMF Master files to FDR Managed Services.
• Developed Conversion plan and created an Access 97 database to provide Shutdown Analysis and Control for terminating modules no longer required due to outsourcing.
• Analysis of Hogan IDS interfaces for Overdraft Protection process. Provided links and files to Hogan Team.
• Coded, tested and implemented OLM Transition Programs for ACH, Autopay/RTN, Duplicate Repapering process between WFB HUB/FDR and Hogan.
• Developed and implemented Client Server and Mainframe test strategies for post conversion initiatives.

Technology: OS/390, COBOL, CICS, DB2, Oracle, SQL, VSAM, NDM, JCL, TSO, ISPF, Hogan, ChangeMan, VSAM, NDM, Access 2000, Easytrieve, Lotus Notes, Windows NT.

Confidential, San Francisco, CA

Team lead, Senior Software Engineer

Responsibilities:

• Led group in the Design, coding and testing of Batch programs for Carrier Access Billing System, CABS Account database. Enhanced CABS programs, coded new module for calculating shortest distance for routing charges.
• Developed Test Plans and executed and tracked all test cases for RADStar 2.0, an online marketing system developed for Confidential by IBM.

Technology: OS/380/390, IMS DB/DC, SAPIENS, COBOL, CICS, BMS, DB2, SQL, QMF, JCL, TSO, ISPF, MVS.

Confidential, San Francisco, CA

Senior Programmer/Analyst

Responsibilities:

• Coded and tested online and batch modules of LABS Order Fulfillment System using TELON and DB2.

Technology: OS/380, COBOL, Microfocus Cobol, CICS, DB2, SPUFI, QMF, ADW, TELON, and Endevor.

Confidential, Concord, CA

Senior Software Engineer

Responsibilities:

• As part of a 4 man team, successfully accomplished the Importation, Conversion and Installation of the Wholesale Banking System (WBS) from EMEA (London) to Concord.
• Programmed and implemented major enhancements to WBS SLF Loan System (Non-Performing Loans).
• Coded enhancements to WBS Commitments System and Developed new Letters of Credit interface.
• As Test Coordinator. Developed Regression testing and implementation procedures for WBS systems. Developed Scripts, ran tests and did follow up meetings for the Item Processing Online Vault Deposit System.

Technology: OS/380, IMS DB/DC, IMS ADF, BTS, COBOL, Easytrieve, DB2, QMF, SPUFI, JCL, TSO/ISPF, CLIST, Xpediter.