SUMMARY

• Expert in Data Analysis by running PL/SQL Queries to validate databases.
• Extensive experience in Data manipulation with large records using Base SAS, SAS/EG, SAS/SQL, SAS MACROS.
• Hands on experience with analysis of Claims Data, Membership Data, and Sales Rep data in healthcare industries.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development, Implement, Validation and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support.
• Hands on experience in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility.
• Good understanding of Data Warehouse concepts including Star Schema and Snow - Flake Schema
• Extensive experience in working on different SAS versions like (8.2, 9.1, 9.2) using SAS/BASE, SAS/STAT, SAS Enterprise Miner SAS/ACCESS, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQL.
• Experience includes in SAS Report Generating Procedures like PROC REPORT, PROC SQL, PROC TABULATE, PROC TRANSPOSE, and PROC PRINT.
• Extensively well versed with statistical procedures like PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC ANOVA, PROC REG, PROC CORR.
• Created new SAS datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and other conditional statements.
• Extensive use of detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing, macro facility, and storing and managing data in SAS data files.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL process.
• Hands on experience working with SAS/BI-OLTP, OLAP Cube Studio. SAS Management Console, SAS Information Map Studio, SAS DI Studio, SAS Stored Processes, SAS.
• Used SAS Enterprise miner to create highly accurate predictive and descriptive models based on large volumes of data from across the enterprise.
• Documented methodology, data reports and model results and communicated with the Project Team Manager to share the knowledge.

TECHNICAL SKILLS: -

Operating Systems: Windows 98/2000/NT/XP, MS-DOS, UNIX, Mainframe

Languages: C/ C++, SAS, PL/SQL, HTML, KSH, XML

Database: Sybase IQ, DB2, Teradata, Oracle, MS-Access, SQL Server 2000/7.0/6.5, MS-Excel, MS-Access.

Tools: WinSQL, PVCS, MS Sql Server Management Studio, Reflection X, EMS Word, MS Excel, MS Power Point, MS Project, MS Visio, MS Outlook, SQL Visio integration, KEA X, Putty, Sybase Power Designer Viewer, and IPSwitch.

SAS Skills: SAS/EBI, SAS/BASE - MACRO/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS ENTERPRISE GUIDE

PROFESSIONAL EXPERIENCE: -

Confidential, Boston, MA

Sr. SAS Programmer

Roles & Responsibilities:

• Involved in the data transfer and data conversion from one platform to the other (SAS to Oracle, Oracle to Excel) and the obtained data was used for further analysis.
• Involved in pulling data from Oracle and DB2 databases, carefully choosing source tables and deciding upon target tables to be created in local environment.
• Responsible for data validation and corrections; uploading/downloading data from/to a PC.
• Conducting studies and surveys to summarize and analyze complex financial actions and prepare recommendations for policy, procedure, control, or action.
• Created permanent formatted SAS data sets and developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis. Wrote Edit check programs and listings of data.
• SAS was used for pre-processing data, data analysis, generating reports, graphs and statistical analysis for making financial decisions.
• Involved in testing and debugging against the test data using PL/SQL.
• Developed and executed SAS programs on a daily and ad-hoc basis using SAS/MACRO, SAS/BASE and SAS/SQL.
• Ran weekly and monthly reports using SAS.
• Created SAS views from tables in Oracle database using SAS/ACCESS.

Environment: SAS/BASE, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, PL/SQL, PROC SQL, Microsoft Access, Sql Server 2008, Toad, MS Visio, WinSQL, SQL Studio, PVCS, MS Sql Server Management Studio, Oracle 8i, UNIX, Windows NT/2000

Confidential, Atlanta, GA

Sr. SAS programmer/Business analyst

Roles & Responsibilities:

• Responsible for managing a small team of 4-5 SAS developers, creating ETL design document and presenting them to architectural review meeting and teem review meeting.
• Updated existing process flows and ETL design to be in compliance with the current standards.
• Performed extraction, transformation and loading of large Oracle tables.
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Pulled data from SAS into Excel using VBA.
• Created customized reports using VBA and DDE.
• Recorded VBA macro in an Excel workbook, and then executed it by SAS application using DDE.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Generated highly customized reports using SAS macro facility, PROC Report, PROC Tabulate, and PROC SQL.
• Used different input styles to read the TXT, CSV and XML files to read into SAS create SAS datasets and wrote complex SQL to join SAS datasets and Oracle tables.
• Used Sybase Power Designer & Viewer to look at the data models and schemas.
• Analyzed various tables using Data manipulation techniques like merging, appending and sorting.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE and macros in SAS.
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
• Generated Ad-Hoc queries/reports and other activities like OLAP, Forecasting (Time Series) and Analysis as requested and used the SAS OLAP Cube Studio for creating Cubes.
• Transferred and Migrated Data from one platform to another to be used for further analysis.
• Developed, analyzed and designed SAS programs in UNIX platform.
• Wrote Korn-Shell scripts for back up and running batch files and perform quality assurance and validation on the transported data and reports.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Wrote complex SAS, SQL and Korn Shell script to manipulate data as per business rules, upload in to the warehouse tables and create reports.
• Worked with large data sets (15+ million records) using Pass Thru SQL technique.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting data between SAS and SQL. Conducted meeting with business users and data architects to define metadata for tables to perform ETL process.

Environment: SAS 9.2, SAS/BI, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS/IMP, SAS Enterprise Guide, SAS/MACRO, SAS/WEB Report Studio, SAS/XML Mapper, Oracle 9i, Sybase IQ, Sybase Power Designer and Viewer, Microsoft Excel, VBA, Microsoft Access, Sql Server 2008, PL/SQL, Windows XP, UNIX, DB Visualizer, Toad, MS Visio.

Confidential, Hartford, CT

Sr. SAS Developer

Roles and Responsibilities:

• Actively involved in designing and writing technical specifications for ETL processes and BI reports.
• Responsible for designing and developing of end to end technical process flow.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Extensively used Korn-Shell scripts to kick off SAS jobs and ftp flat-files to data staging areas and ETL process.
• Involved in data modeling, creates conceptual model for physical and logical tables and conducts complete impact analysis. Used Erwin tool to set up data marts and parent child relationship and metadata. Generated reports and FTP to On-demand landing areas. Extensively involved in various phases of unit testing and production support.
• Used SAS Enterprise miner to access and integrate structured and unstructured data sources.
• Also created Univariate and bivariate, statistics and plots and also linked the plots and tables.
• Performed data transformations and imports.
• Used SAS base code to generate reports and performs ETL process (data extraction, transformation and loading, validation). Monitored and managed the data feeds into the data warehouse and extraction transformation and loading to analytical database.
• Extensively worked on Korn-Shell scripts for running SAS programs in batch mode on UNIX.
• Utilized SAS/BI capabilities to filter and guide business user’s requests.
• Assisted Database Analysts in defining and creating, data dictionary, and in providing end users access to the data dictionary.
• Developing and designing reports, applying comprehensive business knowledge by working closely with the business unit and project managers.
• Developed codes, and tests queries and reports based on user specified criteria against various databases
• Worked with business users to help them understand the data types and structures contained within various databases.
• Extensively worked with large Membership data using hash objects and joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple databases. Modified macros for report generation using SAS/Macros as per the requirements.
• Generated highly customized reports of claims data using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL. Monitored and managed the execution plans for SQL code using SQL developer. Used System macro variables like SQLXRC, SQLXMSG for debugging.
• Extensively performed Data Cleansing, data aggregation, Data Scrubbing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS and PL/SQL queries and creating complex reusable Macros.
• Retrieved data from Sybase, DB2 to SAS for data review and statistical analysis using Libname engine and SQL pass through facility.
• Extensively used PROC Datasets and PROC Copy to modify datasets.
• Extensively used SQL statement functionalities for analysis of large datasets and for data manipulation like Indexing and appending various datasets.
• Wrote complex SQL queries for checking the Data Transactions and Database Integrity in Sybase. Also developed SQL scripts to run complex data integrity test cases and to extract data from the tables.
• Wrote Korn-Shell Scripts performing various steps like running a SAS code, Monitoring batch processing, emailing the output files, removing and Backing up files, archiving files for historical data and zipping up files to send to external locations as attachments in emails.
• Worked with SME (Subject Matter Expert) for validation of various developed process.
• Worked on Unix Shell Scripting (Korn-Shell) for automation of processes

Environment: SAS/BASE, SAS/MACRO, SAS/ACESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/EG, MS Project, Sql Server Management Studio, WinSQL, IPSwitch, Reflection X, Putty, Serena Dimension, Teradata, SQL Server, Sybase IQ, Windows XP, UNIX, Korn-shell and MS Visio.

Confidential, Bridgeport, CT

SAS Developer and Data Modeler

Roles and Responsibilities:

• Interacted extensively with end users on requirement gathering, analysis and documentation.
• Effectively prepared and published various performance reports and presentations.
• Responsible for Statistical Data Model for different customers and credit card holders.
• Involved in designing credit risk assessment modelto calculate risk factor for individual clients.
• Developed complex SAS Macros & Stored Procedures in UNIX & AIX O/S to simplify SAS code and effectively reduce coding time.
• Imported Data from relational database (ORACLE, SYBASE IQ) into SAS files per detailed specifications.
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, PROC CORR and PROC ANOVA.
• Used PROC LOGISTIC to estimate relationship between binary responses.
• Wrote SAS program & Define Jobs to perform Revenue Reports in IBM Mainframe Operating System.
• Migrated data from SPSS using the SAVE TRANSLATE, into SAS as sequential transport files.
• The SAS transport format was read using the XPORT engine and PROC COPY.
• Extensively used SAS ODS facility to create customized reports in HTML.
• Interacted with data using the Dynamic Data Exchange (DDE) facility in SAS.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Data Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis using SQL queries.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts
• Actively involved in creating ad-hoc queries using SAS Information Map Studio
• Generated Ad-hoc reports for external vendors in quarterly, monthly or yearly format as per individual vendor request
• Created reports in the style format (RTF, PDF, HTML) using ODS statements and PROC TEMPLATE
• Performed Consumer profiling, Sales forecasting and testing using Business Object.

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/CONNECT, SAS/ETS, SAS Enterprise Guide, SAS Enterprise Miner, Oracle, Sybase IQ, Sybase Power Designer & Viewer, SAS Information Map Studio, SAS DI Studio, SAS OLAP Cube Studio, SAS Stored Processes, SAS Dashboard, SAS Portal, IBM Mainframe, DB2, Korn shell, Windows XP and UNIX AIX

Confidential, Waltham, MA

Sr. SAS developer/Data Analyst

Roles & Responsibilities:

• Actively involved in analysis of Claims data, Membership data and Service Line data and created delimited files to send it to third party for further analysis.
• Involved in ranking of Healthcare Provider in State of Massachusetts, which involved in improving quality of health to patients.
• Wrote complex SAS code to parse and manipulate XML files and create output datasets.
• Created SAS data sets by extracting data from DB2 and Teradata tables using SAS/CONNECT and SAS/ACCESS.
• Retrieved data from oracle10g to SAS for data review and statistical analysis using Libname engine and SQL pass through facility.
• Performed data analysis using BASE/SAS and SAS/EG.
• Utilized SAS/EG to transpose, stack, rank, and create required reports.
• Also used functions to convert the data types and conditional logic in the Query Builder to create new columns.
• Performed data manipulation, cleaning, sorting, concatenating, stacking, interleaving, merging and combining SAS datasets using SAS/Base, SAS/Enterprise Guide and SQL.
• Created new SAS datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and other conditional statements.
• Worked with statistician to analyze the results obtained from various statistical procedures like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC REG and PROC GLM.
• Responsible for creating monthly and quarterly Group Summary Reports and Detailed Member Reports through SAS Web Report Studio.
• Generated different statistical analysis for continuous and categorical data. e.g. finding the p value, performing overall F- Statistics using one way analysis of variance.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE for creating a preferred list of customers as per the given requirements from business analysts
• Extensive use of detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.
• Wrote Korn Shell Scripts performing various steps like running a SAS code, emailing the output files, removing and copying files, archiving files for historical data and zipping up files to send to external locations as attachments in emails

Environment: SAS/BASE, SAS/STAT, SAS SQL, SAS/GRAPH, SAS/SQL, PL/SQL, SAS/ODS, SAS/MACROS, SAS/ACCESS and SAS/CONNECT, DB2, Teradata, XML, Putty, WinSQL, PVCS, IPSwitch, XML, WINDOWS, Korn Shell, UNIX

Confidential, New Orleans, LA

SAS developer/Data Analyst

Roles & Responsibilities:

• Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.
• Used SAS/ACCESS to read datasets from databases, flat files, also read and write other PC File formats and performed extraction, transformation and loading from large Oracle tables.
• Manipulated existing Oracle database by accessing the data using SQL pass through facility.
• Worked on pre-existing macros for data validation by checking data distribution and comparison to standard data.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Generated highly customized reports using SAS macro facility, Proc Report, Proc Tabulate, and PROC SQL. Analyzed various tables using Data manipulation techniques like merging, appending and sorting.
• Performed data cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and macros in SAS.
• Validated, documented and tested component programs in an efficient manner for inclusion in integrated reports.
• Transferred and Migrated Data from one platform to another to be used for further analysis
• Actively involved in Designing and Developing complex SAS and SQL programs in Unix platform
• Wrote Korn-Shell scripts for back up and running batch files and perform quality assurance and validation on the transported data and reports.
• Worked with the specified marketing teams to clearly identify the selection criteria needed for each list. Ran ad-hoc queries/reports as needed and analysis is done as requested.
• Supported development of a management reporting system, which was using a web front end to generate user queries.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access. UNIX, Korn-shell