SUMMARY

• SAS Certified Base Programmer.
• SAS Certified Advanced Programmer
• 6 years of Analyst/Programming experience in data extraction, data processing, data management and data analysis using SAS,SQL in Oil, Energy and Health Care industries in Windows and Unix environments
• Solid understanding of SAS/Base, SAS/Graph and SAS/Stat, SAS/Access, SAS/Macro and SAS/ETL with proven skills in data extraction, coding, testing, problem solving and reporting.
• Experience in Analysis of large volume of data billions of data , forecasting data, creation of dashboards and reports.
• Excellent work experience in generating listings, tables, figures and validation according to the Statistical analysis plan SAP and Company's Standard Operating Procedures SOPs .
• Experience in generating output files in RTF, HTML, and PDF format using SAS ODS.
• Proficient in writing Macros and also using in-house macros for creating reports and listings.
• Excessive use of SQL queries, stored procedures to retrieve and analyze the SQL server data.
• Experience in Data Warehouse, ETL, SQL QUERIES.
• Experience in SAS tools like SAS Enterprise Guide, ETL studio etc.
• Experience in Accounting, Auditing financial forecasting, budgeting etc.
• Knowledge of data warehouse, database design,OLAP,OLTP systems
• Excellent verbal and written communication skills.

SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Position: SAS Analyst

Responsibilities

• Prepare the pricing files for each campaign as per campaign guidelines and explain the pricing details in pricing meetings.
• Use SQL queries to extract data from Oracle, DB2 Databases.
• Use Excel Macros, VLOOKUP to analyze the past campaign data to calculate future demand.
• Develop statistical models to forecast the annual and total KWH demand for each campaign.
• Use data NULL , SAS PROC, SAS SQL, SAS ODS and sas functions to analyze data and create reports.
• test the quality of data.
• Using SAS procedures and functions to analyze the large datasets, create testing macros to
• Extract and analyze the market data using SAS and Excel tools and create reports.
• Analyze the forecasted flow load using Proc Reg, based on current demand and past data.
• Prepare the Attrition dashboard for each month mid-market data of different products
• Prepare Number of meters and volume data of mid-market.

Environment: SAS 9.3, Oracle Database, Windows/Unix SAS/Macro, SAS/Graph, SAS/Miner, Unix, MS Access, VBA,MS Excel 2010, SQL 2005

Confidential

Position: SAS Analyst

Responsibilities:

• Reading Haver Database using haver data engine and creating dataset on daily,weekly,monthly and yearly basis, Extracting and Loading data from different databases.
• Cleaning the data and produce excel, PDF reports and update the Chevron official website.
• Use SAS ETL tools to extract and load data into sas from various resources.
• Participate in data forecasting using PROC reg, univariate etc with Statisticians and creating graphs gplot, sgplot, gchart using Dashboards. And compare actual data with forecast data.
• Extensive use of Proc Sql, data NULL , Proc Report, Proc Tabulate, Proc Means to clean data and generating reports.
• Extensive use of EXCEL Spread sheets to calculate data and create reports.
• Attend the weekly meeting, present the progress of project and recommend suggestions etc.
• Create technical and functional documentation of each process

Environment: SAS 9.2, Oracle Database, Windows SAS/Macro, SAS/Graph, SAS/Viewer, Unix, MS Access, MS Excel, SQL Server 7.0, Oracle v8.x

Confidential

Position: SAS Programmer/Analyst

Responsibilities:

• Worked as a SAS Analyst/programmer for Rate Case Data Project and transformed CNP Large Commercial and Industrial LC I 15-minute interval data billed data into aggregated hourly loads by CNP Center Point rate classes SVS, SVL, PVS, TVS .
• Extracted data from Oracle ,COBOL and created SAS datasets.
• Read 15 minute interval raw data text files and created SAS datasets.
• Created value-added analysis datasets by defining new variables from raw datasets.
• Extensively used PROC SQL to extract data from multiple tables to pull the customer premise information.
• Moved SAS jobs from Mainframe to UNIX server and modified and enhanced the codes to execute in UNIX platform.
• Employed statistical knowledge to develop relevant descriptive statistics of customer usage, payment history and other characteristics used to segment customers.
• Extensively used Data null to create ad-hoc and customized reports.
• Worked in production support for Rate Case Data Project on UNIX Systems.
• Effectively analyzed massive amounts of residential, commercial and industrial customer data.
• Understood the business requirements and worked on Adhoc-Requests for Residential, Large Commercial and Industrial billing data.
• Create energy demand model and report using SAS Enterprise Miner.
• Prepared technical and functional documentation of each process.

Environment: SAS 9.1, Oracle Database, Windows, UNIX-AIX, Mainframes, Humming bird Connectivity, TOAD, EXCEED.

Confidential

Position: SAS Programmer

• Provided SAS programming for multi-study clinical projects support for various clinical studies, worked closely with statisticians to support the analysis of Clinical studies in various phases.
• Used SAS/GRAPH, SAS/BASE, SAS/SQL, SAS/MACRO, and SAS/STAT and other analysis software in producing tables, listings and figures for the statistical reports to be generated and submitted.
• Program outputs supported data reviews for the analysis, writing, testing, running, documentation and maintenance of programs to generate database s , SAS datasets, spreadsheets, data listing, tables, and graphical displays of data.
• Extracted data from Oracle MS Access database by generating database queries and imported data into SAS to prepare datasets for statistical analysis in UNIX platform.
• Performed SAS program validations and generated documentation for all external and internal deliverables.
• Employed ODS and SAS procedures to generate listings, tables and reports containing drug safety and efficacy data.
• Developed and implemented SAS programs and macros to produce descriptive statistics, statistical analyses, and graphics.
• Extensively used Proc Print, Proc Summary, Proc Report, Proc Tabulate, Proc Means, ODS HTML, PROC Transpose statements and SQL queries to generate listings, tables, reports and graphs according to requirement specifications.
• Created informative reports and documentation as per Standard Operating Procedures SOP's and FDA regulations.

Environment: SAS v9.0, SAS/Base, SAS/Macro, SAS/Graph, SAS/Viewer, Unix, MS Access, MS Excel, MS SQL Server 7.0, Oracle v8.x, Win2000