Adithya Kortha

Throughout my career, I have put on different hats. I have played key technical, managerial, and self-initiated roles in each project that I was involved in. I have implemented new database structures and reporting platforms that have decreased overhead costs and increased profitability for business users & other stakeholders.

• Around 10 years of work experience in IT with Database applications and Business Intelligence/ETL Design & development, Data Analysis in Production, Development, Testing, and Staging Environments.
• Contributed to the Organization’s/Client’s adaptability, agility, and ability to manage constant change through innovative ideology that made me successful in the project.
• Expertise in defining the business process flow, gathering business requirements, and analyzing user data processing needs to develop/enhance appropriate reporting systems.
• Creating long- and short-term plans, including setting targets for milestones, adhering to deadlines, and allocating resources. And delegating tasks on the project to employees is best positioned to complete them.
• Identifying and managing potential risks and liabilities of multiple projects.
• I actively participated in functional unit testing, integration testing, systems testing, and user acceptance testing.
• Worked on developing technical solutions to business problems, and defining, analyzing, documenting, and managing the requirements at the project level that can help to fulfill business needs.
• Determined the business solutions to the issues of software/hardware systems and analyzed the business process, and initiated the solutions in writing system process specifications to be used.
• Initiated cost-effectively implementing technological solutions by determining the requirements of a project and communicating them clearly to the project/product stakeholders, facilitators, and partners.
• Providing expertise in data storage structures, data mining, and data cleansing, and translating numbers and facts to inform strategic business decisions.
• Responsible for collecting business data, analyzing information, and developing improvement and enhancement solutions based on their findings. And we initiated new approaches for reducing costs, pricing new products, solving issues that cause losses, and increasing employee productivity. 
• Developed a database management program, leading the team in meeting all project deadlines.
• Hired and trained new team members and acquired resources from cross-functional teams based on predicted project needs.
• Experience in designing, developing, deploying, and scheduling ETL solutions using SQL Server SSIS packages involving various control flow items like Loops, Bulk Inserts, Incremental Loads, FTP, and Email Alerts.
• Excellent technical and analytical skills with a clear understanding of the design goals of ER modelling for OLTP and dimension modelling for OLAP.
• Skilled in developing SSAS Cubes, Dimensions, Facts, and data source views, SSAS-Data Mining Models, and Deploying, Processing SSAS objects, and creating named calculations and named queries.
• Develop Power BI reports & effective dashboards after gathering and translating end-user requirements.
• Designed Drill-down, Drill-through, Sub-Report, Linked Report, and Cascaded Parameterized reports using SSRS, and was involved in report deployment, managed report subscriptions for end users, and optimized the performance.
• Hands-on experience in designing custom and interactive reports and Dashboards using Power BI.
• Extensive use of DAX functions in creating Power BI Dashboards, Reports, and Tabular Models.
• Created several Apps (Canvas Apps and Model-Driven Apps) using Power Apps and designed Automated flows using Power Automate to pump the data from various Source Systems into our shared location to ensure the data availability for interactive Dashboards and reports.
• Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User-defined data types and functions (UDFs), Cursors, and Indexes using T-SQL&PL/SQL as per Source & Destination systems
• Expertise in writing Sub-Queries and joins to simplify complex queries involving multiple tables and established relationships between tables using Primary Key and Foreign Key Constraints.
• Expertise in creating, scheduling, monitoring, and maintaining old and new SQL jobs, using SQL Server Job Agent.
• Have constant Interaction with cross-functional teams throughout the project management and delivery lifecycle.
• Good team player and communication skills combined with self-motivation, initiative, and the ability to think outside the Box to leverage the resources and proof of concepts to make the project a success.

I did my master's degree in Engineering Management with Information Systems from Indiana Institute of Technology, Fort Wayne, Indiana, USA, in 2017.

Also, I did my master's degree in Information Technology Management from the University of Wolverhampton, Wolverhampton, West Midlands, UK, in 2012.