Sasikala L Mobile: +91-733*******
E-mail: **************@*****.***
Professional Summary
Technically sophisticated, resourceful, holding 8 years of rich experience in SDLC, Project Management,Agile and Issue Resolution Arena. Skilled in delivering projects on time from conception and development to detailed planning, execution and final delivery ensuring customer satisfaction.
Expertise in programming using Oracle PL/SQL, SQL,Java,Android Sudio,Excel VBA along with basic UNIX shell scripting,hands on experience with python with proficiency in using technology to enhance data and information management.
Education Details
Master Of Computer Applications, Anna University, Tamil Nadu, India.
Employment History
Organization : Capgemini Pvt LTD
Designation : Senior Consultant
Period of Employment : May 3rd 2018 to 22nd Jan 2020
Organization : Thirdware Technology Solutions
Designation : Senior Technology Specialist
Period of Employment : Aug 08th 2016 to 20 Dec 2017
Organization : Cognizant Technologies Solutions (CTS)
Designation : Associate-Projects
Period of Employment : Jun 30th 2011 to Aug 04th 2016
Technical Expertise
Languages/Technologies
IDE
Databases
Reporting Tools
Operating Systems
Version Control
JAVA,React JS, Oracle PL/SQL, SQL, Basic UNIX Shell Scripting,Excel vba, Android Studio SDK
SQL Developer, SQL,Jasper, Eclipse
Oracle 11g, Oracle 10g
Jasper Reports
Unix, Windows95/98/2000/XP/7
SVN, GIT
Project Experience
Project 1: [Cognizant Technologies Solutions]
Title : Global Liquidity Engine (GLE)
Client : JP Morgan Chase, USA
Technology Area : JAVA,PL/SQL, SQL
Database : Oracle 11g
Server OS : UNIX [SunOS]
Duration : June 2012 – Dec 2013
Role : Developer
Project Description : JP Morgan Chase is a Fortune 500 conglomerate with US $125 billion revenue. It has five prominent businesses that span across investment banking and commercial banking. It serves more than 30 million consumer customers, which includes some of the world’s most prominent corporate, institutional and government clients.
Global Liquidity Engine (GLE) uses Liquidity Management Account (LMA), an interest-bearing account type to attract and retain operating balances.
It pays interest based on balance duration. Balance levels drive tiers and pay-out rates as account ages.
The yield on the total balances will be a blend of the various tiers that make up the client’s account.
The GLE platform will bridge the gaps between the US domestic LMA offering and other regions (EMEA and APAC) to align with a more global model.
Project 2: [Cognizant Technologies Solutions]
Title : Corporate Prepaid
Client : JP Morgan Chase, USA
Technology Area : JAVA,STRUTS,PL/SQL, SQL,Excel vba
Database : Oracle 12c
Server OS : UNIX [SunOS]
Duration : Jan 2014 – May 2014
Role : Developer
Project Description : JP Morgan Chase is a Fortune 500 conglomerate with US $125 billion revenue. It has five prominent businesses that span across investment banking and commercial banking. It serves more than 30 million consumer customers, which includes some of the world’s most prominent corporate, institutional and government clients.
Corporate prepaid mainly concentrate on preparing prepaid cards.
Customers use their cards for doing their transactions.
Project 3: [Cognizant Technologies Solutions]
Title : Corporate Quick Pay (CQP)
Client : JP Morgan Chase, USA
Technology Area : JAVA,STRUTS,PL/SQL, SQL
Database : Oracle 11g
Server OS : UNIX [SunOS]
Duration : June 2014 – July 2016
Role : Developer
Project Description : Corporate Quick Pay is a Project where end users can able to send and receive payments easily and securely.
Project 4: [Thirdware Technologies Solutions]
Title : Marketing Programme System
Client : Ford
Technology Area : PL/SQL, SQL,Excel vba
Database : Oracle 11g
Server OS : UNIX [SunOS]
Duration : Aug 2016 – 20 Dec 2017
Role : Developer,Lead
Project Description : Marketing Programme system is an application used by various markets to pay amount to dealers.
Project 4: [Standard Chattered Bank]
Title : Transaction screening As A Service
Client : Standard Chattered Bank
Technology Area : JAVA,Android Studio,PL/SQL, SQL,Excel vba
Database : Oracle 11g
Server OS : UNIX [SunOS]
Duration : May 2018 – Jan 2020
Role : Developer,Lead
Project Description : Transaction Screening service is used in sanctions screening for the transactions that are performed by customers.
Contributions and Responsibilities:
Interact with Clients in gathering requirements.
Worked in CORE JAVA,Android Studioand STRUTS programs.
Write PL/SQL code to maintain the data as per the business logic.
Create, modify and customize database objects such as Stored Procedures, Functions, Packages, Triggers, Cursors, Tables, Indexes, Views, Materialized Views, Sequences, Types, Users and Roles as per the business requirement.
Use oracle built-in packages like UTL_FILE, etc., to perform complex business activities.
Tune SQL, PL/SQL and Report queries to improve performance.
Generate and customize Reports based on clients’ requirement.
Provide data migration scripts and update scripts (Shell scripts, SQL scripts).
Perform Testing - unit testing & peer testing.
Document each step of development (Approach, LLD, UTC, and Release Notes) to ensure adequate communication within the team and customers.
Provide On-call developer support on production issues escalated by the support team.
Analyze the root cause of the problems in cluster environment where several major business systems are dealing with important data of the business.
Worked in Android Studio SDK and developed live apps.
Awards and Recognition:
1.Got “Associate of the Quarter” award for Q2 “13” in Oracle Solutions Practice.
2.Got “Going An Extra Mile” award for Q2 “14” in Oracle Solutions Practice.
3.Spot Recognition Award in Ford.
Personal Details
Date Of Birth
: 1 August 1987
Marital Status
: Married
Languages Known
: English, Tamil
Address
: Old Perungalathur,Chennai
Passport No.
: H0149955
Declaration
I hereby declare that the information and facts stated above are true and correct to the best of my knowledge and belief.
Place: Chennai
Sasikala L