RELEVANT SUMMARY

• Over 7 years of extensive experience in SAS performing advanced programming and BI Development including data extraction and manipulation, writing macros and reporting, with major financial institutions.
• Extensive experience as a SAS programmer with SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/ETL, SAS ODS Enterprise Guide EG .
• Extensive experience in developing stored processes and performing statistical analysis such as Regression, TTests, ANOVA and Chi-Square Test.
• Strong knowledge of testing methodologies at all stages of Software Development Life Cycle SDLC .
• Experienced in preparation of SAS datasets, Tables, Listings, Graphs, Reports, and summaries according to requirements and Standard Operating Procedures SOPs .
• Experienced in building OLAP cubes, web reports, dashboards and Portlets using SAS BI tools.
• Expert level skills in SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/SQL and MACRO.
• Experienced in utilizing SAS Procedures, Macros and other SAS applications for data updates, data cleansing and reporting.
• Extensive experience working with different databases including Oracle, Teradata, DB2 and MS SQL Server.
• Highly motivated, Organized Team player with excellent analytical and communication skills.

TECHNICAL SKILLS

• SAS Skills: Base SAS, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT, SAS/GRAPH,
• SAS/CONNECT, Stored Process
• Database: Oracle/8x/9x/10g, Sybase, Teradata, MS-Access, MS SQL Server, DB2 and Netezza
• Languages: SQL, PL/SQL, VBA, NZSQL, KornShell, Perl and R
• SAS EBI Tools SAS Enterprise Guide, Web Report Studio, Information Map Studio, OLAP Cube Studio, Management Console, Information Delivery Portal, Add-In for MS Office, BI Dashboard
• BI Tools JMP, Tableau
• Operating: Windows XP/7 and UNIX
• Others: MS Office, MS Project, Power Point, Excel, Outlook and Access

PROFESSIONAL EXPERIENCE

SAS Developer

Confidential

Responsibilities:

• Understood the processing of present day NYSE SAS jobs involving macros, SQL joins and merges and developed substitute techniques to create the same functionality using Oracle/NZ SQL queries, stored procedures and analytic functions.
• Configured and managed SAS interaction with 3rd party software such as Netezza and GreenPlum databases.
• Performed Ad-hoc querying, reporting and data management.
• Developed KornShell and Perl scripts to schedule the newly developed codes for batch processing.
• Build standard and custom reports for distribution to internal and external customers/users.
• Coordinated with users and manage the deployment of content, code, and configuration changes to schedule production loads/jobs

Environment: SAS 9.2, Oracle SQL Developer, Netezza, Aqua Data Studio, UNIX, Windows 7

SAS Programmer, Navigant Consulting, Washington DC December 2012 May 2013

I was working on the Troubled Debt Restructuring TDR project for RBS Citizens Bank of Rhode Island. I am involved in writing advanced SAS programs and creating Enterprise Guide projects that perform processes such as importing external files, data cleansing, transformations, cash flow models and building reports. I analyzed loan and mortgage data in addition to other portfolios such as credit cards, treasury and automobiles and perform statistical analysis on them. Also Ad-hoc querying and Building Accounting reports formed part of my job responsibility.

Responsibilities:

• Worked on the Troubled Debt Restructuring project for the RBS Citizens Bank of Rhode Island using SAS 9.2 environment.
• Wrote advanced SAS programs involving macros, sql joins merges, prompts and building Enterprise Guide projects.
• Translated user data and reporting requirements into SAS programming language.
• Performed Ad-hoc querying, reporting and data management.
• Worked with relational databases such as DB2 and MS-Access and SAS storage server SPDS.
• Worked with different kinds of financial data including credit cards, student loans, small business, treasury, automobile.

Environment: SAS 9.2, Enterprise Guide 4.3/4.2, ODS, DB2, SPDS, MS-Access, Windows 7

SAS BI DEVELOPER/ TRAINER

Confidential

Responsibilities:

• Worked on SAS reporting projects for the Centers for Medicare and Medicaid Services CMS using SAS 9.2 environment.
• Developed Information Maps, OLAP cubes and Web Reports based on project requirements.
• Designed, created and tested stored processes, programs and reports.
• Performed the role of SAS Trainer and conducting one to two day training sessions on SAS Technology for CMS Business Analysts.
• Assisted the SAS User Coach to develop content for the SAS Training including Exercise Manual, SAS Datasets, EG projects, Information Maps.
• Prepared technical SAS documents as part of the CMS SAS Electronic User Forum
• Performed role of Backup Developer and assisting other developers on two CMS SAS projects
• Participated in peer code reviews and Validated SAS project deliverables

Environment: SAS 9.2 Enterprise Business Intelligence Software Suite, Enterprise Guide 4.3, OLAP Cube Studio 4.2, Information Map Studio 4.2, Web Report Studio, Teradata, SAS/Access, Windows 7/XP

SAS BI DEVELOPER,

Confidential

Responsibilities:

• Created SAS stored processes using Enterprise guide 4.3 in the SAS 9.2 environment.
• Developed SAS codes that generate custom reports for enterprise-wide applications using both base and advanced SAS programming.
• Developed and validated existing SAS programs as part of an upgrade to SAS 9.2 environment.
• Served as the Lead Developer and Point of Contact for about 150 reports collectively, over different business areas.
• Used SAS Management Console to create the metadata necessary to define the reports over a web portal in the SAS EBI environment.
• Worked on the Technical Support team to assist users with their issues on SAS 9.2.
• Responsible for preparing the Developer's Guide and implementation plans necessary for the migration of reports to the test and production environments.
• Assisted with the requirement analysis, design and SOP document creation.
• Experienced with extensive debugging of SAS codes to identify the issue.
• Performed unit testing on Stored Processes and newly developed SAS programs.
• Assisted the QA team with system integration testing and provided post-production support.

Environment: BASE SAS 9, SAS/MACRO, SAS/SQL, SAS/STAT, SAS Enterprise Guide and SAS Management Console, Sybase, DB2 and UNIX.

SAS BI DEVELOPER

Confidential

Responsibilities:

• Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making, measured the execution of bank strategy and identified opportunities for improving existing processes.
• Used OLAP Studio to create cubes for data analysis and report generation
• Used SAS/Access to read and write data to and from Enterprise Data warehouse.
• Used Proc SQL to extract data and wrote SQL queries efficiently.
• Extracted data from MS Access, Excel and Oracle to generate reports.
• Used Dynamic Data Exchange DDE to extract data from Excel Spreadsheets.
• Used SAS web report studio to develop reports for users.
• Responsible for analyzing experimental data, investigate relationships in contingency tables.
• Responsible for evaluating market research data and organizing observations.
• Used Base SAS and SAS/Macro procedures to create tabular reports.
• Wrote numerous SAS Stored Processes.
• Served as data custodian and point of contact for operational data warehouse issues. Prepared data views for RBSS authors, analyzers and viewers.
• Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress toward the Retail Banking Division's strategic objectives.
• Programming experience in COBOL and VB.Net
• Developed and unit tested codes written in SAS, JavaScript and COBOL.
• Documented policies and procedures required for supporting system enhancements.

Environment: SAS BI 9, Enterprise Guide 4.3, OLAP Cube Studio 4.2, Web Report Studio 4.2, SAS/Macro, SAS/SQL, SAS/Connect, SAS/AF, SAS/Graph, SAS/Access, SAS/Internet, MS Access, Oracle, Sybase, Windows NT and UNIX.

SAS BI DEVELOPER

Confidential

Responsibilities:

• Involved with BI Team for delivering a combination of Stored Processes, Web Reports in SAS BI.
• Developed summary tables of the data in various sources using Base SAS and SAS/Macro.
• Employed techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output. Wrote SAS Processes.
• Prepared graphs using the modified data for business analysis.
• Used Information Delivery portals to develop portlets and build dashboards.
• Used SAS/ACCESS to gather data from RDBMS like Oracle, Teradata and DB2.
• Coordinating the production of monthly, quarterly and annual performance reports for senior management.
• Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used time to time and created tables, graphs and listing reports.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
• SAS scripts are run and the output datasets are exported to SAS.
• Created charts showing performance using SAS/GRAPH.
• Analyzed statistical operations such as regression, forecasting, trending and survival analysis.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Run reporting programs and downloaded the results into excel and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: BASE SAS 9, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT and SAS/ACCESS, Oracle, Sybase, Teradata, DB2, PL/SQL and UNIX.

SAS DEVELOPER

Confidential

Responsibilities:

• Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE.
• Analyzed data using various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA.
• Used SAS macro facility to create macros for statistical analysis, reporting results and data extraction.
• Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
• Generated HTML, Listing, Excel and RTF reports for presenting findings of various statistical data using procedures like PROC REPORT, PROC FREQ and also SAS ODS.

Environment: SAS/BASE, SAS/ACCESS, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SQL, ORACLE.