SUMMARY:

• Result driven, SAS certified senior developer and data analyst, with over fifteen years of experience in design and implementation of various applications.

TECHNICAL SKILLS:

Software: SAS/BASE, SAS/STAT, SAS/REPORT, SAS/SQL, SAS STUDIO, SAS/EG,DB2/SQL/Stored Procedures, DB2/ Utilities, ORACLE, PL/SQL, MS SQL SERVER, SSIS, MS/ACCESS/EXCEL, COBOLII/370/LE, CICS, MQ Series, SPUFI, VSAM, VISTA, OS/JCL Utilities, CICS, TSO/ISPF, W/NT, ADVANTIS, NDM, FTP, CA7, PANVALET, LIBRARIAN, ENDEVOR, CHANGEMAN, INTERTEST, XPEDITER, OMEGAMON, FILEAID, EASYTRIEVE, MVS/ESA, LU6.2 MRO/ISC, C, C++, UNIX, SHELL SCRIPT, R, R STUDIO, PERL, INFORMATICA 9. */10. *

PROFESSIONAL EXPERIENCE:

Confidential, Washington, D.C.

Senior Application/Data Warehouse Analyst

Responsibilities:

• Development, extensive coding and maintenance of SAS MACRO modules in SAS/BASE, SAS/STAT, SAS/SQL, SAS/REPORT, SAS/GRAPH, SAS/ODS, FDR DB2/MS SQL Server updates
• System, Data and technical analysis, creation of documentation and data flow diagrams using VISIO
• Develop solution to migrate FDR DB2 data into MS SQL SERVER using SAS
• Implementation of projects according to SDLC standards, production support, interface with business community, ad - hoc SAS programming, INFORMATICA production support on daily basis

Software platform: z/OS/Windows, DB2 10.5/11, QMF, SAS(v9.3/4), SAS/EG, SAS STUDIO, SAS/BASE, SAS/STAT, SAS/ETS, SAS/ACCESS, SAS/CONNECT, ODS, MS SQL SERVER, SSIS, OS/JCL, QMF, ENDEVOR, MS Products, EXCEL, VISIO, INFORMATICA 10.1

Senior Data Warehouse Analyst

Responsibilities:

• Development of MACRO programs generating forecasting reports, summaries and graphs using SAS/BASE, SAS/STAT, SAS/ETS procedures including SQL, FREQ, MEANS, UNIVARIATE, GCHART, ANOVA, GPLOT, SGPLOT, CORR, GLM, GLMSELECT, REG, LOGISTIC, HPSPLIT, HPFOREST, SURVEYSELECT, STANDARD, FASTCLASS, CANDISC, FORECAST, ARIMA
• Extraction of ORACLE data using SAS modules and COMIT applications for detailed data analysis and verification, using R to ensure data accuracy and consistency, ad-hoc programming
• Load and extraction of DB2 data using DB2 UTILITIES, SAS/BASE, SAS MACRO modules
• Assist QA team in profiling and analyzing the data to identify Data Quality issues.
• Development and automation of new SAS reporting batch cycle in z/OS mainframe environment
• Intensive interface with global business community, SDLC documents, UAT test plans,

Software platform: z/OS/Windows, DB2, ORACLE, SAS/EG, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/REPORT, SAS/GRAPH, SAS/ODS, R, R-Studio, MS ACCESS, EXCEL, VISIO

Senior Application/Data Analyst

Responsibilities:

• Created SAS modules to extract, join, merge and manipulate data, creation of analytical reports, various data listings, summaries tables, and graphs using SAS PROCs, SAS/BASE, SAS /GRAPH, SQL, DATASETS, REPORT, GCHART, GPLOT procedures, ODS
• Creation of SAS MACRO modules, design, development and execution of automated tracking for ICS
• Converted SAS Datasets to various file types, such as PDF, Excel, HTML, RTF, conversion of MVS flat files in to SAS datasets and creation of various SAS reporting batch jobs
• Created ETL mappings, workflows using INFORMATICA 9.1 to transform data from multiple sources including ORACLE data base and flat files to load DB2 tables

Software platform: DB2/SQL, z/OS/Windows, SAS(v9.3), SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/REPORT, SAS/GRAPH, ODS, SAS/EG, DB2 Utilities, INFORMATICA 9.1, ORACLE 11.g, VSAM, SPUFI, OS/JCL, PDX, EXPEDITER, FILEAID, FILEMASTER, VISIO

Senior Data Warehouse Analyst

Responsibilities:

• Data and system analysis, creation and maintenance of SAS batch modules and data listings using SAS/BASE, MACRO programming, SAS/SQL, SAS/GRAPH, PROC REPORT, ODS formats, R, R Studio, from Private Wealth Management Data Warehouse DB2 tables
• Developed MACRO programs generating summaries and graphs by employing SAS various procedures including SQL, REPORT, FREQ, MEANS, UNIVARIATE, GCHART, ANOVA, GPLOT, SGPLOT, CORR, GLM, REG and GPLOT, GCHART to send output to different destinations, such as HTML, PDF, CSV and EXCEL. Profiling and analyzing the data to identify Data Quality issues.
• DB2 tables design, alteration, performance considerations and DB2 UTILITIES in MVS environment
• Data analysis, creation of mapping, integration documents, process flows, technical recommendations
• Created Technical specifications, documentation, flow charts, UAT test plans

Software platform: z/OS/Windows, SAS(v9.3), SAS/BASE, SAS/ACCESS, SAS/MACRO, SAS/REPORT, SAS/GRAPH, ODS, SAS/EG, R, R-Studio, ORACLE 11g, DB2/SQL, DB2 UTILITIES, OS/JCL, VSAM, SPUFI, CHANGEMAN, EXPEDITER, FILEAID, VISIO

Senior Programmer / Data Analyst

Responsibilities:

• New Product Development, full project life cycle using SDLC methodology, analysis, design, architecture and development of new Class Action Notification system (CAN) processing Clients customer position, trading/transactional and personal data, including buy/sell, corporate actions, dividends, exchanges and options transmitted through NDM/FTP. The designed CAN system is based on DB2, SAS/BASE, SAS/CONNECT, SAS/ACCESS, SAS/MACRO, SAS/REPORT, SAS/GRAPH, SAS/SQL, DB2/STORED PROCEDURES, COBOLII/370/LE, CICS, .NET, MQ, UNIX, FTP, NDM interfaces.

Software platform: DB2/SQL, DB2 Utilities, SAS/BASE, SAS/MACRO, SAS/REPORT, SAS/SQL, SAS/GRAPH, COBOLII/370/LE, CICS, VSAM, SPUFI, OS/JCL, PDX, EXPEDITER, INTERTEST.

Senior Programmer / Data Analyst

Responsibilities:

• Full project life cycle using SDLC methodology, analysis, development, enhancements of Outside Mutual Funds(OMF) Global Wealth Management systems, including Broker to Broker, confirmations, activity, dividends position processing, flips, corporate actions, CDSC Lots, transmissions to SIAC, DTCC and SURPAS, Mutual Funds Legal Surveillance system, major firm fund conversions, Compliance support. Design, architecture, development and implementation of NSCC Level Zero industry wide project for Smith Barney OMF utilizing DB2/SQL, DB2/STORED PROCEDURES CICS, COBOLII/370/LE, MQ, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/REPORT, SAS/GRAPH SAS/SQL, FTP, NDM interfaces, heavy ad-hoc SAS reporting.

Software platform: DB2/SQL, SAS/BASE, SAS/MACRO, SAS/REPORT, SAS/SQL, VSAM, OS/JCL, COBOL/370/LE, CICS, SPUFI, EASYTRIEVE, CHANGEMAN, FILEAID, UNIX Shell scripting

Senior Programmer / Analyst

Responsibilities:

• Full project life cycle, SDLC, data analysis, design, development, enhancement of Credit Card Services (CCS) systems as well Insurance systems including Underwriting, Clams, Credit Card Services, GL, Profit/Loss, Personal Property, Life and other insurance products and services including marketing campaigns.
• Design, architecture, development and implementation of Billing Transmission sub-system (BTS), part of CCS utilizing SAS/BASE, SAS/MACRO, SAS/REPORT, SAS/SQL, DB2/SQL/UTILITIES, DB2/STORED PROCEDURES, NDM and FTP interfaces.
• Participated in various insurance projects: PPI Refunds Automation, Service Level Reporting, Underwriting conversion.

Software platform: DB2/SQL/UTILITIES, SAS/BASE, SAS/MACRO, SAS/REPORT, SAS/SQL, PERL, UNIX/SHELL, HTML/JAVASCRIPT DB2/STORED PROCEDURES, COBOLII/370/LE, CICS, VSAM, SPUFI, OS/JCL, NDM, CA7, CHANGEMAN, EXPEDITER, INTERTEST, FILEAID