SUMMARY

• 8 years of experience as a Senior SAS Programmer and data analysis using BASE SAS, SAS ENTERPRISE/MINERBI/Data Integration Studio, and SAS EBI, PM software.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL Pass - Through facility. Expert level SAS Advanced programming experience in various environments like PC/SAS, Unix and Mainframes.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/EG, SAS/Share, SAS Enterprise BI Server, SAS Management Console.
• Core ddevelopment experience in creating user interface applications using SAS/AF and SCL on Mainframe/Windows environments.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS Olap Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Expertise on optimization by writing SQL queries using SAS/SQL.
• Having knowledge of data warehousing, tables and structure.
• Having extensive domain knowledge and experience in the diversified fields of Banking, Healthcare, Insurance, Airlines, Manufacturing and other financial service Sectors.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Strong analytical, communication and organizational skills with the ability to analyze business practices and define and document optimal procedures or practices.
• Extensively worked on various RDBMS like Oracle, MS - Access, Teradata, DB2 and SQL Server.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in data manipulation and data cleansing by using procedures such as Proc data sets, Proc sort, Proc transpose etc
• Working on handling clients Key Enhancement Work Requests by following SDLC process.
• Achieving customer satisfaction by ensuring service quality norms and build the company image by exceeding customer expectations.
• Documenting the data in the appropriate way by following quality standards for future use and reference.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts to analyze survey data for generating Tables, Listing Outputs and Customized Graphs.
• Extensive experience in leading the team (Onsite and Offshore).

TECHNICAL SKILLS

SAS Tools: Base SAS 9/8.2/8.1, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS/AF, SAS/Connect, SAS/Intranet and SAS Business Intelligence (BI) platform.

Reporting Tools: Base SAS versions 9/8/6, MS-EXCEL, SAS BI Platform, MS-VISIO, MS-PowerPoint.

RDBMS: DB2, Oracle, Terradata and MS-Access

Languages: SAS, JCL, SQL and FOCUS.

Scripting: Shell, Perl and HTML.

Operating System: Mainframe, UNIX, Windows 95/98/XP/Vista/Win 7, MAC OS, DOS.

Web Server: MS-FrontPage and HTML

Other Tools: PVCS, Clrar Case, VSS, SPUFI, TSO, MS-OFFICE, JOBTRAC, Autosys, UC4, Ultraedit and FILEMASTER for DB2.

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

SAS Analyst

Responsibilities:

• Designed and developed code using SAS/EG for various Reports.
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create reports as per the business requirements.
• Developed SAS macros to simplify SAS code and efficiently reduced coding time.
• Used PROC report and various procedures to build the desired reports. Monitored SAS EBI Platform and resolved systemic issues.
• Prepared mapping frame work and detail design documentation.
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Extensively used PROC SQL and SELECT sub-queries to generate various reports by connecting to the Oracle DB.
• Initially created tables and views in Oracle and used a BI/Query model for local users to access the data tables and reports.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Prepared/Review Unit & System Test cases for the new development and enhancement requests.
• Proving support for the production issues.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements.
• Used SAS GRAPH for generating various graphs and charts for analyzing the data.

Environment: SAS/BASE, SAS/MACROS, PROC SQL, SAS Enterprise Guide, Information Delivery Portal, Information Map Studio, MS Excel, UNIX (SOLARIS), Putty, Windows, SAS/Access Oracle, Teradata

Confidential, Cary, NC

SAS BI Developer

Responsibilities:

• Created Global Market View SAS Datamart and designed star schema for efficient querying and reporting.
• Integrating raw data from various sources to test inputs files required for modeling portfolio performance by designing, developing and maintaining new SAS based processes.
• Regularly used libname Statements and PROC SQL to interact with different RDBMS like Oracle, Teradata.
• Created Stored Processes for the business to generate different ad hoc reports based on the parameters passed.
• SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.
• Customizing and enhancing the existing ETL process.
• Developing metric checks for various source system files to analyze monthly and quarterly data trends using Proc SQL and SAS/STAT procedures.
• Supporting development and production teams by identifying and reporting data quality issues for achieving error less results.
• Fine tuning and performing code enhancements to reduce run time and improve efficiency.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• 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, SAS/Information Map Studio, SAS/Web Report Studio, SAS Add-in for MS Office, SAS/STAT, SAS/EG, Excel, UNIX (HP-UX)

Confidential, Eden Prairie, MN

SAS BI Developer

Responsibilities:

• Created customized reports to help client provide in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Worked as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Primarily focused on analyzing and documenting business requirements.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems and used SQL Assistant to analyze and query from the Teradata DB.
• Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Constructed SAS programs on UNIX platform to clean the data according to the specifications.
• Generated Information Maps using Information Map Studio and created Ad-Hoc reports on need basis using SAS Web Report Studio.
• Coordinated with vital departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats such as HTML, Tagsets, PDF, WORD based on the user group requirement with SAS/ODS.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data fromoracle tables.
• Involved in producing analysis data sets by viewing metadata from SDTM and ADAM data sets.
• Developed various backend SAS application programs, such as Proc import, export, Functions, Triggers, Procedures and Packages using SAS and SQL language for the top management for decision making.
• Implemented all modules logic by using Triggers in a macro program.
• Extensively used Base SAS- ETL to load data from SQL server, oracle, Flat files and sources to Oracle Data warehouse as target.
• Worked on Source and Target Metadata creation and developed many jobs to load data from source into target
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy and Lookup (Connected and Unconnected) to load the data.
• Extensively involved in designing and developing of Star Schema Model for Data Store.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, Unix, Oracle DB2, MS SQL Server 2000, Windows XP, MVS, JCL, Cobol, and Mainframe.

Confidential, Charlotte, NC

SAS Developer

Responsibilities:

• Gathered functional and technical requirements by contacting end users.
• Analysis of the Enhancement & Maintenance Requests.
• Prepared the Phase0 estimations.
• Prepared Design documentation.
• Offshore team co-ordination and coding SAS programs.
• Used SAS Macros, PROC SQL to extract, sort match test accounts and ODS to HTML, PDF and RTF.
• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Prepared Unit & System Test cases.
• Testing & Bug fixing.
• Running Weekly & Monthly jobs to generate reports for end users.
• Working enhancements on Unix shell scrits and Oracle queries.

Environment: SAS 9.1.3, SQL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, MS EXCEL MS ACCESS

Confidential, Pleasanton, 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).