Nikhil Reddy

Contact:

+1-408-***-****

adinhi@r.postjobfree.com

Summary

Senior SAS/SQL Consultant with SAS base and advance certified, having about 7 years of SAS/SQL programming/analysis experience on Windows and UNIX environment with knowledge on various sectors like Financial, healthcare, retail, etc.

Extensive experience in SAS/SQL programming and data analysis on Windows Power Shell, UNIX and Mainframe environments.

Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT

Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SQL, SAS Grid, SAS Enterprise Guide, Enterprise Miner, SAS/ ACCESS and SAS/DI in UNIX, Windows environment.

Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.

Developed new or modified SAS programs and used SQL Pass Through and Libname methods to extract data from the Teradata DB and created study specific SAS datasets, which are used as source datasets for report generating programs.

Additional experience includes using Base Procedures, Graph, Macros, Data Step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and in formats.

Experience in working with multiple databases like Oracle Server, DB2, MS SQL Server, and MS Access.

Knowledge on working with Oauth 2.0 process flow to log in to salesforce to extract data using PowerShell Script.

Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development and Testing.

Experience in agile and waterfall project management methodologies to produce high-quality deliverables that meet or exceed timeline and budgetary targets

Skilled in data manipulation and generating customized reports with SAS data steps and procedures and have experience in handling large amounts of data for Data Cleansing, Data Profiling and Data Scrubbing.

Worked on marketing concepts like Marketing MIX, BCG matrix, Porters five force models, Ansoff Matrix, etc. to make them understand the business view.

Experience in handling client meetings for updating current projects and to discuss on further projects.

Experience in Base SAS, SAS Enterprise Guide, enterprise miner, SAS/AML, SAS/Stat, SAS Macros, SAS/Graph, SAS/Connect, and SAS/Access on Windows and Unix platforms and competence in carrying out statistical analysis of large-scale data

Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA

Develop Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc. Produced HTML, PDF and RTF reports using SAS ODS Generated graphs using ProcGChart and GPlot.

Experience with export SAS Results to different formats such as XML, PDF, Excel using SAS/Export, SAS/ODS for reporting and presentation.

Experience working with marketing team to conduct exploratory data analysis and Expertise in statistical, quantitative and analytical data in financial sector

Certification

SAS Certified Advanced Programmer for SAS9.

SAS Certified Base Programmer for SAS9.

Technical Skills

SAS Tools: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/BI, SAS/DI, SAS VA, SAS/ODS.

Databases: SQL server, Oracle, IBM Informix, Teradata SQL Assist.

Operating Systems: Windows, UNIX, Linux.

Other Tools: MS Office, Tableau, PowerShell, SQL, Putty, Reflection, SAS VA, Teradata SQL Assist.

Educational Qualification

Bachelor in Computer Science and Engineering, NECG, India, 2011

Masters in Computer Science, Northwestern Polytechnic University, 2016

Work Experience

ROLE: SAS/SQL Programmer

CLIENT: Wells Fargo

DURATION: Aug-2019 – Present

LOCATION: West Des Moines, IA

Responsibilities:

Interpreting data, analysing results using SAS EG/ SQL techniques and providing on-going reports in a timely and professional manner.

Work on SAS EG, Teradata SQL Assistant on auto loans, home lending, credit card services and mortgage data and generate weekly reports analysing the transactions, payments, demographics, etc. (acts as both SAS/SQL developer and business analyst).

Working as developer/Business analyst as a part of the Wells Fargo Consumer Lending-Servicing Data Analytics team with an assigned line of business to solicit requirements, translate those requirements into a technical language for our developers and also as build report on SAS as a developer.

Provides Customer Remediation Data Analytics for all of Consumer Banking related LOBs (Auto, Retail, Student Loan, Credit Card, etc... the whole Bank footprint) that are Non-Home Lending.

Accessing various databases using Teradata studio and Teradata SQL Assistant to alter tables using complex SQL queries and then to link the query in SAS EG to produce SAS datasets in both UNIX and windows environment.

Documenting the weekly project flow in Jira and keep track of DRA (Data, Reporting and analytics), SRG (Servicing report governance) tickets in both UAT and PROD agent portal.

Developing and implementing databases (Oracle, Teradata) with over 80 million records and create dashboards on the loans data using SSRS using the dynamic business logic every month.

Translate stakeholder requirements into over 10 different tangible deliverables such as functional specifications, user cases, user stories, workflow/process diagram, etc. and also work as a developer in building complex SAS/SQL programs.

Weekly datasets validation using SAS queries for various RDBMS such as SQL Server, My SQL, Microsoft SQL, Teradata and Oracle.

Collaborate with team and key stakeholders on a weekly basis to update on reports generated by SAS and SQL and also to gather the weekly requirements.

Working independently on Ad Hoc requests reporting results on a monthly basis. Identify, recommend and develop new efficient data solutions for financial data by streamlining business processes.

Develop Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc.

Attend daily scrum meeting to discuss finished task, ongoing task and next day’s target to make sure the project is on track.

Perform market research and segmentation analysis using SAS, SQL, and Excel to get the potential target customers and identify the market trend and opportunities.

Develop and work closely with business to create/update SAS reports. Weekly team meetings on project update using the software lifecycle in SDLC, Agile and Scrum methodologies including creating requirements, test plans, and solutions. Working with the team.

Performed advanced querying using SAS Enterprise Guide, calculating computed columns (based on the loans business logic), using the filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis and generating SAS datasets.

Work on complex and reusable Macros and use SAS functions for Data Cleaning, Validation, Analysis and Report generation for the dataset having many variables.

Convert the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to a new data warehouse using SAS, SQL and Macros with better and accurate values.

Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.

Environment: SQL, SAS EG, SAS Base, Teradata SQL Assistant, Visual Studio, Putty, Oracle, MS office, UNIX, Teradata.

ROLE: Senior SAS/SQL Programmer

CLIENT: Global Atlantic

DURATION: Sep-2018 – July-2019

LOCATION: Des Moines, IA

Responsibilities:

Interpreting data, analysing results using SAS EG/ SQL/R Studio statistical techniques and providing on-going reports in a timely and professional manner.

Identify, recommend and develop new efficient data solutions for financial data by streamlining business processes.

Work on SAS EG for Complaints report and annual statement tracking which tracks the due date on all policies and complaints categorizations on a weekly basis.

Using PowerShell script to login to Salesforce for extracting data, there by automating the process of manually logging into salesforce every time to extract data.

Working on Oauth 2.0 in PowerShell process to extract the data from Salesforce.

The high-level view of the project is to work on the conversion data of customer policies stored in various data sources using SAS ETL process

Work on SAS EG/R for Complaints report and annual statement tracking which tracks the due date on all policies and complaints categorizations on a weekly basis.

The high-level view of the project is to work on the conversion data of customer policies stored in various data sources using SAS ETL process

Developing and implementing databases (Oracle, Salesforce), data collection systems, data analytics and other strategies that will provide efficiency and quality.

Collaborate with team and key stakeholders on a weekly basis to update on reports generated by SAS and SQL.

Working independently on Ad Hoc requests reporting results on a monthly basis.

Work on Complaints, policies data for Global Atlantic to produce weekly dashboards using SAS/SQL and excel for the business.

Attend daily scrum meeting to discuss finished task, ongoing task and next day’s target to make sure the project is on track.

Perform market research and segmentation analysis using SAS, SQL, and Excel to get the potential target customers and identify the market trend and opportunities.

Develop and work closely with business to create/update SAS reports. Weekly team meetings on project update using the software lifecycle in SDLC, Agile and Scrum methodologies including creating requirements, test plans, and solutions.

Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using the filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis and generating SAS datasets.

Work on complex and reusable Macros and use SAS and R functions for Data Cleaning, Validation, Analysis and Report generation for the dataset having many variables.

Convert the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to a new data warehouse using SAS, SQL and Macros with better and accurate values.

Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU.

Develop Financial Monthly and Quarterly summary reports, graphs using SAS procedures like Proc Freq, Proc Graph, Proc Univariate, Proc Summary, and Proc Report etc. Produced HTML, PDF and RTF reports using SAS ODS Generated graphs using ProcGChart and GPlot.

Environment: SQL, SAS EG, SAS Base, PowerShell, Confluence, Visual Studio, Putty, Oracle, MS office, UNIX, Teradata.

ROLE : Sr SAS/SQL Analyst

CLIENT: Kellogg’s

DURATION: Feb 2017 – Aug 2018

LOCATION: Battle Creek, MI

Responsibilities:

Implement solutions to meet high end business needs using SAS/SQL.

Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS, SQL and Macros with better and accurate values.

Analyzed customer spending patterns, and purchase frequency to create clusters for customer relationship management (CRM)

Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, JOIN, UPDATE and PROC SORT.

Gathering Business requirement through meeting and conferences with clients and suppliers.

Work with Project Managers design, execute, and document data management and quality assurance procedures for research data collection projects using SAS and other statistical packages.

Manipulate and manage very large data files in SAS

Design projects that apply valid statistical techniques utilizing various data types in order to structure relevant and actionable analyses

Develop and test experimental designs, sampling techniques, and analytical methods and decide which data are pertinent to answer specific questions or problems

Support research efforts by reviewing statistical methodologies, recommending methodological best practices and implementing statistical analysis solutions

Worked on pre-defined roles of SAS VA, SAS DI to view, analyze the reports on a bimonthly basis

Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS/SQL variable values instead of multiple IF statements.

Connected various databases (DB2, Teradata SERVER) such as development and production database (Teradata on UNIX) using SAS/ACCESS

Involved in building product matrix which determines the progress of all the product line.

Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.

Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.

Worked with the client to develop marketing campaigns for customer acquisitions that involved third party Data Providers, setting up internal IT systems and Campaign data analytics.

Managed multiple projects in a fast-paced environment meeting milestones and deliverable dates with no supervision.

Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data.

Environment: SQL, SAS EG, Power Shell, Oracle, UNIX, Teradata, SalesForce, visual analytics, Putty, Teradata, MS office.

ROLE: Senior SAS Programmer/Data Analyst

INDUSTRY: Financial

CLIENT: Personal Capital

DURATION: July 2016 – Feb 2017

LOCATION: Redwood City, CA

Responsibilities:

Implement solutions to meet high end business needs using SAS and R Studio.

Extensively used Enterprise Guide, SQL Platforms to get connected to various database and other flat file resources to collect information on Retirement Data, Wealth Management, ALERTS and CASES.

Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using R Studio, SAS, SQL and Macros with better and accurate values.

Complete analysis of transactional information to identify risks, trends, and potential suspicious activity related to Anti-money laundering and other criminal activities

Analyzed customer spending patterns, and purchase frequency to create clusters for Asset, Wealth, customer relationship management (CRM)

Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.

Gathering Business requirement through meeting and conferences with clients and suppliers.

Worked on pre-defined roles of Tableau, SAS VA, SAS DI to view, analyze the reports on a bimonthly basis

Perform a 60 days’ observation and conduct SIP (Special interest person), RCA (Relatives and close Associates) check on all the suspicious accounts before submitting the SAR (Suspicious Activity Report) report to the client.

Worked on R studio to perform predictive modeling on the data we receive quarterly to understand the customer behavior.

Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.

Connected various databases (DB2, Teradata SERVER) such as development and production database (Teradata on UNIX) using SAS/ACCESS

Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.

Creation and maintenance of mainframe execution JCL (jobs) to support system replacement project in User acceptance (UAT) and Production environments.

Worked with the client to develop marketing campaigns for customer acquisitions that involved liaising with third party Data Providers, setting up internal IT systems and Campaign data analytics.

Develop credit risk analysis model based on FICO score and categorize the customers.

Experience in implementing fraud management system to prevent credit and debit card frauds and protect customers from fraud.

Produced risk-rating scores for multiple investments using the company's proprietary risk rating engine as well as personally generated models and techniques.

Managed multiple projects in a fast-paced environment meeting milestones and deliverable dates with no supervision.

Environment: SAS EG, SAS Enterprise Miner, SAS BI, Power Shell, Tableau SAS EM, SAS DI, Microsoft SQL, IBM Informix, visual analytics, Putty, Teradata, Oracle, MS office.

ROLE: SAS Programmer/Data Analyst

INDUSTRY: Financial (2.5 Years) and Health Care (1.5 Years)

COMPANY: GeP (Global eProcure)

DURATION: Oct 2011 – June 2015

LOCATION: Mumbai, India

Responsibilities:

Assists in maintaining the company’s credit facilities and relationships including credit renewals, refinancing, future planning, and fulfilling all reporting and compliance requirements.

Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ.

Independently create, execute, maintain, and validate programs that transfer data across multiple data management systems or operating systems.

Creating PHI (Personal Health Information) reports in HTML, PDF and RTF formats using SAS/ODS facility

Used Proc SQL joins and Proc SQL set operators to combine tables horizontally and vertically and proficient in Integration of various Data Sources like MS-Access, Flat and CSV Files.

Involved in Gathering and Analyzing Business Requirements and Detail Technical Design of ETL.

Experience on SAS EG to work on Retirement Plan data for categorizing customers demographically with respect to various offers and build sample dashboards on SSRS

Produce reports to identify potential patients that meet the requirement for defined parameter.

Produce and manage annual hospital performance review packets. The packets will include membership, revenue, and cost analysis for the hospital.

Maintain relationship with around 1500 suppliers so as to know the current market scenario and to help our client with the best possible supplier.

Design and select appropriate SAS procedures for each statistical analysis, test-run SAS program on mock data to ensure smooth analysis implementation.

Worked on survey data analysis to understand the customer segmentation across regions

Coding SAS/SQL programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.

Design and develop stored procedures, functions, views and triggers to be used in the ETL process

Assists in long-term planning and budgeting processes, especially in the areas of cash and credit functions.

Used SAS VA for designing end report in more creative way to the client by using all the features like network diagram, information maps, etc.

Analysis included Behavioural model, Customer Profiling, Segmentation, Trend Analysis, and Predictive Modelling, Optimizing open-ended offers, etc.

Created and Automated Daily, weekly and monthly analysis on the sales of all product categories

Perform Data analysis, statistical analysis; generate safety and efficacy tables, listings and graphs using Base SAS, SAS Macros.

Environment: SAS BI, Windows, web portals, SAS visual analytics, Teradata, MS office, Tableau, Oracle Sql developer.

Contact this candidate