Sreevidya Arumalla
SAS Developer Programmer Analyst
Aldie,VA
Summary
Objective:
With over 11 years of experience in Business/Data Analysis, ETL Processes, Reporting Services, Database Management, Testing, and Implementing data-centric applications across various industries, I am eager to pursue a challenging role with a progressive organization and contribute fully to its success.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Sr.SAS Data Analytics Consultant
Wells Fargo
12.2022 - Current
- Supported LOB strategies by analyzing performance metrics, population distribution trends, and complex data to maximize profits and minimize operating losses within risk and operational standards
- Created and maintained SAS programs to generate reports and summaries, including data cleaning resulting in a 20% increase in productivity and fast turnaround times for data requests
- Imported and exported data between SAS and Excel, MS SharePoint, and various text files (.TXT, .CSV) using Proc Import and Proc Export for analysis and reporting
- Develop and enhance reports by connecting to single or various data sources to improve performance and review remediation analytic approaches to ensure accurate data populations
- Performed ETL processes on Teradata tables and utilized SAS/Access to extract, insert, delete, and update datasets in the Oracle database
- Develop and maintain Tableau workbooks, reports and dashboards using calculated metrics to meet different data visualization requirements
- Develop and Publish Interactive Dashboards onto Tableau Server as well as deliver insights and analytics to key stakeholders
- Collaborated with cross-functional teams to streamline multiple data sources to ensure data accuracy and consistency reducing data redundancy by 18%
- Supported the team in monitoring data quality and performance for customer remediation activities and documentation needs
- Additionally, performed appropriate testing of analytic solutions to ensure results were consistent with business needs.
SAS Senior Programmer/Data Analyst
CITI Bank
08.2020 - 06.2022
- Develop and maintain process flows and data lineage maps in accordance with established standards to ensure and enhance data integrity through monitoring and upgrading system process controls
- Was responsible for Data Quality Assessment to establish and maintain metrics for Data attributes e.g., validity, consistency, integrity, completeness, accuracy, availability, timeliness, etc.
- And to define targets for these metrics
- Performed Data Profiling to identify data gaps and errors, data anomalies, inconsistencies, and redundancies by analyzing content, structure, and relationships within data
- Involved in design process of analysis on Critical data variables using different STAT procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT to define data quality rules
- Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions, and conditional statements
- Utilized data step options like KEEP, DROP, and RENAME for storage efficiencies and employed Data set options IF, WHERE, MISSOVER, TRUNCOVER, COALESCE, etc.
- For reading raw data files
- Created Source to Target Mapping Documents for Field-to-Field transformation at each level of modification within SAS scripts and automated manual processes using SAS Macros
- Provided ongoing support to monitor key systems by identifying, analyzing, and interpreting trends or patterns in complex datasets, and collaborated closely with management to prioritize business and information needs
- Work with Data Stewards and subject matter experts to research reported data anomalies, identify root causes, and determine solutions to ensure that data anomalies are detected and contained within thresholds.
SAS Python Developer/Data Analyst
Fannie Mae
02.2018 - 07.2020
- Used SAS Access Interface to various Relational Database Management Systems (RDBMS’s) including Netezza, Oracle, and SQL Server in a SAS Grid environment to provide modified loan data and to support Home Price Valuation Models, Retrospective Property Models and other business application groups
- Providing essential data elements to multiple applications and EUCs for risk management within financial reporting processes, while also migrating legacy SAS programs to Python, writing high-performance scripts for large dataset processing, and actively participating in AWS cloud data migration
- Developed reports as per business requirements and involved in creating automated test folders and test suites in JIRA and mainly responsible for providing programming and QA support
- Extensively used SAS/SQL/Unix to extract model input data from different data sources and worked on Legacy warehouse retirements (for e.g., ADW, RDW and EDW) applying validation and business rules
- Corrected and transformed the data in response to errors discovered during the validation process and formatted the data to generate model ready output for the valuation purposes
- Redesigned the repeat borrower application by simplifying the execution process, enhanced the process output and control reports based on the inputs from user groups
- Worked on Agile projects with bi-weekly sprints to deliver high quality code in timely manner and well versed with development best practices such as code reviews, unit testing, system integration testing (SIT) and user acceptance testing (UAT)
- Written SQL scripts to test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
- Involved in Unit Testing, Integration Testing, System Testing and Regression Testing and Performance Testing on a client/server application and used JIRA and Quality Center as a Bug/Defect Tracking and Management tool.
Sr.SAS Developer/Business Analyst
Freddie Mac
01.2017 - 06.2017
- Collaborated with Business Analysts and Data Modelers to define mapping documents, design processes for diverse sources and targets, reverse-engineered code to develop requirement specifications, and translated business needs into technical specifications
- Modified / debugged existing SAS scripts to have an efficient processing system and get rid of redundant steps using SAS Enterprise guide, Base SAS, and SAS Macros
- Used the Import and Export facilities in SAS to exchange data between SAS and Microsoft Office environments (Excel, Access) and Involved with data profiling for multiple sources
- Developed and executed SAS SQL queries for merging, concatenating and automated intermediate DATA and PROC steps to simplify frequent reporting
- Generated reports by employing various SAS Procedures like Proc Tabulate, Proc Report, Proc Contents, Proc Download, Data Null, SAS Arrays and Proc SQL
- Develop in a LINUX / SAS Grid environment, within an Agile/Scrum framework and prepared daily, weekly, and monthly project status reports
- Assisted in documenting decisions, data differences, exceptions and conclusions drawn throughout iterations
- Tracked data related issues on a daily basis
- Automated many standard and ad hoc reports generation and involved in creating New Scorecards and Reporting the changing values.
SAS Developer/Business Analyst
Fannie Mae
10.2013 - 02.2016
- Acted as a resource to the team by providing SAS programming support, meeting project deadlines, and collaborating with NUC managers to handle reporting requirements and ad hoc requests
- Created loan profiles for book of business (BOB) based on loan, property, deal, and bond information for each given period in both hindsight and get current modes
- Prepared the data for the audit purposes which involved the impact analysis on reporting dollar amounts and involved in the collection evidence for SOX compliance and generated various reconciliation reports
- Developed expertise in solving complex and time critical data quality issues across all the FNMA systems including the issues that require historical loan data population
- The process involved impact analysis, documentation, pre and post implementation verifications
- Created summary reports and graphs for quality control analysis using data from various NSO systems, extensively employing PROC TABULATE, PROC REPORT, PROC FREQ, PROC MEANS, PROC GCHART, PROC GPLOT, and PROC SUMMARY
- Developed Unix Korn shell scripts to automate recurring processes and routine administration tasks, using AutoSys as the job scheduler
- Conducted and generated daily, weekly, and monthly statistical reports based on routine analysis in the dashboard using Business Objects, and documented requirements while generating process flow diagrams for various mapping specifications and reporting
- Used Tableau to produce standard monthly reports and automated monthly excel reports into Tableau Workbooks and Dashboards Analyzed business situations for various problems; initiated meetings and discussions with business users, non-technical persons, and developers to solve the problems.
SAS Developer/Reporting Analyst
Bank of America
04.2012 - 09.2013
- Responsible for researching, analyzing, and responding to analytical inquiries that impact risk parameters also responsible for performing complex data management, mapping, and query development
- Made improvements to production code by replacing generic macros and data steps with proc sql steps, resulting in 70% reduction of processing time
- Using SAS/SQL Pass Thru extracted data from W and BACARDI databases and created SAS data sets for analysis and reporting
- Accomplished data movement process that load data from DB2 into Teradata by using Teradata SQL and utilities such as BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, and improved design of Extract and Load specifications
- Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base
- Extensively used SAS/Macro facility to create macros for statistical analysis, results reporting, and data extraction
- Additionally, automated data extraction and conversion to CSV, TXT, and XLS formats using Korn shell scripts and scheduled jobs with AutoSys
- Designed and developed code using SAS/EG to support ad hoc requests and automated standard reporting with SAS Web Report Studio and Microsoft Add-in and scheduled jobs via EG
- Developed SAS BI Dashboards which are used to monitor KPI’s - Key Performance Indicators
- Automated report generation in UNIX System for efficiency during Production and in a Production Environment.
SAS-SQL Reporting Analyst
Wells Fargo Card Services
10.2010 - 03.2012
- Made transaction data broadly accessible to program teams and worked towards implementing the targeted business strategies
- Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about the current business environment, portfolio trends, expected portfolio losses and the forecast assumptions
- Developed new SAS programs to generate HTML, RTF, and TXT reports, created customized reports and stored processes in Enterprise Guide, and automated the monthly Delinquency Report displaying a 13-month data trend
- Used SAS ODS, SAS Graph, and procedures Proc Tabulate, Proc means to create ad hoc reports and graphs as per the requirements of the users
- Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE
- Used Proc Template to produce customized report in spreadsheet with footnotes, titles, and pages numbers, eliminating user’s work to customize the report
- Involved in developing a SAS code for Acquisition models, X-Sell and Up-Sell marketing models, segmentation and targeting and campaign optimization
- Created monthly, quarterly, and annual performance reports for senior management using SAS/EG and PC SAS and Assisted data mining team to extract data patterns and trends from sales data
- Generated ad hoc reports in Excel via Dynamic Data Exchange (DDE) and browser viewable reports in PDF/HTML via SAS ODS (Output Delivery System) based on client requests.
Education
Bachelor of Science - Computer Science And Engineering
Jawaharlal Nehru Technological University
AP, IndiaSkills
Proficient in SAS programming (Base SAS, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO)
Experience with ETL processes, statistical analysis, data manipulation and transformation
Database management (SQL, Oracle, DB2, Teradata) and performance optimization
SAS BI tools (SAS Enterprise Guide, SAS Visual Analytics)
Experience with other programming languages (Python, SQL)
Debugging and troubleshooting SAS programs
Data visualization and reporting using SAS and Tableau
Proficient in all phases of SDLC with expertise in Agile and Waterfall methodologies
Advanced-level skills in Microsoft Word, PowerPoint, Excel, Visio and Access
Additional Skills:
Strong analytical and problem-solving skills
Ability to interpret and present complex data
Detail-oriented and Well-Organized
Excellent communication skills (verbal and written)
Adaptability and flexibility with team collaboration and interpersonal skills
Certification
Certified Base SAS Programmer for SAS 9
Timeline
Sr.SAS Data Analytics Consultant
Wells Fargo
12.2022 - Current
SAS Senior Programmer/Data Analyst
CITI Bank
08.2020 - 06.2022
SAS Python Developer/Data Analyst
Fannie Mae
02.2018 - 07.2020
Sr.SAS Developer/Business Analyst
Freddie Mac
01.2017 - 06.2017
SAS Developer/Business Analyst
Fannie Mae
10.2013 - 02.2016
SAS Developer/Reporting Analyst
Bank of America
04.2012 - 09.2013
SAS-SQL Reporting Analyst
Wells Fargo Card Services
10.2010 - 03.2012
Bachelor of Science - Computer Science And Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Kavya S PrabhuKavya S Prabhu
Senior Institutional Investment Analyst at Wells FargoSenior Institutional Investment Analyst at Wells Fargo