Developer Data
Resume:
SUREKHA MENTHEM
SENIOR ORACLE PL SQL DEVELOPER
Pleasanton, CA +1-432-***-**** ********@*****.*** SUMMARY
I'm a Senior Oracle PL SQL Developer with 7+ years of experience. I have worked as Oracle Developer for major clients such as Nokia, Cargill & Citi Bank and have been recognized with several Performance awards in my career.
Colleagues know me as a highly creative developer who can always be trusted to come up with a new approach. But I know that the client's business comes first, and I never try to impose my ideas on others. Instead, I spend a lot of time understanding the business and the audience before suggesting ideas.
Understanding and Collecting requirements from Business user side or Business Analyst and try to convert that requirement to SQL queries or PL SQL
Having 7+ Years of IT experience as an Oracle PL SQL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing, Production Deployment and Support
Use different strategies of database development to meet the client functional requirements
Expertise in SQL and PL SQL programming, developing complex code units o Creating PL/SQL Packages, Procedures, Functions, o Creating Views and Materialized Views
o Creating Triggers, Writing Exception handling
Experience in data migration/conversation using SQL*Loader and using SQL Developer Import and Export
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose
Used PL SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
Experience with Project life cycle management and Testing Cycles like Unit Testing, SIT, UAT and Production Deployments
Expertise in Incident Management, Problem Management (PBI), change management, Change Request, RFC (Request for Change)
Ability to work independently as well as work with project teams and have strong verbal and communication skills
Strong commitment to quality, documentation and engineering excellence
Excellent analytical, communications, and problem-solving skills
Experience in Unix, Linux using basic commands
EMPLOYER: CHEMTEX (DEC 2019 TO PRESENT) & HCL (OCT 2018 TO NOV 2019) CLIENT: CITIBANK
PROJECT: CGE (CITI GIFT & ENTERTAINMENT)
LOCATION: PLEASANTON (SAN FRANCISCO BAY AREA), CALIFORNIA Job title: Senior Oracle PL SQL Developer
Environment/Tools: Oracle 11g & 12c, UNIX, TOAD, SQL Developer, PUTTY, Service Now Duration: Oct 2018 to Present
Roles & Responsibilities:
• Involved in Requirement Gathering, analysis, Design and Development
• Involved in Testing cycles like Unit Testing, SIT, UAT
• Involved in Production Deployment and Support activities
• Experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views, materialized views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle
• Experience in data migration/conversions using SQL*Loader
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose
• ORAAS migration: Implemented DB Security for DB users
• Responsible for performance tuning activities in the project
• Involved in Performance testing to provide functionalities from the application and prepare sample test data
• Responsible for creating builds through RTC and RLM deployments (SIT/UAT/PROD) with support for prod application checkouts
• Raising CMP requests for RLM onboarding for the new servers
• Raising CMDB request to map servers with ServiceNow
• Familiar with Service Now to create Change Requests (CR), Incidents (INC)
• Worked on Citi related employee feeds like GDW, AMC and Forex to receive feeds from the external teams and process the data to database tables
• As part of the value add, for GDW job we have created a test job to make sure the exact employee data
EMPLOYER: CAPGEMINI
CLIENT: NOKIA
PROJECT: LAWSON ERP APPLICATIONS
LOCATION: BANGALORE, INDIA
Job title: Senior Oracle PL SQL Developer
Environment/Tools: Oracle 11g, UNIX, TOAD, SQL Developer, PUTTY, HP SM9 Duration: Mar 2015 to Oct 2018
Description:
Lawson is a time management, resource management application where resources from different countries will be booking time using this application. Project information will be received from different interfaces, this information will be booked by resources in Nokia
Roles & Responsibilities:
• Engagement with customer for requirements gathering, scope and solution planning
• Responsible for creating and modifying the PL/SQL procedure, function according to the business requirement
• Modifying procedures, functions and packages for migrations and upgradation of Database
• Involved in Admin activities like import, export schema, user’s creation and privileges
• Reviewing the PL/SQL code for the purpose of optimizing performance ensuring effective utilization of the indexes used in the SQL or PL/SQL code
• As a member of Production Support team involved in Handling Production Issues reported by Clients on call
• Worked on materialized views, sequences, synonyms, complex SQL queries using joins, sub queries and inline views to retrieve data from the database
• Development of SQL, PL/SQL procedures, creating new schedule jobs, fixing failed jobs on daily basis
• Involving in creating RFC (Request for change) to implement the changes in production
• Fixing the existing defects, implementing new logics based on user’s request EMPLOYER: CAPGEMINI
CLIENT: NOKIA
PROJECT: WEB PUBLICATION
LOCATION: BANGALORE, INDIA
Job title: Application Developer
Duration: Sep 2014 to Mar 2015
Environment/Tools: Core Java and HTML
Roles & Responsibilities:
• Creating Webpages HTML and Core Java
• Managing Web pages and web sites
• Publishing and expiring intranet and internal web pages
• Worked as an Independent resource for solving more than 10 tickets daily
• Involved in Requirement gathering and Designs
• Involved in Testing cycles like Unit testing, User acceptancy testing
• Involved in Release management activities for Deployments EMPLOYER: CARGILL
CLIENT: CARGILL
LOCATION: BANGALORE, INDIA
Job title: SQL Developer
Environment/Tools: SQL Developer, Putty
Duration: Jan 2013 to Aug 2013
Description:
Cargill operate across many countries in several sectors. And since Cargill mostly works business to business. Cargill works alongside farmers, producers, manufacturers, retailers, governments, and other organizations to fulfill Cargill’s purpose to nourish the world in a safe, responsible and sustainable way. Cargill creates efficiencies, develop innovations, and help communities thrive. Roles & Responsibilities:
• Development of high-quality database solutions
• Develop, implement and optimize stored procedures and functions using SQL
• Analyze existing SQL queries for performance improvements
• Review and interpret ongoing business requirements
• Build appropriate and useful reporting deliverables
• Develop procedures and scripts for data migration PROFESSIONAL EXPERIENCE
Dec 2019 to Present Chemtex Environmental Laboratory Inc Oct 2018 to Nov 2019 HCL Technologies Ltd
Sep 2014 to Oct 2018 Capgemini Technology Services India Limited Jan 2013 to Aug 2013 Cargill
EDUCATION & CERTIFICATIONS
Graduated in 2013 with
78.83% GPA
Bachelor of Technology (B. Tech) in
Electronics and Communication Engineering (ECE)
from JNTU Anantapur, Andhra Pradesh, India
Contact this candidate