Work History
Showcase
Education
Work history
UpStack
SQL Developer
2022 - Present (3 years)
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
Senior Software Developer
2021 - Present (4 years)
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
Oracle Database Developer
2016 - 2021 (5 years)
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
ETL Developer
2015 - 2016 (1 year)
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
PL/SQL Developer
2012 - 2015 (3 years)
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.
Showcase
SQL Developer - Standard Life UK
Standard Life is a UK life assurance company owned by Phoenix Group.
The company specializes in database solutions for data extraction, transformation, and loading.
Their focus is on handling access time, batch processes, validation checks, and security within the IFRS reporting team.
SQL Developer - International Reg Reporting
Managed international regulatory reporting solutions for data messaging, analysis, and processing.
Provided end-to-end application development, maintenance, and support for the project.
Focused on the SQL Developer - International Reg Reporting project.
PL/SQL Developer - Procure and Pay Module (TCS Internal)
Developed procedures, packages, and views for data transactions within the TCS Procure and Pay module.
Tuned slow processing queries to improve performance.
Led process development for data transaction handling, including reporting and mailing.
Education
Oracle Advanced PL/SQL Developer Certified Professional
Oracle
2013 - 2013
Oracle PL/SQL Application Developer - Associate (OCA)
Oracle
2012 - 2012
B.Tech Information Technology
Shri Ramswaroop College Of Engineering and Management
2008 - 2012 (4 years)