SAS Programmer

PRASHANT RANA

Email: ********.********@*****.*** mobile: +1-443-***-****

Website: https://www.linkedin.com/in/prashant-rana-a0b876153/

A SAS Programmer at The Hilltop Institute with a Master’s degree in Information Systems at the University of Maryland, Baltimore County. My coursework focused on Database/Data warehousing Techniques, Data Manipulation, Data Visualization, Data mining and Analysis using tools including SAS, SQL/Database Administration, Tableau, Python, and ETL. With my strong technical background coupled with my communication skills and strong ability to perform in a team environment helps me overcome business challenges.

EDUCATION

University of Maryland, Baltimore County (UMBC) Baltimore, MD

MS, Information Systems, GPA: 3.66 Completed May 2019

University of Mumbai Mumbai, India

BE, Information Technology, GPA: 3.8 Completed June 2015

SKILLS

Programming: SAS, T-SQL, PL/SQL, shell scripting, Python, HTML5, CSS3

Database Technologies: Oracle Database Express Edition 11g, MySQL, MS SQL

Tools and Technology: Tableau, Spyder, Jupyter Notebook, Orange 3, SQL Server Management Studio, SSDT, SSIS, SSRS, SQL Developer, Netbeans, Eclipse, Microsoft Excel, Microsoft PowerPoint, Microsoft Word

Operating Systems: Microsoft Windows, Linux, Ubuntu

Relevant Courses: Data Analytics Using Statistical Learning, Data Mining, Advanced Database Project, Health Informatics, Decision Support System, Distributed System

RELEVANT EXPERIENCE

The Hilltop Institute Maryland, U.S.A

SAS Programmer June 2019(Present)

Use SAS Programming to create desired health datasets to use for analysis.

Work closely with the Maryland Department of Health to understand and fulfill their data request, targeting the betterment of vulnerable populations in Maryland.

Maintain and manage data on the SQL database and visualize it using Tableau.

Graduate Research Assistant October 2018 – May 2019

Data Analyst Intern May 2018 – October 2018

Created a Data warehouse based on Star schema (Online Analytical Processing) suitable for reporting purpose

Created a Decision Support System for Maryland Department of Health (MDH)

Optimized the performance of Medicaid Management Information Systems OLTP database

Performance Tuning of Tableau server and SQL server along with CTO of The Hilltop Institute

ETL process via SQL Server Integration Services for Data warehouse maintenance and automation of processes

Alepo Technologies Pvt Ltd Mumbai, India

System Engineer June 2015 – May 2017

Analyzed Logs, maintained Database replication and performed Database Installation which ensured service redundancy and fault tolerance mechanism

Monitored AAA, PCRF, OCS servers based on RADIUS, DIAMETER and LDAP protocols which allowed end users to connect to LTE, 3G, WiMAX, Wi-Fi monetization/ offload network

Maintained MySQL/ORACLE/Maria DB with admin privileges on Redhat/CentOS Operating systems

Examined packet captures via Wireshark and led implementation of Logstash as a data analysis tool to maintain SLA

Contact this candidate