SUMMARY:

• Over 10 years of experience as SAS Programmer and Analyst with Market/Risk Analysis, Financial Analysis and Health Care Data Analysis.
• Proven skills in Data Mining Techniques such as Cluster Analysis, Market Basket Analysis.
• Experience with Financial Models, Forecasting, Projections, and Decision Support
• Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS and SAS/ODS, SAS/Enterprise Guide.
• Experience in using Unix for automation of SAS Programs.
• Good understanding of various statistical concepts such as Confidential - Test, Correlation and Regression Analysis.
• Strong expertise in SAS Base procedures, reporting and summary procedures.
• Experience with PROC SQL, SAS DDE and SAS Arrays.
• Expertise in using Visual Basic for Application VBA in MS-Excel for Data manipulation.
• Expert with Microsoft Excel (Vlookup, h-lookup, pivot tables, etc.)
• Knowledge in marketing models such as Up-Sell, Cross-Sell and Retention/Acquisition models in Banking/Financial and Marketing Domains to increase the response rate for campaigns
• Experience in updating CRM and MIS reporting systems in finance and marketing departments.
• Knowledge in data warehousing and business intelligence concepts, and design principles. Experience in RDBMS development including SQL, PL/SQL, and languages.
• Good understanding of Health care terminology such as Medicare, Medicaid, HIPPA, CPT, DRG and HCPAC.
• Experience in using Import and Export procedures to handle data in raw data files ORACLE, DB2, PEOPLE SOFT and Teradata.
• Familiarity with HR Management, systems and operations (People Soft).
• Quick learner with ability to understand job requirements, employ new ideas, concepts, methods, and technologies
• Strong analytical, diagnostic skills and ability to work in a fast-paced and team-oriented environment.

TECHNICAL SKILLS:

Statistical Software: SAS/Base SAS, SAS/SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ETS, SAS/EG, SAS/IMS, SYSTAT, SPLUS, SPSS, SAS EMINER.

Reporting Tools: MS Excel (VBA Macros, Pivot table, Vlookup, HLookUp)

Databases: Oracle, MySQL, MS-Access, People Soft, Teradata, DB2.

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

SAS Programmer/ Analyst/ Data Consultant

Responsibilities:

• Analyze Confidential /TPMG physicians Retirement/Benefit Plan data from Fidelity (Pension Plan/ Benefits administrators).
• Compile the data from different data sources into a meaning full data system for reporting purpose.
• Develop program to check if all the business rules are applied correctly for physician benefit plan selection.
• Develop program to generate easy to read reports and audits for actionable results.
• Write and automate program to generate reports on the inconsistency of data in the vendor system (Fidelity).
• Write program as needed to audit the payment info of retirees to check the compliance with the benefit plan selection.
• Work directly with internal business owners to develop data validation audits and documentation.
• Educate business owners about data inconsistencies that were discovered, and generated reports with examples and description to discuss with the vendor (Fidelity).
• As a SAS Programmer use SAS Macros and SAS ODS to generate both Excel and HTML reports for higher end management.
• Automate all the existing programs and audit report generating programs to run with minimal manual intervention.
• Ensure the accuracy of reports using SAS reporting procedures and VBA tools.
• Query databases (Oracle 11g) on on-going and ad-hoc basis.
• Utilize Toad 12.6 (latest version) to access Oracle DB.
• Currently utilize SAS Base 9.2 and SAS EG 4.3.
• Create input data sets by using SAS Enterprise Guide, SAS/Base and SAS/ACCESS facility for report generation by accessing Oracle.
• Used UNIX for automation of SAS Programs to generate data for analysis and reports.
• Use SAS/Base procedures and functions for data cleaning, validation and data quality checks.
• Familiarity with HR Management, systems and operations (People Soft).
• Understand and document in house SAS optimization program and generate reports as per schedule.

Confidential, Atlanta, GA

SAS Programmer/ Analyst

Responsibilities:

• Ensure the accuracy of reports using SAS reporting procedures and VBA tools.
• Query databases (ECDW/Teradata and Kronos/Oracle) on on-going and ad-hoc basis.
• Automation of Data Extraction, Transformation and Loading the results to final datasets using Oracle, SAS and SQL.
• Utilize Toad 11.5 (latest version) to access Kronos/Oracle DB.
• Utilize DSPSAS01 ( Confidential & Confidential UNIX/Solaris system); Familiar with using UNIX commands and the crontab process for scheduling queries/jobs/processes.
• Currently utilize SAS Base 9.3 and SAS EG 5.1.
• Currently utilize Teradata SQL Assistant v 13.10 for SQL Queries.
• Generate Reports, Summary tables, Charts and Graphs for different users using SAS/ASSIST.
• Create input data sets by using SAS Enterprise Guide, SAS/Base and SAS/ACCESS facility for report generation by accessing Teradata.
• Built and maintained monthly and weekly reports for executive management.
• Used UNIX for automation of SAS Programs to generate data for analysis and reports.
• Assisted in development of multiple versions of a report (Pdf, HTML) using SAS/MACROS.
• Created and maintained daily reports on Connected Car (Audi, GM - OnStar, Tesla, Ford, and Volvo).
• Created Ad-hoc reports about sales and activations Confidential the time of iPhone 6 and iPad Air 2 launch for executive management using SAS and Oracle OBIEE.
• Created reports for other Confidential & Confidential partnership business accounts (CAT, Fedex, UPS, and USPS).
• Responsible for maintaining accuracy of data feed to TEOCO.
• Use SAS/Base procedures and functions for data cleaning, validation and data quality checks.
• Conduct ad-hoc statistical tests and create reports using SAS/STAT procedures such as Proc Univariate, Proc ttest and Proc Anova.
• Create reports for business development using SAS reporting procedures such as Proc Report, Proc Tabulate, Proc Summary and Proc SQL.
• Familiarity with wireless technologies, systems and operations (GSM, 3G, & LTE).
• Understand and document in house SAS optimization program and generate reports as per schedule.
• Interact with field teams to understand business process and make recommendations on model enhancements.
• Report to management on model performance and reporting.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS V9.3, SAS Enterprise Guide, Enterprise Miner, Excel, Oracle, MySQL, MS-Access, Teradata, OBIEE, UNIX.

Confidential, Gouverneur, NY

SAS Programmer/ Analyst

Responsibilities:

• Extracted data from oracle database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Developed algorithms to identify void transactions pharmacy data sets and eliminate them from analysis.
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.
• Studied purchasing patterns of medications by long term care facilities by store.
• Analyzed the similarities and differences among various heath conditions such as Alzheimer’s, Bipolar disorder, diabetes and Oncology.
• Extensively used sas report procedures such as Proc REPORT, Proc TABULATE, Proc TEMPLATE, and Proc SQL to create store wise reports.
• Extensively used SAS/ODS to create html and pdf reports.
• Used Unix for automation of SAS Programs for generating reports.
• Analyzed Medicare, Medicaid and AARP transactions to identify purchasing patterns for secondary insurance.
• Extensively used various SAS/STAT procedures such as Proc Univariate, Proc Confidential -test and Proc F-test for data validation and statistical analysis.
• Supported procurement teams by forecasting demand for various drugs in six months and one year.
• Implemented efficiency techniques for optimal performance of the code.
• Involved in debugging, documentation of codes used in production.
• Participated in various team meetings and interacted various teams during requirements gathering and results delivery.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS ODS, SAS/GRAPH, SAS/IML, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, SAS Enterprise Guide, Enterprise Miner, Excel, Windows XP, UNIX.

Confidential, Atlanta, GA

SAS Data Analyst

Responsibilities:

• Extract, transform and load data from Teradata, excel sheets, flat files, etc. using SQL, fast export utility and proc import into sas datasets.
• Extensively used various SAS Data manipulation techniques to validate, cleanse and conduct for monthly trend analysis.
• Perform summary statistics on data before extracting from Teradata.
• Used various statistical procedures such as cluster analysis, Market basket analysis to discover the most profitable product combinations for reducing mass mailing costs.
• Conducted data mining on Confidential customers data and analyze potential prospects in acquiring new customers and for cross-sell and up-sell opportunities.
• Extensively used various Base SAS, SAS/STAT, SAS/Graph and Excel to analyze market growth, trends, ROI, wallet share of Confidential and competitors in the market.
• Extensively used SAS/ STAT to conduct linear, logistic regression analysis on Confidential 's internal bookings data to address the question, whether a consumer will buy a Confidential product or not based on significant variables.
• Used various Pivot Tables, VLOOKUP, and HLOOKUP features of Excel to support internal report requirements.
• Used Unix for automation of SAS Programs to generate reports for executive management.
• Assisted in automation of projects on monthly basis and basic sas admin responsibilities

Environment: SAS 9.x (BASE, GRAPH, MACRO), Oracle 9i, Teradata, PL/SQL, UNIX, MS Excel.

Confidential, TX

SAS/ Statistical Analyst

Responsibilities:

• Involved in designing processes in SAS and VBA for new business units.
• Analyzed and build Risk-Metrics using SAS/IML and SAS/ETS and Base SAS.
• Implemented Monte-Carlo simulation techniques for Risk-Metrics using SAS/IML.
• Integration / synchronization of daily P&L reports with financial forecasts.
• Reviewed existing reporting outputs to validate current deliverables prior to publication.
• Ensured the accuracy and timeliness of daily PnL and position reports using SAS reporting procedures and VBA tools.
• Automation of Data Extraction, Transformation and Loading the results to final datasets using Oracle, SAS and SQL.
• Generated Reports, Summary tables, Charts and Graphs for different users using SAS/ASSIST.
• Used advanced techniques to reduce the execution of processes times in SAS and MP-Connect, SAS/Access.
• Conducted data validation using SAS Enterprise Guide
• Summarized the results and data with PROCs FREQ and MEANS.
• Performed Statistical Analysis with statistical procedures and univariate procedures from Base SAS, SAS/STAT and SAS/IML.
• Created Reports with PROC REPORT and ODS.
• Scheduling day-to-day and weekly processes of reports using Windows Scheduler.
• Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks.
• Worked with both windows and UNIX environments.

Environment: Base SAS, SAS Macros, SAS/Access, SAS/Assist, SAS/STAT, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, SAS/IML, ORACLE, SAS V9.1.3, SAS Indexes, SAS Views, SAS MP-Connect, SAS Enterprise Guide, Enterprise Miner, Excel, Windows XP, UNIX.

Confidential, KS

SAS programmer Analyst

Responsibilities:

• Performed ETL-Extraction/Transformation/Loading on DB2, Oracle and other flat files using SAS/Access, Proc SQL procedures, Proc Import etc.
• Worked with large tables consisting of huge volume of data and write complex queries to join/extract data from source data.
• Involved in developing codes, production support activities, generating reports, code reviews.
• Developed SAS based applications for measuring financial performance of newly acquired accounts: Forecast vs. Actual.
• Implemented Credit Risk Analysis reporting system based on Fico Scores
• Wrote programs in SAS generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Ran Monte Carlo simulations to calculate quarterly capital requirements for Citizen’s operational risk component
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports.
• Responsible for maintenance and enhancements work in reporting system using SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph.
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.
• Developed Macros in Shell Scripts for Data Management, Submitting batch jobs and Performing FTP

Environment: SAS/BASE, SAS/Macro, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, Oracle 9i, PL/SQL, DB2, UNIX, MS EXCEL, MS ACCESS

Confidential, NY

SAS Programmer/Statistical Analyst

Responsibilities:

• Used SAS/BASE, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
• Extracted data from Oracle, using SQL pass through facility of SAS/ ACCESS, for further analysis.
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation
• Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Developed and maintained standardized SAS programs and Macros for regulatory submission reports.
• Used SAS/ETL to create reports from relational database or multi-dimensional cubes.
• Created new programs and modified existing programs in the data warehouse.
• Created state wise and regional wise reports using analysis output and export them to web enabled format.
• Prepared flowcharts indicating the input data sets, sorting and merging techniques and wrote SAS code accordingly.
• Used shape files to create spatial maps for the reports using SAS

Environment: SAS V 9.1.3 (Base, Macros, SQL), SAS/ETL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, ArcGIS, Oracle 9i, PL/SQL, Windows XP.

Confidential

Computer Programmer Analyst

Responsibilities:

• Designed the data migration plan with no downtime, which involved migrating data from Oracle and MySQL (about 25 million photos, 5 million albums) to a single Oracle database.
• Managed a remote team building a new photo uploader, to upload multiple photos Confidential once.
• Increased average photo uploads by 3 times.
• Mentored the team in data and file migration, performance analysis, design and coding.
• Used JMagick and ImageMagick for processing images.

Environment: VBA for Excel, ORACLE, TOAD, PL/SQL, Java, C, C++, Weblogic, Perl, EJB, Javascript, JDK Applets, JDBC-ODBC, MS Office and Excel.