SAS/SQL

Sowmiya Desikan

#** ************ ******, ** ******** Apt, New Perungalthur, Tamil Nadu Ch-63-995******* *************@*****.***

Career Objective

Aim to be associated with progressive organization that gives me scope to update my knowledge and skills, and be a part of a team that works dynamically towards the growth of the organization.

Attributes

Strong analytical and logical skills

Excellent communication and presentation skills

Strong Interpersonal skills

Ability to produce quality result in pressure situations

Professional Experience

Standard Chartered Global Business Services, Chennai.

Data Analyst, Dec 2015-Apr 2018

Work experience in Retail/Credit Risk vertical.

Data Analytics Professional with 2 years and 4 months of experience in applying SAS programming performing Data analysis, Profiling and Composite report.

Creating SAS datasets by extracting data from Excel, Flat Files.

Sub setting dataset using set, merge, sort, update and conditional statement.

Merging and summarizing data using different procedures.

Validating data using SAS functions and procedures.

Summarizing data using DATA Step, Proc SQL, Proc Format, Proc Sort, Proc Means & Proc Summary.

Worked with various procedures like PROC FREQ, PROC TABULATE, PROC REPORT, PROC SUMMARY, PROC MEANS, PROC FORMAT, PROC TRANSPOSE and PROC SQL.

SAS Products - SAS/BASE, SAS/MACROS, SAS/SQL, SAS/ODS.

Roles and Responsibilities

Responsible to manage the generation and delivery of daily/weekly/monthly/quarterly retail risk reports accurately and timely with adequate checks and controls.

Responsible for handling all queries relating to the reports generated.

Adequate knowledge around SAS and Excel as these tools is primarily used to produce the MIs and also to troubleshoot and resolve issues on these tools.

Major reports dealt with – AFPQR, IFRS, Forbearance, NIRB and other minor reports around 50 MIS.

Risk Management

Work closely with country risk teams.

Responsible to ensure quality processing and adherence to all key controls and checks.

Responsible to ensure delivery of reports with extremely accurate and are done based on past trends.

Compliance with all relevant policies and procedure, guidelines, rules and regulations.

Regulatory & Business Conduct

Display exemplary conduct and live by the Group’s Values and Code of Conduct.

Take personal responsibility for embedding the highest standard of ethics, including regulatory and business conduct, across SCB. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.

Effectively and collaboratively identify, escalate, mitigate and resolve risk.

Key Stakeholders

INTERNAL

Country Business (PM&F)

Country Operations

Credit Units(CI, FA, Collections and Recovery, CRM)

Finance

Legal Compliance and Assurance

IS & IT Personnel (Local and Group)

Human Resources

Group Credit

Competencies

Leadership Competencies

Spot Opportunities

Solve Problems

Take the lead

Build Resilience

Collaborate, Communicate, deliver sustainably and achieve results

Technical Competencies

Manage Risk

Writing queries

Report Generation

Manage Stakeholders

Leadership Level

Individual Contributor

Individual Contributor

Individual Contributor

Individual Contributor

Individual Contributor

Target Proficiency Level

Entry

Entry

Entry

Entry

Education

B S Abdur Rahman University, Vandalur

MCA, 2015

GPA: 9.1/10

Exposure: C, C++, JAVA

Major Project – Deaf Application(Angular JS, SQL)

SDNB Vaishnav College For Women, Chrompet

B.Sc.Computer Science,2012

Percent: 81.26%

Associate Secretary of Fine Arts

Mini Project – Online Quiz(VB,SQL)

Training

Have undergone an extensive training at M/s. Temenos, Chennai on T24 product from May 2015 Till Aug 2015

Additional Skills

Awards and Honors

Proficient in Microsoft Office, Excel, PowerPoint, Word, Outlook.

Bilingual in Tamil and English.

Self learner.

Ability to work under time pressure and adapt to changing requirements possesses good technical computer skills.

Received Excellence award in Migration phase and have a deep dive experience with China Clients.

Involved in Hong Kong and China processes which deals with lot of deliveries.

Successfully delivered the BAU reports with high accuracy.

Declaration

I hereby declare that the above furnished information is true and verifiable.

Place: CHENNAI

Signature

Date:

(D Sowmiya)

Contact this candidate