Jeevan Kadambala Email & Phone Number

Houston, Texas, Us

• Gathered and analyzed the business requirements and then translate them to technical specifications • Involved in discussion with the business user to understand their requirements and converted them to technical requirements • Validated the data in the reports using nested DAX queries and checked if the data is aligned with the business needs and expectations • Published reports to the server using deployment pipelines and created security to make sure it is visible to only respective stakeholders and financial teams as the reports contain sensitive information. • Created Actions in Worksheets and Dashboards to interact and to compare data against different views. • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data • Performed data validation by writing SQL queries to make sure that data is correct in the reports and aligned with the business needs • Developed complex DBT models to migrate stored procedures from legacy to snowflake

Bangalore, Karnataka, In

• Gathered user requirements, analyzed, and designed software solution based on the requirements • Engaged and lead a team of 10 to implement software solution • Engaged and coordinated with Business Analyst’s for deploying data quality issue resolution • Created automated solutions to load multiple vendors data from Azure Blob storage to snowflake • Designed complex SQL queries to extract data from database • Model creation and designed transformation using DBT • Developed Power BI dashboard, KPI’s, Chart to show trends and performance of overall market, finance related analysis. • Assisted UAT in clarifying technical issues and helped in validating the migration of historical data form legacy

Maryville, Mo, Us

• Provided lessons to students on Tableau, business intelligence concepts • Demonstrated processes to fetch data in Tableau from data source, cleaning data using data interpreter, joining two tables, using Quick filter, data filter, context filter effectively • Shared knowledge on the best practices of visualizations such as use of proper graphs, filters, colors, meaningful data interpretation and analysis • Demonstrated how to use Rapid Miner tool to perform data mining and analysis on a set of data • Developed and taught lectures, designed and administered exams, assisted with creating materials Java, Business Intelligence and Cyber Security courses. • Managed 5 teaching assistants and 60 students per semester • Acted as the mentor for students during lab and help sessions in fixing code bugs, clarifying and resolving their queries.

Bangalore, Karnataka, In

• Modeled and deployed dashboards with required KPIs to track planned, actual audits and to analyze the data integrity of the audited data. Reduced Data Integrity issues by 80% • Worked on Filters such as context Filter, Quick Filter (Normal filter, Date Filter, Cascading filter and Filter sharing • Created parameters in reports and made it more user friendly • Formatted data using legends, marks, colors, size, text, and shape • Experience in various reporting objects such as calculation fields (date calculation, if and else, IIF, case), sets, groups, Level-of-Detail (LOD), sorting and grouping • Derived conceptual designs from business objectives to deliver software and applications according to specifications for usability, performance, and functionality • Created different KPI using calculated key figures and parameters • Strong Dashboard design experience in effective data visualization. Familiarity with best practices and visualization and design • Provided production support to Power BI users and wrote custom SQL to support business requirements • Good SQL reporting skills with the ability to create SQL views and write SQL queries. • Developed complex T-SQL queries and SQL scripts for efficient data load on complex business rules • Monitored strategies, processes, and procedures to ensure data integrity, optimized and reduced Data redundancy • Created database triggers to implement business requirement • Performed end-to-end Data Analysis and ensured the data quality gaps are identified • Extensive experience in reviewing business requirements and analyzing data sources from Excel/MS SQL Server for design, development, testing and production rollover of reporting and analysis projects within Power BI • Created actions in worksheets and dashboards to interact and compare data against different views • Developed Macros to send automated emails to auditors with desired dynamic data

Pune, Maharashtra, In

• Designed and implemented 30+ dashboards for Audit and Assurance application • Enhanced existing reports with new functionalities and more user-friendly design • Analyzed reports in case of data discrepancy, performance issues or unavailability of reports to users. • Experienced in performance tuning of the existing application • Analyzed Audit data to create KPIs, trend analysis, and forecast accuracy measures • Interacted with end-users to collect requirements and acquire the necessary domain knowledge. Trained and provided support to end users on how to use QlikView for analysis • Eliminated synthetic keys using QVD concatenation and qualify based on the nature of synthetic keys • Designing, developing, testing, debugging, and implementing QlikView solutions based on the specified requirement • Experienced in scheduling and distributing reports using loop and reduce • Created ad-hoc dashboards for support team and Audit & Assurance technical team • Involved in QlikView server migration • Provided guidance and assistance to fellow developers to ensure efficient and effective responses to reporting requirements • Worked with decision makers and analyst to identify and document the business requirements behind ad hoc and dashboard reporting needs • Analyzed the database and provided detailed information on their operational and forecast for future years • Provided executives and operational users with powerful analytic capabilities and insights on their • operational and forecast for future years • Facilitated the system wide data integrity and standardization as identified by system leaders • Suggested different ways of representing the data to gain better visualization for the end-clients • Maintained and published standard reports and performed ad-hoc analysis as needed • Brainstormed to oversee data related issues and provide quick workarounds to fix problem • Documented requirements from users for change requests

Master'S Degree

Bachelor'S Degree, Computer Software Engineering