SUMMARY

• Statistical Programmer with 7 Years of experience in analysis, design, development, validation and implementation of Mortgage, Banking and Financial industries. Extensive experience in handling multiple projects in given timelines.
• Worked with Senior Statisticians and Data Managers to provide SAS programming in analyzing the data, generated Reports, Tables, Listings and Graphs.
• Extensive experience in BASE SAS, SAS/MACROS, SAS/STAT, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/GRAPH in Windows environment.
• Experienced in producing Excel, RTF formatted files using SAS ODS to produce ad - hoc reports for presentation and further analysis.
• Solid understanding and proficient use of various procedures like proc SQL, proc summary, proc report, proc freq, proc means, proc contents, proc dataset, proc append, proc import, proc export, proc print, proc sort.
• Cognizance with data creation, extraction, cleansing, manipulation, transformation, exploration, summarization and visualization.
• Proficient with relational database concepts such as SQL, MS Access and Reporting using SAS.
• Experience in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Thorough knowledge in SAS Programming using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in manipulation, and preparation to produce summary datasets and reports.
• Thorough knowledge and experience of Microsoft Office tools like MS Access, MS word, MS Power Point and MS Excel.
• Energetic self-starter with excellent analytical, organizational, quantitative research, mathematical analysis, attention to detail, problem solving and reporting skills.
• Capable of handling multiple tasks, manage multiple projects being flexible and responsive, and translating key business findings and insights based on data analysis.
• Enthusiastic learner of new technical tools and software applications and present ideas in a clear and concise manner to senior management.
• Ability to work in high speed, hectic environment with a sense towards urgency and prioritizing responsibilities by working independently but also cohesively in the team with positive demeanor executing analysis plans, meeting the deadlines.
• Highly motivated with excellent organizational and interpersonal skills.
• Ability to work independently as well as collectively & willing to relocate.

TECHNICAL SKILLS

SAS/ SAS Tools: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/ODS, SAS/ACCESS

SAS Procedures: Print, summary, Report, Tabulate, Univariate, Means, Freq, SQL, Import, Export, Append, copy, formatTranspose, Datasets, Compare, Gplot, Sort, Regression

RDBMS: SQL.

Office Tools: MS-Office.

Operating Systems: MS-DOS/Windows 2000/XP/7/8

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Statistical Programmer

Responsibilities:

• Performed statistical analysis and data management on study data by utilizing appropriate statistical methods by using SAS tools.
• Gathered and analyzed data/metrics from multiple sources such as site analytics.
• Used to design, building and testing a series of SAS programs for generation of datasets automatically without giving parameters from outside.
• Used to develop Macros for automatic running of all programs like Merging, Sorting, Printing of ODS files.
• Used to access the data from Oracle DB and SAS datasets /importing the initial data from the source files.
• Restructured SAS datasets using PROC TRANSPOSE for the analysis.
• Developed reports using PROC REPORT and DATA NULL .
• Also provided descriptive statistics using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Wrote code using SAS/Base and SAS/Macros to extract clean and validate data from flat file, Excel file and Oracle Database.
• Developed MACROS to create Tables, Listings and Figures (TLF’s) also developed macros for Data Management use.
• Identified out of trend results and data issues and drives for resolution with data owners and appropriate service and support teams.
• Published key service and support performance metrics in a consistent manner with a focus on accuracy and timeliness.
• Created results presentations and facilitated results review meetings with senior leadership, directors and managers to analyze results and action planning.
• Provided executive ad hoc support for business reviews.
• Developed current year best views and long range forecasts for site-adoption and marketing metrics and obtains approval from the Digital Experience senior leadership team.
• Coordinated with external organizations on the target-setting process.
• Collaborated with delivery team to improve data collection and web-based tracking.
• Used various procedures such as Proc Sort, Proc Means, Proc Freq, Proc Format and Proc Report to generate Tables, Listings, Graphs and Reports.
• Provided SAS Programming support and technical assistance in the accurate development and intermediate steps required.
• Presented statistical results using the appropriate Graphs, Charts, Tables and written Reports.

Environment: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPHS, SAS/ACCESS, SAS/ODS, MS-OFFICE

Confidential - Minneapolis, MN

Statistical Programmer

Responsibilities:

• Created Reports for online and batch applications for various servers.
• Prepared Graphs using the modified data for business analysis.
• Co-ordinated the production of monthly, quarterly, and annual performance reports for senior management.
• Developed efficient, well documented, readily comprehensible, modifiable and reusable SAS programs using Base SAS and SAS Macros.
• Performed programming validation to ensure quality of analysis datasets and programmed outputs.
• Extracted database files using SQL Pass through Facility and LIBNAME statements.
• Performed Data Cleaning, Data Validation and Data Documentation on the work developed by other programmers.
• Created ad-hoc reports as per the requirements.
• Used Proc Import/Proc Export, SAS/ODS to generate datasets from external file formats (Excel, Access and PDF) and to convert created datasets into external file formats.
• Performed data integrity checks and data cleaning using SAS Macros and data step.
• Provided statistical and output manipulation techniques using Procedures like Proc Means, Proc Sort, Proc Print, Proc Freq, Proc Univariate, and Proc Anova.
• Extensively used PROC GPLOT and PROC GCHART for generating graphs.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Created Data Dictionary and migrated the data when shifting to new version of SAS.
• Results are performed using SAS programming and using techniques such as SAS Macro language, advanced data manipulation, and statistical procedures (e.g. PROC FREQ, PROC REPORT).
• Ran reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/GRAPHS, SAS/ACCESS, SAS/ODS, MS-OFFICE.

Confidential, NY

SAS Programmer

Responsibilities:

• Developed and executed complex programs and reports with proper documentation.
• Developed business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools like SAS, MS office.
• Used SAS data step functions, formats, statements and procedures like PROC FORMAT and to map the variables to the customer’s needs.
• Involved in writing code using BASE SAS andSAS/Macros to extract clean and validate data from oracle tables.
• Created SAS datasets and SAS views by extracting data from Oracle tables using SAS SQL.
• Extensively used data manipulation procedures such as merge, append, set to create analysis data sets.
• Generated summary reports and descriptive statistics using SAS/Base and SAS/STAT Procedures
• Created and applied user defined formats to specific variables in SAS data sets.
• DevelopedSASprograms usingSAS/BASE andSAS/SQL for preparing analysis and reports from databases.
• Independently delivered end to end on complex projects and assist in developing and testing new information infrastructure.
• Managed end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.
• Independently executed standard processes, implements predefined algorithms and correct identified problems.
• Maintained large data sets i.e. reading in data from various sources in various formats to create SAS data sets.
• Documented the process i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Developed business and technical knowledge of team members and identifies opportunities of improvement.

Environment: SAS/BASE, SAS/ STAT, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Graphs, MS-Access.