SUMMARY

• SAS Professional with 7 years of hands on experience in IT industry with extensive experience as a SAS Programmer/Analyst in Financial, Pharmaceutical, and Insurance sector.
• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide 4.1/4.2
• Proficient in SAS v 8.2/9.1.3/9.2 , SAS/BASE, SAS/MACROS, SAS/Connect, SAS/SQL, SAS/Access (Oracle/Teradata) and SAS/ODS.
• Proficient in Debugging, Documenting, Validating, and Optimizing SAS programs for QC and QA.
• Extensive Experience in arranging and participating in meetings with Business Users and suggesting recommendations for improving system performance.
• Proven skills in data cleansing, data archival, data migration, ad - hoc reporting, and coding using SAS on various environments.
• Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS word, MS PowerPoint, MS Excel.
• Strong ability to write SQL queries usingPROC SQL and thorough knowledge of SQL in Oracle platform.
• Experience in various data Extraction, Transformation and Loading (ETL) techniques.
• Familiar with the concepts of OLAP and Stored Procedures.
• Excellent communication and interpersonal skills and Experience in creating Ad hoc report for team meeting.
• Proven abilities in establishing effective task priorities as a team player with result oriented attitude.
• Extremely energetic, detail oriented, organized, self-starter with the ability to work independently and excellent team player with strong analytical abilities, communication skills, interpersonal skills, and problem solving skills.
• Possess strong ability to quickly adapt to new applications, platforms and languages and ability to handle multiple tasks simultaneously.

TECHNICAL SKILLS

Statistical Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS.

Database: Oracle, MS-SQL Server 2000, MS Access.

Operating Systems: MS Windows (95, 98, 2000, NT, XP, windows7), MS-DOS.

Languages: SQL, PL-SQL

Development Tools: MS Office (Word, Excel, Power Point, Access).

PROFESSIONAL EXPERIENCE

Confidential, OH

SAS BI Developer

Responsibilities:

• Created Global Market View SAS Datamart and designed star schema for efficient querying and reporting.
• Automated the Monthly, Quarterly and Half yearly Production process using shell scripts and setup cron jobs to schedule them on the UNIX box.
• Experience working with different kinds of data like Dun and Bradstreet and Harte Hanks to do analysis on customers and identifying new opportunities.
• Analyzed different internal data like Campaign, Opportunity and supported adhoc request from business.
• Regularly involved in Data preparation, Data manipulations and formatting to support the statisticians with their models.
• Regularly used SQL Pass thro, libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata.
• Created Stored Processes for the business to generate different adhoc reports based on the parameters passed.
• Have experience creating information maps which would be utilized by web report studio to generate static reports.
• Built reports using Web Report Studio and Information Delivery Portal.
• Automated Reports using SAS Add-in for Microsoft Office.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/Access (Oracle / Teradata), SAS/Connect, Stored Process, SAS/Information Map Studio, SAS/Web Report Studio, SAS Add-in for MS Office, SAS/STAT, SAS/EG, Excel, UNIX (HP-UX), Windows

Confidential, FL

SAS Consultant

Responsibilities:

• Worked with Business team to analyze and understand the changes involved for the new business needs.
• Analyzed the oracle data warehouse to design the ETL process and implement the business logic required using Data Integration Studio.
• Hands on experience working on health care data including revenue, membership, claims and cost of health care data.
• Built automated process to pull data from Oracle and load the resulting Flat files into Access and SQL Server.
• Responsible for running of productionalized programs on monthly, quarterly basis.
• Extensively used SQL Pass thro for pulling data from Oracle and SQL Server
• Designed and developed code using SAS/EG.
• Built Cubes using OLAP cube studio which were utilized in Web Report Studio and Information Delivery Portal.
• Hands on experience in using Enterprise Guide for building Stored Process.
• Automated reports using SAS Add in for Microsoft Office.
• Extensively used Humming bird for FTP purposes.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS/STAT, SAS Enterprise Guide, SAS DI Studio 4.2, SAS OLAP Cube Studio, Web Report Studio, Information Delivery Portal, Excel, UNIX (SOLARIS), Windows, Oracle, SQL Server, SAS/Access Oracle, Humming Bird Exceed

Confidential, Nashville, TN

SAS Programmer/ Analyst

Responsibilities:

• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Write the SAS code and run those data sets to produce necessary financial reports by using SAS/STAT Procedures such as PROC Freq, PROC Tabulate, ProcUnivariate, and PROC ANOVA.
• Used of SQL server, SQL access, SQLPLUS, TOAD and PL/SQL to solve complex database problems as well tuning purpose
• Involved in maintaining and tuning existing JCL scripts
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.
• Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.
• Analyzed the data using SAS/STAT procedures PROC FREQ, PROC MEANS, PROC SUMMARY
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Design of ETL process to meet the requirement of data demand.
• Developed and maintained the Crontab Entries for scheduling the daily, weekly, monthly, quarterly as well as yearly jobs
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose.
• In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel, TOAD, MS Access

Confidential, CA

SAS Programmer

Responsibilities:

• Creating and joining huge table for purpose of analysis of the data which is extracted from the Oracle database. Involved in taking regular backups.
• Created specifications for validation to ensure transfer of clean and quality controlled data to the clients.
• Worked closely with Sales Operation manager.
• Analyzed the sales data, future trends and summarized results to generate meaningful recommendations for management.
• Extensive use of Proc SQL to perform queries and to join tables.
• Built complex data marts and queried them for strategic reporting and analysis.
• Designed and delivered on-going and back-end reporting for analysis.
• Supported ad hoc data queries from brand team.
• Built Stored Process using EG to generate Excel reports.
• Responsible for running of productionalized programs on the weekly, monthly and quarterly reports.
• Used procedures like Proc Means, Proc Freq and Proc datasets to run metrics on different datasets.
• Designed and developed code with SAS/EG to support ad hoc requests.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/EG, Excel, UNIX (SOLARIS), Windows