Venkateswarlu Bollu
SAS Programmer
ezvenki@yahoo.com
510-248-4101
Billing Rate:$70/hr 

SAS Certified Professional Version 8

Experience Summary
SAS Programmer/Analyst with over 6+ years of experience with SAS system. 6+ years of programming/analysis experience in SAS on the MVS, UNIX and Windows platforms. Created Financial and Retail Modeling Datasets. Used the procedures SQL, TABULATE, FREQ, FORMAT, and GRAPH to generate modeling reports. Generated daily, weekly and monthly reports using Proc Report and SQL. Strong SAS programming background for maintaining existing code, ad hoc reporting and supporting the reporting functions. Additional experience includes using Base Procedures, Graph, Macros, Data Step, SQL, CRM, Data Mining, extracting internal/external data including cleaning and validation, use of formats and informats. Involved extensively in Data Extraction, Transformation, Loading, Analysis, MIS Reports for Banking. Involved in generating reports on Logon indicators, cbol customers, Transaction Summary, Email address Collection, E-DMs, E-statement Enrollment, Internet Application, New to Bank Customers via Online Channel, IFT & Online Fund Transfer, Online Templine Increase and Reward Redemption, Revenue, Alerts, AVR & CPO, ATM, CDM for Banking. 
Technical Skills Inventory:
Operating Systems: Personal computers/ Microsoft 
                                  Windows (XP, 2000, NT), MS-Dos, 
                                  Unix, MVS.
Databases 	       : Oracle SQL, Access, Oracle, Sybase, DB2,
                                SQL-Server, Teradata, Mainframes, MS- 
                                  Access        
Languages	       : C Language, Visual Basic
OLAP Tools	       : SAS/EIS, MS-Analysis services 2000
Data Warehousing: SAS/ Base, SAS/Access, SAS/Connect
		          SAS/Share, SAS/EIS, SAS/Stat 
		          (V6.1.2 & V 8.1)

Roles:

·	SAS Programmer
·	Programmer Analyst

Industry Applications:

·	Financial
·	Pharmaceutical
·	Telecommunications

Education:

·	University Masters Degree.
·	Post Graduate Diploma in Computer Applications
·	Certificate Course in Oracle 9i from SSI.

Certifications:

·	SAS Certified Professional V8 (SAS/Base)
        
EXPERIENCE SUMMARY

PROJECT DETAILS

1.INDUSTRY	Banking
CLIENT	Wells Fargo Bank
DURATION	Feb 05 - present
ROLE	Sr. Programmer /Analyst
LOCATION	 MN

DESCRIPTION OF THE PROJECT

Wells Fargo Bank provides a comprehensive range of financial services; personal financial services; commercial banking; corporate, investment banking and markets, private banking and other activities. I was involved in performing complex analysis  that maximizes profits and/or asset growth and minimizes operating losses. I was also involved with the update and maintenance of the Data warehouse and generation of various reports. Data is loaded from database into SAS datasets, and Reports were generated. The system maintains the company income and expenditure details and it also generates detailed reports regarding financial transactions, sales details, and purchase details, operating costs.

Responsibilities

·	Understanding the Business and its Requirements
·	Gathering the requirements from user
·	Creating Channel MIS Reports
·	Extraction of data from Data Ware housing tables
·	Modifying data using SAS/BASE and Macros.
·	Preparing graphs using he modified data for business analysis
·	Creation of Data Sets on the Remote server.
·	Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
·	Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
·	Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
·	Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.

Environment: Base SAS, OS Windows, SAS/SQL, SAS/GRAPH, MS Excel, Unix10, database Oracle, TOAD.


2.INDUSTRY	Banking
CLIENT	First USA Bank
DURATION	Jan 04 - Dec 04
ROLE	Programmer/Analyst
LOCATION	Wilmington, DE

DESCRIPTION OF THE PROJECT
First USA Bank provides a comprehensive rage of financial services; personal financial services; commercial banking; corporate, investment banking and markets, private banking and other activities. I was involved in Mainframes Performance Reports, Capacity planning and Analysis and generated reports for online and batch applications for various servers. Used SAS system as front end tool to create datasets from MF datasets and used SAS/GRAPH to create charts showing MF performance. Monitored and Analyzed Bank and Cards application usage on MF. Data Tables, reports and OLAP results on account/household values and customer profiles are obtained by merging and summarizing data using SAS.

Responsibilities:

·	Maintained Mainframes Performance Reports.
·	Created reports for online and batch applications for various servers.
·	Modified data using SAS/BASE and Macros.
·	Prepared graphs using the modified data for business analysis.
·	Creation of Data Sets on the Remote Server.
·	Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
·	Extracted data sets from MF server using PROC CIMPORT and created datasets in SAS libraries.
·	Coding SAS programs with the use of SAS/BASE and SAS/Macros for ad hoc jobs.
·	SAS scripts on MF are run, and the output datasets are exported into SAS.
·	Created charts showing MF performance using SAS/GRAPH.
·	Monitored and Analyzed Bank and Cards application usage on MF. 
·	Maintained and enhanced existing SAS reporting programs for marketing campaigns.
·	Maintained SAS statistical analysis for the products purchased every month.
·	Run reporting programs and download the results into EXCEL and build pivot tables. 
·	Presented the results and statistical reports in PowerPoint for marketing staff.  
·	Moved data set across platforms (from PC and Mainframe to UNIX and Vice Versa).

Environment: IBMS/390 and IBM compatibles, MVS, BASE SAS, SAS/ MACRO, SAS/ SQL, SAS/ STAT, SAS/CONNECT and SAS/ACCESS, DB2, Sybase.


3.INDUSTRY	Health Care-Pharma
CLIENT	Bristol-Myers Squibb
DURATION	Oct 02 - Nov 03
ROLE	Programmer/Analyst
LOCATION	NJ 

DESCRIPTION OF THE PROJECT

BMS is a Biopharmaceutical company developing products designed to improve the safety of the world’s health in Oncology and is conducting Phase III clinical trials. As a SAS Programmer, my role was in analysis of clinical trials data and generating required reports, listings, summaries and graphs for submission to FDA and other regulatory authorities.

Responsibilities:
·	Successfully designed and implemented statistical reporting processes for regular data collection and clinical data analysis. Analyzed Phase I, II and III Clinical Trials. 
Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
·	Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
·	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 and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
·	Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission; Participated in preparing study results as well as ISS and ISE for FDA submissions using SAS.
·	Attended project team meetings, worked with Bio-Statisticians, Data Managers, and Clinical Research Managers as appropriate. Reviewed and provided feedback for Data Integrity Plans.
·	Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
·	Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
·	Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.

Environment: Windows 2000, SAS 8.2, SAS/Macro, SAS/STAT, SAS/ACCESS, Enterprise Miner, SAS/CONNECT, SAS/ODS, SAS/SQL, Oracle.



4.INDUSTRY	Investment (System for Marketing Analysis)
CLIENT	Joseph Investment South
DURATION	Aug 01 – Sep 02
ROLE	Programmer/Analyst
LOCATION	Chicago, IL

DESCRIPTION OF THE PROJECT
Joseph Investment South is a global asset management firm offering new investment techniques and smart business practices to the money management industry. I was involved in the development of programs and applications using SAS for data extraction and performed statistical analysis to aid in marketing and financial decisions. 

Responsibilities: 
·	Involved in extracting, analyzing and auditing marketing data from the data-warehouse using SAS.
·	Participated in marketing campaign-planning meetings with program managers in order to develop and document campaigns specifications. 
·	Created SAS data sets by extracting data from Oracle tables using SAS/CONNECT and SAS/ACCESS. 
·	Used TOAD features to connect to multiple databases for comparing views and checking syntax errors in the PL/SQL stored procedures for performance tuning and quality control. 
·	Developed scripts, procedures and applications to generate sophisticated ad hoc reports using SAS/EIS and SAS/AF. 
·	Worked with Marketing and Financial departments to develop required applications for performing complicated analysis like customer retention analysis, identifying cross-sell opportunities, portfolio performance tracking, calculating moving averages etc. 
·	Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data, preplanning and doing ad hoc joining of multiple Oracle views. 
·	Generated SAS/ MACROS and several PL/SQL stored procedures for reusability and to minimize data processing.
·	Wrote stored procedures for specific analytic reports 
Wrote large aggregation SQL queries using in-line views 
·	Ran SAS report programs and downloaded the results into Excel for data analysis. 

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/QC, SAS/STAT, SAS/GRAPH, SAS/EIS, SAS/AF, SAS/PC, UNIX, PL/SQL, Oracle 8i.

5.INDUSTRY	Laboratories
CLIENT	Cipla Laboratories
DURATION	Sep 00 - Jun 01
ROLE	SAS Programmer
LOCATION	 India.

DESCRIPTION OF THE PROJECT
Worked with Non-clinical statistics unit of pharmaceutical company, developing computer programs to do the Statistical analysis of product sales, performance of sales department, regional sales, Monthly, Quarterly and yearly sales reports. The incentive compensation was taken care of in this project and the profit forecast was also done

Responsibilities: 
·	Extensively involved in Oracle PL/SQL programming to create Triggers, database Packages Procedures/Functions etc. Creation of database objects like Tables, Views, and Synonyms etc.
·	Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
·	Transferring and migrating data from one platform to another to be used for further clinical analysis. 
·	Extracted data from Oracle using SQL Pass through facility and generated ad-hoc reports. 
·	Prepared, documented and tested required programs and procedure data displays in an efficient manner for inclusion in integrated clinical, statistical summary reports and other reports. Supporting other team members in designing and developing programs. 

Environment: SAS V6.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, Oracle              7.3 and UNIX.

6.INDUSTRY	Telecom
CLIENT	Airtel
DURATION	Nov 99 - Aug 00
ROLE	SAS Programmer
LOCATION	Hyderabad, India.
DESCRIPTION OF THE PROJECT
Airtel is an organization offering cellular services with a wide network and huge customer base operating all over the country. This project involved integration of data from diverse databases, which stores data for individual calls. Warehouse was developed to store cleaned and integrated data to view the customer information of the organization in different dimensions using SAS/EIS Tool.

Responsibilities:
·	Understanding the business requirements and end-user needs.
·	Developing code for star-schema and MDDBs.
·	Deploying data mart and decision support systems.
·	Implementing physical models using Oracle database.
·	Creating MIS channel reports for business analysis.

Environment: SAS V6.2, BASE SAS, SAS MACROS, SAS/ACCESS, SAS/EIS, SAS/MDDB, SAS/SQL, SAS/GRAPH, MS Excel, Unix10, Windows NT