Data Analyst

Gayathri Achanta

Mobile: 650-***-**** Email: *******@*****.***

Summary:

Client oriented IT professional with 6 years of experience in Data Analytics and Reporting.

Expertise in using BASE/SAS, SAS/Macro’s, SAS/SQL.

Creation of new programs by using Advanced programming in SAS and modifying the existing SAS Programs.

Programming SAS/Macro’s to automate the process for effective results.

Expertise in using various SAS procedures like Proc Sort, Proc Freq, Proc contents, Proc Transpose, Proc Import, Proc Export,Proc Reports/Tabulate and Proc print etc.

Excellent knowledge on the Banking / Financial Service, Telecom sector

Technical skills with core competency on SAS Banking Detailed Data Store, Anti-Money Laundering, Customer Intelligence, Profitability Management, Credit Risk Management System.

Strong knowledge and understanding of SQL and ability to write SQL queries

Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.

Excellent communication, Analytical skills.

Have good knowledge and experience in Software Quality Assurance tested the web based applications and database application. Hands on experience in writing test Plans and test cases for testing team

Technical Skills:

SAS

Base SAS, SAS/Macro’s, SAS/SQL, SAS/STAT, SAS EG

Programming Languages

C, C++,C#

Operating System

Windows 2000 Professional, Windows98, Windows XP,Unix and Linux

Databases and Reporting

Oracle 9i, MS SQL Server,Microstrategy,Cognos

Query Languages

SQL

Web Technologies

Asp.net,HTML,css

Office Suit

MS-Office

Education:

Masters in Computer Science, Osmania University, Hyderabad.

Professional Experience

Kaiser Permanente, CA Oct 2016- Till Date

Role: Data Analyst

Responsibilities:

Data Collection-Children for special needs (E.g. Demographic, treatment details etc.)

Data Cleansing using Excel,SAS and ensure the quality of the data

Ananlysis on the children treatment data and recommendations.

Generating reports, and statistical analyses.

P2P Systems Inc, CA Aug 2015- Sep 2016

Role: Data Analyst

Responsibilities:

Modified/developed SAS codes for data cleaning and Reporting

Modified SAS code using SAS/ Base and SAS/Macro facility.

Identified problems with the data, if there were any, and also

Produced derived data sets, tables, listings and figures

Analyzed the data and produced quality customized reports by using PROC TABULATE, REPORT.

and SUMMARY and also provided descriptive statistics using PROC Means,

Frequency, and Univariate.

Report generation using many SAS procedural statements, SAS/MACROS

SAS was used for pre-processing data, SQL queries, data analysis,

Generating reports, and statistical analyses.

Processed data collection to ensure proper quality of data and

Maintained the daily error log for cleaning the data.\

HSBC Bank June 2010- Jan 2012

Role: Risk Analyst

Responsibilities:

To develop a Credit Scoring role that can be used to determine if a new applicant is under a good credit risk or a bad credit risk or under an average credit risk by using number of explanatory Variables of historical data.

Developing a Model of several variables that allows us to classify a new applicant into one of those categories of good, bad, average classification procedure by

Reading data from different sources and making into SAS format.

Data cleansing and performing variable transformation that seems appropriate.

Extensively used different SAS techniques like First. and Last., Merging, Functions, Formats and Informats.

Perform various descriptive statistical analysis.

MellonSoft, India Sept 2007- Dec 2009

Role: Data Analyst/ SAS Programmer -Bank credit risk scoring

Responsibilities:

Active role in providing data to the Analyst’s using SAS Tools.

Creating summary datasets and large datasets using Base SAS, SAS/SQL.

Created reports as per the requirement using SAS procedures.

Responsible for analysis and database programming to support Business information

Reading data from different sources like ledgers, trial balances and balance sheets.

Data cleansing at different stages and variable transformation that seems appropriate.

Extensive usage of SET and MERGE statements while preparing reconciliation reports.

Data transformation using different SAS functions, formats, informats and options

Developing, modifying, validating and documenting the SAS MACROS for standardized tables.

Generating different SAS data sets for Analysis.

Usage of PROC SQL concepts like Indexes, Views, Joins and Sub-queries.

Usage of SAS ODS for posting results in required formats like CSV, RTF and HTML.

Build new models

Detecting the fraud happened in the credit card business

REFERENCES: Available upon request.

Contact this candidate