Anshul Upadhyay

anshulup910@[Link]
347-227-1747

Summary

 Strong hands-on experience of 11 years with large IT applications on requirement, analysis,

coding, testing, implementation, maintenance and review
 Good experience in Oracle, Perl, Unix programming
 Well-versed in Perl and HTML/JavaScript based web applications
 Experience in PL/SQL programming, including effective use of Oracle packages, stored
procedures, database triggers and tools like SQL*Plus, SQL*Loader
 Strong coding and programming experience in PL/SQL using cursors, ref cursors, collections
and bulk collects
 Design, develop, and maintain ETL jobs to extract, transform, and load data from multiple source
systems into data warehouses and data marts.
 Good experience in scripting and programming in different languages, including Unix shell and
Perl
 Strong development, support and administration knowledge on SQL, and PL/SQL
 Ability to develop/maintain applications and write complex PL/SQL queries.
 Great customer support skills and adaptable to changing business needs
 Good project management, communication, and interpersonal skills
 Smart-working & enthusiastic about learning new technology & tools

Technical Skills

Programming Language : Python, Perl, PL/SQL, SQL, JavaScript

RDBMS : Oracle, MS SQL Server, MS Access
Operating System : UNIX, Windows, Linux
Web Server : Apache Web Server, Weblogic, Wepsphere
Tools : SQL Loader, SQL Plus, MS Office

Professional Experience

TechOps Investments March 2023 to Present

T Rowe Price, Baltimore, MD
Sr. SQL Developer
The TechOps Investment (EASE) team was formed to support around 750 applications for various
investment team like Trading, Front Office, Reporting, Accounting and Performance, Data distribution and
Quantitative Analysis. The main objective for the team to provide the standard and consistent global
production support service across the entire portfolio. The service includes Production support and
resolution of event driven applications alerts and failures.

Responsibilities:

 Performed transactions using SQL Database and using PL/SQL, stored procedures.
 Worked on improvising the performance of the existing SQL Queries
 Fine tuned database procedures and PL/SQL scripts for performance tuning
 Generated PL/SQL and shell scripts for scheduling periodic load processes
 Designed custom reports with associated materialized views and PL/SQL procedures to
summarize backend Oracle data
 Followed up with the source based on the files that were missing
  Set up PL/SQL package to analyze the tables and indexes, records tables and rebuild indexes
 Develop complex SQL queries, stored procedures, views, and functions to support ETL
transformations and business reporting.
 Debugged and wrote error trap routines in Unix Korn Shell
 Worked on the missing data from the table in the database and investigating the root cause of the
failure
 Used Oracle PL/SQL tables, ref cursors to process huge volumes of data
 Worked on the deletion of the old tables to empty the DB space
 Automated the data validation and loading process using Unix shell script
 Developed Server side PL/SQL (Stored Procedures, Functions & Packages) for implementing
complex business logic
 Analyzed production issues as necessary to determine the cause of the issue and determine the
solution.
 Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables
 Focused on providing agile software solutions to clients demanding the best that IT has to offer
 Write, optimize, and maintain complex SQL queries to retrieve, analyze, and manipulate large
datasets.
 Designed and optimized SQL transformations and ELT processes using Snowflake warehouses,
tasks, and streams.
 Migrated Oracle workloads into Snowflake by redesigning tables, secure objects, and micro-
partitioning.
 Tuned Snowflake queries using clustering, warehouse optimization, and query profiling.
 Built ELT pipelines integrating AWS S3 → Snowflake for automated ingestion of JSON/XML data.
 Developed and optimized complex PL/SQL stored procedures, functions, packages and
triggers for high-volume financial datasets.
 Designed and automated data loading and validation workflows using Unix shell scripts for
scheduled batch processing.
 Tuned SQL queries and database objects using indexes, partitions, and materialized views to
improve ETL performance.
 Investigated missing data issues and production failures, ensuring accurate data movement
across systems.
 Implemented data auditing and consistency checks for validating source-to-target
transformations.
 Monitor and troubleshoot ETL job failures, performance issues, and data discrepancies.
 Wrote audit programs for data consistency check and validation.
 Monitored log activity to ensure error free data retrieval.
 Optimized Performance tuning on a PL/SQL web application database
 Handled the tasks of reviewing technical projects during various stages of development life cycle.
 Developed and performance tuning PL/SQL, packages, procedures, functions and triggers
 Tested the application in Windows and UNIX server.
 Optimized performance on a PL/SQL web application database
 Assisted in user support and training
 Participated in providing off hour and 24*7 support.

Environment: Oracle Database 12c and 18c, PL/SQL, SQL, Jira, ServiceNow, Perl, Unix, ESP, Github

PMTS November 2020 to February 2023

Nationwide Mutual Insurance Company, Columbus,OH
SQL Developer
PMTS is responsible for creating, tracking and reporting on all payments issued by the Nationwide
Financial Company administration areas. Both interface and manual payments are processed. It has
become the repository for all tax data for various business area beginning since [Link] includes the
Payment activity and adjustments (both financial and non financial) made to the payment or Payee after
the payment was issued. The Payments can be issued one of the four methods -ACH, Check, Zero-Net and
Pre-Notes

Responsibilities:

 Developing new PMTS screens using Oracle forms 12g

 Attend 3 amigo meetings to understand the requirements of business and then start with the
development work
 Wrote SQL and PL/SQL scripts to retrieval data from SQL database
 Work on creating an estimation document for the effort required for my development work
 Develop and maintain SQL scripts for data extraction, transformation, reporting, and automation
tasks.
 Optimize ETL workflows and database performance using indexing, partitioning, and query tuning
techniques.
 Developing codes in PERL and Groovy (Java)
 Work on production cards picked up from Jira and Service Now
 Create CHG’s to implement the codes to production
 Worked on UAC to create new workflows and jobs
 Migrated workflows and jobs from ESP to UAC
 Worked with offshore teams to help with on call process
 Maintaining all Unix based source code in GitHub
 Built data extraction and transformation workflows using PL/SQL, Perl, and Groovy scripts for
financial payment processing systems.
 Automated CSV-to-database data loads using SQL*Loader, similar to SSIS file ingestion.
 Collaborate with data engineers, analysts, and business stakeholders to understand data
requirements and implement scalable ETL solutions.
 Migrated Oracle workloads to AWS and Snowflake, supporting cloud-based ELT pipelines.
 Created and maintained tables, views, procedures, and triggers for staging and reporting layers.
 Supported system testing and production deployments using Jenkins, UCD, and scheduling tools
(ESP/UAC).
 Troubleshoot and resolve SQL errors, performance bottlenecks, and data inconsistencies.
 Created Perl programs with DBI routines for the Oracle connection.
 Creating new tables, views, Procedures for various database activities
 Using Ruby mine tool for creating Automation process for the generation of test data files and
running flows for various systems
 Creating groovy scripts for the creation of new files and updating the quarterly/monthly files dates
in the database
 Developed cloud-based ELT workflows using AWS services (S3, Lambda) integrated with
Snowflake.
 Created Snowflake SQL scripts, views, and procedures to modernize legacy logic.
 Processed semi-structured data (JSON, XML) using Snowflake VARIANT and FLATTEN.
 Automated Snowflake data loads using Snowpipe and scheduler tools (ESP/UAC).
 Modified scripts to change the mechanism for automatic serial number allotment
 Wrote PL/SQL functions, cursors, triggers and embedded them in PL/SQL packages.
 Migrating the application to AWS cloud and hence working with tools like Harness, Ingress,
Kubernetes, and docker
 Working with Job scheduling tools like ESP to control the mainframe production flow and
monitoring the job using CA Workstation tool
 Experience working the production Team during on call week (once after every 5 weeks)
 Wrote packages using PL/SQL to access data from the database and write into and extract from
 flat files using SQL* LOADER utility
 Experience working with Auditors to provide audit information
 Worked on creating cursors to complete the functionality of updating the raised tax percentage for
various states using tax app application
 Worked on creating functionality in ESP Tools for all the jobs to run only for NYSE (New York
Stock Exchange) open days
 Worked on resolving the overdue for jobs and monitor the incoming files from UV Clouds and
PMTS
 Used SQL*Loader to convert the data from the CSV to SQL tables
 Work with Jenkins to build the jar file to be implemented in production and use UCD tool to
deploy the new developed code to production
 Work on creating documentation for all our codes and post it in SharePoint so as to make sure it
can be referenced later
 Responsible for Performance tuning activities in PL/SQL
 Work on changing the passwords for all the PMTS applications for my team and the Business users
and update the same in PIDM Website which is accessible by the team and the business
 Work with other developers and have a code review session to help team walk through all the new
codes and everyone is aware of the new changes
 Have experience working with the API’s using postman to create new API
 Write SQL queries in database for completing the adhoc request that are needed by the auditors
or business for auditing the work

Environment: Oracle Database 12c and 18c, PL/SQL, SQL, Jira, ServiceNow, Perl, Unix, ESP, Github,
Rubymine, Groovy(Java), CA Workstation, Unix, Oracle Forms 12g, AWS, UV Clouds, S3 Bucket

ONE Revenue Assurance October 2019 to October 2020

Verizon, Irving,TX
SQL Developer
One Revenue Assurance is a data migration project where Verizon was migrating its data from
Oracle to Hadoop. The purpose of doing so was because of slow running queries reference data delays,
badly optimised queries, tablespace issue in oracle, Filespace issue and limitation on file transfer. The
Wholesale Component is used for invoice validation and working of error handling issues. It has a number
of reports that are used to validate the various sections of the invoice. It submits tickets to the US if there
are significant differences between the reports and invoice. The USAGE under wholesale provides a
summary of issues that have occured on the previous day and which tickets need to be prioritised. Boulder
is used for tracking the projects. The JITR-EH is an application that provides the RA team the ability to pull
real time queries for them to review, investigate and perform manual recycles. While migrating to hadoop
the team is developing a pull process to directly pull data from source database, create dashboards for
monitoring the pulls process and repull process, proper creation of loaders and movers, creation of repull
process to check on missed pull process. The USAGE Component deals with the usage of DATA, CALLS and
MESSAGING. It comprises almost 190 scheduler jobs to run each day. It is responsible to load 600 Tables
across three Schemas and comprises many pull processes to pull data from the source in the form of ETL
method. It also had a functionality of front end which would help to monitor the reports.

Responsibilities:

 Worked on the creation of pull process to pull data directly from the source Database. The pull
process will run daily or hourly
 Designed and implemented Schema for the backend databases using PL/SQL
 Implement error handling, logging, and audit controls for ETL processes to ensure regulatory
and operational compliance.
 Worked on creation of a repull process to run if in case the pull process fails to pull the data. The
 repull process runs Daily
 Worked on creation of new tables for migration process along with the creation of Indexes,
Partitions and Grants
 Worked on fixing the data and synchronizing the data for different Components in PROD and UAT
 Set up Oracle PL/SQL package to analyze the tables and indexes, records tables and rebuild
indexes
 Used Jenkins to deploy the New CLOBs From GITLAB
 Saved all our code changes in GITLAB so that we are able to refer it at later stages
 Worked on Bugs, Stories and Enhancements assigned to us from JIRA and SERVICENOW
ticketing tool
 Designed ELT pipelines to ingest large datasets into Snowflake for analytics and validations.
 Tuned Snowflake warehouses and SQL for performance improvement of pull/re-pull processes.
 Developed Snowflake stages, file formats, and secure views for Parquet/JSON/CSV ingestion.
 Implemented Snowflake RBAC roles, grants, and security best practices
 Automated SQL*Loader to load the data from flat files.
 Developed complex SQL scripts to generate data content records for automatic content generation
 Designed and executed end-to-end ETL data pull and re-pull processes for migrating large volumes
of data from Oracle to Hadoop/Snowflake.
 Developed automated data loaders and movers using SQL, PL/SQL, and Unix shell scripts for
scheduled data ingestion.
 Created and managed staging, target tables, indexes, partitions, and grants for Data Warehouse
environments.
 Tuned data extraction performance and warehouse load queries to ensure efficient batch
processing.
 Implemented data validation, file monitoring, and failure recovery processes for failed ETL jobs.
 Worked on creating of sequences and Retention Scripts for the tables
 Created Packages and Procedures for testing our code and for new tables
 Worked on Enhancing and improvising the reports that we used to receive for the missing files or
failed pull or repull process
 Designed and developed many Perl modules for data validation work
 Worked on creating new loaders and movers to move the files and load the data successfully
 Improved performance issue for the existing pull and repull processes
 Created multiple PL/SQL procedures/sub routines to retrieve data used in input module.
 Worked on creating new columns in the tables and updating the logic in the queries for the pull
and repull process
 Created flat files with SQL*Plus from Oracle tables in Unix environments
 Worked on creating specific DB Accounts for the users to access our Database
 Worked on the Enhancement and Fortification of the Java Code Applications using ECLIPSE
 Created multiple Perl scripts to support front end team for report output.
 Worked on creating generic process, usage reporting, pepclobs tables, usage missing files
process, REVO loader issues reports

Environment: Oracle, PLSQL, SQL, Perl,Linux, Python, Jenkins, Java, Eclipse, Gitlab, Jira, Toad, SQL,
Crontab, Putty

Fixed Income Market Making August 2018 to September 2019

Wells Fargo, New York, NY
SQL Developer
Fixed Income Market Making is a platform where one can perform market-making/pre-trade activities for
all fixed income instruments. It is the strategic cross-product solution to replace some of the current
tactical systems.
Responsibilities:

Debugged and wrote error trap routines in Unix Korn Shell

 Wrote many Perl programs for data file loading
 Uploaded Employee Entree Module data into Oracle database using SQL Loader
 Wrote many Java programs to do the data validation
 related problems, enhancing applications by tuning database access and designing alternative
solutions
 Schedule and automate ETL jobs using tools like SQL Server Agent, Informatica, Talend, SSIS, or
Airflow.
 Employed agile techniques to ensure timely delivery of required components to support new
application development
 Developed reports that would automatically produce excel output in the export module.
 Managed UNIX jobs for data automated import and export of data using Perl scripts.
 Used Java techniques including threading and Java class hierarchy
 Improved performance of all the modules through tuning.
 Created multiple Perl scripts to support front end team for report output

Environment: Oracle, PL/SQL, SQL*Loader, SQL *Plus, Perl, Cron Tab, UNIX, HTML, JavaScript, SQL

Clearing & Settlement System November 2012 to July 2016

Forex Capital Markets, New York, NY
Oracle PL/SQL Developer
This System provides real-time fund settlement and securities obligation of trading members with the
online access to settlement accounts, reconciliation reports and accounting information. It also arranges
for some features like the pay-in/pay-out, it collects and maintains the margins, processes for shortage in
funds and helps to clear and settle the trades.

Responsibilities:

 Gathered requirements from the client for front end design and developed software requirements
specification
 Created Perl Scripts that retrieved data from the database using Oracle PL/SQL blocks.
 Document ETL workflows, data mappings, and technical specifications for maintenance and
knowledge transfer.
 Involved in Perl based database work using DBI/DBD
 Participated actively in the design, building, testing and deployment stages.
 Implemented the Agile Scrum process to manage project
 Participated in the requirements gathering phase interacting with several clients to define the
scope of the product.
 Prepared the test cases and created the mock data for rules, covering all the positive and negative
scenarios and prepared test results.
 Worked on Agile SCRUM environment
 Wrote control files and loaded the data into the Oracle database with SQL*Loader
 Designed and implemented reusable base Java code modules
 Created flat files with SQL*Plus from tables in Unix environment
 Developed Unix Shell scripts to run Korn shell Tabs for Incremental Updates
 Provided after hours support during production and deployment.
 Guide the team and also involved in knowledge transfer sessions.
 Automated the upgrade process through the use of batch programs and Perl scripts
 Installed, Configured and provided production support.
 Ensured appropriate level of documentation is created
Environment: Oracle, PL/SQL, SQL, SQL*Loader, SQL Perl, Cron Tab, UNIX, DBI/DBD, *Plus, HTML,
JavaScript, CSS

Education: Bachelor of Technology from Rajasthan Technical University, 2012

Masters in Software Engineering and Development from Pace University, New York,2018