SUMMARY:

• Around 8 years of extensive experience in the field of SAS Programming and Data Analysis projects
• Certified Base SAS Programmer for SAS’9.
• Processed large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Good command in using SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS (Teradata, Oracle), SAS/INSIGHT, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, MS Office tools.
• Expertise in advance SQL programming for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis.
• Experience in creating, registering and deploying stored procedure with SAS Enterprise Business Intelligence tools.
• Created SAS Programs to generate new datasets by importing raw data files and modified existing datasets using SQL, Set, Merge, Sort, Update, Formats and Functions.
• Good command in SAS procedures, reporting and Summary procedures, generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SQL, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Predictive modeling using SAS Enterprise Miner.
• Working experience with PCSAS, SAS Enterprise Guide, SAS Enterprise Miner.
• Skilled in working with PROC SQL, SAS arrays and SAS Macros to automate SAS tasks and to convert and produce file with different formats as per the requirements.
• Working experience with control M workload automation.
• Strong skills in Developing SAS Programs for Data Analysis, Data Requirement Analysis and Data Mapping for ETL process and working with Analysis of Variance (ANOVA), Regression Analysis, Linear Models, Multivariate Analysis, and Predictive Solution Models including linear, multiple, polynomial, and nonlinear regression models.
• Experienced in handling data with data integrity during extraction, manipulation, processing, analysis and storage.
• Responsible for leading software testing, troubleshooting, and implementation.
• Support end - users, company-wide to resolve database and software issues utilizing remote desktop tools.
• Database recovery and subsequent problem resolution.
• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.
• Coordinates project development and implementation activities.
• Query Reports using Access and SQL.
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data. 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.
• Develop SAS and VBA macros for automating the analysis, process, and report generation.
• Excellent programming skills in developing programs to increase the performance and efficiency of SAS programs and importing, extracting and loading the data into various servers like Oracle, teradata, DB2 with specific bulk load techniques.
• Strong Knowledge in advanced analytics and Text and Data mining Techniques.
• Strong background in statistical modeling using SAS, Matlab and Origin.
• Interacted with Business users to understand the Business Requirements
• Good understanding of probability theory, stochastic processes, random variable and events.
• Experience in implementing PDEs and numerical methods to solve real time problems.

TECHNICAL SKILLS:

Reporting Languages: SAS 9.2, JMP Statistical discovery, SAS EG

Statistical Software: Base SAS, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/Access, SAS/Insight, SAS Enterprise Guide, Origin, Matlab

Programming Languages: C, C++, COBOL, JAVA, Python, TCL, Perl, SQL, and Visual Basic 6.0

RDBMS: MS Access, Oracle, SQL Server

Big Data Technologies: Hadoop, HDFS, Hive, MapReduce, Pig

SAS Procedures: Sort, Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary, anova, logistic, glm, mixed, Reg, SQL, Copy, gslide, upload, download, Printto, Datasets, Format, freq.

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

Sr. SAS Programmer/ Data Analyst

Responsibilities:

• Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse usingSAS, SQL and Macros with better and accurate values.
• Experience in creating reports inSAS Enterprise Guide v4.2/4.3
• UtilizedSAS /ACCESS to extract data from Sybase and other relational databases for analysis.
• Prepared new datasets from raw sets files using Import Techniques and modified existing datasets using data statements such as SET, MERGE, UPDATE and PROC SORT.
• Designed, developed, tested and debugged new MACROS and modified the existing macros according to the enhancements in the business.
• Worked on edit check programs to maintain data consistency and data validation.

  Production Job Scheduling and Monthly Run.

• Worked on ad-hoc requirements and later converted them as monthly and quarterly reports.

  Developed and maintained the regular codes and made some amendments as per the business changes.

• Written effective new codes to get the required analytical summary data.
• Transformed the statistical data in various formats (excel, access) intoSAS data sheets. Provided statistical programming expertise in the production of analysis, tabulations, reports and listings.
• Developed programs for cleaning, transforming and modifying the data daily.
• Used baseSAS andSAS /SQL to generate tables.
• Generated the production reports and submitted with key observations and recommendations.
• ValidatedSAS data sets using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Formatted HTML, RTF and PDF reports usingSAS output delivery system ODS.
• Responsible to write theSAS programs to perform the QA analysis/testing.
• Used PROC compare to compare the data before and after editing developed variousSAS reports for Survey project and involved in code reviews for all the developed reports

Environment: BaseSAS v9.2,SAS /Macros,SAS /SQL,SAS OLAP Cube Studio 4.2,SASEnterpriseGuide v4.2,SAS /ACCESS,SAS /STAT, Sybase, Windows XP, UNIX, ProjectManagement, UE Studio.

Confidential

Sr. SAS Programmer/ Data Analyst

Responsibilities:

• As a part of this project Nielsen RMS captures sales and price data via handheld scanners from virtually every major retail chain like Wal-Mart, Target etc.
• This data is analyzed and transformed into reports to identify key shopper behavior.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Understanding the Business and its Requirements
• Worked with SAS on UNIX environment
• Gathering the requirements from user
• Involved in providing estimation for the requirement
• Modifying data using SAS/BASE and Macros
• Manipulated data by using scan, substring functions
• Modified many SAS and COBOL programs to reduce job run time
• Received many customer appreciations STAR of the MONTH and ON THE SPOT s.
• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Developed advanced SAS/SQL and SAS Data Procedures to extract the data from the raw input files.
• Generated Tables, Listings and Graphs using various SAS techniques such as SAS Macros, SAS/STAT and SAS/INSIGHT data manipulation and statistical procedures.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• 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.
• Generated SAS batch programs and generate log files, list files and reports in desired directories by passing parameters using UNIX shell scripts.
• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Produced Excel, Power Point, RTF, HTML and PDF formatted files using SAS/ODS to produce ad hoc reports for further analysis.
• Wrote Python scripts to perform the Monte Carlo simulations to solve relevant partial differential equations.
• Developed and delivered periodic analysis reports by using SAS.
• Extensive knowledge in Software Development Life Cycle: System Analysis, Design, Development and Testing, UAT, Test Processes and Test Life Cycle.
• Performed program documentation on all programs, files and variables for accurate historical record accordingly for future .
• Responsible for accurate and timely data analysis and submissions.

Environment: SAS 9.2, SAS 9.3, SAS Macros, SAS/SHARE, SAS/CONNECT, PL/SQL, Oracle 10g, MS Excel, Windows 7, HTML, UNIX AIX.

Confidential

Sr. SAS Consultant/Analyst

Responsibilities:

• Performed Data analysis, statistical analysis, generated reports, listings and graphs using SAS Tools SAS/Base, SAS/Macros, SAS/Insight, SAS/SQL, SAS/Connect, SAS/Access.
• Used sorting and merging techniques on the input data sets for Data Preparation, to get the required output and then writing the code using SAS tools.
• Developed routine SAS macros to create tables, graphs and listings for inclusion in reports and maintained existing ones.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures like proc summary, proc Tabulate and SAS/Graph.
• Conducted and generated the Regression, Correlation studies and Analysis of Variance (ANOVA) using Proc REG, Proc CORR, Proc GLM, Proc ANOVA.
• Used SAS Enterprise Business Intelligence tools create, register and deploy stored procedures.
• Performed data extraction by converting MS-Word documents and MS-Excel tables into SAS data sets.
• Used SAS Enterprise Miner to perform predictive modeling.
• Analyzed data through problem solving. Performed data archival, Ad-hoc reporting, and coding utilizing SAS on WINDOWS.
• Converted DB2 and ORACLE data tables into SAS data files using SAS SQL Pass through Facility, and uploaded SAS data files into ORACLE tables using SAS Dbload procedure.
• Build reports from the processed data, generated several reports from analyzed data and converted the data into dbf format and sent to the client and also the reports were sent to web, creating Universes using web intelligence.
• Performed program documentation on all programs, files and variables for accurate historical record accordingly for future .
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS output to RTF and HTML files.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.
• Developed advanced SQL queries with multi-table joins, group function and sub queries.
• Worked with DBA to validate the data.
• Completed timing analysis, developed forecast model, presented analysis and forecast model
• Performed trend analysis and tracking
• Interacted with Business users regarding Business Requirements.
• Extensive knowledge in Software Development Life Cycle: System Analysis, Design, Development and Testing, UAT, Test Processes and Test Life Cycle.

Confidential

SAS Programmer/Analyst

Responsibilities:

• Generated customized reports to help client in understanding risks with ease and accordingly optimize performance and customer satisfaction.
• The scope of this project is to upgrade existing Basel II system to Basel III including the introduction of a new and stricter definition of capital.
• Basel III guidelines are the response of BCBS (Basel Committee on Banking Supervision) to the 2008 crisis.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Performed extensive Data Cleansing during the ETL's Extraction and Loading Phase by developing SAS Program including complex reusable Macros analyzing the raw data.
• Created SAS programs on UNIX platform to clean the data according to the specifications.
• Coordinated with vital departments to analyze customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats such as HTML, PDF, WORD based on the user group requirement using SAS/ODS.
• Extracted, transformed and loaded data from large Teradata tables by including SAS code in Data step, Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.
• Created and maintained large data sets, combined data from various sources in varying formats to create SAS datasets, Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce reports as per requirements.
• Extracted customized reports from complex data sets 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.
• Performed Statistical Data analysis, mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, MS Visio, MS Project, Teradata, Oracle9i, UNIX, Enterprise Guide.

Confidential

SAS programmer/Data Analyst

Responsibilities:

• The project involved design, development, implementation, testing, analysis and evaluation of a third-party validation and data cleaning on 100 million records of consumer credit account summary data.
• Task involved working with very large datasets. Also, I have involved in the design and implementation of statistical reporting processes, regular data collection and analysis. All the SAS process was developed in UNIX environment with oracle.
• Actively involved in design and implementation of SAS process, analyzed existing applications and recommended improvements
• Interact with business partners, and analysts to refine targeted populations, and control populations. Locate appropriate databases for projects and perform relevant analysis.
• Process data collection to ensure proper quality of data and involved in marketing campaigns analysis. Automate the process using macros and auditing the code for each marketing campaign.
• Generate the Lead list, audit reports and list output based on the business criteria and business logic, suppress the do not mail, do not call.
• Analyze the profitability and the behavior of customers between different marketing campaigns. Generate analytical reports and create SAS macros for data extraction, reporting and to support routine processing and also for process automation.
• Perform updating data by daily, weekly and maintain, manipulating the data for database management. Importing data from Excel and MS Access, Oracle tables and also from Teradata DBMS tables, creating SAS
• Datasets, Merging according to the requirement, generate the reports and analyze those results. Extract data from Oracle & Teradata database using PROC SQL, SQL Pass through and also with LIBNAME
• Identify data discrepancies and produce derived datasets, tables, listings and figures to facilitate correction in the data. Monitor SAS processes and prepare extensive documentation.

Environment: SAS 8.2, VB, MS Office, PL/SQL, HTML, Windows, UNIX, Teradata and Oracle 9i.