Sql Server Data Warehouse

Ajay Appam

Database Developer

Phone: +1-726-***-****

Email: **************@*****.***

LinkedIn profile: http://www.linkedin.com/in/ajay-yadav-137b4b349

Professional Summary:

* ***** ** ******ence in Oracle (SQL, PL/SQL), Shell Scripting, Data Warehouse Production Support.

Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.

Extensive experience in developing applications using Oracle database 11g/12c/19c, on Windows/Unix/Linux Environment.

Strong Coding and Designing Experience in Oracle PL/SQL & SQL.

Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace, TKPROF utilities and PL SQL Profiler.

Design of data models and objects including Tables, Views, and User defined Functions, Triggers and Stored Procedures for applications.

Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Experience creating mappings to extract, transform and load data from Oracle and SQL Server Sources into Data warehouses and Data Marts.

Experience in Dynamic SQL, Records, and Exceptional handling.

Expert in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic.

Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes.

Experience in migration and conversion from Flat Files/MS Access to Oracle using Oracle SQL*Loader and PL/SQL interfaces.

Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills

Strong knowledge of OLAP Process and Data Warehouse System.

Received many appreciations from Client for delivering bug free product within the estimated schedule.

Strong communication, interpersonal, analytical skills and strong ability to be a good team player while working in small/large teams

Excellent written and communication skills, able to communicate effectively within the team and with all stake holders, including Testing Team, UAT Team, business users, and Performance teams.

Educational Qualifications:

Bachelor’s in JNTUH - 2015

Master’s in Webster University - 2024

Technical Skills:

Programming Language: PL/SQL, SQL, C, C++, Core Java

Web Technologies: HTML, HTML5, XML

Scripting Language: Shell Script, XML, CSS, Java Script,

Database: Oracle 10g/11g/12c, SQL Server 2005/2008/2012/2016, Ms Access 2000.

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2007, Windows 8, UNIX, Linux

Versioning Tool: Tortoise SVN. Serena

Tools/Utilities/IDE: Visual Studio 2008/2010, SSRS, SSIS, Oracle Warehouse Builder, SQL Developer, SQL Navigator, SQL*Plus, SQL*Loader, 9i. Toad Data Modeler.

Cloud Technologies: Amazon Web Services (AWS), Google Cloud Storage (GCP), Microsoft Azure

Professional Experience:

IQVIA, Durham, NC Dec 2024 - Present

PLSQL Developer

Responsabilités :

Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.

Working on Oracle 11 to PostgreSQL Migration, Prepare DMA report in PostgreSQL.

Backup support for Azure SQL Server 2017 Linux and Postgres databases.

Created Ad-hoc reports with complex t-SQL queries based on business requirement.

Load data from a text file or csv files or from flat files in a PostgreSQL database.

Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups.

Perform failover when necessary, and then rebuild the master as a slave in PostgreSQL streaming replication setup.

Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.

Generating PowerShell scripting to avoid errors and also used for SSRS.

Redesign Oracle application architecture to prepare for migration to PostgreSQL environment.

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.

Executed Test Cases Manually to verify the system functionality as per user requirement

Participated in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Involved in the Preparing Automation status report and updating with client in scrum meeting.

Troubleshoot and resolve issues reported by business users.

Utilized SOAP UI to create manual test cases to validate systems test cases before System integrated testing.

Environment: PostgreSQL 10.x/9.x/8.x, SQL Server 2017/2016/2014/2012, Oracle 11g, Aurora, Teradata, PL/SQL, SharePoint 2013/2010, SQL Server Data Tools, T-SQL, Agile, Tabular, Excel 2013, Power view, Cloud, TFS, Power pivot, Performance Point, MDX, Tableau, Report Builder 3.0, Crystal Report 8.0, DTS, HTML, JSON, Erwin 4.0, XML, Windows Server 2008

S. BCBS, Richardson, TX

Oracle PL SQL Developer Dec 2023 – Oct 2024

Responsabilités:

Configured and built EC2 CentOS database servers for hosting PostgreSQL databases and monitoring software.

Responsible for data validation testing using SQL and executing testing on data Warehousing projects.

Maintain SQL Server instances to ensure software are properly installed, security patches are applied and upgrades are done properly.

Install and manage RAC with ASM infrastructure on Linux.

Extract, transform and loading data from multiple sources into Elastic Search and Redshift

Extensively worked in the performance tuning of programs, ETL procedures and processes.

Worked in agile environment on testing iteratively against newly developed code.

Used Cassandra for database and Redis for cache, for storing and fetching the data.

Worked on the necessary SQL (DDL) scripts to create the relational database, Data Warehouse/ Data Mart with Star Schema and Snow Flake Schema in MS SQL Server 2008R2. Plus, the SQL (insert statements) scripts to populate the Dimensions using the help of VBA to automate the process.

Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQL db package

Worked on multiple joins like Cross join, Left Outer Join, Right Outer Join, Inner Join between two or more tables.

Developed Chef cookbooks to apply standardized DISA STIG configurations and install infrastructure services.

Used Redis Cache for high performance, which creates space for new data by removing old data.

Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.

Tested and validated the Report Net reports by running similar SQL queries against the source system(s).

Redesign Oracle application architecture to prepare for migration to PostgreSQL environment.

Redshift Table Design (Dim /FACT) and define the sort and distributed key for data distribution.

Implemented T-SQL/SQL Scripts and Wrote SQL queries to validate data.

Install and configure new SQL Servers, involve in migration to newer versions of SQL Server 2012/2016/2017 and support on daily basis.

Worked on converting legacy data into latest supportable format for SQL Server

Create and maintain shell scripts to backup and restore Oracle and PostgreSQL databases.

Patches installation and configuration in Oracle Database 11g,10g and 9i.

Private VPN using Ubuntu, Python, Django, Postgres, Redis, Bootstrap, jQuery, Mongo, Fabric, Git, Tenjin and Selenium.

Backup and restore the database (including clone)

Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team.

Manage application schemas and metadata, perform application PL/SQL code review.

Perform Manual and Back-end testing using SQL in Oracle relational database.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Worked with TFS Sidekicks to clear the user mappings and undo pending changes of other users etc.

Setup multi - tenant databases in Oracle 12c in Development and QA environments.

Participated in all the agile planning, daily standup meetings and give the updates.

Environment: PostgreSQL 12.x/11x./10.x/9.x/8.x, SQL Server 2017/2016/2014/2012, Oracle Enterprise Edition Release 10g, Aurora, Oracle 10g/11g, AWS, TFS, Agile

S.P Soft Pvt. Ltd, Hyderabad. Jun 2019 – Dec 2022

Sr. SQL Developer

Responsibilites:

Simplified the company’s HR processes and reduced amount of time that it takes to do many routine tasks by developing of back-end logic for HR System using Oracle SQL, PL/SQL.

Designed, implemented Call-Support System (hardware and software accidents tracking system) using PHP, MySQL, JavaScript

Developed Shell Scripts for Data loading and DDL Scripts.

Worked on Data conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.

Performance tuning of Oracle Databases and User applications.

Used SQL*Loader as a tool to load data into the staging tables.

Provided user training and production support

Improved the performance of the application by rewriting the SQL queries.

Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.

Environment: Windows, Solaris, Oracle 10g, SQL, PL/SQL, PHP, MySQL, JavaScript, HTML, Toad, SQL*Plus.

HDFC Bank, India Jun 2015 – May 2019

Database Developer

Responsibilities:

Coordinating with client for requirement gathering, clarification and providing solutions for several problems

Handled client's enquiries regarding the project requirements.

Assured consultative analysis and functional requirements are completed and document deliveries are met.

Involved in query optimization and performance tuning.

Involved in analysis, coding and code review of the team members.

Created Perl Scripts and Autosys job to automate the monthly report generation process.

Involved in query optimization and performance tuning.

Involved in Development and Created PL/SQL stored procedures, functions.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Environment: MS SQL Server 2012/2008/2005/2000, PL/SQL, Visual Studio, SQL Server, Data Tools (Business Intelligence Development Studio (BIDS)), T-SQL, MDX, MS Excel, Team Foundation Server (TFS), Pentaho Integrated Solutions,

Contact this candidate