Data Sql

Leonard Wilkerson

*** ***** *****, ****, ** *****

Telephone: 302-***-**** / Email: ****************@*******.***

Overview:

Over 20+ years providing technical and development support as an Administrator, Business Analysis, Project Manager, Designer/Developer/Programmer, Architect for the US Department of Labor, US Treasury, FDIC, NAVY, World Bank, Freddie Mac, Fannie Mae, National Science Foundation, and Australian Embassy, Dun & Bradstreet, BBVA Compass Bank, Bank of America, Sovereign Bank/Banco Santander, McKinsey & Company, Citi Group, JP Morgan Chase to name a few.

Education:

PhD Candidate in Operations Research, Rutgers University, 1985

MS in Systems Engineering, Howard University, 1984

MS in Computer Science, Howard University, 1984

BS in Psychology, Howard University, 1982

In top 1% percentile in US in SAT & GRE math sections

Member of the Lehigh Valley Chamber of Commerce & the Lehigh Valley Hispanic Chamber of Commerce since 2007

Experience (In terms of Skills):

Skill Years of Exp Skill Years of Exp Skill Years of Exp

SQL 18 VB 6 C 5

Hyperion/Essbase 2 Data Warehousing 12 Harvest 5

MS BI tools 7 Ab Initio 5 FOCUS 10

Fiserv/Foxtrot 2 Informatica 5 SAP 5

SAS 20 COBOL 10 Adabase/Nat 5

Mainframe 16 DB2 UDB 7 Trillium 5

API 2 Sybase 5 Java 3

Syncsort 10 Oracle 16 WebMD 5

Business Objects 5 SUN 7 Toad 7

UNIX 22 AIX 7 Easytrieve 10

Shell Scripting 22 Microstrategy 7 IMAN 1

Linux 7

Detailed Professional Experience:

Freddie Mac/IBM/Artech, McLean, VA & Department of Labor/ Lockheed Martin/Leidos/Net Visions Resources, Washington, DC 05/15 – 10/16

SAS Administrator/Programmer

● Worked as a SAS Administrator responsible for adding users; installing client applications; troubleshooting technical problems; recommending/implementing and tuning SAS GRID programs; interfacing with the SAS Institute for Support on administrative and system issues; acted as a liaison to SAS Technical Support for SAS users.

● Worked as R Studio Server and Tableau Administrator responsible for adding users; installing client applications; troubleshooting technical problems; recommending/implementing and tuning; installed and supported Docker Containerization and Pentaho Kettle Integration; created/updated Risk Assessment; Budget Investment; Project Management; and Project Planning Documentation.

● In addition provided 3 cycles of Disaster Recovery support and testing for the following tools – ARIS; TeamStudio; Appfluent; CDQP Spectrum; Dataflux; Hyperion; Intelliprint; Microstrategy; SAS; DP Protect; and Cloakware.

● Reporting Tools Used: SAS Enterprise Guide, SAS GRID, SAS E Miner; PC SAS ; MS office Products; ARIS; TeamStudio; Appfluent; CDQP Spectrum; DataFlux; Hyperion; Intelliprint; Microstrategy; SAS; DP Protect; Cloakware; R Studio Server; Tableau; Docker Containers; and Pentaho Kettle.

● Environment: UNIX; AIX; Windows; Linux.

Bank of America/Axelon, Newark, DE, 06/13 – 05/15

SAS Administrator

● SAS Administrator for over 3000 customers in Consumer LOBs; assisting users with programming support – optimizing programs; SAS software installs/migrations (PC SAS; PC Files Server; MS SAS add-ins, eminer, etc); Supporting odbc and other importing/exporting of data from Unix to PC; and SAS GRID optimization.

● The direct customer contact and the Enterprise Guide Expert; MS SAS add-in; and all programming best practices; Created/designed numerous technical improvements for accessing data via Data Direct; Odbc; Custom Tasks and Microsoft office products (Access; Excel; Word; Share Point).

● Created invented methods to access and update live Share Point data with in Enterprise Guide; Created programs that embedded SAS reports and/or SAS graphs in the body of an Outlook email. Both of these techniques were provided to the SAS Institute for others SAS users to use.

● Backup support for JMP/AMO; SAS Automation Jobs; SAS outages; Patching; restarts; space and storage for file system and performance capacity planning; Management Console; IMAN.

● Reporting Tools Used: SAS Enterprise Guide 5.1, SAS GRID, SAS E Miner; PC SAS 9.4; MS office Products; Maximo; IMAN; Maestro; MS SQL Server; Data Direct

● Environment: UNIX; AIX; Windows; Linux

US Treasury, Washington, DC, 02/13 – 6/13

Senior ETL Business Analyst; Programmer Analyst

● Supported the Office of Fiscal Responsibility to help improve data quality through data standardization. Creating methods that can assist in improving risk monitoring and insure data integrity. Integrated, modified, and made production ready an application that related to LEI (US), GEI (German) Legal Entity Identifiers.

● Supported the $3 trillion SEC MMF market processing that will support new US rules that will make these funds safer and improve credit and data quality.

● Reporting Tools Used: SAS Enterprise Guide 5.1, SAS DI Studio; SSIS; SharePoint; Jira; Confluence

● Environment: MS SQL Server 2008 & 2012; Linux

BBVA Compass Bank/Apex, Birmingham, AL, 08/12 – 01/13

Senior Business Analyst; Programmer Analyst

● Supported the Comprehensive Capital Analysis and Review (CCAR) supervisory assessment of capital adequacy by the Federal Reserve.

● Supporting strategies for managing capital over a nine-quarter planning horizon, to ensure robust, forward-looking capital planning to handle unique risks and sufficient capital issues so that continued banking operations occur throughout times of economic and financial market stress.

● Provided SAS programming projections that incorporate detailed information about the risk characteristics and business activities and estimates using a consistent approach across all banks.

● Reporting Tools Used: SAS Enterprise Guide 5.1, SAS 9.3; excel; SharePoint

● Environment: Oracle

Bosch Rexroth/Robert Half, Bethlehem, PA 07/12- 08/12

Financial Analyst; Programmer Analyst

● Provided comptroller and information systems support using VB and excel to forecast yearly budgets for the following three years.

● Reporting Tools Used: Excel, VB

● Environment: Microsoft, SAP

McKinsey & Company/Oxford, New York, NY/Florham Park, NJ 06/12- 06/12

Senior Business Analyst; Programmer Analyst

● Provided insight and SAS programming into improving the efficiency of table look-ups for match records within a 1 billion row non indexed table.

● Reporting Tools Used: SAS, UNIX

● Environment: Oracle

Sovereign Bank/Banco Santander/TCML, Reading PA 05/10 – 05/12

Senior Business Analyst; Programmer Analyst

● Subject Matter Expert (SME) in Banking processes & operations

● Involved in improving operational metrics, business case development and performance measurement.

● Designed, maintained, updated, and implemented Opt-In/Opt-Out tracking process for the Bank.

● Handled banking Process Transformation, Process definition, analysis, design, and implementation Requirements definition and mapping.

● Created production ready system-generated reports of all transactions on Sovereign Bank internal accounts.

● Provided reports used in settlement, daily processing, and research and reconciliation of General Ledger accounts.

● Provided internal support for numerous divisions within Sovereign Bank. Direct development affects large number of internal clients, in all aspects-financially, competitively, in customer confidence, and in legal and regulatory.

● Provided On-line system inquiry, Customer Reference File (CRF) updates;

Demand Deposits; Time Deposits; Customer Reporting Systems; General Ledger; and Safe Deposit Box tracking.

● Processed more than 2 million accounts or customer requested maintenance transactions.

● Provided ad-hoc investigative support; design and development for multiple business units on a daily basis for mass maintenance projects.

● Designed, developed, programmed, and implemented Safe Deposit Box

tracking process that retrieves and captures revenue for customers who are 90 days delinquent via other bank accounts; my design and programs generated over $1 million in revenue for the bank.

● Created numerous methodologies; computer programs; and applications that provided cost savings for the bank.

● Reporting Tools Used: SQL (Informant - Hyperion), MS Access, MS Excel, Foxtrot, Fiserv

● Environment: Oracle data warehousing technology, SQL, Mainframe

Dun & Bradstreet/Matrix, Center Valley, PA 03/08 – 05/10

Senior Analyst; Programmer Analyst

● Designed/redefined process to extract 160 million rows (monthly) of GRP data (Global Risk Profiler - scoring global businesses and corporate linkage information) for large world-wide companies; and EMMA data (emerging markets mediation) – provided methodologies to compare businesses statistically by scores that predict the likelihood of a business being problematic in paying bills.

● Extracted data via API from St. Louis Federal Reserve and EDGAR

I-Metrix data using tags to blend scoring for validations, accuracy, completeness, and timeliness by identifying high-risk accounts and manage risk exposure. In addition, supported FSS (Financial Stress Score) which provides the highest level of predictive performance by effectively leveraging financial statement and national debt rating data.

● Supported clients via translations, scrubbing, and integrating large amounts of data into understandable charts, reports, and/or files.

● Created tools to retrieve SBRI (Small Business Risk Insight) data via numerous tools to support solutions for financial institutions that lend to small businesses, highly predictive lending performance data about prospective small business customers in terms of evaluating credit risk and preventing fraud and conducting customer portfolio monitoring.

● Designed and developed algorithms and methodologies to search and extract vast amounts of data and processing, Created and cleansed data for origination & performance data validation across time periods for Standard and Custom Predictive Indicator reporting.

● Implemented Propensity Deposit Model (Based on Survey of Small Business finances from the Federal Reserve (SSBF) – a method of comparing financial services among firms of differing sizes involving company characteristics as well as banking services and trade aligned with depository information.

● Reporting Tools Used: SQL, MS Access, MS Excel, SAS, Mainframe Tools, API, Business Objects

● Environment: Oracle data warehousing technology, PL/SQL, Business Objects, Mainframe, UNIX, Linux

Sedgwick CMS/ComForce, Memphis TN 11/07 – 02/08

Senior Business Analyst & Programmer

● Designed client/user requirements; created ETL streams using Informatica to extract, manipulate, and interpret insurance claims administration, managed care, program management and related services for large employers such as the state of West Virginia.

● Responsible for programs that assessed insurance carriers and regulatory groups.

● Tested and debugged Informatica programs.

● Reporting Tools Used: SQL, MS Access, MS Excel, TRILLIUM & Informatica.

● Environment: Oracle 10g, Oracle data warehousing technology, PL/SQL, Informatica, UNIX.

HIM On Call, Allentown, PA 07/07 - 11/07

Project Manager

● Responsible for the overall software development process and team for a DocuXP application. DocuXP, a web-based Electronic Medical Patient Record System, that allows users to generate coding, abstracting, and revenue related management reports.

● Developed project plan and time lines by allocating resources, including directing offshore team.

● Managed the testing and implementation of new Java based application.

● Researched and developed best practices for application development and production maintenance.

● Collaborated with development team members on a weekly basis and provided updates to senior staff.

● Tested and validated Java and PL/SQL programs.

● Reporting Tools Used: SQL, MS Project, MS Excel, & Informatica

● Environment: Oracle 9i, Oracle data warehousing technology, PL/SQL, Java, UNIX

Surveillance Data, Plymouth Meeting, PA 11/06 - 07/07

Senior Business Analyst & Programmer

● Designed/redefined client/user requirements; Created pharmaceutical study designs, business rules; performing statistical analysis;

● Created data views/templates and report drafts; creating technical specifications; performing quality assurance checks using HIPAA compliant, integrated hospital/doctor/office/lab/prescription and/or health care claims data to meet pharmaceutical custom analytics business needs.

● Analyzed project requirements, define and instructed project scope, scheduled, work tasks for programmers;

● Managed and reported project status; provided, managed project members tasks and responsibilities; communicated project milestones, risks, and other information; facilitated meeting; analyzed and troubleshot issues; ensured quality of work through designing test procedures;

● Maintained positive relationships among team members including sales, marketing, programming, and testing staff. Programmed in SAS, SQL, MS Reporting Services

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, MS Reporting Services (SSIS), TRILLIUM

● Environment: SAS (including Macros), Oracle 10g, Oracle data warehousing technology, PL/SQL, MS SQL Server, UNIX

Citi Group/Jean Martin, New York, NY 01/06 - 10/06

Senior Consultant/Business Analyst & Programmer

● Designed; developed; implemented; modified; tested; and validated complex banking rules, programs; production systems, algorithms for International Basel II standardization application.

● Managed/programmed/developed the SAS implementation and integration with PeopleSoft, Oracle10g, and MS/SQL Reporting Services.

● Created Reports to show and help analyze country level portfolio data.

● Performed project management task such as scope, scheduling, and reporting issues for the team.

● Lead/managed/developed/programmed the conversion from existing process to the utilization of the Basel II standards using the latest SAS data mapping technology.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, MS

Reporting Services (SSIS)

● Environment: SAS (including Macros), Oracle 10gi, Oracle data

warehousing Technology, SQL Plus, UNIX shell scripting, PeopleSoft

MBNA(Bank OF America)/Sharp Decisions, Wilmington, DE 09/05 - 01/06

Senior Consultant/Business Analyst & Programmer/Developer

● Designed validation methodology for MBNA (Bank Of America), and TSYS portfolio conversions to the Bank Of America credit card portfolio. Provided full life cycle development including testing, documentation, programming and requirements development.

● Reporting Tools Used: SAS.

● Environment: Mainframe, SAS, and VB

JP Morgan Chase/Comsys, Wilmington, DE 01/05 - 08/05

Senior Consultant/Business Analyst & Programmer/ETL Architect/Developer

● Designed; developed; implemented; modified; tested; and validated/correction of complex banking rules, programs; production systems, algorithms for CHASE & Bank1One.

● Made other technological improvements related to the automated scoring engine and mission critical processes for daily, monthly, and quarterly credit card processing (reducing processing time from 23 hours to 2 hours) along with additional merger related credit card activities.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, MS Reporting Services (SSAS, SSIS, SSRS)

Environment: SAS, Oracle 9i, Oracle Data Warehousing Technology, SQL Plus, UNIX shell Scripting, Ab Initio

PJM Interconnection/Endasol, Valley Forge, PA 03/04 - 12/04

Senior Consultant/Business Analyst & Programmer

● Designed and developed applications and reports that support PJM as a regional transmission organization.

● Development involves supporting the reliability of the largest electric grid in North America;

● Provided objective oversight and market monitoring of the operation of electrical markets; examination of transmission congestion costs and the potential for an electrical market participant to exercise undue market power; detection of design flaws in operating rules, standards, procedures and practices, or structural problems in the PJM markets so that they can be addressed.

● Reporting Tools Used: SAS

● Environment: SAS (including Macros), Oracle 9i, Oracle data warehousing technology, Citrix, toad, UNIX, SAS V8, NT, SQL, and Mainframe

ING/Sharp Decisions, Hartford CT 08/03 - 02/04

Senior Consultant/Business Analyst & Programmer/Developer

● Managed the conversion of a production data warehousing application to Informatica Power Center 6 for ING.

● The ETL process was converted to the Informatica extraction, translation, and loading model while maintaining normalization, access paths, and data mapping, conversion, and integrity. Ralph Kimball methodologies were utilized throughout the design to implementation.

● Guided management and staff through the business intelligence integration solution.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, Informatica

● Environment: Informatica Power Center 6, UNIX, SAS V8, Sybase 11 data warehouse, NT, SQL, and Mainframe

Glaxo-Smith-Kline/TAC Worldwide, Philadelphia, PA 01/03 - 07/03

Senior Data Conversion Architect/SAS Analyst/Developer

● Created numerous ad-hoc reports on demand for Glaxo-Smith-Kline.

● Reports created using MicroStrategy desktop; oracle SQL plus 8i data warehouse;

● In house data; MS Access; Excel; UNIX; and SAS V8 for UNIX Reports were across all drugs and were related to counts and market share information.

● Documented and optimized SQL queries ad-hoc reports for sales team/pre-sale support teams. Extracted data from external sources.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, and MicroStrategy

● Environment: IBM, SAS, UNIX, Oracle 9i, WebMD

FDIC/Ciber, McLean, VA 12/01 - 12/02

Senior Programmer Analyst

● Analyzed, developed, designed, and modified programs for mission-critical banking information.

● Developed/maintained programs that evaluated banks in terms of profitability and therefore the ability to survive.

● Developed data cleansing procedures using SQL stored procedures, and Trillium. Conducted project management and database design review on multiple projects.

● Performed day-to-day management of a team (5 people).

● Loaded and extracted data from/to DB2 UDB.

● Developed and implemented testing requirements and documentation for full life cycle analysis. Performed and implemented data scrubbing methodologies via SAS to create standardized data.

● Performed QA and GAP analysis.

● Environment: IBM, NT, SAS, SQL*Plus, PL/SQL, SQL, COBOL, DB2 UDB

MCI(WorldCom,Verizon)/Comsys, (Remote from Home) McLean, VA 08/00 - 02/02

Senior Consultant/Business Analyst & Programmer/ETL Architect/Developer

● Responsible for the development and maintenance of headquarter financial analysis and reporting for MCI (WorldCom).

● Architect of the technical support for the MCI Friends and Family marketing initiative. Developed numerous ad-hoc reporting tools.

● Trained senior level management on the headquarter reporting process in Pentagon City and Chicago.

● Created SQL, load/extract routines for Data Warehousing initiatives.

● DB2 querying process developed to report on billing records.

● Architect of testing procedures for SAS, FOCUS, DB2, and COBOL development to production migrations.

● Created testing standards for headquarter reporting system.

● Trained management on system functionality; Created all documentation for system and Report generator process.

● Controlled, managed, designed, and implemented all testing procedures

and documentation.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, FOCUS

Environment: IBM, COBOL, SAS (including Macros), FOCUS, VM/CMS, NT, DB2 UDB, Easytrieve, SQL, Oracle 9i, UNIX shell scripting

Concord EFS/SUN Microsystems/Algomod, Wilmington, DE 02/01 - 11/01

Data Liaison

● Analyzed the ATM End Of day process to improve efficiency in terms of program errors, server errors, and other server tuning methodologies.

● Monitored, and improved this process during the migration from IBM mainframe to AIX and then to a SUN Solaris E10000 2.7 server. Oversaw and improved testing migration process to trap programming errors before installation to production.

● Environment: SUN, NT, C, Syncsort, COBOL, and AIX

Freddie Mac/Keane/Princeton Information, Tyson’s Corners, VA 05/00 - 01/01

Data Warehouse SAS Developer/ETL Architect

● In charge of the SAS portion of the Servicers Corporate Data Warehouse initiative (the first Data Warehouse at Freddie Mac).

● Conducted project scope analysis for the SAS development and the SAS user requirements analysis. Assisted in the design of the logical and physical database models for the warehousing system and the star schema.

● Designed and implemented warehouse structure integrated with Enterprise Portal. Developed dimensional models and aggregation strategy for DSS.

● Designed and deployed a SAS daily, weekly, and monthly mortgaging reports accessible via WEB OLAP which allowed user customization.

● Developed data cleansing procedures using SAS and SQL stored procedures.

● Developed repository of data for testing; extracted, transformed and loaded data with Ab Initio tool; collected business requirements and used

Ab Initio graphs to load, populate, cleanse, and process large data sets; advanced knowledge of Metadata validation.

● Processed web server logs that contained mortgaging data, translated data from Sybase, and data from legacy systems via Ab Initio to create new enterprise. Oracle, Db2 UDB, Solaris tools, shell scripting, autosys,

Microstrategy and other business intelligence tools were utilized. Lead a

technical team to implement portions of a data warehouse application.

● Extracted servicer-mortgaging information from Oracle using Ab Initio to move data and transform, integrate, and load into our Sybase, and DB2 tables. Created customized ad-hoc reports via Ab Initio. Conducted performance tuning for the warehousing system. Retrieved and loaded PeopleSoft data into DB2 Oracle tables. Trained senior managers on SAS application and usability. Created numerous C and UNIX shell scripts, triggers, and functions for the production processing of incoming and outgoing data files. Created numerous C and SAS SQL and PL/SQL embedded programs to manipulate the mortgaging analysis process.

● Tested, designed, and developed all testing procedures and created all documentation methodologies for harvest migrations, and SAS embedded PL/SQL code migration to production.

● Reporting Tools Used: SAS, SQL, Microstrategy

● Environment: SUN, NT, Oracle 8i, DB2 UDB, Sybase 10/11.x, PeopleSoft, SAS, Microstrategy, C, UNIX Shell Script, Ab Initio, SQL, PL/SQL, Harvest, IBM, COBOL

Calypso Online, Sterling, VA 09/99 - 04/00

Senior Software Engineer/Programmer

● The Architect of the commission’s process. Provided additional Oracle

data solutions for statistically tracking customers, likes/dislikes; Loaded information into an Oracle Data Warehouse.

● Created Web pages for stores. Object oriented programming features were used.

● Managed the testing procedures that were carried out by subordinates, including documentation, web page requirement analysis.

● Reporting Tools Used: HTML, Crystal Reports

● Environment: Toad, UNIX, SUN, NT, Oracle 8i, Java, JavaScript, Shell

Script, C, SQL*Plus, SQL, Seagate Crystal Report, and Linux

World Bank/TAC Worldwide, Washington, DC, VA 03/99 - 08/99

Senior Data Conversion Architect/SAS Analyst/Developer

● Maintained and converted a World Bank PC/Mainframe system from FOCUS to SAP.

● Assisted all worldwide users with their monthly headquarter reporting process.

● Performed system functionally analysis, feasibility and forecasting analysis.

● Created FOCUS and SAP reports during conversion.

● Reporting Tools Used: SAP, MS Access, MS Excel

● Environment: IBM, FOCUS, SAP

Freddie Mac/Keane/Princeton Information, Tyson’s Corners, VA 03/96 - 02/99

Data Warehouse SAS Developer/ETL Architect

● In charge of the SAS portion of the Servicers Corporate Data Warehouse initiative (the first Data Warehouse at Freddie Mac).

● Conducted project scope analysis for the SAS development and the SAS user requirements analysis. Assisted in the design of the logical and physical database models for the warehousing system and the star schema.

● Designed and implemented warehouse structure integrated with Enterprise Portal. Developed dimensional models and aggregation strategy for DSS.

● Designed and deployed a SAS daily, weekly, and monthly mortgaging reports accessible via WEB OLAP which allow user customization.

● Developed data cleansing procedures using SAS and SQL stored procedures.

● Developed repository of data for testing; extracted, transformed and loaded data with Ab Initio tool; collected business requirements and used Ab Initio graphs to load, populate, cleanse, and process large data sets; advanced knowledge of Metadata validation.

● Processed web server logs that contained mortgaging data, translated data from Sybase, and data from legacy systems via Ab Initio to create new enterprise. Oracle, Db2 UDB, Solaris tools, shell scripting, autosys, Microstrategy and other business intelligence tools were utilized. Lead a technical team to implement portions of a data warehouse application.

● Extracted servicer-mortgaging information from Oracle using Ab Initio to move data and transform, integrate, and load into our Sybase, and DB2 tables. Created customized ad-hoc reports via Ab Initio. Conducted performance tuning for the warehousing system.

● Retrieved and loaded PeopleSoft data into DB2 Oracle tables. Trained senior managers on SAS application and usability. Created numerous C and UNIX shell scripts, triggers, and functions for the production processing of incoming and outgoing data files. Created numerous C and SAS SQL and PL/SQL embedded programs to manipulate the mortgaging analysis process.

● Tested, designed, and developed all testing procedures and created all documentation methodologies for harvest migrations, and SAS embedded PL/SQL code migration to production.

● Reporting Tools Used: SAS, SQL, Microstrategy

● Environment: SUN, NT, Oracle 8i, DB2 UDB, Sybase 10/11.x, PeopleSoft, SAS, Microstrategy, C, UNIX Shell Script, Ab Initio, SQL, PL/SQL, Harvest, IBM, COBOL

Fannie Mae/Verizon/TAC Worldwide, Wash, DC & Silver Spring, MD 03/95 - 02/96

Senior Data Conversion Architect/SAS Analyst/Developer

● Designed and developed analysis tools to support Fannie Mae in their automation of the appraisal process.

● Created SAS ad-hoc reporting process.

● Decoded street data programmatically from Dun and Bradstreet and in house data. Provided full life cycle testing for all SAS development for the department.

● Designed and developed analysis tools to support the payphone division for Verizon.

● Feasibility studies concerning payphone locations were determined by this reporting.

Reporting Tools Used: SAS, SQL, MS Access, MS Excel

● Environment: IBM, FOCUS, SAS V8 (including Macros), UNIX, Oracle

Mobil/Exxon/Comsys, Fairfax, VA 04/94 - 03/95

Senior Consultant/Business Analyst & Programmer/ETL Architect/Developer

● Created the LUBE reinvestment System which tracked $20 Million in

loans for Mobil/Exxon.

● Mobil/Exxon lent these monies to oil changing facilities.

● Manned the world wide payroll system for Mobil.

● Trained management on system functionality; Created all documentation for system and Report generator process.

● Controlled, managed, designed, and implemented all testing procedures and documentation.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, FOCUS

● Environment: IBM, COBOL, SAS (including Macros), FOCUS, VM/CMS, NT, DB2 UDB, Easytrieve, SQL

Litton PRC, VA 11/93 - 03/94

Senior Consultant/Business Analyst & Programmer

● Designed and developed a FOCUS of Windows menu driven process.

● Reporting Tools Used: FOCUS

● Environment: IBM, and PC FOCUS

NAVY, Tyson’s Corner, VA 03/93-11/93

Data Architect/Programmer

● Converted Mainframe FOCUS system to SUN Solaris UNIX FOCUS.

● Environment: FOCUS and UNIX

Computer Learning Center, Alexandria, VA 11/92 - 06/93

Senior Instructor (Evening)

● Taught UNIX, C, and shell scripting to senior level students.

● Environment: HP, IBM, SUN/UNIX, FOCUS, UNIX Shell Script, C

Australian Embassy, Washington, DC 05/91 - 12/91

Senior Instructor (Evening)

● Taught Word Perfect to staff.

● Environment: PC and Word Perfect

MCI (WorldCom)/Comsys, Pentagon City, VA 03/91 - 02/93

Senior Consultant/Business Analyst & Programmer/ETL Architect/Developer

Responsible for the development and maintenance of headquarter

financial analysis and reporting for MCI (WorldCom).

● Architect of the technical support for the MCI Friends and Family marketing initiative. Developed numerous ad-hoc-reporting tools.

● Trained senior level management on the headquarter reporting process in

Pentagon City and Chicago.

● Created SQL, load/extract routines for Data Warehousing initiatives.

● DB2 querying process developed to report on billing records.

● Architect of testing procedures for SAS, FOCUS, DB2, and COBOL development to production migrations.

● Trained management on system functionality; Created all documentation for system and Report generator process.

● Controlled, managed, designed, and implemented all testing procedures and documentation.

● Reporting Tools Used: SAS, SQL, MS Access, MS Excel, FOCUS

● Environment: IBM, COBOL, SAS (including Macros), FOCUS, VM/CMS, NT, DB2 UDB, Easytrieve, SQL, UNIX shell scripting

AT&T/Lucent/Bell Labs, Piscataway, NJ & Parsippany, NJ 12/89 - 03/91

Member of Technical Staff

● Designed and implemented a financial application for billing information using FOCUS and Informix.

● Programmed in FOCUS, VM/CMS.

● Reporting Tools Used: FOCUS

● Environment: IBM, FOCUS VM/CMS and Teradata

SONY, Park Ridge, NJ 12

Contact this candidate