SUMMARY

• Over 8 years of Experience in Base SAS, SAS/Macros, SAS/SQL, SAS/STAT, SAS/Access, SAS/GRAPH, SAS/ETS and SAS/ODS.
• Good understanding of various statistical concepts such as T - 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, 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 and Teradata.
• 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, Teradata, DB2.

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SAS Analyst /Developer

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.
• Communicating the day-to-day results to senior managers.

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, Minneapolis, MN

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
• Analyzed Medicare, Medicaid and AARP transactions to identify purchasing patterns for secondary insurance
• Extensively used various SAS/STAT procedures such as Proc Univariate, Proc t-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, CA

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.
• Gained extensive knowledge on CISCO's various internal transactional systems
• Read and transfer 90 million worth of customer records in Duns & Bradstreet.
• 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 CISCO customers and Duns & Bradstreet data 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 CISCO and competitors in the market
• Extensively used SAS/ STAT to conduct linear, logistic regression analysis on Cisco's internal bookings data to address the question, whether a consumer will buy a Cisco product or not based on significant variables
• Used various Pivot Tables, VLOOKUP, and HLOOKUP features of Excel to support internal report requirements.
• 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, 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 &T 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.
• 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 &T partnership business accounts (CAT, Fedex, UPS, 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, 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.