Objective
Aspiring SAS professional seeking an opportunity with organization that recognizes and utilizes my technical and analytical skills, along with nurturing them for professional growth.
Summary
Certified Base SAS programmer
Around 2 years of experience Software developer.
One year experience with SQL.
Possess good working knowledge of SAS 9.3 tools such as Base SAS, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/Report and SAS/ODS.
Strong knowledge of SAS skills related to data management, reports, data structures and error handling.
Experience in transforming data imported from disparate data formats into SAS Datasets.
Hands on experience in cleaning and resolving data issues and merge data from different sources onto a single integrated dataset.
Good data analysis skills and experience in generating tables, listings and reports from SAS datasets.
Good analytical and problem solving skills
Quick learner and ability to work under pressure with strict timelines.
Certifications:
Certified Base SAS programmer for SAS 9
Oracle Database 11g: SQL Fundamentals
Education:
Masters in Information Technology - Panjab University
Bachelors in Computer Applications – Punjab Technical University
Technical Skills:
Languages: SAS 9.3, SQL, PHP
SAS Tools: Base SAS, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/REPORT, SAS/ODS
Databases: MSSQL, ORACLE, MS-Access
Tools: MS Excel, MS-Word, Jira, Quality Center
SAS Training
NXlogic Monroe, NJ
SAS datasets – loading, reading, manipulating and creating new datasets.
Reading raw data, and excel data.
SAS functions for data manipulation, conditional and grouping logic.
Subsetting, sorting, summarizing and printing of data using ODS.
Effectively used many SAS functions like SCAN, SUBSTR, PUT, INPUT, TRIM, MDY
Utilized PROC SQL, PROC REPORT, PROC FREQ, PROC MEANS, and PROC UNIVARIATE functions.
Debugging SAS compiling errors and identifying issues, producing reports or analysis data sets and SAS data sets.
Developed SAS/Macros to have reusable code, rather than repeating the same.
Experience:
HR Coordinator (Part-time)
Pegaframe Infotech Inc. Princeton, NJ
June 2016 – Till date
Responsible for preparing documents with H1b filings and transfers, Initiating LCAs, and RFEs.
E-verification of employees.
IT bench sales for securing suitable opportunities for employees.
Software Developer
Client: Future Computing Solutions India, Chandigarh
Oct 2005 – July 2007
Project: (www.sikhpoint.com) Blogs and Forums. The Sikhpoint Blogs is a journal (or newsletter) that is frequently updated and intended for general public consumption. These blogs are often a mixture of what is happening in a person's life and what is happening on the Web, in matter related to Sikhism. Also worked on Forums, where user can discuss or query anything related to Sikhism.
Designing DB schema and creation of tables.
Designing and coding of PHP templates.
Writing SQL queries for DB access