Rajesh Yarramsetty

adzwlk@r.postjobfree.com

469-***-****

linkedin.com/in/rajeshyarramsetty

Summary

** ***** ** ********** **** strong leadership and relationship building skills, SAS development, Reporting and Data Management

My strength lies in sound SAS, MIS reporting and SAS Web application development and process optimization.

Proficient in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/Hadoop, SAS Stored Processes and EXCEL

Extensive knowledge in data management and ability to work efficiently on large datasets.

Good experience in generating MIS reports on a daily, weekly, and monthly basis and in ad-hoc analysis.

Have worked in various domains like Banking, Finance, Insurance, Healthcare, and transportation.

Experience with working independently as well as part of a team.

Organized Data science programs to enable a platform for the project members to up-skill in respective fields as per the project requirements and created a pool of ready resources for future project execution.

Training associates in SAS Programming, SQL and in Excel on a continuous basis as part of training program.

Experienced programmer adept at converting SAS code to Python for efficient data analysis and automation.

Facilitating seamless SAS migration to AWS cloud for enhanced scalability and performance.

Education Details:

Jawaharlal Nehru Technological University

Bachelor of Technology, Information Technology

2003 - 2007

Skills:

SAS Base • SAS Enterprise Guide • SQL • Teradata • Python (Programming Language) • Microsoft Power BI • Tableau • GitHub • Mainframes • Unix • Amazon Web Services (AWS)

Honors & Awards:

Shooting Star - WNS Global Services Jun 2012

Awarded as a Shooting star for the report automation done using DDE in SAS and saved lot of manual efforts in terms of report execution time and quality.

Star performer - Tata Consultancy Services

Mar 2015

Awarded as Star performer in TCS for two consecutive quarters for efficiently resolving client issues in development and often earning praise from clients for my efforts.

Spot Award - JPMorgan Chase & Co.

Aug 2018

Have Received Spot award in 2018 H2 for building a new Disposition panel process effectively.

Experience

Lead Analytics Consultant /Sr. SAS Developer

Wells Fargo

Feb 2022 - Jul 2023 (1 year 6 months)

Responsibilities:

Performed complex activities related to business analysis/data extraction and building strategies using SAS related to home lending and employee surveillance on sales practices.

Using SAS tools to analyze and extract insights from Teradata databases, transforming raw data into meaningful information.

Writing and optimizing complex SQL queries within Teradata to retrieve and manipulate data efficiently.

Partner closely with business teams to identify and optimize the ongoing risk analysis and reporting necessary to support front line accountability for sales practices and other key risk issues.

Produce production of monthly, quarterly, and annual performance reports for senior management

Support research, analysis and development of data-marts and meta-data for home lending team

Converting SAS code to Python for efficient data analysis and automation.

Facilitating seamless SAS migration to AWS cloud for enhanced scalability and performance.

Identify opportunities and deliver process improvements, standardization, rationalization, and

automation (Excel to Power BI and Tableau).

Senior Manager

Standard Chartered Bank

Dec 2019 - Feb 2022 (2 years 3 months)

Responsibilities:

Senior Manager in Strategic Business Information Management team in Retail Banking Area

Supported Various MIS Reporting needs of Business on Retail Banking Products

Responsible for SAS Programming and MIS monthly, weekly, and quarterly Reporting

Worked on the Process Enhancements on BAU execution by decommissioning existing reports with redundant KPI’s and Building a centralized Reports with all almost all KPI’s used for different stake holders.

Worked on various Ad hoc analysis on a day-to-day basis.

Worked on new projects by Creating New dashboards from the scratch on ongoing basis as per the country user needs managed product and segment teams.

Associate

JPMorgan Chase & Co.

Jun 2018 - Dec 2019 (1 year 7 months)

Responsibilities:

Worked in Data strategy and execution for home lending Risk team.

Supported Loss forecasting, capital model and Mortgage modelling teams with their data needs for Comprehensive Capital Analysis and Review (CCAR) and for Internal capital Adequacy Assessment process (ICAAP)

Worked on Process Enhancements on the BAU execution.

Developed a new process to identify the accurate losses for the closed loans based on the severity by integrating several data sources.

Worked on various Ad hoc analysis on a day-to-day basis.

Assistant Manager/SAS Developer

Tata Consultancy Services

Oct 2013 - Jun 2018 (4 years 9 months)

Responsibilities:

Responsible for SAS Programming and SME support to the business Users on their queries related SAS performance optimization techniques and SAS Hadoop integration.

Worked on SAS Campaign program conversions from traditional SAS/ AF programming to Stored processes on SAS 9.4.

Identifying performance bottlenecks in both SAS programs and Teradata databases and implementing optimizations for improved efficiency.

Integrating data from various sources into Teradata using SAS, ensuring data consistency and accuracy

Extensively worked on SAS Web development using SAS web services and stored process

Worked on SAS and Java web services Integration to build web application portal for the end users to their day-to-day reporting.

Facilitated internal team communication to effectively provide customer support.

Investigated and resolved customer inquiries and complaints in an empathetic manner.

Solved unresolved customer issues and Worked on Performance optimizations in existing SAS Processes

SAS Programmer/Senior Analyst

WNS Global Services

Dec 2011 - Oct 2013 (1 year 11 months)

Responsibilities:

Worked as a Senior Analyst with Suncorp which is an Australian insurance giant.

Responsible for SAS Programming and monthly, weekly, and quarterly Reporting.

Worked on Renewal, Retention rates and Strike rate analysis of customers & Providing business insights on the Analysis.

Worked on enhancements/generation of Business-As-usual reports.

Developed user-written SAS code to process external raw data files like .csv, xls, and txt.

Developed macros, stored processes for re-usability, data analysis, statistical analysis, reporting and summation.

Training and assisting other associates on process related activities.

Preparing Ad-hoc Analysis reports when management requires

Identify opportunities to improve the SAS code and develop them to make the code more efficient.

Updating process level documents on a monthly basis to reflect any changes made. Interacting with the business customers on their queries.

Involved in discussion with the stake holders in terms of additions and modifications in the output of the project.

SAS Programmer/Engineering Analyst

Qualtech Consultants

Oct 2010 - Dec 2011 (1 year 3 months)

Responsibilities:

Worked with Barclays Finance, Mumbai as a SAS Programmer Analyst at client's place.

Automated key MIS reports which involve key metrics and analysis results for portfolio quality indicators, vintage indicators, and leading indicators along with several other metrics.

Automated entire process using DDE and macros, where there is no need of doing manual work.

Worked on various ad-hoc reports and analysis in Credit policy and Risk analytics.

Worked on WAS-IS Analysis, Deviation tracking on the loan booking process, Bounce rate Analysis and Various other ad-hoc analysis.

Have worked on automation of CRM, UW and Branch wise performance reports.

Summarize/Compiling the data as it is required for the analysis, keeping the summarized data in a permanent location for monthly updating and reporting.

Preparing Ad-hoc Analysis reports when management requires.

Helping the team members by giving support in writing the SAS codes for Ad-hoc reports.

Assistant Professor

St. Ann's College of Engineering and Technology., Nayunipalli(V), Vetapalem(M), Chirala-523187,(CC-F0)

Jul 2009 - May 2010 (11 months)

Responsibilities:

Trained students in Core JAVA, C Programming and in SQL.

Handled 4 batches consists of 60 members each and taught core JAVA, C and SQL

Developed and implemented innovative instructional methods.

Evaluating, monitoring, and mentoring student academic progress.

Organized and participated in departmental and college activities and served and supported functional activities of departmental committees.

Contact this candidate