Data Analyst Software Developer

BENJIE PLOTCH

** ******** **** *********, ** ****7

631-***-**** 631-***-**** (alternate) ******.******@*****.***

https://www.linkedin.com/in/benjieplotch/ United States Citizen

Business/Technical Analyst – SAS Programmer

Profile: A results driven Business & Data Analyst with Private and Public sector experience across multiple industries.

A problem solver who uses an array of business tools and visualizations, collaboratively creating technical solutions

across multiple departments. A certified SAS programmer with extensive experience writing SQL queries on

multiple platforms (PC Windows, UNIX, SAS Enterprise Guide, SAS Studio).

Work Experience

Wells Fargo, Charlotte, NC (Contract position) 2023 – 2025

Senior Lead Analytics Consultant (Customer Remediation Data and Analytics)

• Working on the remediations, determining the impact of customers’ financial inaccuracies and applying adjustments

• Upgrading and streamlining the SQL Code with 25% more efficiency with enhanced functions and macros.

• Gathered multiple formatted remediation documents and developed the User Guide Documentation & Instructions

• Trained members of my team in the steps required from these SAS, Excel, CSV, and PDF Files

Bank of America, Charlotte, NC (Contract position) 2022

Business Analyst/Software Developer – Global Financial Crimes Technology Unit

• Wrote SQL queries in TERADATA and SAS EG identifying key fraudulent activity attributes in the SAS models

• Migrated the SAS legacy the Global Wire Fraud models completing regression testing for their migration into Hadoop

• Worked in an Agile Environment in short term sprints accessing the Metadata in mapping out the required attributes

AmeriHealth Caritas, Philadelphia, PA (Contract position) 2021

Software Developer – Enterprise Solutions

• Worked with SAS Enterprise Guide to determine the key variables and names in the company’s SAS programs

• Worked on compiling an inventory list of these programs for a possible migration with other software alternatives

United States Bureau of the Census, Suitland, MD (Contract position w/Public Trust Clearance) 2019 - 2021

Software Developer - Methods and Matching Operations, Post Enumeration Survey Team

Worked with samples of the US population independent of the 2020 Decennial count, testing new statistical methodologies with the goal of improving the rate of linking unmatched people with correct addresses

• Optimized run time with more efficient coding techniques – using hash tables, and substituting flexible excel

layouts within the SAS Code for the fixed length input files and applied advanced macro functions.

Wrote SAS code implementing scoring grades combining names, demographics, and geographic distances

Wrote Python Programs to create output for the geographic categorized data

Healthfirst, NYC, NY 2006 – 2019

QC Analyst/Software Developer - Information. Management & Administration

Wrote PROC SQL Queries to extract data from Oracle and SQL Server databases for CCMS & MHS data pull projects.

Created ad-hoc keyword search SAS Programs to for the Hospital Administration Department

• Designed the Functional Specifications, Test Plans and wrote the SAS programs utilizing the Output

Delivery System (ODS) to implement a series of Medical Audit Reports following HIPPA, PHI, and other privacy

guidelines in collaboration with Project Managers and the Network Management Team

• Developed SAS Cost and Utilization Reports to calculate Profit and Deficit Ratios for Medicare & CHP patients

• Worked with Agile Sprint User Stories, identifying ICD10 revisions for Diagnostic and Procedure Code Reporting

• Developed the Tableau Dashboard and Excel Runbook using Pivot Tables and VLookups

BENJIE PLOTCH

60 Wesleyan Road Smithtown, NY 11787

631-***-**** (cell) 631-***-**** (alternate) ******.******@*****.***

https://www.linkedin.com/in/benjieplotch/ United States Citizen

Additional Work Experience

United States Bureau of the Census, Suitland, MD (Contract position) 2005 – 2006

Software Developer/ Longitudinal Employer Household Dynamics

Developed SAS programs and mapped State Labor Market Unemployment records using ArcView (GIS)

Created demographic and quarterly workforce indicators, and adjusted records falling outside their census tracts

Wells Fargo, Frederick, MD (Contract Position) 2004 - 2005

Software Programmer – Mortgage Division (Automated Decisioning Solutions – Modeling Group)

Wrote SAS/SQL macro programs in SAS Enterprise guide to apply rules code for the FREDDIE MAC and

FANNIE MAE government subsidized Non-Conforming Institutional Lending and Retail Central Processing Loans

Graded Loans with Probability of Default Categories – and subgrades (Caution, Accept, High Acceptance)

Created SAS data sets and utilized the Standard and Poor’s Simulator to assign Risk Grades for the loans

Technical Skills

Programming: SAS Certified Base Programmer, SAS Enterprise Guide, TERADATA, Macros, Python, Arcview, Tableau, Data Visualizations, Desktop Mapping, Geographic Information Systems (GIS);

Software: Reflections X, MS Office Suite, WORD, PowerPoint, Excel (Pivot Tables and VLookups), Sharepoint, SQL, JSON

Project Management Systems: Service Now, Version One, Agile, ALM, HelpStar;

Database Systems: Oracle, SQL Server, Clinical Care Management Systems (CCMS) Managed Health Systems (MHS)

Education:

Hunter College, NYC, NY

M.A. Degree in Geography

- Wrote thesis titled “Estimating Phosphorous Export in Three Croton Stream Basins of the NYC Water

Supply Using a Geographic Information System ”

- Used ARCINFO & SAS STAT Stepwise Regression and other statistical methods in the calculations of the

phosphorus non-point source pollution runoff

Central Connecticut State University, New Britain, CT

B.S. Degree in Accounting

Certifications:

SAS Certified Base Programmer

Contact this candidate