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