Sas Institute Independent Consultant
Resume:
Ejan Addy
**** ***** *** *** ***, Takoma Park MD 20912
****.****@*****.***
Summary
Experienced professional with 10+ years of Technology experience in design, development, testing, access and control documentation. Excellent leadership, training and project management skills with projects.
Technical Expertise
Platform: Windows 2000, XP, 2003, UNIX Solaris, Red hat, AWS
Programming tools & languages: SAS, C/C++, Python, PHP, bash script, HTML, SQL, PLSQL, MySQL, Oracle, DB2, AWS Redshift (Spectrum), AWS Glue, Tableau
Communications: Internet Explorer, Firefox, Lotus Notes, Skype,
Experience
Independent Consultant/Contractor 01/2021–Present
SAS/PythonConsultant
Analyze SAS codes used for models, model data preps, and HIVE tables, to build requirements for PySpark developers. Provide comparable SAS to Python conversion in terms of SAS procs and how the process can be replicated in Python/PySpark.
Debug PySpark code and provide solution/design to the developers. Provide guidance, process improvement to developers, testers, business stakeholder including CMA, FE, CDW et all and management.
Develop using SAS Studio on Viya platform code for a processing engine use to make credit decisions.
Partner with various teams based on their research needs to build pipelines that feed their models using Pyspark, HIVE
Perform data validation, data mapping, and sanity checks, to ensure that the true data source is accurate.
Benched marked SAS Viya performance using SAS CAS against the SAS grid lsf data processing. On the SAS Viya platform using SAS studio to build datasets to supplied SAS VA. Use the proc fcmp on the platform to interface with python.
Provided analytical/implemented solutions in SAS/Python for clients such as Freddie MAC and KPMG(DOD).
Office of the Comptroller of the Currency, Washington, DC 08/2017– 12/2020
Financial Analyst, Economics Division
Responsible for various data products that are used by the economists are generated in timely fashion (e.g. loan level data from the Federal Reserve, Agency data, vendor Home Price Index data, and vendor private label MBS loan data). Including providing analytics related the products above and others.
Partnered with economists on their research needs (e.g. generate loan delinquencies and extracting/normalizing XML data, using SAS grid/viya, Python and BASH scripting).
Participated in technical evaluation of vendor data and developed ETL using SAS, BASH, and Python
Assisted economists, research analysts, and fellow financial analysts with their coding questions.
Tested AWS (Glue, Redshift, SageMaker, Athena, and Quicksite) for proof of concept for moving production environment to the cloud. Explored Machine Learning on the Sagemaker Platform to predict delinquencies using XGBoost algorithm with Fannie data.
Department of Treasury TIGTA Washington D.C 08/2015 – 08/2017
Information Technology Specialist
Provided technical guidance and approaches to data analysis for Auditors using SAS, Excel, Access and other tools.
Conducted information technology tasks such as extracting, formatting and analyzing data in an IBM mainframe, DB2, SAS and Sybase database environment; and Utilization of SAS, JCL, SQL and/or XML for reading data, preparing reports, etc.
Support end-users to ensure proper access controls and understanding of technology implementation
Developed and automate data processing processes along with various multi-layer maps using SAS mapping tools which include SAS graphs, ODS, geocoding, in additional to other technology aspects.
Department of Commerce Suitland Maryland 08/2012 – 08/2015
Information Technology Specialist
Evaluated, proposed, and implemented solutions for data intake, ETL, statistics report, module and best option for optimal performance for Standard Economic Processing Systems II (STEPSII). Release 1 in production as of September 2014.
Scheduled and conduct meetings as needed to flush out ideas and maintain schedules as it relates to modules, environment, and configuration.
Supported end-users to ensure proper access controls and understanding of technology implementation
Analyzed and develop, multitier applications systems known as STEPII using SAS macros, SAS web services, stored procedures, SQL, PLSQL which communicates with java web services.
Administered and supporting the implementation, install, and configuration of SAS® EBI and SAS® Grid solutions on a server architecture running under Blade servers RHEL5, using JBOSS as the middle tier with SAS/ACCESS configuration to Oracle 11G database.
Citi / Randstad, Baltimore Maryland (contract) 03/2012 – 8/2012
Risk Management Application Consultant
Developed data infrastructure strategies and innovations need for production risk tools risk processes using SAS, EXCEL and ACCESS.
Lead initiatives on Basel II data quality management, model generation, and risk parameter framework.
Scheduled and conduct weekly team meetings, mediator for team conflict resolution and different stake holders, served as project manager for Basel II.
Produced reports / analysis for tracking sourcing and performance used setting business direction and for portfolio policy changes.
Designed and complete MIS and reporting using SAS, Excel Unix in support of ad hoc requests from the business users, regulatory agencies, and/or other audit entities which included CCAR, Stress testing model validation testing, scorecard and dashboards.
Comsys, Arlington VA (contract) 06/2011 – 2/2012
Consultant
Using SQL, SAS Base and SAS Macro update data diagnostics to comply with Early Retirement Reinsurance Program known as ERRP requirement which led to my clients receiving over 40 million dollars in reimbursements.
Integrated data from multiple medical and drug providers and performing root cause analysis.
Performed data cleansing, preparation, reporting using SQL, SAS ODS, and SAS GRAPH and EXCEL for project managers and Clients, along with data analysis.
Developed, documenting, and communicating concepts and processes used within the team, while contributing ideas for internal improvements.
Produced reports, created layout for data intake and mapping for processing.
2020LLC/CSC, Baltimore MD (contract) 01/2011 – 06/2011
Consultant
Lead development, of new SQL & SAS report modules and enhancements to existing report modules for PQRI based on requirements using SAS MACRO, FORMATS, TRANSPOSE, FREQ, TABULATE, APPEND, SAS PROCS, PROC SQL, SQL, ODS, bash script on a Unix platform accessing Oracle database which resulted in the of creation of management reports and graphs used by Center of Medicare and Medicaid Services for evaluation of the impact on locals, procedures, doctors, hospitals and additional facilities.
Represented our organization during technical discussion with CMS, and other contracting firms. Ensuring my organization technical needs and CMS vision align while putting us on strong footing.
Gathered information for report design, participated in setting up the development environment for the vanilla SAS DEV and SAS BI DEV.
Hewitt Associates, Atlanta GA 09/2007 – 10/2010
Programmer Analyst
Performed analysis, development, modifies and maintain existing & new SAS programs, test, deploy and documents SAS SQL programs following published standards (SDLC) in a cross-functional environment.
Analysis and technical design or enhancements to existing systems using, SQL, SAS MACRO, BASE SAS, SAS PROCS, PROC SQL, ODS, SQL, JCL CICS on a Mainframe platform accessing DB2 database (including SPUFI) which resulted in the of creation of scorecard, dashboard, reports, data mapping and more.
Participated in the preparation of time estimates for SAS programs which resulted in project meeting the deadline within budget planned.
Tested all SAS programs thoroughly following standard guidelines. Provided on-call support to production systems during off hours of SAS programs.
Reynolds & Reynolds, Duluth GA 06/2004 – 08/2007
Programmer
Database programming for the IBM Universe data server to maintain system software code on Linux platform. Use of tcl (terminal control language and xml).
Partnered directly with the user to assemble custom requirements.
Remotely trained and assisted Finance Managers in proprietary software usage. Garnered In-depth knowledge of the Finance and Insurance industry provided customer service to internal and external clients.
Education & Training
Southern Polytechnic University, Marietta, GA. MS, Information Technology -2013
State University of New York at Buffalo, Buffalo, N.Y BS, Computer Science 2004
Learning Tree Hadoop Administration
ESI International Project Planning Analysis and Control
SAS Institute DS2
SAS Institute SAS Platform Administration:
FastTrack
SAS Institute EM and Text Analytics
Tableau Tableau I and Tableau II
Contact this candidate