Data Sas

PROFESSIONAL SUMMARY

Over *+ years of experience in analysis, design, development and implementation in Banking, Healthcare and telecommunications Domains using SAS.

Extensive experience in SAS programming, SQL, Python and Tableau.

Knowledge on Machine learning and data mining techniques with knowledge of applying them to real problems.

Experience in working/ creation of Hive datasets

Experience in designing visualizations using Tableau software and Storyline on web and desktop platforms, publishing and presenting dashboards.

Worked extensively in Python for Data Analysis and Predictive Modelling.

Expertise in extracting data from various disparate data sources like (XLS, CSV, TXT) files, Oracle, SQL Server, MS-Access, etc. Ability to analyze & process data using various SAS procedures such as utility procedures, report procedures, statistical procedures.

Proficient in RDBMS concepts and expertise in using Oracle, Access and SQL server databases.

Expertise in processing large datasets with millions of records for data transformation and data modeling including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.

Developing Macros at various instances for automating listings and figures on data for analysis.

Successfully increased portability of existing SAS programs and created new programs using SAS macro-variables to improve efficiency and consistency of results.

Successfully analyzed business logic and system needs to prepare dataflow diagrams and documentation.

Employed techniques like sorting and merging on the raw data sets and coded the using Proc SQL and SAS Macro facility to get required output.

Strong experience in SAS Enterprise guide in creating stored processes using the dynamic prompts containing both packaging or streaming output, and prepared reports using ODS.

Highly Motivated, organized with strong analytical and communication skills in establishing effective task priorities as a team player with result-oriented attitude.

Experience in working with large technical teams to understand requirements and to develop code based on SDLC procedures.

Extensive experience in generating data driven insights

TECHNICAL SKILLS

Expertise in using SAS tools, SAS/Base, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/STAT, SAS/ODS, SAS enterprise Miner, SAS/SHARE

BI Tools: Tableau, power BI and Excel

Programing tools: Python

Machine Learning Algorithms: Regression, Classification Models, Clustering, Boosting and Bagging Methods, Decision Trees and Random Forests, Recommendation Systems, Association

EDUCATIONAL QUALIFICATION

DREXEL UNIVERSITY Lebow College of Business

Master of Science in Business Analytics (GPA-3.93)

INDIAN INSTITUTE OF TECHNOLOGY (IIT-BHU) Varanasi, India

Bachelor of Technology in Engineering

certification

SAS Base Programmer for SAS9

PROFESSIONAL EXPERIENCE

Comcast, Philadelphia, PA Jan’ 18 – TILL DATE

Role: SAS Consultant

Responsibilities:

Deployed supervised model to predict the internet connectivity problems and improve the customer experience, resulting in a significant increase in the ROI for company by preventing truck roll expenses

Dashboard includes more than 60 key metrics such as customer lifetime value, Revenues, subscriber share etc., Which helps to focus/improve the revenue on each perspective.

Developed a predictive model to estimate the Customer life-time value (CLV) using stepwise regression model

Performed data validation, transformed data from RDBMSoracle to SAS datasets

Responsible for the cleaning, reformatting, analysis and loading the data into the database.

Combined and grouped datasets using concatenation and merging

Developed enterprise wide dashboard and scorecards regarding customer acquisition ease the decision making of the senior leadership team

Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA_NULL_ for analysis

Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes

Built dynamic macros to automate the manual effort and to increase the throughput of the entire team

Identified Key Metric and developed reports in Tableau for Leads dashboard system

Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc.,

Developed Tableau Dashboards for Xfinity Stream which includes App usage details, to get better understanding of future enhancements

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, Oracle 9i, PL/SQL, MS Excel and Unix, Tableau, Python

Barclays, Hanover, NJ Jun’ 14 – Dec’ 17

Role:SASProgrammer

Responsibilities:

Involved in multiple steps of analysis process starting with data gathering, translate data into insights, presenting the information to enhance the understanding of customer profiles, portfolio metrics and overall product performance.

Developed the prospect acquisition models to decrease the acquisition expenses and identify the profitability of a customer acquired through different marketing sources such as Purchased Leads, Call Transfers, Direct Mail and Online Leads

Performed ETL operations for the preparation of Consumer Credit Cards, Rewards and Digital Payment data.

Developed a complete tracking system in SASReporting and Tableau to identify the key attributions done by financial representatives which has been published at all the zone and region level branches.

Performed ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and documentation using SAS.

Developed and designed SAS Programs/ Macros to analyze financial data and to generate reports.

Used SAS/ACCESS to extract data from ORACLE and SQL SERVER.

Created different datasets by combining individual datasets using various inner, outer, right and left joins using SAS/SQL.

Created and modified existing SAS datasets using PROC SQL, PROC DATASETS, PROC IMPORT, etc.

Built summary reports to communicate key findings/performance indicators and articulated strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC UNIVARIATE, PROC MEAN, PROC GPLOT and DATA_NULL_.

Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, and SAS/MACROS for descriptive and inferential statistical analysis and data displays.

Extensively worked on creating Macro variable and Macro for automated weekly, Monthly report generation and to submit in a batch mode

Generated complex reports in text, HTML, Excel and PDF formats using SAS Output Delivery System (SAS/ODS).

Used PROC TEMPLATE to customize the reports in spreadsheet with footnotes, titles, and pages numbers along with image logos.

Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA_NULL_ for analysis.

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Enterprise Guide, Teradata, DB2, ORACLE, SQL Server Windows XP.

Independent Health, Buffalo, NY Aug’ 12 – May’ 14

Role: SAS Programmer

Responsibilities:

Classified the members into standard and high-risk categories through monthly predictive analysis of claims data to identify patients who likely to have a healthcare need in short notice

Segmented the customers, who have specific expectations for their healthcare plan. And to increase the number of customers by assured marketing strategies.

Created weekly reports and summary reports of Inpatient and outpatient records in Tableau

Created risk reports with internal predictive analytics tool to assist in identifying and reviewing clients with high clinical and financial dangers in order to mitigate risks.

Extracted patient data and claims data from the databases like Oracle, SQL, Teradata and transferred them as SAS data sets using PROC SQL

Extensively used the SET, UPDATE and MERGE statements on SAS datasets to read and manipulate claims data

Pre-Processed the claims and subscriber’s data using SAS procedures like PROC REG, PROC COR

Conducted Statistical analysis by using SAS Procedures like PROC ANOVA, PROC T-TEST, PROC REG and PROC LOGISTIC

Worked with statisticians to gather and analyze the analysis requirements

Created SAS views from Oracle database tables using SAS/Access and using SAS programs to create reports

Coordinated with the stakeholders and prioritized workflow processes to meet business and information needs

Developed functional dashboards in Tableau from multiple data outlets to synthesize market share.

Created Hive Datasets to store large amounts of claims data extracted from different databases.

Created Views from the Hive tables using SAS Programs

Built summary reports to communicate key findings/performance indicators and articulated strategic implications using PROC REPORT, PROC TABULATE, PROC UNIVARIATE, PROC MEAN, PROC SUMMARY

Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQ, SAS/ODS, Oracle 9i, PL/SQL, MS Excel and Unix, Hive

Contact this candidate