SATHEESH KUMAR

Mobile:+1-972-***-****

Email: adcq6i@r.postjobfree.com

Professional Summary

Over 14+ years of experience in software analysis, design and implementation with Oracle 12c, 11g, 10g etc, SQL, PL/SQL and Microsoft SQL Server.

Proficiency in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Virtual Private Database (VPD), Flashback Archive Data for auditing (FBDA) etc.

Performance tuning and optimization using Explain Plan, SQL*Trace, TKPROF and Oracle Optimizer hints, SQL*TRACE, TKPROF, HINTS, DBMS_STATS etc.

Around a year experience on BigData Hadoop (Sqoop, Hive, HDFS, Impala, Kudu, Kafka, Flume Spark Scala), Streamsets.

AWS Certified Solutions Architect – Associate with less than a year experience on Random POCs using EC2 instances, S3, DynamoDB, Redshift, RDS, EMR, Kinesis, Cloud Watch, CloudTrail etc.

Better understanding of ETL with 3 years of working experience.

Data science certified with fundamental concepts.

Having around 6 years of Lead Engineer experience as for monthly and quarterly releases, with agile methodology.

Sound experience in Data Modeling using ERWin, and worked on database design for various projects

Proficiency in developing Oracle Forms 9i, Oracle Reports 9i.

Aware of usage of Design Patterns and other coding best practices.

Knowledge on Oracle GoldenGate 12c middleware.

Proficient in Object Oriented design and Methodologies.

More than 7 years of experience in Oracle PL/SQL Trainings.

Possess good communication and interpersonal skills.

Technical Certifications

AWS Certified Solutions Architect – Associate

OCP - Oracle Certified Associate, Paper-I (IZO-007 with 100% marks).

Data Science Foundation from IABAC.

Experience:

Client: IQVIA RDS Durham, NC. Oct’19 – till date

Title: Lead Oracle Pl/SQL Developer

Description: Infosario Analytics Biogen - a web based data processing and data presentation tool. It consumes data from various sources and process using Java/hibernate to presentation layer. Spotfire reports shows all metrics and milestones required based on the data processed.

Responsibilities:

Analyze software requirements to determine feasibility of design within time and cost constraints.

Design, develop, test and implement software application functionalities using Oracle PL/SQL.

Database design with Entity Relationship diagrams - created conceptual, logical and physical data models, reports and diagrams.

Preparing a relational Data Model with one-to-one, one-to-many and many-to-one relational models.

Enabled audit on each entity using FBDA (Flashback Data Archive).

VPD (Virtual Private Database) implementation for secure data access for users.

Modify database programs to increase processing performance using Oracle PLSQL and other related technologies. Review, test and correct program errors.

Experienced in PL/SQL and SQL optimization and using techniques like indexing, joins/cursor optimization, constraint disabling, temporary tables, bulk collect, collections.

Work on the Agile Methodology to perform migration of data from Legacy inventory to the target database.

Work on the migration scripts and performance tuning the scripts to speed up the data loading.

Performing Master Data analysis to integrate data from different location sources to a consolidated database.

Suggest and deploy telecom standard naming convention for the data objects.

Ensure data quality by performing Data Analysis before and after migration.

Design and perform unit testing and analyze effectiveness and outcome of testing with project management.

Develop PL/SQL stored procedures, functions, packages, views, materialized views, triggers using TOAD and SQL * PLUS, tuned the performance using explain plan. Also, develop Shell scripts and scheduled the jobs in UNIX server.

Experience in reviewing Java code for running the troubleshooting test-cases and bugs.

Experienced in handling Packages, Functions, Modules and Exceptions in the Java.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Designed and performed unit testing and reviewed with project management.

Environment: Oracle 12c, PL/SQL, SQL, SQL Server, Toad, Java, hibernate, SQL PLUS, UNIX shell scripting, Active Batch.

IQVIA RDS India (Pvt) Ltd Jun’11 – Sep’19

Title: Senior Oracle Pl/SQL Developer

Description: SDH (Subject Data Hub)- A web based application that collects data from various sources and provides a single point of access to high level projects for the data analysis and reports.

Responsibilities:

Database design with Entity Relationship diagrams - created conceptual, logical and physical data models, reports and diagrams.

Preparing a relational Data Model with one-to-one, one-to-many and many-to-one relational models.

Design, develop, test and implement software application functionalities using Oracle PL/SQL.

Modify database programs to increase processing performance using Oracle PLSQL and other related technologies. Review, test and correct program errors.

Experienced in PL/SQL and SQL optimization and using techniques like indexing, joins/cursor optimization, constraint disabling, temporary tables, bulk collect, collections.

VPD (Virtual Private Database) implementation for secure data access for users.

Work on the Agile Methodology to perform migration of data from Legacy inventory to the target database.

Work on the migration scripts and performance tuning the scripts to speed up the data loading.

Performing Master Data analysis to integrate data from different location sources to a consolidated database.

Suggest and deploy telecom standard naming convention for the data objects.

Ensure data quality by performing Data Analysis before and after migration.

Design and perform unit testing and analyse effectiveness and outcome of testing with project management.

Develop PL/SQL stored procedures, functions, packages, views, materialized views, triggers using TOAD and SQL * PLUS, tuned the performance using explain plan. Also, develop Shell scripts and scheduled the jobs in UNIX server.

Experience in reviewing Java code for running the troubleshooting test-cases and bugs.

Experienced in handling Packages, Functions, Modules and Exceptions in the Java.

Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable.

Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.

Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, and LISTAGG

Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Designed and performed unit testing and reviewed with project management.

Preparation of run books and builds for automatic deployments.

Environment: Oracle 12c, PL/SQL, SQL, SQL Server, Toad, Java, hibernate, SQL PLUS, UNIX shell scripting, Active Batch.

Ness Technologies, Bangalore Apr’09 to May’11

Title: Oracle PL/SQL developer

Description: QResponse - A web based application that collects information about subjects’ health conditions via questionnaires which are asked to the subjects over the telephone by the QCALL staff prior to their subsequent visit to the site. And QResponse Schedules calls to subjects on a clinical study at predefined intervals or visits, enables Call Centre staff to ask visit-specific questionnaires, in multiple languages, to the subjects on those scheduled calls and Collects the responses of subjects into a secure database.

Responsibilities:

Design, develop, test and implement software application functionalities using Oracle PL/SQL.

Modify database programs to increase processing performance using Oracle PLSQL and other related technologies. Review, test and correct program errors.

Experienced in PL/SQL and SQL optimization and using techniques like indexing, joins/cursor optimization, constraint disabling, temporary tables, bulk collect, collections.

Work on the Agile Methodology to perform migration of data from Legacy inventory to the target database.

Work on the migration scripts and performance tuning the scripts to speed up the data loading.

Performing Master Data analysis to integrate data from different location sources to a consolidated database.

Suggest and deploy telecom standard naming convention for the data objects.

Ensure data quality by performing Data Analysis before and after migration.

Design and perform unit testing and analyze effectiveness and outcome of testing with project management.

Develop PL/SQL stored procedures, functions, packages, views, materialized views, triggers using TOAD and SQL * PLUS, tuned the performance using explain plan. Also, develop Shell scripts and scheduled the jobs in UNIX server.

Experience in reviewing Java code for running the troubleshooting test-cases and bugs.

Experienced in handling Packages, Functions, Modules and Exceptions in the Java.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Designed and performed unit testing and reviewed with project management.

Preparation of run books and builds for automatic deployments.

Environment: Toad, Oracle 12c, PL/SQL, SQL, SQL Server, Java, hibernate, SQL PLUS, UNIX shell scripting, Active Batch.

Wipro Infotech, Bangalore. Jul’08 to Apr’09

Title: Oracle PL/SQL developer

Description: DMS captures the detail process followed at the spares parts & Accessories department in a Maruti Dealership. These processes help the spares manager to manage the department efficiently and effectively.

Responsibilities:

Worked on Developer 2000 with oracle Forms 9i and Reports 9i

Design, develop, test and implement software application functionalities using Oracle PL/SQL.

Modify database programs to increase processing performance using Oracle PLSQL and other related technologies. Review, test and correct program errors.

worked on PL/SQL and SQL optimization and using techniques like indexing, joins/cursor optimization, constraint disabling, temporary tables, bulk collect, collections.

Used PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc.

Work on the Agile Methodology to perform migration of data from Legacy inventory to the target database.

Work on the migration scripts and performance tuning the scripts to speed up the data loading.

Performing Master Data analysis to integrate data from different location sources to a consolidated database.

Suggest and deploy telecom standard naming convention for the data objects.

Ensure data quality by performing Data Analysis before and after migration.

Design and perform unit testing and analyse effectiveness and outcome of testing with project management.

Develop PL/SQL stored procedures, functions, packages, views, materialized views, triggers using TOAD and SQL * PLUS, tuned the performance using explain plan. Also, develop Shell scripts and scheduled the jobs in UNIX server.

Experience in reviewing Java code for running the troubleshooting test-cases and bugs.

Experienced in handling Packages, Functions, Modules and Exceptions in the Java.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Designed and performed unit testing and reviewed with project management.

Preparation of run books and builds for automatic deployments.

Environment: D2K (Forms 9i & Reports 9i) Toad, Oracle 12c, PL/SQL, SQL, SQL Server, SQL PLUS, UNIX shell scripting, Active Batch.

Ashok Leyland. May’07 to Jun’09

Title: Database developer

Description: Ashok Leyland is one of the major companies which deal in Manufacturing and distribution of heavy, medium and light commercial vehicles, marine and industrial diesel engines and spare parts. The main purpose of CAA (Cost Audit Application) is to do annual cost audit of the firm. The modules included in this application are Material, Labors, Unit Overhead, Corporate Overhead and Pro-forma.

Responsibilities:

Design, develop, test and implement software application functionalities using Oracle PL/SQL.

Modify database programs to increase processing performance using Oracle PLSQL and other related technologies. Review, test and correct program errors.

Experienced in PL/SQL and SQL optimization and using techniques like indexing, joins/cursor optimization, constraint disabling, temporary tables, bulk collect, collections.

Develop PL/SQL stored procedures, functions, packages, views, materialized views, triggers using TOAD and SQL * PLUS, tuned the performance using explain plan. Also, develop Shell scripts and scheduled the jobs in UNIX server.

Experience in reviewing Java code for running the troubleshooting test-cases and bugs.

Experienced in handling Packages, Functions, Modules and Exceptions in the Java.

Used Bulk collect and FORALL in stored procedures to improve the performance and make the application to run faster.

Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, and LISTAGG

Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Develop a deep understanding of the system, mentor the development team and enforce coding standards.

Designed and performed unit testing and reviewed with project management.

Preparation of run books and builds for automatic deployments.

Ensure data quality by performing Data Analysis before and after migration.

Design and perform unit testing and analyze effectiveness and outcome of testing with project management.

Environment: Developer 2000 (Forms 6i & Reports 6i), Toad, Oracle 12c, PL/SQL, SQL, SQL Server, Java, hibernate, SQL PLUS, UNIX shell scripting, Active Batch.

Academic

Master of Computer Applications (M.C.A) from S.V.U College of Engineering, SVU University, Tirupati.

Bachler Degree (B. Com) in Commerce, S.T.B.C College, Kurnool.

Professional Training

Oracle GoldenGate 12c (OGG).

SonarQube

Spotfire

Fair understanding of HDFS, Hadoop, Hive, Flume, Spark Scala, Impala, Kudu

Streamsets

Awards and Recognition

Stood Employee of the Quarter for multiple quarters.

Received many “Gold Award”, “Shout Out”, “Out Standing”, “Bravo” and “Applause” awards for the hard work.

Contact this candidate