SUMMARY:

• 7+ years’ experience in Base SAS, SAS/Stat, SAS Macros, SAS/Graph and SAS/Access on Windows and UNIX platforms and competence in carrying out statistical analysis of large - scale data.
• Experience in using data steps in SAS for creating, maintaining and manipulating datasets.
• Experience in using various statistical procedures in SAS such as Proc SQL, Proc Sort, Proc Freq, Proc Univariate, Proc Means, Proc Transpose, Proc TEST and Proc Import.
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
• Hands on experience in performing client installations and configuration of various SAS products like SAS Enterprise Guide 7.1, SAS Enterprise Miner, SAS Add-in for Microsoft office and SAS Model Manager, SAS Enterprise Business Intelligence, SAS Visual Analytics 7.1 on shared environment and individual architecture on windows and Unix/Linux operating system.
• Performed Installation and Configuration SAS 9.2, SAS 9.3 and SAS 9.4TS1M4 on Shared grid environment installed.
• Working experience in SAS Access, SAS Connect, SAS/SAS DI, SAS EG.
• Experience in performing adhoc queries and User Acceptance Tests (UAT) for various applications and reports on a daily/weekly or monthly basis
• Well versed with creating HTML Reports for financial data using SAS ODS facility, Proc Report and extraction of data SQL-pass-through, PL/SQL facility. Wide-range experience in data manipulation and generating customized reports with SAS data steps and procedures
• Have experience on end-to-end process in reporting and generation of analysis datasets including SAS DI.
• Created reusable Macros extensively, used existing Macros, and developed SAS Programs for cleaning, validation, and analysis and Report generation.
• Analysing, developing, designing, implementing and automating the new reports arising out of new specification and reporting requirements.
• Excellent analytical, logical, error debugging and problem solving skills
• Experience in administering SAS Grid environment, SAS Management Console and SAS LSF, SAS applications, SAS environment manager, Platform RTM, SAS Deployment Manager.
• Quality assurance procedures of other programmer’s work, validating, debugging, documenting and optimizing SAS programs for QC and QA.
• Using ODBC to connect SAS System with relational database management systems to retrieve data and create SAS datasets.
• Experience with export SAS Results to different format, such as XML, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Experience in creating and maintaining many datasets using Array, Merge, Update, Set and Proc SQL.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Have experience in different databases like Oracle and Teradata
• Experience in exploratory data analysis.
• Experience in Quality Center -executing tests manually, defect logging, and defect reporting.
• Effective Oral and Written communication.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/REPORTS, SAS/ACCESS, SAS/STAT, SAS/EG, SAS v 9.3/8.2.

SAS Procs: Print, Means, Univariate, Correlation, Regression, SQL, Tabulate, Freq, Sort, Summary, Format, Import, Export, Transpose, Compare, Life Test, and Gplot.

Languages: SQL, PL/SQL, C, VBA, HTML, XML, VB Script, VB6.

Database: Oracle 10g, Teradata, Netezza, SQL Server 2000, MS Access.

Operating Systems: Windows XP/NT/2000/98, MS DOS, UNIX.

Others: Java, MSOffice (Word, Outlook), SPSS.

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

SAS Developer

Responsibilities:

• Worked with the Market Penetration and Customer retention team in the Customer Insight Analytics department in FEDEX which dealt with the data of various commercial alliances.
• Developed SAS code to manipulate raw data and validate data integrity.
• Extensively used SAS/ACCESS to Teradata for pulling data from database.
• Created source to target data mapping documents and ETL design document.
• Took responsibility for most complex, multi-site, multi domain SAS activities and integration.
• Creating and removing the users, user groups, and roles on the SAS Metadata and accessing the libraries by using SAS Management Console.
• Extracted of data from fact and dimension tables and created SAS repository.
• Involved in coding and pulling data from various oracle tables using Unions and Joins.
• Created and maintained of automatic scheduled jobs using automatic macro variables.
• Involved in extracting data from the mainframe to UNIX via SAS EG
• Optimized the existing daily report jobs in Unix Environment, monitored logs and debugged errors associated.
• Sourced and analyzed data from a variety of sources like SAS data sets, MS Excel, CSV, XML, and flat files etc.
• Connected and extracted required data as per business logic from Oracle and Teradata using the LIBNAME method and SQL pass through facility.
• Communicated with third party vendors and other departments within the company for the purpose of gathering requirements to run several monthly and quarterly reports.
• Used SAS Enterprise Guide for data access, data cleaning, manipulation, analysis and reporting.
• Created and customized macro programs/macro variables to pull data more effectively.
• Used the shell scripting to securely transfer files to other development/production/quality servers used by other departments.
• Worked on SPDS implementation/support side lambda.
• Configured SAS access to Hadoop from SAS grid environment to Horton works HDP platform.
• Regular Monitoring of SAS Servers to ensure the performance. Extracted metadata reports by using SAS Enterprise guide, SAS code.
• Excelled in Change Management procedures, problem management procedures and version control for SAS code. Worked on Data analyzing Platform.
• Created and delivered reports and presentations with key findings and recommendations.
• Performed data quality analysis using advanced SQL skills.
• SAS data sources connected to the SQL, Oracle, Hadoop, Teradata and DB2.
• Automated SAS jobs running on a daily, weekly and monthly basis using Unix Shell Scripting.
• Adding/removing queues and hosts inLSF cluster and set user limits to submitting the job. Worked on Data Warehousing for developing dash boards for BA.
• Attending sessions along with users organized by SAS Experts about various SAS Products and clearing up the user’s queries regarding SAS Grid.
• Assisted in filtering the identifiers of the top global customers in alliance with the FedEx by analyzing and cross validating customer level data across several tables.
• Communicated with Manager and Peers to determine data mapping flow between different relational tables in different schemas to ensure the business logic could be integrated most effectively while working on the ad-hoc requests.
• Validated data in production and development environments for the Organization's internal dashboard.

Confidential, Des Moines, IA

SAS Developer

Responsibilities:

• Worked with business users to design and develop several ad-hoc that integrated complex business logic. The reports created include Annual Reports on different Health Care Measures.
• Performed installation and configuration of version SAS 9.3. Administered various SAS servers and applications, user definition, group definitions, grid nodes by using SAS Grid Manger, SAS management console, wrote scripts. Managed the SAS repositories, libraries, folders.
• Performed user data migration on cross platform by using SAS migration tools like PROC MIGRATE, PROC CPORT, PROC CIMPORT.
• Generated HTML codes using VBA
• Imported/exported large amounts of data to and from Teradata
• Utilized ODBC for establishment of connectivity to Teradata & MS Excel for automating reports and graphical representation of data to Business and Operational Analysis teams
• Built various types of Grouped reports, List Reports, Cross Tab Reports, Chart Reports using
• Cognos experience in interacting with SAS Technical support and opening tickets about issues when required.
• Experience with UNIX shell scripts to set the performance limit to cluster.
• Installed different Oracle clients 11g and add Oracle database servers to SAS servers from SAS Management Console.
• Supported to various SAS products SAS Management Console, RTM, SAS DATA integration studio, SAS Enterprise guide, SAS Enterprise Miner.
• Monitor the backups regularly and tested restore SAS content the from backup file.
• Connected to the Oracle database and extracted the relevant data (using LIBNAME or Pass-through facility) and then processed the data using business logic to produce reports. Made use of Proc SQL, Proc Report and ODS for producing these reports.
• Used SAS Enterprise Guide to access data, to manage data, to create reports and to validate data healthcare data.
• SAS Procedures used are Proc Append, Macros, Import and Export, Proc Transpose, Proc Datasets.
• Handled the tasks of manipulating data by using UNIX platforms.
• Customizing the existing Macros according to need and requirement, testing and debugging the Macros and creating more complex and reusable Macros.
• Used Enterprise Guide (EG) query builder to run queries against the tables and sub setting the data.
• Quality assurance procedures of other programmer’s work, validating, debugging, documenting and optimizing SAS those programs.
• Validating the accuracy of the data in context to the front end application structure using PL SQL.
• Produced statistical reports for various business needs and expertise in data preparation, data cleaning, analysis, and reporting.

Confidential, Charlotte, NC

SAS Programmer / Analyst

Responsibilities:

• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Window environment
• Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.
• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Extracted data from different sources like Oracle and MS Access, Excel, and text files using SAS/Access, SAS SQL procedures and created SAS required datasets u sing survey programming and/or data processing.
• Designed, developed, and tested software to implement the models using SAS statistics procedures.
• Creating excel pivot table reports using Cycle Time data. These reports consist of Customer level data. These reports are very useful to get a greater insight into the further plan design.
• Automated the existing audit and production programs.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Debugging SAS programs using data null, Put statements and using data step debug.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• 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.
• Created reports using Proc Report, Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML Excel and RTF.
• Documented the code and algorithms logically.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Confidential, Louisville, KY

SAS/Programmer

Responsibilities:

• Reviewed Business Process and Develop Process Flow Diagrams.
• Analyzed discrepancies in the prescribed medications among providers to decrease company’s healthcare cost.
• Worked with Health care data which includes various claims, membership details and of the members.
• Gathered and assimilated data from Oracle, SQL Server and reporting requirements from business.
• Extracted data from oracle database using SQL pass- through facility.
• Created reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Sourced and analyzed data from a variety of sources like SAS data sets, MS Access, MS Excel, CSV, XML, and flat files etc.
• Analyzed the claims data, future trends and summarized results to generate meaningful recommendations for management.
• Coded, Modified and automated existing SAS programs to automate process, improve efficiency.
• Used various SAS ODS techniques to generate complex reports.
• Performed quality control (QC) checks on peer developed programs to ensure that the correct source data is used, correct code and logic are used.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets.
• Used Enterprise Guide (EG) for creating, editing and submitting SAS code for stored processes to Application server, for running queries against oracle to bring the data into the SAS environment.
• Researched for cause of errors in code and modified code per requirements.

Confidential, Springfield, IL

SAS Developer

Responsibilities:

• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment
• Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.
• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables.
• Advanced analytics and reports created based on the criteria provided.
• Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Performed approvals for peer audit reviews on reports by analyzing data.
• Developed SAS Macro programs to create ad-hoc reports.
• Developed application for measuring financial performance of newly acquired accounts such as Forecast vs. Actual and developed SAS programs for generating reports on key financials, Income Statements and Balance Sheets.
• Converted the financial data retrieved from vendors into SAS readable format and executed the datasets to produce necessary financial reports using SAS/STAT procedures such as PROC FREQ, PROC REPORT.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE. Used DBLOAD procedure to load data into the database effectively prepared and published various performance reports and presentations.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.