SUMMARY:

• Base SAS Certified, Statistical Business Analyst Certified, Advanced SAS certified with 12+ years of extensive experience in SAS Programming on Windows, Unix and Mainframes
• Certification in Advanced Business Analytics using R with 3 years of experience in R Programming in Data Science, Business Analytics, Predictive models using Liner, Logistic Regression, K Means Cluster Analysis, Decision Tree Analysis, Machine Learning and Time Series Forecasting methods
• Hands on experience in R Programming using several CRAN packages, data analysis, management, sorting, merging, summary using vectors, arrays, matrices, functions, data frames, tables etc and model building using lm,glm,ts,kmeans validating using ANOVA, Plots,Lift charts,Gain charts, ROC Curve
• Expert skills in SAS DATA STEP, PROC Step, SQL, ETL, data mining, SAS MACRO, SAS ACCESS, SAS STAT, SAS GRAPH, SAS DI Studio, SAS BI Platform, SAS Web Report Studio, SAS BI Dashboard, SAS Stored Process, SAS Management Console, SAS Forecast Server, Enterprise Guide, Enterprise Miner, SAS VA and ODS and procs like PROC SQL, import, export, means, summary, freq, tabulate, report, univariate, options, datasets, append, print, sort, transpose, format, glm, corr, factor, t test, Chi Square, ANOVA,Arima,Arma,rank, Reg,logistic, catmod, genmod, gplot,boxplot etc
• Hands on expertise in Agile framework, ITIL framework, worked as Scrum Master/Ajile Project Manager, updated Agile tracking systems to provide transparency on product/delivery and sprint backlogs
• Hands on in SAS BI Platform, EBI, SAS DI Studio, SAS OLAP Cube Studio, Datawarehouse architecture, Dimensional modeling using Star, Snow flake schema, Data Modeling, Source Target mapping,Logical and Physical data modeling using ERwin, SQL Pass - thru, Proc SQL,Libname and Oracle,Teradata and Confidential DB2
• Wrote new SAS programs from scratch, automated and fine tuned existing SAS code using SAS Macro, ODS Korn Shell scripts and SQL Tuning and generated HTML/PDF/RTF Reports and Graphs/Charts.
• Proficient in SAS VA LASR server, creating visualizations, reports, dashboards, graphs, charts etc using SAS VA Explorer, SAS VA Designer, SAS VA Data Builder
• Data mapping, data profiling of the data models, validate the metadata, improve data quality and data integrations and create data marts to be used further in data visualization and reports generation
• Hands on expertise in ETL Process using SQL, HiveQL,SAS DI Studio, Abinitio, Oracle, Teradata, functional analysis, Data Data cleansing, Sorting, Merging, Data joins, Data Transformation, tables and generate reports
• Data Preparation from extracting data from multiple sources, flat files, tables, validate data types, cleaning, data transformation using metadata, SQL queries and Joins/Filters in the transformations and load tables into data marts and generate customized reports used by data warehouse team
• Analysis of the multiple data sources from Oracle, Teradata, variables mapping, data joins,validate with metadata, metrics on data quality, prepared the dashboards, build model data and built various Predictive Models in Time Series forecasting, Linear & Logistic Regressions used in Business Analytics
• Extensive hands on expertise in complete SDLC Project Management and leading projects from Requirement Analysis, Design, Planning, Estimation, Coding, Code Reviews, Test Plan Preparation, Debugging, Unit/System/Integration/Regression Testing, UAT,Implementation and Production Support

TECHNICAL SKILLS:

SAS Tools: Base SAS, SAS Macro, SAS Stat, SAS ODS, SAS Graph, SAS Access, SAS Connect, SAS Enterprise Guide, SAS Enterprise Miner, SAS Office Analytics, SAS Enterprise Business Intelligence, SAS BI Dashboard, SAS DI Studio, SAS Metadata Server, SAS Management Console, SAS BI Server, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Stored Process, SAS Metadata Server, SAS Add-in, SAS Grid, SAS EBI, SAS ETL,Dataflux Data Management Studio

Reporting Tools: Base SAS 9.4/9.3/9.2/9/8/6 , SAS Data Integration Studio, SAS Information Map Studio, SAS Visual Analytics Data Builder, SAS VA Designer, SAS VA Explorer, SAS VA Viewer, LASR Analytic Server, MS-EXCEL, Pivot, VLookup, Toad, Tableau Desktop, Tableau Server,ERWin, Hue,Sharepoint

DBMS/RDBMS: MS-ACCESS, MySQL, ORACLE11g, MS SQL Server, TeradataV2R6.2.2, BTEQ, FASTLOAD, Confidential DB2 V9, IMS/DB,HIVE

Languages: R Programming, SAS, SQL, Toad, HiveQL, PL/SQL, SQL*Plus, HTML, COBOLII, XML, JIL, Autosys, Ksh, Korn Shell Scripts, PL/1, JCL

Platforms: Windows,Unix-AIX/Solaris/HP, Linux, HADOOP, HDFS, Confidential Mainframes ES9000/S390/R9672, MVS-XA/ESA,TSO/ISPF,Z/OS,JCL,JBOSS

Project Management:: ITIL V3, MS Project, MS Excel, Visio, PowerPoint, PCM/BMC Remedy

Configuration Management: Clear Case, Clear Quest, Share Point, Lotus Notes, JIL, Expeditor, Panvalet

Data transfer protocols: FTP, SFTP, Open SSH, Connect SQL, Putty, Winscp, Weblogic

GUI: SAS Enterprise Miner, SAS EG Studio, CICS3.1,Control M,Sharepoint,Jira

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. SAS Consultant

Responsibilities:

• Initiated and set up JIRA Ajile dashboard, lead as scrum master, created JIRA scrum board, issue types, work flows, Sprints, tasks, sub tasks, monitor tasks, user stories and successful completion of Sprints
• Produce project documentation, system requirements and testing plans, project plans and teamwork assignments, performing quality review and escalating functional, quality, timeline issues appropriately
• Extracting data from Hadoop Data Lake, Excel, Analyzing, Cleaning, Sorting, Merging Reporting and creating dashboards for ADS team using Base SAS, SAS Macros, SAS Connect, SQL,Hive, SAS VA,SAS EG,Hue
• Writing complex Base SAS programs, SAS Macros, extracting data from Hadoop using Hue, HiveQL, SQL and preparing staging tables for ETL processing using Joins, Concatenations, Merging etc
• Worked with Raw data from flat files, Excel using SAS/ACCESS and created SAS datasets, Files and Reports
• Analyzing Source/Target variables, preparing data dictionary, metadata using Logical Models, extracting data from data lake, excel files, creating tables in Hive and SAS using SQL Pass through/Libname and Proc SQL
• Extensively used DATA Step, Formats, Functions, Macros, SORT, MERGE, PROC SQL, TRANSPOSE, TABULATE, COMPARE,REPORT,GRAPH etc. in Data transformation and Manipulation processes.
• Extract data from Hadoop TZ,LZ and create tables in ETL staging zone and process them in the analysis of applications like CoSD Wireline, DNM, ALM and create dashboards, publish on sharepoint and to business users
• Created Data visualizations, reports/custom graphs using SAS VA Explorer, SAS VA Designer, import/load tables onto VA Analytics LASR server, applying filters, write queries using SAS VA Data Builder
• Automating/ fine tuning the SAS, SQL and Hive code and productionizing it by using SAS Macros, Shell Scripts
• Worked extensively in ETL Process using SQL, SAS DI Studio, Oracle, functional analysis, Data Data cleansing, Sorting, Merging, Data joins, Data Transformation, build tables and generate reports

Environment: SAS Enterprise Guide, SAS Base,SAS Macros, SAS DI Studio, SAS Graph, SAS ODS, SAS Stored Process, SAS Visual Analytics, SAS LASR, SAS Management Console, Hadoop HDFS,HiveQL,SQL,Oracle Toad, Datawarehouse, ERWin, Sharepoint,Jira,MS office,Excel-Pivot/Vlookup, Linux/Unix-Solaris, Shell Scripts

Confidential, NC

Sr. Consultant/Data Analyst

Responsibilities:

• Produce project documentation including formal proposals and schedules, system requirements and testing plans, project plans and teamwork assignments, directing and monitoring work efforts on a daily basis, identifying resource needs, performing quality review and escalating functional, quality, timeline issues.
• Managing projects in both Agile and Waterfall development environments and managed project scope to ensure delivery was compliant to scope commitment, Coordinated Daily scrum meetings, spring planning, spring review,
• Translate business requirements into functional specifications, prepared project flow, reviewed BRDs, technical plans, Validated Test Cases, Test Plans, UATs and ensured successful project release cycles
• Worked extensively in Data Extraction from Data Marts/external sources and in Data Analysis, Cleaning, Sorting, Merging and Reporting using R Programming, Base SAS, SAS Macros, SAS Connect, SAS STAT, SQL
• Performed Exploratory Data Analysis, Hypothesis validation, Variables selection, Correlation Analysis, Fitness of the model,Testing and Validating Predictive Linear/Multi Linear, Logistic Regression and Time Series models
• Analyzed data and built models using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, PROC LOGISTIC,PROC ARIMA and PROC ANOVA.
• Prepared the model data and built various Predictive Models using R Programming Time Series forecasting, Linear & Logistic Regressions and K-Means Clustering in Business Analytics
• Data selection, assigning roles to variables and selecting automatic forecast criteria and Build large Time series Models using SAS Forecast Server both interactive and batch mode and SAS Enterprise Miner and also with STAT procedures like Reg, Log and Time series Arima as required
• Hands on expertise on Tableau Desktop in perform the transformations, apply filters, drill downs, and generate Data visualizations, interactive Dash Boards, powerpoint,link across multiple views in one dashboard, monitor and measure goals, identify patterns, outliers, uncover structure, summarize findings in further business analytics
• Worked extensively on Tableau Desktop and built dashboards that can interact with views of data and worked on several options like query, display, analyze, sort, group, drill down, organize, summarize and generate charts
• Extract data from SQL Server, used Toad T-SQL scripts, Import and Export data from Excel to SharePoint using SharePoint Online, Format data using Pivot tables charts in Excel and upload reports/docs to SharePoint
• Strong skills in EDW Data warehouse architecture,DWH/BI, Dimensional modeling, Flow diagrams, Data mapping, cleansing, Sorting, Merging, Transformation, ETL Process using SQL, SAS BI, Oracle, Teradata
• Data mapping, data profiling of the data models using stats, aggregates and validate the metadata, improve data quality and data integrations and create data marts to be used further in data visualization and reports generation
• Worked extensively in ETL Process using SQL, SAS DI Studio, Oracle, Teradata, functional analysis, Data Data cleansing, Sorting, Merging, Data joins, Data Transformation, build tables and generate reports
• Performed data analysis, statistical analysis, generated dashboards,reports, charts, and graphs using SAS VA
• Created Data visualizations, reports/charts using SAS VA Explorer, SAS VA Designer, import/load tables onto VA Analytics server, applying filters, write queries using SAS VA Data Builder
• Worked with Raw data from flat files, Excel, Mainframe files to Teradata using BTEQ,Fastload and to Oracle using SQl,Toad,JCL,SQL Tuning and created SAS datasets, Files, Reports and Graphs for Data Analysis.
• Developed reusable SAS programs by using SAS Macros, %Include code,Shell scripts to retrieve and format Oracle/Teradata data and SAS programs to generate tables and reports using Data Null, CALL SYMPUT, PROC SQL, PROC Sort, Proc Contents, Proc Corr, Proc Export, PROC Format, Proc Transpose, PROC Report

Environment: R Programming, R Packages, SAS Enterprise Guide, SAS Enterprise Miner, SAS Base,SAS Macros, SAS DI Studio, SAS Graph, SAS ODS, SAS Stat, SAS BI Platform, SAS BI Dashboard, SAS Web Report Studio, SAS Stored Process, Dataflux Management Studio,Excel, Windows, SQL,Toad,Oracle11g, Teradata, DWH/BI,Datawarehouse architecture, Tableau, Sharepoint,MS office, Unix-Aix/Solaris, Korn Shell Scripts, Control M, Remedy PCM,ITIL Change Management, Release Management, Rational Clear Case, Clear Quest, Sharepoint,Jira, MS office, MS Project, Waterfall, Viso, Ajile, Scrum, Excel-Pivot/Vlookup

Confidential, VA

Data Analyst/SAS Consultant

Responsibilities:

• System Analysis, Design,Requirements Scope, Technical Specification, Coding, Debugging, Code Review, writing Test Plans,Test Cases and UAT of the various MRs given by the client.
• Created and documented deliverables and documents such as: requirements definitions, functional specifications
• Translate business requirements into functional specifications, prepared project flow, ensured tech plans are in accordance with business functions, reviewed BRDs, Validated Test Cases, Test Plans, UATs
• Performing predictive modeling, Time series forecasting and validation using SAS procedures including Proc Means, Proc Univariate, Proc Corr, Proc Rank,Proc Reg, Proc Logistic,Proc Arima etc
• Performed Exploratory Data Analysis, Hypothesis validation, Variables selection, Correlation Analysis, Fitness of the model,Testing and Validating Predictive Linear/Multi Linear, Logistic Regression and Time Series models
• Worked extensively in functional analysis, Data cleansing, Sorting, Merging, Data joins, Data Transformation, build tables and generate reports using Base SAS, SAS Macros, SAS Connect, SQL,SAS EG,and SAS Studio
• Worked extensively in Data warehouse architecture, DWH/BI, Dimensional modeling, Star, Snowflake schema, OLAP Cube, Source Target mapping, Logical and Physical modeling using ERWin, cleansing, Sorting, Merging, Data joins, Data Transformation, ETL Process using SQL, SAS ETL, SAS DI Studio, SAS EG,Oracle, Teradata
• Data mapping, data profiling of the data models using stats, aggregates and validate the metadata, improve data quality and data integrations and create data marts to be used further in data visualization and reports generation
• Expertise in Data Extraction from raw data, MS Excel, Text Files, Oracle and Teradata tables, Cleaning, Sorting, Merging, Joining, Transforming, SQL Tuning and creating SAS Datasets for loading into Data Marts and DWH.
• Developed new SAS Macros for applications to retrieve and format Oracle database records and SAS programs to generate tables and reports using Data Step,Data Null, CALL SYMPUT, PROC SQL, Proc Tabulate, PROC Sort, PROC Format, Proc Freq, Proc Summary, Proc Means, Proc Transpose, Proc Append, PROC Report etc
• Used Proc Dbload, Proc SQL, Proc import, Proc export to load SAS data sets from Mainframe and Unix to Oracle 9i, extract,sort and migrate applications from Mainframe using Base SAS/Macro,SQL,JCL,Syncsort
• Extracted data from SQL Server, prepared Dashboards, reports, visualizations using Toad, Tableau in Analytics
• Access Raw data from flat files, Excel, SQL Server, Oracle Databases using SAS/ACCESS, extract to Tableau desktop, apply filters and generate visual Reports, Graphs using Tableau and upload to EDW and SharePoint
• Automating jobs using SAS Macro, Shell Scripts, Control M, modifying existing SAS programs for efficiency
• Incorporated ITIL framework and used PCM Remedy, Change management and Release management in code migrations and project release cycles successfully
• Involved in complete Re Write of HLP project from Design, Analysis, Coding and Testing using Base/SAS,SAS/Macro, SQL,DB2/UDB, Oracle on UNIX and MVS
• Extensive use of Proc Tabulate, Proc Print, Proc Report and output the reports via ODS HTML to SharePoint and Proc Tabulate to create analysis tables. Generating GRAPHS and CHARTS using Proc Gplot and Gchart

Environment: SAS Enterprise Guide, SAS Base 9.2, SAS Macros, SAS Graph, SAS ODS, SAS Stat, SAS DI Studio, SAS OLAP Cube Studio, SAS BI Dashboard, SAS Add in, SAS Stored Process, MS Access, SQL, SQL Server Studio, Oracle, Teradata, DB2,MS office, SharePoint, Windows, Unix-Solaris/HP, Erwin, ER Diagrams, Metadata, EDW, Business Intelligence, Abinitio, ETL, Toad, PCM/Remedy, Clear quest, Clear Case, ITIL Change Management, Release Management, Mainframes,MVS,TSO/ISPF,JCL,Syncsort,Ajile,Scrum,Syncsort

Confidential, NC

SAS Programmer Analyst

Responsibilities:

• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables and listings
• Worked closely with Business Partners in DMCE marketing team and improved/automated the Food Weekly and Monthly process efficiently using Base SAS, SAS Macro and Shell scripts.
• Developed SAS code using SAS/BASE,SAS/Macro to clean the invalid data from the database while reading the data from Oracle, TERADATA, Excel, XML,Mainframe and flat files into SAS software.
• Extract and Transport data from DB2 and Oracle tables in UNIX. Extract huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader.
• Automated SAS jobs running on daily/weekly/monthly basis using SAS BI,SAS Macro and Unix Shell Scripting
• Extensively used SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary, Transpose and Data Null for producing Confidential and customized reports and external files.
• Extensive use of SQL,SAS/Access, SAS/Connect to connect to various databases (ORACLE, DB2) such as development and production database (DB2 on UNIX). Worked on Mainframes, MVS/JCL to read, modify and create new SAS datasets, convert Mainframe files using Syncsort as per the business needs.
• Generated custom reports with line sizes, page breaks, Header message, and Bottom message using PROC SORT, PROC PRINT, and PROC REPORT.
• Enhancing batch SAS Mainframe programs, automating data extraction,transformation and loading results to database using SAS,SQL, DB2,MVS,TSO/ISPF,JCL,Syncsort,Changeman and XML
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables
• Used Proc SQL, Proc DBLOAD, Proc Tabulate, Proc Report, Proc Sort, Proc Freq, Proc Transpose, Proc Summary, Proc Compare, Proc Means, Proc ANOVA, Proc Univariate and Data NULL.

Environment: SAS/Enterprise Guide, SAS/Base9, SAS/Macros, SAS DI Studio, SAS/Graph, SAS/ODS, SAS/Stat, SAS/Connect, SAS Web Report Studio, Excel, MS Access, Oracle, Teradata,DB2, SQL*Loader, Windows, MS office, Unix-Solaris,Aix, Confidential /S390,Mainframes,TSO/ISPF,MVS,JCL,Syncsort and XML.

Confidential, DC

SAS Developer

Responsibilities:

• Involved in complete Re Write of MF RBC project starting from Design, Analysis, Coding and Testing using Base/SAS,SAS/Macro, SQL, SQL*Loader on both UNIX-AIX/Solaris and Mainframe (MVS,TSO/ISPF,JCL).
• Worked with Large Datasets(>100M) and performed Performance Management of Queries, Sorting, Merging, Massaging of the data of Oracle Tables, SAS datasets on both Mainframes Syncsort and UNIX.
• Reading data from Excel, Oracle and Raw data from Text Files and converting them to SAS datasets and or writing to Flat Files, Oracle Tables and Excel files and generating Reports RTF and HTML formats using Data Null, SAS/ODS,PROC REPORT.
• Import and export data in between Unix and PC by using SAS/CONNECT remote login utilities and PROC DOWNLOAD, PROC EXPORT, PROC IMPORT.
• Extensively used Base SAS- ETL to load data from SQL server, oracle, Flat files and sources to Oracle Data
• Worked extensively on extracting data from data warehouse using SQL & ETL tool Abinitio and creating reports using HTML/PDF reports using ODS, Proc Reports, Proc Charts and Proc Graphs
• Creating SAS datasets from tables in Database using Mainframe SAS, JCL,SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding and scheduling SAS jobs with the use of Control M, Base SAS and SAS/Macros and Shell scripts
• Wrote number of Korn Shell scripts for running batch files, automated daily/weekly/monthly reports using shell scripts and Autosys JIL jobs, performed validation on transported data and reports.
• Extensively used Data Step and Procs such as PROC Means, PROC Summary, PROC Print, PROC SQL, PROC Tabulate, PROC Sort, PROC CONTENTS, PROC REPORT, PROC Freq, Proc Format, PROC Transpose.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, PROC GLM and PROC ANOVA.

Environment: Confidential Mainframes S390,UNIX-Solaris,AIX,BaseSAS8, SAS/Macro, SAS/ODS,ORACLE10g, Korn & C Shell Scripting, Awk/Sed,TSO/ISPF, JCL, MVS, Z/OS,TSO/ISPF, SQL, SYNCSORT, MySQL,SQLLDR, PL/SQL, CTL files,FTP,AUTOSYS, JIL, Remedy, Rational ClearCase & ClearQuest, RDW, Excel, Word, Abinitio

Confidential, VA

SAS Programmer

Responsibilities:

• Analysis, Coding, Debugging, Code Review using Base SAS, SAS/Macro, SAS/Connect,DB2/UDB, SQL on both UNIX-AIX, Solaris and Mainframe Environments(MVS,TSO/ISPF,JCL,FTP,Syncsort,Xpeditor).
• Worked extensively in SAS Data Analysis, Data Extraction, Creating SAS Datasets from raw data, Excel, Text Files, Oracle and DB2 tables, Sorting, Merging and creating Reports using Proc Report..
• Data Cleaning, Sorting, Merging, Data Analysis and Summarization using SQL,SAS on UNIX and PC SAS.
• Used Proc SQL, Proc DBLOAD, Proc Tabulate, Proc Report, Proc Sort, Proc Freq, Proc Transpose, Proc Summary, Proc Compare, Proc Means, Proc ANOVA, Proc Univariate and Data NULL .
• Standardized and developed reusable SAS programs by using SAS Macros across the DWH team.
• Worked on Confidential Requests in reading data from Excel, Oracle Tables and Text Files and creating Flat Files/Reports/Datasets and generating reports using Data Null,
• Generate custom reports with line sizes, page breaks, Header message, and Bottom message using PROC SORT, PROC PRINT, and PROC REPORT.
• Extensively used DATA Step, Formats, Functions, Macros, SORT, MERGE, PROC SQL,ETL, TRANSPOSE, TABULATE, COMPARE,REPORT,CHARTS etc.in SAS programming

Environment: Confidential / S390 Mainframes, UNIX-Solaris,BaseSAS,SAS/Macro,PC-SAS,UDB-DB2,ORACLE, Shell Scripting, Awk/Sed, JCL, MVS, Z/OS,SQL, MySQL, Rational ClearCase & ClearQuest, DB2 Command Center, TSO/ISPF, FILEAID, Interactive-SAS, Report Works, Excel, Word,Unix-Aix/HP