Rakesh S.

Rakesh S.

SQL Developer

Bengaluru, India
Hire Rakesh S. Hire Rakesh S. Hire Rakesh S.

About Me

Rakesh is an experienced SQL Developer with a data-focused approach to understanding customer needs and translating strategic objectives into action. He develops, builds, evaluates, installs, and administers database systems - delivering sophisticated procedural SQL logic, working on SQL tuning, database modelling and design, relational database architecture, metadata and repository creation and configuration management.

Work history

UpStack
UpStack
SQL Developer
2022 - Present (2 years)
Remote
  • Develop high quality database solutions. Develop, implement and optimize stored procedures and functions using SQL.

  • Work on analyzing existing SQL queries for performance improvements.

  • Implement monitoring solutions to ensure data integrity - working closely with engineers, product managers and other stakeholders.

Wells Fargo
Wells Fargo
Senior Software Developer
2021 - Present (3 years)
Bengaluru, India
  • Designed and implemented a new regulatory reporting system and OFSAA solution within Wells Fargo.

  • Developed solutions for EMEA reporting data, handled engine upgrades and deployed monitoring solutions on the project.

  • Provided end-to-end deployment solutions - executing standards, controls, procedures, and documentation.

Tata Consultancy Services
Tata Consultancy Services
Oracle Database Developer
2016 - 2021 (5 years)
Lucknow, India
  • Designed new applications with PL/SQL customization to enhance OFSAA implementation on projects for clients.

  • Worked on Erwin data modelling and Ab-initio code for migration and delivered T2T, PLC, Batch, and Sub Ledger Applications.

  • Administered and executed database management systems and privileges management protocols on projects.

Snap-on Business Solutions
Snap-on Business Solutions
ETL Developer
2015 - 2016 (1 year)
Noida, India
  • Implemented solutions to reverse-engineer tables and views that create new ODI interfaces, scenarios and load plans.

  • Designed and created packages and scenarios, loaded and executed data using the Oracle data integrator tool.

  • Worked on new solutions to simplify the tuning and publishing process for long-running batches to meet OEM SLAs.

Tata Consultancy Services
Tata Consultancy Services
PL/SQL Developer
2012 - 2015 (3 years)
Lucknow, India
  • Designed and developed new PL/SQL applications and integrated GPS with other database applications within TCS.

  • Liaised with test teams to execute tests, handled process improvements and resolved production/environment issues.

  • Deployed solutions to enhance existing systems, built new modules to improve usability, and estimated efforts to elevate system performance.

Portfolio

SQL Developer - Standard Life UK
SQL Developer - Standard Life UK

Standard Life is a life assurance, pensions, and long-terms savings company in the UK which is owned by Phoenix Group. Designed and implemented database solutions to extract, transform and load data to the IFRS reporting team within Standard Life - handling access time, batch processes, validation checks and security.

SQL Developer - International Reg Reporting
SQL Developer - International Reg Reporting

Worked on an international regulatory reporting solution that manages SOR data messaging, analysis and processing of data pushed to vendor applications for reporting to regulations. Provided end-to-end application development, maintenance and support on the project.

PL/SQL Developer - Procure and Pay Module (TCS Internal)
PL/SQL Developer - Procure and Pay Module (TCS Internal)

Led processes to develop procedures, packages and views for data transactions on the TCS Procure and Pay module - handling reports and mailing from the system. Tuned slow processing queries to achieve optimal results.

Education

Oracle Advanced PL/SQL Developer Certified Professional
Oracle Advanced PL/SQL Developer Certified Professional
Oracle
2013 - 2013
Oracle PL/SQL Application Developer - Associate (OCA)
Oracle PL/SQL Application Developer - Associate (OCA)
Oracle
2012 - 2012
B.Tech Information Technology
B.Tech Information Technology
Shri Ramswaroop College Of Engineering and Management
2008 - 2012 (4 years)