SUMMARY:

• Over 6 years of Professional Experience in SAS Programming on different platforms - Windows, Linux and Unix, also having worked in Updating, Data Extraction, transformation and loading to data warehouse, data analysis, updating, testing, mapping analysis and business driven data validation.
• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes, Information Delivery Portal, DI Studio and Web Report Studio.
• Experience in Base SAS, SAS/Stat, SAS Macros, SAS/Graph, SAS/Connect, and SAS/Access on Windows and UNIX platforms and competence in carrying out statistical analysis of large-scale data.
• Experience in Business Intelligence/Data Warehousing Design and Architect, Dimension Data Modelling, ETL, OLAP Cube, Reporting and other BI tools.
• Extensively used DI transformations such as Append, Lookup, Sort, Splitter, Transpose, User Written Code, and SQL Join for creating, updating and merging various SAS datasets.
• Experience in migration of Hyperion Reports to SAS using SAS Enterprise Guide and SAS DI Studio.
• Experience in using data steps in SAS for creating, maintaining and manipulating datasets.
• Experience in using various statistical procedures in SAS such as Proc SQL, Proc Sort, Proc Freq, Proc Univariate, Proc Means, Proc Transpose, Proc TTEST and Proc Import.
• Performance tuning using techniques like %INCLUDE shared code, MACRO Subroutines, USER Written Functions using PROC FCMP.
• Produced data in various output formats including HTML, RTF, PDF and PS using SAS ODS.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC GPLOT, PROC REG and PROC GLM to check the data distribution of normality and homoscedasticity.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, SUMMARY and DATA NULL for producing statistical reports.
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
• Publishing the reports using SSRS deploying on the server.
• Expertise in transforming business requirements into analytical models, designing algorithms, building models, developing Data Mining and reporting solutions.
• Extensive experience in developing Drill through and Drill down reports, parameterized reports, linked reports, sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Strong experience in designing and developing substantial number of reports in SSRS using the data from ETL Loads
• Using ODBC to connect SAS System with relational database management systems, such as Microsoft and Oracle, to retrieve data and create SAS datasets.
• Excellent experience with export SAS Results to different format, such as XML, Excel using SAS/Export, SAS/ODS for reporting and presentation.
• Proficient in creating and maintaining many datasets using Array, Merge, Update, Set and Proc SQL.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
• Self-motivated individual with strong technical & analytical.
• Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Have experience in different databases like Oracle, SQL Server, DB2, MySql and Teradata.
• Leverage technology and business process skills to generate innovative solutions to address client business problems.
• Experienced in business terms like Basel compliance, equities, fixed income, and risk management.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Experience in Quality Center - design test steps, requirement mapping to tests, executing tests manually, defect logging, and defect reporting.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS:

Skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/Internet, SAS/ODS, SAS/Access, SAS Enterprise Guide, Enterprise Miner, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio, SAS Forecast studio, SAS DI Studio and Management Console.

SAS Procedures: Print, Transpose, Contents, Means, Chart, Plot, Tabulate, Univariate, Summary, Sort, Reg, SQL, Copy, Freq, Forms, Upload, Download, Formats.

Databases: Access, SQL Server, MySQL, Teradata, Oracle.

Software packages: MS Word, Advanced MS Excel, MS PowerPoint, SQL Plus

Reporting Tools: Base SAS versions 9.4, 9.3/9.2/9/8/6, SAS E.G. 7.1/6.1/6.2/5.1 , SAS Graph, MS-Excel, SAS BI Platforms, SSRS, Hyperion, MS-Word, and MS-PowerPoint.

PROFESSIONAL SKILLS:

Confidential, New York, NY

SAS Developer / Programmer

Responsibilities:

• Understand and update the existing code or create new code by using BASE/SAS, SAS/MACROS and SAS/SQL to implement new requirements.
• Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods.
• Extracted data from Oracle using SQL Pass through facility and generated reports.
• Develop SAS code to validate data of different portfolios.
• Modified existing SAS programs and created innovative programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Generate Reports in user required format by using ODS and PROC Report.
• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.
• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.
• Used SAS PROC SQL Pass through Facility to work with Teradata database.
• Analyzed and implemented the code and table changes to improve performance and enhance data quality.
• Created and revised the common macros.
• Reading data from different sources like .csv, excel, tab delimited files.
• Perform various business checks on the source data to confirm whether data is correct or not.
• Compare the source data with historical data to get some statistical analysis.
• Perform transformations like Merge, Sort and Update to get the data in required format.
• Create the understandable EXCEL template to start dad mapping for each line of business.
• Extensively utilized SAS/BASE, SAS/SQL and SAS/MACRO.
• Extensively used procedures such as PROC APPEND PROC IMPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS and PROC SQL.
• Involved in project review meetings with respective Business SME's.

Environment: SAS 9.1.3, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, UNIX.

Confidential, Memphis, TN

SAS Developer / Programmer

Responsibilities:

• Created Reports in SAS E.G. and SAS DI Studio using Proc Report, Proc Summary, proc means, Proc Print, Proc Tabulate. Developed enhanced multi-sheet Excel and PDF-based reports using SAS ODS (Excel, HTML, RTF, PDF), which are used to generate on Hyperion platform.
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment.
• Supported with Hyperion to SAS EG conversion Project. Specialized on SAS EG projects.
• Used SAS Enterprise Guide to create graphs, cascading prompts, and deploy stored processes.
• Converted more than 250 Hyperion reports to SAS Using SAS BI Tools.
• Attend meetings with end user to collect requirements.
• SAS data stores (SAS OLAP Cubes) required supporting business intelligence and reporting needs.
• Derived business intelligence solution ensuring accuracy, completeness and quality of the data in Global Sales operation systems.
• Exclusively worked on SAS Stored process to trigger query builder.
• Handled several data, Technical, formatting Issues in the process of migration.
• Create analyst-level dashboards and pivot tables using Prompts in SAS EG and Stored process. I
• Develop SAS Metadata API that register and publish reports for SAS IDP and Web Report Studio
• Worked on scheduling jobs in SAS DI Studio. Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Used SAS Web Report Studio (WRS) to manipulate reports.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Expertise with several SAS dataset functions, SAS system options, Macros, Macro variables, stored process.
• Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Created dynamic Macro arrays by SQL and with data step programs. Used SAS Macros and SAS SQL queries to obtain results which were generally stored as delimited text.
• Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.
• Worked on the Teradata queries as part of migration efforts.
• Thorough hands-on experience in using ODS to generate different files including RTF, MS Excels, PDFs and HTMLs.
• Raw data files in Excel and RTF formats in SAS for invariably short or unrelated data requested for a report was used to append or merge in SAS to obtain desired reports.
• Extensive knowledge and experience in Microsoft Office tools like MS Access, MS word, MS PowerPoint and MS Excel.

Environment: SAS 9.3 and SAS 9.4, SAS EG 7.1, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SAS BI, SAS WRS, SAS IDP, SAS DI Studio, Oracle Teradata SQL Assistant 14.10, Oracle Hyperion Studio, Oracle Hyperion Web Client, MS Office, and Unix.

Confidential, Buffalo, NY

SAS Programmer / Analyst

Responsibilities:

• Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.
• Performed daily weekly and monthly campaigns as per the deliverable schedules.
• Creating waterfall reports and analyzing data and creating ad-hoc’s on deliverables.
• Advanced analytics and reports created based on the criteria provided.
• Extracted data from various sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.
• Automated the existing audit reviews and production.
• Performed approvals for peer audit reviews on reports by analyzing data.
• Developed SAS Macro programs to create ad-hoc reports.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Created dashboards and KPI's using SSRS.
• Created parameterized reports, drill down, and drill through reports using SSRS.
• Worked on SAS D.I. studio for ETL processing, Extract data from SQL Server, DB2, Teradata and loading data in to Target tables in Teradata, worked on different transformations in SAS D.I. studio.
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Created reports using Proc Report, Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML Excel and RTF.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF, and Excel formats using Reporting Services.
• Interaction with Business Analyst, SMEs and other Data Architects to understand Business needs and functionality for various project solutions.
• Documented the code and algorithms logically.
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS 9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SAS BI, SAS web reporting studio, SSRS SAS DI Studio, Oracle, Teradata, SQL Server, DB2, MS Office, and Unix.

Confidential

SAS Programmer / Analyst

Responsibilities:

• Developed SAS Macro programs to create Ad-hoc reports
• Created macro program to create Macro variables to pull data from DB2 for monthly data extraction
• Extracted data from various sources like Oracle and Teradata and text files using SAS/Access, SAS SQL procedures and created SAS datasets
• Worked on a Unix and Windows platform in a server application environment
• Passing Macro variables to Unix server from windows remotely created from windows to develop good user interface for the end user
• Done performance tuning for the programs created
• Used SAS Proc SQL pass through facility to connect to DB2 tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join
• Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text
• Created dynamic Macro arrays by SQL and with data step programs
• Developed SSRS Reports according to the client requirements on the tables and published in server
• Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting
• Assisted in the design and testing of program logic, coding programs, program documentation and preparation of programs.
• Developed Macros to replace repetitive codes for generating Descriptive statistics.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, clustering etc. to gain insight into the data.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Maintained and updated existing utilities as per project requirements.
• Active involvement in knowledge sharing via presentations at monthly programming meetings.

Environment: SAS 9.2/9.3, SAS/Access, SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, SSRS DB2, MS Office, UNIX.

Confidential

SAS Developer / Programmer/ Analyst

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process copious amounts of customer response and sales data.
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms.
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.
• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns.
• Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.
• Created Ad hoc reports for marketing managers using SAS Enterprise Guide.
• Experience manipulating multiple inputs from various sources, including legacy systems, external vendors and corporate databases.
• Worked in tandem with multiple teams like data analysis team, risk analysis team, marketing team to understand the data relationships.
• Experience in preparing, reviewing, executing the test cases default lagging, tracking and analysis.
• Expertise in Health Care Analytics, Fraud Modeling and Risk Management.
• Highly motivated, organized with excellent analytical and communication skills in establishing effective task priorities as a team player with result-oriented attitude
• Expertise in ETL/DWH testing concepts, Informatica power center, TOAD, Base SAS concepts, basic understanding of Perl
• Programming and analyzing in guiding with the design and development of the application
• Data preparation: drawing flowcharts indicating the input data sets, sorting and merging techniques to get the required output and then writing the code
• Involved in communicating with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data
• Was involved in development and analyzing periodic forecasting reports using various MS Excel and SAS tools.
• Data validation: data was validated before use the same for final analysis.
• Data analysis: the validated data was analyzed to get the following: market share find top customers for the target lists look for responsiveness of targets based on sales force effort
• Extensively used Arrays in SAS data steps. Merging datasets and manipulating datasets
• Extensively used SAS/Macro programming
• Used Enterprise Miner for taking data and converting them into required SAS datasets. Also used the SAS Forecast Studio for appropriate analysis of data for different Forecasting models like Time Series Forecasting
• 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, SAS/Base, SAS/Macro, SAS/Connect, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS Enterprise Guide, SAS/ODS, Enterprise Miner, UNIX, SQL, MS Office, MS Access, MS-Excel, Windows.