SUMMARY:

• Certified BASE SAS Programmer with around 6 years of experience in working with SAS and SAS tools emphasizing on analysis, design, developing, testing and implementation of various projects for Banking (Credit card Risk Management and Marketing campaign) and health care industries on windows and Unix environment.
• Extensive experience in creating User interactive reports using VBA, Pivot charts, Excel macros, vlookup and Excel charts.
• Experience of creating automated dashboards using MS Excel and SAS.
• Experience of importing data from external data sources. Using the data to create dynamic reports.
• Extensive experience in BASE SAS, SAS/GRAPH, SAS/SQL, SAS MACROS, SAS/ACCESS, SAS PC (V8, V9), SAS ODS, SAS Enterprise Guide, SAS PM.
• Experience with Data warehousing concepts like Star Schema, Snowflake schema, data slicing and dicing, Dimension table and fact tables.
• Thorough knowledge in Statistical Analysis and data analysis.
• Experienced in Base SAS procedures such as PROC FREQ, MEANS, SUMMARY, UNIVARIATE, FORMAT, IMPORT, EXPORT, REPORT, TABULATE, TRANSPOSE, DATASETS, COMPONENTS, APPEND, COPY and PRINT.
• Experience with SAS Enterprise Guide for creating various programs and stored processes using code and GUI for process flow.
• Technical expertise in implementing Output Delivery System (ODS) to create customized outputs like HTML, RTF and PDF. Creating charts (horizontal/vertical bar charts, block charts, 2 - D/3-D pie charts, donut charts, star charts) using Chart and GChart procedure in SAS/Graph to graphically represents the data.
• Experience with Credit Risk with credit cards
• Knowledge of logistic regression and segmentation.
• Experience of maintenance of PD (profitability of default), EAD (Exposure at default) and LGD model (Loss given default).
• Experience with OCC reporting, Moody’s Microeconomic data and FICO scores.
• Extensive experience in Sales and Marketing data analysis: creating tables, listing and generating reports and graphs.
• Skilled in using SAS to read, write, import and export to another data file formats, including delimited files, Spreadsheet, Microsoft Excel and access tables.
• Worked with Sales Force Directors to provide SAS programming in analyzing the data, generated reports, tables, listings and graphs.
• Expertise in requirement analysis, business modeling, data modeling and system testing.
• Excellent knowledge of SQL and proficient in working with various database platforms.
• Extensive experience with concatenating, interleaving, and merging SAS datasets.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Excellent documentation skills for documenting all tasks and processes, creating user guides, training manuals.
• Possess strong ability to quickly adapt to new applications and platforms.

TECHNICAL SKILLS:

Tools: SAS BASE, SAS Enterprise Guise, MS Excel, MS Visio, MS PowerPoint, TOAD, MS Word, HTML, Remedy, Teradata SQL Assistant, SQL navigator for Oracle, Exceed.

Databases: Oracle 10g, Teradata, SQL Server, MS Access, MS Excel, SPDS

IDE: SAS Base 9.1/9.2, Microsoft Visual Studio.

Languages: SAS, SQL, UNIX, Visual Basic Application (VBA).

Platforms/OS: MS-Windows NT/2003/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Database Analyst

Confidential, San Francisco, CA

• Worked with Data Prep team of Small business marketing for creating the data for various Marketing campaigns.IT also involves auditing of data.
• Handling various Weekly and monthly production jobs.
• Data manipulation and validation using MS Excel.
• Experience with the rescrub process and created jobs (sas code) for rescrubbing data.
• Created Unix script for SAS jobs automation and parallel run.
• Reduced the time of Job running by half using Unix scripting with SAS.
• Used Base SAS, SAS macros, PROC Logistic, PROC test for creating excel based reports.

Reporting for Credit Risk Analysis

Confidential, Concord, CA

• Working with Credit Risk Analysis group to create reports for the risk analysis. This involves monthly and quarterly reports.
• Creating production data for PD, EAD and LGD model.
• Ensure that the models meet the specifications as per the internal modeling standards and regulatory requirement.
• Conduct data validation, initiate and provide guidance in conducting data fixes.
• Creating SAS code for PD, EAD and LGD model production data.
• Created excel and html based reports.
• Handled large data. Model involved data for last 8 years of credit card data.
• Used Base SAS, SAS macros, PROC Logistic, PROC test for creating excel based reports.
• Working on KS,Gini, Population stability Index and character analysis for the OCC.
• Automated the reports using Excel VBA. Worked on Excel graphs. Created automatic graphs
• In excel. These reports automatically pull the data from mounted UNIX drive. No manual intervention is required.
• Created reports in HTML and PDF formats using SAS Output delivery system.

Environment: Windows XP, UNIX, BASE SAS, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle, VBA, Microsoft Office.

Confidential, Indianapolis, IN

Project Lead/Module Lead

• Worked with Salesforce Operations group to analyze and create the activity dashboards and monthly reports for the sales force activity.
• Worked on star schema, snowflake schema. Created schema objects (tables, views, indexes, triggers, etc.)
• Interacted with Business users (sales force directors, area managers) from different Sales forces to analyze the requirement.
• Involved in creating the various matrices for analyzing the performance of Sales forces.
• Conducted technical feasibility study and prepared the mock dashboards for end users approval.
• Analyzed various sources for the required data, pulling data from different sources using SQL.
• Developed SAS codes for various matrices calculation, used SAS data step merge, proc sort, proc summary, Proc SQL, SAS macros for creating these Dashboards.
• Handled large volume of data around 5 million records for creating monthly Rx reports at one time.
• Provided quick Ad hoc requests as per customer’s requirement using Proc SQL, IMS data, SAS Macros, VBA.
• Created complex and reusable SAS macros to create tables, listings and graphs for submissions to higher management. Extensively used existing MACROS and developed SAS programs for data cleaning, validation, analysis and report generation. Tested and debugged existing macros using system options.
• Created permanent formatted SAS data sets and used SAS/BASE and its tools for pre-processing data, data analysis and statistical analysis.
• Worked as mentor/SME throughout the project for requirement creation/editing and document. Interacted and effectively communicated with project managers team members to understand and create business requirements and then converted requirements into technical specifications.
• Helped create traceability links between requirements of different requirement types based on the Requirements Management plan, assuring consistency with other projects.
• Created reports in various output forms like HTML, PDF using SAS ODS and SAS EG.

Environment: Windows, SAS Base 9.1/9.2, SAS/SQL, SAS Enterprise Guide, SAS Macros, MYSQL, MS Excel, MS Word, MS Visio, MS PowerPoint, Remedy, VBA, HTML, and Toad.

Market Research and Analysis

Confidential, Indianapolis, IN

• Worked with market research and analysis team to get the customer segmentation and targeting done for various products and markets.
• Created list reports, graphs and data sets using SAS, SAS EG, and SAS PM.
• Pulled data from various different sources like Oracle, Excel, Access, and DB2 to analyze the data and produce the reports.
• Merged different data sets using one-one and match merging. Used logical variables like first and last to find and eliminate duplicate observations.
• Utilized statistical procedures like Freq, Report, SQL and Transpose to generate tables, listings and VBA for summarizing data reports and ad-hoc trend reports.
• Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel. Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Maintained large data sets, combined data from various sources in varying formats using set and merge.
• Prepared new datasets from raw data files using import techniques and modified existing datasets using sort, update, formats, functions and conditional statements.
• 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.

Environment: Windows XP, BASE SAS, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle, DB2, SAS Enterprise Guide, SAS PM, VBA, Remedy.