Overview
Summary
Work History
Education
Profile Summary
Skills
Timeline
Principal Consultant

AZHAR SHAIKH

Tekgeminus
13
years of professional experience

Summary

Technical Lead | Data Solutions Architect with 13+ years of experience in designing, developing, and managing high-performance data-driven solutions. Specialize in Oracle Databases (PL/SQL, Oracle APEX), delivering scalable, and high-performance data solutions.

Work History

Principal Consultant

2 Years 7 Months
Tekgeminus | 04.2024 - Current

Tech Stack: Oracle Database(PL/SQL),REST API

Role:

  • Oracle Database Design & Architecture: Designed, developed, and optimized complex Oracle database structures, including data modelling, ER diagram design and redesign, schema architecture, and relational database optimization to support evolving business requirements.
  • Database Performance & Optimization: Spearheaded Oracle database performance tuning through SQL and PL/SQL optimization, query analysis, indexing strategies, execution plan analysis, and database-level enhancements to improve application performance, scalability, and efficiency.
  • Database Administration & Infrastructure Management: Managed database-level activities including tablespace management, storage allocation, schema optimization, and database object maintenance, ensuring efficient resource utilization, data integrity, and overall database stability.

Principal Data Engineer

6 Months
KPI Partners | 08.2023 - 02.2024

Project: Sales Audit Application

Client: Advance Auto Parts

Tech Stack: Oracle Database(PL/SQL),Apex,RESTFul Web Services

Role: Author(Designer/Developer)

  • Led design and implementation of application logic, ensuring alignment with project goals and delivering robust, efficient solutions.
  • Collaborated with stakeholders to define requirements, providing accurate project estimates and scope definitions.
  • Architected backend systems, including data modeling, DDL execution, and PL/SQL package development for optimized data management and system performance.
  • Developed interactive user interfaces using Oracle APEX components like forms, reports, charts, and dashboards to enhance user experience.
  • Created and executed test cases, ensuring functionality, performance, and reliability in collaboration with testing teams.
  • Facilitated data migration between environments, achieving 100% success rate in maintaining data integrity and consistency.
  • Prepared data sets for test case execution, resulting in 30% reduction in testing time and improved accuracy of test results.

Technical Analyst

9 Months
COFORGE | 08.2022 - 05.2023

Client: HSBC

Tech Stack: Oracle Database(PL/SQL),SQL Loader, Control-M Automation, Unix Shell

Role: Subject Matter Expert

  • Analyzed existing systems to create knowledge base using flowcharts and PlantUML, resulting in 25% improvement in process efficiency.
  • Automated patching tasks using Control-M jobs, ensuring 100% on-time execution with minimal manual intervention.
  • Utilized SQL Loader for data loading, streamlining patching process and reducing data entry errors by 40%.
  • Implemented data modeling techniques for storing payload information, optimizing data storage and retrieval for patching operations.
  • Employed dynamic SQL to enhance flexibility in generating and executing SQL statements during patching process.

Senior Software Developer

8 Months
Joules2Watts | 12.2021 - 08.2022

Project: Quercus

Client: Ellucian

Tech Stack: Oracle Database (PL/SQL), Oracle Apex

Role: Senior Developer

  • Executed advanced UI enhancements in Oracle APEX, improving user experience through responsive design principles and streamlined navigation.
  • Delivered new features in Quercus based on customer requirements, utilizing agile methodologies for timely support and issue resolution, ensuring 95% customer satisfaction.
  • Resolved build issues in Quercus, applying CI/CD principles to streamline development and deployment processes, significantly reducing deployment time.
  • Utilized version control applications such as Source Tree and Bitbucket; performed code analysis using Sonar Qube for comprehensive quality assurance, identifying and mitigating code vulnerabilities.
  • Worked on regulatory requirements, collecting and formatting student data into XML and JSON files according to government standards, ensuring compliance and accuracy in data submission to educational authorities.
  • Implemented robust data capture processes, transforming student data into XML and JSON formats for seamless API submission, enhancing interoperability and facilitating real-time data exchange with government bodies.

Senior Associate

2 Years
Synechron Technologies | 12.2019 - 12.2021

Project: Simple Reconciliation

Client: HSBC

Tech Stack: Oracle Database(PL/SQL),Python, Angular

Role: Senior Developer

  • Developed Single Page Application (SPA) in Angular for peers to efficiently extract end-user data, enhancing data accessibility and usability.
  • Revamped nomenclature of existing Control-M jobs to meaningful names, improving clarity and maintainability, created framework for future job development.
  • Automated over 15 reports triggered to downstream reducing manual intervention.
  • Maintained and enhanced reconciliation engine, optimizing performance and accuracy in data processing.

Member of Technical Staff

2 Years 8 Months
Tekgeminus | 04.2017 - 12.2019

Project: Energy Usage Web

Client: Berkshire Hathaway

Tech Stack: Oracle Database (PL/SQL)

Role: Programmer (Author/Designer)

  • Collaborated with Chief Technical Architect on data modeling and planning, designing optimized data structures and schema definitions for critical business processes.
  • Created tables and defined relationships using advanced DDL techniques, implementing constraints, indexes, and partitioning for improved performance and data integrity.
  • Developed complex ETL processes to load data from warehouses into new tables, utilizing Oracle features like external tables, SQL*Loader, and parallel execution for efficient data migration.
  • Engineered backend systems with PL/SQL, including stored procedures, packages, and triggers for intricate customer billing projection logic.
    Optimized query performance using tuning techniques with Oracle tools such as Explain Plan, SQL Trace, and DBMS_PROFILER, ensuring efficiency for large data sets.
  • Implemented partitioning and materialized views to enhance query performance and data retrieval in high-volume environments.
  • Integrated systems with external APIs using Oracle REST Data Services (ORDS) for real-time data exchange in billing projections and customer insights.

Jr Programmer

3 Years 7 Months
Bajaj Allianz General Insurance | 09.2013 - 04.2017

Tech Stack: Oracle Database(PL/SQL),JSP,Ajax,XML

Role: Developer

  • Developed JSP pages using HTML, CSS, JavaScript, jQuery, XML, and Ajax to create dynamic, interactive web interfaces in the insurance domain.
  • Owned development of the accounting module, writing Oracle stored procedures for business logic implementation and JavaScript/jQuery for client-side validation.
  • Utilized Rational ClearCase for version control, managing code versions and changes throughout the project lifecycle.
  • Gained expertise in SDLC under the waterfall model, handling the full development cycle from application development to release, ensuring timely and successful delivery.

Education

Bachelor of Science in Computer Science

Pune University | 10-2013

Profile Summary

  • Led the end-to-end database development lifecycle, utilizing Agile and Waterfall SDLC methodologies to manage requirements, design, implementation, and maintenance, ensuring timely and efficient project delivery.
  • Architected robust Oracle database solutions, including the design and optimization of database schemas, tables, and relationships, ensuring scalability, high availability, and fault tolerance for enterprise-level applications.
  • Developed high-performance PL/SQL packages, stored procedures, triggers, and functions to meet business requirements, streamline operations, and enhance the overall efficiency of database systems.
  • Conducted comprehensive performance tuning, including indexing, partitioning, query optimization, and parallel processing, resulting in substantial improvements in query response times and overall system performance.
  • Led the design and implementation of complex ETL processes for large-scale data migrations, ensuring seamless data extraction, transformation, and loading while maintaining data integrity and minimizing downtime.
  • Utilized Oracle APEX for rapid application development, building intuitive user interfaces and integrating advanced front-end frameworks with robust backend systems.
  • Collaborated with cross-functional teams to automate and schedule database tasks using Control-M and custom scripts, ensuring seamless workflow management and reducing manual intervention for operational efficiency.
  • Proficient in version control and collaboration tools like Git, SourceTree, and SVN, managing codebase and facilitating smooth integration and deployment across development teams.

Skills

  • Tech Stack: Oracle PL/SQL, Oracle APEX, HTML, CSS, JavaScript, jQuery, SQL Loader, ETL, Data Migrations, Database Design & Modeling
  • Tools: Toad for Oracle, SQL Developer,Informatica PowerCenter, Control-M Automation, Git, SourceTree, SVN, SonarQube
  • Platforms: Oracle Database 12c/19c, Oracle REST Data Services (ORDS), Linux/Unix, Windows, Cloud Platforms (AWS, Oracle Cloud)
  • Soft Skills: Team Leadership & Mentorship, Stakeholder & Client Communication, Problem Solving & Critical Thinking, Collaboration in Agile/Waterfall Teams, Project Management & Delivery

Timeline

Principal Consultant
Tekgeminus
04.2024 - Current
Principal Data Engineer
KPI Partners
08.2023 - 02.2024
Technical Analyst
COFORGE
08.2022 - 05.2023
Senior Software Developer
Joules2Watts
12.2021 - 08.2022
Senior Associate
Synechron Technologies
12.2019 - 12.2021
Member of Technical Staff
Tekgeminus
04.2017 - 12.2019
Jr Programmer
Bajaj Allianz General Insurance
09.2013 - 04.2017
Pune University
Bachelor of Science in Computer Science
AZHAR SHAIKH