Objective

SAS Programmer with over six years of experience in software development, design, analysis, coding, implementation, maintenance and support as a SAS Programmer/Analyst with profound experience in financial, telecom and .com industries.

SUMMARY

• A versatile SAS programmer with six years of professional IT experience in software development, system design documentation and implementation, as a SAS Programmer/Analyst with extensive knowledge in Banking, Telecom, and .com industries in different environments like UNIX, windows and worked with different databases like DB2, Teradata, Oracle and SQL Server
• Experience in developing different methods of Extraction, Transformation and Loading ETL into data warehouse
• Excellent understanding of data management principles, database design, data analysis, and data manipulation
• Experience working with SAS BI tools such as SAS Enterprise Guide, SAS Information Map studio, SAS Management Console, SAS Data Integration Studio, SAS Web Report Studio and SAS OLAP Cube Studio
• Extensive experience in data manipulation, data analysis, datavalidation,datacleansingand generating customized reports with SAS data steps, procedures and macros
• Proficiency in using SAS/ACCESS to import various external data files into SAS library, and extensively used SAS Proc SQL for advanced data query
• Experience in consumer credit risk analytics and statistical modelling including predictive credit modelling, credit decisioning strategies and credit dashboard analytics
• Thorough work knowledge of using ODBC to connect SAS System with relational database management systems to retrieve data and create SAS datasets
• Experience in developing routine codes with SAS Macro facility
• Solid knowledge of databases and ability to manage large volume data/database
• Proven ability in market segmentation by dividing customers into appropriate levels and recommending suitable techniques
• Proven ability in gathering customer behavior data from a wide variety of data sources to identify actionable insights for improvement
• Performed a crucial role in gathering report requirements and preparation of the report design documents
• Met scheduled timelines for all projects, in an effort to be efficient while applying business solutions for the client
• Experience in resolving customer problems, ticket issues and troubleshooting support problems
• Confident, self-motivated and a team player. Self-oriented with analytical skills

WORK EXPERIENCE

SAS Programmer

Confidential

• Possess thorough understanding of banking or financial domain with respect to real estate /re credit risk data i.e. forecasting risk experience and collection risk, collectively default credit risk
• Analyzed various loss mitigation solutions i.e. Options to retain home
• Followed federal financial institutions examinations council ffiec guidelines for real estate equity analysis EA calculation and loss recognition
• Worked with short sale, deed in lieu data, bankruptcy data, and foreclosure sale data
• Used net available equitytool to estimate property's equity calculation and estimate impacted processes
• Performed SAS/SQL coding
• Wrote code, validated. Verified other team members code for accuracy as a part of data validation and data migrationproject
• Worked on validating an old database against new reporting database
• Old database was initially used by consumer real estate portfolios in a centralized location using standardlized naming conventions and credit related metrics.
• Worked with different portfolio data within the old database including wfhm, wfhe, wfhmsa, wff, wfnl, wbr,Wells FargoWealth as indicator flags
• Understood financial business requirements and translated them into sas coding, validations and control
• SAS, SAS/EG, UNIX, PROC SQL
• Worked independently with minimal support
• Calculated state wide differences between severity wfhe data to analyze state distribution of base population
• Worked extensively with pivot tables for data analysis
• Passion for learning and innovating new methodologies in the intersection of applied math/probability/statistics/computer science.
• Proficient at translating unstructured business problems into an abstract mathematical framework
• Environment:SAS 9.3,SAS/EG 5.1,SAS ETL, Oracle, db2,SAS/ACCESS, Teradata client 13.11,MS SQL server, WIN 7 ,Enterprise 64 bit, Linuxboks 6.5

SAS Programmer/Application Developer

Confidential

• Worked with FedEx marketing team combined with analytics to analyze, combine technical expertise and use that to drive improved value for customer and corporation.
• Worked with Marketing team in developing the html based Web reportsusing SAS with Unix
• Alliance Marketing team at FedEx would provide a single point of contact to the company who can understand business and can develop solutions to meet needs of the company. This provides more effective and timely support for the requests
• Developed web-pages which refreshes the data automaticallyfrom time to time when updates take place
• Knowledge of web-development JAVA Script, PERL, HTML
• Experience with Oracle and Teradata databases
• Gained experience on Marketing/Sales data and developing the reports related to marketing
• Involved in data analysis and data cleansing
• Pulled data from databases, analyzed it in SAS and published it to web pages
• Used shell scripts to automate the whole process andPerl/HTML to publish it on to the web site
• Used CGI or JavaScript which is part of SAS UI framework
• Understood and worked on the company's internal website/ Dashboard: Querying the backend data to populating the tabular columns and graphs on the website
• Developed graphs and tables using SASand published them onto the Html page based on drop down selections
• Made several changes to the website including adding tags, drill down links using SAS and drop down lists using CGI/PERL
• Created pie charts using PROC Gchartand displayed tables containing information from SAS datasets on the website
• Worked on SAS macros, created drop down lists with selected functions and drilldown links
• Changed fonts, headings and CSS styles in dashboard
• Worked on monthly refresh of data on Dashboard by running backend and frontend queries
• Tested webpages and maintained quality control to make sure correct data is being populated

Environment:SAS 9.2, SAS EG 4.3, SAS ETL, Toad for Oracle 9.7.2, SAS/Access, Teradata, Microsoft Office, SOLARIS, Windows

SAS Programmer

Confidential

Responsibilities:

• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in UNIX environment
• Extracted, transformed, and loaded data using SAS
• Planned, designed and executed marketing campaigns using Unica Campaign tool
• Designed criteria, developed algorithms and written code and executed campaign using SAS code and SAS tools
• Used SAS EG for quick slice and dice on the files created by Unica tool before doing reporting and analysis
• Involved in frequency reporting and analysis on campaign generated output files with a help of third party reporting tool
• Used SAS Web Report Studio extensively to generate web based reports. Ensured the validity and accuracy of the analyzed data.
• Defined requirements for the development of the exception reports and monthly performance reports.
• Assisted Business User in identifying new requirements and recommended enhancements.
• Modified the existed macros accordingly to the current requirements and made them concise and reusable.
• Converted Oracle data tables into SAS data files using SAS SQL Pass through Facility.
• Moved data sets across platforms from PC to UNIX and Vice Versa .Developed and exported the SAS data to Excel pivot tables.
• Raised queries on the existing Oracle and SQL Server databases to provide ad-hoc reports using SAS/SQL.
• Involved in the development of different datasets according to the user specifications for various applications.
• Extensively used SAS/ODS to generate HTML and PDF reports
• Submitted SAS/SQL Queries in UNIX shell to validate data
• Coordinated with the other teams to deliver the data to the clients on time.
• Documented all programs, files and variables for accurate historical record and for future reference

Environment:SAS/BASE, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, SAS/ODS, SAS EG, SAS Web Report Studio, Oracle, SQL Server, Unica Campaign Tool, VB, MS Access, UNIX.

SAS/ Statistical Analyst

Confidential

Responsibilities:

• Worked with marketing and related departments to develop required applications using SAS/STAT and SAS/MACRO
• Performed complicated analysis including customer retention analysis and portfolio performance tracking
• Credit card direct marketing analytics, marketing campaign strategies development, and predictive modeling.
• Developed several SAS macro platforms to extract, process, and analyze customer and account-level data across various databases
• Presents extensive time-seriesfor any cohort of booked credit card accounts or customers
• Engaged in various marketing programs including customer loyalty, attrition, and promotion offer structure
• Applied advanced statistical analysis including linear and logistic regression, cluster, and ANOVA
• Analyzed CRM patterns over time, provided strategic recommendations, presented and communicated analytical results to clients

Environment:SAS/BASE, SAS/Connect, SAS/Intrnet, Humming Bird V9.0, Exceed, Excel, DB2, UNIX AIX , Windows

SAS Analyst/Developer

Confidential

Responsibilities:

• Interacting extensively with end users on technical analysis and documentation
• Involved with key departments to analyze areas and discuss the primary model requirements for the project
• Familiar with data mining process using SAS SEMMA sample, explore, modify, model and access scheme and report writing using SAS Enterprise miner
• Involved in credit risk assessment modelto calculate risk factor for individual clients based on hierarchy
• Wrote complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools SAS/BI and also developed ad-hoc reports using SAS Enterprise Guide
• Developed Income statements Balance sheets in MS Excel
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Created reports in the style format RTF, PDF and HTML using ODS statements and PROC TEMPLATE
• Performed Consumer profiling, Sales forecasting and testing of financial and business models
• Effectively prepared and published various performance reports and presentations

Environment: SAS/BASE , SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Business Intelligence, SAS Enterprise Guide, SAS Enterprise Miner, SAS Web Report Studio, SAS Data Integration Studio, SAS Information Map Studio, SAS Management Console, SAS OLAP EBI Server, Teradata, DB2, ORACLE, SQL Server Windows XP