Twenty + years of experience in the field of computer sciences. System integration, software installation, full life cycle system design, development, coding, customization, conversion, software reengineering, unit testing, stream testing, operational system testing, integration testing, QA, production support, disaster recovery, change management control, System Architect, relational data base design..
Strong in SQL SERVER, ORACLE, DB2, SQL, QMF, CICS, IMS, VSAM, COBOL II, SAS, SAS MACRO, SAS/AF, SAS/CONNECT, SAS/SQL, EASYTRIEVE, DYL280, ENDEVER, SYBASE, UNIX, SHELL Script, UCC11, UCC07, CA MASTERPIECE Accounting Software, General Ledger, Accounts payable, Fixed Assets, Procurement, Payroll, Financial, Banking, and Mortgage applications.
ORACLE, SQL PLUS, PL/SQL, SQL FORM, ORACLE developer 2000.
SQL SERVER 2005, T-SQL, SSMS, SSIS. MS ACCESS VISUAL BASIC, HTML, Crystal Report XI, ODBC.
DB2, QMF, SPUFI, SQL, COBOL II, CICS, VSAM, VSAMAIDS, ENDEVOR, IMS/DB, UCC11, VISIO, ABC FLOW, EASY FLOW,EASYTRIEVE,DYS280.
DATACOM/DB, DUN & BRADSTREET ACCOUNT SOFTWARE, CA MASTERPIECE ACCOUNTING PACKAGE., UCC11, UCC07.
UNIX SHELL SCRIPT, Algorithmics SOFTWARE AUTOSYS, CLEARCASE/CLEARQUEST, RAPID SQL, SYBASE,
SAS, SAS MACRO, SAS/ACCESS, SAS INTRANET, SAS/AF, SAS Report works.
RAPIT SQL, MYSQL,T-SQL, ORACLE SQL, SYBASE SQL, DB2 SQL, TERADATA SQL, CDW DATAWARE HOUSE SQL.
FINALST and SEARCH SOFTWARE AMERICA(SSA)
MVS/ESA, MVS/XA, PC/DOC, DOS?VSE, WINDOW NT, MICROSOFT 95, VM, UNIX/AIX, TERADATA ,MIS , Z/OS 890 , .NET.
IBM 3090, 370, AS400, UNIX SOLARIS, TERADATA , CDW computer, CDC.
M.S. degree, computer science,
Confidential– data base developer/SAS developer
April 2009 - present
- writing test script, test case, business requirement into test case, write technical requirement, business analysis, problem shooting,
- Counter party mortgage insurance reconciliation, adhoc reporting, single family system support, UAT test, integration test, test plan. Regression test data extraction from ORACLE, SYBASE Data warehouse.
- SAS BI server and ORACLE Data Warehouse SERVER.
SYBASE, ORACLE, SQL PLUS, PL/SQL, UNIX, MYSQL, PC SAS, SAS MACRO,
SAS/CONNECT,MS ACCESS, SAS/STAT.
CLEAR QUEST, VISIO, ORACLE Data Warehouse.
SAS DI /ETL STUDIO
SAS Management Console
SAS Information Map Studio
SAS enterprise/store process
Confidential–SQL server developer/Data Analyst
Jun. 2008 – Mar. 2009
- Support clients Medicare Plan D, WEBPDE custom drug claim system ,Create PDE file for submit to CMS (Medicare) Plan to Plan transfer process ADHOC reporting , Drug Benefit Eligibility Analyst reporting, Reconciliation of Drug Claim LICS (low income Medicare process).
- Develop Crystal report post to Web, create SQL procedure, setup execution procedure,
- Audit claim files. Reconciliation Claim file and fixed data.
USING: SQL server 2005 , SSIS, SSMS, SQL , Store procedure, Crystal report XI , MS Access ,DB2, SAS.
Confidential– Sr. IT SPECIALIST/SAS expert
Apr. 2006 – May 2008
- Medicaid/Medicare application production support, technical analysis and development Prescription Drug MARx system, Part B,C ,D Enrollment and payment system.
- Compare data /tables element to element from database to database. Interface Social Security Administration (SSA) Data with MARx.
- Data conversion, AdHOC reporting, Convert end user system to production. Full enrollment /Payment reconciliation/Quality Assurance
USING: IBM Mainframe DB2, SPUFI,SQL, SAS,TSO,MVS/XA,BMC software, REXX, CLIST,QMF, COBOL ,Z/OS, MQ series.
Confidential - It specialist/TERADATA/DB2 conversion
Feb 2002 - Oct 2002
- Data conversion From TERADATA To IBM DB2 system Perform a key roll as a computer specialist and DBA ,
- Redesign and Convert current database tables, create DDL, create table, tablespaces, Partition tables, export data from Teradata, using BTEQ, XPORT, Convert application software, command code ,Macro, to DB2, Also using two vendor software
- FINALST and SEARCH SOFTWARE AMERICA to generate ZIP code and search Keys. Convert 350 million Records for a single table, total 12 tables.
USING: DB2, COBOLII, SQL, TERADATA SQL, BTEQ, MACRO, Vendor software SSANAME software and FINALIST. IDCAMS, SYNCSORT, PC software, FTP, ENDEAVOR, SAS,SAS MACRO, XPORT,DB2 utility download and load, CICS, ENDEAVOR.
Mar 1994 - Nov, 2001
- Data Warehousing, system analysis, requirement, design, coding. Reconciliation, testing, integration, ad hoc reporting.
- Application -single family, acquisition loan processing, quartile Fix rate, market shares including FreddieMac loans. Extract data from ORACLE database,
- FTP to Mainframe vice versa. ORACLE DBA, table load and backup/recovery, Quality Assurance. Support user 500 tasks/reports per year.
- Data conversion converts from old legacy system to new Express Track system,
- Extract production customer BTN (phone number) as a driver, posting /convert To the baseline system, function including nightly data base refresh cycle,
- Financial data process cycle for different jurisdiction such as VA, MD, NJ, PA, DA, large business and small business.
- Major responsibility was system testing and QA using life data, new modules, and life cycle process test, UAT,REGRESSION Test, Full Volume Test
- Y2K project using Princeton aging tool, and DB2 MOVE aging tool to age data from 1998 to the year 2000 for integration test of SALLIE MAE Mortgage system. Y2K Re-mediation of the current software for Y2K compliance. Such as Date conversion, date calculation and date formatting. Etc. Develop DB2
- SAS Programming to age 57 million records database table, including update child tables and date field in the keys. Age VSAM files and flat files -aged around 400+ files in order to run cycle of year 2000 process.. Develop 105 SAS programs to compare the baseline with the post cycle DB2 tables and output files. Disaster recovery testing for IBM software and Utilities.
- Design, Development, enhancement of the MCI billing system, 10XXX and Galaxy casual billing system, production support, problem solving, analysis and Implementation,
- maintaining current billing system by new release, new business requirement, emergency requirement enhancement, phone recycling, pay phone surcharge, transaction process. And . Quality Assurance, create test plan, and testing.
- Team leader in Transfer carrier Electronic Exchange system, provided downstream user the carrier change information, INTER/INTRA exchange transaction process, NPA/NXX phone number order system, development, enhancement, production support, business reporting, Electronic Data Transmission, PIC and 2 PIC database application.
- Support client FREDDIE MAC Performing Loan system, Credit Enhancement Loan system, . YEAR 2000 Prototyping to create company standard, enhancement tuning, system enhancement to reduce processing time frame window, development END-user system,
- FTP/EDI data transmit from IBM mainframe to UNIX server.
- Support Client AT&T the SDN department billing system, enhancement, new release development and maintenance, unit testing, full volume testing, stream testing, code generation using CASE tool, reconstruct the COBOL code to make more efficient.
- Support Central Bank CALL Derivative Banking, Archival Financial item system, integration of finance from Domestic Bank, Foreign bank system, bank examination system, reengineering current system, maintenance of 3 other banking systems, development, problem shooting.
- Support Legal service department, extract the detailed call and credit call records to trace the customer information, statistics analysis and billing reporting
USING: DB2, COBOLII, SQL, TERADATA SQL, BTEQ, MACRO, Vendor software SSANAME software and FINALIST. IDCAMS, SYNCSORT, PC software, FTP, ENDEAVOR, SAS,SAS MACRO, XPORT,DB2 utility download and load, CICS, DATACOM DB, REXX, DB2 FILEAIDS, DB2 utility. IMS, FTP/EDI,CLIST,EXCEL, STERLING Software CASE TOOL, ARMS QA system, MS access, ORACLE.