Job Description –
• Develop data automation in Excel and SQL using functions, macros and VBA as needed
• Create new Cost validation programs, SQL databases and maintain existing databases
• Create advanced User Interfaces (UI) in Excel
• Develop, maintain, and support existing MS Excel VBA applications, and analyze and convert business requirements as needed.
• Develop SQL queries and stored procedures to fetch data from different tables in remote databases in remote servers
• Create and optimize SQL queries as needed
• Analyze complex data to develop automated reporting with VBA, Excel and PowerBI
• Develop and organize insightful reports, dashboards with custom visuals, slicers, measures, calculated columns using Data Analysis?DAX) queries
• Develop cost data reports that provide insights on different level of visualizations per user requirements
• Develop SQL queries and stored procedures to fetch data from different tables in remote databases in remote servers
• Perform object-oriented analysis and design, and diligent testing to ensure optimal performance of all assigned systems and system modules.
• Developing test plans and software documentation to support code modifications and additions