SUMMARY

• SAS Certified Professional with over 8+ years of experience in data analysis and statistical modeling including data extraction, manipulation and validation techniques, writing macros and reporting on various projects for different industries using SAS and its tools
• SAS professional in developing statistical methods routinely used in Financial /Mortgage / Insurance /Auto - Finance/Health-care/ Customer & Sales data analysis
• Strong skills in SQL, Data Warehouse, Data Exploration/Extraction, Data Validation, Reporting and Excel
• Experienced in developing SAS procedures, macros, merges, data steps for data cleaning, formatting and reporting
• Expertise in performing Data Analysis, Data Modeling, Data Cleansing, Integration, Data import, Data export
• Proficiency in writing flexible, maintainable and well-documented SAS codes using DATA step and PROC step
• Experience in MS Excel, PowerPoint, Access, Visio and Other MS Office Suite
• Extensively used Teradata SQL, BTEQ for the backend process to build the business rules
• Created numerous Volatile, Global, Set and MultiSet tables
• Extensive experience in working with SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/ODS, SAS/Connect, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS Enterprise Guide, Storing and Managing Data in SAS Files
• Performing Adhoc reports by using SAS, Oracle, Teradata, BTEQ, and UNIX
• Expert Level on Access, Excel, SQL, SAS with regards to Data Management and processes automation/standardization
• Solid expertise in working on Teradata Sql Assistant, Sql Developer and Toad
• Experience in loading flat files to Teradata by writing fast load scripts
• Extensively worked in aTeradataDatabase environment (Large Database, Thousands of Tables and Views)
• Experience with Teradata SQL Assistant, Oracle, and IBM Mainframe QMF & SAS applications in development, reviewed SQL Queries & conditioning of accounts for each releases
• Banking, AML/Regulatory Compliance, Performance Analytics, Reporting, Capital Markets, Debit Card, Credit Card, Deposits, Funds Transfer, Client Information Systems, General Ledger, Fixed Assets, Bank Mergers and Conversions, Consumer Lending, Mortgage, Default, Risk Analytics
• Good statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple regression models

TECHNICAL SKILLS

Platforms: UNIX, Windows, IBM Mainframe

Software: SQL, SAS, Base SAS, SAS/Macro, SAS Enterprise GuideSAS Enterprise Miner, SAS/STAT, SAS/GRAPH, SAS/SQLSAS/ACCESS, SAS/ETL, HTML, XML, C, C++, CobalVBA, Java script, VSS (Visual SourceSafe)

Database: SQL Server, Oracle, Teradata, MS Access, DB2

Desktop: Excel, Word, Visio, Publisher, Lotus Notes, Outlook, SharePoint, Info path

Testing Tools: HP Quality Center/ Mercury Test Director

BI Tools: Tableau, Cognos, Qlikview

Methodologies: SixSigma, DMAIC

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. SAS Programmer/Analyst

Responsibilities:

• Participated in the process improvement initiatives as a part of SLQ2CQ Project techniques for various Business group such as Recoveries Remarketing, Legal Recoveries etc
• Participated in a target list production for customer campaigns across a variety of products and marketing
• Maintained KPI tracking reports, by understanding key business indicators, extracted and consolidated data from multiple sources, identified significant trends
• Generated customer campaign for COAF (Auto-Finance) business by using credit card business data by in-turn using the instrumental data in creating specialized offer packages to new and existing customers
• Developed Macro programs to clean, validate and update the data to perform analysis and generate reports
• Modified existing datasets using Set, Merge, Sort, formats, functions and conditional statements
• Coordinated with marketing department to finalize the list of individuals to whom the loan can be forwarded so that targeted campaign can be launched
• Used options like DROP, KEEP and RENAME to work with some variables
• Experience in developing SAS Procedures, Macros, SAS Formats & Informats, SAS Arrays, SAS Functions and applications for data cleaning, reporting and documentation
• Optimized performance using Data Profiling, Data Validation and Data cleansing using Statistical procedures with SAS PROCs
• Experience in converting SAS codes and models from PC SAS to SAS EG
• Developed programs to generate derived datasets from raw data imported from sources; modified existing SAS datasets using Data Step, Set, Modify, Merge and Retain statements
• Used Teradata/SQL, UNIX Shell Script, MS Office (Especially advanced in Access, Excel VBA/Pivot Table& PowerPoint)
• Extensively used Business Objects crystal reports to validate the metric data against most recent/historically reported data
• Provided database support to modeling and production team
• Performed QA audits to ensure that all delivered files were validated by matching the output results to the business requirements
• Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting
• Extensively written PROC/SQL to retrieve data from various data sources including data warehouse and SQL server and UNIX
• Performed data mapping, data transformation, validation and documentation
• Importing/exporting large amounts of data from files to Teradata and vice versa
• Worked on scripting SQL queries and also by creating SAS dataset to get the desired format for metrics to be reported for business groups Including Loss Mitigation and Loss Prevention
• Worked on consolidating a list of datasets for a range of metrics belong to different business group by extensively performing SAS functions
• Effectively used data blending, quick filters, actions, hierarchies features in tableau
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Experience in assisting users in creating and modifying worksheets and data visualization dashboards
• Expertise in performing data pull into PC SAS from an Excel sheet or by means of SAS Pass-through facility and also into SAS EG from Knowledge Links and experienced in performing proc steps like transpose, Freq, Sort, Report etc
• Assisted various Business Department in better understanding of the metric calculation, measurement and aggregation method for the successful completion of the UAT and on-time
• Solid expertise in scheduling/ prioritizing the CRON jobs in SAS EG 5.1 by using Shell scripting

Environment: Enterprise Guide 5.1, SAS 9.3, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SQL server 8.0, Teradata, Tableau 8.2, UNIX, SAP BOBJ crystal/ Webi reports

Confidential, Bloomington, IL

Sr. SAS Programmer/Analyst

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools - SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/SQL, SAS/CONNECT, SAS/ACCESS
• Completed all levels of application testing and Q&A, and prepared all required documentation
• Used SQL, Oracle, UNIX Shell Script, SPSS, STATA, MS Office (Especially advanced in Access, Excel VBA/Pivot Table& PowerPoint), exposure to Business Objects
• Extensively usedSASprocedures like Print, Sort, SQL, Means, Summary, Freq etc
• Participated in designing, coding, testing, debugging and documenting SASPrograms
• Statistical analysis included coding the data sets, calculating simple percentage distributions, graphs, multiple tables and reports developed using SAS/STAT
• Created RTF, PDF, HTML, LISTING, etc using Output Delivery System (ODS)
• Extensively used variousSASData Step functions,SASprocedures, and SQL to write reports logics forSASStored processes
• Formatted HTML and RTF reports, using SAS- output delivery system ODS
• Used theSASMacro facility to produce weekly and monthly reports
• Validated programs and databases
• CreatedSASCustomized Reports using the Data Null technique for FDA evaluations
• Developed routineSASmacros to create tables, graphs and listings for inclusion in study reports and regulatory submissions and maintained existing ones
• Used various ODS outputs depending on the requirements and provided with a fine framework for FDA submission
• Developed SAS Macros for data cleaning, reporting and to support routing processing
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis
• Converted existing Cognos reports toSASweb reports and using those maps for creatingSASweb reports usingSASWeb Report Studio

Environment: SAS 9.2, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, Oracle 11g, Cognos, R, UNIX, ETL, Business Objects, MVS, VBA, Data warehouse, MS Excel, Macros, VBA, MS-Access

Confidential, Dayton, OH

Sr. SAS Programmer/Consultant

Responsibilities:

• 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
• Used FTP(File Transfer Protocol) to transfer files across platforms
• Performed several case studies and presented findings to management. E.g. delinquency progressions for pre-defined cohort, effectiveness of agents in loan modification, identify factors affecting loan performance
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor
• Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros
• Extracted the data from database using SQL queries and created SAS data sets
• Developed SAS programs using Base SAS for tabulation counts, correlations
• Developed SAS macros for data cleaning and reporting and to support routing processing
• Created RTF, PDF, and HTML Reports using SAS ODS
• Used theSASMacro facility to produce weekly and monthly reports
• Debugged, Created, maintained and documented adhoc reports on demands
• Presented numerical information in various formats and also created SAS customized reports using the DATA NULL technique
• Generated graphs using SAS/GRAPH and SAS Graphics Editor
• Solid Expertise in generating reports, tables, listings and graphs using SAS procedure steps such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC GPLOT, PROC MEANS, PROC SQL, PROC TRANSPOSE, PROC GCHART, PROC APPEND, PROC COMPARE etc
• Responsible for Analyzing report requirements and developing the reports by writing Teradata queries and Ms Excel
• Good at creating, reviewing, retrieving, validating Datasets and to read, write, import and export to another data file formats, concatenate, interleave and merge datasets
• Importing/exporting large amounts of data from files to Teradata and vice versa
• Utilized ODBC for connectivity to Teradata & MS Excel for automating reports and graphical representation of data to the Business and Operational Analysts
• Used Proc REPORT to generate reports and also developed annual reports based on the existing data
• Designed and developed Qlikview software applications and complex server-based Qlikview dashboards from scratch to support reporting and Business Intelligence initiatives
• Experienced in using QlikView Functions (Ranking, Date and Time, Join, Peek, Aggregation, Range, Previous etc.) and also created variables using SET, LET or control statements in the scripts
• Imported data from excel sheet for analysis in SAS
• Using SQL queries, extracted data for metrics reporting from a variety of systems, Including Loss Mitigation/Recovery
• Extensively worked with risk management team by creating Ad-hoc reports for Credit Bureau Reporting
• Effectively handled the complexity by understanding myriad business rules and processes, interoperating between SQL/SAS/Excel, analysis over large data sets (millions of records) spread across several sources
• Owned established production reports by constantly maintaining and updating new requirements from business

Environment: SAS 9.2, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETL, Teradata, Oracle 11g, UNIX, Qlik View, Ab Initio, Hyperion Brio, Informatica 9.1

Confidential, Princeton, NJ

SAS Consultant/Programmer

Responsibilities:

• Created and extracted Clinical data tables from Oracle to SAS using SAS tools like SAS/SQL Pass through Facility
• Supported RDB, an MS Access database which extracts, transforms and loads (ETL) Deals data from Oracle data sourcing systems and the Deals Data Mart
• Extracted data from existing data source and performed ad-hoc queries by using SQL, MS Access and UNIX
• Designed & developed various departmental reports by using SQL and Ms Excel
• Maintained consistency of SAS variables format and sorted various datasets using PROC SORT and performed the operation merging using MERGE
• Created Unix Scripts that uses Bteq to access Teradata Database
• Converted Scripts from Oracle to Teradata
• Worked on Pivot tables and VBA to write macros in Excel
• Developed SQL queries to retrieve information from relational databases for regular quality control reviews of the database against original source data
• Manage, manipulate and join datausing SAS,Excel tables, Oracle and SQL query builder
• Extract/transfer dataand perform ad-hoc queries using SASv9.1 from/to different data sources, like MS SQL server, Excel and reporting items
• Designed scripts in SASto be compatible withOracleto load and access data from theOracle tables
• Wrote queries on the Teradata database to provide ad-hoc reports using SAS/SQL
• Developed and executed business reports using Teradata SQL advanced techniques like rank, row number etc
• Expertise in generating reports, tables, listings and graphs using SAS proc steps such as PROC REPORT, PROC TABULATE, PROC FREQ, PROC GPLOT, PROC MEANS, PROC SQL, PROC TRANSPOSE, PROC GCHART, PROC APPEND, PROC COMPARE etc
• Validated, cleaned and updated data to perform statistical data analysis and to generate report
• Created SAS MACROS for applications to extend and customize SAS software programs and used existing SAS MACROS for standard reporting
• Maintained large data sets, combined data from various sources in varying formats using set and merge
• Developed Queries using PROC/SQL to retrieve the data based on the matching columns
• Performed data manipulation such as data step manipulation, sorting, merging, concatenating
• Developed SAS programs to analyze data using various SAS procedures such as Proc Freq, Proc Means, Proc Univariate, Proc Anova, Proc Glm, Proc Print
• Participated in the QC program by validating tables, listing and graphs created by others using PROC COMPARE and parallel programming method

Environment: Teradata, SAS Enterprise Guide 4.0, SAS 9.1, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/SQL Oracle, DB2, Business Objects, MVS,UNIX, Oracle, VBA, Cognos 8, QMF, SQL, HTML, CRM Siebel 8, MS-Excel, MS-Visio, Lotus Notes

Confidential, Atlanta, GA

SAS Programmer

Responsibilities:

• Responsible for providing detailed data analysis and in designing and developing systems, processes, and measurements for Business Unit Operations and to support strategic reporting requirements using SAS, SQL in a mainframe environment
• Move data sets across platforms (from PC and Mainframe to UNIX and Vice Versa)
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0
• Effort estimations, project planning, coding, unit test, delivery & support for Ms-Excel, Ms-Access based VBA applications as a single team player since it is an initiative of Technology With Operations
• Performed data manipulations and scrubbing, Unix, BTEQ and KSH scripting
• Designed the database in Ms Access (Creation of Database, tables, views and Procedures)
• Performed validation testing and UAT to produce clean and consolidated results
• Manipulated and updated the tables as per specifications and extensively used stored procedures
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents
• Worked on the mainframe-SAS environment & PC SAS (Windowing Environment)
• Came up with methods to improve functionality and effectiveness of the code by brainstorming with other team members during team meetings and discussions
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues
• Automating reports using MS Excel with ODBC Connection
• Scheduling SQL Job to run at night times
• Designed and developed a metadata driven automated reporting system

Environment: SAS 9.0, SAS/BASE, SAS/Access, SAS/SQL, SQL, Oracle, Visual Basics 6.0, MS Access, Word, Excel, Windows