Key Responsibilities
Develop and maintain Excelbased applications using VBA to automate data processing and reporting tasks.
Perform data cleaning transformation and ETL processes to ensure highquality datasets for analysis.
Create and maintain macros for automated reporting and data manipulation in Excel.
Troubleshoot existing VBA subroutines and macros identifying functional and nonfunctional errors and implementing fixes.
Extend and enhance existing VBA subs and macros without breaking existing functionality.
Interact with databases using ADODB OLEDB DAO ODBC Excel Connection for data retrieval and manipulation.
Write and optimize complex queries in PL/SQL and TSQL including stored procedures to enhance data processing efficiency.
Design and implement Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD) for database design and documentation.
Collaborate with crossfunctional teams to understand data requirements and deliver analytical solutions.
Work with datacentric applications and contribute to data warehousing projects.
Analyze and troubleshoot performance issues within database processes and Excel macros implementing optimization techniques such as indexing and query refinement.
Provide insights through data analysis supporting business decisions with actionable recommendations.
Required Qualifications
Bachelor s degree in Computer Science Information Technology Data Science or a related field having 69 years of experience
Proven experience in VBA and Excel programming with a strong understanding of data manipulation.
Proficiency in data processing cleaning and ETL processes.
Strong experience with ADODB connectivity recordsets and database programming.
Indepth knowledge of PL/SQL and TSQL; ability to write optimized stored procedures.
Experience in creating Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD).
Familiarity with datacentric applications and data warehouse concepts.
Excellent problemsolving skills with strong analytical and critical reasoning abilities.
Demonstrated ability to optimize database performance through effective indexing and query design.
Position VBA Developer having strong database and PL/SQL
Key Responsibilities
Develop and maintain Excelbased applications using VBA to automate data processing and reporting tasks.
Perform data cleaning transformation and ETL processes to ensure highquality datasets for analysis.
Create and maintain macros for automated reporting and data manipulation in Excel.
Troubleshoot existing VBA subroutines and macros identifying functional and nonfunctional errors and implementing fixes.
Extend and enhance existing VBA subs and macros without breaking existing functionality.
Interact with databases using ADODB OLEDB DAO ODBC Excel Connection for data retrieval and manipulation.
Write and optimize complex queries in PL/SQL and TSQL including stored procedures to enhance data processing efficiency.
Design and implement Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD) for database design and documentation.
Collaborate with crossfunctional teams to understand data requirements and deliver analytical solutions.
Work with datacentric applications and contribute to data warehousing projects.
Analyze and troubleshoot performance issues within database processes and Excel macros implementing optimization techniques such as indexing and query refinement.
Provide insights through data analysis supporting business decisions with actionable recommendations.
Required Qualifications
Bachelor s degree in Computer Science Information Technology Data Science or a related field having 69 years of experience
Proven experience in VBA and Excel programming with a strong understanding of data manipulation.
Proficiency in data processing cleaning and ETL processes.
Strong experience with ADODB connectivity recordsets and database programming.
Indepth knowledge of PL/SQL and TSQL; ability to write optimized stored procedures.
Experience in creating Data Flow Diagrams (DFD) and EntityRelationship Diagrams (ERD).
Familiarity with datacentric applications and data warehouse concepts.
Excellent problemsolving skills with strong analytical and critical reasoning abilities.
Demonstrated ability to optimize database performance through effective indexing and query design.
data processing,indexing,diagrams,database performance optimization,data flow diagrams (dfd),data manipulation,data,macros,t-sql,vba,entity-relationship diagrams (erd),pl/sql,etl processes,data warehousing,sql,database programming,excel programming,query refinement,data analysis,database