Data Analyst Sas
Resume:
Srilekha Jogiparthi
adb6g2@r.postjobfree.com
SAS/SQL Data Analyst
Passionate SQL Data Analyst with around 6+ years of experience in reporting, SAS data analysis, model implementation, development and Credit Risk Management in Home Lending, credit card and Retail Marketing Domain.
Summary
Work experience includes close interaction with Basel partners, Business Intent owners, Technology group, Marketing group and Project team.
Good understanding of Basel II concepts in banking including experience with credit risk models (probability of default (PD), exposure at default (EAD), loss given default (LGD) etc.).
Expertise in data extraction from several databases including MS SQL, Oracle, Mainframes metadata, EDW tables, Tera data and other external files using SAS/ACCESS, PROC IMPORT, SAS/SQL pass through facility, SAS data steps and Lib name statement in both UNIX and windows environments.
Extensive hands on experience in analytics and reporting using Base SAS, SAS/Enterprise Guide (EG), SAS/MACRO, SAS/GRAPHS, SAS/ACCESS, SAS/CONNECT, SAS/SQL, SAS/ODS.
Worked extensively on various SAS procedures like PROC SORT, PROC APPEND, PROC CONTENTS, PROC FORMAT and PROC PRINT.
Strong experience in SAS data warehouse, ETL, Data analysis, SAS Ad-Hoc reporting using SAS procedure steps such as PROC COMPARE, PROC FREQ, PROC SUMMARY, PROC MEANS, PROC REPORT, PROC TABULATE and PROC SURVEYSELECT and many data steps like MERGE, SET, UPDATE statements as per the business requirements.
Strong hold on writing SQL queries especially in handling large data sets with SQL joins using PROC SQL
Experience in using SQL views and indexes for handling large data sets and responsible for accessing and managing data and for writing complex SQL queries and analysis.
Used SAS ODS (output Delivery System) to create output in different styles and redirecting to CSV, PDF, RTF, HTML and Excel files.
Troubleshoots unplanned issues with attention to details and accurately meeting deadlines.
Maintain documentation for key implementation processes across the team for maintaining accurate historical records and future reference with focus on standardization of implementation and execution controls.
Practical experience with working on multiple environments like development, testing and production.
Taken advantage of multiple python libraries like Numpy, Matplotlib along with pandas to carry out mathematical operations and generate reports.
Experience in building, publishing customized interactive reports and dashboards using Tableau and Excel.
Implemented logical statements such as IF/ELSE, SELECT, WHERE to streamline the data processing and prepare quick reports.
Hands on experience in bringing large data from SAS and non-SAS data sources into a SAS environment and performing SAS data manipulations against the resulting sets. This includes merging datasets and to write SAS Macros and generate list outputs/reports.
Create new and use existing macros to improve the efficiency of report generation and automation of reports and data creation.
Used python module Pyodbc to extract data from database (MS SQL) and also multiple packages like Pandas and NumPy for data analysis and for conversion of existing SAS logics.
Implemented Agile/Scrum methodologies during project development.
Firm grasp in gathering and understanding business requirements to develop effective solutions and created Sequence diagrams using MS Visio.
Advanced Excel skills, including data import, pivot tables, lookups and data analysis.
Good team member and ability to quickly adapt to new culture and environment and build effective relationships.
Technical Proficiencies
EDUCATION
Master of Science in Electrical and Computer Engineering (May 2015)
Bachelor of Engineering in Electrical and Electronics Engineering (July 2012)
PROFESSIONAL EXPERIENCE
Client: Wells Fargo, Concord, CA Jan2018 - Till Date
Role: Data/Risk Analyst
Description: Wells Fargo & Company is an American multinational financial services company headquartered in San Francisco, California, with central offices throughout the United States. It is the world's fourth-largest bank by market capitalization and the fourth largest bank in the US by total assets.
Responsibilities:
Responsible for implementation of Home Lending (including Home Mortgage and Home Equity) Basel risk models for the estimation of scoring data (PD, LGD, etc.) to support Basel Submission process for risk weighted assets (RWA) in compliance with Basel regulations.
Work closely with model development teams and other Basel partners on the implementation of models for creating monthly production data and to support model execution, performance monitoring and reporting.
Perform change requests (CR) from model/implementation team to implement the changes in the production code as per the specifications to maintain the code quality.
Extensively involve in system test to ensure change requests are implemented correctly with no additional impact to the Basel submission process and to make sure results comply with G&O requirements and Basel regulations.
Implement necessary data quality checks like internal controls and model Population stability index (PSI) for the Basel submission process and to ensure no unexpected impact to model segmentation and scored data.
Worked on different service requests (SR) raised by internal teams and Basel partners. Performed multiple Adhoc analysis on various variables to see the single variable impact on the Basel process.
Test data enhancements on the database and check the impact to Basel process and ensure the impacts are within accepted threshold and verify the completeness and accuracy of data added to the database.
Research on discrepancies and take actions consistent with procedures to remediate problems.
Use PROC COMPARE to check the correlation between the variables.
Summarize raw datasets and perform data parsing using SAS procedure such as PROC SUMMERY, PROC MEAN, PROC FREQ, PROC SORT, PROC TABULATE and SAS data steps like MERGE, SET etc. which also involves solving and analysis of massive data.
Extensively perform data cleansing during the ETL’s extraction by analyzing raw data and writing SAS program and create complex reusable Macros.
Written and executed multiple SQL queries especially in handling large data sets and responsible for accessing and analyzing data using SQL views. Used custom SQL for complex data pulls.
Connect to SQL Database from client side and use SQL queries like inner and outer joins, aggregate functions, unions, updates, deletes and inserts for extraction and manipulation of Data.
Responsible in consolidating and enhancing the existing dashboards and pdf’s using Tableau desktop and published reports to Tableau server.
Developing analytics around model results for enhancing performance.
Successfully transitioned the existing legacy process of economic datasets to be in consistent with other Home Lending Models and presented the results to other Basel partners.
Experience with UNIX/LINUX environments.
Troubleshoots unplanned issues with attention to details and accurately meeting deadlines.
Maintain documents for key implementation processes across the team with focus on standardization of implementation and execution controls.
Conversion of existing SAS patch files to python data frame structure and save in pickle format by creating functions.
Client: Capital One, Rolling Meadows, IL Oct 2016 - Dec 2017
Role: SAS/Data Analyst
Description:Capital One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses, and commercial clients. Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking and savings products.
Project: Menards Loyalty Program
Responsible for the quarterly fulfillment of the Menards Cardholder Rebate program which annually pays $50M in rebate dollars and requires the review of 2.5M customers. The rebate program covers multiple % rebates based on location of purchase, Consumer first time spend incentive, and manufacturer rebates based on Sku.
Program fulfillment requires maintenance of a rebate "bank" for non-qualified customers.
In addition, compliance level audits are also maintained at multiple points of execution to ensure accuracy at the account, transaction and fulfillment levels
Partner closely with the Execution and Compliance teams to translate new requirements into actionable execution that ensures accuracy and maintains program rules and regulatory requirements
Part of the requirements and validation team associated with the internal automation of the fulfillment execution. This entailed business, functional, regulatory requirements and validation parallel processing.
Dealt with large volume and varied sources for data extraction using ETL process
Gathered information at the transactional and account level from different sources like EDW and metadata sources. Merged various data sets using PROC MERGE.
Included various external files (like extra rebates from partners) using PROC SET, PROC APPEND and PROC MERGE.
Performed in depth analysis of every dollar hitting our SAR Reports (our system of records).
Created Flat files using Data _NULL_ in different formats as per the digital team request.
Perform Marketing Campaign Reports analyzing the reasonableness and profit potential of the user’s campaign assumptions comparing different runs which will be an important factor for success for their business.
Performed documentation on all programs, files and variables for accurate historical records and for future reference.
Conducted in depth and adhoc analysis as per the business requests as per the customer queries.
Transferred few existing jobs to different environment (SAS EG).
Project: Spamhaus
With the cease to email communication, our team has put in different controls to bring back email communications to customers with respect to different partners.
Responsibilities:
Performed data ANALYSIS on system to segment the whole records as per the risk levels to plan the communications to be sent to customers.
Was responsible for performing manual purges by identifying the blacklisted emails in the process of cleaning the system and attaining white list emails (good emails).
Delivered different ways of report in excel with pivot tables.
Created in-time validation sample using PROC SURVEYSELECT.
Extensively involved in research of issue identified with the online enrolled customers and got to the root cause and produced atud files to set their status on system.
Created new financial tables and manipulated customers data by using joins and merges and append data (proc append) from existing source tables which contains millions of records.
Extracted data sets from server using Proc Import and created datasets in SAS libraries, coding SAS programs with the use of SAS/BASE and SAS/MACROS for ad hoc jobs.
.
Foresters Financial Services, Inc - Baton Rouge, LA Mar 2015 - Sep 2016
SQL/Data Analyst
Description: Foresters Financial is an international financial services provider with a unique history that began in 1874 when we set out to provide access to life insurance for average working families. More than 140 years later, we provide investment, life insurance, retirement and savings solutions that help families achieve their long-term financial goals.
Responsibilities
Involved in Business and Data analysis during requirements gathering.
Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
Defined Data requirements and elements used in XML transactions.
Analyzed and rectified d Data in source systems and Financial Data Warehouse databases.
Generated and reviewed reports to analyze Data using different excel formats
Documented requirements for numerous Adhoc reporting efforts
Troubleshooting, resolving and escalating Data related issues and validating Data to improve Data quality.
Involved in Regression, UAT and Integration testing
Participated in testing of procedures and Data, utilizing PL/SQL, to ensure integrity and quality of Data in Data warehouse.
Metrics reporting, Data mining and trends in helpdesk environment using Access
Gather Data from Help Desk Ticketing System and write Adhoc reports and, charts and graphs for analysis.
Performed User Acceptance Testing (UAT) to ensure that proper functionality is implemented.
Guide, train and support teammates in testing processes, procedures, analysis and quality control of Data, utilizing experience and training in Oracle, SQL, Unix and relational databases.
Maintained Excel workbooks, such as development of pivot tables, exporting Data from external SQL databases, producing reports and updating spreadsheet information.
Extracted Data from DB2, COBOL Files and converted to Analytic SAS Datasets.
Deleted users from cost centre's, deleted users authority to grant certain monetary amounts to certain departments, deleted certain cost centers and profit centers from database
Created a report, using SAP reporting feature that showed which users have not performed scanning of journal voucher documents into the system.
Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
Worked on issues with migration from development to testing.
Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the Data
Validated cube and query Data from the reporting system back to the source system.
Tested analytical reports using Analysis Studio
CA Technologies - Mumbai, Maharashtra Feb 2012 - June 2013
SQL/Data Analyst
Description: The company had been a provider of anti-virus and Internet security commercial software programs for personal computers during its venture into the business-to-consumer ("B2C") market, today it is primarily known for its business-to-business ("B2B") mainframe and distributed (client/server, etc.) information technology ("IT") infrastructure applications since the spinoff of their security products into Total Defense.
Responsibilities
Experienced in developing business reports by writing complex SQL queries using views, volatile tables
Implemented data analysis algorithms for various business needs using Python, Postgres SQL.
Developed different Machine learning algorithms to detect anomalies.
Analyzed and applied various Statistical tests on business bulk data using Python, MATLAB, and Excel.
Used Pandas library and R for statistical Analysis.
Worked on Python-based test frameworks and test-driven development with automation tools.
Built various graphs for business decision making using the Python matplotlib library.
Implement various scripts in Python and MATLAB to retrieve and manipulate data.
Experienced in Automating and Scheduling the Teradata SQLScripts in UNIX using Korn Shell scripting.
Wrote several TeradataSQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
Implemented Indexes, Collecting Statistics, and Constraints while creating table
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
SAS Tools
SAS Enterprise Guide, PC SAS v 9.2, v 9.3
Languages
SAS, C, C++, Postgre SQL, HTML, Python3.6
Reporting
Microsoft Excel, Tableau
RDBMS
Teradata, MS Access, Oracle, SQL Server, Mainframes
Documentation
MS-Office 2003/07/10/13
Methodologies
Agile, Waterfall
Operating Systems
Windows, UNIX
Other
Subversion (SVN), Microsoft SQL Server Management Studio, Teradata Sql Assistant, Teradata Studio, MS Visio, putty
SAS Expertise
SAS v 9.0, 9.1, 9.2, 9.3 SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS, SAS/REPORTS
Contact this candidate