SAS Programmer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

RUBY VUGGILI
ruby@sreeinfotech.org

512-275-9876

                                                              RUBY  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

Download Resume Format