SUMMARY:

• SAS Advanced Programmer with hands - on experience of over 8+ years in programming, analysis, design, development, testing and implementation of Statistical applications in financial and marketing/sales projects for major financial companies of various projects for different industries.
• Proficient in SAS/Base, SAS/Macro, SAS/SQL, SAS/Graph, SAS/ODS in UNIX, Linux and Windows environments.
• Expert in Data extraction from several databases including Oracle, Teradata, Hadoop and other external files usingSAS/ACCESS,SAS/SQL pass through facility, LIBNAME statements, PROC IMPORT procedure and also viaSASData steps
• Extensively used Macros and application of SAS procedures like PROC REPORT, PROC PRINT, PROC FORMAT, PROC SUMMARY, PROC DATASETS, PROC SQL, PROC TRANSPOSE and their multiple options in generating reports, PROC MEANS, PROC FREQ, PROC SORT, PROC GLM, PROC SURVEYSELECT for statistical analysis, PROC IMPORT and PROC EXPORT for data transfer.
• Migrated data from different sources text based files, Excel spreadsheets, and access to SQL Server databases using SQL Server Integration Services.
• Diverse Knowledge with Data Step, SAS Macro and Variety of SAS Procedures and combining them with various options provided in developing efficient and dynamic programs.
• Worked in various levels of SDLC (System Development Life Cycle) which involves Analysis, Design, Development, Testing, Implementation and support with extensive exposure in database.
• Experience in utilizing SAS Functions, SAS Procedures, Macros, and other SAS application for data updates, data cleansing, and reporting.
• Experience in list pull for the Direct Marketing Campaigns. Used to analyze the data, taking risk management into consideration.
• Well versed with creating HTML, PDF Reports for financial data using SAS ODS facility and proc report.
• Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of results.
• Experiences in performing full fledge ad hoc queries and User Acceptance Tests (UATs) for various applications and reports, based on daily basis.
• Successfully analyzed business logic and system needs to prepare dataflow diagrams and documentation.
• Generated summary reports using Excel PIVOT Tables.
• Conducted kick-off meetings with Business Partner to gather the requirements.
• Excellent leadership, analytical and problem solving skills. Excellent communication and presentation skills.

TECHNICAL SKILLS:

SKILL: SAS 9.2, SAS 9.0 (BASE, ACCESS, MACROS, SQL, STAT, CONNECT, SHARE, GRAPH, ODS, SAS Functions)

SAS Procedures: Report, Freq, Tabulate, Transpose, GPlot, GChart, Print, Datasets, Format, Compare, Append, Import, Export, Explode, Printto, Contents, Means, Summary, SQL, Copy, Sort, Univariate, Reg, Mixed and ANOVA.

Languages: C, SAS and SQL.

Databases: Oracle 8x/9i, Teradata, Hadoop MS Access, SQL Server 2000

Microsoft Products: MS Office 2K/2010, MS Visual Basic 6.0

Operating Systems: MS-DOS, Windows 2000/XP, UNIX, Linux, Mainframes(z/OS)

PROFESSIONAL SUMMARY:

Confidential, NJ

Sr. SAS Developer

Responsibilities:

• Effectively ensured the deliverables are prepared to satisfy the project requirements
• Extracted data from Mainframes and various databases such as Hadoop and Teradata and transformed them to IDEAS (Unix Platform).
• Used SAS software to connect to Hadoop and Teradata to read data and performed predictive analysis, Risk model and opportunity models in SAS.
• Worked on Hue and Impala applications in Hadoop.
• Experience in writing SQL queries to extract data from various relational databases such as Teradata and Hadoop (Hive database) and perform data analysis using SAS.
• Used variousSASProcedures - Proc Freq, Proc Means, Proc Format, Proc Sort, Proc Append, Proc Contents, Proc Printto, Proc Compare, Proc Import/Export, Proc SQL, Proc GChart, Proc GPlot, Proc Transpose, Proc Datasets, Proc Summary, Proc Tabulate and Proc Report.
• Extensively developed SAS Macros to automate the process of generating monthly data sets which were further used to perform predictive analysis
• Developed and maintained programs that were used by the modeling department to develop risk and opportunity models.
• Created SAS Macros to send automatic email notification to the users about the status of monthly SAS ETL jobs
• Created process flows in SAS Enterprise Guide and scheduled jobs on SAS Management Console and UNIX using Crontab and on based on the requirement.
• Developed SAS stored procedures, Created SAS ETL jobs using SAS DI Studio
• Wrote SAS programs to automate the ETL monthly process to extract data from Mainframes and load the SAS datasets into IDEAS (UNIX platform)
• Involved in preparing documentation for the previous version of the application along with Design document, diagrams and code samples for the requirements.
• Experience in applying techniques to efficiently manage huge volumes of data with millions of records.
• Presented numerical information in various formats. CreatedSAScustomized reports using the DATA NULL technique
• Worked withSAS/ODS, HTML to produce dynamic web interfaces fromSASprograms
• Analysis of the SAS existing code, tune /enhance the existing code and created new code based on the users requirement.

Environment: SAS/BASE9.4, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/ODS, SAS/SQL, SAS ENTERPRISE GUIDE6.1, SAS MANAGEMENT CONSOLE 9.4, UNIX, MAINFRAMES, WINDOWS, SAS Data Integration Studio, HADOOP, HUE, IMPALA.

Confidential, NJ

Sr.SAS Analyst Programmer

Responsibilities:

• Understanding the Business Requirement and developing new code and changing the existing code to implement the enhancements.
• Worked closely with database management team and SAS business analysis team to understand the requirements and developing the SAS code to meet the requirements.
• Developed SAS codes to import flat and excel files, merged, sorted and summarized data, and input data.
• Applied numerous “suppressions” on lead files based on specifications from the execution.
• Created SAS Data sets from Teradata tables and performed weekly and monthly files using SAS/BASE and SAS/SQL for the various in-house business departments.
• Extensively used Shell scripts to automate the process to create reports.
• Implemented data cleaning techniques using PROC PRINT, DATA NULL, Transpose, NODUPKEY, and PROC SQL.
• Rigorously used data step options like keep, drop, rename, compress as a part of storage efficiencies. Data set options if, where, missover, truncover etc. were used in reading raw data files.
• Used extensively SAS ODS to create waterfall reports.
• Extensively used macros to increase the efficiency and accuracy of the application.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Generated EXCEL, HTML, PDF, and RTF reports using SAS ODS, PROC REPORT.
• Involved in defining and performing the UAT test cases for complex business scenarios and executed the test cases successfully to generate a report to the management to compare the success rate.

Environment: Enterprise Guide 4.1, SAS 9.1, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/MACROS, Oracle 9i, MS Excel, Unix, DB2, SQL Builder, Windows XP.

Confidential, IL

SAS Programmer

Responsibilities:

• Understanding the Business Requirement and Gathering the requirements from Business users.
• Responsible for targeted list pull and applying the suppressions as per the Business Requirement Document.
• Worked closely with database management team and responsible for various output files for various channels like Direct Mail, Phone Channel, email, ATM etc.
• Extensively used macros to increase the efficiency and accuracy.
• Involved in creating analysis dataset specifications, Data definition tables.
• Created several Summary Tables, Listings and Graphs for Statistical comparison.
• Writing SAS data sets into a delimited text file and validated data and created HTML reports using different procedures like proc freq, proc means, proc transpose, proc datasets, proc sort, proc compare, proc sql, proc report etc. and SAS ODS facility.
• Implemented data cleaning techniques using PROC FREQ, PROC PRINT, DATA NULL, PROC MEANS, PROC TABULATE, PROC UNIVARIATE, NODUPKEY, and PROC SQL.
• Match merging using merge statement with in= option was extensively used to find exceptions of loan numbers from different tables.
• Involved in writing UNIX shell scripts, which are used as a source to run SAS batch programs and generate log files, list files and reports in desired directories by passing parameters.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Generated EXCEL, HTML, PDF, and RTF reports using SAS ODS, PROC REPORT.
• Served as point person and subject matter expert representing the business perspective in all prospective client meetings.

Environment: SAS 9.1, Base SAS, PC SAS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/MACROS, MS Excel, Unix10, database Oracle.

Confidential, VA

SAS Programmer /Analyst

Responsibilities:

• Involved in extracting, analyzing and auditing marketing data from the data-warehouse using SAS.
• Participated in marketing campaign-planning meetings with program managers in order to develop and document campaigns specifications.
• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS.
• Used TOAD features to connect to multiple databases for comparing views and checking syntax errors in the PL/SQL stored procedures for performance tuning and quality control.
• Worked with Marketing and Financial departments to develop required applications for performing complicated analysis like customer retention analysis, identifying cross-sell opportunities, portfolio performance tracking, calculating moving averages etc.
• Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data, preplanning and doing ad hoc joining of multiple Oracle views.
• Generated SAS/ MACROS and several stored procedures for reusability and to minimize data processing.
• Wrote stored procedures for specific analytic reports
• Wrote large aggregation SQL queries using in-line views
• Ran SAS report programs and downloaded the results into Excel for data analysis.

Environment: SAS 9.1, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/PC, UNIX, PL/SQL, Oracle 8i.

Confidential, Columbus, OH

SAS Programmer

Responsibilities:

• Interacted with business users and gathered business requirements.
• Extract data from different data sources like DB2, Excel sheets, Delimited text files, Comma separated files using Sql pass through facility and different data steps respectively.
• Responsible for updating historical tables on monthly and weekly basis.
• Created test and control populations for Direct Marketing based on the business rules
• Responsible for pulling the data for direct mail (DM) and email marketing (EM) for various marketing campaigns.
• Generated HTML Reports Using SAS/ODS and Summary reports using Excel PIVOT Tables
• Loading SAS data sets as a table onto DB2 using Sql pass through facility, library reference method or Proc DBLOAD, which is then used for UAT purpose to be tested by Business users.
• Dictionary tables were extensively used in finding the metrics for the whole DB2 table or a SAS data set.
• Rigorously used data step options like keep, drop, rename, compress as a part of storage efficiencies. Data set options if, where, missover, truncover etc. were used in reading raw data files.
• Used %SYSFUNC, its functions and options to update huge SAS data sets with a given small SAS data set. Open, close, Fetch, varnum, getvarn, getvarc etc. were some functions used with %SYSFUNC.

Environment: SAS 9.1, SQL, Oracle 9i, SAS/BASE, SAS/ACCESS, SAS/SQL, SQL, SAS/Graph, Excel, Windows NT and UNIX

Confidential, St Louis, MO

SAS Programmer

Responsibilities:

• Created email error macro for ETL automated scripts.
• Responsible for executing Telecom and Direct mail execution programs.
• QA and Reporting Results of Outbound Final Files for each campaign.
• Submitted file to Risk for Approval on final file to be processed.
• Created lead generation files required for the campaign execution using mainframe and Oracle databases per Telecom and Mail provided by the marketing.
• Participated in weekly meetings and discuss ongoing process changes and upcoming initiatives.
• Segmented data per Telecom / Mail Criteria per strategy provided.
• Created SAS datasets using multiple data step inputs and files across platforms.
• Inputting all variable changes into Change Form database, broken out by segment and monitoring process.
• Wrote SQL Queries to extract data per business per Telecom / Mail.
• Responsible for on-going communication with relationship on campaign management.
• Worked with testing and other teams for implementing changes in database variables.
• Created reporting spreadsheets for each campaign including Hotlists
• Established and implemented process/procedures guidelines overall accuracy and attention to detail
• Generated Summary Reports using Excel PIVOT Tables

Environment: SAS 8.2, BASE SAS, SQL, Oracle9i, MS Access, Excel, UNIX and Windows NT

Confidential

SAS Programmer

Responsibilities:

• Extensively involved in SAS programming to create tables, listings, graphs.
• Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Transferring and migrating data from one platform to another to be used for further clinical analysis.
• Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports.
• Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical summary reports and other reports. Supporting other team members in designing and developing programs.

Environment: SAS V6.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, Oracle 7.3, CDW and UNIX.