We provide IT Staff Augmentation Services!

Sas Developer Resume Profile

Business Domain

Banking/Finance

Commercial Lending, Retail Banking, Collections Charge-Offs, Equities, Derivatives, MBS, CDO, Branch Operations, Loan Origination/Servicing, Exchanges, Broker/Dealers, Orders, Trades, Margin, Settlement, Custodians, Accounting, Stock Records, General Ledger and Sub Ledgers, Regulators, Regulatory Reporting, Compliance, Fraud/Loss Prevention, CCAR, DFAST

Technical

  • 7 years of robust professional experience as a Data/Reporting Analyst and Developer in SAS
  • 6 years of experience in RDBMS and DWH environment in SAS, Teradata, Sybase and Oracle for analysis and reporting
  • 6 years of Experience in MS Excel, MS Access, Excel VBA, SAS DDE etc for application development, scorecards and dashboards for analytics reporting
  • 5 years of experience using SAS on UNIX domain
  • 5 years of experience with direct customer facing role including requirement gathering, coordinating meeting, seamless communication and participation in business and strategy planning meetings
  • 4 years of experience working with SAS BI Suite Enterprise Guide, Olap Cube Studio, SAS Add In, Information Map Studio and Web Reports delivering high performance business reports
  • 4 years of experience working in agile scrum development process
  • 4 years of experience in physical and logical data modeling and schema design using industry standard tools like Erwin and others
  • Extensive experience building and maintaining reporting data marts in SAS for risk analytics, consumer analytics, business development etc
  • Extensive experience extracting information form enterprise data sources like Oracle, SQL Server, DB2 UDB, Flat files, text files, Spreadsheets, VSAM from within and outside the firm
  • 4 years of experience with Teradata version 12 SQL Assistant, BTEQ, FastExport for ETL, analysis and reporting
  • 3 years of experience with OBIEE products Oracle, PL/SQL, OWB etc for analysis, development and reporting
  • Excellent communication and presentation skills with ability to effectively communicate to diverse technical and non-technical audience

SUMMARY

  • SAS Advance and Base certified with Over 7 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS
  • Understanding of the client's vision, goals, limitations, data sources and time lines
  • Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions
  • Firm understanding of Proc Olap and Proc Infomap to deliver solutions meeting complex business needs
  • Extensive experience transferring data across platforms Mainframe, Unix, PC based on the business and reporting needs
  • Vast experience in presentation using SAS, Excel, Pivot Tables, DDE for presenting the end results
  • Proven skills in SAS Base data step and proc and SAS Macro fulfilling on demand business needs
  • Advanced SQL skills with ability to code complex queries to load, clean, format store data
  • Clear understanding of data modeling principles like star and snow-flake schema, dimensional data model, 3nf etc
  • Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
  • Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
  • Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data
  • Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies
  • Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc in marketing domain
  • Experience in loading SAS Metadata Server with metadata from external packages for ETL development
  • 3 years of experience in job scheduling and load balancing using SAS Grid and LSF
  • Involved in preparing and reviewing BRD, FRD documents to serve development and reporting
  • Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions
  • Extensive experience in Teradata tools utilities like SQL Assistant, BTEQ, FastExport TPump for business analytics and reporting on massive Enterprise Data Warehouse
  • Strong skills in requirements gathering, analysis and ETL design, coding, debugging
  • Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc
  • Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors
  • Involved in projects having to deal with cross functional teams and multiple stakeholders
  • Minimum time to self sufficiency in any environment
  • Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience

TECHNICAL SKILLS

  • SAS Tools
  • SAS 9.3, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/STAT, SAS/ODS SAS/CONNECT, SAS/GRAPH, SAS/ENTERPRISE GUIDE, SAS OLAP CUBE STUDIO, SAS/ENTERPRISE MINER, SAS/INFORMATION DELIVERY PORTAL
  • Databases
  • Oracle 9X/8.x, MS SQL Server 2000/2005, Teradata 11/12, DB2, MS Access, Informix
  • GUI Tools
  • MS Office, MS Project, MS Visio
  • Commercial Tools
  • Informatica, Expediter, FileAid, Rapid SQL, Crystal Reports, Hyperion, ERWin, Roscoe, RCS
  • Operating System
  • WINDOWS XP/NT/Vista, UNIX AIX , MVS, z/OS
  • Programming Languages
  • C, C , SQL, VBA, VB 6.0, Java, HTML, XML, Bourne Shell
  • Reporting tools
  • Crystal Report, Hyperion, MS SQL Server Reporting Services

WORK EXPERIENCE

Confidential

SAS Developer

Responsibilities

  • Directly involved in gathering complex business requirements pertaining to recent or old pattern of abnormal behavior or activity on different channels that would affect the end customer of the bank
  • Convert business requirements into technical specifications using available tools and technologies
  • Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
  • Use SAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions
  • Create detailed business and technical documentation for individual projects
  • Maintain and contribute to the modulated software development environment for loss prevention
  • Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
  • Use Agile methodology to build, test and deploy models and applications
  • Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS Early Warning And Reporting System applications
  • Extensively use Proc Olap and Proc Infomaps to build data sources for the reporting applications using SAS, AMO and Web Reports
  • Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support for SAS, Oracle 11g
  • Responsible for troubleshooting and delivering outputs using PROD/DEV/QA environments
  • Develop test cases/plan for individual project assignments of Loss Prevention reporting using ID Portal
  • Involved in preparing Data Quality Review Plan DQRP to adhere to the internal specifications
  • Provide production support and retrospective version control on the application on ad hoc basis
  • Implement the needed fuzzy logic in pattern mapping and segregation of the customer profiles using SAS programming techniques

Environment: SAS ENTERPRISE GUIDE, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, SQL Server, RCS, UNIX, RCS, UltraEdit, IBM Tivoli

Confidential

SAS Developer

Responsibilities

  • Extensively used SAS on UNIX platform to develop custom business solutions
  • Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
  • Developed and supported infrastructure to implement Statistical and Economic models
  • Conduct walkthroughs of requirement artifacts and communicate effectively with business, development and testing teams during construction phase to ensure clear understanding of requirements
  • Effectively used version control to coordinate the development across the various phases
  • Used SAS to develop custom desktop solutions for the Stress Testing of the Commercial Loan portfolio of the bank
  • Extensively used SAS macros, loops and other techniques to perform program and application automation
  • Responsible for Phase I/II and III model validations for Commercial lending portfolio of the bank in Energy, Muni, Construction, C I Consumer and Industrial to derive PD Probability of Default , LGD Loss Given Default and EAD Exposure at Default
  • Responsible for implementation of the various quantitative models in retail domain targeting delinquency, charge-offs
  • Participated in datamart design and build using Oracle 11g, Toad, SQL Plus for the consolidation of the very large vendor data into the enterprise systems
  • Supported in house oracle datamart administration using configured environment variables, parameters, stored procedures, group profiles
  • Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling
  • Used SAS and system options to improve the performance of the existing sas programs
  • Participated in the process of streamlining the data process underlining the program automation
  • Used SAS program techniques to develop custom and enhances reports for customers using AMO, Olap Cubes, OBI
  • Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data
  • Performed rigorous query tuning and performance optimization for the applications that process the large transactional data

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Teradata, RCS, UNIX, RCS

Confidential

SAS BI Developer

Responsibilities

  • Extensively used Proc OLAP to generate cubes for DQ and custom reporting
  • Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.
  • Developed SQL queries to fetch data from schema of terabyte range
  • Developed Cubes using formats replacing aplha to conserve disk space for input tables
  • Used Excel and call execute routine in SAS to generate Proc Olap code having ease of maintenance
  • Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
  • Produced reports in excel using SAS add-in, Proc Report and ODS Tagsets
  • Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
  • Developed SAS stored procedures and views to provide BI analysis and insights
  • Involved in developing and maintaining documentation of operational processes and data mappings
  • Used Proc Metalib as well as SAS SMC to configure/alter information of datasets/views/tables etc
  • Developed several reports using SAS Information Map studio to be presented in Excel as well as Web reports
  • Extensively used Proc SQL and SAS Macros for application automation
  • Extensively used SAS Dictionary tables and Proc Metadata to get real time information for SAS datasets
  • Used Excel templates and VBA to generate custom reports from data in SAS tables
  • Extensively involved in mainframe SAS for analyzing very large datasets several hundred rows
  • Involved in fine tuning the code to reduce the churn time and improve the efficiency
  • Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
  • Extensively used proc tabulate, proc rank, proc transpose in developing custom reports
  • Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
  • Exported large SAS data sets more than 300 variables to MVS external files to be sent to external vendors using SAS and SAS/Macro
  • Hands on experience in moving SAS data sets from Unix to PC environments using FTP
  • Used Meta Engine as well as SQL Passthru method to load the manipulated data from external tables into SAS data sets

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, SAS Web Reports Studio, SAS Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, VBA

Confidential

Audit Software Professional/SAS Consultant

Responsibilities

  • Strongly served the data requests of varied nature pertaining to operational risk, management risk, policy enforcements, regulatory oversight, Investor portfolio management, P L reporting to name a few
  • Adeptly performed Data Management for the Business Unit: data profiling and cleansing of business unit's assets data using SAS.
  • Served as a direct point of contact with the end user to understand the requirement and develop technical solutions to deliver in terms of quality, time and accuracy
  • Automated the creation of Excel pivot tables from SAS data sets using SAS/Macro and VBA
  • Responsible for monthly surveillance reports tracking deals for Profit and Loss analysis using SAS and Excel
  • Developed SAS stored procedures and views to provide BI analysis and insights
  • Involved in developing and maintaining documentation of operational processes and data mappings
  • Used Excel templates and VBA to generate custom reports from data in SAS tables
  • Extensively involved in mainframe SAS for analyzing very large datasets several hundred rows
  • Created SAS programs using the COBOL copybook layouts
  • Involved in creating SAS datasets out of the live VSAM datasets
  • Prepared several regulatory reports in standard formats as specified using SAS
  • Involved in fine tuning the code to reduce the churn time and improve the efficiency
  • Designed and coded ETL processes with varied source systems like Oracle, SQL Server and flat files
  • Coded extremely complex SAS Data step and procs including the advanced techniques and the use of the available options to serve the ever evolving and dynamic business reporting needs
  • Involved in creation of flat files out of database tables
  • Involved in aggregating data residing on the vast network of distributed servers with all forms of data storage
  • Tested JCL and PROCS for Auto Reconciliation jobs for a month and compared reports, flat files and VSAM files from test and production environments
  • Extensively used SAS/DDE to generate formatted Excel sheets maintaining data integrity from SAS output data sets
  • Exported large SAS data sets more than 300 variables to MVS external files to be sent to external vendors using SAS and SAS/Macro
  • Hands on experience in moving SAS data sets from Unix to PC environments using FTP
  • Used SQL Passthru method to load the manipulated data from DB2 tables into SAS data sets
  • Developed an application using Base SAS, SAS/Macro, Proc SQL and Proc Contents to generate concise data profiling reports

Environment: SAS 9, SAS/SQL, SAS/MACROS, SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ETL, TSO, MVS, VSAM, DB2, Teradata, SAS/ENTERPRISE GUIDE, Easytrieve, ISPF, VBA

Confidential

SAS Developer

Responsibilities

  • Developed and implemented strategies to integrate data from over 40 loan-servicing organizations into the SAS data warehouse
  • Streamlined existing SAS code for table look-ups
  • Created an automated monthly forecast report for dollars and number of accounts that rolled from current to delinquent using SAS/Macro, Excel and VBA
  • Compiled datasets for building attrition and risk models in SAS
  • Developed summary tables of the data in various sources using Base SAS and SAS/Macro
  • Analyzed the loan data to generate portfolio statistics report using SAS, summarizing accounts by Fico bucket, market segment and account status
  • Invoked SAS programs via VBA code to provide an easy user interface on the windows environment to connect to the Unix system
  • Created analytical reports that drills down various performance metrics of existing collection strategies by key collection performance drivers including debt balance, recovery score, payment history and demographics
  • Used Excel templates and VBA to generate custom reports from data in SAS tables
  • Involved in creating Data Marts and performing data validation for scorecard modeling and customer segmentation using logical/physical DM and Teradata-ETL procedures
  • Extracted metrics for Risk Management team from Teradata server using PROC SQL in SAS and modified it using Base SAS and SAS Macros to present in required format
  • Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
  • Developed data base objects like tables, views, indexes, stored procedures and user defined functions as per the business needs in SAS
  • Queried data and applied constantly changing business rules to build customized user reports used in the process of managing loans, brokers, and sales representatives
  • Designed automated data load system employing SAS/BASE and MACRO to control job flow and perform data audit on major intermediate and final data sets
  • Used SAS OLAP Cube Studio and Web OLAP viewer to perform quick and insightful analysis of data
  • Extensively worked with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS.
  • Set up cron jobs on the Unix environment to schedule the run of daily SAS reports

Environment: SAS 9,SAS/SQLSAS/MACROS,SAS/BASE,.SAS/GRAPH,SAS/STAT, SAS/DDE, UNIX, Oracle, DB2, SAS/ENTERPRISE GUIDE, VBA, Teradata, SAS Enterprise Miner 5.2, MS Office, FileAid, Expediter

Confidential

Data Analyst - SAS

Responsibilities

  • Developed programs using the Libname statement SAS Views to extract report error statistics
  • Created Automated Turnaround documents for use as re-input to source
  • Contributed to several JAD sessions with focus to eliminate bottlenecks form the system
  • Used Microsoft Access and Excel to provide output analysis data
  • Programmed reports for Management to use to find business logic problems, manual and automated keying problems
  • Imported data from SQL Server and Excel to SAS datasets. Performed data manipulation by merging several datasets and extracted relevant information
  • Used SAS datasets to create reports using Proc Print and Reports. Also used Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL
  • Used arrays along with Proc Means, Proc Summary and Proc Freq. Created drill-down HTML reports for the finance department using data from several sources
  • Used SAS/DDE to call Excel VBA macros in reporting applications development
  • Used SAS Macros to produce drill down capability for the reports
  • Produced tables in Excel using ODS and Proc Tabulate as per the business requirements
  • Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
  • Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets
  • Participated in full life cycle of model development: market research, statistical analysis, model development, and reports/presentations

Environment: SAS/BASE, SAS/ODS, SAS/MACRO, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, Windows NT Server, UNIX, Microsoft Office 2003, SAS/EG, MS SQL Server, Teradata, Java, Python, COBOL, Perl

Hire Now