SUMMARY

• Over eight years of extensive experience in the field of SAS (9.2, 9.1.3, 9.1, 8.2 versions) Programming / Business Analysis and Data Analysis in Healthcare/Finance/Insurance projects.
• Experience in all phases of Software Development Life Cycle (SDLC) including Requirements, Analysis/Design, Development and Testing. Expert in defining BI Standards, Best Practices, Code Review, DW standards and production support. Experience in creating functional specs, gathering business requirement, developing Use Cases diagrams, Class diagrams and Sequence diagrams using MS Visio. Expert in assisting to develop project plans for supporting the implementation as needed.
• Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process. Experience in Data Modeling and involved in creation of Star Schema and Snowflake dimensional data marts. Experience in using CA Erwin Tool for defining subject areas and creating logical and physical models as well as Data Marts. Strong experience in using ETL Tool Ascential DataStage 7.5/7.0/6.0/5.2/5.1 (Server, Parallel Extender) for Extraction, Transformation and Loading to Enterprise Data Warehouse.
• Experience in developing new or modified existing SAS programs to load data from the source and created study specific datasets in IBM Mainframe environment. Experience working with ./n . Experience in reading mainframe EBCDIC data files using SAS FTP Access Method and using EBCDIC informats.
• Strong expertise in RDBS and SQL programming for data management. Strong experience with databases like Sybase, DB2, Oracle, Teradata, MS SQL Server and MS Access. Strong expertise in SAS programming for extracting data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.
• Statistical Analysis SAS, Crystal Reports, SASWeb with HTML interfacing with relational databases such as Oracle, DB2, Teradata and SQL server.
• Used IBM MAINFRAMES, JCL to extract relevant datasets to carry out customer segmentation based on the project’s requirement.
• Extensive experience in writing Korn - shell scripts for executing SAS batch files on UNIX to save the execution time and report automation as well as JCL for executing SAS on Mainframe.
• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports
• Experience in processing large datasets with billions of records for data transformation including data cleansing, data scrubbing, data profiling and applying business logic rules to incoming data.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily basis using complex SQL Queries.
• Expertise using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, MS Office tools.
• Expertise in using various SAS procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT. Experience in Consumer Profiling, Customer Segmentation, Regression Analysis and Sales Forecasting.
• Expertise in creating multiple threads, between the RDBMS and each SAS thread. Experience in pipeline parallelism, multithread application and debugging techniques.
• Experience in performing ad hoc queries and User Acceptance Tests (UAT) for various application and reports on a daily/weekly or monthly basis.
• Hands on experience working with OLTP, OLAP Cube Studio, SAS Enterprise Business Intelligence Server (SAS/EBI) and SAS Information Map Studio

TECHNICAL SKILLS

OPERATING SYSTEM: WINDOWS XP, 2000, 9X, NT, DOS, LINUX, SOLARIS, AIX, HP-UX

RDBMS: ORACLE 9I, MS ACCESS, Teradata, DB2, SQL SERVER, ERWIN, AQT, ETL

LANGUAGES: SHELL (SH, BASH, Korn), PERL, C++, PL/SQL

SAS: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/ACCESS, SAS/CONNECT, PC SAS, ODS, HASH OBJECTS, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Reporting Studio, SAS Information Delivery Portal, SAS Enterprise Miner, SAS Enterprise Guide, SAS Data Integration Studio

ETL: DataStage (Server,Parallel Extender, and Quality stage / Integrity), Informatica

TOOLS: XML, HTML, DHTML, MS PROJECT, MS OFFICE, SPSS, TOAD, SQL DEVELOPER, LOTUS NOTES, MAESTRO, X WINDOWS, CRON, AT, VI, SED, AWK, PUTTY

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

SAS Analyst

Responsibilities:

• Cisco requires insight into travel spend worldwide. Any long term solution shall be presented in a reporting application that is cohesive, robust, and drillable. Any short term solution shall utilize an existing reporting application to provide finance, managers and executives increased insight into actual (expensed) travel related spending.
• Working with Finance Planning and Reporting to Manage and support day to day issues.
• Determine impacts of Revenue and Booking issues and to resolution including root cause.
• Using SAS Profitability Management (SAS PM) created and modified existing Associations.
• Support fiscal close functions to ensure success including data dependencies.
• Involved in AE (Allocation Engine) updates like creating New Measure, sub-measures, updating it and deactivating or reactivating sub-measures.
• Working on Allocation Process for Bookings, Expenses and Revenue and good understanding of Opex, ASCogs allocation process.
• Automated, system emails for New Sub-measure updated, manual mapping, mismatch criteria v/s rules report.
• Validated measures and sub measure and rules associated to it.
• Assisted in developing new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
• Working on creating rules and associating to submeasure and supporting Production team.
• Separating allocation for Profitability and Opex
• Month end tasks like, to run scheduled sas jobs for OPEX, ASCOGS and refreshing SAS Server.
• Involved in data Analysis and reporting to support the Production Team in their business decision process using SAS and SAS PM.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC REG
• Involved in UNIX Shell programming using Korn shell and setup jobs for SAS application batch run.
• Developed, analysed and designed SAS programs in UNIX platform
• Developed SQL scripts to run complex data integrity test cases and to extract data from the tables.
• Using SAS PROC SQL to extract data from different relational database management (Oracle) systems

Environment: SAS 9.3, SAS EG 4.3 SAS PM (Profitability Management) UNIX, SAS/ACESS. SAS Web Report Studio, SAS Data Integration Studio, SAS Management Console, SAS OLAP Oracle, and Toad.

Confidential, Newark, DE

SAS Programmer/Analyst

Responsibilities:

• Working with Chief Center Credit Management Center department to validate certain Models.
• Build and Validate 5 Loan forecasting models for loan portfolios for risk management. Used SAS and SQL on windows to develop account level models for Loan Losses.
• Worked with Credit Risk Managers and analysts to interpret forecast results based on model assumptions and changes in the business environment.
• Worked with Model Owners and Specialists and independently perform model validation in compliance with Model Validation Policy and Guidelines.
• Collects data and assumptions used in models, including model output, in preparation of model Validation.
• Monitors existing predictive models for ongoing efficiency and stability; performs refreshes as necessary.
• Produce predictive models which enable the creation of rating plans and evaluation of risk
• Documented the present model validation results to the manager.
• Developed modeling utility programs with SAS Macro for the various stages of predictive modeling process.
• Proficiency in SAS toolset & Technologies such as SAS Grid, SAS eMiner, amongst others, Statistical Analysis, Predictive Modeling/ Scoring
• Established rigorous model-based approaches with quantitative support to produce monthly/quarterly credit loss and delinquency forecasts for planning, as well as determining risks and the timing of losses. Provided segment-level delinquency forecasts.
• Enhanced governance over reserve and loss forecast model methodologies and related processed by ensuring critical risks are appropriately identified, evaluated, reported and controlled.
• Conducted and generated monthly and yearly statistical reports based on the routine analysis on following models; Loan Loss Projection Model.

Environment: SAS 9.1 9.2, SAS 9.3, SAS EG 4.2, SAS EG 4.3, SAS E-Miner, SAS/MACRO, SAS/ACESS and SAS/CONNECT, ORACLE, PL/SQL, Oracle, Ms Project, Windows XP, UNIX.

Confidential, Birmingham, AL

SAS Programmer

Responsibilities:

• Working with Credit risk department to validate certain variables which need to be meet with Federal requirement
• Generate statistical reports. Technologies like Oracle and SAS used for creating reports.
• Prepare new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Create complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Create SAS Customized Reports using the Data Null technique.
• Generate graphs using SAS/GRAPH and the SAS Graphics Editor.
• Develop SAS macros for data cleaning and reporting and to support routing processing.
• Use Proc REPORT to generate reports. Develop annual reports based on existing data.
• Import data from excel sheet for analysis in SAS.
• Maintain large data sets, combined data from various sources in varying formats to create SAS data.
• Establish the highest level of confidence in the bank’s integrity of data.
• Export all result into Excel, PDF format by using ODS statement
• Convert ORACLE data tables into SAS data files using SAS SQL ‘Pass Through Facility’.
• Develop SAS programs using Base SAS for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Create and implemented statistical analysis plans and specification documents, participated in database design, data collection guidelines, and logic checks.
• Apply generally accepted Programming Standards and Techniques to assure efficient program logic and data manipulation.
• Create documentation sufficient to explain the results achieved when performing validation.
• Automated SAS EG projects by creating Base SAS ETL programs using the departments coding standards and set the jobs to run on an automatic basis

Environment: SAS 9.1 9.2, SAS 9.3, SAS EG 4.2, SAS EG 4.3, SAS/MACRO, SAS/ACESS and SAS/CONNECT, ORACLE, PL/SQL, DB2, Datastage, Ms Project, Windows XP, UNIX, Korn-shell.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Responsible for reviewing the team’s existing SAS programs and modifying them to make them more logical and efficient.
• Wrote programs using PC SAS (UNIX), Oracle PL/SQL.
• Develop programming to implement new reporting using the company’s credit loss accounting data, both from Oracle databases and EUC sources.
• Installed new systems and upgraded software packages.
• Wrote Oracle PL/SQL (Oracle 9i) Stored Procedures and Functions.
• Executing existing SAS program jobs to produce monthly reports and datasets and meet tight deadlines
• Experience in data mining/predictive modeling, marketing analytics, database marketing, or other data
• Design and develop routines, tools and using SAS EG/Base SAS to support ad hoc reports.
• Developed new complex SAS programming to introduce new reports and data sources
• Maintain existing programs and queries to generate monthly credit data more efficiently
• Involved in data Analysis and reporting to support the Marketing Team in their business decision process using SAS and Business Objects.
• Documented program code and ensure appropriate data management procedures are implemented.
• Also cleaned the data using SAS code (SAS Macros) and VB Script and develop SAS Code on UNIX according to the specifications.
• Interface with internal customers from various units to provide reports and data
• Provide ad hoc analysis of credit loss activity and respond to requests from internal customers.
• Developed complex SAS Macros & Stored Procedures to simplify SAS code and effectively reduce coding time.
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time.
• Performed complex statistical analysis using PROC MEANS, PROC FREQ.
• Based on the mapping, develop an ETL (using SAS DI Studio) to augment the CFNA Analytic Data Mart with the historical statement data by streaming the necessary data elements from the mainframe to an MS SQL Server. Test, quality-check, optimize, formalize, productionize, and document the ETL process.
• Using ETL tools for data sourcing and SAS ODS for reporting

Environment: SAS 9.1 9.2, SAS/MACRO, SAS/ACESS and SAS/CONNECT, Sybase, Oracle, DB2, Datastage, Ms Project, Windows XP, UNIX, Korn-shell

Confidential, New York City, NY

Sr. SAS Developer

Responsibilities:

• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports
• Performed incoming data reading from IBM mainframe to SAS and transferred to data staging tables and performs ETL process to load data from staging tables to DB2 warehouse
• Design and Develop reports, charts, data structures, OLAP Cubes, ETL processes and stored processes.
• Created SAS programs to extract from data tapes system usage records pertaining to CICS, resources and create capacity planning reports for management.
• Modified and created new CICS and DB2 programs utilizing standards to pass data to the website system.
• Provide statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from client’s data.
• Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets Used Macro routines to convert .xls, .rtf and .txt files to produce SAS reports and graphs. Used Proc DBLOAD, Proc SQL, Proc import, Proc export statements to load SAS data sets from and to DB2 and Oracle 9i.
• Used IBM MAINFRAMES, JCL to extract relevant datasets to carry out customer segmentation based on the project’s requirement.
• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informats to read these data files.
• Worked with data gap and database anomalies like Insert, Delete and Update.
• Create Information MAPS for Analytics and Business Forecasting Team.
• Develop programs and perform unit test using SAS, DB2, SQL and Clear quest. Assist in User Acceptance Testing (UAT).
• Extensively used SQL statement functionalities for analysis of large datasets (Billions records) and for data manipulation.
• Designed and developed in Oracle. Performed the business operations, workflow, optimization, and needs analysis. Performed the data analysis, modeling, and mapping
• Developed DDL and DML statements and implemented it to the DB2-UDB.
• Wrote programs using PC SAS (UNIX), Oracle PL/QL.
• Extensive use of SAS/Access, SAS/Connect to connect to various databases such as development and production database (DB2 on UNIX).
• Worked on SAS BI enterprise server.
• Experience with Accessing, Integrating and synthesizing data.
• SAS/STAT was employed to produce statistical analysis such as regression, multivariate, survival, psychometric and cluster analysis. Quarterly and annual sales and profit summary reports were prepared using the Proc Report.
• Used SAS datasets to create reports using Crystal Reports 10 and Proc Reports.
• Produced Ad hoc reports using Oracle/SQL, SAS, and Crystal Reports, on-demand.
• Was involved in segmentation and response analysis for direct marketing campaigns.
• Forecasted impact of direct market campaigns for acquiring, developing and retaining customers.
• Developed and maintained Excel Reports for sales data on a need basis.
• Expertise in Microsoft Excel for automate the report using different excel functions, creating Pivot Reports.
• Designed and created parameterized SAS EG jobs for analyst and business users to execute for different scenarios using different parameters.
• Implemented data management plans designed to meet project deadlines.

Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, STATA, SAS BI Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros,MVS, JCL,Oracle 9, DB2, PL/SQL, MS Excel

Confidential, Hartford, CT

SAS Data Analyst

Responsibilities:

• Conducted JAD sessions and gathers business requirement to write spec documents.
• Creates new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Used IBM Mainframe application, CICS, Customer Information Control System which is a transaction processing system designed for both Online and Batch activity.
• Was working on programming in JCL interacting with DB2 and CICS under the Advanced Consumer Lending servicing systems.
• Involved in Code development in DB2, CICS calls for new functionalities and change requests.
• Conducted Data Requirement Analysis, designed technical specifications and Data mapping sheets to meet the business rules and data extraction ETL process by looking at the metadata to know the dependencies and joins between different tables in warehouse for leveraging the execution time and SQL performance tuning.
• Extensively used korn-shell scripts to kick off SAS jobs and ftp flat-files to data staging areas and ETL process.
• Experience with high volume data mining, statistical analysis, predictive modeling, forecasting, or econometrics
• Used SAS base code to generate reports and performs ETL process (data loading, validation). Monitors and manages the data feeds into the data warehouse as well as extraction transformation and loading to analytical database.
• 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. Modifies macros for report generation using SAS/Macros as per the requirements.
• Generated highly customized reports for claim data using SAS/MACRO facility, PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL. Monitors and manages the execution plan for SQL code using SQL developer.
• Provided ad hoc reporting and gap analysis for Management using Crystal Reports.
• Combined capabilities of SAS, SQL, Crystal Reports, and Business Objects.
• Performed incoming data reading from IBM mainframe to SAS and transferred to data staging tables and performs ETL process to load data from staging tables to Sybase warehouse
• Extensively performed Data Cleansing, data aggregation, Data Scrubbing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Responsible to create and modify JCL and to create and run SAS Mainframe jobs and analyze SAS Mainframe reports
• 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 the datasets and freed up the library space after code execution
• Extensively used SQL statement functionalities for analysis of large datasets and for data manipulation like Indexing and appending various datasets.
• Wrote 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.
• Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures
• Worked as a 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 and SAS/CONNECT, STATA, Sybase, DB2, Datastage, Ms Project, MVS, JCL, Windows XP, UNIX, Korn-shell, MS Visio, UML, ERWIN, Lotus Notes, Solaris

Confidential, New York City, NY

Sr. SAS Developer/Programmer

Responsibilities:

• Develop Credit Risk Analysis Model Based on Fico scores.
• Responsible for Statistical Data Model for different customers and credit card holders.
• Involved in data Analysis and reporting to support the Marketing Team in their business decision process using SAS and Business Objects.
• Interacting closely with end users on requirement gathering, analysis and documentation.
• Involved in credit risk assessment modelto calculate risk factor for individual clients base on loc hierarchy
• Developed complex SAS Macros & Stored Procedures to simplify SAS code and effectively reduce coding time.
• Extensively used the PROC MODEL statement to define a theoretical model for the relationship between dependent and independent variables
• Imported Data from relational database (ORACLE) 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, and PROC ANOVA.
• 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 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
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Performed Consumer profiling, Sales forecasting and testing using Business Object.
• Effectively prepared and published various performance reports and presentations
• Develop Ad-hoc report using SAS Enterprise Guide.

Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Management Console, SAS OLAP & EBI Server, Teradata, DB2, Windows XP, Korn shell UNIX.

Confidential, Charlotte, NC

Sr. SAS Consultant/Analyst

Responsibilities:

• Prepared customized reports to help client provide a strong competency in understanding risk and accordingly perform better customer selection and customer satisfaction.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked on gathering, analyzing and documenting business requirements.
• Extensive Experience in writing Korn-shell scripts for executing SAS batch files on UNIX to save the execution time and for automation.
• Created SAS database files, Ad-hoc analyses and graphical reports, developed standard reports and supported SAS users. Involved in extracting, analyzing and clustering marketing data (according to customer demographic profile) from the data warehouse (ETL).
• Conducted meeting with business users and data architects to define metadata for tables to perform ETL process
• Used SAS PROC SQL to extract data from different relational database management (Teradata) systems. Used SQL Assistant to analyze and query from the Teradata DB.
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.
• Also cleaned the data using SAS code (SAS Macros) and VB Script and develop SAS Code on UNIX according to the specifications.
• Coordinated with key departments to analyze areas such as customer retention, opportunities and customer segmentation. Store and distribute SAS Enterprise Guide results in different formats (HTML, PDF, RTF) based on the user group requirement.
• Performed extraction, transformation and loading from large Teradata tables using Datastage in data-warehouse. Passed parameters in shell script to read daily and on request jobs to reduce complexity of business process.
• Written Korn-shell FTP scripts to FTP files to the specific path in the UNIX environment and to backup SAS files.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS/Base, SAS Enterprise Guide, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets.
• Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave datasets for producing required analysis of data and used SAS Business Intelligence to produce required Reports.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Wrote UNIX Korn-Shell scripts for back up and running batch files and perform quality assurance and validation on the transported data and reports.
• Performed Data analysis mainly using Regression and ANOVA (Proc REG, Proc GLM, and Proc ANOVA).
• Developed Stored Processes to distribute reports and in a secure manner.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Involved in JAD sessions for gathering business requirements and documentation to reduce the complexity of business process.
• Effectively prepared and published various performance reports and presentation.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT, SAS/GRAPH, SAS/ODS, MS Excel, MS Visio, MS Project, Teradata, Oracle9i, UNIX, Korn-shell, Enterprise Guide, ERWIN

Confidential, Edison, NJ

SAS Developer

Responsibilities:

• Responsible for defining the scope of the project-Project Value Scorecard, gathering business requirements from user interviews and then converts requirements into technical specifications. Developed Business Requirements Specifications documents. Used SAS for pre-processing data, data analysis, generating reports, statistical analysis and graphs.
• Created and modified Korn-shell scripts on UNIX to schedule the program to run on daily, weekly and monthly basis.
• Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS. Used SAS/ACCESS to read datasets from, Databases, Flat files, also read and write other PC File formats.
• Used PROC SQL for ad-hoc report programming and creation of the ad-hoc reports for marketing research data. Modified/developed new SAS programs using PROC TABULATE and PROC REPORT to generate periodic reports. Also performed statistical procedures using PROC MEANS, PROC FREQ and PROC UNIVARIATE.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing. Developed and maintained data retrieval and analysis tools for reporting and performed complex ad-hoc processes as necessary to develop viable recommendation for improvement. Identified and produced analytical data to support decision-making.
• Extensively used macros and Korn-shell scripts as well as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views.
• Extensively used SQL statement functionalities for analysis of large datasets (Billions records) and for data manipulation.
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading. Created permanent formatted SAS data sets for present and future analysis.
• Worked with various data like EBCDIC, ASCII and Binary formats and extensively used different kinds of informats to read these data files.
• Extensive worked on detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• 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.
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, PROC RANK, and SAS/MACROS.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge.

Environment: SAS/BASE, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, STATA, MS Excel, Rational Rose and Requisite Pro, TOAD, Oracle, DB2, Sybase, MS Visio, Unix, Korn-shell, JCL, IBM Mainframes, MS Project, SQL server, Java, UML, XML, Lotus Notes