Harshavardhan Naini

Highly skilled Oracle PL/SQL ETL BI Developer with 14 years of extensive experience in database development, data integration, and business intelligence. Proficient in Oracle PL/SQL programming, ETL processes, and BI tools, delivering robust and scalable solutions to meet complex business requirements. Adept at data analysis, performance tuning, and data modeling, with a strong focus on optimizing data workflows and enhancing data-driven decision-making processes.

Technical Skills
Database Management: Oracle 10g/11g/12c, SQL, PL/SQL, MySQL
ETL Tools: Oracle Data Integrator (ODI), Informatica, Talend, SSIS
BI Tools: Oracle BI (OBIEE), Tableau, Power BI, Cognos
Programming Languages: SQL, PL/SQL, Python, Shell Scripting
Data Modeling: ERwin, Oracle Designer
Performance Tuning: Query Optimization, Indexing, Partitioning
Operating Systems: Windows, Linux, Unix
Version Control: Git, SVN

Client: Bank of Montreal Toronto, ON                                                                     August 2023 to December

ETL Data Conversion (SME)

Description: This integration project involved migration from Oracle to Netezza and Azure. I Orchestrated more on Netezza conversion which involves writing Netezza scripts as well as scheduling all the initial as well as Delta loads.

Responsibilities:

• Debugging ETL jobs errors, ETL Sanity and production Deployment in TAC-Talend Administrator Console using SVN.
• Led the design and implementation of ETL processes to support data integration from multiple sources into the enterprise data warehouse.
• Developed and optimized complex SQL and PL/SQL scripts to ensure efficient data extraction, transformation, and loading.
• Implemented data validation and quality checks to maintain data integrity and accuracy.
• Collaborated with data architects and business analysts to understand data requirements and deliver solutions that meet business needs.
• Architected and developed scalable ETL solutions for large data warehousing projects.
• Implemented and optimized complex PL/SQL procedures, functions, and triggers to support data transformation and integration.
• Managed job scheduling and workflow automation using Autosys, ensuring timely execution of critical ETL jobs.
• Utilized ServiceNow for incident management, change management, and problem resolution, improving overall system reliability.
• Designed and developed run books to document processes, workflows, and troubleshooting steps for operational efficiency.
• Collaborated with cross-functional teams to deliver end-to-end data solutions for retail banking applications.
• Conducted performance tuning of ETL mappings and SQL queries to enhance system performance on Oracle Exadata platforms.
• Provided mentorship and guidance to junior developers, fostering a collaborative and knowledge-sharing environment.
• Played a key role in data migration projects, ensuring seamless data transfer and minimal downtime.
• Utilized UNIX/Linux scripting to automate daily ETL processes and job scheduling.
• Provided technical leadership and mentorship to junior ETL developers, ensuring adherence to best practices and coding standards.

Environment: Oracle , Visual Studio 2017, XML JIRA, Confluence, VersionOne, Microsoft Office, Windows server 2016, SQL profiler, MS Visio, Unix/Linux, Tidal, ETL Informatica

Kennedy International Software                                                                       October 2016 to July 2023

ETL BI Netezza developer                                                                                                                  

Responsibilities:

• Debugging ETL jobs errors, ETL Sanity and production Deployment in TAC-Talend Administrator Console using SVN.
• Solid skills in designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Coordinated with Business Analysts and customers to develop business requirements and specifications documents using Microsoft word and Power Point.
• Maintained business intelligence models to design, develop and generate both standard and ad-hoc reports using SSMS, SSIS, SSRS and Microsoft Excel.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Designed physical and logical data models and handling data repository for data models.
• Led the design and implementation of a large-scale data warehouse supporting over 1000 users.
• Developed and maintained star and snowflake schemas to optimize data retrieval and reporting.
• Selected appropriate DBMS and designed physical storage structures.
• Managed ETL processes using Informatica PowerCenter, ensuring efficient data extraction, transformation, and loading.
• Developed and implemented ETL processes to extract, transform, and load data from various sources into the data warehouse.
• Created and maintained complex PL/SQL scripts for data transformation and validation.
• Scheduled and monitored ETL jobs using Autosys, ensuring data integrity and consistency.
• Participated in the full software development lifecycle, including requirements gathering, design, testing, and deployment.
• Worked closely with business analysts and stakeholders to understand data requirements and deliver solutions that met business needs.
• Performed data profiling, cleansing, and integration tasks to support data quality initiatives. Developed and maintained complex SQL scripts for data transformation and validation.
• Ensured data integrity and consistency during the ETL process.
• Conducted regular performance tuning of SQL queries and database operations.
• Improved query performance by 30% through indexing, partitioning, and query optimization.
• Monitored system performance and implemented changes to improve data load times and query response times.
• Analyzing the source data to know the quality of data by using Talend Data Quality
• Conduct studies pertaining to development of latest information systems to meet current and projected needs.
• Performing the unit testing of the transactions in ETL Netezza Environment.

Environment: SQL Server 2016, Visual Studio 2017, XML JIRA, Confluence, VersionOne, Autosys Microsoft Office, Windows server 2016, SQL profiler, MSVisio, Unix/Linux, Tidal, ETL Informatica.

 TracfoneWireless                                                                                                       Feb 2016 to September 2016

ETL BI Developer 

Responsibilities:

• Orchestrated on database links and orchestrated on tables, distinct types of views like inline and materialized views in different databases by linking the databases.
• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed PL/SQL packages, procedures, functions, and triggers to support application development and data processing needs.
• Assisted in the design and implementation of database schemas, ensuring optimal performance and scalability.
• Conducted code reviews and performance tuning of SQL queries to optimize application performance.
• Collaborated with application developers and system administrators to resolve database-related issues.
• Created detailed technical documentation and run books for database processes and procedures. Created jobs and alters to execute SSIS packages automatically as well for reporting services.
• Created complex SSIS packages using transformations /tasks and designed packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.
• Performed data warehouse design and modeling according to established standards.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task .
• Implemented Slowly changing dimensions up to Type 3 and developed Late Arriving dimension and fact scenarios during data load from Staging to Data Warehouse
• Developed, maintained, and supported ETL processes using Microsoft SSIS.

Environment:  SQL Server 2017/2016 Enterprise Edition, Windows 2016 Server, C#, T-SQL, Excel, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SharePoint 2013, SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2017, VTFS 2016, MS Visio.

• Master’s in computer applications from Osmania University in 2004, Telangana, India.

My Certification:

• Databases and SQL for Data Science with Python
• Excel Basics for Data Analysis
• Informatica Certified Professional - Data Integration 
• Oracle Certified Professional (OCP) - Oracle Database 12c. 
• Unix Admin (General)
• Introduction to Data Analytics

Professional Affiliations
• Member, Oracle Developer Community
• Member, Data Warehousing Institute (TDWI)