Ajay Kumar Deekonda

Lead BI developer/consultant responsible for the design/develop/maintain the BI and ETL project. ·Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI and Snowflake. ·Proficiency in DAX, Power Query, Power BI Desktop/Service/Report builder. ·Created user roles and groups to the end user and provided row level security(RLS) to them. ·Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters. ·Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries. ·Strong understanding of ITIL process – Service Management, Incident Management, Change Management, etc. ·Worked on Power BI Paginated report using Report builder. Experience on GitHub Copilot. ·Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. ·Developed complex Stored Procedures using SQL , Dynamic SQL queries having good performance. Extensively used Joins, CTEs. ·Supported and maintained enterprise data warehouses, understanding their architecture and the flow of OLTP and OLAP data. ·Pioneered new data visualization techniques, improving client engagement by 40%. ·Constructed SQL queries for complex data extraction, increasing data availability by 25%.

• Managing a team of 15 members to design/develop/maintain the BI and ETL project. • Accountability of all the offshore activities of the team and the project. • Requirement gathering in collaboration with the global team. • Customer facing SME for the key data integrations. • Handling both structure and unstructured formats of the data through multiple ETL/BI tools. • Leveraging complex calculated measures using Data Analysis Expression language (DAX). • Mentored teams and developed multiple data models to fit the right business s need. • Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots, Custom visualizations in Power BI.

• Lead a team of 5 Members to designed/developed/maintained BI Reports. • Explored data in variety of ways across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection and analysis and visualization. • Shaping an approach for governance and deployment of Power BI including advising on licensing, distribution/sharing, training and support. • Strong experience in BI tools (Filters, prompts, queries, drilling, scope of analysis, subquery, ranking,section,break,alerter,sorting,formatting,tables,charts,hyperlinking,groups,calucluate fields, calculation context, relative positioning) etc in BI Dashboards. • Explored data in variety of ways across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection and analysis and visualization. • Understanding of various data aggregation techniques, analysis, blending, Tableau Charts, Graphs, complex calculations, table calculations, geographic mapping, extract optimization, LODs etc. • Experience with reporting, data management and data analytics including standard and ad-hoc reporting using visualization tools like Tableau. • Experience in Business Objects universe design, development and maintenance support using Universe Design tool (UDT) and Information Design Tool (IDT). • Expert in various Business objects tools (BI 4.x) - Web Intelligence, IDT, UDT, BI Launchpad, CMC, Scheduling. • Expertise in designing and building Universes that connect to single or multiple databases. • Experience in developing complex Business Objects reports using the functionalities like Drill, Optional Prompts, Input Controls, etc. • Developing or acquiring test data and initiate tests to determine the accuracy of reporting logic to produce desired results. • Designed Universes using BO 4.2 designer by retrieving data from database, defining the necessary connections and exported them to specific universe domains.

• Designed Universes using BO XI 3.1 designer by retrieving data from database, defining the necessary connections and exported them to specific universe domains. • Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users • Created Classes (Sub classes), Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes. • Used @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes. • Designed and Developed WebI Reports as per the Users Requirements using the features in Business Objects including: Master/Detail, Charts, Cross Tabs, Drill Down, @Functions and Formulae to analyze the data.