SUMMARY:

• CertifiedBaseProgrammerfor SAS 9with 7 plus years of experience in Consumer Good, Financial Analysis, Risk Analysis, and Data Analysis.
• Expert inSAS9.4, 9.3, 9.2, 9.1, 9.0 versions programming, Requirement analysis, data mapping and data analysis usingSASsoftware in platforms like WINDOWS and UNIX.
• Expert in SAS/BASE, SAS/Assist, SAS/Connect, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/Access, SAS/GRAPH, SAS/ETS, SAS ETL, and SAS/ODS.
• Excellent in analyzing and documenting business requirements, interactions with Users, Marketing Group, Project Team, and QA Analysts.
• Expert in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process. Extracting data from flat files, Excel spreadsheets and tables using LIBNAME and SQL PASSTHRU facility.
• Experienced in PROC SQL,SASDDE,SASArrays,SASBase procedures, summary procedures,& Data Step programming and reporting.
• Experienced in generating Ad - Hoc reports as per requirements using PROC PRINT, PROC SUMMARY, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC TRANSPOSE, PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, DATA MERGE, and SORT.
• Excellent experience in Data extraction from different types of databases including Oracle, SQL Server, and other external files usingSAS/ACCESS,SAS/SQL pass through facility, PROC IMPORT procedure, &SASData steps.
• Expertin modifying existing & creating new Macros to improve ease and speed in generation of results.
• Experienced in working on Joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases.
• Worked on Tableau to create dashboards like weekly, monthly, &daily reports using Tableau desktop & publish them to server.
• Self-motivated, dedicated and hardworking with strong Technical & Analytical skills. Always keen and eager to face up to challenges.

TECHNICAL SKILLS

Office Tools: MS Office 2016/2014/2010/ 2007/ 2003, MS-Word, MS-Excel, MS-Access, MS-PowerPoint.

SASTools: SAS/BASE,SAS/MACRO,SAS/SQL,SAS/ODS,SAS/ACCESS,SAS/GRAPH, SAS/STAT,SAS/ODS,SAS/Graph,SAS/STAT,SAS/Macro,SAS/EGSASProcedures

Software Packages: MSOffice 2016/2014/2012, SAP R/3, MS Office Project, Visual Studio 2010/2008/2005, SharePoint, Joomla, SAS 9.4/9.3/9.2/9.1, R Console 3.3.0

Programming: BaseSAS 9.0, R, C, C++, Java, HTML, CSS, ASP .NET, C#, JavaScript, and XML

Operating System: Windows10/7/Vista/XP, UNIX, Mac OS X

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

Sr. SAS Analyst

Responsibilities:

• Ran weekly and monthly reports using SAS, SAS/SQL, SAS MACRO and SAS GRAPH.
• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, and Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Gathered customer data and performed back-end analysis for all marketing campaigns including direct mail, Tele marketing and other media.
• Programming of data listings using SAS. Converted MS-Word documents and Excel tables into SAS data sets.
• Developed application for measuring financial performance of newly acquired accounts: Forecast Vs Actual.
• Developed SAS programs for generating reports on Key financials, Income Statements, and Balance Sheet
• Involved in development and enhancements of SAS Programs.
• Successfully generated permanent and temporary SAS datasets.
• Involved in writing code using Base SAS & SAS/Macros to extract, clean, and validate data from oracle tables.
• Used procedures like PROC - FREQ, MEANS, SORT, PRINT, TABULATE and REPORT.
• Developed SAS programs for statistical analysis and data displays working with various SAS products like SAS - BASE, SQL, STAT, ACCESS, MACROSetc. to develop solutions.
• Successfully used Proc Means to calculate means, standard deviation, sum, median etc. of data
• Generated graphs using SAS/GRAPH.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.
• Developed routine SAS macros to create tables, graphs, and listings.
• Developed SAS macros for data cleansing/Reporting, and to support routing processing.
• Created SASMACROS and SASGRAPHICS.
• Used Proc REPORT to generate reports.

Environment: SAS/SQL, SAS 9.4/9.2/9.0, SAS/MACROS, SAS/BASE, SAS/ODS, SAS/STAT, SAS/GRAPHICS, Oracle9i, SAS/GRAPH, SAS Access, Teradata, PROC Reports, UNIX.

Confidential, Riverwood, IL

SASProgrammer Analyst

Responsibilities:

• Read data from different sources like .csv, excel, tab delimited files.
• Extracted data from the database usingSAS/Access,SASSQL procedures and createSASdata sets.
• Created datasets and generating reports using PROCREPORT, PROCSQL and MACROS.
• Used Output Delivery System facility to write custom safety reports in PDF, RTF and HTML formats.
• Unnecessary data and duplicate were reported to client using data null.
• Code, and testSASprograms for the summarization, statistical analysis and reporting.
• Performed various business checks on the source data to confirm whether data is correct or not.
• Compared the source data with historical data to get some statistical analysis.
• Performed transformations like Merge, Sort and Update to get the data in required format.
• Generated Reports in user required format by using ODS and PROC Report.
• Validated SAS Data Sets usingSASprocedures like Proc Means, Proc Frequency and Proc Univariate.
• Generated outputs with table of contents using ODS HTML.
• Extensively usedDATA NULL, TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL, &GPLOT procedures.
• Provided programming support to compress data from a multiple source for each subject into a single table usingArraysandDo Loops.
• Manipulated large data sets to Increase programs efficiency. Responsible for data entry and conversions, data validation and corrections.
• Took ownership, and actively managed project timelines. Executed standard reports, processes, files, and implement predefined algorithms
• Set up QA/QC framework, and ensured adherence and constant improvement.
• Developed business and technical knowledge of team members, & identified opportunities of improvement.

Environment:SAS/BASE,SAS/STAT,SAS/SQL,SAS/MACRO,SAS/ACCESS,SAS/ODS, MS Access, Excel, TERADATA.

Confidential - Irvine, CA

SASProgrammer

Responsibilities:

• Worked on expanding several data warehouse tables and identify reports that are generated through severalSASand SQLcodes.
• Involved in developing analytic specifications through participation in project teams or meetings with clients for ongoing project and ad hoc requests
• Worked with large data sets (15+ million records) using SQL Pass Through method.
• Programmed & collected data from various oracle tables using Unions and Joins.
• Executed data cleansing by analyzing and eliminating duplicate data and inaccurate data using PROC - FREQ, SORT, UNIVARIATE, and MACRO inSAS.
• Involved in the data analysis, DB creation, applying database constraints,& make ready to load onto database.
• Generated customized reports usingSAS/MACRO facility, PROC REPORT, PROC TABUTAE and PROC SQL.
• Prepared graphs using the modified data for business analysis.
• Created Data Sets on the Remote Server.
• UsedSAS/ACCESS to gather data from RDBMS like TERADATA.
• Coordinated the production of monthly, quarterly, and annual performance reports for senior management.
• Maintained, and enhanced existingSASreporting programs for marketing campaigns.
• MaintainedSASstatistical analysis for the products purchased every month.
• Ran reporting programs, extractedthe results into EXCEL, and built pivot tables.
• Presented the results, and statistical reports in PowerPoint to the marketing staff.

Environment:SASBASE,SAS9.2/9.0,SASSQL,SAS/EG,SASMACRO, ORACLE, TERADATA,SASCONNECT,SAS/ODS, MS Excel.

Confidential

SASData Analyst

Responsibilities:

• Involved in Business Analysis and Systems Planning, migration of data from text files and DB2 to SAS data sets. Generated reports by submitting JCL and monitoring weekly, Daily, and Monthly Jobs.
• Developed, enhanced& executed complex programs and reports with proper documentation.
• Comprehend production codes, undertake diagnosis, resolution of complex issues, and improve the efficiency of processes and programs.
• Developed business domain expertise, rudimentary project based business knowledge, and good theoretical knowledge of tools likeSAS, MS office.
• Independently delivered end to end on complex projects,& assisted in developing and testing new information infrastructure.
• Managed end-user expectation in the delivery of projects within agreed timelines.
• Executed standard processes, implemented predefined algorithms,& corrected identified problems.
• Maintainedlarge data sets, i.e. reading in data from various sources in various formats to create SASdata sets and/or ASCII files.
• Documented the process, i.e. documented all the possible information about the application like SASprograms, DATA files, and source.
• Prepared project plan for the execution.
• Independently interacted with business partners to understand business needs,& translated them to technical specifications. Assisted in developing,& testing new information infrastructure.
• End to end project management and hands on delivery when required.

Environment:SAS, BASE/ SAS,SAS /SQL,SAS /CONNECT,SAS /ACCESS, SAS /ODS, Oracle, DB2, UNIX,& Windows 7/Vista/XP