Data Sas
Resume:
RAVINDRA VUGGILI
*********@************.***
RAVINDRA
VUGGILI
________________________________________________________________________
Experience Summary:
. SAS certified professional with 6+ years of professional experience
in working with SAS with strong emphasis on SAS programming for
reporting, modeling, data analysis, and data mining, Risk
management, Marketing, and Financial departments of large
enterprises.
. Extensive experience in working with Base SAS (MACROS, Proc SQL,
ODS), SAS/ACCESS, and SAS/GRAPH in UNIX, Windows environment.
. Cognizance with data creation, extraction, cleansing, manipulation,
transformation, exploration, summarization and visualization.
. Highly efficient using SAS Enterprise Guide, SAS 9.2 & SAS
Enterprise Miner, writing and debugging complex programs.
. Familiar with inferential statistical analysis like Hypothesis
tests, Logistic/Multiple Regression analysis.
. Excellent knowledge in Predictive Modeling i.e., translating
business problems into analytical models such as Regression,
Decision tree & Neural Network models.
. Extensive predictive/statistical modeling experience retrieving,
manipulating, matching/merging and analyzing large data files.
. Strong C, C++, Base SAS, Advanced SAS programming features like SAS
Macros, Data Steps, Proc Steps, Proc SQL, ODS, SAS Arrays and
generate tables, listings, figures and also advanced MS Excel
skills.
. Proficient with relational database concepts such as SQL, MS Access
and reporting using SAS.
. Experience in working with multiple databases like Oracle, DB2,
Sybase, and Teradata.
. Experience in using SAS to import/export data to external file
formats like flat, Excel, XML files
. Thorough knowledge in SAS Programming, using Base SAS, Macro
Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and
ODS facility in data scrubbing, manipulation, and preparation to
produce summary datasets and reports
. Followed System Development Life Cycle (SDLC) methodology for the
design, development, implementation, and testing of various SAS
modules
. Thorough knowledge and experience of Microsoft Office tools like MS
Access, MS word, MS PowerPoint, and MS Excel
. Energetic self-starter with excellent analytical, organizational,
quantitative research, mathematical analysis, attention to detail,
problem solving, critical thinking and reporting skills.
. Capable of handling multiple tasks, manage multiple projects being
flexible and responsive, and translating key business findings and
insights based on data analysis.
. Enthusiastic learner of new technical tools and software
applications, and present ideas in a clear and concise manner to
senior management.
. Ability to work in high speed, hectic environment with a sense
towards urgency and prioritizing responsibilities by working
independently but also cohesively in the team with positive
demeanor executing analysis plans, meeting the deadlines.
. Exceptional verbal and written and strong communication skills in
particular explain complex technical concepts and applications to
both technical and non-technical audience at ease.
Technical Skills:
SAS Tools SAS V9.x /8.x, Base SAS, SAS/SQL,
SAS/Macro's, SAS/Stat, SAS/
Graph, SAS/Report, SAS/ODS, SAS Enterprise
Guide, SAS Enterprise Miner
Databases Oracle, DB2, Teradata, Sybase and MS Access
MS-Office Tools Word, Excel, Power Point, Visio,
Project
Software XpressMP, Gurobi, System Architect, MATLAB,
Simio
Operating Systems Windows XP/2000/2003, UNIX and Linux
Programming Languages C, C++, SQL
Certifications:
. SAS OSU Data Mining Certificate
. SAS Certified Advanced Programmer for SAS 9
. SAS Certified Base Programmer for SAS9
Education:
Bachelor of Engineering in Electrical and Electronics, Osmania University,
INDIA
Work Experience:
Capital One Bank, Plano, TX
Jul'09 - till date
SAS Programmer/ Analyst
The project uses SAS and Teradata database to conduct statistical analysis
and to create data mining solution that allowed the bank to develop
advanced models for better consumer loan providing and recoverability and
to determine marketing strategy. Running modeling programs using SAS,
SAS/Stat, SAS/Access, SAS/SQL, SAS/Macro, and SAS/Graph for the Consumer
Lines & Loans Processing.
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 up to 3 years to check the same
month's 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/Connect, Windows XP professional, UNIX, Teradata
MasterCard, St. Louis, MO
Apr'07 - Jul'09
SAS programmer
MasterCard operates one of the world's largest retail electronic payments
network and is one of the most recognized global financial services brands.
Responsibilities included providing subject matter expertise to the VAS
team while developing more statistically advanced analyses using the SAS
software. Manage large datasets and capture specialized technical knowledge
reducing costs on external providers. Develop methodologies and analytical
models in order to identify business opportunities and optimize the
profitability of the payment system.
Responsibilities:
. Perform 'Invest' level bank-specific analysis on large data sets
including proprietary information, such as customer demographics,
activity, spend levels and financial information.
. Develop analytic production and ad hoc requests/reports to be used in
credit card activation and usage decision making.
. Evaluate analytical findings to ensure accurate interpretation of data
and development of meaningful data mining results.
. Interpret business and statistical analysis to the team of consultants
for use in decision-making
. Defining ways to organize several sources of information in order to
support the business opportunity identification process for client
banks in Latin America.
. Responsible for client-specific transactional data analysis, such as
point-of-sales and ATM transactions, sales volume and profitability
and performance indicators for debit and credit card programs.
. Identify relevant market trends by country, based on a deeply analysis
of payment industry information in Latin America.
. Analyze and mine multiple client data to select statistically valid
data samples, build, test, and implement predictive models by
investigating appropriate methods and algorithms.
. Engage in quantitative analysis on many non-standard and unique
business problems using computer-intensive data mining techniques
(decision trees, neural networks, clustering, etc.) to deliver
actionable output.
. Identify the most relevant criterion to segment individual customer
bases for client banks in Latin America. Develop statistical modeling
including: Chaid, Discriminant Analysis, Cluster Analysis
. Logistic Regression to capitalize business opportunities of
activation, usage and retention for strategic clients.
. Responsible for internal development of new consulting services in
coordination with team consultants based on needs basis.
. Enhancement of the current consulting offering through the development
of more statistically advanced analyses using specific data-mining
tools such as SPSS, SAS software.
. Responsible for providing the consulting team with data preparation,
data analysis and statistical modeling using SAS as a primary tool.
. Execute data crunching, write codes, merge/purge/ and split data, and
do ad hoc queries/cut data programming in SAS
. Create and consolidate reports using several internal and external
sources through the development of standard macros.
. Generate codes in order to develop and deliver current business
solutions through the automation of consulting processes, providing
ideas to create more efficiency within the team.
. Data preparation, cleaning, manipulation, and visualization. Extract
data from relational databases and perform complex data manipulations.
Conduct extensive data checks to ensure data quality.
. Develop, update, and maintain current SAS programs using SAS tools for
Windows in a user support environment.
. Work with team members to understand market and client specific needs
for development of new consulting solutions or refinement of existing
services.
. Present and communicate results of data mining efforts in a manner
consistent with the target audience and business needs.
. Document all SAS programs developed and write other documentation as
needed. Identify and share best practices for key topics.
. Responsible for transfer of technical knowledge to facilitate
implementation of the business solution provided.
. Contribute ideas within the team in order to identify profitable
opportunities for the Key banks and key Markets.
Environment: SAS 9.2, SAS/BASE,SAS/MACRO, SAS/ODS, SAS/Connect, SAS/ACCESS,
SAS/STAT, SAS/SQL, SAS Enterprise Guide, MS-Access, MS-Excel, ORACLE,
Windows XP, Visual Basic
HDFC Bank, India Jun'05 - Mar'07
SAS Programmer
HDFC Bank is the leading bank company in India. Responsible for acquisition
modeling in the emerging markets of India. As it was not easy to buy
geographical and demographic data In India, customer data was built
internally by gathering demographics and general information of card
members pertaining to diverse products to extract information about
solicited and non-solicited responders over a period of time. Compared and
analyzed trend and related information from this data to create customer
SAS datasets and flat file for modelers. These datasets were used for
capturing new customers through direct mail and telemarketing
Responsibilities:
. Created SAS datasets from Oracle database with random sampling
technique and created Oracle tables from SAS datasets by using SAS
Macros
. Created large datasets by combining individual datasets using various
inner and outer joins in SAS/SQL and dataset merging techniques of
SAS/BASE
. Analyzed data using various statistical Procedures like PROC SUMMARY,
PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
. Used SAS/Macro facility to create macros for statistical analysis,
reporting results and data extraction
. Proposed a set of action plans to mitigate the risks identified with
the sourcing decision
. Generated HTML, Listings, EXCEL and RTF reports for presenting
findings of various statistical PROCEDURES using PROCEDURES like PROC
REPORT, PROC PRINT, PROC FREQ and also SAS ODS
Environment: SAS/BASE 8.2, SAS/ACCESS, SAS/GRAPH, SAS/MACRO, SAS/ODS,
SAS/SQL, SAS/STAT, SQL, ORACLE
Contact this candidate