Kamalavathi Tadi
Mobile no: +1-469-***-****
Email: **********@*****.***
Professional summary:
** ***** ** ********** **** expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment using Client/Server.
Good knowledge on Oracle database architecture.
Applied Database Tuning and Optimization, Normalization in the new database design
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Good knowledge on logical and physical Data Modeling using normalizing Techniques.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique.
Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Created Python Scripts to retrieve data from various cloud systems.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Completed AWS Associate architect certification in 2020.
JOB PROFILE:
Working as “Senior Tech Lead” in Virtusa since September 2019 to till date
Working as “Senior Consultant” in VirtusaPolaris since December 2014 to 2019
Worked as “Software Engineer” in eBizNET Solutions since May 2011 to December 2014.
Worked as “Software Engineer” in Shakya technologies LTD (client-BHEL Hyderabad) from July 2008 to May 2011.
EDUCATIONAL QUALIFICATIONS:
MCA from JNTU, Hyd (Progressive Engineering. College)
BSC from Andra University (G.B.R Degree College)
Database SKILLS:
Languages : SQL, PL/SQL, Python, Java
RDBMS : Oracle 12c, Oracle 11g, PostgreSQL .MY SQL, MS SQL Server
NO SQL DB : Mongo DB
Cloud : AWS (EC2 SE SQS EMR), Hadoop, Spark, Elastic search
Applications : Developer 2000 (Forms 4.5/6i/10g, Reports 6i/10g), Openshift, GIT
Other Database Tools : SQL *LOADER, PL/SQL Developer, TOAD, Hive, Openshift
OS : Windows, UNIX, LINUX, AIX
PROJECT DETAILS:
Project: 1
Project Name:
CFTP
Client:
CITI BANK (USA)
Role:
Senior Tech Lead
Organization:
VIRTUSA-POLARIS
Duration:
Nov 2022 to till date
Team Size:
Global 300
Environment:
Oracle 12c, Apache spark, Scala, Python, Hadoop, Tableau, IFW reports, SQL, Open shift, Kibana, Genkins, AWS Mango DB, Postgresql, Kafka
Project Description:
CFTP: CITI Funds Transfer Pricing
CFTP is centralized funds transfer pricing engine and ability to transfer interest rate risk from business to local treasuries utilizing existing process and vectors under the global transfer pricing policy and ALCO.CFTP performs Liquidity Premium calculations.
CFTP process wide range of contractual data for transfer price and Liquidity computations and process market data like Yield Curve Rates, reference data like Holiday data, Firm Accounts. These data are sourced from various other Citi systems.
Reference data process from SFTP/ NAM server, shell script pull reference data to CFTP locations. ECS (Open shift cluster) -Reference Data ingestion processing Layer (Spring boot, Spring Batch application) Process to ORAAS data bases.
Oracle process and summarize the data as per the business logics and other maintenances. Process data stores in parquet files through data connect Frameworks.
CFTP process all countries data and stamp the appropriate rates using EAP Cloudera Cluster (Spark Batch Processing) and generate various tableau reports, IFW reports.
Generate Feed files and send to various upstream partners
CFTP engine is capable to process high volumes of multiple data sets and generate feed as per the country SLAs.
Roles and Responsibilities:
Involved in all phases of SDLC from analysis, design, development, testing, implementation and maintenance with timely deliverables.
Developed complex DB objects like Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
Processed high volume data sets by using Python scripts.
Developed complex queries for tableau and IFW reports
Worked as part of SME support. Addressed critical functional issues by querying analyzing data sets. Resolved production on going issues and provide immediate work around solutions within stipulated timelines.
Closely worked with support team and resolved long running job issues and technical issues by analyzing spark, Open shift, Kibana logs.
Preparing functional documentation and giving functional KT session to team members
Project: 2
Project Name:
CFTP
Client:
CITI BANK (USA)
Role:
Senior Tech Lead
Organization:
VIRTUSA-POLARIS
Duration:
November 2022 to till date
Team Size:
300
Environment:
Oracle 12c, Java, AWS, Json, Mango DB
Project Description:
CALM : CITI Asset and Liability Model
CITI Asset Liability Model (CALM) is a tool that can be used to make sound decisions regarding plan assets and liabilities. It is particularly helpful in comparing the effects on plan funding of one or more sets of future "what if" scenarios. CALM can be applied to every part of the plan process: plan design, plan governance, and investment management.
CALM provides a platform for decision-making. By analyzing proposed changes in the asset portfolio, plan design, or funding policy, you can see the likely future impact of current choices.
The CALM process evidences due diligence in support of fiduciary obligations of the plan sponsor.
Roles and Responsibilities:
Involved in all phases of SDLC from analysis, design, development, testing, implementation and maintenance with timely deliverables.
Developed complex DB objects like the Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
Troubleshoot product issues to determine the problem root-cause(s), done the work-around and provided solutions.
Involved in Functional, Technical document preparation.
Created of development DBs using the scripts.
Involved in Data migration from web logic server to web sphere.
Lead 12C and oracle cloud migrations.
Closely worked with support team to resolve production issues against aggressive timelines.
Project: 3
Project Name:
BANZ ERP
Client:
BANZ GROUP (Bahrain)
Role:
Team Member
Organization:
eBizNET Solutions
Duration:
April 2013 to Dec 2014
Team Size:
5
Environment:
Oracle 11g
Project Description:
BANZ ERP offers an advanced warehouse management system that provides a full-fledged solution to customers combining intelligent logistics and state-of-the-art warehousing.
Fully integrated inventory, customs and transportation system.
Inventory Management – Multiple units of measure, lot control, bar code scanning, cross-docking and delivery scheduling provides the inventory accuracy as well as better utilization of resources.
Customs formalities – Customs related documents are processed/recorded through the system.
Duty calculation –- Automatic calculation of duty amount based on the item cost, freight, insurance and harmonized code.
E-storage –- All customs related documents are stored in an electronic format, allowing fast and easy retrieval of data
Container Management – coordination with customs and port authorities for efficient and cost effective container movements.
Allows to keep track of bonded and duty paid items separately
Multiple Inventory ownership– Ability to track the inventory by ownership.
Activity based billing –- Different predefined rules for different customers based on their requirements. Accurate billing is carried out based on the activities performed.
Provides critical information like document flow, demurrage, damages, inventory ageing etc.
Block deliveries of items detained by health authorities.
Customer e-portal – 24x 7 access to stock reports and balance inquiry via the internet.
Roles and Responsibilities:
Developed Stored Procedures, Functions, database Triggers and created Packages to access databases from front end screens.
Developed both inbound and outbound interfaces to load data into targeted database using UTL_HTTP packages,XML, webservices.
Created database reports to get open enrollment and enrolled list reports.
Created database tables and wrote database triggers applicable to business rules.
Developed triggers and packages to delete stored session data from various tables.
Debugged various defects related to implementation of business logic.
Project: 4
Project Name:
HSN18
Client:
Home Shop 18
Role:
Team Member
Organization:
eBizNET Solutions
Duration:
Jan 2013 to Apr2014
Team Size:
9
Environment:
Oracle 11g
Project Description:
The Project is to fasten their daily business operations such as receive, order fulfillment,
internal stock adjustments and so on. Replaced their own ERP WMS system with eBizNET WMS system.
As per their business requirements added some advanced functionalities, enhanced and changed the existing
functionalities without disturbing the current process. New functionalities such as serial check In, inbound &
outbound operations without pallet LP, capture multiple serial# (multiple IMEIs for mobiles) and so on.
Enhanced and changed functionalities such as trailer management, serial# generate, barcode label, address
label printing, ship unit manifesting, RF check in process, customized return process by segregating the
return type as RTO & RBC, PO overage, max overage percentage and so on. Provided many managerial,
operational and performance related reports to track warehouse operations. Eventually the product has been
enhanced for online shopping warehouse (WMS) requirements.
Roles and Responsibilities:
1. Written packages, function and procedures for the customizations made for client which includes packages for RF technology.
2. Created tables,views, sequences,synonyms,indexes,types.
3. Functional and Unit testing of product.
4. design and provide queries to reports of homeshop18.
Project: 5
Project Name:
eBizExpress
Client:
GATI
Role:
Team Member
Organization:
eBizNET Solutions
Duration:
Jan2012 to Dec 2012
Team Size:
5
Environment:
Oracle 10g
Project Description: eBizExpress focuses on SCM needs of small and medium businesses to help them develop a strong and responsive Supply Chain capability within a very short time period and a minimal capital investment . The fast paced solution is self-configurable and leverages eBizNET supply Chain expertise to provide substantial business value in warehouse Inventory, Transportation and Reverse Logistics Management.
Roles and Responsibilities:
1. Involved in preparing technical designs.
2. Written packages, function and procedures for the customizations made for client which includes packages for RF technology.
3. Created tables,views, sequences,synonyms,indexes,types.
4. Functional and Unit testing of product.
.
Project: 6
Project Name:
ELS (Event Logistics System)
Client:
RED BULL
Role:
Team Member
Organization:
EBizNET Solutions
Duration:
May 2011 to Jan 2012
Team Size:
5
Environment:
Oracle 10g
Project Description: This system is part of the supply chain process that
plans, implements and controls the efficient, effective flow and storage of goods, services and related
information from the point of origin to the point of consumption in order to meet customers’ requirements.”
To make this happen, transportation, distribution, warehousing, purchasing and order management organizations must execute together.
Roles and Responsibilities:
1. Designed and developed database packages, procedures, functions and triggers, according to the business requirement.
2. Wrote Scripts, SQL queries using joins, sub queries and inline views to retrieve data from the database.
3.Commendable knowledge on all aspects of product development methods - analysis, design, development, testing and problem solving.
4. Create Unit Test Plans for enhancements and fixing the bugs.
Project: 7
Project Name:
BEACON (Biometric Enable Access CONtrol system)
Client:
BHEL
Role:
Team Member
Organization:
SHAKYA Technologies
Duration:
Jan 2009 to May 2011
Team Size:
4
Environment:
SQL, Pl sql and D2k,unix shell scripting
Project Description: This System is developed with Biometric solution for Access Control and Timesheet recording of the associates in the organization. The entry / exit is controlled through the multiple entry gates to the Factory, Administrative Circle and Township – Estate Circle Administration, apart from the remotely access control system like HRD Center based on the work requirements. This is a challenging project which involves modules related to permanent employees and apprentices.
Roles and Responsibilities:
Involved in writing, maintaining, testing, and debugging code in PL/SQL
Developed PL/SQL packages as application-programming interface (API) to access oracle database through other front end application.
Designed and developed various PL/SQL packages, forms, menus and reports.
Analyzed the existing code and optimized, enhanced the existing procedures and SQL statements for the better performance.
migrated the forms and reports which were developed in Oracle Developer 6i to 10g.
maintained the data integrity and security using integrity constraints and database triggers.
Customization of the support screens.
Involved in developing transaction forms which involve many validations at all the levels.
Developed the UNIX scripts to automate jobs and file processing.
Troubleshoot performance issues and bugs within packages, forms and reports.
Prepared checklists, identified test cases, prepared and integrated test plans.s
Wage period which used to be 25th of previous month to 24th of present month has been changed to 1st to end of the month (28/29/30/31).
ADVANCE PAYMENT logic developed for the wage period change.
Project: 8
Project Name:
AMS(Time Sheet Maintaining) for BHEL Corporate Services
Client:
BHEL
Role:
Team Member
Organization:
BHEL
Duration:
July 2008 to Jan 2009
Team Size:
3
Environment:
SQL, Pl sql and D2k
Project Description: This System is developed to monitor the attendance of workers working in Staff Canteen. Employees here work in three shifts viz. first, second and night shift. Monitoring of attendance in each shift and preparation of list of employees those can continue their shifts, in case of emergency. Reports like attendance, night shift allowances, extra hours worked and allied are generated.