SUMMARY

• Over all 8+ plus years experience with SAS, Oracle PL/SQL, Discoverer,Unix Shell
• Scripting, VB, Java, C#, COBOL and MS Excel and involved in reporting and analysis tasks such as summaries, tables, lists, graphs and hypothesis testing.
• Six + years work experience as a SAS Data Analyst/SAS Programmer in Direct marketing, credit card services, Healthcare and Retails Industries.
• Experience in Base SAS v … SAS/STAT, SAS Macros, SAS/GRAPH, SAS/CONNECT, SAS/INTRANET and SAS/ACCESS on Windows and UNIX platforms and competence in carrying out statistical analysis of large - scale data
• Experience in using SAS Business Intelligence, SAS Financial Management (FM), SAS OLAP Cube studio, SAS Management Console, Enterprise Guide (EG 4.0), Enterprise Miner, SAS DI Studio SAS/FSP, SAS/AF
• Experience in using data steps in SAS for creating, maintaining and manipulating datasets.
• Experience in using various statistical procedures in SAS such as PROC SQL, PROC SORT, PROC RANK, PROC FREQ, PROC UNIVARIATE, PROC MEANS, PROC TRANSPOSE, PROC TTEST and PROC IMPORT.
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results
• Worked extensively with SAS Credit Risk Management Solution for Basel II and also with other related tools such as SAS Enterprise Miner in credit scoring and fraud management, SAS Risk Dimensions in market risk projects
• Created automated online reports using Oracle SQL and Discoverer to compute performance metrics from customer purchase data.
• Supported database migration by converting scripts from Oracle SQL to Teradata SQL.
• Used Oracle SQL to build data validation tools for list processing tasks.
• Seven years work experience in using MS Excel tools such as VB, Charts, Solver, Crystal Ball, Pivot tables and lookup functions applied to quantitative, analytical and reporting projects.
• Five years experience using Unix Shell scripts, Data Flux and Oracle SQL to perform ETL, data processing and automation tasks. Set up customized ETL programs for efficient and automated list processing routines with exception handling capability.
• Used Data Flux tool to create name and address based id assignment to customer data. Created standard multi-use programs using Data Flux to load customer data files in multiple formats such as flat files, SAS, Access into Oracle tables.
• Quality assurance procedures of other programmers' work, validating, debugging, documenting and optimizing SAS programs for QC and QA
• Using ODBC to connect SAS System with relational database management systems, such as Microsoft SQL and Oracle, to retrieve data and create SAS datasets
• Excellent experience with export SAS Results to different format, such as XML, Excel using SAS/EXPORT, SAS/ODS for reporting and presentation
• Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE, SET and PROC SQL.
• Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.
• Self-motivated individual with strong technical & analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS

Statistical Software: SAS Base, SAS Macros, SAS Access, SAS/GRAPH, SAS/STAT, SAS/Intranet, SAS/CONNECT, SAS/ACCESS, SAS Business Intelligence, SAS Financial Management (FM), SAS OLAP Cube studio, SAS Management Console, Enterprise Guide (EG 4.0), Enterprise Miner, SAS DI Studio SAS/FSPSAS/STATS, SAS/AF,SAS FORECAST SERVER

Databases: Oracle 9i/10g, Teradata, MS Access,SQL Server2008, MYSQL

Operating Systems: Windows, Unix,Mainframe,Solaris

Programming Languages: Java/J2EE, VB.Net, C#, ASP.Net,C,C++,PHP,COBOL,PL/SQL,Discoverer

Software Packages: MS Word, Advanced MS Excel, MS PowerPoint, TOAD, SQLPlus

Optimization tools: Arena, Solver, Crystal Ball

PROFESSIONAL EXPERIENCE

SAS Programmer/Analyst

Confidential - Madison, WI

Responsibilities:

• Developed new code in SAS/SCL for enhancement requests from the users on applications namely Performance feedback System, Broadcast system, Yard hold system, DoAll, Modular Build Doall system etc.
• Troubleshooted the errors occurring in the code or sql queries due to wide range of data and increasing volume of day to day transactions.
• Developed reporting system which analyzes part number and machine process performance using the SAS/db2 interface to import data.
• Provided O.L.A.P. (On Line Analytical Processing) functionality by using SAS O.L.E. (Object Linking and Embedding) and D.D.E. (Dynamic Data Exchange) tools to embed, update and selectively view MS/Excel and MS/Access data within a SAS/AF frame application.
• Created XHTML front-end tables using SAS/WEB applets to create list boxes, check boxes and radio buttons that conditionally branch to SAS generated custom tabular and/or graphic report output.
• Developed techniques to integrate HTML objects such as check boxes in SAS Proc Tabulate report procedures for a project to convert the PFS application from a mainframe environment using DB2 and VSAM/ COBOL to a client server environment with UDB/UNIX, SAS/SQL, SAS/SCL, SAS/GRAPH, SAS/ACCESS, and SAS internet tools.
• Wrote SAS code using SAS/SQL, SAS data step processing and SAS macros to replicate and enhance the reporting functionality provided in the previous mainframe VSAM/COBOL environment.
• Wrote UNIX scripts to run hourly, daily, weekly and monthly batch jobs to transfer data from mainframe to unix server and convert data to SAS datasets by running SAS codes containing SAS macros to perform unique tasks such as using SAS to build mainframe JCL and submit batch jobs to FTP multiple SAS data sets from the mainframe to a UNIX platform to dynamically allocate UNIX files and provide production data for various data warehouse databases.
• Designed and implemented training modules to assist the department with the transition from a Mainframe to UNIX platform and from SAS 8.0 to SAS / 9.2.

Environment: SAS/SCL, SAS/ODS, SAS/Connect, SAS/Stat, SAS/Access, Enterprise Guide (EG 4.0),Enterprise Miner, UNIX, Windows, Access, Excel, MVS/TSO, JCL, VSAM, COBOL, DB2

SAS Programmer/ Analyst

Confidential, Orange county, CA

Responsibilities:

• Generated statistical reports. Technologies like Teradata and SAS are used for creating reports.
• Working on checking Data quality by comparing current month data and previous month data or going back upto 3 years to check the same months data to reveal the similarities and variances in the data. The determination is usually based on checking differences in missing, mean, standard deviation, minimum and maximum values of the range of data.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements.
• Created 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.
• Created SAS Customized Reports using the Data Null technique.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Developed routine SAS macros to create tables, graphs and listings.
• Developed SAS macros for data cleaning and reporting and to support routing processing.
• Used Proc REPORT to generate reports. Developed annual reports based on existing data.
• Imported data from excel sheet for analysis in SAS.
• Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros.
• Maintained large data sets, combined data from various sources in varying formats to create SAS data sets and/or ASCII files.
• Converted Teradata data tables into SAS data files using SAS SQL 'Pass Through Facility,' and uploaded SAS data files into Teradata tables using SAS 'Dbload' procedure. Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/ConnectWindows XP professional, Unix, Teradata SQL/Assisstant.

SAS Business Analyst / Strategy Consultant

Confidential, West Chester, PA

Responsibilities:

• Conducted thorough analysis on historical data to generate seasonality of demand index profiles.
• Analyzed past data to generate granular price elasticity of demand values and associated reports to aid business decisions regarding promotions and investment therein.
• Studied store behavior at a high level to gather information and generate reports regarding selling patterns, traffic volumes, geographic divides and seasonal swings.
• Spearheaded the requirementgathering, development and testing phases of the YMR Project.
• Used SAS/Access and SQL Assistant to interface with the database server for data extracts.
• Performed extraction, transformation and loading from / to large Teradata tables.
• Optimized, automated and productionalized daily / weekly / monthly scripts for increased efficiency and intelligence.
• Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
• Generated web based reports via Web Report Studio to enable users and decision makers across the enterprise with self sufficient access to consistent, accurate data and the predictive power of SAS analytics.
• Used %sysfunc and other macro functions of SAS/MACRO to execute I/O operations and write reusable code.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, Proc ANOVA.
• Transacted with various formats of data; flat files, CSV, XLS, ASCII; to create and maintain large datasets.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on the data.
• Developed reporting procedures using PROC REPORT, PROC TABULATE and DATA NULL .

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STATSAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, SAS Web Studio, HTMLTeradata

Sr.Analyst Programmer

Confidential, Atlanta, GA

Responsibilities:

• Collection of user requirements and development of technical specifications, and provide documentation as applicable.
• Analyzing all the programs to identify the External feeds and dependencies.
• Prepared flow diagrams and spread sheets how the sequence of the programs to be run.
• Maintained and enhanced Existing Mainframe applications for Client ProfitabilityDone Data conversion between SAS in Mainframes and SAS under Unix/Windows environments.
• Preparing the JCL's for down loading the files from Mainframe.
• Developed Data Entry and Validation Screens using SAS/AF and SAS/SCL.
• Interacting with statisticians, DBA, and reviewers, determine the data processing
• Compile statistics and create detailed reports and graphs for management and customer review using SAS/ STAT. SAS/Graph, SAS Macro etc.,
• Modified the programs by using SAS MACROS, as table driven rather than changing YYMM, rate, and amount etc. value every month in all programs.
• Unit Testing with different possible conditions.
• Writing shell script programs to run SAS jobs in UNIX, and then scheduling the scripts using Autosys, Cron tab, or AT command to run at specific day and time.
• Developed AutoSys Routines (JILs) for automating and scheduling batch process
• Responsible for checkout/checking from/to SCCS before/after code modification. Develop applications, support production systems.
• Extensively used ETL to load data from Oracle database and Flat files to Oracle data warehouse
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Generated reports using Business objects, WEBi and Seagate Crystal Reports 8.x
• Wrote Oracle Database Triggers, Stored Procedures, Functions, PL/SQL Blocks
• Used Explain Plan Utility for Optimizing SQL Queries.
• Mentored Team Members in SAS related issues
• Extracted data from Oracle, Excel, Fixed Format and flat files into SAS Datasets.
• Extensively used techniques to read and write-out fixed format files using filename, put, and column input features
• Used change management system for documenting application/data base changes.

Environment: Sun4u Sparc, IBM Mainframe, DELL Workstation 400, Sun OS 5.8(Unix), Windows NT, TSO, SAS 9.1.3, BASE SAS, SAS/AF, SAS/SCL, SAS Macros, SAS/ACCESS, SAS Procs and SAS/SQL, SAS/ GRAPH, SAS/STAT, SQL, PL/SQL, JCL, COBOL, Oracle 10g, DB2, Informatica PowerCenter 8.1

SAS Developer

Confidential, Brea, CA

Responsibilities:

• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables.
• Acquired financial raw data from Oracle and DB2 tables and loaded the data into SAS datasets Used Macro routines to convert different types of source file (Excel, Word, and Text) 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.
• Provide statistical programming expertise in the production of datasets, analyses, tabulations, graphics, and listings from client's data.
• Created data marts and reports for Business intelligence reporting in SAS using SAS ETL, SAS DI (Data Integration), and Enterprise Miner.
• Create Information MAPS using the Information Map Studio for Analytics and Business Forecasting Team for creating the Time Series Forecasting Models and also written SAS Stored Processes to Create Efficient Reports and delivering it in the Web Portals using the Information Delivery Portal and SAS Management Console.
• Involved in Data mining using Enterprise Miner for various health care datasets such as Eligibility, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx).
• Created edit check programs to find discrepancies in a raw dataset provided by Data Management Group.
• Developed and scheduled SAS jobs using Shell Scripts / UNIX.
• Used SAS Access to ORACLE feature for large data extractions (SQL-Pass thru), PROC DBLOAD.
• Involved in various phases for segmentation and response analysis used for direct marketing campaigns.
• Extensively used SAS Enterprise Miner to perform various marketing analytics like segmentation, clustering and profiling for customer retention
• Forecasted impact of direct market campaigns for acquiring, developing and retaining customers using SAS.
• Developed and maintained SAS Web Reports for sales data based on the requirement. Implemented data management plans designed to meet project deadlines.

Environment: SAS (Base, Macros, SQL), SAS/ETL, SAS/GRAPH, SAS/ACCESS, SAS/CONNECT, SAS/STAT, Excel, Access, Oracle, PL/SQL, Windows XP

SAS Developer/Analyst

Confidential, Henrico, VA

Responsibilities:

• Developed SAS code modules to extract (filter) data from Oracle, Teradata, DB2, flat files, proprietary format files using business rules and load into SAS datasets in the SPDS (Scalable Performance Data Server).
• Used Data Flux tool to create name and address based id assignment to customer data.
• Created standard multi-use programs using Data Flux to load customer data files in multiple formats such as flat files, SAS, Access into Oracle tables.
• Worked on Data quality by comparing current & previous data to ensure consitency & integrity of data.
• Performed data cleaning and scrubbing to remove redundancies, deal with missing data and validate data to standards of integrity using SAS DATA steps, Proc SQL and SAS SQL Pass Thru.
• Developed genericmacros, utility macros (audit, ftp, backup/archive files) and driver macros for integration of SAS modules for automation.
• Performed data transformations according to the business requirements, using Proc SQL and macros, and loaded data into data warehouse using SQL Loader utilities.
• Used SAS/EG in multi-user environment for intermediate data manipulation, analysis and summary statistics.
• Involved in creating the Logical and Physical design of the data warehouse using ERwin Modeling tool.
• Assisted in creating dimension model using Star Schema Methodology (Fact tables, Dimension Tables etc).
• Assisted in scheduling SAS jobs, configuring email/messaging services in crontab as well as SAS/ETL studio.
• Involved in complete Software Development Life Cycle (SDLC) of the project such as modeling, process flows, development, unit testing and documentation.
• Raised queries on repository to provide ad hoc reports, for marketing dashboard project, using Data Null, Proc Tabulate and Proc Report techniques.
• Provided programming, validation and aggregation for direct marketing models including customer segmentation analysis.
• Generated web based reports via SAS ODS using several SAS procedures including Tabulate, Format, Freq, Summary and Transpose.
• Developed SAS programs to extract demographic and life style information data from repository for modeling studies.
• Exported reports into Excel spreadsheets for further statistical analysis by marketing team.
• Developed user interfaces using JSPsand HTML.
• Developed necessary Hibernate DAOs(Data Access Objects) for control module.
• Developed application components using Spring Framework

Environment: SAS 9.0, Dataflux, ORACLE, DB2, SQL Server, BASE/SAS, SAS Macro, SAS/ACCESS, and SAS/SQL, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/ETL Studio, SAS Enterprise Guide, AIX 5.2J2EE, EJB, JSP, JDBC, Weblogic Application Server, Eclipse, Java Script.