SUMMARY

• Over 8 years of Professional Experience in Data analysis, Database marketing, Customer profiling, SAS Programming, Statistical Analysis and modeling, Credit scoring, RFM analysis, Text Mining, Pattern Recognition and Web Analytics.
• Significant Data analysis and programming experience using SAS Windowing, SAS Enterprise Guide and SAS in UNIX.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macros, SAS/Enterprise Guide, SAS/Share, SAS Enterprise BI Server, SAS Stored Process, SAS Business Intelligence and SAS Management Console.
• Experience with retail data, credit card, and banking data.
• Business Domains experience: Healthcare, Pharmaceutical, Technology, and NGO.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Experience with SAS Business Intelligence Platform: SAS add - in for Excel, Information Maps, Web Report studio, Dashboards, JMP, and OLAP Cubes.
• Proficient in the following reporting and statistical procedures:REPORT, SQL, APPEND, DATASET,TABULATE, FREQ, MEANS, UNIVARIATE, TTEST, CORR, PRINT, REG, GLM, ANOVA, IMPORT,SUMMARY, LIFETEST, TRANSPOSE, COMPARE, EXPORT, COPY, CONTENTS.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Experience with predictive modeling, business analysis, statistical modeling, multi-variant statistics and logistic regression.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Functional knowledge of risk management principles and credit card terms within financial services industry.
• Created and modifiedKorn-Shell scriptsfor the program automation andJCLforSASon Mainframe.
• Experience in buildingRisk score modelsfor controlling Fraud and increase the customer traffic.
• Experience in creating and automating daily, weekly, monthly, Profitability analysis reportsfor credit/debit card products.
• Experience in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Experience inData Extraction,Transformation,Loading, Analysis,and MIS Reportsfor Banking.
• Created complex and reusable MACROS, extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Possess experience as a SAS programmer in UNIX, Mainframe and PC Environment
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Good interpersonal skills, written and verbal communication skills and accustomed to working in challenging environments under deadlines, excellent analytical and problem solving skills.

TECHNICAL SKILLS:

SAS Tools: Base SAS 9.3/9.2/9/8.2/8.1/6 (mainframe), SAS/Stat, SAS Macros, SAS/SQL, SASGraph, SAS Enterprise Guide.

Reporting Tools: Base SAS versions 9.3/9.2/9/8/6, SAS Enterprise Guide, SAS Enterprise Miner, SAS Graph, MS-Excel, SAS BI Platform, SAS OLAP Cube Studio, SAS Web Report Studio, MS-VISIO, and MS PowerPoint.

RDBMS: SAS SQL, DB2, Oracle 7x/8i/9i/10g/11g, Teradata, MS-Access, Microsoft SQL Server, and MySQL.

Languages: SAS, SQL, C, C++, C#, Java, Visual Basic, Visual C++, PHP.

Operating System: Windows 95/98/XP/Vista/Win 7/Win 8/Win 10, UNIX, MAC OS, and DOS.

Batch Server: UNIX, Putty, SSH, and SAS scripting.

Web Server: HTML, JSP, Linux, Apache Server.

Office Tools: Word, Excel, PowerPoint, MS ACCESS.

PROFESSIONAL EXPERIENCE

Confidential, IL

SAS Consultant

Responsibilities:

• Design, develop, and implement SAS Extraction Code for data extraction.
• Understood and gatheird the requirements by interacting with business users.
• Created many custom functions to be shared and shared and reused by the report designers.
• Writing complex SQL Queries using joins,to extract the data from the Teradata Database and Schedule the jobs in UNIX.
• Develop and support Extraction, Transformation and Load process (ETL) using Informatica power center to populate Teradata tables and flat files.
• Migrating SQL server Objects (Table/Views) to Teradata Objects.
• Migrating data from SQL server to Teradata using Teradata, Worked on Sql combined in Database environments like SAS, ORACLE, TERADATA
• Worked with large datasets, moving them across Mainframe, Teradata, UNIX and SAS
• Wrote SAS scripts to extract sample data from various databases likeDB2, Oracle.
• Broadly involved in Data Extraction, Transformation and Loading (ETL process) from source to target systems using Datastage PX
• Managed DFAST & CCAR project resources and vendors (National and international) in coordination of competing priorities.
• Provide status reporting for the Dodd-Frank Program at an executive reporting level.
• With the SAS Intelligence Platform, implemented an end-to-end intelligence infrastructure using software dat is delivered, tested, and integrated by SAS intelligence platform.
• Used Record selection functionally to restrict the records from the Database.
• Used drill down functionally to restrict the records from the Database.
• Participated in testing and generating Business Objects reports using the Universe.
• Participated in scheduling the reports using central Management console and Infoview.
• Created Functional requirements and design document
• Used new features of SAS 9 like call symputx, new functions and regular expressions.
• Done table lookup using match merge and SQL joins
• Done data validation using regular expressions
• Used SQL pass through facility to process high volumes of data
• Created summary data using various functions, arrays and transpose
• Provided data for use in generating computer reports and statistical analysis.
• Improved performance of proc SQL on SAS Oracle interface using options like insert buff, read buff, in jobs
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL server Reporting Services (SSRS) and creating various types of reports like Drill Down, Matrix, Chart.
• Experience in writing expressions in SSRS and expert in fine tuning the reports.
• Analyzing various tables using Data manipulation techniques like merging, appending, concatenating and sorting.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Created and modified SAS macros for edit check process.
• Performed unit and system integration testing
• Performed user acceptance testing.
• Prepared graphs using the modified data for business analysis.
• Good team player and experience with working offsite.
• Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
• Resolved issues created by testing team and users

Environment: SAS/BASE 9.1.3, Mainframe, SAS/Enterprise Guide V3, SAS/MACRO, SAS/ACCESS, SAS/Enterprise Miner, SAS/Web Report Studio, Oracle9i, DB2, Teradata.

Confidential, Richardson, TX

SAS Consultant

Responsibilities:

• Responsible for designing and developing of end to end technical process flow.
• Worked with clients in defining data requirements based on customer's unique business requirements, analyze client’s data and developed enterprise reporting suite.
• Understand and analyze facilities inbound data files, including claim, payment, demographic, charges, charge description master, and other data.
• Extensively worked withhuge claims datausinghash objectsandjoining data set, indexing, data aggregation and automate code usingSAS/Macros.
• Generated highly customized reports ofclaims data using PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC SQL. Monitored and managed the execution plans forSQL code.
• UsedSAS/ACCESSto gather data fromRDBMSlikeTERADATAandDB2.
• FormattedHTML, PDF, CSV and RTF reports, usingSAS ODS targets.
• Extracted data from the Mainframe flat files using SAS, SAS SQL procedures and create SAS data sets.
• Extensively usedSAS/Macro facilityto provide reusable programs dat can be conveniently used time to time and created tables, graphs and listing reports.
• Wrote complexSQL queriesfor data pulls, checking the data transactions in Teradata and Oracle. Also developedSQL scriptsto run complex data integrity test cases and to extract data from the tables.
• Developed programs using UNIX SAS to convert the tables on Teradata into SAS datasets using SQL Pass through facility.
• Extensively worked on data import, data integration, data validation, data cleansing and interfacing with various databases Oracle, Teradata, SQL Server handling large datasets.
• Move data sets across platforms (from PC and Mainframe to UNIX and Vice Versa).
• Automated jobs using korn shell scripting SAS and Teradata jobs, stage flat-files data onto UNIX environments to support ETL processes.
• Actively contributed to the design and implementations of internal process improvement as well automate processes.
• Involved in peer review, testing of the code written and documenting different processes.

Environment: SAS/BASE 9.2, SAS SQL, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/MACROS, SAS/ACCESS and SAS/CONNECT, Oracle, DB2, Teradata, XML, Mainframes, WINDOWS, Putty, UNIX.

Confidential, Denver CO

SAS Developer

Responsibilities:

• Respond to ADHOC requests for reports and data.
• To generate data to show revenue opportunities of existing accounts using PROC SUMMARY, PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Experience in writing complex queries within SAS & SQL.
• Proficient in shell scripting and performance tuning within a Unix/Linux Environment
• Created Macros and developed SAS programs for Data cleaning, Validation, Analysis and Report generation using newly created as well as existing macros.
• Written Code in SAS to connect to TERADATA to retrieve the data from the table.
• Created some scripts in UNIX for File Transfer from one Server to Other using SFTP
• Worked with Cross functional teams from Business intelligence management, marketing, retentions, operations etc.
• Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access)
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS,MS Access and Excel.
• Data integration of different individual Business units to create appointment date file by using Macros, Data steps, Match Merge and Hash-look up.
• Initially created tables and views in Teradata and used a BI/Query model for local users to access the data tables and reports.

Environment: SAS 9.3, SAS/BASE, DDE/EXCEL, SAS/SQL, UNIX, WINDOWS, Enterprise Guide, Shell Scripting, SAS/ACCESS.

Confidential

SAS Programmer

Responsibilities:

• Used BASESAS,Macros,SASEnterprise Guide, andSASSQL for programming.
• Modified macros for report generation usingSASMacros as per the requirements.
• Programmed withSASEnterprise Guide query builder for constructing complex queries analysis.
• Extensively used Data Null andSASprocedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE for creating a preferred list of customers as per the given requirements from business analysts.
• Develop, enhance & execute complex programs and reports with proper documentation.
• Comprehend production codes, undertake diagnosis, resolution of complex issues and improve the efficiency of processes and programs.
• Develop business domain expertise, rudimentary project based business knowledge and good theoretical knowledge of tools like SAS, MS office Independently delivers end to end on complex projects and assist in developing and testing new information infrastructure.
• Manage end-user expectation in the delivery of projects within agreed timelines and as per agreed quality standards.
• Independently executes standard processes, implements predefined algorithms and corrects identified problems.
• Created SQL views for retrieving and dynamically updating data.
• Maintaining large data sets, me.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
• Documenting the process, me.e. documenting all the possible information about the application like SAS programs, DATA files and source.
• Preparing project plan for the execution.
• Independently interacts with business partners to understand business need and translates to technical specifications. Assist in developing and testing new information infrastructure.
• End to end project management and hands on delivery when required.
• Take ownership and actively manage project timelines. Execute standard reports, processes, files, and implements predefined algorithms
• Sets up QA/QC framework and ensures adherence and constant improvement.
• Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.
• Develops business and technical knowledge of team members and identifies opportunities of improvement.

Environment: SAS, Mainframe, BASE/SAS, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/ACCESS, SAS/ODS, Oracle, Teradata, DB2, UNIX and Windows 2003/XP.