AZHAR SHAIKH

Project: Front Office Control (My Supervision)

Client: UBS (Merged with CS)

Tech Stack: Oracle Database,Python,REST API

Role: Application Lead

• Application Lead overseeing project deliveries, ensuring timely execution and high-quality output across decommissioning initiatives.
• Designed and implemented strategies for application decommissioning, streamlining processes for both upstream and downstream systems.
• Collaborated with cross-platform teams, effectively communicating decommissioning plans and workarounds to ensure seamless integration and minimal disruption

Project: Sales Audit Application

Client: Advance Auto Parts

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

Role: Author(Designer/Developer)

• Led the 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 a 100% success rate in maintaining data integrity and consistency.
• Prepared data sets for test case execution, resulting in a 30% reduction in testing time and improved accuracy of test results.

Client: HSBC

Tech Stack: Oracle Database,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.

Project: Quercus

Client: Ellucian

Tech Stack: Oracle Database, 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.

Project: Simple Reconciliation

Client: HSBC

Tech Stack: Oracle Database,Python, Angular

Role: Application Lead

• 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.

Project: Energy Usage Web

Client: Berkshire Hathaway

Tech Stack: Oracle Database (PL/SQL)

Role: Author

• 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.

Tech Stack: Oracle Database,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.