Ramesh Kumar M V S

• Around 15+ years of It Experience in Development, Enhancement, Maintains, Production support, Data Modeling, PLSQL Programming, Architecture, Reporting, Unix Shell Scripting, Informatica, Reporting Including Business Requirements, System requirements gathering of Enterprise Data Warehouses of Health care, oil and gas, Inventory, online transaction, finance, Entertainment domains.
• Strong technical hands-on experience in Oracle 19c/12c,11g/9i databases, Informatica power center 8.x, 7.x, 6.x, SQL Server 20012,2006,2008.
• Expertise in designing and developing Informatica Mappings from varied transformation logic using filter, expression, rank, router, aggregation, joiner, lookup and update strategy.
• Experience in Extraction, Transformation and Loading of data from heterogenous sources systems like flat files, Excel, XML, Oracle, SQL Server.
• Experience in Data Modeling using Dimensional Data Modeling, Star/Snowflake Schema Modeling, FACT And Dimensional tables, Physical and logical data modeling, using Erwin.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e., Packages, Stored Procedures, Functions &Triggers using SQL Developer and Toad as development tools.
• Extensive experience in developing applications using tools like oracle Forms 9i/6i, Oracle Reports
• Having Strong experience in features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL.
• Having Strong experience in table/index partitioning and data purging techniques.
• Integration of Different Applications with JSON, XML and Web Services.
• Extensively used Attributes like %TYPE and %ROWTYPE data types
• Extensively used Oracle Joins- Inner Join, Left Outer Join, Right Outer Join, Full Outer Join
• Performed regular SQL performance tuning, fixed common SQL performance issues, like inefficient indexing and unoptimized SQL queries
• Extensive experience in using the Oracle system packages UTL_FILE, UTL_MAIL and UTL_SMP.
• Developed, scheduled Microsoft SSIS packages to extract Data from remote systems
• Extract the data from different data sources using Python Scripting
• Developed Applications using Core Java, J2EE, Python
• Strong knowledge and experience in Unix/Linux Shell Scripting, Cron jobs
• Extensively involved in all the phases of SDLC (Software Development Life Cycle).
• Well versed with Agile Project Management System (KANBAN) and JIRA.
• Active contribution to application lifecycle including maintenance, release management, critical bug fixing and ensure error free delivery of the software solution.

• 15+ Years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Having 7+ years of Leading the team with effective work delegation, inspiring the team mates and communicating effectively.
• Knowledgeable Oracle Developer skilled in data collection, analysis and management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work.
• Highly-skilled software development professional bringing more than 15 years in software design, development and integration. Advanced knowledge of Oracle SQL, PL/SQL, MS SQL, AWS/RDS, REST API.
• Developed complex enterprise Healthcare applications and development of unit and system test plans.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• 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 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e., Packages, Stored Procedures, Functions &Triggers using SQL Developer and Toad as development tools.
• Extensive experience in developing applications using tools like oracle Forms 9i/6i, Oracle Reports
• Good knowledge on logical and physical Data Modeling using normalizing Techniques. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based), Materialized Views, Global temporary tables.
• Having Strong experience in features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL.
• Having Strong experience in table/index partitioning and data purging techniques.
• Integration of Different Applications with JSON, XML and Web Services.
• Worked for Disapplying data to different application using the oracle packages and procedures 
• Extensively used Oracle Joins- Inner Join, Left Outer Join, Right Outer Join, Full Outer Join
• Having Strong experience in performance tuning and developing high volume data loads. Should be strong with Exception Handling
• 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 
• Extensive experience in using the Oracle system packages UTL_FILE, UTL_MAIL and UTL_SMP.
• Developed, scheduled Microsoft SSIS packages to extract Data from remote systems.
• Performed code reviews with analysts and application architects.
• Extract the data from different data sources using Python Scripting and developed Applications using Core Java, J2EE, Python
• Strong knowledge and experience in Unix/Linux Shell Scripting, Cron jobs
• Well versed with Agile Project Management System (KANBAN) and JIRA.
• Extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Active contribution to application lifecycle including maintenance, release management, critical bug fixing and ensure error free delivery of the software solution.

B.V. Sc & A.H from Acharya N. G. Ranga Agricultural University, Telangana, India