SAS Programmer with seven 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 over seven 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 Linux and windows
• 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 EG, 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 and generating customized reports with SAS data steps and procedures including Data _NULL_, Proc Datasets, Proc Format, Proc Contents, Proc Freq, Proc Transpose, Proc Tabulate, Proc Gplot, Proc Gchart, Proc Print, Proc Cimport, Proc SQL, Proc Summary, Proc Report
• Proficiency in using SAS/ACCESS to import various external data files into SAS library, and extensively used SAS Proc SQL for advanced data query
• Extensive experience and proficiency in using SAS ODS to create output files in a variety of formats including RTF, HTML and PDF
• Thorough work knowledge of using ODBC to connect SAS System with relational database management systems to retrieve data and create SAS datasets
• Extensive experience in developing routine codes with SAS Macro facility
• Solid knowledge of databases and ability to manage large volume data/database
• Proven ability in gathering customer behavior data from a wide variety of data sources to identify actionable insights for improvement
• Proven ability in market segmentation by dividing customers into appropriate levels and recommending suitable treatments or strategies
• Very good command in Data Analysis, validation,Cleansing, and providing helpful recommendations
• 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

TECHNICAL SKILLS

• Statistical Software: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/STAT, SAS/Access, SAS/CONNECT, SAS/ODS, SAS/Internet
• Database: Teradata, Oracle, DB2, MS-SQL Server 2000, MS Access
• Operating Systems: UNIX, MS Windows (95, 98, 2000, NT, XP), MS-DOS, MVS
• Languages: SQL, PL-SQL
• Web Development: HTML, DHTML, XML, JavaScript
• Development Tools: MS Office (Word, Excel, Power Point, Access)
• OOD Suites: Microsoft Visio, UML

EDUCATION

• Bachelors in Pharmacy.

SAS Programmer, Confidential, Los Angeles, CA May 2011- Present

• Extracting and concatenating data from internal and external resources, including demographic and credit variables and payment history, and frequently using SAS Macro, data steps and procedures including Proc SQL, Proc Cimport, Proc Sort, Proc Format, Proc Summary, Proc Export, Proc Transpose, ProcFreq, Proc Contents, etc.
• Created a process for transforming the different forms of raw data into SAS datasets
• Worked with multiple internal and external data analysis teams to understand data relationships
• Responsible for the system study, analysis, design, development, coding, generation of reports using SQL, PL/SQL, MS-Access, testing and documentation
• Extensively used SAS data steps and Macros in generating monthly delinquency reports for account management
• Working closely with project manager and making recommendations on to yield better results
• Ensured the validity and accuracy of the analyzed data
• Created Information Maps to feed Web Report Studio which generated reports
• Use SAS Web Report Studio to generate web based reports
• Used SAS BI and Microsoft Add-in to automate the standard reporting
• Created Stored Processes that would generate ad hoc reports based on parameters passed
• Automated lots of reports from the SAS EnterpriseGuide projects, Excel Spreadsheets etc.
• Used SAS/EG to design and develop code to support ad hoc requests
• Used SAS/ODS to produce RTF and generated HTML reports with CSS
• Extensive use of Procfreq, Proc Report, and Proc Tabulate for reporting purposes Analyzed the data, future trends and summarized results to generate meaningful recommendations to management

Environment:

SAS 9.2, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/STAT, SAS/EG, SAS DI studio 4.2, SAS Cube Studio, SAS ETL, SAS Web Report Studio, SAS OLAP, SAS Information Delivery Portal. Excel, UNIX (SOLARIS), Windows, Oracle, SQL Server, SAS/Access Oracle, SQL Server

SAS Programmer, Confidential, Atlanta, Georgia Feb 2010-Apr 2011

Responsibilities included analyzing customer behavior and credit data provided from Credit Bureaus and disparate loan systems, and developingcampaigning analysis reports in order to produce high quality loans for residential mortgages.

• Consulted with marketing and business staff to match customer needs with an appropriate loan program and level of risk
• Supported market segmentation in defining and delivering marketing lists necessary to develop effective marketing strategies and campaigns across multiple channels, customer segments, product/service lines, and geographic markets
• Performed data cleaning, data mapping and data conversion using SAS Date steps and procedures
• Used Base SAS, SAS/STAT and Macro facility to manipulate demographic, credit history and lifestyle data sets
• Identified and implemented business process to improve customer expectations.

SAS/ Statistical Analyst, Confidential, Bryan, TexasApr 2009- Jan 2010

Confidential, was one of the largest independent financial institutions in Texas. My responsibilities included collecting, mining, segmenting, analyzing, and maintaining critical customer information. I performed statistical analysis in supporting customer retention management.
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
• 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

SAS Analyst/Developer, Confidential San Francisco, CA Sep 2008– Mar 2009

With 22 years of experience, ZS is a global management consulting firm specializing in sales and marketing strategy, operations and execution. ZS is recognized for its expertise in go-to-market and sales force strategies and its downstream implementation capabilities. ZS helps companies achieve sales success by delivering both issue-specific solutions and large-scale business transformations.

Responsibilities:

• Client Interaction, Requirements gathering and Translation of business requirements into effective systems specifications for the development
• Designed and created PPT presentation of High level documents,Process flow diagrams and Project plan for the application
• Efficiently used various SAS tools like SAS/BASE, SAS/GRAPH, SAS/SQL to develop and process the call plan and the reports generated by Excel VBA macro for the entire Sales Force.
• Understand the Product-Market dynamics for Levoxyl Recent Physician behavior in Thyroid Market and finalize the key segmentation drivers for call plan
• Automated various QC reports by using the SAS tools namely SAS/STAT, SAS/MACRO and SAS/GRAPH and outputs generated on Excel
• Used SAS/MACRO facility to create macros for statistical analysis, results, data extraction, querying and reporting using PROC SQL
• Produced efficient large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE
• Design, Process flow diagrams and developed the Targeting and Sampling by creating various SAS Macros and SAS Formats to use across the systems
• Extensive usage of PROC SQL, PROC Report, PROC Freq, PROC Tabulate, PROC Transpose to generate monthly reports for the selective sales force of Sanofi Aventis also for all the Management levels
• Troubleshoot and QC the SAS programs and the business rules used in the systems, helping the team and integrated testing by Unix Shell Job Runs
• Provided Code review at the client site to improve the performance and efficiency of using the resources

Environment:

SAS/BASE, SAS/MACROS, SAS/CONNECT, SAS/ACCESS, SAS/SQL, SAS/GRAPH, MS Excel, SQL Server, Windows NT

SQL/SAS Programmer, Confidential, Delhi, India Mar 2005- Aug 2008

Confidential is a company which specializes in Data Processing, Data Conversion, Custom and web development for their various clients in the Financial, retail and the Engineering sectors. This project consisted of huge inventory and sales data stored in different databases. They wanted to integrate the data present in these scattered databases to construct a huge database and produce standard reports out of it. All the data was extracted, transformed and then loaded into a single large dataset for easy access in the later time.

Responsibilities:

• Production of standard Reports.
• EstablishedAccess control environment for Different users and groups.
• Creation of SAS master file that is done on a weekly and monthly basis: Used these weekly master files and SQL Server databases for report generation.
• Data extraction from SQL Server and convert them to SAS data sets.
• Copied SAS datasets using PROC COPY utility.
• Created and maintained SAS datasets that are extracted from an SQL Server database which includes data management of SQL Server tables, programming in SAS and SQL for data management, analysis and presentation.

Environment: SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, Oracle, UNIX (Sun Solaris)