SUMMARY

• SAS Programmer, Statistical Modeler with around 7 years of experience in Analytics and BI domain along with Master’s degree in Operations Research from Confidential, New York.
• Experience with BASE SAS, SAS/MACRO, SAS/SQL, SAS/STAT and SAS/Enterprise Guide in Windows environments, Python and R Programming
• Expertise in using various SAS procedures like PROC EXPORT, PROC SQL, PROC PRINT, PROC FREQ, PROC SORT, PROC REPORT, PROC TABULATE, PROC CORR, PROC GLM, PROC UPLOAD, PROC MEANS, PROC CONTENTS, and PROC UNIVARIATE
• 6 Years of in - depth research work in Data Mining, Predictive Modeling, Simulation and Optimization, Survival Analysis techniques such as Forecasting Techniques, Clustering, Association Rules, Regression Analyses, Decision Tree, Probabilistic Graphical Modeling, Multi-objective Optimization
• Experienced in handling Terabytes of records and manipulating them through SAS
• Good knowledge of data extraction and sorting data from various databases like UNIX, MS Access, SQL server
• Modified existing SAS programs and created new programs using SAS macro to improve ease and consistency of results
• Worked in group with statisticians to provide SAS programming support for analyzing the patient level data and generating reports, tables, graphs summarizing as per company standards
• Hands on experience in using Spotfire Software, Access, and MS Excel
• Excellent problem solving skills and decision making ability
• Effective team player with excellent verbal and written communication, organizational and interpersonal skills and very efficient in delivering the results within deadlines

TECHNICAL SKILLS

Tools: SAS, SQL, Python, R, SpotFire, MS Excel, VBA, SPSS

ExpertiseBusiness: Analytics, Insurance and Pharmaceutical Industry, Business Intelligence, Reporting, Cluster Analysis and Segmentation, Logistic and Multinomial Regression, ROI Analysis

Interests: Sky diving, Rafting, Zip lining

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Lead SAS Developer

Responsibilities:

• Worked with the Algorithmic trading team in the Global Equities division
• Replaced an existing Risk UI platform used for Electronic Sales Trading with a more robust and faster performing application using Spring boot and Protobufs
• Built Predictive models for risk analysis using PROC REG, PROC SGPLOT, PROC PRINCOMP
• Assessed the existing Sybase database and designed queries from the database to perform risk checks using SAS SQL
• Created risk summary reports and external files using complex SQL, SAS procedures and Excel
• Built and automated transaction cost analysis report using SAS and Excel VBA
• Executed cluster analysis using PROC CLUSTER to group similar accounts based on their trading patterns

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SAS EG, Spring Boot, Protobufs, JAVA, Sybase

Confidential, New York, NY

Twitter Sentiment Analysis

Responsibilities:

• Parsed real time Twitter feeds and performed sentiment analysis using Python and natural language processing (NLP)
• Web-scraped to extract online data from multiple sources and combined them to get the final results
• Performed statistical analysis on sales and correlation analysis with the sentiment scores using Python

Environment: Anaconda Python Editor, Python Tweepy Library, Basemap, Numpy, BeautifulSoup

Confidential, Whippany, NJ

Lead SAS/Statistics Developer

Responsibilities:

• Lead a 10-member team offshore and 4 onsite where the primary responsibility was project and resource planning while supporting the Brand, Marketing and Sales teams
• Worked in Enterprise guide programs for report generation and data analysis
• Developed sales analysis using PROC SUMMARY, PROC FREQ, PROC REG, PROC UNIVARIATE, PROC MEANS, PROC ANOVA, PROC SQL, etc. for forecast, time-series and discriminant analysis
• Analyzed the data, future trends and summarized results to generate meaningful recommendations to management
• Developed concise and reusable code with use of SAS macros
• Executed latent class segmentation in SAS using PROC LCA in order to segment and optimize the promotional spending in various channels to these segmented customers
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements
• Experienced in multiple ROI, segmentation, statistical and analytical projects done for the top brands
• Executed Hungarian algorithm to get a test-control matching using PROC ASSIGN

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SQL, SAS Metadata, Tableau, Access

Confidential, New York, NY

Lead SAS Developer

Responsibilities:

• Assessed effectiveness of marketing campaigns and suggested ways to optimize these using market mix models using SAS
• Built a price optimization tool to minimize risk and maximize profits using pricing models for the actuary division
• Executed a project to search for subrogation opportunities using data mining techniques leading to significant profits
• Designed an analysis framework to measure and report data quality for different data warehouses using Tableau
• Managed a team of 5 members (offshore) and supported the Property, Casualty and Actuary divisions by providing business insights on key ad-hoc analysis while ensuring consistency in metrics and reporting standards
• Extensively developed SAS Macros programs to save time and effort for generating large but repetitive reports which only required variable changes
• Developed and executed new reports and dashboards using SpotFire
• Used various Statistical Procedures like PROC FREQ, PROC REG, PROC UNIVARIATE, PROC SUMMARY, PROC MEANS, PROC GLPOT to analyze data and generate reports
• Created graphs and summary reports for risk analysis reports in production using SAS GRAPH

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SQL, SAS Metadata, R, SpotFire

Confidential, Bridgewater, NJ

Senior SAS Developer/Statistics Modeler

Responsibilities:

• Developed the real time physician intelligence system to track the physician prescribing behavior and better the targeting strategy for the pharmaceutical client using PROC SHEWHART to get the statistical quality control and PROC PHREG to forecast the survival analysis results for physician prescribing trends
• Managed the client, acting as liaison between client and offshore team by gathering requirements from the client and breaking it down to the offshore team, insight generation and identification of new business problems that needed to be addressed
• Clarified client requirements, business needs and project objectives, via feedback sessions and client meetings and helped them make data driven decisions
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting
• Conducted Business Analysis, project assessment and feasibility determination. Strategized project scoping and specifications documents, to clearly communicate the project roadmap
• Lead the team that supports ad-hoc, standard reporting and production projects
• Reported offshore progress to client with the use of Excel Templates, Excel macros, Pivot tables and functions, as well as creating daily, monthly, quarterly and yearly reports activity onsite through the creation of SQL Server and MS Access databases

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SQL, SAS Metadata, Access, SAS EG

Confidential

Lead Business Analyst (SAS)

Responsibilities:

• Created various summary reports of Total Sales, Regional Sales and Account Sales for many top brands
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data to produce required reports
• Executed Hungarian algorithm to get a test-control matching using PROC ASSIGN for measuring ROI of marketing campaigns
• Managed and lead execution and development of new reports and dashboards
• Played a pivotal role in brand performance tracking for newly launched products by creating weekly performance reports
• Developed sales analysis using Proc Summary, Proc Freq, Proc Reg, Proc Mean, Proc ANOVA, Proc SQL, Proc Univariate, etc for forecast, time-series, and discriminant analysis, etc.
• Designed, built and tested a series of SAS programs for the transfer and validation of reports
• Main responsibilities included interaction with clients, understanding the business problem, process and analyze the data required to arrive at the solution, interpret the results and generate insights
• Conducted training sessions to assure knowledge transfer of methodologies, SAS, statistical models and other data analysis
• Performed analysis including Segmentation, Predictive Modeling, CHAID, etc.
• Communicated with personnel in the sales and statistical groups for specific reports and presentations to new/existing clients
• Reduced the production time significantly by automating a lot of reports using VBA automation and efficient SAS Macros

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SQL, SAS Metadata, Access, SPSS

Confidential

Senior Business Analyst (SAS)

Responsibilities:

• Designed a segmentation methodology to understand the impact of marketing campaigns on target physicians and helped the client decide to continue the campaign for which targets using PROC CLUSTER, PROC FASTCLUS
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the UNIX DB
• Designed and automated the tracker for launch brands and track their performance against competitors in the cholesterol market
• Raw data files in Excel, TEXT and ACCESS formats in SAS for invariably short or unrelated data requested for a report was used to append or merge in SAS to obtain desired reports
• Extensively used Arrays in SAS Data Steps. Merging Datasets and Manipulating Datasets
• Used SAS ODS and Proc Export steps to create all the reports as user interface was based on the Windows environment
• Worked on Data Preparation by drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code
• Used Data validation techniques for validating data before using the same for final analysis
• Worked on Data Analysis where the validated data is analyzed to get market share, top customers for the target list and assess responsiveness of targets based on sales and marketing efforts
• Programmed and guided the design and development of the applications
• Used SAS DATA NULL and PUT statements to create customized reports
• Uploaded SAS data sets across platforms from PC to UNIX and vice versa
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales
• Developed new macros for report generation using SAS/Macro as per the client’s requirements

Environment: SAS Base, SAS R, Proc, Macros, VBA, Excel, SQL, SAS Metadata, UNIX, Access