SUMMARY

• Over 7 years of experience in programming, analyzing and reporting in various Banking, Healthcare, Insurance and retail using SAS on Windows and Unix environments.
• Extensive Experience in SAS/Base, SAS/Macro, SAS/Stat, SAS/Access, SAS/Graph, SAS/SQL, SAS/ETL, SAS/ODS, and SAS/Gchart.
• Profound knowledge and strong experience in Base SAS, SAS/Macro, SAS/ODS, SAS/Graph, SAS/SQL, SAS/Stat, SAS Share, SAS/IntrNet and SAS/Connect, SAS Enterprise Guide, SAS Enterprise BI Server, SAS Management console.
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and managing data.
• Expertise in analyzing and coordinating audit data, generating reports and tables.
• Leverage technology and business process skills to generate innovative solutions to address client business problems.
• Created RTF, PDF, and HTML listings, tables and Reports using SAS/ODS.
• Sound knowledge of linear programming, probability, statistics, design of experiments, quality assurance and optimization techniques.
• Excellent working knowledge of SAS Business Intelligence, SAS Enterprise Guide 4.1/5.1, JMP 9, SAS OLAP Cube studio 9.1, SAS Information Map Studio 3.1, SAS Data Integration Studio 3.4 and SAS Management Console 9.1
• Created reports in SAS and exported to Excel spreadsheets, created web reports using Web Report Studio
• Strong experience with databases likeOracle, MS SQL Server, Teradata, DB2 and MS Access
• Involved in extracting data from XML files, flat files, CSV, Dat files, Mainframe VSAM files and relational databases, transforming the data and loading into the DW.
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Extensive experience in preparation of tables, listings, and graphs.
• Experienced in business terms like Basel compliance, equities, fixed income and risk management.
• Expertise in statistical, quantitative and analytical data in financial sector.
• Good at migrating SAS datasets and SAS applications from Unix <=>NT
• Experienced in producing external files and customized reports using various SAS procedures like Proc Print, Proc Report, Proc Tabulate, Proc Means, Proc Summary, Proc SQL, Proc Freq, Proc univariate, Proc transpose, Proc Rank, Proc Access and data Null techniques.
• Skilled at using basic and advanced RDBMS concepts, SQL, PL /SQL and Unix commands.
• Experience in Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

SAS Skills: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/ETL, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide 4.0, Enterprise Miner, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 3.1, SAS Information Delivery Portal, SAS Olap Cube Studio 9.1 and Management Console.

Databases: Oracle 10g/11g, MS Access, MS SQL Server, DB2, Teradata

Programming Languages: PL/SQL

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

Operating Systems: Windows 8/795/98/00/NT, Unix

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. SAS Programmer/Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets for statistical analysis, validation and documentation
• Used procedures such as Proc Freq, Proc Means, Proc Sort, Proc Print, Proc Tabulate and Proc Report.
• Developed new or modify macros for report generation using SAS / Macros as per the statistician requirements.
• Developed SAS programs for statistical analyses and data displays.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Involved in modify Legacy Data Warehouse SAS jobs to run on the MDW platform and execute SQL against the DB2.
• Executed the SAS jobs in batch mode through Unix shell scripts
• Used the ETL tool (Extraction Transformation Load Process) to load data in the database using control files.
• Worked on advance querying the database using SAS Enterprise guide in calculating and computing columns, using filters, manipulated and prepare the data for reporting and statistical summarization
• Involved in designing the project and process flow diagrams using SAS Enterprise Guide
• Conduct data mining and statistical analysis (t-test, Chi-Square test, Anova, and logistic regression) to improve existing strategies.
• Design, coding, testing, debugging, and documentation of multiple treatment and payment SAS programs for charge-off card data.
• Involved in using Forecast Studio for analyzing forecast models.
• Involved in Physical modeling on Teradata such as creation of tables, indexes and views
• Analyzed existing SAS scripts based of off various platforms such asUnix and Windows.
• Prepare daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.
• DevelopSASand VBA macros for automating the analysis, process, and report generation.
• Wrote SAS reports to Excel, the SAS content server, HTML, and PDF
• Automated SAS jobs running on a daily, weekly and monthly basis using SAS/BI and Unix Shell Scripting
• Wrote stored processes to be used through the SAS Information Delivery Portal
• Used SAS Enterprise Miner for data mining.
• Review and modify SAS Programs, created customized ad-hoc reports, process data for publishing business reports; automate and distribute designed business reports on schedule in various format.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Frequent Use of functions and Proc Format.
• Created reports in the style format using ODS statements and Proc Template.
• Design SQL query to select, create, append, and update database tables and views.
• Developed numerous ad-hoc SAS programs to create summaries and listings.
• Created SAS Macros and SAS Graphics. Customize the existing programs using macros as per the statistician’s requirements
• Generated SAS customized reports using the DATA NULL and Proc Report techniques.

Environment: SAS 9.3, SAS/Base, SAS/BI, SAS/Graph, SAS/Stat, SAS/SQL, SAS/ODS, Excel, Oracle 10g/11g, SAS/ETL, Windows NT, Unix, Teradata, DB2, SAS Enterprise Guide 5.1, Enterprise Miner, and SAS Forecast Studio.

Confidential, NYC, NY

Sr. SAS Developer/ Analyst

Responsibilities:

• Design and develop, efficient tool for data integrity tracking.
• Maintained performance reports, creation of reports for online and batch application of various server and Involved in preparing executive Dashboards for senior level management
• Used SAS, SAS Macros, Procedures like SQL, Freq, Univariate, Summary, Means, Transpose, Arrays, Tabulate, and Sort to extract data, prepare integrated data base and its analysis
• Extracted data sets from server using Proc Import and created datasets in SAS libraries. Coding SAS programs with the use of SAS/Base and SAS/Macros for ad-hoc jobs
• Developing CDIT and in Unix environment using SAS tools.
• Reporting Scripts and SAS jobs will be modified to connect to DB2.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide.
• Involved in developing Unix shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Teradata tables and created Logical and Physical Data Models using Erwin design tool.
• Used various Tagsets options in SAS ODS Mark up engine (Excel XP, MS office, MSoffice2k) to deliver the Formatted EG reports as XML /HTML sheets that could be opened with Excel directly.
• Created Custom Stored Compiled Macro’s to help Analysts export ‘formatted’ datasets to MS excel.
• Analysis, programming and creation of reports on existing strategies usingSASand SQL.
• Understanding various data sources to the GRMS (Global Risk Management System).
• Extracting data from flat files using SAS Base and Macros.
• Configured SAS BI components and solved BI related issues.
• Revising a series of Oracle PL/SQL programs to SAS for extraction of data from Oracle in Enterprise Miner.
• Validating and profiling the variables using SAS Base / Macros using proc freq, proc means, proc format and proc univariate.
• Provided analysis, development, and testing for SAS programs using Teradata datamart to consumer and small business areas for market analysis.
• Created batch and interactive applications utilizing SAS/Base, SAS/SQL, and SAS/Macros.
• Daily generate consolidated reports and alerts using SAS.
• Sending automatic sigma / control chart based alerts from Unix system to Lotus notes using Base SAS, Macros Language and data null .
• Developed various SAS / AF screens to publish the SAS Datasets and reports / graphs.
• Developed programs to create daily HTML reports using ODS and CSV reports using Proc Export.

Environment: SAS9/9.2, SAS/Base, Macros, SAS Access, SAS AF/SCL, SAS Enterprise Guide, Enterprise Miner, SAS/BISAS/ETL, SAS/Connect, Teradata, DB2, MS excel, SQL and Unix Crontab.

Confidential, Columbus, OH

SAS Developer

Responsibilities:

• Prepared Functional Solution Document as part of revenue Attribution based on the Business requirement document provided.
• Worked on Technical Solution Document, which included ETL designs for the SAS Data Integration (DI) development.
• Designed job flows using SAS/DI to extract data from source systems, perform required transformations and load back to target.
• Perform Source system analysis on the available source data, which was needed as part of RTE Data Model design.
• Used SAS/BRM to integrate all the business rules and then invoke them back into SAS Data Integration (DI) jobs.
• Design base tables structure, which will also be used for reporting purpose as well as in RTE.
• Created ETL jobs in SAS Data Integration (DI) based on Technical Solution Document. These jobs included coded algorithm and rules created in SAS BRM.
• Worked extensively in sorting, merging, concatenating and modifying SAS Data sets in different environments like Windows and Unix.
• Extracted data from the database using SAS/Access, SAS/SQL procedures and created SAS data sets.
• Solid understanding and proficient use of various procedures like Proc SQL, Proc Summary, Proc Report, Proc Freq, Proc Means, Proc Contents, Proc Dataset, Proc Append, Proc Import, Proc Export, Proc Print, and Proc Sort.
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.
• Extracted, performed validation and generated SAS data sets from Teradata; applied SQL Pass through Facility.
• Developed new macros for report generation using SAS/Macros as per the customer's requirements.
• Retrieved Millions of Records Using different Procedures.
• Performed Job scheduling using SAS Management Console and monitoring jobs using Process Flow Manager and using commands on Unix.
• Involved in code migration across multiple environments. maintenance of all the Table scripts needed during Migration.
• Done code and data validations while moving across multiple environments.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS Data integration (DI) studio, SAS Management Console, SAS Enterprise Guide, SAS/SQL, Oracle, Unix, and MS Office.

Confidential, Baltimore, MD

SAS Programmer

Responsibilities:

• Involved in migration of data from Informix on SunOS 5.8 to DB2 on AIX 5.3 and validation of SAS jobs, Unix jobs, SAS Reports, History data, other scripts, and programs from the Legacy Data Warehouse (LDW)
• Using Korn shell scripts execute SAS jobs that move data from Informix to SAS MDDBs or SAS datasets.
• Responsible for migrating the korn shell scripts, which will perform the Extraction Translation and Loading of data.
• Responsible for establishing the connection to data base in the new environment.
• Optimizing the shell scripts according to the EDW requirement.
• Rewriting the SQL quires with the new table structure.
• Generate Multi-dimensional data databases (MDDBs) within SAS OLAP Server
• Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.
• Responsible for importing, manipulating and generating weekly and monthly list reports using SAS Enterprise Guide
• Generate reports that are posted on DirectNet where they are accessible by users SAS jobs are categorized as Production.
• Building of generic utility processes for large volume sort, sort/summation, and Unix batch SAS execution
• Created final reports in Excel sheets which were then accessed by the business users.
• Production jobs are built by placing as SAS procedure within a Korn shell script that is then executed via JCL and through CA-7 scheduler.
• SAS jobs are typically written within SAS using Pass-Through SQL that is executed against the database via SAS/Access.
• Developed Daily, Weekly and Quarterly reports for each service.
• DATA NULL was used for developing custom reports.
• ODS is used for generating HTML files.
• Production Support, troubleshooting problem solving.
• Extensively used Proc Means, Proc Freq and Proc Summary.

Environment: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/IntrNet, SAS/Share, SAS/Connect, SAS Macros, SAS/Access, SAS Enterprise Guide, Sync sort, Oracle, SQL, (IBM AIX V5.2),CVS, Unix, DB2, Excel, Sun Solaris, Windows NT, MS Office, and HTML

Confidential, San Francisco, CA

SAS Programmer

Responsibilities:

• Service clients in claims, billing, marketing, and sales who submit their projects to our Project Register.
• Develop and maintain applications and databases by evaluating client needs, analyzing requirements, and developing software systems.
• Provide information for statistical analysis by planning data collection, analyzing and interpreting data, and applying statistical methodologies.
• Extract data from DB2, IMS, SAR reports and SAS data sets. Base SAS 8.2, SAS Macro, SQL.
• Involved in code changes for SAS programs and Unix shell scripts
• Produced data extracts for various departments and outside vendors
• Imported data into the company SAS data warehouse
• Wrote common macros that are used across multiple applications
• Generated reports in HTML, PDF or RTF formats according to business specifications
• Created ad-hoc reports and tables for information delivery and data management departments
• Worked closely with the development teams to replicate end user issues.

Environment: SAS/Base, SAS Enterprise Guide, SAS /Macros, SAS/SQL, SAS/Access, Oracle, DB2, Windows 2000, MS Access, and Unix Sun Solaris (Korn Shell).