Pl/sql developer Resume
CAREER SUMMARY:
- Overall 8+ years of IT development experience across banking and telecommunication domain
- Five year experience in credit card and Mobile banking(Master Data Management).
- One year experience in core JAVA/JSP,weblogic in US Oncor electricity account.
- Two year experience in Oracle PL/SQL and Java, JSP, Unix in Confidential account.
- Five month internship in Confidential on work flow management.
TECHNICAL SKILLS:
Languages/Technologies: Java, J2EE, Jsp, JavaScript
Database: Oracle, MySQL & DB2
Distributed Web Environments: Tomcat 5.0
Development Tool: IBM Websphere Studio App Development, Eclipse, Putty, MyEclipse5.0, Text pad, NetBeans6.9
Enterprise Application: IBM Master Data Management,IBM IGC
Testing Tools: Winrunner, Apperfect, Quality Center & Eclipse
Design Tools: Rational Rose.
CI/CD Tools: Jenkins,Storm UI
Log Tools: Dynatrace, Splunk
Version control Tools: MKS
Self Placed learning: IBM Online Big Data,Hadoop,Python,Machine learning courses.
FUNCTIONAL SKILLS:
- Anti Money Laundry using MDM SDP and Single Customer View across all credit, debit cards and other accounts by 360 degree view in Confidential Bank.
- Telecommunication & network resource management domain knowledge gathered while working in Ericsson/ Confidential account.
- Worked with GUI, Unit testing and prepared/executed test cases for all applications (eg e - learning & Confidential ) developed during my MCA degree.
PROFESSIONAL EXPERIENCE:
Confidential
PL/SQL DeveloperTechnologies used: IBM IGC 11,Unix Server & Oracle 12c.
Responsibilities:
- I developed four different jobs each for three different servers so that stopping, starting and restarting of services were automated.
Confidential
PL/SQL DeveloperTechnologies used: Oracle 12c, Unix Server & MDM 11.3.
Responsibilities:
- I tested the data load from different sources to RDM,RDM to MDM and MDM responses through SOAPUI.
Confidential
PL/SQL DeveloperTechnologies used: Oracle 12c, Unix Server & MDM 11.
Responsibilities:
- Provided level 2 support to MDM application .
- Also worked in quarterly maintenance releases and bug fixes .
- Provided level 3 support as well for design change for production issues.
Confidential
PL/SQL DeveloperTechnologies used: Oracle PL/SQL, Unix Server & MDM 8
Responsibilities:
- Daily status report was created manually before but I automated that process by developing unix script to fetch data from logs and then on macros to generate it in excel. By this automation, 4 to 5 hours effort in preparing status report was cut down and reports are generated in an hour.
- Functions of MDM server, MDM's evergreen SDP concepts and interaction with database were acquired from IBM's MDM experts. Many online MDM courses and a class room training(3day) are done as part of KT for this project.
Confidential
PL/SQL DeveloperTechnologies used: Oracle PL/SQL, Unix Server.
Responsibilities:
- My team develops views using Oracle Pl/sql to speed up the data retrieval from the database.
- Also the purpose of this project is to develop new NRM RDB interfaces for the NRM applications and modify existing views and interfaces for Confidential .
- I created indexes on tables based on business requirement that speeds up data retrieval which was dead slow previously.
- Also I created a a java class to load data to different tables that was previously done manually.
- Also done certain fixes in procedures that speeds up the procedure run time and it results in client appreciation.
Confidential
PL/SQL DeveloperResponsibilities:
- Designed and coded for work allocation and time sheet reporting.