SUMMARY

Senior Database Developer with over ** years of experience in the software industry field providing services to corporate firms in all phases of software development life cycle

Over 10 years of database experience in Oracle and 7 years in Sybase dealing with various aspects of database analysis, design, development, maintenance, query analysis, performance tuning and SQL batching

ETL Experience Informatica: 2 year

Over 6 years’ experience using Perl and Shell scripting in a Unix/Linux environment to automate various maintenance, file processing and reporting tasks and 1 year of Python experience

Proficient in all phases of Software Development Life Cycle (SDLC) and Agile Scrum methodology

Excellent analytical, communication and Interpersonal skills.

Ability to quickly grasp and adapt to New Tools and Applications.

Excellent team player with the ability to manage and work independently in a time sensitive environment.

EDUCATION

oMaster of Science in Computer Science, Southern Illinois University Carbondale, Illinois

oBachelor of Technology in Computer Science & Engineering, Institute of Technology, Varanasi, India

EXPERIENCE

Pluto Technologies Inc Sept 2021 – Present

Title: Senior Developer

Client: TIAA-Cref

The Retirement Services Train is leading the development of a new model engine for the RetirePlus Portfolios that TIAA offers its clients.

Responsibilities:

Developed migration tool to migrate data from MMS Oracle database system to new MIM Mongo database using Python

Developed SQL queries to extract plan configuration data from MMS to store in ICON system.

Analyze dependencies and enhance queries to handle corrupt data in lower environments.

Mentored and trained new team members on tools developed

Actively participated in Agile Scrum ceremonies

Involved in code reviews to deliver quality code

Environment, Oracle 12c, MongoDB, GitLab, JIRA, DBeaver, Studio 3T, Compass IDE, Python, PyCharm

Deutsche Bank Apr 2016 – Sept 2021

Title: Senior Engineer

The Level1 Trade Surveillance team of the Regulatory GT department of Deutsche Bank is responsible for the monitoring and validating trades from the Trade Store system where trade data is sourced from multiple systems across the bank.

The Level1Controls team of the Regulatory GT department of Deutsche Bank is responsible for the enhancement and support of the Global Supervision System (GSS/Navigator Task Manager) application which helps supervisors across the bank track violations/ breaches by their direct reports for various regulatory rules (Volcker, Dodd Frank, KYC, Clean Desk, MTA). Supervisors can provide evidence that the breach/violation has been remediated or why it may not be valid.

This system helps the bank keep an audit of all violations or breaches to meet regulatory requirements.

Responsibilities:

Optimized various PL/SQL queries to optimize flows

Enhanced database procedures, views, triggers and queries for various workflows in Level1Controls

Design and develop compaction jobs for HDFS system

Upgraded dbTradeStore and reference data systems api to latest versions in Informatica workflows

Planned and Identified Tasks and Estimates and Coordinated various projects from 2017 Q3 - 2019 Q3

oEliminate CMIS dependency to support enhanced reporting and auditing requirements, enhance application stability and improve consolidated output reporting job performance

oDecoupling of GSS Reporting Module to enhance application stability and improve performance of the daily consolidated output reporting job

Upgraded Informatica 9.5.1 to 10.2

Developed materialized views for new pipleines

Developed tool to load test data to lower environments from preprod database using Python scripts

Actively participated in Agile Scrum ceremonies

Involved in code reviews to deliver quality code

Environment, Oracle 12c, Informatica 10.2, Git 2.2.4, JIRA, SQL Developer, Python, PyCharm

Matlen Silver July 2015 – Nov 2015

Title: Senior Developer

Client: Bank of America, Charlotte, NC

The Improved Risk Rating team of the Enterprise Credit Derivatives department at Bank of America is responsible for developing and supporting the Scorecard application which allows internal users of the bank to rate various obligors and associated facilities. The application portfolio includes several related web applications, JMS framework and web services that support transaction management, user access management, application configuration management, a dashboard tool, message notification management, financial statements retrieval and transaction events publishing.

Responsibilities:

Design, analysis, development and testing of several database enhancements to the Scorecard web application developed using Java making JDBC calls to retrieve data from Microsoft SQL Server database

oEnhanced application to support appropriate Memo Exposure under the Leverage Leasing tab for facilities with Wholesale load instrument

oFixed bugs in the Scorecard application causing the application to break when double quotes are introduced in Obligor name, when Save button was clicked twice in Collateral screen and when Collateral with a long description was selected to be saved for facility rating

Involved in DR activities to support the Actuate reporting framework which generate the Risk Rating Detail Reports and Risk Rating Review Reports

Participated in Daily Scrum calls as part of the Agile Project Methodology to deliver code in 2-week Sprints

Involved in code reviews to deliver quality code

Environment Microsoft SQL Server, VersionOne, Linux

Verizon Wireless, Irving, TX Dec 2012 – Nov 2014

Title: MTS III Cslt-Sys Engr

The Cloud Web Portal App team in the Vzw IT HandSet Self Service Department of Verizon Wireless oversees the development and support of the online BackUp Assistant website which allows a Verizon Wireless customer to view and manage any contact or media file they have backed up through their mobile device. The web application interacts with the cloud server using RESTful APIs to manage cloud content. When a contact or media file is backed up through the mobile device, the backend sync process updates the web application.

Responsibilities:

Developed and maintained device meta data and user preference details in Oracle tables

Participated in user story, design review and code review meetings to provide feedback and solutions to business and technical problems for revamp projects

Shared personal lessons learnt and tips in using Accurev (newly introduced versioning tool) with rest of team

Helped support the Backup Assistant and Sync and Connect applications in production

Raised application security and/or vendor contract violation related concerns to team management from design perspective

Environment Oracle 8, JIRA, Linux

CITIBANK INC, Warren, NJ Aug 2011 – Nov 2012

Title: Senior Programmer Developer (AVP)

The Prime Finance Asset Servicing (PFAS) IT Department caters to the needs of Citibank Prime Brokerage Clients and Trading department of the Prime Brokerage business. The Prime Finance portal hosts the Corporate Actions web application which allows Clients and Citibank traders to view and elect on various Voluntary or Mandatory corporate actions with Options that occur on traded securities having client positions. The portal also hosts various Asset Servicing related Crystal Client reports such as the Corporate Events, New and Amended Events, Dividend/Interest Accrual/Announcement and Proxy reports. Various Batch processes retrieve Corporate Action related events, positions, account and security data from different source systems into the PFAS system to be viewed on Corp Action Web Portal and Reports.

Responsibilities:

Design, analysis, development and testing of the server-side process to load Corporate Event XML messages received from the new source system ASPEN using MSSQL backend database.

Requirement Analysis, Development and Support of Crystal MSSQL reporting logic to meet business requirements and to facilitate roll out of new Crystal report framework to Clients.

Support business client queries on Prime Portal Corporate Action application

Environment MSSQL, SVN, Ksh scripting, Autosys 5

PERI Software Solutions Inc, Jersey City, NJ Oct 2004 – Jul 2011

Title: Software Analyst

Client: Goldman Sachs (Securities Lending Technology Department)

The Securities Lending IT Department supports the Trading and Business Operations personnel of the Securities Lending business interacting with Clients and Brokers on a day to day basis. The various applications developed for the supply side business allow users to lookup inventory and pricing, book trades and adjust contracts. Autosys automated batch jobs maintain trade consistency with respect to market conditions such as pricing of securities (Automarks), computing client billing, archiving of position related data and other application maintenance tasks.

Responsibilities:

Design, analysis and development of DB2 backend database objects.

Research and Technical analysis of existing system to be re-engineered

Analysis and Development of batch jobs for retrieving prices from strategic product and price sources to be loaded into system.

Design, analysis and development of Reporting infrastructure for automating Trading and Operational reports using Composite software, a data virtualization tool while implementing the MVC model.

Developed and enhanced Perl, CGI, C and Bash shell scripts involved in batch processing and reporting for the Automarks, Contract Compare, Contract Maintenance and Position Calculation processes.

Analyzed, Batched and performance tuned Sybase SQL queries and monitored database health

Participated in Perl, SQL, JIL and shell script code reviews

Small enhancements to Perl, Shell script, database objects to fix bugs or enhance functionality.

Supported Adhoc User data queries by generating on demand trading and operational user reports

Environment:, DB2, Sybase, Composite software, CVS, Eclipse, JIRA, Perl, CGI, Bash scripting, Autosys, Rapid SQL, Aqua Data Studio, SCCS, SVN

Contact this candidate