SUMMARY:

• Having 8 years of experience as a Senior SAS Programmer and data analysis using BASE SAS, SAS Integration Studio, and SAS EBI, PM software.
• Very proficient understanding of Data Modeling using Use Case Diagram OOAD/UML , Data Mining, SAS Data Miner, Data Warehousing and Predictive Modeling with expertise in Business Intelligence, Data Integration concepts using the SAS Forecast Studio, Tableau.
• Created complex and reusable MACROS and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily, weekly and monthly basis using complex SQL Queries.
• Extensive experience in DATA merging sub setting with the use of PROC SQL, Merge and SET statements.
• Experience in all phases of Software Development Life Cycle SDLC including Requirements, Analysis/Design, Development, Implement, Validation, and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS ORACLE tables using LIBNAME and SQL Pass-Through facility.
• Good understanding of Data Warehouse concepts including Star Schema and Snow-Flake Schema
• Extensive experience in working on different SAS versions like 8.2, 9.1, 9.2 using SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/ETL, SAS/SQL.
• Extensively worked on SAS SCL to create object-oriented, interactive applications.
• Strong understanding in various Economic/Econometric and statistical concepts such as ANOVA, Correlation, Regression Analysis and Multivariate Analysis.
• Proven skills in Data Mining Techniques, Statistical Regression ,Segmentation analysis, missing value pattern Mathematical and Econometric Models using SAS, STATA, etc.
• Knowledge in data warehousing and business intelligence concepts, design principles Experience in RDBMS development including SQL, PL/SQL, languages.
• Proficient in using Import and Export procedures to handle data in raw data files ORACLE, DB2, TERADATA, NETEZZA, NETEZZA and SYBASE database management systems.

• Thorough Knowledge and experience of Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel, MS Visio, MS Project Management, and MS Outlook.

PROFESSIONAL EXPERIENCE

Confidential

Team Lead/Sr. SAS Programmer

Responsibilities:

• Supported 2 departments with 15 people for their needs in terms of data and reports
• Managed team of backend and frontend developersandCreated data schemas and data models to extract data from various databases.
• Working on Forecast Studio, Enterprise Miner, Tableauand experience in modeling performing cost analysis and trend analysis using Tableau.
• Worked in SAS EBI Studio, Created process flows for Jobs, worked with transformations/stored processes, registering and updating table metadata and worked in Data Management platform.
• Performed automated model scoring within database to improve performance and achieve faster time-to-result, reducing excessive data movement across servers and enhance productivity.
• Performed cluster analysis and principle component analysis using SAS-Enterprise Miner and aided the marketing initiative by segmenting millions of customers in over 5000 corporate alliance.
• Manipulating decision-trees and extension nodes in variable clustering to create score code using Enterprise Miner
• Experience on accessing Web Reporting andInformation delivery portal.
• Experience with SAS OLAP and MOLAP building and tuning cubes joining tubes using SASOPERATE.
• Prepared tracking sheet and planning, assigning the required task to team members.
• Responsible for migrating SAS and SQL codes, and data across the servers, within the server and in subversion tool. Also responsible for setting up FTP/AFTP processes to move the data files across the environments.
• Developed SAS scripts to scan all the logs and sends the error reports to the respective teams
• Designed, developed and executed UNIX shell scripts to automate production jobs, distribute reports, email job status to responsible teams, zip/unzip/move/archive/FTP/AFTP input and output data files, and reports, and delete old log files.
• Involved in modifying complex SAS and SQL codes, SAS Macros and SQL Stored Processes and applied new SAS programming methods and techniques to make it more efficient and bring them up to the current standards.

Environment: SAS/BASE 9.3, SAS/EG, SAS/EM, SAS/STAT, SAS/SQL, SAS/SCL, SAS/GRAPH, SAS/MACRO, PL/SQL, SAS/ODS, SAS/ACCESS, SAS/CONNECT, WinSQL, IPSwitch, Subversion, Toad, Oracle 11g, Reflection X, MS SQL Server, Microsoft Access, Shell scripts, MS SharePoint, Tableau

Confidential

Sr. SAS Programmer/Analys

Responsibilities:

• Working on Forecast Studio, Financial Management studio, Data Integration Studio and experience in modeling performing cost analysis and developing new products, analyzing usingDashboard studio and Tableau Server.
• Worked with creating and monitoring Hadoop clusters, created Pig jobs, Hive jobs using LASR Analytics server.
• Performed automated model scoring within database to improve performance and achieve faster time-to-result, reducing excessive data movement across servers and enhance productivity.
• Created tables to integrate SAS Embedded Process and Teradata, Netezza, Oracle and run scoring models.
• Experience on accessing Web ReportingandInformation delivery portal.
• Accountable fordefining, creating and implementing data access security using UDF's and Informational mapsoutputs as well as related reports.
• Prepared tracking sheet and planning, assigning the required task to team members.
• Responsible for migrating SAS and SQL codes, and data across the servers , within the server and in subversion tool . Also responsible for setting up FTP/AFTP processes to move the data files across the environments.
• Extensively used BASE SAS, Macros, and SAS SQL for advanced programming and production support. Used Unix commands find, grep, search, locate to search FTP directories for failed jobs and created process to automate the failed jobs in production.
• Actively involved in system integration testing, unittesting, regression testing, performance testing and back testing.
• Extensively used Proc Sort, Proc Freq, Proc Means, Proc Summary, Proc Comp, and ProcUnivariate to perform data cleaning and used Proc Sort with nodupkeys and noduprecs options to remove the duplicate records.
• Designed, developed and executed UNIX shell scripts to automate production jobs, distribute reports, email job status to responsible teams, zip/unzip/move/archive/FTP/AFTP input and output data files, and reports, and delete old log files.
• Involved in modifying complex SAS and SQL codes, SAS Macros and SQL Stored Processes and applied new SAS programming methods and techniques to make it more efficient and bring them up to the current standards.
• Attended technical meetings daily scrum meeting and worked closely with senior Business Systems Analyst, Architects, DBA's, and other team members to understand the issue, find the root cause and resolve the issues.

Environment: SAS/BASE 9.3, SAS/FM, SAS/DI, SAS/STAT, SAS/SQL, SAS/SCL, SAS/GRAPH, SAS/MACRO, PL/SQL, SAS/ODS, SAS/ACCESS, SAS/CONNECT, WinSQL, IPSwitch, Subversion, Toad, HADOOP, Oracle 11g, Reflection X, MS SQL Server, Microsoft Access, Shell scripts, MS SharePoint, Tableau

Confidential

SAS/SQL Developer

Responsibilities:

• Performed statistical analysis in SAS EBI on clinical data and did predictive modeling for determining success rate of trails.ProducedSAS Graphical reports showing Trend Analysis charts and performed data analysis on interactive dashboardsusing Tableau.
• Performed SAS programming using techniques as SAS Base, SAS Macro, data manipulation techniques, and statistical procedures e.g., Proc Means, Proc Freq, Proc Report .
• Used SCL for customized method developments and integrating PROCs with components.
• Designed flowcharts indicating the input data sets and the techniques that would be used sorting, merging, etc. to get the desired output.Exposure to Data warehouse applications.
• Preliminary data integration, data validation clinical data quality checks is done on the clinical trial data using SAS/SQL.
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales.
• Upload SAS data sets across platforms from PC to UNIX and Vice Versa.
• Involved in clinical trial studies, data migration/extraction of data from Flat files, SQL Tables and SAS datasets.
• Extensively used Dynamic Data Exchange DDE for importing data in Excel sheets into SAS
• Extracted, validated and generated SAS data sets from Oracle applied 'SQL Pass through Facility'.
• Performed statistical analysis, wrote SAS code for Data Management and reportingusingIDP and WRS, and performed validation, including testing SAS code.
• Produced Tables/Listings for Integrated Summaries of Efficacy ISE and Safety ISS .
• Maintained appropriate study application documentation.
• Created and maintained SAS Datasets that are extracted from an Oracle Clinical Database.
• Created SAS Customized Reports using Data Null technique for FDA regulations.

Environment: SAS/BASE V9.1.3, V8.2 , SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, Windows XP/Teradata, Netezza, Tableau

Confidential

SASProgrammer

Responsibilities:

• Developed PD scorecards using Credit Scoring nodes in Enterprise Miner. Run various interactive grouping nodes and inspected results.
• Preprocessed data for LGD modeling using linear regression and performed predictive modeling using various drivers like debt type, seniority, industry impact, firm impact, economy impact.
• Analyzed Cumulative accuracy profiles CAP for PD modeling, Exposure at Default EAD modeling for revolving credit.
• Performed back-testingfor validation usingBasel II frameworks.
• Accessed and analyzed the data based on the requirement using SQL, SAS and MS Excel.
• Performed ETL tasks in extracting the data from databases using SAS procedures like SAS/SQL, SAS/Access and creation of datasets.
• Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and Documentation
• Analyzed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures.
• Retrieved the original data and convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Interactively meeting the teams for getting the required data to generate the reports as per business requirements.
• Created UNIXKorn shell scripts to export environment variables and deleted old files.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE/REPORT/TABULATE and using Word, Excel and PowerPoint as well
• Built summary reports after identifying customers, occupancy period and revenue generated using PROC SUMMARY, MEANS and FREQ. Updated Revenue item table on a daily basis.
• Cubes are built using the Teradata, Netezza tables and created some intermediate required data sets which will be joined using the Cube Studio.
• Generating reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN,PROC GPLOT and PROC GCHART.
• Developing SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS, etc for statistical analysis and data displays
• Developing and analyzing key performance indicators relevant to emerging business needs using PROC FREQ, PROC TABULATE, PROC MEAN, PROC UNIVARIATE, PROC GLM, PROC TTEST, PROC TRANPOSE, and DATA NULL
• Used the JDBC for data retrieval from the database for various inquiries. Performed purification of the application database entries using Oracle 10g.
• Documented purpose and methods used in each SAS program

Environment: UNIX AIX 5.2 , XP, Base SAS v9, VI Editor,SAS Enterprise Guide, SAS/MACRO, SAS/GRAPH, SAS/STAT, MS Excel, Oracle 10g

Confidential

SAS Programmer/Analyst

Responsibilities:

• Developed programs Statistical analysis of product sales, performance of Sales department, forecasted regional sales, Monthly, Quarterly and Yearly sales reports. The incentive compensation was taken care of in this project and the profit forecast was also done.
• Analyzed employee accounts for payroll fraud, falsifying expense claim, theft of cash and asset.
• Programming and analyzing in guiding with the design and development of the application.
• Drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code.
• Developed different modules using standard J2EE architecture. This includes JSP, EJB, and JDBC.
• Find top customers for the target lists Look for responsiveness of targets based on sales effort.
• Extensively used Arrays in SAS Data Steps.
• Extensively done SAS/Macro Programming.
• Used SCL for customized method developments and integrating PROCs with components.
• Used SAS DATA NULL and PUT statements to create the customized reports.
• Developed new macros for report generation using SAS/Macro as per the customer's requirements.
• Produced SAS Graphical reportsshowing Trend Analysis charts for campaign.
• Used SAS PROC SQL Pass through Facility and SAS/CONNECT to work with Oracle database.
• Used SAS GRAPH for generating various graphs and charts for analyzing the product sales.
• Upload SAS data sets across platforms from PC to UNIX and Vice Versa. Environment: SAS/BASE, SAS/STAT, SAS, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/ETS, SAS/QC, SAS/Connect, UNIX, SQL, MS Access, EXCEL, Java, JSP, SPSS, Teradata, Netezza/QueryMan