Ramesh Kumar Email & Phone Number

Pune, Maharashtra, India

Pune, Maharashtra, India

Role: Assistant vice president | Database team lead Domain: Operational Risk management, Governance risk compliance- Managed end to end delivery of various dashboards and DB applications- Worked on performance tuning of SQL queries- Set up CICD pipeline for DB deployment using Bitbucket, Jenkins and RLM- Build Datawarehouse from very beginning using Sqoop, hive and Oozie.- Worked on improving dashboard performance and data accuracy.- Designed and developed application, relational data models and reports using SQL, PLSQL. - Managed to keep defect ratio below 10%- Helped users with improving processes for quality deliverables.- Handled both OLTP real time application and its Datawarehouse in bigdata

Pune Area, India

• Developed Oracle PL/SQL packages, procedures, functions, and anonymous pl/sql block based on technical and functional specifications • Extensively worked with Dynamic SQL , Composite data types & Global TemporaryTables• Performing SQL tuning for long-running Adhoc SQL and informatica jobs• Created and Modified existing PL/SQL stored procedures, packages and functions to incorporate change requests • Developed PLSQL routine for data upload using SQL loader and conversion logic to load data in target system for new partner and dealers• Debugging issue/escape and providing production support• Build business reports in MS Power BI and MS Excel• Build CICD pipeline for Auto deployment using Jenkins• Leading a team of 3 member

Pune Area, India

Responsibilities:- Develop Oracle PL/SQL stored packages, oracle objects types (record, table), PL/SQL object types, procedures, functions, SQL Loader script, and triggers based on technical and functional specification documents. - Modify existing PL/SQL stored procedures, packages, functions to incorporate change requests- Data extraction, transformation and load (ETL) using Pervasive Data Integrator and SQL Loader-Code Version Management using Tortoise SVN- Application configuration, events creation, validations creation, rule set creation for import of data, screen designing, interfacing jobs etc. for existing application- Collaborate with cross functional teams / functional units at offshore/onshore to ensure completeness of tasks with quality- Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based)- Extensively used bulk collection in PL/SQL objects for improving the performing- Performed SQL and PL/SQL tuning using various tools like EXPLAIN PLAN, and AUTOTRACE.- Document the business process flows- Involved in the on-Call Production Support

Master In Computer Management, Computer Engineering, First Division

Activities and Societies: Debate Team Member, Member of organizing committee of Annual function, Seminars and Sports activityMaster.

Bachelor Of Computer Science, Computer Science And Networking