ABHISHEK SHARMA

Software Engineer II

Truist Financial, Atlanta

• Worked on multiples projects with the head of the departments in business banking. Primary responsibility includes performing data processing for the execution of the complex marketing campaigns.
• Business issue, Analyzing variable distributions, Data cleanup ,Inconsistencies , Outliers , Conversion to meaningful categorical variables, Analysis of independent variables with dependent variables.(Base SAS, SAS OLAP Cubes , SAS Studio , ETL)
• Created combination variables, Change the values of the variables from descriptive categories to numerical categories, analyzed error rate , ran different predictive models on test sample , identified the best performing predictive model, Identified the equation , Translated into meaningful business rule and success rate of the model.(Base SAS , SAS/Graph,SAS/ODS,SAS/Macros, Proc SQL/MEANs/Logistic.SAS EM and SAS Studio)
• Creating and modifying reports, Optimize each of the main variables, Scenario Analysis for each of the key variables , Excel template for changing the cost values,Scenarios analysis fr achieving different eligibility or denial rates, Cost impact , Margin impact , Net Profit and loss effect( SAS/GRAPH,SAS/ODS,SAS Macros,Proc Plot )
• Analysis of Business Requirements Document (BRD) and Functional Business Requirement document (FRD).
  • Developed and maintained data preparation and validation routines to support the reporting of cost information.
  • Reviewed and analyzed trends in current portfolio populations and recommended verification strategies.
  • Provided analytic support for cross-channel fraud and verification, operating losses, verification strategies, fraud risk assessments, and other product strategies to ensure goals and objectives are satisfied.
  • Developed complex programming models to extract data and manipulated databases to support verification strategies for reporting/analysis.
  • Built scorecards for credit risk analysis and regression models for analysis of the relationship among variables.

• Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing, segmentation, scoring, and list management purposes.
  • Drew flowcharts indicating the input data sets, sorting and merging techniques.
  • Wrote code using SAS/base and SAS/macros to extract clean and validate data from a flat file, excel file, RDBMS, access database, and Oracle database using SAS ETL and DB load processes.
  • Extensively using do loops, array, and SAS/stat to manipulate numerical data and scientific data.
  • Design, develop, and implement data warehouse solutions using ETL tools (e.g. Abinitio , Cognos , Tableau)
  • Involved in creating Dataset Specifications (DSS) for creating analysis datasets.
  • Imported data from excel documents to SAS datasets using Dynamic Data Exchange (DDE) utility.
  • Created SAS macros for generating similar types of tables and listings for demographic, disposition, different types of adverse events, lab shift, vital signs shift, lab marked abnormalities, the extent of exposure, time to an event etc.
  • Validated (QC) and documented the competing codes for datasets and reports.
  • Create reports and dashboards using business intelligence tools (e.g. Tableau, Power BI) to communicate data insights to stakeholders.
  • Offered technical leadership to junior personnel and other team leaders, providing expertise on SAS , Cognos , QlikView Python and Abinitio

• Create analysis for pre annual enrollment and post annual enrollment processes for different reports
• Interprets basic JCL commands and utilize mainframe utilities
• Transfer and maintain codes in production libraries (As per SDLC disciplines)
• Writes basic SQL Queries for DB2 Relational database
• Resolves basic programming defects and errors
• Writing codes for any ad-hoc or permanent report required by client
• Writing code in JCL, SAS to fulfill requirements according to analysis
• Design SAS reports in Excel and CSV files based upon client specification.