Praveen Kumar
Mumbai
Summary
Highly skilled in Oracle PL/SQL development, ETL processes, and SQL optimization with over 16 years of experience. Proficient in Oracle database versions 10g through 21c, with strong expertise in PL/SQL, SQL, and UNIX Shell Scripting. Adept in tools such as Oracle SQL Loader, AUTOSYS, and Control-M for automating tasks. Extensive experience in version control systems including GIT and SVN for collaborative development. Expertise in database design including tables, views, indexes, and key performance tuning techniques using EXPLAIN PLAN and DBMS_PROFILER. Familiar with Python and its libraries like Numpy, Pandas, and lambda functions, adding versatility to my programming skills. Well-versed in optimizing complex queries and data management, ready to take on challenging software development projects.
Overview
17
17
years of professional experience
Work History
Sr. PL/SQL Developer
BNP Paribas
Mumbai
04.2023 - Current
- Collaborate with business leaders to shape strategic directions for the OLS application
- Gather and analyze requirements, crafting effective solutions in line with business needs
- Develop, enhance, and maintain the BNP Paribas Group liquidity reporting app (OLS)
- Design new features, fix bugs, and ensure smooth deployment to production
- Monitor app performance, promptly addressing issues, and proposing design changes
- Provide guidance, mentorship, and training to junior developers on OLS app and methodologies.
Sr. PL/SQL Developer
Credit Suisse
Pune
11.2021 - 12.2022
- Led project responsibilities, initially automating and maintaining it through Oracle PL/SQL development
- Created SQL scripts, PL/SQL procedures, triggers, functions, and packages
- Rigorous unit testing ensured module integrity before UAT Sign-off and production
- Crafted tailored SQL queries and procedures for mutual fund sales data extraction
- Prepared detailed technical documentation on system design
- Communicated complex product details effectively to non-technical stakeholders.
Associate
J.P Morgan Chase India Pvt Ltd
Mumbai
11.2015 - 11.2020
- Demonstrated active involvement in all aspects of SDLC including gathering requirements, designing systems, programming,testing and offering support.
- Proficiently worked with stored procedures, functions, and triggers to enhance database functionality.
- Displayed effective communication abilities while collaborating with team members and stakeholders
- Developed and designed ETL jobs, ensuring seamless transition in UAT and production.
- Significantly enhanced the performance of critical SQL queries
- Effectively managed change processes for QA and Production releases, ensuring seamless transitions
- Demonstrated effective leadership skills in managing complex technical projects that resulted in improved infrastructure efficiency.
Sr. Analyst Programmer
Bank of America
Mumbai
12.2013 - 11.2015
- Managed Bank of America's Treasury Bank information system within the Financial Technology Group
- Led development of AOQ, Balances, and IDDA modules in Bank Information System (BIS)
- Prioritized enhancements and new modules, creating procedures, functions, packages, and Unix scripting
- Played a key role in database programming and performance tuning
- Collaborated with DBAs for query optimization and data retrieval efficiency
- Implemented indexing strategies for faster data access
- Crafted tailored complex SQL queries
- Identified and rectified performance bottlenecks through analysis and adjustments
- Utilized database partitioning and monitoring tools for efficiency
- Optimized queries through execution plan analysis and hints usage
- Introduced caching mechanisms for improved application speed
- Significantly contributed to the efficiency of the Treasury Bank information system and its modules.
Analyst Programmer
Comsoft Pte Ltd
Singapore
08.2011 - 07.2013
- Engaged in system study, development, customization, implementation, and unit testing
- Significantly contributed through crafting PL/SQL programs, including procedures, functions, packages, and triggers
- Central role in enhancing existing components and creating critical ones
- Developed procedures, functions, packages, and queries to augment system capabilities
- Produced Business Analytic and MIS Reports, vital for day-to-day operational decision-making.
Consultant
Capgemini India Pvt. Ltd
Mumbai
06.2007 - 05.2011
- Managed various critical functions, including Batch Monitoring and Change Management processes
- Led Service Improvement Plans, overseeing implementation and providing insights
- Efficiently executed Batch Fixes during failures
- Developed essential backend PL/SQL programs in Oracle, automating processes and enabling maintenance
- Designed and created diverse SQL scripts, PL/SQL stored procedures, triggers, functions, and packages
- Excellently understood requirements from the Front Office and clients, preparing accurate estimates and technical designs for enhancements
- Proficiently planned and executed deliverables with meticulous attention to detail.
Education
Bachelor of Technology(B.Tech) - Computer Science and Engineering
Uttar Pradesh Technical University
Lucknow07-2004
Skills
- PL/SQL
- SQL
- Python
- Tableau
- Unix Scripting
- Oracle 10g/11g/12c/19c/21c
- AUTOSYS
- Control-M
- GIT
- Jira
- ITSM
Languages
- English, C2
- Hindi, C2
Timeline
Sr. PL/SQL Developer
BNP Paribas
04.2023 - Current
Sr. PL/SQL Developer
Credit Suisse
11.2021 - 12.2022
Associate
J.P Morgan Chase India Pvt Ltd
11.2015 - 11.2020
Sr. Analyst Programmer
Bank of America
12.2013 - 11.2015
Analyst Programmer
Comsoft Pte Ltd
08.2011 - 07.2013
Consultant
Capgemini India Pvt. Ltd
06.2007 - 05.2011
Bachelor of Technology(B.Tech) - Computer Science and Engineering
Uttar Pradesh Technical University