Data Analyst

SHANTANU AWASTHI

*******.*******@********.***

732-***-**** Extn 142

Data Analyst SAS Programmer with nearly 7 years of experience in design and model development using SAS to compile and analyze large data sets including data step processing, data mining, data manipulation, data transformation.

Extensive Exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.

Passed Exam P (Probability) conducted by S.O.A. (Society of Actuary) in July 2014.

Passed Exam FM (Financial Mathematics) conducted by S.O.A. (Society of Actuary) in April 2015.

Experience in extracting/creating, merging, analyzing and reporting large SAS datasets of up to 22 million records.

Interact with end users to provide reports.

Experience in developing and modifying SAS Programs and Macros for data extraction, data integration, data cleaning, validation, and query writing and reporting.

Good understanding and hands-on experience on Econometric and Statistical analysis such as Correlation Analysis, Hypothesis testing, ANOVA, Multivariate Statistical Analysis, Linear & Non-linear Regression Analysis, Decision Trees, Random Forest Tree.

Good understanding and hands on Factor Reduction Techniques such as Principal Components, Factor Analysis.

Expert in conducting Segmentation techniques such as Cluster Analysis(Hierarchical & Non-Hierarchical), Decile Analysis and Response Analysis techniques such as Discriminant Analysis and Logit Model.

Extensively used Pre-existing Macros and helped in developing SAS Programs for DATA Cleaning, Validation and Report Generation.

Experience in writing advance SQL Program for joining multiple tables, sorting data.

Experience in DATA merging sub setting with the use of the PROC SQL, Merge and SET statements.

Worked with Procedures such as PROC SQL, PROC REPORT, PROC SORT, PROC TRANSPOSE, PROC MERGE, PROC PRINT and PROC TABULATE in SAS.

Knowledge and experience in Microsoft Office tools like MS Access, MS Word, MS PowerPoint, and MS Excel.

Experience in using SAS ODS to create HTML, PDF, CSV files.

Experienced working with larger database to perform complete data retrieval, manipulation using multiple input files using data steps. Generated Summary reports using Excel PIVOT Table.

Skilled in using SAS statistical procedure like PROC REPORT, PROC TABULATE, PROC CORR, PROC GLM and PROC ANOVA, PROC LOGISTIC, PROC FREQ, PROC MEANS, and PROC UNIVARIATE.

SOFTWARE SKILLS

Statistical Analysis Tools

SAS

Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH. Windows environments

Predictive modeling using SAS Enterprise Miner.

Programming Languages

R

MATLAB

Data Visualization Tools

SAS Visual Analytics

Business Intelligence Tools

Tableau

SAS BI

Other Tools

Unix, Windows,Oracle

PROFESSIONAL EXPERIENCE

Wells Fargo Bank Colonial Heights, VA

To provide insurance and financial solutions with the ultimate goal of making a contribution in the community we serve.

SAS Developer (AUGUST 2014- TILL NOW)

Played a key role in the development of credit score card for all customer credit accounts and classify them into high risk and low risk customers.

Identified the variables that discriminate a bad customer to a good customer using WOE and IV.

Performed Logistic Regression to estimate the probability of a new customer being classified as a good or bad customer.

Interact with business people to gather functional requirements.

Developed Business model that defined attributes that helps in understanding business rules and policy.

Design code for business requirement and presented to business users.

Used Sankey Diagram and Bubble chart for better visualization of data provided.

Created SAS data sets by extracting data from Oracle database and flat files using PROC SQL, PROC Import, and SAS Data Step.

Conducted statistical analyses using linear regression (PROC REG), logistic regression (PROC Logistic).

Created reports including tables, listings, and graphs by using PROC TABULATE, PROC SUMMARY, PROC FREQ, and PROC REPORT.

Collaborated with teams in planning and structuring transactions to assist in credit analysis and pricing.

Performed high-level quantitative credit risk analysis with the internal and external data.

Used SAS DATA _ NULL_ and PUT statements to create the customized report.

Search for meaningful patterns, trends, and relationships by sifting through large amounts of data.

Developed several SAS analytics models and reports using SAS/EG.

Duty First Consulting Vienna, VA

Duty first Consulting is service disabled Veteran owned small business Providing information technology and management consulting services primarily to the Federal government .Expertise in the areas of information technology, human capital management, business process.

Statistical Analyst (FEBRUARY 2012-AUGUST 2014)

Imported raw data files and subsequently created SAS datasets by using ETL tools and performed data manipulation on the datasets.

Extensively used PROC SQL and SELECT sub queries to generate various reports by connecting to different database such as Oracle.

Write SQL for explanatory data analysis and use visualization techniques to provide recommendations to business.

Developed SAS and SQL Programs for Data Cleaning, Validation, and Analysis and Report Generation.

Performed missing value imputation using PROC STDSIZE and REPONLY options.

Tested and debugged preexisting macros using different macros debugging options.

Generated high quality reports in the form of listing HTML, Excel and PDF formats using SAS ODS.

Prepared Data listings, summary tables and Graphs for analysis using SAS system.

Developed reports using PROC REPORT, PROC TABULATE and DATA_NULL.

Ensured data analysis and programming code to meet regulatory and company standards.

Extracted, transformed and loaded using SAS.

Converted large data from Oracle to SAS data sets using SQL pass through and LIBNAME facility.

Merge the datasets to provide the users the data in required form.

Abraxas Corporation Springfield, VA

Abraxas provides specialized support, develops and integrates state of art technologies and implemented trusted and unique solutions to address the global challenges faced by National Security Community toady and those it will face in future.

Data Analyst (August 2010- January 2012)

Investigated Missing data and data anomalies in SAS data sets.

Extracted data from different sources like claims data mart and text files using SAS SQL Procedures and created SAS datasets.

Performed data preparation and transformation using SAS procedures to ensure data quality and consistency.

Used SAS PROC SQL pass through facility to connect to tables and created SAS datasets using various SQL join such as left join, right join, inner join and full joins.

Analyzing deviations in aggregate claims statistics.

Created customized reports using SAS Procedures such as UNIVARIATE, FREQ and GLM, LOGISTIC etc.

Created and modified preexisting macros to report summary statistics as well as inferential statistics.

Performed Validation of SAS programs using various SAS sophisticated techniques and communicated findings to the programmer/ statistician.

Interacted with other team members and lead to discuss the required developments to be made in coding to improve the functionality.

Generated analysis reports, graphs using SAS Reports and SAS ODS to produce EXCEL and HTML reports.

Leidos Reston, VA

Leidos provide a wide variety of clinical, business and IT solutions for healthcare.

SAS Programmer (August 2009- August 2010)

Wrote analysis plans including specifications for graphs.

Manipulated large data sets, data validations and corrections.

Create Plot using PROC PLOT. Created Permanent formatted SAS data sets for present and future analysis, sorting and merging by common variables.

Imported Data from relational database into SAS files per detailed specifications.

Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel.

Performed ETL task in extracting the sales data from database using SAS procedures like SAS SQL, SAS Access and creation of datasets.

Performed data analysis, data presentation, graphical presentation, Statistical Analysis, Reporting, validation and documentation.

Analyzed larger data sets using PROC SORT, PROC PRINT, PROC TABULATE procedures.

Extremely used PROC MEANS, PROC FEQ, and PROC SUMMARY for data cleaning and data mining.

Used PROC SORT with nodupkey options to remove duplicate records.

EDUCATION

MS in Applied Mathematics from Virginia State University.

Bachelor of Technology in Electronics and Communication from G.G.S.I.P.U.

Contact this candidate