TECHNICAL SKILLS

Databases: Oracle DB2, MySQL, SAS SPDS, Microsoft Excel.

Programming Languages: SAS, Python, R, SQL, Unix/Linux Shell Scripting, Java, HTML.

Software: SAS Tools (SMC, SAS DI Studio, BI IMAP Studio, Web Portal/Web Report Studio, SAS EG, SAS EMiner

Operating Systems: Linux, Solaris, Windows and MAC OS.

Certifications: SAS Certified Base Programmer for SAS 9.

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Graduate Research Assistant

Responsibilities:

• Worked on a real - time project consisting of a healthcare data, it consisted of questionnaire data from survey results on drugs and performed modelling and clustering and statistical analysis to get teh contributing factors.
• Also worked on Data Management, Data Visualization, Prediction models, Machine learning techniques for model building and testing of models under different scenarios.
• Developed an automated process for scraping data from a movie website and performed extraction, transformation & loading of data into structured format and performed analysis on reviews.
• Maintained teh college graduate student’s database and performed visualization and generated reports for teh analysis purpose using Excel Pivot Table, Tableau.

Confidential

SAS Consultant

Responsibilities:

• Designed, build and deployed new ETL processes and maintained an existing one’s for jobs automation, validation and reporting using SAS DI studio and other SAS EBI tools like SAS EG, SAS WRS and SAS Imap.
• Improved teh performance of existing ETL processes and responded quickly to fixes and enhancement requests
• Extracted data from different sources (Flat files, Teradata, oracle DB, SPDS), transformed and restructured data and loaded it into data warehouses for reporting and analysis purposes.
• Extensive experience in SDLC process including requirement gathering, analysis, planning, designing, coding, unit testing & implementation and prepared teh relevant documents in Dev/Prod environments.
• Performed complex report conversions, mapping and critical data analysis and founded key performance indicators (KPI’s) and drivers using analytics tools.
• Contributed for maintenance and efficient use of SAS applications, development ofbackup strategies, performance tuning,capacity planning,
• Strong problem solving and technical skills, strong collaboration wif team members helped in providing solutions to teh business in given estimated deadline leading to high customer satisfaction.
• Performed User Acceptance testing(UAT) and did analysis and rectified teh Production issues.
• Developed SAS SQL procedures, Macros and Unix Shell Scripting for automation, data validation and reporting.
• Prepared, analysed and distributed monthly revenue report, quarterly historical performance report for various merchants like JcPenny, Wal-Mart etc.
• Provided key insights and patterns to teh clients for forecasting & help them in driving teh business analysis.
• Created analytical dashboards using Advanced Excel, SAS VA and Tableau and published reports on Client’s SAS Portal and producing HTML, RTF, CSV, and PDF formatted files as per requirement.
• Performed data and predictive modeling, statistical analysis & visualization using SAS tools (SAS Eminer, SAS EG, SAS VA) and Tableau and helped clients in decision-making or quantitative analysis.
• Created VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Used advanced Microsoft Excel to create pivot tables, used HLOOKUP, VLOOKUP, and other Excel functions.
• Worked on data cleaning, transformation, normalization of data using SAS procedures and macros and implemented simple to complex data conversion from unstructured data to structured formatted data.
• Analysed customer data using quantitative & statistical approaches and provided actionable recommendations.

Confidential, Hoboken, NJ

R Programming

Responsibilities:

• Performed data cleaning, normalization and applied different classification techniques (Random Forest, Naïve Bayes, Decision tree, KNN, ANN etc.) and founded key indicators and compared model’s accuracy.Analysis of Content Extraction on a YELP Website (Python Programming)
• Implemented Web-Scraping on a YELP website where thousands of reviews are analyzed and performed data cleaning & modeling using Machine learning techniques to train teh model and performed Context Extraction and came up wif a meaningful information out of it.Performing teh Sentiment analysis on Twitter Reviews (SAS and R)
• Extracted Airlines tweets using twitter developer API and cleaned teh data by removing teh unwanted terms performed sentiment analysis on thousands of reviews and came up wif a meaningful information.Created a Re-engineering framework for an oil company (MS Visio)
• Demonstrated Re-engineering framework and strategy for an Oil Company using BPMN models.Analyze teh variables affecting teh healthcare costs at Wisconsin’s Hospital (R Programming)
• Analyzed teh hospital dataset, to research on teh healthcare costs and their utilization to find teh age category of people who frequent teh hospital and has teh maximum expenditure.
• Used ANOVA, PCA and Linear Regression and created a model and founded teh variables affecting teh hospital costs and their correlation.Credit Card Sales Analysis for a Bank (SAS and Tableau)
• Responsible for data cleaning and storing data in small data marts using SAS and created dashboard & Reports using Tableau based on yearly, monthly and quarterly sales for different regions.