N Nikhil Reddy
Senior SAS Consultant with SAS base and advance certified, having over 6.5 years of SAS with 1.5 years of R programming/analysis experience with knowledge on methodologies applied in Health care, Food, Financial and insurance sectors.
Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SQL, SAS Grid, SAS Enterprise Guide, Enterprise Miner, SAS/ ACCESS, etc.
Strong SAS programming background for creating, maintaining existing code, ad hoc reporting and supporting the reporting functions.
Experience in data mining using both R and SAS to further perform statistical tests (hypothesis testing) on the mined data.
Experience in Multiple Linear Regression based analysis using R understand the importance of independent variable over dependent.
Familiarity with advance simulation algorithm MCMC (Monte Carlo Markov Chain) to generate a set of samples to understand the distribution.
Experience in agile and waterfall project management methodologies to produce high-quality deliverables that meet or exceed timeline and budgetary targets.
Experience in performing Annova to test the difference among group means of categorical variable in retail industry.
Performed market research and segmentation analysis using R, SAS and Excel to get the potential target customers and identify the market trend and opportunities.
Familiarity with R data processing functions like stack, merge, reshape, substr, ect. And plots like barplot, boxplot, ggplot, qplot, etc.
Utilized R Studio to apply regression and classification methods (such as Random Forest) to predict the popularity; evaluated the performance of different models and explored the influential rank of factors for customer survey.
Knowledge in calculating and understanding the time complexities of different algorithm used in machine learning
Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
Experience in handling client meetings for updating current projects and to discuss on further projects.
Have strong experience on working with Data which includes various Healthcare claims and Membership.
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.
Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA.
Experience with export SAS Results to different formats such as XML, PDF, Excel using SAS/Export, SAS/ODS for reporting and presentation.
SAS Certified Advanced Programmer for SAS9.
SAS Certified Base Programmer for SAS9.
R certification from Simplilearn.com
SAS Tools: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/EM, SAS/Forecast Studio, SAS/BI, SSIS, SSRS, SAS/DI, SAS VA, SAS/ODS.
Other Tools: R Studio, MS Office, Tableau, SSRS, SQL, File Zilla, Putty, Reflection, SAS VA, Reflection, Teradata SQL Assist.
Bachelor in Computer Science and Engineering
Masters in Computer Science and Engineering
ROLE: Analytics Solution Lead/ Senior SAS Programmer
INDUSTRY: Food retail
DURATION: Feb 2017 - Present
LOCATION: Battle Creek, Michigan
Analyse Market Research Survey Data conducted by Cambridge Research and help building a marketing and sales tool.
Performed market research and segmentation analysis using SAS, SQL and Excel to get the potential target customers and identify the market trend and opportunities.
Extensively worked on developing the questioner consisting of 132 questions to understand the customer behaviours and the product penetration.
Worked on R Studio plotting the graphs based on survey data collected and also used SAS Text miner to understand the customer behaviour.
Using Text miner on a survey data was altogether a new task for Kellogg’s and the output was much useful to proceed further to implement text miner for other areas.
Worked on a special case project to generate special set of samples (Slice Sampling, Hasting algorithm) form the survey using MCMC (Monte Carlo Markov Chain) in R Studio.
Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
Assigned tasks to the team members after explaining them the business requirement and helping then understand the code logic.
I was also a part of Frozen food data, where I used R Studio and SAS EG to analyse multiple categories of frozen foods based on the weights assigned to each categories.
Keeping track of project by arranging a weekly meeting with the Global Insight managers and present the weekly report on Tableau dashboard to give them a graphical view of customer segmentation.
Created complex and reusable Macros and used SAS and R functions for Data Cleaning, Validation, Analysis and Report generation as the data has 24,000 variables.
Extensively used various Base SAS procedures like proc SQL, proc Report, Proc Format, Proc Tabulate, Proc Print, Proc Sort etc. for reporting purposes Proc Freq, Proc Means, Proc reg.
Participated in meetings with the Insight Managers of 3 countries (UK, Australia and Canada) to understand the requirement and help them in building the report using SAS Enterprise miner and EG.
Performed cluster analysis on grouping the customers based upon 56 variables using K-mean cluster analysis.
Responsible for handling requests from the marketing department and inquiries from the Customer Services related to statistics of existing data.
As a lead, trained the tech team of Canada, Australia and UK to make then understand the business logic and make sure the reports of the all the 3 regions are in synchronous.
The output consisted of 30 individual reports and were replicated on Tableau dash boards
Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data.
Environment: SAS EG, SAS Enterprise Miner, R Studio, SAS BI, Tableau, SAS EM, SAS DI, Microsoft SQL, IBM Informix, visual analytics, Putty, Teradata, Oracle, MS office.
ROLE: Senior SAS Programmer/Data Analyst
COMPANY: Bank of America
DURATION: March 2016 – Jan 2017
LOCATION: Wilmington, Delaware
Implement solutions to meet high end business needs using SAS.
Extensively worked on AML (Anti Money Laundering) data and generated monthly and quarterly reports.
Extensively used Enterprise Guide, miner/Mainframe Platforms to get connected to various database and other flat file resources to collect information on ALERTS and CASES.
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.
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 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 RCA on all the suspicious accounts before submitting the SAR report to the client.
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, Mainframe (Reflection), Tableau SAS EM, SAS DI, Microsoft SQL, IBM Informix, SSRS visual analytics, Putty, Teradata, Oracle, MS office.
ROLE: SAS Consultant
INDUSTRY: Healthcare insurance
COMPANY: Conversa Health
DURATION: Aug 2015 – Feb 2016
LOCATION: Portland, OR
Experience with analysis of Claims Data, Membership Data, and Sales Rep data in healthcare industries.
Attended the business classes on fundamental of Clarity systems, INPATIENT, OUTPATIENT, Ambulatory &
Design and select appropriate SAS procedures for each statistical analysis, test-run SAS program on mock data to ensure smooth analysis implementation.
Responsible for developing and submitting JCL jobs in Mainframe to complete various Weekly, monthly and quarterly processes.
Implementation of end-to-end ETL Process for IBM mainframe Operating System.
Lead and managed Health Risk Assessment project which electronically fed data files from vendor.
Analyze the Add & Term reports of each region using SAS tools like PROC FREQ, proc tabulate, proc report, Proc mean, Proc transpose.
Creating PHI (Personal Health Information) reports in HTML, PDF and RTF formats using SAS/ODS facility
Used SAS VA, SAS DI to represent the categorization of patients based on the Add & Term results
Involved in Gathering and Analyzing Business Requirements and Detail Technical Design of ETL.
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.
Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
Develop an understanding of relevant business processes, goals, and strategies for each individual healthcare client in order to provide comprehensive data analysis.
Attend weekly meetings with the client to update the progress and to recommend required changes.
Integrated analytic code written in Base/SAS, SQL, and SAS/Stat to create a point-n-click reporting environment.
Maintain a healthy bridge between my team and client as a we never missed any deliverable nor had any escalations.
Independently digging through the root cause of problems in Data, backend tables, databases, SQL code or SAS programs and describing the nature of technical issue.
Provide proper validation, including testing and documentation (e.g., requirements document, program validation), in accordance with company standards.
Environment: SAS Base, SAS/SQL, SAS/STAT, Reflection, Epic Systems, Web Portal, IBM Informix, Teradata SQL Assist, ETL, Oracle SQL developer, MS office, UNIX, Windows, SAS/Access Oracle, PUTTY.
ROLE: SAS Programmer/Data Analyst
COMPANY: GeP (Global eProcure)
DURATION: May 2012 – May 2015
LOCATION: Mumbai, India
PROJECT (May 2012 - May 2015)
Assists in maintaining the company’s credit facilities and relationships including credit renewals, refinancing, future planning, and fulfilling all reporting and compliance requirements.
Independently create, execute, maintain, and validate programs that transfer data across multiple data management systems or operating systems.
Coding SAS/SQL programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
Performed market research client on loan request information in commercial lending, BSA/Anti-Money Laundering (AML) Administration and third-party applications.
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.
Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ.
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.
ROLE: Data Analyst/SAS
COMPANY: Tech Mahindra
DURATION: Jan 2011 – March 2012
LOCATION: Pune, India
Worked with researchers to create analytic files using administrative health care data.
Designed and developed SAS DQI codes for the Vendor transition (VT) and target by drug Campaigns.
Created different types of summery tables and listings tables using PROC MEANS, PROC TABULATE, PROC REPORT.
SAS Utility/Macro creation for global use, involved in Coding analyzing, Report generation and testing programs using SAS/Base, SAS/Macro, SAS/STAT and SAS/SQL to the Client requirements.
Extensively used Data _Null_ and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files
Create, execute, maintain, and validate programs that generate listings, tables and figures using SAS programming, macros, SAS/GRAPH, and SAS/STAT
Perform secondary research to identify potential suppliers in the market and to analyze the latest trends of our incumbents.
Make recommendations with regard to the storing of relevant benchmarks, reference data, and metadata needed for state of the art Data Quality Analytics program.
Communicated very well throughout the team for implementation and changes of codes
Maintained proper work instructions of various processes and updated as and when required.
Environment: SAS, SQL, Teradata, MS Office, Databases, PUTTY, SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS, ORACLE, Windows, Excel, SQL