ASHWINI S

Email: advt9r@r.postjobfree.com

Phone: 763-***-****

OBJECTIVE

Looking for challenging roles which can help me in implementing the expertise and experience gained; work in projects with efficiency and quality and nurturing myself as better professional.

EXPERIENCE SUMMARY

Overall, 7 years of experience in Development & Enhancement in Banking domain

5+ years of experience in Base and Advanced SAS programming

3 years of experience in Data Warehousing (ETL)

4 years of experience in Data Analytics and MIS reporting

5 years of experience in Unix Shell Scripting

2+ years of experience in Teradata

Hands on experience in SAS DI Studio

Hands on experience in scheduling tools such as Control -M and Autosys

Hands on experience in the basics of Informatica and Oracle

1+ year of hands-on experience in Git.

WORK EXPERIENCE

Working as IT Analyst in Tata Consultancy Services from Jan 2014 to till date.

TECHNICAL SKILLS

Key Skills

Base & Advanced SAS, SAS Macros, Unix Shell Scripting, SQL

Database

Teradata

Operating System

UNIX, Windows

Domain

Banking and Financial Services

Trainings Attended

Informatica, Business Objects

Certification

SAS Base Programming (89%)

EDUCATION

Qualification

Subject

Percentage/Grade

BACHELOR OF ENGINEERING

Electrical & Electronics Engineering

82.99

STANDARD XII / H.S.C.

Others (Bio-Maths)

93.16

SSC

Others

88.72

PROJECT EXPERIENCE

Project Name

GRMAS Analytics

Customer

Citi

Project Description

GRMAS analytics is a platform for data gathering, risk modelling and running various analytics for the retail partner cards portfolios. GRMAS environment receives periodic input files from credit processors, new accounts systems and credit bureaus for the RPC cardholders. This data is used to build Datamart for performing analytics.

Duration

3 years 8 months

Period

Dec 2017 To Aug 2021

Roles

Developer

Responsibility

1.Involved in analysis and interaction with clients and Business Analyst in gathering requirements.

2.Developing SAS codes for reporting and creating Datamart for performing analytics

3.Performing ETL operations by SAS Program coding.

4.Design and development of regular and adhoc MIS reports

5.Developing UNIX Shell Scripts

6.Scheduling jobs in Autosys

7.Quality checks

8.Involved in Production implementation, change Management Activities and Maintenance Activities

Technical Skills

Base and Advanced SAS Programming, Unix Shell Scripting, Autosys, excel, GitHub

Achievements

Received "Star Team Award"

Project Name

BCBS SAS Reporting

Customer

J. P. Morgan Chase Bank, National Association

Project Description

The Basel Committee on Banking Supervision provides a forum for regular cooperation on banking supervisory matters. Its objective is to enhance understanding of key supervisory issues and improve the quality of banking supervision worldwide. The Committee frames guidelines and standards in different areas - some of the better known among them are the international standards on capital adequacy, the Core Principles for Effective Banking Supervision and the Concordat on cross-border banking supervision.

Duration

2 years 4 months

Period

Jan 2015 To Apr-2017

Roles

Developer

Responsibility

1.Gathering requirements from Business Analyst.

2.Developing SAS codes as per requirements.

3.Performed ETL operations by SAS Program coding.

4.Generating reports to the clients.

5.Developing UNIX Shell Scripts

6.Scheduling jobs in Control-M.

9.Involved in Production implementation, Change Management Activities and Maintenance Activities

Technical Skills

Base and Advanced SAS Programming, Unix Shell Scripting, Teradata SQL, Control-M

Achievements

Received "On the Spot Award"

Project Name

ICDW Cards Remodelling

Customer

J. P. Morgan Chase Bank, National Association

Project Description

JPMC is building an integrated customer data warehouse with a high-performance, scalable,

extensible, and providing a 360 view of the customer, which is critical to support future growth.

Currently, JPMC is in the process of Sun setting existing CDW applications and Migrating them to ICDW Integration Layer which is built on a third normal form on IBM’s Reference Data Model

BDW. ICDW foundation on Overall architecture, ETL process, Data Architecture & Modeling

process is already in place which needs to be extended for the new applications which are planned

to be on-boarded. Overall effort is split to 8 waves. There are 12 CDW Applications which need to

be migrated to ICDW environment as part of Wave 2

Duration

5 months

Period

Apr-2014 To Aug-2014

Roles

Developer

Responsibility

1.Gathering requirements from Business Analyst.

2.Creating Informatica Mappings as per requirements.

3.Involved in Performance Tuning in Teradata.

4.Developing Bteq scripts in Teradata.

5.Developing UNIX Shell Scripts.

6.Involved in the Build process like creating DDLs, DMLs and mappings and also generating workflows and sessions for the same.

7.Scheduling jobs in Control-M.

8.Involved in Production implementation, Change Management Activities and Maintenance Activities

Technical Skills

Informatica, Unix Shell Scripting, Teradata SQL, Control-M

PERSONAL INFORMATION

Name

Ashwini S

Father’s name

Santhanamahalingam K

Date of Birth

12-10-1992

Marital Status

Married

Languages Known

English, Tamil

Permanent Address

NO 259, F2 Omega Homes, LIC Nagar 6th Street, Madipakkam - 600091

Declaration

I declare that the information and facts stated above are true and correct to the best of my knowledge and belief.

SIGNATURE

[Ashwini S]

Contact this candidate