SUMMARY:

• Technology Lead/PA with more than twenty years’ experience in commercial data processing involving strong analytical, design and software development skills. Experienced in all stages of the Systems Development Life Cycle (SDLC).
• Worked on the design and implementation of various BATCH, ON - LINE and Web based applications utilizing COBOL, COBOL II, CICS, DB2,DB2/SQL, MQ Series, VSAM, Java, XML and SQL Server, dot Net Frameworks.
• Industries worked in include Brokerage, Banking, Life & Annuity and Healthcare. Applications worked on include Client Statements, FA Statements, General Ledger, P & S and Margin, Combined Interest Reporting, Claim Processing and Accounting systems, Customer Information File (CIF) and Customer Profile Systems (CPS), Fixed Income instruments, IS (Investment Solutions) Toolset Application, MLR and Claims Entry System (GIAS).
• Quick learner with an ability to rapidly gain an understanding of specifics of a particular business, synthesize information and employ new methods and technologies.

EXPERIENCE:

Confidential, Paramus, NJ

Senior Programmer Analyst - Consultant

• Created new programs, processes to read MQ Queues, reformat data and load History database with the new information.
• Changed Daily jobs to enhance system capability using ESP job scheduler.
• Created REORG jobs for partition DB2 tablespaces with ESP jobs.

Confidential, Malvern, PA

Data Developer - Consultant

• Integrated into Daily & Quarterly RMA Fee calculation Trust accounts.
• Changed Daily, Monthly & Quarterly fee calculations to create aggregated fee groups so clients can benefit from low fees.
• Modified RMA quarterly fee audit report programs, stored procedures to include TRUST & Inherited IRA Accounts.
• Changed Fee calculation programs, stored procedures for Money Market Reform (MMR) to properly use Liquidity Fees and Redemption Gates, for that purpose mapped money market database to fees and gates Database.
• Identified SQL statements in stored procedures/reports that were pain points in order to improve concurrency, altered SQL statements appropriately without disturbing data integration.
• Responsible for running applications for loading/migrating Fee Calculations Audit Report Database.
• Impact Analysis of RMA Daily, Monthly and Quarterly Fee calculations.
• Automated test to validate the result of quarterly fee calculations data for all account types, solved fee calculation defects.
• Constructed SQL queries to retrieve client information for data analysis, data masking of sensitive information, verified the accuracy of data analysis.
• Gather TRUST accounts data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format.
• Responsible for carrying out various data analytical tasks, verifying data for calculation errors and data irregularity.

Confidential, Basking Ridge, NJ

Technology Lead - Consultant

• Review and coordinate mainframe technical deliveries of TOPS, written in COBOL, CICS, DB2 with MQ calls.
• Drive TOPS production-issue-resolution with business and other technical groups.
• Track and report work of 15 member team.
• Assist Service Manager in planning and execution.
• Prepare software packages, obtain signoff from stakeholders and management to implement into production environment.
• Production 24/7 coverage and weekend support of online, batch & DB2 systems.
• Troubleshoot COBOL, CICS and DB2 problems (review CICS system dumps/transaction dumps and SQL tuning), changed programs, stored procedures.
• Worked with Quality Assurance team to ensure an easy translation of requirements documentation into test scenarios, led efforts to validate data fixes & data cleanup processes.
• Unit tested changes made to DB2 and CICS - DB2 programs, using microfocus Cobol environment and mainframe.
• Created quick ad hoc SQL queries and turn over results to users.
• Mapped provider demographic database to various downstream processing systems, ICD9 to ICD10 codes.
• Prepared quality test data environment for ICD10 conversion project.
• Coordinated the release with the DBA’s, business owners and ensured database objects deployed correctly.
• Experience in implementation of HIPPA 276/277 Claim Status Request & Response transactions, knowledge of EDI 837, 835 transactions set format.

Confidential, Smith Barney, New York, NY

Consultant

• Data mapping, new expanded Database Architecture review and design sessions.
• Created data mapping specifications, Use Case, Activity, State Transition, and Data Flow diagrams using various modeling techniques.
• Proactively coordinating with business and development team to simulate the critical defects found during testing and production implementation.
• Database design. Creation of DDL’s (DB2), using WinSQL, working with DB2 utilities, MQ Series.
• Communicated to offshore team the requirements to fix data issues in production.
• Created test scripts including specific test cases and expected results to conduct unit, integration, regression, functionality and UAT testing.

Confidential, Weehawken, NJ

Consultant

• Technical design and development for the new product account enrollment and terminations processes.
• Performing QA and Production Support for the systems Front End.
• Database design. Creation of DDL’s (DB2), using WinSQL, working with DB2 utilities, MQ Series.
• Creating Stored Procedures using Store Procedure Builder.
• Participating in unit, integration, regression, functionality and UAT testing

Confidential, New York, NY

Consultant

• Used various modeling techniques to create Use Case, Activity, State Transition, and Data Flow diagrams.
• Participated in JAD sessions with stakeholders and project directors.
• Analyzed the application systems and created flowcharts, specs for Batch and On-Line programs, which would use Message Queuing Interface to perform conversation between programs.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Worked with the development team during the design phase to ensure usable, technically accurate, optimal solutions
• Created test scripts including specific test cases and expected results.
• Worked with Quality Assurance team to ensure an easy translation of requirements documentation into test scenarios.
• Participated in UAT planning and execution including the documentation and assistance in the execution of test scripts.

Confidential

Consultant

• Numerous API (DB2) programs was written, work with applications in a data sharing environment
• Coded and modified numerous CICS programs.
• Utilized RUP to configure and develop process, standards, and procedures.
• Database design and implementation
• Design and implementation of web based EQ Access System MQ Architecture
• Assisted QA team in developing test plans and relevant test scenarios
• Participated in unit, integration, regression, functionality and UAT testing

Confidential

Programmer Analyst - Consultant

• Interacted with users to translate business requirements into program specifications
• Compiled data dictionary for new Trade Surveillance system
• Performed data mapping during migration of data from the legacy to the new system
• Relied on Use Cases as a basis for creating a Role Matrix identifying suitable access authorization for each user
• Technical design and development of the system
• Conducted team briefings
• Created test scripts including specific test cases and expected results
• Assisted in the organization and delivery of storyboard presentations

Confidential, New York, NY

Programmer Analyst - Consultant

• Designed System charts, program specifications, coded, tested and implemented
• Designed web based screens and coded them
• Maintained release summary logs and test scripts
• Coordinating efforts of 2-4 software developers, user testing
• Designed and coded programs which would use Message Queuing Interface
• Design and implementation of significant additions to the NT FA Statements system
• Conducted quality testing of application changes and enhancements

Confidential, New York, NY

Programmer Analyst - Consultant

• Member of a team responsible for the re-design of the Gemini General Ledger system. The Gemini system reconciles and reformats data feeds (flat files) from the major insurance companies before feeding into the DB2 database for the PeopleSoft General Ledger module. The Gemini system holds invalid data feeds and allows correction of the data via its on-line components.
• Activities included coding and testing the current COBOL programs (both batch and on-line), QMF reporting procedures and batch jobs along with data analysis of current data held in DB2 database, conversion COBOL/IDMS programs to DB2.

Confidential, New York, NY

Programmer Analyst - Consultant

• Involved in the redesign of the P & S System. This system provided professional management of investments and financial assets such as stocks. The system consisted of various on-line and batch programs. Worked on Bookkeeping and Money Movement Systems. The systems were fed data from on-line data entry applications, a purchase and sales feed through P & S batch and a feed from the DTC, SIAC and Pricing reference Data from Bloomberg, Thompsons. Responsible for the system analysis, program design, coding, system integration testing, implementation into production and post implementation support. Also responsible for creating program specifications and modifying the CICS/DB2 programs. The systems were written using COBOL/COBOL II, CICS accessing DB2 and VSAM databases.

TECHNICAL SKILLSL

MS Office products, Visio. COBOL, DB2 Stored Procedures/DB2 Utilities, CICS Command Level, DB2/SQL, QMF, VSAM, QSAM, TSO/ISPF, INTERTEST, XPEDITER. FILE-AID/DB2, ChangeMan, TMON, Abend-Aid, OS/Utilities, MVS JCL & Utilities, Sync Sort, ENDEAVOR, CICS, MS Access, PLATINUM, MQ Series, Visual InterDev, XML, XSL, Java Script. Stored Procedure Builder, WinSQL, ORACLE, SQL Server Management Studio, IBM Rational Clear Case, Rational Requirements Composer/RTC.