Dilip C

• To find a stimulating and challenging position which builds on my technical skills & knowledge, as well as professional experience and then utilize it to work towards the growth of the organization and at the same time should provide me job satisfaction.
• A customer oriented, multitask professional with excellent analytical and logical skills possesses experience as BI Consultant having around 4.5+ years of experience in BI.
• Have experience in developing Reports and Dashboards in Power BI Desktop and SQL Server.
• Develop the overall application architecture for projects, ensuring that the architecture is appropriate across the business domain(s), evolves to meet changing business and technology environments, and adheres to the enterprise architecture.
• In this my career I used tools like Power BI, Excel,Azure Data Factory and SQL server.
• Conducted meetings with business stakeholders, clients for requirement gatherings and presented various solutions using best practices.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services, MS Excel etc.
• Handled and maintained versioning for documents using GitHub.
• Connecting data sources, importing data and transforming data for Business intelligence.
• Sound knowledge in making DAX queries in Power BI desktop and DAX studio.
• Created many DAX measures, calculated columns to implement date, time, statistical, and mathematical operations to show on the visuals.
• Experience in reporting services, Power BI (Dashboard Reports) and SSRS using MS SQL Server.
• Expertise in Creating Data Visualizations like Matrix table, Area Charts, Line and Stacked column chart and Creating Visuals like Donut chart, Waterfall chart, Gauge chart and Funnel chart.
• Created reports with parameters, bookmarks, synchronize slicers, drill down and drill through options.

Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills. Hardworking employee with customer service, multitasking and time management abilities. Devoted to giving every customer a positive and memorable experience.

• Father's Name: Someswara Reddy C
• Gender: Male
• Nationality: Indian
• Marital Status: Single

PROJECT PwC(BI Developer, Azure  Data Engineer ): 

Tools used: Power BI, SQL Server. Data Lake, Synapse,  Azure Data Factory.

 Collecting and Understanding the Business Requirement Documents and building the relationships between the various data sets in power pivot., Performed data changes suitable for better modelling and visualizations., The results were converted into various visualizations like donut chart, Pie chart and Bar graph, and water fall charts and Card Visualizations., Created different filters like visual level filters and page level filters and report level filters as per reporting needs., Created bookmarks, drilldown, drill through and parameters based on customer requirement., Created measures for DPMO, Overall Previous month Quality percentage, Overall Current month quality percentage and Quality percentage for every auditor, calculations using DAX., Created Data Model in Power Pivot by Establishing the Relationship Between the tables., Hands on Azure Data Factory like building Data Pipelines validating and publishing them. 

PROJECT IKEA:    Specified users to access reports at data set Row Level Security (RLS)., Publishing reports to Power BI server and providing the access to required team lead on Monthly Basis., Specified Scheduled refresh for the report based on customer instructions., Generated alerts when customer required point reached., Created App spaces for easy visualization of the reports as per the client requirement., Participated in requirements meetings and Scrum Calls to understand the Report Requirements., Used Power Query / Query Editor for Data transformation as per the reporting needs. 

PROJECT SIEMENS:  Enhanced the Data Model by creating New Columns and New Measures using DAX., Developed at least two - three visual options for each report for discussion with stakeholders and customers., Created Hierarchies and Drilldown Reports., Created Microsoft Power BI Dashboards in Power BI Service using Reports., Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dataset., Managed access of Reports, Dashboards and Data for individual users using roles., Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.

I hereby declare that the above-mentioned information is true up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.