Resume

Sign in

SAS Analyst

Location:
Houston, TX
Salary:
Open
Posted:
September 10, 2008

Contact this candidate

Resume:

PRAVEEN GOVINDRAJ

678-***-****

OBJECTIVE:

To work for a reputed business organization that provides opportunities to utilize and enhance my technical skills and leadership qualities in order to solve organizational problems most efficiently using mathematical methods in operations research, statistics and information systems.

PROFILE:

Quantative Analyst with over 6 years of experience in statistical analysis, reporting and data management using SAS Software.

Strong educational background in Statistics with an emphasis in strategic problem solving, cost-savings objectives and long-range goals.

Experience in forecasting, risk management, customer segmentation, developing customer analytics and univariate and multivariate predictive modeling methods.

Experience with regression analysis, categorical data analysis, data mining, correlation analysis and analysis of variance on the data.

Experience working with various SAS products under multiple platforms such as UNIX, and Windows 98/00/NT/XP.

Well versed with Oracle and Teradata databases.

Demonstrated quick learning ability, strong analytical and good communication skills.

An outgoing personality, self-motivated, sincere, hardworking, ability to work independently or cooperatively in a team.

TECHNICAL SKILLS:

Statistical Software: SAS 8.x, 9.x (Base SAS, SAS/DI, SAS/BI, SAS/STAT, SAS/ETS, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS).

Programming Languages: mySQL, PL/SQL, Visual Basic, C, C++, Java, Lindo, Lingo, ModL, ampl, cplex, HTML & XML.

Software Packages: MS Office (Word, Excel, PowerPoint), MS Project 2000, Matlab, SPSS, Minitab, Precision Tree, Queryman, Toad.

Operating Systems: DOS, Windows 9x/NT/2K/XP & UNIX.

Databases: Teradata, Oracle 8/9i/10g & Sybase.

EDUCATION:

Stanford University Stanford, CA Autumn’05 – Summer’06

Certificate in Quantitative Methods for Finance and Risk Management.

Arizona State University Tempe, AZ Fall’04 – Fall’05

Six Sigma Black Belt Certification Program

Arizona State University Tempe, AZ Fall’00 – Fall’01

M.S, Industrial Engineering, Specialization in Operations Research. Graduated in Aug’02.

Mangalore University Mangalore, India Aug’93 – Jul’97

B.E, Industrial Engineering. Graduated in Feb’98.

WORK EXPERIENCE:

Reliant Energy, Houston, Tx. Mar’ 08 – Present

Senior Marketing Analyst.

As a consultant in the analytics and forecasting department, I am involved in data analysis and providing analytical support to different forecasting processes within the group. The analysis is done mainly by using SAS and Excel.

Responsibilities:

Create AA curves.

Generate adhoc reports.

Create tranche tracking reports.

Perform attrition rate and usage analysis.

Provide programming support for True-up and supply position tracking.

Automation of credit sleeve reporting.

Post campaign analysis and response rate analysis across campaigns.

Perform customer conversion and enrollment analysis.

Value at risk reporting and its automation.

Calculate attrition differences among customers along dimensions like tenure, length of residency, value segment and so on.

Environment: Base SAS 9.1.3, SAS/SQL, SAS/ODS, SAS/Macros, MS Excel, IBM AIX, Oracle, Windows NT.

FedEx Corporation, Memphis, TN. Feb’ 06 – Mar’08

FedEx Corporation is the premier provider of shipping and information services worldwide in over 100 countries.

Senior Marketing Analyst.

As a consultant in the forecasting department, I was involved in data analysis, developing forecasting models and providing analytical support to different forecasting teams. The analysis is done mainly by using SAS.

Responsibilities:

Yield decomposition analysis.

Developed model in SAS for new business analysis.

Developed forecasting models for different variables.

Automated Sales & Forecast reports using SAS/DI & SAS/BI.

Performed PFE, CFaR & VaR analysis on fuel and fuel surcharge revenues using SAS/RD.

Developed SAS programs which create weekly guess report sent to the finance department.

Automated the Ground forecasting weekly guess process used in the weekly revenue reports sent to higher management.

Perform ad-hoc analysis for different business requirements of FedEx.

Use Time series analysis and SAS/STAT to analyze the existing data and generate reports, tables, listings and graphs at regular intervals for business decision making.

Perform analysis of various business units using mathematical and statistical methods to increase the customers, sales volume and overall performance of the business.

Perform customer segmentation analysis.

Performed exploratory data analysis by pulling data from Oracle and Teradata databases to assess shipping trends.

Wrote UNIX shell scripts to automate processes.

Maintain processes needed for updating websites on a regular basis using SAS, PERL, CGI and JAVA.

Extensively use various SAS procedures, like Proc Print, Proc Report, Proc Summary, Proc Freq, Proc Tabulate, Proc Mean, Proc Univariate, Proc Transpose, Proc Rank and Proc SQL for analysis.

Co-ordinate in the development and maintenance of processes that provide data for generating forecasts and strategic planning at higher level of management.

Improved operational efficiencies and effectiveness.

Environment: SAS 9.1.3, SAS/DI, SAS/BI, SAS/MACROS, SAS/BASE, SAS/ODS, SAS/SQL, ORACLE, TERADATA, UNIX, Shell Scripts, MS Excel, Windows NT.

Triumph LLC, Tempe, AZ. Jul’02-Jan’06

Triumph LLC is a second tier supplier of automotive parts to the American, European & Asian auto Industry. Some of Triumph’s customers are TRW, Ford, Delphi, Eaton, Visteon, Husco, Siemens etc.

Data Analyst.

The job involved data analysis and creation of reports by extensive use of SAS products. It involved design and development of reporting systems to analyze statistical parameters for quality, production and sales.

Responsibilities:

Used Statistical Experimental Design, Response Surface Methods, Statistical Modeling, Generalized Linear Models and Data Mining to minimize risk.

Used categorical data analysis in raw material quality surveys.

Developed predictive models using linear regression, logistic regression ARIMA forecasting and decision trees by analyzing time series data on current processes.

Developed data collection tools such as process maps, flow charts, C&E/Fishbone, run charts and Pareto charts for measuring current work standards and Gantt charts for operator scheduling

Developed capability analysis of various processes using Indices such as Cp and Cpk. Conducted time studies for run at rate determination used in machine capability analysis.

Used quantitative tools to determine optimal quantity to pack by using linear and non linear optimization.

Performed capacity analysis for labor and machines.

Developed financial reports for management.

Performed business analysis and data flow processing.

Provided financial reports and presentations.

Used SAS procedures and prepared daily, monthly, yearly reports.

Presented complex analytical and technical information to senior management or to other business staff.

Interacted with the vice president, managers, modelers and analysts to develop control parameters.

Created accurate forecasts, budgets and simulations by developing an understanding of costs and profitability of products, processes and customers.

Environment: Base SAS 8.2, SAS/SQL, SAS/ODS, SAS/Macros, MS Excel, UNIX, Oracle 8i, HTML, Windows NT.

BEML, India. May'98-Jul '99

Bharath Earth Movers Ltd is the second largest manufacturer of earth moving equipment in Asia. Its earth moving equipment is used in mining, construction and road building.

Programmer Analyst.

As a programmer analyst, I was involved in writing programs using SQL and VB to generate manufacturing, marketing and financial reports. The data was also analyzed to understand and meet business process requirements.

Responsibilities:

Gathered end user information to provide appropriate solutions.

Developed testing procedures for both new and enhanced functionality.

Compiled and wrote documentation of program development and subsequent revisions.

Involved in documentation of design, code and reports of the projects.

Coded and debugged new and existing programs.

Wrote SQL queries in SQL*plus.

Extracted data from existing data stores and performed ad-hoc queries.

Worked with large and complex databases containing millions of records.

Created Views from tables in databases using SQL*plus.

Made changes to visual basic functions to modify customized applications.

Analyzed and generated manufacturing, marketing and financial reports using data in Oracle databases.

Analyzed data to arrive at specific and crucial information for the organization.

Analyzed marketing data to improve operational efficiencies and effectiveness.

Created html reports for higher management.

Regularly interacted with the marketing and financial analysts for the presentation of reports.

Developed and executed departmental data for performance and response purposes.

Developed and executed technical processes for marketing programs and tests.

Environment: Oracle 8, SQL*plus, VB, HTML, Windows NT.



Contact this candidate