CAREER SUMMARY

• SAS certified programmer with around 8 years of professional experience in working with SAS and SAS tools with strong emphasis on ETL and reporting, analysis verification, and validation in various projects in financial industry
• ETL using SAS Data Integration studio and permanent report generation using OLAP cube
• Technical design for ETL using SAS Data Integration studio for customized DW source format
• Generation of temporary Adhoc reports using SAS EG, viewing reports from OLAP cube using EG and the Addin MS excel plug-in
• Maintaining OLAP cubes, preparing analysis dashboards for ad-hoc analysis reporting
• Involved in writing complex routines for data scrubbing, data cleaning and data extraction
• Thorough knowledge in SAS Programming, Merging SAS Data Sets, Macro Facility, Preparing Data, SAS Procedures, Producing Reports, SAS Formats, SAS Functions, Storing and Managing data in SAS Files
• Created Star Schema tables from Relational Schema tables using Data Integration Studio and created OLAP Cubes using Futrix, a SAS based, intuitive and interactive reporting and analytical OLAP tool
• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc., to analyze customer related data, generate custom reports, tables, listings, and graphs
• Experience in financial modeling and statistical techniques to predict, evaluate and manage credit risk across various loan portfolios
• Generation of reports and analysis from granular information data needs of clients
• Hard coding whenever required for ad-hoc reporting and data exporting into Excel
• Used SAS Integration Studio to extract the data from different sources by applying filters, transformations and load data into data marts/Data warehouse
• Employing SAS HASH objects for injecting data into memory storage for increased performance and faster access
• Applying the SAS Information Map Studio to create MAPS objects by making use of business logic applied to source data
• Experience in writing macros to develop concise and reusable code
• Involved in writing complex routines for data scrubbing, data cleaning and data extraction.
• Thorough knowledge in SAS Programming, Merging SAS Data Sets, Macro Facility, Preparing Data, SAS Procedures, Producing Reports, SAS Formats, SAS Functions, Storing and Managing data in SAS Files
• Experience in performing different operations on data sets of any size like Sorting, Merging, Concatenating and Interleaving
• Analyze customer related data, generate custom reports, tables, listings, and graphs
• Knowledge in importing data from Teradata, Oracle tables, DB2, and MS SQL Server
• Experience in using SAS to read, import, and export to other data file formats, including delimited files
• Experience in generation of various periodic and ad-hoc reports for various analyses
• Thorough knowledge in SAS Programming, merging SAS Data Sets, Reading Flat File into SAS, SAS FORMATS, SAS INFORMATS, DATA NULL , SAS Functions, Preparing Data to generate Reports using PROC REPORT and PROC TABULATE
• Assistance in business analysis, application setup, Ad Hoc Queries, data conversion, data manipulations, data exports MS Excel and reporting
• Business Object manipulations of flat files imported from SAS datasets
• Using Business Objects for reporting in conjunction with SAS
• Output report formatting with Business Objects from SAS text file datasets for ad-hoc reports
• Performed program documentation on all programs, files and variables for future reference
• Experience in Base SAS, SAS/MACROS, SAS/SQL, SAS/ACCESS, SAS/GRAPH, and SAS/STAT
• Performance Improvement using SAS Indexes, Debugging and SQL tuning
• Develop annotated correlations interfacing multiple economic variables and their effect on realization of portfolios, prepayment speeds and delinquency rates
• Provides analysis and reporting on an adhoc basis to assist in making strategic and/or significant operational decisions
• Performed Cleansing, Testing and Validation of data
• Worked closely with the data management team to ensure that the data entered into the database is clean and accurate
• Experience of MS Office tools like MS Access, MS Word, MS PowerPoint, and MS Excel

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAS BI programmer

Responsibilities:

• Used variety of SAS transformations in Data Integration Studio to develop ETL Jobs and worked on SAS Forecast Server and SAS Enterprise Miner for Data Mining and Analytics Purposes.
• Developed SAS OLAP cubes and defined hierarchies, levels, measures and aggregation calculations based on the user requirement.
• Resolving the issues faced by the end user to connect to the SAS server, SAS Enterprise guide and OLAP Studio.
• Assisted end users in getting access to the development work done by the other users by import and export of tables.
• Financial modeling and statistical techniques to predict, evaluate and manage the credit risk across various loan portfolios
• Business Intelligence expert responsibility for enterprise BI architecture, strategy, framework and capabilities including operational reporting and analytical solutions, OLAP analysis, dashboards, advanced analytics as well as data management and data warehousing.
• Created stored processes SSP from SAS code, Tasks from EG processes using EG. Created SAS Macro that adds date timestamp to the output file.
• Used variety of SAS transformations in Data Integration Studio to develop ETL Jobs and worked on SAS Forecast Server and SAS Enterprise Miner for Data Mining and Analytics Purposes.
• Wrote programs using UNIX SAS to convert the tables on Oracle database into SAS datasets using SQL pass through facility.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Using slowly changing dimensions SCD Type II to track changes over time in data.
• Using OLAP cubes for data aggregation
• Worked on queries for avoiding FTS in Teradata.
• Data comparison with SAS files and ETL output Files.
• Developed SAS stored Processes and then used in Web Report Studio and SAS IDP.
• Developed Multi Dimensional Data Sources CUBES using OLAP studio.
• Utilized OLAP cubes to report large volumes of data, provide hierarchical trees
• Analyzed data and then created reports in Web Report Studio and Informational Delivery Portal.
• Business Intelligence expert responsibility for enterprise BI architecture, strategy, framework and capabilities including operational reporting and analytical solutions, OLAP analysis, dashboards, advanced analytics as well as data management and data warehousing.
• Leverages the strategy of using SAS as the two main platforms for supporting Business Intelligence development activities in conjunction with other Information Architecture artifacts to ensure a cohesive BI solution i.e. Data Integration Patterns, Information Sourcing Access Patterns, and Data Quality Framework .
• Business functional specific logical view of Enterprise information for corresponding functions information processing.
• Define the people, processes and technologies that need to be integrated and aligned to take a more strategic approach to BI.
• Performed Cleansing, Testing and Validation of data using PROC FREQ, PROC MEANS, PROC COMPARE, PROC PRINT, PROC UNIVARIATE, PROC SORT, PROC SUMMARY, etc
• Used SAS Integration Studio to extract the data from different sources by applying filters, transformations and load data into data marts/Data warehouse.
• Worked with SQL , and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Used procedures like Proc Download, Proc Sort, Proc Export, Proc SQL, and Proc Datasets extensively.
• Calculated custom columns as per business requirements, applied business rules when importing data.
• Providing data information as requested for internal/external audits and regulatory reporting and presenting findings to Senior Management.
• Used SAS functions such as character manipulation functions: Substr, Transwrd, Translate, Left, Trim, Compress etc and date format conversion functions like Today, Sysdate, Datetime, Date.
• Coordinated with report developer to get right data into reports

Environment: Base SAS 9.2, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access, TERADATA, Access, Excel, SAS Data Integration Studio, SAS tools Enterprise guide 4.3, OLAP, Web Report Studio, Information Map and SPM

Confidential

SAS Programmer

Responsibilities:

• Involved in updating and retrieving data from Data Warehouse and generating analysis reports using SAS/BASE, SAS/MACRO, and PROC REPORT.
• Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting and data extraction.
• Extracted of data from ORACLE and other flats files into SAS Data Sets using SAS/Access, SAS/Connect, Proc SQL, and SAS Import Utilities. Designed and created the SAS Data Sets from Excel Spreadsheets and also from different kinds of flat files for data manipulation purposes.
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access.
• SAS Data Integration studio for ETL and generation of master datasets from various databases, as well as loading into different complex databases like Oracle, Teradata
• Used SAS Enterprise Guide to create various reports, Analyzed the data from various source, Created different charts.
• Used SQL Loader Facility to load the SAS data sets and other flat files to Oracle Database.
• SQL and SAS Code Tuning for increased performance. Reviewed and Streamlined old SAS code to eliminate errors and improve functionality.
• Created Star Schema tables from Relational Schema tables using Data Integration Studio and created OLAP Cubes using Futrix, a SAS based, intuitive and interactive reporting and analytical OLAP tool.
• Used SAS IDP for Developing portal pages and portlets and SAS BI Dash boards.
• Used SAS Integration Studio to extract the data from different sources by applying filters, transformations and load data into data marts/Data warehouse.
• Developed macros to validate the pre-existing model to be used on any data set for future use, using PROC MEANS, PROC MODE, and PROC UNIVARIATE, etc.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Regular interaction with the financial analysts for the presentation. Performed in-depth quantitative data analysis. Coded SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs.

Environment: Unix, Windows NT, MVS, SQL, PL/SQL, SAS Data Integration Studio, SAS Enterprise Guide, SAS Web report Studio, Base SAS9.2, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, TERADATA Oracle8.0, PL/SQL, Sql net, UNIX SHELL SCRIPT, MS ACCESS, SQL Loader, DB2, VB, Micro Strategy, ETL, SAS Information Map Studio.

Confidential

SAS Programmer Analyst

Responsibilities:

• Creating SAS Views from tables in Database using SAS/Access, and analyze data.
• Retrieved the financial data from flat files received from the vendors, convert them into SAS readable format. Make the SAS data sets, analyze data as per given requirement.
• Worked with SQLPLUS, and PL/SQL extensively to solve database problems to make database effective and efficient tuning purpose. In PL/SQL Implement of DML, Implicit and Explicit Cursors, function, conditional logic, creating and ODBC connection.
• Experience in Transferring and converting data from one platform to another to be used for further analysis. From Oracle and Excel to SAS both export and import of data
• Perform complex ad-hoc programming, analysis, and reporting
• Designed, documented, implemented, and maintained, monthly and ad-hoc financial, and marketing analyses
• Develop and produce monthly reports summarizing business activity, delinquency loss
• Extract and summarize account and transaction level data for trend analysis and forecasting
• Generated daily, weekly and monthly reports using Proc Report and SQL.
• Created required financial reports using analysis output and export them to other environments or the web using various SAS method like create delimited, text files, ODBC, CEDA, CPORT, ODS having formats such as HTML, RTF, or XML.
• Scheduled and managed jobs with AutoSys job management system to ensure job streams flowed smoothly.
• Used data cleaning techniques such as Proc freq, Proc Print, null , proc means, proc tabulate, Proc Univariate, Proc SQL, nodupkey, Proc character, invalid, and discrete data character values.
• Making changes to the code as part of the maintenance and developing new codes for data extraction
• Converted external flat files into SAS data sets
• Used INFILE statement options to control processing when reading raw data files
• Performed Data Cleaning Validation using data step and SAS functions
• Used SAS Functions to manipulate character and numeric data
• Identified problems with the data, if there were any, and also produced tables, listings and figures, which analyzed the data
• Extensively used PROC PRINT and PROC TABULATE to generate reports
• Wrote Macros to replace repetitive codes.
• Interfaced programs with Oracle databases to provide accurate reporting, archiving, and error handling.
• Extracting financial data from the database using SAS/Access, SAS SQL, SAS/Connect, Procedure and create SAS permanent data sets in SAS library.
• Reading data from flat/xls/msdb files using proc import
• Extensively used procedures like PROC SQL, PROC PRINT, and PROC SORT etc.

Environment: Base SAS, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, Oracle 8i SQL, PL/SQL , UNIX, MS-Windows XP, MS-Office

Confidential

SAS Programmer/Analyst

Responsibilities:

• Produce SAS datasets, flat files, and reports to various departments
• Used SQL Loader Facility to load the SAS data sets and other flat files to Oracle Database.
• Proc SQL was used for Queries, Joining, Merging, Concatenating different tables for data extraction from different database.
• Extensively programmed for statistical analysis of data
• Perform queries and used ODS SAS to prepare reports using pre existing templates directing SAS output to RTF, PDF and HTML to publish reports for business users group and load them in UNIX server.
• Developed, programmed, and executed controlled tests to determine the impact of new programs, and strategy changes
• Extensively used edit check programs for data processing and validations. Worked with large audience response data sets and generated graphs using SAS Report and SAS/GRAPH and MS Excel
• Created Data Models for different level of analysis based on the requirements.
• Created SAS/Macros for Proc Export, comparing two variables in a dataset etc.
• Created Macro variables, using Proc SQL, Let statement and Call Symput
• Used correlated sub-query to get the latest information from the audit tables.
• Demonstrated project management skills including the ability to track multiple projects at once while keeping customers and management informed on status.
• Created reports using PROC REPORT, PROC TABULATE, ODS statements and PROC TEMPLATE to generate output formats in HTML, CSV, EXCEL, XML, PDF or RTF
• Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall business strategies.
• Analyzing the different data sources using SQL for key variables required in efficient targeting of the policy holders.

Environment: Base SAS, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS/ETL, UNIX SAS, PC SAS, Oracle 9i, DB2, PL/SQL, MS Excel, MS Access

Confidential

SAS analyst

Responsibilities:

• Descriptive statistics with SAS STAT procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE. PROC TABULATE, PROC SORT, PROC TRANSPOSE etc.
• Worked in individual projects and supporting marketing campaigns.
• Work with large customer response and sales data sets.
• Cleansing, validating, and manipulating complex data using DATA-STEP PROGRAMMING, SAS PROCEDURES and SAS FUNCTIONS
• Sorting and merging multiple large datasets to obtain curtailed summary tables and listings
• Maintained SAS statistical analysis for the products purchased every month.
• Created a customer mailing list for Direct Mailing and Telemarketing.
• Created Data Models for different level of Marketing based on the reports.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns
• Conducted individual account and household level analysis. Conduct significance tests and study response rates for different offers.
• Created statistical analysis using segmentation analysis, regression analysis and predictive modeling.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.
• Moved data set across platforms from PC to UNIX and Vice Versa .
• Used SQL and PROC SQL Pass through Facility to work with Oracle, DB2.
• Troubleshooting the failed SAS jobs in UNIX and change the code as per requirement.
• Restructured SAS datasets using PROC TRANSPOSE procedure.
• Implementation of Adhoc Requests and coding enhancements in the existing pre processing and post-processing SAS codes.

Environment: Windows XP/2000/NT/2003 Server, UNIX, MS-SQL SERVER, SAS/BASE, SAS/MACROS, SAS/ODS, SAS/SQL, SAS/STAT MS Office