Independent Consulting, Resume,

SUMMARY

Globally ranked among teh top 5 Snr SAS Programmers.
TEMPHas experience in programming, SDTM clinical trials, Possess good communication, interpersonal and problem solving skills.

TECHNICAL SKILLS

SAS /Base, SAS/Macro, SAS Data Integration Studio(Fluent), SAS Enterprise Guide(Fluent), Excel(Fluent), SQL(Advanced), C++(Intermediate), C#.NET (Intermediate), Unix(Intermediate)ETL, Data warehousing, Data Analysis

PROFESSIONAL EXPERIENCE

Independent Consulting

Confidential

Responsibilities:

Designed clinical data sets form CDMS to SDTM model.
Renamed variables to SDTM terminology as per CDISC standards.
Wrote SAS macros to automate teh entire SDTM process.
Resolved TYPE 1 and TYPE 2 errors by teh automation process, which produced plots against two independent variables.
Gave TEMPeffective programming practices in SAS language to clients.
Consulted wif various clients on teh significance of agile methodologies which would result in TEMPeffective communication between team members and ensure smooth operation of teh business.
Consulted wif clients on IT data warehouse design patterns like star schema, data vault which would streamline their business process in an TEMPeffective manner.

Senior SAS Programmer

Confidential

Responsibilities:

Implemented teh Marketing Automation Project by contributing to significant changes in teh data warehouse design which used teh Data Vault methodology.
Used SAS Data Integration Studio 4.2 to design and build teh ETL process. Used SQL join, Lookup and Surrogate key generator transforms TEMPeffectively, also used teh publish email transform to send email, modified teh Lookup and Surrogate key generator transforms to give desired results.
Designed SAS DI Studio jobs to validate teh data in teh data vault design for UAT.:
Completed teh project under a very tight deadline, dis TEMPhas resulted in successful creation of teh tables needed for teh Marketing team to proceed wif their Campaigns theirby saving budget and reducing teh need of extra resources.
Department of Human Services, Canberra

SAS Programmer

Confidential

Responsibilities:

Installed SAS on Windows7, migrated teh legacy programs across SAS servers (WINDOWS to UNIX) during teh transition phase of teh department, tested and re - engineered teh programs and reports to retain their functions.
Established connection between SAS and SQL server using SAS Management console so as to get direct access using LIBNAMNE statement between SAS and MS-SQL server and vice versa.
Successfully automated teh administrative reports by solid programming in SAS Base and SAS Macro language dat show key demographic facts in various government outlays theirby reducing teh manual effort of producing reports on ad-hoc basis.
Used teh INPUT statement to read teh raw data, used teh %sysfunc instead of Data NULL step to use most of teh SAS functions.
Re-wrote teh code written in DATA step to Proc SQL, used CASE THEN and END statement to calculate new derived variables.
Developed algorithms using Proc SQL to calculate regional and metro areas based on latitude and longitude variables, GEODIST function and CASE statement.
Created teh Response dataset, teh Map dataset and Annotate datasets needed for Proc GMAP.
Developed thematic choropleth map using Proc GMAP, used teh %ANNOMAC macro to display labels in teh map.
Wrote and maintained technical documentation about teh metadata of datasets, SAS formats, SAS programs and algorithms.
Created datasets for Formats and created formats using Proc FORMAT, used CNTLIN and CNTLOUT options to generate formats to and from datasets.
Ensured consistency in naming of Formats. Generated reports using Proc GCHART, Proc GKPI, and Proc PRINT, Proc TABULATE.
Automated teh reports by using SAS Macros and Proc SQL, %do %while loops, %do %until loops, indexed and non-indexed arrays where possible.

We provide IT Staff Augmentation Services!

,

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship