SUMMARY:

• 8 years of experience in analysis, design, development, testing in SAS V6.0/8.2/9.1
• Extensive experience in direct marketing campaigns acquisition, cross-sell, retention across multiple channels
• Hands-on experience in RDBMS development including SQL programs and stored procedures.
• Experienced in extracting data from various databases like Oracle, SQL server, Informix etc. using SQL Pass through Facility.
• Expertise in using SAS ODS to create HTML, RTF and PDF for creating customized and adhoc reports
• Experienced in creating, storing reusable Macro modules as well as invoking stored macros.
• Proficient in handling data between SAS Excel, flat files and analyzing data using SAS.
• Extensive experience in developing SAS generic code to Software development Lifecycle SDLC Standards.
• Hands-on experience in RDBMS development including SQL programs and stored procedures.
• Extensive experiences of editing and debugging procedures for data cleansing, correction, transformation and program validation.
• Excellent analytical, inter-personal communication skills with experience in interacting with clients, multiple user groups and managing development teams. Ability to work in a fast paced environment and under deadlines.

Technical skills

• SAS SAS9.x/8.x
• Operating Systems Windows NT/XP/2000/2003, DOS, UNIX AIX, Sun Solaris, LINUX
• Programming Languages C, SQL, PL/SQL, COMPAQ VISUAL FORTRAN 6.6, MATLAB 7.1, VBA, Perl
• Web Tools/technologies HTML 4.0, XML
• Databases: Oracle 8.x/10g, MS SQL Server 7.0/2000/2005, MS Access-2000, DB2 7/8, Informix, Teradata
• Application s/w Packages MS Office, Microsoft Visio, MS Project, Shell korn, sed,awk Scripting, rational rose, source safe, JCL
• Statistical Software MINITAB, SPLUS

PROFESSIONAL EXPERIENCE

Confidential

SAS Developer/Application programmer, Credit and Portfolio Risk Management

Member of MIS team which supports Risk infrastructure management for Citi retail private label group. Involved in project that supports risk management with forbearance data mart build, analytics, error, exception and compliance reporting. Provide ad-hoc analyses, generate different cuts of data and supply excel, CSV, list report outputs per requirement

Responsibilities:

• Obtain functional and reporting requirements, translating to technical design specifications for SAS coding, validation and to generate on-demand reports for stake holders
• Provide ad-hoc analyses, generate different cuts of data and supply excel, CSV, list report outputs per requirement
• Develop monthly/weekly/daily error and exception reports that are used to highlight the condition requiring attention for Risk management to monitor change control to adhere to compliance requirements, automate and move to Maestro scheduler.
• Support Monthly reporting for regulatory bodies OCC and FRB for compliance. Validation of reports generated for each individual elements within report. Change analysis and issue identification. Work on resolving compliance issues through data analysis, business reasoning and logic, code development, testing and implementation.
• Analyze source system inconsistencies, develop interpretation strategies and convert business logic into SAS coding blocks. Assess change required to systems and existing data marts for compliance reporting.
• Use various techniques to read flat files with varying layout, define key variables for reporting and use extensive SQL to generate summary and detailed reports
• Using korn shell scripting to check arrival existence of files, trigger shell scripts and SAS jobs, check success and or failure of SAS and korn shell jobs, compress, archive reports, ship to collaboration sites mailx , notify users, automate file processing, scheduling and exchange files between servers.
• Improve the code efficiency and reduce run time, load on system resources using advanced SAS techniques such as multi-process connect parallel processing , hash tables etc.

Environment: SAS 9.1/9.2, Microsoft add-in, Enterprise Guide, MS-Office, Korn shell, Maestro scheduler, putty, Reflection X, IBM AIX 5.3, Windows XP and RUMBA, First data FDR

Confidential

SAS Consultant/Analyst, Client experience

Client experience supports business through marketing intelligence, research, customer and campaign management and analytics. Supported client experience in SAS augmented staff capacity.

Responsibilities:

• Meeting business partners and managers to obtain functional requirements
• Translating business requirements to technical design specifications for coding, validation and reporting purposes
• Review/analyze excel, pdf, ppt, SAS datasets and reconcile / compare to reports generated by other lines of businesses and then provide SAS code using base SAS, Proc SQL, Macros, ODS, functions to generate a new report based upon the reconciliation fixes
• Periodic interaction with Manager to discuss project progress and recommendations for scope of improvement
• Technically execute, prepare and present results to business partners
• Identify data gaps, source system inconsistencies and develop strategy to fix them
• Develop strategies to build new reports and modifying existing templates
• Provide technical support for data mart build, table load, validation and testing
• Analyze marketing campaign results and develop reports on monthly basis
• Automation and scheduling of various jobs to run in batch mode for monthly data mart load and reporting
• Improve efficiency of data handling between SAS-Excel, Excel-Excel, RDBMS-SAS
• Provide regular technical support for co-workers in a cross team environment
• Automate SAS code and data handling between different systems and files
• Peer review code and reports developed every month

Environment: SAS 9.1/9.2, Microsoft add-in, Enterprise Guide, MS-Office, Teradata, Teradata SQL Assistant, IBM AIX 5.3, Windows XP

Confidential

Targeted marketing consultant

Member of targeting execution team part of I I - formerly CART which supports Wachovia enterprise marketing with customer insight and critical analysis by customer research, targeting, providing periodic results, and measuring marketing campaign performance.

Responsibilities:

• Meeting business partners regularly to agree on and obtain campaign specifications
• Translate business requirements into technical design specifications for coding through PC SAS
• Selecting population by choosing high potential customers based on internally developed models
• Segmentation design sampling for response measure and other standard criteria for a given specific campaign
• List processing using SAS code for direct marketing cross sell and acquisition deposit campaigns for retail and small business lines via direct mail, online and telemarketing channels.
• Analyze marketing campaign performance, report results, and make recommendations to business partners to improve the marketing strategy
• Migration of SAS code to suit new data environment and develop metadata.
• Identify and trouble shoot data gaps and field issues with quick turnaround time.
• Automate the generation of periodic cross sell campaign response files using macros and batch processing
• Modify existing code to improve efficiency and speed.
• Exporting data to Excel for analysis using pivot tables from SAS datasets
• Develop code for audit checks for various ad hoc requests
• Scheduling batch SAS jobs on windows to run on remote system.
• Develop migration process for campaigns between CRM and DBMS systems.
• Extensively used sort, freq, mean, contents, print, univariate and sql procedures
• Regularly meeting team lead and reviewing peer code.

Environment: SAS 9.1, Enterprise Guide, Unica Affinium campaign plan, db-access, Ms-Excel, Informix, Teradata SQL Assistant, Oracle, IBM AIX 5.3, Windows XP

Confidential

SAS Data Analyst

Responsibilities:

• Analyzed the data based on the requirement
• Tuned the SQL queries to get better performance
• Wrote and modified SAS code in windows Environment
• Validate and test all code for accuracy and efficiency and moved it into Production.
• Developed, tested, debugged stored processes using SAS/EG
• Used Microsoft add ins for delivering reports in word and excel
• Conducted Ad Hoc analysis to support business strategy
• Developed SAS programs based on the draft spec document
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extracted data from warehouse using SQL procedure and created SAS data sets.
• Writing extensive UNIX shell scripts using Korn shell and using VI editor.
• Extensively used SAS procedures Print, Sort, SQL, Mean, Freq etc.

Environment: SAS/ BASE, SAS/MACRO, SAS/STAT, SAS/CONNECT, SAS/ACCESS, SAS/EG, Ms-Excel, Oracle 8i and IBM AIX 5.2

Confidential

SAS Statistical Programmer

Worked as team member, involving in the following projects, at Customer Data Management Analysis Department for Analytics group. Scored customer profitability and purchase propensity modeling for mutual funds campaign. Redeveloped scoring and next generation cross-sell models

Responsibilities:

• Involved in the Production support for Performance based Re-pricing, Customer Response, and Credit Rating applications.
• Constructed SAS data sets using match merging, sub-setting, selecting and summarizing observations and developed customized reports.
• Created summary reports using proc reports.
• Created SAS/Views from tables in Oracle database
• Created proc template for customizing the presentation of output using SAS/ODS.
• Data extraction from data warehouse, validation, modeling and processing.
• Modify/develop Korn shell scripts to automate and schedule tasks
• Documentation of the process and programs using MS word and MS power point.
• Involved in doing the risk analysis using statistical methods.

Environment: SAS, SAS/STAT, SAS/Graph, SAS/Macros, Windows NT, UNIX, MS-office, Oracle.

Confidential

SAS Consultant

I was involved in manipulation of large data sets. Responsible for data entry and conversions data validation and corrections uploading/downloading data from/to PC. My duties are implemented on both ad-hoc and routine basis. I was also responsible for Statistical analysis of data for use in litigation cases creating graphs using PROC PLOT, creating permanent formatted SAS data sets for present and future analysis sorting and merging by common variables. Also, Used SAS MACRO programming extensively.

Responsibilities:

• Involved in data processing which implements the necessary data analysis procedures and transforms data to the required format necessary to generate reports.
• Defined various ad hoc reports to be written in SAS based on user requirements.
• Used various functions and created new formats.
• Copied, moved, deleted, compared, renamed, spooled, printed, and browsed files in SAS.
• Developing stored processes using SAS/EG
• Developed statistical reports using Data null and PUT statements.
• Involved in migration of data from one system to another system.
• Wrote shell korn scripts to schedule batch jobs using VI editor.
• Responsibilities include writing, managing a 5 member team, defining their weekly schedules.
• Responsible for production support of existing systems for the user as well as enhancement of system functions.

Environment: Oracle, Base SAS, SAS/SQL, SAS/Graph, SAS/EG, Windows NT, UNIX, and ES9000.

Confidential

SAS Programmer

Cingular Wireless had an Enterprise Data Warehouse for holding the data of all the customers and employees. This multi-dimensional data warehouse had the information about the salaries and other information of all the employees, billing and other services offered to the business andresidential customers. This data was used for different purposes, the main purpose being raising campaigns to hold the valuable customers and prevent the existing customers from leaving Cingular. We the SAS team had to pull the data from different sources to generate lists for the campaign raising purpose. We also helped the client to calculate revenues on a weekly basis for different products.

Responsibilities:

• Involved in the design and development of databases different data models and ERDs according to the user specifications in the development of databases for small applications.
• Involved in the administration of the enterprise data warehouse using warehouse administrator.
• Written SAS code for developing data sets from raw data files received in text format. This included cleaning data.
• SAS/ENTERPRISE GUIDE software was used for file and program management purposes.
• Connected to Oracle and pulled data into SAS data sets using SQL pass through facility.
• Wrote different joins and merges to create reports based upon the requirements given.
• Written time and resource efficient code using PROC SQL.
• Written queries in Teradata SQL assistant to retrieve data from Teradata tables.
• Written macros to automate the code so that they generate reports on the invocation of the macro which helped to save time and manual intervention.
• Extracted, transformed, and loaded data using SAS/ETL.
• Used PROC SORT to sort the data according to the requirement.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROC FREQ, PROC CONTENTS and PROC DATASETSto generate different reports and run metrics on different data sets.
• Created tables, views in Teradata and Oracle as well as indexes and keys on different columns.

Environment: Base SAS, SQL, PL/SQL, Teradata SQL assistant, Mainframes, UNIX, SAS, Visual Basic, SAS/EG, SAS Warehouse.

Confidential

SAS Programmer Clinical Trials

The project is to study the effect of new Medicine in the treatment of Multiple Myeloma. To compare the whether Study Medicine offer an effective but less toxic alternative to the usual chemotherapy for patients newly diagnosed with multiple myeloma. The toxicity appears lower, and the response rate is as good as or better than that obtained using complex combinations of chemotherapy regimens. The study is to evaluate how much extra response do we actually get over dexamethasone , how much toxicity are we buying in that process and its worth.

Responsibilities:

• Created new or modify SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Extracted raw data from the warehouse and created SAS data sets that are required for the project analysis using SAS/ACCESS and SAS/CONNECT.
• Converted ORACLE data tables into SAS data files using SAS SQL and uploaded SAS data files into ORACLE tables using SAS DBLOADprocedure.
• Created SAS Data Entry Screens using the SAS FSP and View Table Utility.
• Developed numerous ad hoc SAS programs to create summaries and listings.
• Created SAS MACROS and SAS GRAPHICS. Customize the existing programs using SAS Macros as per the statistician's requirements
• Analyzed different drugs sales activity metrics and generated reports and graphical representation of these sales for comparison of different drugs using SAS/GRAPH and SAS/STAT. Used PROC LIFETEST and PROC GPLOT to create graphs in SAS.
• Used VBA to generate graphs automatically with data exported from SAS to excel
• Generated SAS Customized reports using the DATA NULL and PROC REPORT techniques.
• Created survival graphs in Excel by transporting SAS data sets into Excel spreadsheets.
• Created TEMPLATES to modify the appearance of the Displayed ODS Tables using PROC TEMPLATE.
• Extensively used PROC FREQ, PROC TABULATE, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC COMPARE andPROC UNIVARIATE.

Environment: SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/ODS, SAS/SQL, SAS/GRAPH, MS-Excel, PL/SQL, Oracle 8.0, HTML and Windows 2000.