Sql Server Data Integrity
Resume:
RAJENDER DICHPALLY
********.*********@*****.***
SUMMARY:
Proficient in PL/SQL, SQL, Stored Procedures, Functions, Triggers, Packages, and Performance Tuning for high-performance database applications.
Hands-on experience in database modeling, normalization, and indexing strategies to enhance data integrity and query performance.
Performance tuning SQL Server and PL/SQL code for optimum performance of the database.
Proficient in DW/Submit batch processing, focusing on performance improvements and resolving batch job failures.
Strong knowledge of ETL processes, data migration, and data warehousing using Oracle tools such as SQL Loader, Data Pump, and Oracle GoldenGate.
Adept at writing and optimizing complex SQL queries, views, materialized views, and partitioned tables to improve application efficiency.
TECHNICAL SKILLS:
Databases: Oracle (19, 12c & below), SQL, SQL Server (2019, 2014 & below), Sybase 12.5, MS Access, DB2.
Tools: Oracle Intelligence Builder, OBI, SSRS, SSIS, SSAS, Cognos, .Net (4.0 Framework), ASP.Net, Crystal Reports (14.1 and below), Erwin, SharePoint, VSS, Shell Script, Java Script, VB Script, ASP, JDBC, XML, Active X, MTS, Perl.
EDUCATION:
NEW YORK INSTITUTE OF TECHNOLOGY
MS Computer Science 1997
Master of Business Administration Finance 1994
Master of Business Administration Marketing 1993
MIZUHO BANK, Manhattan, NY –
Senior Database Developer/ Analyst March 2017 - Present
Working on the Management reporting (VaR calculation), Data Analytics and Data Mining. Used Oracle and Exadata backend queries/ Stored proc’s for Implementing and Maintaining Business logic.
Worked on Oracle PL SQL Queries for business users for Data analysis and Data Mining.
Designed and implemented efficient JSON/XML data processing workflows, ensuring seamless data transformation and integration.
Developed and optimized parsers, validators, and transformation scripts for JSON and XML data structures.
Optimized PL SQL queries and database performance through indexing, query optimization, and data normalization.
Designed and developed complex PL/SQL stored procedures, functions, triggers, and packages to optimize database functionality and performance.
Conducted SQL query tuning using EXPLAIN PLAN, TKPROF, and AWR reports to enhance database performance.
Utilized JavaScript to build front-end applications that interface with SQL databases.
Implemented security measures, such as encryption, auditing, and role-based access control in MSSQL.
Diagnosed and resolved performance bottlenecks in high-volume transaction processing systems.
Created shell scripts to automate data import and export tasks between databases and external systems.
Developed ETL processes using SQL Loader, Data Pump, and external tables to handle large datasets.
Optimized Oracle/ Exadata database performance through indexing, query optimization, and data normalization.
Designed and implemented data archival and purging strategies for improved storage management.
Conducted database performance tuning and troubleshooting to resolve slow-running queries and other performance issues.
Automated database backups, restores, and disaster recovery processes using RMAN.
Developed and maintained ETL processes using SQL Loader, Oracle Data Integrator (ODI), and Informatica.
Developed materialized views, snapshots, and data replication strategies to enhance reporting performance.
Developed APIs and database interfaces for seamless integration with third-party applications.
Created batch jobs and automation scripts using Shell scripting and Python for data processing.
Managed database security by implementing role-based access controls, encryption, and auditing.
Implemented and maintained data warehouse solutions for business intelligence and reporting.
Created and maintained documentation for database structures, processes, and best practices.
Performed data cleansing and transformation tasks to ensure data accuracy and consistency.
Collaborated with cross-functional teams to gather database requirements and design scalable solutions in MSSQL.
Managed and configured Sybase databases, including installation, upgrades, and patch management.
Designed and implemented automated scripts for routine database maintenance tasks, such as backups and indexing.
Implemented AJAX calls using JavaScript to fetch data from SQL databases asynchronously, improving application performance.
Worked in Agile development environments, participating in sprint planning, daily stand-ups, and retrospectives.
Optimized T-SQL queries to improve database performance and reduce execution times.
Developed and maintained complex SQL queries for data analysis and reporting.
Generating Reports to Management on Risk Analyses and Compliance. Supporting users spread across multiple groups – Fixed Income, Equities and Traders.
Environment: Oracle 19 and below versions, Exadata, SQL Server 2019, Tableau, Actimize, SSRS, linux, Azhure, DBeaver, ICloud, SSIS.
PRICE WATER HOUSE COOPERS, Manhattan, NY –
Senior Database Developer/ Senior Programmer/ Analyst/ Project Lead February 2016 – March 2017
Worked on the Global Independence Compliance application that monitors the security holdings of all Partners/ Managers of the firm to adhere to compliance issues. I managed a team of 8 developers remotely.
Worked on creating stored proc’s and queries in Oracle PL SQL/ Exadata for business users.
Participated in the development of database architecture and design standards to ensure scalability and performance.
Managed MSSQL databases, including installation, configuration, upgrades, and patch management. Worked on Actimize environment.
Created PL/ SQL scripts to automate data integration and ETL processes.
Utilized shell scripting to automate the deployment of database updates and patches.
Wrote several stored procedures, triggers and views for the reporting database in MySQL. Wrote stored procedure to pull data from Reuters/ Bloomberg.
Created JavaScript-based data validation scripts to ensure data integrity before submission to SQL databases.
Developed data migration scripts for transitioning from other database systems to Sybase.
Assisted in the troubleshooting and resolution of database-related issues, including connectivity and performance problems.
Created Python-based ETL pipelines to integrate data from multiple sources into SQL databases.
Utilized T-SQL to design and implement database schemas, tables, and relationships.
Designed and implemented data migration strategies to support system upgrades and integrations. Designed and implemented data migration strategies to support system upgrades and integrations.
Developed shell scripts to manage database user accounts and permissions.
Optimized MSSQL database performance through query optimization, indexing, and partitioning.
Implemented database partitioning strategies to manage large datasets and improve query performance.
Developed and maintained data models and data flow diagrams to support database design and development efforts.
Implemented Python scripts to perform data analysis and generate reports from SQL databases.
Developed dynamic SQL statements and parameterized queries using T-SQL.
Utilized Sybase Replication Server for data replication and synchronization between databases.
Automated the scheduling and execution of SQL scripts using cron jobs and shell scripting.
Provided technical support and guidance to development teams regarding database design and optimization best practices.
Environment: Oracle 12c, Exadata, SQL Server 2014, Crystal Reports, Oracle Business Intelligence, SharePoint, Actimize, Turbo, SSRS, SSIS.
BANK OF AMERICA, Manhattan, NY –
Senior Programmer June 2015 – February 2016
Worked on the surveillance project for the bank using Actimize software. I am leading a team of 4 developers that are working on creating alerts and business rules to alert the help desk on the transactions that are not in conformity with the regular business transaction and need to scrutinized and alerted for further action.
Performed tuning on Oracle/ Exadata queries on the backend for optimization of applications.
Did Performance tuning, wrote stored procedures for the Actimise (Risk Management) project. Wrote PL SQL Stored procedures for Data Mining.
Environment: Oracle, 11G, Exadata, Crystal Reports, .Net, Informatica, Actimize, SharePoint, Exadata, Hadoop.
AMBAC ASSURANCE, Manhattan, NY -
Senior SQL Database Developer/ Data Analyst September 2014 – April 2015
Developed and maintained custom SQL scripts and tools to automate routine database tasks and enhance efficiency.
Worked on the ABSNet project that tracks the deals that have been assured by the company.
The project involved loading the data from the input files to the data base tables using SSIS package.
Implemented error handling and transaction management in T-SQL scripts.
Designed and maintained database schemas, tables, views, and relationships in Sybase.
Developed Python applications to automate routine database maintenance tasks, such as indexing and backups.
Created shell scripts to parse and analyze database log files for error detection and troubleshooting.
Designed and maintained relational database schemas, tables, views, and indexes in MSSQL.
Developed and maintained stored procedures and triggers to automate data processing and business logic.
Worked on SQL stored procedures to load data from the data files, apply business rules and push the data into the database tables.
Implemented data visualization solutions using JavaScript libraries such as D3.js and Chart.js, leveraging data from SQL databases.
Designed T-SQL scripts to perform data validation and quality checks.
Worked on SSRS reports for management that tracked the performance of the deals/ cusips assured by the company and the tranche value of the deals.
Utilized Python to write and execute complex SQL queries and stored procedures.
Developed shell scripts to perform regular database health checks and generate reports.
Performed data analysis and profiling to support data quality initiatives and identify areas for improvement.
Utilized SQL Server Management Studio (SSMS) and other tools for database development, management, and troubleshooting.
Integrated JavaScript applications with backend SQL databases using ORM (Object-Relational Mapping) tools like Sequelize.
Implemented Sybase Backup Server for automated database backup and recovery processes.
Implemented SQL Server Integration Services (SSIS) packages for ETL processes and data integration.
Created and maintained T-SQL scripts for database maintenance tasks, such as indexing and statistics updates.
Implemented shell scripts for data extraction, transformation, and loading (ETL) processes.
Implemented data validation and integrity checks in Python before inserting data into SQL databases.
Performance tuning on Oracle database 12c for improving the data flow from the flat files to the database and reports.
Environment: SQL Server 2012 and 2008 R2, SSIS, SSRS, SharePoint, VSS, Excel Macros, Actimize, Oracle 12c, Exadata
JP Morgan Chase – Jersey City -
Senior Database Developer/ Reports Developer/ Project Lead September 2013 – July 2014
Worked on the Oracle and SQL Server database to create data mart for reporting.
Utilized shell scripting to automate the process of data archiving and purging.
Created Reports (Business Objects and AdHoc) using datamart for management.
Worked on creating ETL Jobs for pulling data from various sources into Oracle and SQL Server.
Created shell scripts to automate the generation and distribution of database reports.
Performance tuning on Oracle database 12c for improving the data flow from the flat files to the database and reports.
Developed shell scripts for real-time monitoring of database replication and synchronization.
Environment: SQL Server 2012 and 2008 R2, SSRS, SSIS, SSAS, Oracle 12c, Share Point, Excel, Ad Hoc Reporting
Thrikasa Intl LLC – NY January 2013 – August 2013
Developed complex T-SQL queries for Data Analysis and Data Mining purpose.
Worked on Building a Reporting Platform for Business Users using Data Mart.
Environment: SQL Server, Crystal Reports, SSIS Packages and Business Objects.
Senior Database Developer/
UNITED NATIONS - UNICEF, NY –
Senior Database Developer October 2012-December 2012
Worked on the International Aid Transparency Initiative (IATI) that monitors the aid distributed by Unicef across the globe in which the vision system was on Oracle 11g.
Implemented shell scripts to automate the deployment and configuration of database environments.
Also any modifications for the existing stored procedures were done after due processes and procedures and the modifications were rolled out into production in batches.
Automated the cleanup of temporary files and logs using shell scripting to optimize disk space usage.
Data Loads from the SAAP database were loaded into the vision database using data loader and data prepared for end users
Environment: Oracle 11G, Postgres, Exadata, SharePoint, Unix, Crystal Reports 2011 (Version 14), SQL Server 2008, T SQL (Stored procedures, Triggers, Indexes, Synonyms), SSIS, BIDS.
THOMSON REUTERS, Wall Street, NY –
Senior Developer 2011 - 2012
The data from the backend was pulled from different data sources through an Ingestion process and presented through a front end URL that accepts user parameters and outputs a XML data through web services.
Worked on the Ingestion process to write several stored procedures that pulled data from different data sources. Fine-tuned the PL/SQL code for optimum performance.
Environment: SQL Server 2012 and 2008, My SQL, C#, Windows scripting, .Net, T SQL (Stored procedures, Triggers, Indexes, Synonyms), Replication, C, Ingestion between various data sources, Microsoft Silverlight 3., Enterprise Library, Entity Framework 4.1, XML, TSS, T-SQL, XQuery, XSD, LINQ to XML, Fiddler2, Tortoise SVN, JIRA, SSIS, BIDS, SharePoint, BCP.
THE VITAMIN SHOPPE, North Bergen, NJ –
Senior SQL Developer and Business Analyst 2010 - 2011
Built and Modified the FIND (Financial Intelligence Network Data Warehouse) system that takes data from various Data sources and applies business rules and puts data into the central data warehouse and then build reports in various formats for the users (management and field).
Streamlined and tuned the database process for better performance and better data flow using Oracle 10g and third party application for this process.
Created PL/ SQL queries and stored procedures for the users and also created materialized views for better performance.
Environment: Oracle 10 G, Exadata, SQL Server 2005 & 2008, Visual Basic.Net, Microsoft Visual Basic Applications, XML, DHTML, SSIS, SSRS, VB Script, VM Ware, PL/SQL, Oracle Exadata, SQL Server Business Intelligence Development Studio, Oracle Microsoft Access 2007, Business Objects XIR3, Data Integrator – X1R2, Remote Desktop, Vertex.
UNITED WATER, Suez. Oradell, NJ –
Senior Programmer/ Business Analyst 2008 - 2010
Designed and Developed the Core Application of the firm – Key System using Visual Basic for Applications with Oracle 11g and SQL Server 8.0 database.
Maintained and developed the SharePoint application for putting all data into the central repository.
Wrote PL/SQL procedures to read and write data from the data warehouse.
Developed several reports in Business Objects XI R2, Crystal Reports, Oracle Reports for the users and management for effective decision making.
Involved in loading data from Oracle and SQL Server and performing maintenance on the database servers for optimum performance that helped the firm with better customer service to the users.
Environment: Oracle 11G, Visual Basic.Net, ASP.Net, XML, DHTML, VB Script, Java Script, PL/SQL, Oracle Reports 11G, Cognos, Exadata, Microsoft Access 2007, Business Objects, SQL Server 8.0, Business Objects XIR3, Data Integrator – X1R2, Remote Desktop, Oracle Lite Repository.
NOMURA SECURITIES, Wall Street, NY –
Senior Programmer/ Business Analyst 2004 – 2008
Responsible for Technical support to over 40 controllers and brokers over several groups (Fixed Income, Treasury, Asset Management, Mortgages, Management Reporting etc).
Designed and developed packages with functions and stored procedures for the controllers.
Developed DTS packages that read real time data.
Wrote packages that parsed over 300 tables with data from the mainframe files and flat files based on the arrival of the file on the firm’s network domain.
Worked on Informatica to pull data from several source database tables into the custom databases.
Coordinated several mission critical updates like Oracle and SQL Server upgrade, File system upgrades, DLL installations, disaster recovery testing etc.
Worked on making the applications SOX complaint.
Supported the Controllers and Brokers with several ad hoc applications designed and developed in Visual Basic, VBA, PL/SQL, SQL Server reports, DTS packages, Crystal Reports, Business Objects reports etc.
Built project plans for optimum utilization of the allocated budget and resources.
Environment: SQL Server 8.0, Sybase 12.5.1, Oracle 10G, Mainframe, Visual Basic 6.0, Visual Basic.Net, Access 2000, Excel Macros, Dameware, SAAS, Crystal Reports 11, Cognos, Business Objects XI R2, Informatica, UNIX.
STANDARD & POOR’S, Manhattan, NY –
Senior Programmer/ Business Analyst 2002 – 2004
Worked on creating a database for the databus project using Erwin
Normalized the data in the database to the third normalization.
Acted as liaison for several departments to effectively design and implement the firms reporting process on the company’s intranet.
Wrote packages to read data from the data warehouse and populate the data into applications used by different departments.
Used reporting tools like Crystal Reports, Oracle Reports to help the company build a strong reporting process for effective management decisions.
Allocated work among the developers for optimum utilization of the contractor’s time and effective load balance of the work.
Gave inputs to management for decisions on third party software procurement.
Environment: Visual Basic.Net & Visual Basic 6.0, Oracle 9.0, ASP.Net, HTML, DHTML, XML, Crystal Reports 9.0, UNIX, C, Microsoft Transaction Server (MTS), Compuware (QALoad etc), Microsoft Project 2000, ASP, COM, DCOM, Java Script, VB Script, IIS Server
Contact this candidate