Data Sas
Resume:
Sandeep
acrle7@r.postjobfree.com
SUMMARY:
Over 7+ years of experience in Statistical Analysis Software (SAS) for developing and implementing various applications.
Solid Experience and Excellent command in various SAS procedures and tools like SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/ CONNECT, SAS Enterprise Guide and SAS/SQL in Windows and UNIX operating systems.
Solid understanding and proficient use of various procedures like proc SQL, proc report, proc freq, proc means, proc contents, proc dataset, proc append proc import, proc export, proc print, proc sort.
Expertise in storing and managing data in SAS files, merging SAS data sets, using ARRAYS and MACROS, SAS procedures (PROCs), PROC SQLs, SAS Formats and informats.
Excellent command in writing complex script for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.
Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows
Experience in using various MS office tools for analyzing, arranging and presenting data
Strong experience in coding using SQL, Procedures/Functions, SAS macros.
Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis
Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
Good knowledge in software engineering methodologies
Extensive experience in preparation of reports, tables, listings and graphs
Strong leadership, interpersonal and oral/written communication skills
Ability to work independently as well as collectively & willing to relocate
TECHNICAL SKILLS:
Statistical Packages
SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide, SAS Information Map studio.
Databases
Oracle, Sql Server for Teradata
Languages
SAS, SQL, C, C++, Core JAVA, HTML, XML.
Platforms
Windows and UNIX.
Others
MS office, MS Visio, MS Project Management, VBA macros.
Version
SAS 9.2 to 9.4
EDUCATION:
Bachelors of Technology from SASTRA University, Thanjavur, INDIA.
PROFESSIONAL EXPERIENCE:
PNC Bank, Pittsburgh, PA Jun’14 – Till date
Role: SAS Programmer
DESCRIPTION:
PNC offers a wide range of services for all its customers, from individuals and small businesses, to corporations and government entities. As a SAS programmer I was involved in managing and preparing business case scenarios to validate the end user requirements. I maintained and modified existing SAS programs to include Macro variables to improve the program usage, eliminate redundant programs and increase the efficiency of the overall process on SAS BASE V9.3 UNIX platform.
Responsibilities:
Extracted, updated and deleted data from MS SQL Server using SAS/ACCESS and SAS/SQL
Used PROC IMPORT to convert raw data files in different formats to SAS data sets
Used PROC EXPORT to convert SAS data sets to formats specified by the end-user
Read raw data files with missing values using TRUNCOVER and MISSOVER options
Created SAS reports in external locations using DATA _NULL_ statement with FILE and PUT statement
Generated reports using BASE SAS procedures – PROC PRINT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY
Created large data sets employing MERGE and SET statements in the data step
Utilized SAS/ODS to create reports in PDF, RTF and HTML format
Combined data vertically using SET statements, PROC APPEND and SET operators in PROC SQL
Combined data horizontally using data step merge and by using match merging, in-line views in PROC SQL
Conducted extensive data checks to ensure the reliability of data
summarized and analyzed data employing pivot table and pivot chart in Excel
Performed several statistical functions using SAS/STAT procedures and created one-way and Multi-way tables
Created mailing lists of targeted customers using PROC FORMS
Environment: SAS, SAS/BASE, SAS/ODS, SAS/GRAPH, SAS/ACCESS, SAS/STAT, HTML, Oracle, MS SQL Server, MS OFFICE, VB
GEICO, Chevy Chase, MD Jan ’13 – May‘14
Role: SAS Programmer
DESCRIPTION:
The Government Employees Insurance Company is an auto insurance company. It is the second largest auto insurer in the United States, after State Farm. As a SAS programmer, I have built sophisticated Proc reports using style attributes. I was involved in data cleaning, data manipulation, requirement gathering, generating reports, statistical analysis and data analysis.
Responsibilities:
Extensively used different SAS procedures such as PROC SQL, PROC REPORT, PROC PRINT, PROC SORT, PROC TABULATE, PROC SUMMARY, PROC MEANS, PROC UNIVARIATE, PROC FREQ, PROC DATASETS, PROC TRANSPOSE for data analysis and report
Used PROC GCHART, PROC GPLOT and PROC G3D for generating graphs such as pie-charts, histograms, bar graphs, scatter plots from processed data
Expertly created Macro programs to generalize various reporting needs, thus eliminating the need for creating multiple programs with prefixed values.
Combined multiple raw data files to form a SAS Data set using the FILENAME statement with the FILEVAR= option
Used SAS/ACCESS to extract, insert, delete, update data from ORACLE database
Extensively used DATA _NULL_ statement to generate raw data files, new macro variables and reports which were stored in external locations
Created data set views and indexes to enhance the storage space requirements and CPU system resources
Performed merging and joining of data using merge, set statements in data step methods and by using inner, outer joins, SET operators in PROC SQL
Eliminated duplicate observations in the data set using NODUPKEY and NODUPRECS options in PROC SORT
Used Match-merging to determine the insurance type and the claims filed by the customers based on the unique value of customer ID
Environment: SAS SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SQL, HTML, Oracle, Windows XP
Cigna Health Care, Chattanooga, TN Jan’11 – Dec‘12
Role: SAS Developer
DESCRIPTION:
Cigna, a global health insurance service company, offers health, dental, supplemental insurance and Medicare plans to individuals, families and businesses. As a SAS developer, I was Responsible for scheduling and coordination SAT(QA) to Prod implementation. I applied simple statistical procedures such as PROC MEANS, PROC FREQ in analyzing data.
Responsibilities:
Interacted with business users and gathered business requirements.
Executed ad hoc data analyses in response to business requests.
Maintain the in-scope applications production support levels for lights on door open(LODO)
Monitoring production schedules/jobs
Interfaced with the software development team to resolve production problems, investigate performance issue.
Many production jobs were setup and coded from scratch.
Scrubbing and sub setting data for the purpose of sustaining data accuracy as well as maintaining data quality; creating and selecting new variables.
Monitoring the existing code performance and to change the code for better performance.
PROC SORT procedure was used to sort data sets before applying the MERGE statement when merging various Oracle tables
SAS data sets were constantly created and updated using the SET and UPDATE statements
SQL joins procedure was used to join various data from different data sets across various databases
Imported the spreadsheet data into the SAS using Proc Import procedure then generate the reports.
Proc Export procedure is used for exporting the data from SAS to spreadsheets
Frequently supplied audit reports to the Audit Team based on their queries using various SAS procedures which often included the DATA_NULL_ data step.
Generate customized reports as required per the formats provided by the vendor.
Maintained routine SAS MACROS to create Audit reports, Waterfall reports and Final mailing lists.
Provided required reports to parties concerned to generate the technical specifications and analysis of the data.
Transferring files using FTP.
Modified older programs with hard-corded data values with Macro programs to enhance the flexibility, reusability of SAS programs and also to reduce system resources.
Environment: SASBASE, SAS/MACROS, Subversion SVN, TWS, MS Office, DB2 9.5 on AIX, UNIX
ICICI, Hyderabad, India Jun’ 08 – Dec’10 Role: Statistical Analyst
DESCRIPTION:
ICICI Bank provides Personal Banking, Corporate and Business Banking. I was involved in the revenue assurance department handling Fraud management patterns. I was involved in data cleaning, data manipulation, requirement gathering, generating reports, statistical analysis and data analysis.
Responsibilities:
Modified data using SAS/BASE and Macros.
Employed techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output
Prepared graphs using the modified data for business analysis.
Creation of Data Sets on the Remote Server.
Used shell programming to run weekly and monthly reports
Used SAS/ACCESS to gather data from RDBMS like TERADATA.
Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
Extracted data sets from server using PROC IMPORT and created datasets in SAS libraries.
Coding SAS programs with the use of SAS/BASE and SAS/Macros for Ad-hoc reports.
SAS scripts on UNIX are run, and the output datasets are exported into SAS.
Maintained and enhanced existing SAS reporting programs for marketing campaigns.
Maintained SAS statistical analysis for the products purchased every month.
Run 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/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS Access, Excel, TERADATA.
Contact this candidate