Database Developer
Resume:
Santhana Lakshmi Chidambaram
Mail Address:
**************@*****.***
Mobile Number:
SUMMARY
• Over 12 years of expertise in Oracle SQL, PL/SQL, UNIX Shell Scripting and Informatica.
• Expertise in SQL and PL/SQL Performance Tuning
• Performed Software Quality Testing for all web applications, batch jobs, used automation framework and test cases
• Performed Integration testing and Regression testing.
• Involved in testing of dashboards that gather data from various sources, such as relational databases, spreadsheets, flat files and APIs, to facilitate analysis.
• Involved in Data cleansing, Data Validation and Data Migration
• Have done testing of ETL (Extract, Transform, Load) processes to integrate multiple data sources in a data warehouse application.
• Experience in Javascript, core Java and Node.js and playwright.
• Experience in root cause analysis and defect analysis and fix the same.
• Worked in Agile process, used JIRA and Azure DevOps for testing and deployment (CI/CD pipeline)
• Completed Oracle Database 11g - SQL Fundamentals I Certification
• Involved in all phases of SDLC and STLC.
• Automated various jobs to enhance productivity.
• Have done extensive manual and automated testing, coordinating across teams for deployment
• Received many appreciations from client for various initiatives and accomplishments.
• Completed ITIL Foundation Certification
TECHNICAL SKILLS
Hardware Pentium based PCs
Operating System Windows-95/98/2000/NT/7,LINUX,Unix Programming Languages SQL,PL/SQL, Unix Shell Scripting, core Java, Java Script Databases & Tools Oracle – 8i,9i,10g/11g/12c, PostgreSQL, Oracle Apex 4.0Tableau, Playwright
Data warehousing Tool ETL - Informatica Power center 8,9, Datalake Other Utilities HTML, Toad, SQL Developer, PLSQL Developer, Putty, Win SCP, BMC Remedy tool, SDM12 Remedy tool, Maestro scheduler, Autosys, MKS, SVN, RTC and RLM tool, Playwright, Databricks, Azure DevOps EXPERIENCE SUMMARY
PROJECT PROFILE 1
Role Software Quality Engineer (Free Lancer)
Duration Sep 2025 – till date
Location Tampa, Florida
Programming Languages & Tools Tableau, PostgreSQL, Datalake, Javascript PROJECT DESCRIPTION
We are NumPy Ninjas, a groundbreaking technology collective led by innovative women at the forefront of artificial intelligence and computational science. Our diverse team of female data scientists, machine learning engineers, and tech visionaries is dedicated to transforming complex computational challenges into elegant, powerful solutions that push the boundaries of what's possible in AI. ROLES AND RESPONSIBILITIES IN THE PROJECT
• Involved in data cleansing and data validation
• Performed testing of dashboards and various charts in Tableau
• Have done requirement analysis and design specifications to identify Test scenarios.
• Developed Master test plan, Integration and System Test plan.
• Prepared Test scenarios, Test cases and involved in regression testing.
• Involved in automated testing which uses Playwright and javascript
• Prepared test scenarios and test log documents
• Gathered metrics for Performance and Stress testing, prepared Defect Report PROJECT PROFILE 2
Role Senior Software Quality Assurance Analyst (Database) Project Title Credit Risk Report
Duration May 2025 – Sep 2025
Location Tampa, Florida(Remote)
Programming Languages & Tools Oracle SQL,PL/SQL, ETL, Java script PROJECT DESCRIPTION
CRR (Credit Risk Report) application which provides a comprehensive snapshot of a customer’s credit history, payment behavior, and financial health. The report can include a variety of information, such as the customer’s payment history, business acquisition history, previous records with other suppliers, credit scores, and ratings.
ROLES AND RESPONSIBILITIES IN THE PROJECT
• Performed testing of batch jobs and done performance tuning
• Developing Unix shell scripts, creating unit test cases.
• Have done requirement analysis and design specifications to identify Test scenarios
• Developed Master test plan, Integration and System Test plan.
• Prepared Test scenarios, Test cases and involved in regression testing and back end testing.
• Prepared test scenarios and test log documents
• Gathered metrics for Performance and Stress testing, prepared Defect Report. PROJECT PROFILE 3
Role Senior QA consultant (Database)
Project Title Customer Profitability Analysis Application Duration Feb 2018 – May 2021
Location Capgemini, Offshore, Chennai, India
Hardware Intel based PC
Operating Systems Linux, Windows 7
Programming Languages & Tools Oracle SQL, PL/SQL, Unix shell scripting, Java Script, SVN,PL/ SQL Developer, Autosys, Putty, WinSCP, Playwright
PROJECT DESCRIPTION
BNPP Wealth Management — BNP Paribas Wealth Management has been committed to protecting customer wealth and deliver tailor-made experience, with outstanding attention to detail and expertise from precise local knowledge to the global know-how that we access from the group. Customer profitability (CP) is the profit the firm makes from serving a customer or customer group over a specified period of time, specifically the difference between the revenues earned from and the costs associated with the customer relationship in a specified period. CLIENT DESCRIPTION
BNP Paribas India Solutions
TECHNOLOGIES
Oracle SQL, PL/SQL, Unix Shell scripting, Java script, ETL, Tableau ROLES AND RESPONSIBILITIES IN THE PROJECT
• Understanding the user requirement and analyze the Functional requirement specification
• Have done testing of Oracle Stored Procedures, Functions and Packages
• Developing Unix shell scripts, creating unit test cases.
• Developed Design document, unit test case and test log documents
• Involved in regression testing and application integration testing.
• Automated various repetitive tasks which increase productivity which in turn saves time and cost
• Worked on Enhancement of Application Batch jobs
• Participated in User acceptance testing and training
• Have done code-review for various modules and code changed by other team members
• Involved in management reporting stuffs like weekly, monthly status report preparation and review PROJECT PROFILE 4
Role Senior QA Consultant(Database)
Project Title AML
Duration Dec 2015 – Feb 2018
Location Oracle Financial Services Software, Offshore, Chennai, India
Hardware Intel based PC
Operating Systems Linux, Windows 7
Programming Languages & Tools Oracle SQL, PL/SQL, Unix shell scripting, Core Java SVN, SQL Developer, Autosys, RTC/RLM, ETL Informatica
PROJECT DESCRIPTION
AML — Anti Money Laundering.
Citibank- Citibank is the consumer division of financial services multinational Citigroup. Anti-Money Laundering(AML) is a set of procedures, laws or regulations designed to stop the practice of generating income through illegal actions. In most cases money launderers hide their actions through a series of steps that make it look like money coming from illegal or unethical sources was earned legitimately.
CLIENT DESCRIPTION
Citibank
TECHNOLOGIES
Oracle SQL, PL/SQL, Unix Shell scripting, ETL - Informatica ROLES AND RESPONSIBILITIES IN THE PROJECT
• Understanding the user requirement and prepare the Functional requirement specification document
• Creating workflows using various transformations, scheduling workflows through autosys.
• Handling flat files and loading and generating feed files through workflows.
• Developing Unix shell scripts, creating unit test cases.
• Debugging workflow failures, identifying the root cause and resolving the issue
• Design, coding and testing of Oracle Stored Procedures, Functions and Packages
• Developed Design document, unit test cases and test log documents
• Performed regression testing and prepared defect reports
• Involved in performance tuning of application jobs
• Have done code-review for various modules and code changed by other team members
• Involved in management reporting stuffs like weekly, monthly status report preparation and review PROJECT PROFILE 5
Role Senior Associate
Project Title Supply Chain Source Planning
Duration June 2015 – Dec 2015
Location Cognizant Offshore, Chennai, India
Hardware Intel based PC
Operating Systems Linux, Windows 7
Programming Languages & Tools Oracle SQL, PL/SQL, Unix shell scripting, Autosys, MKS, Javascript
PROJECT DESCRIPTION
SCSP — Supply Chain Source Planning.
Abbvie - Global biopharmaceutical companies that has the ability to discover and advance innovative therapies and meet the health needs of people and societies around the globe. The Supply Chain Management (SCM) platform supports the SCM Planning and Global Inventory Reporting Processes at Abbvie. It includes planning processes for Demand, Supply and Integration for Commercial, Planning and Manufacturing affiliates. The SCM Platform integrates these processes to provide visibility to planning activities performed at these global locations. CLIENT DESCRIPTION
ABBVIE
TECHNOLOGIES
Oracle SQL, PL/SQL, Unix Shell scripting, Java script ROLES AND RESPONSIBILITIES IN THE PROJECT
• Understanding the user requirement and analyze the Functional requirement specification
• Design, coding and testing of Oracle Stored Procedures, Functions and Packages
• Developed Design document, unit test case and test log documents
• Automated various repetitive tasks which increase productivity which in turn saves time and cost
• Worked on Enhancement of Application Batch jobs
• Have done code-review for various modules and code changed by other team members
• Involved in management reporting stuffs like weekly, monthly status report preparation and review PROJECT PROFILE 6
Role Associate
Project Title Platts Market Data Direct
Duration Mar 2015 – May 2015
Location Cognizant Offshore, Chennai, India
Hardware Intel based PC
Operating Systems Linux, Windows 7
Programming Languages & Tools Oracle SQL, PL/SQL, Java PROJECT DESCRIPTION
MDD — Market Data Direct.
Platts is a leading global provider of energy, petrochemicals, metals and agriculture information, and a premier source of benchmark price assessments for those commodity markets. Since 1909, Platts has provided information and insights that help customers make sound trading and business decisions and enable the markets to perform with greater transparency and efficiency. Platts’ new innovative, distribution capability, Platts XML Direct, offers flexible, reliable and fast delivery of its real-time content, including page-based ‘Alert’ services, selected newswires and Platts real-time numeric data. Platts XML Direct does this by combining IBM MQ Series® messaging technology with a new XML message schema.
CLIENT DESCRIPTION
McGraw-Hill Platts
TECHNOLOGIES
Oracle SQL, PL/SQL, Java
ROLES AND RESPONSIBILITIES IN THE PROJECT
• Understanding the user requirement and analyze the Functional requirement specification
• Involved in developing and testing Oracle Stored Procedures, Functions and Packages
• Have done code-review for various modules and code changed by other team members
• Developed test plan and test case documents
• Involved in Technical Documentation of applications
• Involved in management reporting stuffs like weekly, monthly status report preparation and review PROJECT PROFILE 7
Role Associate
Project Title Dodge Data and Analytics
Duration April 2010 – Feb 2015
Location Cognizant Offshore, Chennai, India
Hardware Intel based PC
Operating Systems Sun-Solaris, Windows 2000
Programming Languages & Tools Oracle SQL, PL/SQL, Unix Shell Scripting, Informatica, Core Java
PROJECT DESCRIPTION
Dodge Global Network — Regional Construction Reporting Nationwide. The Dodge Global Network (DGN) is a web application which delivers a customized solution with early- design, hard-to-find private construction projects. The Network enables construction industry people to prioritize their sales pipeline, increase win/loss ratio, and target the right relationships. Productivity tools help them to manage their sales force and streamline their entire sales process. Reporters across various regions collect the project news, associated company information, plans and specification related to the project through infACT application. Data Migration relates to the migration of the information pertaining to a Dodge Report from infACT to DGN. It involves migrating data from one database to the other. The DR’s, Plans, Spec etc., needs to be transferred to the database so that from there the data can be published to the customers via DGN. CLIENT DESCRIPTION
SYMPHONY TECHNOLOGY GROUP (Earlier it was owned by McGraw-Hill Construction) TECHNOLOGIES
Oracle SQL, PL/SQL, UNIX Shell Script, Oracle Apex and ETL- Informatica ROLES AND RESPONSIBILITIES IN THE PROJECT
• Understanding the user requirement and analyze the Functional requirement specification
• Involved in developing and testing of Oracle Stored Procedures, Functions and Packages
• Automated various repetitive tasks which increase productivity which in turn saves time and cost
• Worked on Enhancement of Application Batch jobs
• Providing fix for all Database Application failure and all kind of Data issues
• Handled high priority incidents and requests and strictly adhere to the SLA
• Developed mappings and worked with Transformations like lookup, Update Strategy, Aggregator, Router, Stored Procedure, Expression and Joiner transformations.
• Worked on creating Slowly Changing Dimensions workflows
• Debugging workflow failures, identify and resolve the issue
• Involved in Performance Tuning of SQL Queries and PL/SQL Code.
• Performed Data Migration and data validation
• Done regression testing and integration testing after migration
• Have done code-review for various modules and code changed by other team members
• Developed test plan and test cases for automation and enhancement tasks
• Participated in User acceptance testing and training
• Involved in Technical Documentation of various applications
• Involved in management reporting stuffs like weekly, monthly status report preparation and review
• Co-ordination with monitoring team and providing required KT to new joiners in the team
• Have mentored new members in the team
EMPLOYMENT HISTORY
Cognizant Technology Solutions from Dec 2009 to Dec 2015 Oracle Financial Services Software Limited from Dec 2015 to Feb 2018 Capgemini from Feb 2018 to May 2021
Innova technologies from May 2025 to Sep 2025
NumpyNinja from Sep 2025 till current date as a freelancer. EDUCATION
Degree College/University
Bachelor Degree (B.Tech) in Information Technology Kongu Engineering College, Anna University
University 19th Rank in B.Tech Information
Technology
Contact this candidate