SUMMARY:

• While I am technical and love to develop programs in any language, I have a strong affinity for analysis. I am adept Confidential 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 for 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.
• Applications and environments: Retirement Benefits, Banking and Credit Cards, Finance, Healthcare, Wholesale and Retail Sales and Inventory, Telecommunications, Automotive, Manufacturing, Construction.
• Exceptional experience with: Business Requirements and Systems Analysis, Data Modeling, Cost Analysis and Estimating, Project Planning and Control, Application support and Maintenance, Conversions, Relational Database Design, Outsourcing (Managed Services), Performance Tuning, Quality Assurance.
• System Development Life Cycle: Requirements, Feasibility Studies, Sizings, CMM Methodology, Waterfall, QA, Regression Testing, User Acceptance, Implementation, and Production Support.

TECHNICAL SKILLS:

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

Hardware and software: IBM z/OS, OS/390 using MVS, COBOL/II, Easytrieve, DB2, SQL-PL, Stored Procedures, QMF, SPUFI, IMS DB/DC, TSO/ISPF, JCL, VSAM, CICS, Fileaid, Xpediter, Platinum, MQ, SAPIENS, TELON, ChangeMan, Endevor, Panvalet and Librarian.VB.Net, SQL Server, T-SQL, Oracle, TOAD, Access, VBA, Excel, C/C++/C#, ASP.Net, Visual Studio, .Net Framework 4, TFS, ColdFusion, HTML, XML Micro Focus Cobol, NetCobol, ADO, ODBC, SSMS, Business Intelligence (SSRS, SSIS/DTS), ETL, VB6, Java (J2EE), Teradata, Sharepoint, MS Office, Word, Powerpoint, Visio, Connect:Direct (NDM), Clarity, BMC Remedy.

PROFESSIONAL EXPERIENCE:

Analyst, Mainframe

Union Bank, Monterey Park, CA

Responsibilities:

• Analysis of Cobol and Assembler programs to define data elements and to deconstruct code in the Union Bank DDA system for the Price Waterhouse structured Data Dictionary.

Technology: zOS, Cobol, VSAM, JCL, Assembler, Topaz, SharePoint, Oracle, TOAD, Excel, Windows 7.

Programmer/Analyst, Mainframe, Micro Focus, .Net Developer

Confidential, Long Beach, CA

Responsibilities:

• Import all PRIMS-A Cobol, IMS and DB2 Bill of Materials modules into Micro Focus for the Confidential PAPR re-hosting initiative.
• Test Mainframe vs Micro Focus IMS DB/DC Cobol programs using HP UFT.
• Develop screen scraping Test Summary Comparison Report using VB Script and HP UFT.
• Set up Visual studio Team Foundation Server and Git Version Control for all Micro Focus Source modules.
• Run Dyl280 jobs and download results for offshore Dyl280 to Cobol Conversion effort. Analyze differences and provide corrections to offshore Dyl280 to Cobol Converted modules.
• Analyze CA7 for importing and/or converting to Autosys.

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

Business Analyt and Excel, Access Developer

Confidential, Libertyville, IL

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.
• Designed Compliance data base using Power Designer Data Modeling tools, Access, Excel, and VBA.
• Automated a method to import client data from Excel to Access further simplifying and speeding up the process.

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

Programmer/Analyst, Mainframe, .Net Developer

Confidential, Cypress, CA

Responsibilities:

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

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

Programmer Analyst, Developer

Confidential, Carson City, NV

Responsibilities:

• 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.
• Added index tax to fuel loads to be used on worksheets, and statistical reports for the Motor Carrier Group.
• 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.

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

Programmer Analyst, NetCobol, .Net Developer

Confidential, Naperville, IL

Responsibilities:

• Analyzed and updated custom Cobol.Net and VB.Net modules and SQL Server queries and tables to the latest release of the QicLink 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, NetCobol (Fujitsu Cobol), Windows 7, Windows XP (VM).

Business Analyst, and Access Developer

Confidential, Chicago, IL

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 and Data Modeling Using Visio, for Version 2.2 of the ASO Group Configurator (ASOGC) application 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.
• Did Data Analysis queries and SSIS Packages and SSRS reports to extract data for a Confidential managed SalesForce marketing campaign.

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

Analyst, .Net Developer

Confidential, Cypress, CA

Responsibilities:

• Data Analysis of DB2 tables to determine Plan usage. Enhanced the Confidential Employee Retirement Benefits Application (PRISM) 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.

VB6, Access, Excel Applications Developer

Confidential, Oakland, CA

Responsibilities:

• Analyzed VB6 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, SQL, Excel, VBA, Outlook.

Business Requirements Analyst

Confidential, Hoffman Estates, IL

Responsibilities:

• Designed Database structures, Tables and Relationships, using the Erwin Data Modeling tool. Defined SQL scripting requirements for the TechMahindra offshore programming group.
• Supported Production for SE Fulfillments System for Customer Care & Billing IT Solutions group.
• Set in motion a process that instituted full unit and functional testing by the TechMahindra offshore group. By the time I left we had corrected 10 failed promotions affecting thousands of Confidential &T customers.

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

VB.Net and Mainframe Support Contractor

Confidential, Chicago, IL

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 new Accounts Receivable Rebate Summary Reports (SSRS) along with Stored Procedures, UDFs and Views to support the reports.

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

Mainframe Application Developer

Confidential, Chicago, IL

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.

Systems Analyst and Application Developer

Confidential, Concord, CA

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 and Oracle 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 Sea Confidential (subsidiary of Confidential ).
• Team lead. Coded and tested Batch and Websphere J2EE Modules for the RUN (Recycle Unassigned Accounts) initiative for all Confidential Account numbers including those used for DDA/SDA (Direct Deposits/Savings) and TDR/IRA (Time Deposits/IRAs). Developed C/C++, DB2 Stored Procedures and COBOL programs.
• Designed fully normalized database using ERWin data modeling for the RUN DB2 database. This included all business rules, Primary and Support Tables, Primary Indexes and Entity Relationships.
• 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 (Fidelity/Systematics) (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.
• 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: z/OS, OS/390, COBOL, IMS/DB, IMS Fastpath Databases, Easytrieve, ISPF/TSO, VSAM, ChangeMan, JCL, TSO/ISPF, DB2, QMF, SPUFI, PL/SQL (Oracle Stored Procedures), DB2 Connect, WebSphere, Platinum, MQ, Easytrieve, CICS, IMPACS, Hogan, VB6, Access 2003, Visual Basic Scripting, VB.Net, SQL Server 2000, T-SQL, DTS, SSIS/DTS, ETL, CMM 3.0 SDLC Methodology. Lotus Notes, C/C++, J2EE (Java), HTML, XML, JavaScript, Clarity.

Systems Analyst

Confidential, San Francisco, CA

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.

Business Analyst, Access Application Developer

Confidential, Cupertino, CA

Responsibilities:

• Designed and implemented Full Function Access Database using Power Designer data Modeling, 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 SSRS reports and Pro Forma Invoice.
• Developed Invoicing and Purchase Order Tracking Application using Access, VB.Net and SQL Server.

Technology: Access 2000/2002, VBA, SQL Server, SSRS, Outlook, Power Designer, Windows XP.

Team Lead, Sr. Analyst and Software Developer

Confidential, Concord, CA

Responsibilities:

• Functional Analysis, Data Analysis and Mapping all of the business related processes for the CMF Master files Outsourcing to FDR Managed Services.
• Developed Conversion plan and created an Access 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, DB2, Oracle PL/SQL, SQL, VSAM, NDM, JCL, TSO, ISPF, Hogan, ChangeMan, VSAM, NDM, Access 2000, Easytrieve, Lotus Notes, Windows NT.

Team lead, Senior Software Engineer

Confidential, San Francisco, CA

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.
• Coded Sapiens modules 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.