SAS Programmer

N ame: ROHIN I MU K HERJEE

P hone: 919-***-****

A ddress: 605 West Chapel H ill Street,

Apt # 440, Durham, NC, 27701

E - m a il : ***********@*****.***

C AREER OBJECT I VES:

Looking for an opportunity to apply my professional SAS Programming,

Communicative and In terpersonal skills with accuracy and a long with innovative ideas

to accomplice and enhance the Business credibility of my organization.

SU M MARY OF QUAL I F ICAT IONS:

Certified SAS professional with 4+ years work experience in accessing, manipulation,

analysis of big data and generating Reports using SAS software. Hands on experience

and thorough understanding of SAS Business In telligence toolset and i ts configuration

on windows platform.

Familiar with the software development life cycle (SDCL). Command in importing and

exporting complex internal data to and from Microsoft Excel and Microsoft Access

using PROC Copy, PROC I MPORT and PROC EXPORT.

Proficient in SAS V 9.3 with strong experience in Base SAS, SAS/Macro, SAS/Access

and SAS/SQL under windows Enviroment. Strong understanding of data cleansing,

data management and data processing techniques like merging, concatenating,

i nterleaving, appending of SAS datasets and data validation using Proc Compare and

P roc Freq.

Good understanding of SAS functions like character functions, date functions and

familiar with SAS Formats and Informats .

H ands on experience in preparing Summary reports with descriptive statistics using

P roc Means, Proc tabulate and the Proc Univariate procedure.

Thorough experience in extracting data from various disparate data sources like (xls,

csv, txt) files, SQL Server, MS-Access, etc. Ability to analyze and process data using

various SAS procedures such as utili ty procedure, report procedures, statistical

p rocedures.

Vast experience in SAS Enterprise Guide in creating stored processes using the

dynamic prompts containing both packaging and streaming output, and prepared

reports using ODS.

Well versed with platform for SAS Business Analytics typically client t ier consisting of

SAS Enterprise Guide, SAS Add-in for Microsoft Office, SAS Information Map Studio,

SAS OLAP Cube Studio and middle tier consisting of SAS Information Delivery Portal,

SAS Web Report Studio, SAS Stored Process Web Application, SAS Content Server,

SAS BI Dashboards and SAS Management Console used to create the metadata

l ibraries.

Very proficient with the SAS Visual BI (JMP). Wide experience in building an

i nformation Consumer Reporting Application.

Ability to work efficiently in both independent and team Enviroments. Possess

excellent communication and problem solving skills. Reputed for dedicated teamwork,

communication and presentation skills, solid work ethic and commitment to achieving

various goals and key objectives as set forth by the senior management of the Company.

CERT I F ICAT IONS:

• Certified Base SAS Programmer with a score of 97%

• Certified Advanced SAS Programmer with a score of 82%

• Certified BI Content Developer with a score of 88%

T EC H N ICAL SK I L LS:

Operating Systems: MS Windows XP/Vista.

Language: SAS 9.3, SQL, Macro.

SAS Tools: SAS/Base, SAS/Macro, SAS/SQL, SAS/ODS, SAS/Access, SAS/OLAP Server,

SAS BI Platform, SAS EG, SAS add-in Microsoft Office, SAS WRS.

Office Tools: M S-OFFICE, Word, Excel, PowerPoint, HTM L.

Business In telligence: SAS Enterprise Guide, SAS Data In tegration Studio, SAS

I nformation Map Studio, SAS Web Report Studio, SAS Information Delivery Portal,

SAS BI Dashboard and JMP, SAS OLAP Cube, and SAS Add-in for Microsoft Office.

ED UCAT ION:

Bachelor of Laws and Bachelor of Arts - BA.LL.B (Hons.)

P ROFESSIONAL EXPER I E NCE:

J aypee Group of Companies, Noida, India- J une 2011 to July 2014

KEY RESPONSIBI L IT IES: SAS Business Analyst

Created stored processes from SAS Enterprise Guide Projects. Created I MAPS using

d ifferent Data sources and created fil ters as well as prefil ters, compound fil ters etc to

subset the Information Map data, built OLAP Cubes to answer analytical queries

against multidimensional data. Created SAS Data In tegration Studio Jobs. Worked on

t he SAS Prompting Framework.

Created data sources using SAS Enterprise Guide as well as SAS Programs.

Designed Dashboards thereby creating Indicators . Explored the SAS In tegration with

J MP.

Manipulated complex data sets using SQL and related techniques to develop efficient

SAS code. Reviewing Business requirements for standard reporting.

Use SAS Macro Facility to create and call user-defined and automatic macro variables

i n both compilation and execution stages to automate programs by defining and calling

SAS Macro Program and macro functions.

Worked on SAS Business In telligence platform to drive the automation of standardized

analytics.

Generating SAS EG stored processes with static and dynamic prompts for product-

specific analysis. Modifying existing codes for improvement in the performance.

Advanced Querying using SAS Enterprise Guide, manipulating data for reporting,

G raphing, statistical analysis, summarization and generating Reports.

Created and consolidated Reports using several internal and external sources th rough

t he development of standard Macros.

Summarized grouped data and read raw data files with formatted input.

Created reports using Proc Tabulate to display statistics in tabular format.

Generated codes in order to develop and deliver current business solutions through the

automation of consulting processes, providing ideas to create more efficiency within the

team.

Developed macro programs defining the macro parameters using different debugging

options like MPRINT, M LOGIC, and SYMBOLGEN.

ENV I RO M E N T: SAS/Base, SAS/SQL, SAS/Macro, SAS/Access, SAS Business

I n telligence, SAS Enterprise Guide, SAS Web Report Studio, SAS Data In tegration

S tudio, MS Office Tools.

W NS Global Services, Gurgaon, India- A pril 2010 to June 2011.

KEY RESPONSIBI L IT IES:- SAS Programmer

Produced quality customized reports by using Proc Report and provided descriptive

s tatistics using Proc Means, Proc Freq and Proc Univariate.

Developed SAS Macros for data cleansing and Reporting.

Generated HTM L and RTF reports using SAS Output Delivery System.

Performed data and programmed validation to ensure the quality of deliverables meet

i nternal standards.

Generated analysis data sets and conducted required study analyses.

Validating the datasets and comparing the results to that of source programmer’s

output.

Created Analysis Datasets, Summary Tables, L istings and Plots according to the

specification of the study for statistical analysis.

In Data Transformation and Manipulation process, extensively used procedures like

SQL, Transpose, Tabulate, Copy, Sort and Datasets etc.

Created large datasets by combining individual datasets using various inner and outer

joins in SAS/SQL and dataset merging techniques of SAS/BASE.

ENV I RO M E N T: SAS/Base, SAS/SQL, SAS/Macro, SAS/Enterprise Guide, Windows,

SAS/Access, SAS/ODS, MS Office, SAS/Web Report, MS Excel.

•

Contact this candidate