PROFESSIONAL SUMMARY:

• Over 6 plus years of extensive experience in SAS programming on different platforms - Windows, UNIXD & Mainframes also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validationWorking knowledge inSASProgramming, using BaseSAS, Macro Facility, PROC SQL,SASProcedures,SASFunctions,SASFormats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Experience in Data analysis and Reporting in retail, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial, marketing and health care data and in the production of reports, tables, graphs and listing.
• Worked with BASESAS(MACROS, PROC SQL, ODS),SASEnterprise Guide,SAS/ACCESS andSAS/GRAPH in UNIX and Windows environment.
• Developed new or modified existing SAS programs to load data from the source and create study specific datasets.
• Proficient in usingSASto import/export data to external file formats like flat, Excel, XML files.
• Involved in writing and updating Standard operating procedures (SOP) for reviews and approvals.
• Worked with various databases like oracle RDBMS and Teradata.
• Working on handling clients Key Enhancement Work Requests by following SDLC process.
• Good analytical skills pertaining to understanding a business domain coupled with excellent teamwork and strong communication skills (verbal & written).
• Highly motivated individual with excellent organizational and interpersonal skills.
• Possess strong ability to quickly adapt to new applications and platforms.
• Good team leader with strong analytical and communication skills.
• Creative, organized, flexible and hard working.
• Ability to plan and influence others in key decision making.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/ACCESS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/REPORT, SAS/ODS, SASEnterprise Guide, SAS/Connect,SASStored Processes Web Application.

Databases: Oracle, Teradata, MS-Access & SQL server.

Operating Systems: Windows98/2000/XP, UNIX, Linux, Mainframes.

Languages: SAS, SAS Enterprise Guide.

Core Competencies: Statistical programming, Data Analysis, Reports Development & MS-OFFICE.

PROFESSIONAL EXPERIENCE:

SASSenior Programmer

Confidential, Brea, CA

Responsibilities:

• BuildSASdatasets from clinical database and Developed programs using the LIBNAME statement &SASViews to extract & report error statistics.
• Worked on extensively remodeling icd9 and icd10 codes.
• Worked on various drug models.
• DevelopedSASmacros, templates and utilities for data cleaning and reporting.
• Contributed to several JAD sessions with focus to eliminate bottle necks form the system.
• Used Microsoft Access and Excel to provide output analysis data.
• Worked on epic systems.
• Worked in tandem with Biostatistics and Data Management member on various clinical projects.
• Imported data from SQL Server and Excel toSASdatasets. Performed data manipulation by merging several datasets and extracted relevant information.
• UsedSASdatasets to create reports using PROC Print and Reports. Also used PROC Transpose, PROC Tabulate, PROC Import, PROCFREQ and PROCSQL
• Used arrays along with PROC Means, PROC Summary and PROC Freq.
• Created drill-down HTML reports for the finance department using data from several sources
• UsedSAS/DDE to call Excel VBA macros in reporting applications development
• UsedSASMacros to produce drill down capability for the reports.
• Produced tables in Excel using ODS and PROC Tabulate as per the business requirements
• Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
• Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets
• Participated in full life cycle of model development: market research, statistical analysis, model development, and reports/presentations

Environment: SAS/BASE,SAS/ODS,SAS/MACRO,SAS/SQL,SAS/GRAPH,SAS/STAT,SAS/ACCESS,SAS/CONNECT, Windows NT Server, UNIX, Microsoft Office,SAS/EG, MS SQL Server, Teradata.

SASProgrammer

Confidential, New York, NY

Responsibilities:

• DevelopedSASMacro programs to create Ad-hoc reports
• Created macro program to create Macro variables to pull data from DB2 for monthly data extraction
• Extracted data from different sources like Oracle and Teradata and text files usingSAS/ Access,SASSQL procedures and createdSASdatasets
• Worked on NTS(National Transplant Services) & data.
• Worked on a Unix, Windows & Mainframes platform in a server application environment
• Passing Macro variables to Unix server from windows remotely created from windows to develop good user interface for the end user
• Done performance tuning for the programs created.
• UsedSASProc SQL pass through facility to connect to DB2 tables and createdSASdatasets using various SQL joins such as left join, right join, inner join and full join
• Prepare daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.) and present findings and recommendations to all levels of senior management.
• SASEnterprise Guide was used to convert existingSASprograms toSASstored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Created dynamic Macro arrays by SQL and with data step programs
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Extensively used BaseSAS- ETL to load data from Teradata, SQL server, oracle, Flat files and sources to Teradata Data warehouse as Confidential .
• WroteSASreports to Excel, theSAScontent server, HTML, and PDF.
• Revising a series of Teradata programs toSASfor extraction of data from Oracle in Enterprise Miner.
• Assisted in the design and testing of program logic, coding programs, program documentation and preparation of programs.
• Developed Macros to replace repetitive codes for generating Descriptive statistics.
• Developed efficient, well-documented, readily comprehensible and modifiableSAScode usingSAS/ Base andSAS/ Macro facility.
• Maintained and updated existing utilities as per project requirements.
• Active involvement in knowledge sharing via presentations at monthly programming meetings.

Environment: SASEnterpriseGuide,SAS/Access,SAS/Base,SAS/Macro,SAS/Stat,SAS/Graph,SAS/SQL, Teradata, EXCEL, Oracle, DB2, VBA, MS Office and Unix

SASDeveloper

Confidential

Responsibilities:

• Project involves developing business applications and analytical tools to detect various types of FRAUD in retail, commercial and Debit Card segments of the bank.
• Directly involved in gathering complex business requirements pertaining to recent or old pattern of abnormal behavior or activity on different channels that would affect the end customer of the bank.
• Convert business requirements into technical specifications using available tools and technologies.
• Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
• UseSAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions.
• Create detailed business and technical documentation for individual projects.
• Maintain and contribute to the modulated software development environment for loss prevention.
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions.
• Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS(Early Warning And Reporting System) applications
• Extensive use of PROC SQL,SASMacros, Unix and Windows Batch Shell for process automation
• Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support forSAS, Oracle.
• Responsible for troubleshooting and delivering outputs using PROD/DEV/QA environments.
• Develop test cases/plan for individual project assignments of Loss Prevention reporting using ID Portal.
• Involved in preparing Data Quality Review Plan (DQRP) to adhere to the internal specifications.
• Provide production support and retrospective version control on the application on ad hoc basis
• Implement the needed fuzzy logic in pattern mapping and segregation of the customer profiles usingSASprogramming techniques

Environment: BaseSAS,SAS/Macros,SAS/SQL,SASEnterprise Guide, SAS/ACCESS, SAS/STAT, Windows 7, UNIX, Oracle, Tableau, Project Management.

SAS JrProgrammer/Analyst

Confidential

Responsibilities:

• Generate EI List for Alerts for the major failures. DevelopedSAScode to generate Reports.
• Extract the data from MDAW by using SQL queries Generate EI List for Alerts for the major failures. DevelopedSAScode to generate Reports.
• Create the stored process as per their requirement for standard Reports and make changes inSAS/MACRO code if needed.
• Preparing Evidence-Package to know detail analysis of a part failed.
• Performed data mining, extracted and explored data bySAS/SQL from databases such as ORACLE, and analyzed and tested large and complex datasets.
• Developed queries to validate and test input and output data sources usingSASand SQL to ensure data quality deliverables and meet the specification.
• Reviewed, analyzed and tracked portfolio performance and risk assessments.
• Interpreted and provided management recommendations and suggestions regarding market strategies.
• Using Enterprise-Guide for Text Analytics, to get the text-themes which are useful in Root Cause Analysis of the failure.
• Helped the team to Automate Supplier Analysis Report using Proc Report and PROC SQL to save time and reduce manual errors.
• Maintenance of reports and enhancements done through SDLC change management process
• Performed UAT testing and debugging of existing programs with test data sets to ensure the reliability of the programs using the VALIDATE statements.

Environment: ENTERPISE GUIDE, STORED PROCESS, ORACLE, TERADATA, SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO,SAS/ACCESS, MS OFFICE