Sr.sas Programmer/risk Analyst Resume Profile
Columbus, OH
PROFESSIONAL SUMMARY:
- CertifiedSASProgrammer withover 6 years of experience in analysis, design, development, testing and implementation of Applications in Financial, Retail and Healthcare Industry using SAS Software.
- Extensive knowledge of Mortgage, Banking, Financial, Retail and Campaign marketing data.
- Extensive Experience in Base SAS, SAS/MACROS SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/IntrNet, SAS/CONNECT and SAS/ODS etc in Windows, Mainframe Unix environment.
- Extensively used ETL to transform and load data from Oracle database, XML files, Flat files to Oracle.
- Experience in utilizing SAS Functions, SAS Procedures, Macros, and other SAS application for data updates, data cleansing, and reporting.
- Experience in developing programs to generate derived datasets from raw data imported from various sources.
- Experience in Data management, data extraction, manipulation, validation, and analyzing huge volume of data.
- Expertise in transforming data imported from different data sources into analysis data structures, using SAS functions, options, ODS, macro facility and other SAS procedures.
- Experience in extracting data from relational databases like Oracle, DB2, Teradata, SQL Server and MS Access etc.
- Experience in Developing and designing SAS Programs / Macros to access and analyze financial data used in CCAR submissions.
- Experience in working with Business Users and Technical Teams to understand requirements and to develop code based on SDLC procedures.
- Experience in transferring data across different environments using FTP, SFTP, Humming Bird and Synchrony.
- Experience in writing UNIX shell scripts
- Detail oriented, organized, enthusiastic to work in a fast paced and team oriented environment
- Strong communication skills, problem solving skills and challenge oriented.
TECHNICAL SKILLS
Statistical Software | Base SAS, SAS/MACRO, SAS/STAT, SAS/ACCESS, SAS/IntrNET, SAS/GRAPH, SAS/SQL, SAS/ODS, SAS/REPORTS, SAS/CONNECT, SAS/ETL, SAS/ENTERPRISE GUIDE SAS BI Tools |
Operating Systems | Windows, UNIX Mainframe |
Databases | Oracle, MS-Access, SQL, Teradata, DB2 |
SAS Procs | Print, Means, Univariate, Correlation, Regression, SQL, Report, Freq, Sort, Summary, Format, Import, Export, Transpose, Compare, Gplot and Gchart, Anova. |
Languages | SQL, Shell Scripting PL/SQL, Visual Basic, HTML, XML. |
Other Tools | MS Office, Crystal Reports, Business Objects, Teradata SQL Assitant, TOAD. |
PROFESSIONAL EXPERIENCE
Confidential
Sr.SAS Programmer/Risk Analyst
Description:
Confidential is one the biggest financial services company in Confidential with product offerings in different domains such as banking, mortgage etc. As per Confidential mandate stress tests for big financial corporations to assess adequacy of firms' capital and capital plans, as part of that Confidential has to conduct supervisory stress test using various Analytical and Forecasting Models.I was primarily responsible for building, testing, deploying and migrating various models in Confidential environment. My other key responsibilities include scheduling, maintaining various Production Forecasting Models other critical jobs and developing various summary and forecasting reports.
Responsibilities:
- Involved in meetings and projects with business users, project managers developers to automate, upgrade or expand applications that accomplish business operations and goals.
- Accessed multiple databases using SAS and provided ongoing reporting that supported information-based decision making and periodic CCAR submissions.
- Successfully migrated the model input process of Model Ready to pull data directly from RMI in EDW instead of pulling from an intermediate SAS repository IDSL .
- Supported the production team by developing a Shell script that invokes different macros to produce monthly data that is used for CCAR submission.
- Developed production code for Financial Runs, like 10 year, 20 year, 30 year production runs that create the SAS datasets that are being used for further analysis and modeling purpose.
- Updated and modified the production code according to the dynamic requirements which are dependent on the scenarios like CCAR Base, CCAR Adverse, CCAR Severe.
- Updated and modified production code to generate SAS datasets for different Stress test scenarios such as S2, S3, S4 based on the macro economic variables UER, IR, HPI etc .
- Generated NCL, UPB projections for class variables such as NCI, PCI, HFI, HFS.
- Successfully migrated Model Ready from EDW to Teradata.
- Worked on Teradata Database environment to extract input data for various production process.
- Developed Utility Macros and extensively used existing macros for Validation, Analysis, Report generation and Integration of Data.
- Used Proc SQL extensively to merge, manipulate and summarize the data.
- Investigated missing data and the data anomalies by creating edit checks for imported SAS datasets.
- Customized the variables to user-defined Formats using PROC FORMAT.
- Documented and tested programs that were widely used for various data reporting tasks.
Environment: Base/SAS, SAS/Macro, SAS/SQL SAS/Connect, SAS/Graph, SAS/Access, Windows, Humming Bird Exceed, Teradata, DB2, UNIX SAS/ENTERPRISE GUIDE,
Confidential
Sr.SAS Programmer
Description:
Confidential is one of the top bank holding corporations in the Confidential with head office in Confidential. Confidential has been in business since early Confidential and has been in different mergers and acquisitions since then. Confidential Management group which is a part of the Marketing group analyzes and advises company needs for different telemarketing, direct marketing and e-mail marketing campaigns. As a Sr.SAS programmer, I was involved in creating various lists to provide data related to customer interaction event fact, offer details, customer response, and measure the performance of those campaigns. The group focuses on pulling data from different sources on different Confidential, flat files. I was also responsible for writing UNIX scripts for loading flat files to Teradata tables, transferring data between different operating systems using FTP.
Responsibilities:
- Responsible for user requirements collection and prepared technical design documents.
- Worked with financial analysts to support documentation and decision making.
- Maintained and enhanced existing SAS reporting programs for marketing campaigns.
- Was involved in segmentation and response analysis for direct marketing campaigns.
- Forecasted impact of direct market campaigns for acquiring, developing and retaining customers.
- Involved in analyzing the Risk Partner's, Email campaign and Loan product data on monthly basis to meet Marketing and Financial goals.
- Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG, and PROC ANOVA.
- Wrote complex shell scripts to run the nightly batch jobs without failing, by looping up the jobs still the database is up.
- Developed Synchrony scripts to SFTP files across various environments.
- Loaded data from flat files to Teradata using FASTLOAD MULTILOAD.
- Extensively used Data Null techniques for producing highly formatted and customized reports.
- Developed Complex SAS Macros to automate the reports which involved manual intervention.
- Extensively used ODS techniques for developing reports.
- Involved in peer review, testing of the code written and documenting different processes.
- Effectively prepared and published various performance reports and presentations.
- Developed Ad-hoc reports using SAS Enterprise Guide.
Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Enterprise Guide,Teradata, DB2, ORACLE, SQL Server Windows XP, Synchrony.
Confidential
SAS Programmer/Analyst
Description:
Confidential is the largest Independent Bank in Confidential with assets over Confidential. Confidential provides consumer and commercial banking services through a network of subsidiary banks. AS part of this project, I was involved in working with business analysts in obtaining the business rules and thereby creating and modifying customer lists based on different parameters such as address, loan amounts and customer loyalty. I was also responsible for generating reports for business users.
Responsibilities:
- Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress toward the Consumer Banking Division's strategic objectives.
- Performed data Analysis, mainly using Regression and ANOVA PROC REG, PROC ANOVA, PROC GLM
- Used SAS/SQL for extract, transfer and load ETL methodology and processes.
- Performed Data Cleansing widely during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Programs and creating complex reusable Macros
- Used SAS macros for error handling, code validation, date stamping of log files, collect files to a given directory and scheduling.
- Developed an automated code to calculate all the logics in the given excel for different products.
- Wrote PC SAS programs to read in EXCEL and files with various delimiters, manipulated the contents and created reports using data null as per client's specifications.
- Documented policies and procedures required for supporting system enhancements.
- Trained and managed junior programming staff.
Environment:Base SAS, SAS/Macro, SAS/SQL, SAS/Connect, SAS/Graph, SAS/Access,SAS/Stat, Oracle and UNIX,EXCEL.
Confidential
SAS Developer
Description:I was responsible for providing statistical analysis and forecast to support Commercial Bank Marketing, Loan Service, and other departments throughout the bank. I also generated various reports to track operations and performance of marketing and other initiatives to help evaluate progress towards achieving company goals. I also managed data transfer and documentation and interacted with cross-functional teams to deliver projects within committed time frames.
Responsibilities:
- Analyzed business workflow and system needs.
- Created reports to monitor and analyze Bank and Cards application usage on MF.
- Maintained SAS statistical analysis for the products purchased every month.
- Converted raw data file into SAS datasets using the SAS INFILE statement.
- Extracted data from legacy systems and SQL Server using PROC SQL, transformed them into SAS data sets and loaded them in the repository.
- Presented the results and statistical reports in PowerPoint for marketing staff.
- Ran reporting programs and download the results into EXCEL and build pivot tables.
- Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
- Produced Graphical reports showing PIE and BAR charts for analysis while providing the drill down capabilities. Moved data set across platforms from PC and Mainframe to UNIX and Vice Versa
Environment: SAS/MACRO, SAS/SQL, SAS/STAT, SAS/PC, SAS/CONNECT, SAS/ACCESS, DB2, Base SAS, Mainframes,EXCEL.
Confidential
SAS Programmer/SAS
Description:
Confidential is the second largest Health Care Company in Confidential, with 15.5 million members across Confidential. Confidential is a loaded database having historical data that will be one source for analysis across all subject areas within Confidential.I was involved in extracting data from Confidential and apply transformation rules according to client request to generate flat files for medical claims, pharmacy claims,providers and membership.
Responsibilities:
- Connected various databases ORACLE, DB2, SQL SERVER, Sybase such as development and production database DB2 on UNIX using SAS/ACCESS, SAS/CONNECT
- Performed extraction, transformation and loading from large Oracle tables using SAS/ETL.
- Developed executed SAS programs on a regular and ad-hoc basis using SAS/Macro andSAS/Graph.
- Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
- Extensively used the SET, Update and Merge statements for creating, updating and merging variousSAS datasets.
- SAS PROC SQL/pass through facility used for querying, insertion updating the data
- Analyzed data and summarizes performance using summary statistical procedures.
- Providing notations of performance deviations and anomalies, creating and publishing periodic reports, as well as any necessary ad hoc reports.
- Created graphs using PROC GPLOT and GCHART permanent formatted SAS data sets for present and future analysis.
- Performed Quality assurance and validation on the transported data and reports.
- Additional responsibilities involved developing and analyzing business performance reports e.g. for claims data, provider data, utilization data .
Environment: SAS 8.2,DB2, Oracle, UNIX and Windows,SQL,EXCEL.
Confidential
SAS Programmer
Description: Confidential is India's second-largest bank, offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries and affiliates in the areas of investment banking, life and non-life insurance, venture capital and asset management. Confidential has different branches across India, in which the data is being stored in different databases. The project involved in generating forecast reports to predict the future market growth and strategic planning based on the reports.
Responsibilities:
- Extracted data from Oracle using SQL Pass through facility, Proc Access, Libname Method and generated ad-hoc reports.
- Transferring and migrating data from Oracle to SAS datasets to be used for further statistical analysis.
- Responsible for creating new code, utilize existing code and maintain data in SAS.
- Created SAS datasets from raw data files with different field structures using trailing and in the data step.
- Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS and PROC FREQ.
- Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.
- Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation.
Environment: Windows XP, SAS 8.2, SAS/Macro, SAS/ODS, SAS/SQL, SAS/STAT, Excel, PROC SQL, PC SAS, ORACLE.