Varun Kumar Nakirikanti
Business Intelligence Developer
Beaverton,OR
Summary
Seasoned Business Intelligence Developer with six years of experience delivering analytical solutions contributing to team success. Demonstrated expertise in utilizing advanced analytics tools to translate intricate data into actionable insights, driving strategic decision-making and fostering business expansion. Proficient in data visualization, modeling, and performance enhancement, adept at leading cross-functional teams to deliver impactful projects within budget and timeline constraints. Firmly believe in the transformative power of analytics to unlock growth opportunities for businesses.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Sr.BI Developer
Bank of America
04.2023 - Current
- Analyzed business requirements within the BI context and designed data models to transform raw data into actionable insights.
- Translated intricate business requirements into technical specifications, ensuring alignment with organizational objectives.
- Led the development of data analysis frameworks, resulting in actionable insights and data-driven decision-making.
- Provided strategic guidance on reporting and automation solutions to business stakeholders.
- Managed critical databases, overseeing daily operations, performance tuning, and disaster recovery planning.
- Executed database upgrades with a 30% reduction in downtime.
- Utilized DAX to implement dynamic calculations for sales trends and performance analysis.
- Developed measures and calculated columns to analyze essential KPIs for business decision-making, including customer churn rate and lifetime value.
- Successfully migrated on-premises databases to Azure, optimizing resource utilization and reducing infrastructure costs by 30%.
- Managed Windows and Linux servers, ensuring 99.9% uptime for critical databases and applications.
- Experienced in integrating Databricks with various components of the data ecosystem, such as data lakes and warehouses.
- Implemented data solutions in AWS, leveraging services like S3 and Redshift for scalable and cost-effective storage and analytics.
Power BI Developer
Intel Corporation
10.2022 - 04.2023
- Developed Enterprise-level Business Intelligence solutions using SSRS, utilizing advanced SQL techniques for data transformation, manipulation, and analysis.
- Generated reports and dashboards in Power BI to monitor key performance indicators (KPIs) such as open rate, click rate, and conversion, leveraging insights to enhance campaign performance and customer segmentation.
- Implemented various features in Power BI reports, including bookmarks, conditional formatting, and filtering, to meet user requirements. Published reports to Power BI cloud (Pro) and shared them with end users.
- Managed On-Premises Gateway for data source refreshing and scheduled incremental refreshes on extracts.
- Extracted data from multiple sources and performed data munging using SQL, integrating it into a cohesive data stream (ETL). Prepared monthly Power BI reports to deliver data-driven insights for business growth.
- Proficient in Infrastructure and Operations, with experience in cloud network infrastructure on Azure.
- Utilized Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems, including nested JSON formatted data, into Snowflake tables.
Business Intelligence Developer
Tech Mahindra
11.2019 - 07.2021
- Collaborated with business analysts to gather and document functional and technical requirements.
- Analyzed business requirements in BI context and designed data models to convert raw data into actionable insights.
- Applied advanced level calculations to datasets to extract valuable insights.
- Created calculated/customized columns and tables using Query Editor.
- Established relationships between data and developed tabular and multidimensional data models.
- Proficient in DAX expressions including filters, aggregates, functions, and time intelligence.
- Developed visual reports, dashboards, and KPI scorecards using Power BI Desktop.
- Designed and implemented four executive dashboards in Power BI to analyze KPIs such as Accounts Receivable, Overdue Receivable, and disputes across multiple regions and Lines of Business (LOBs) to enhance collections team performance.
- Contributed to designing and constructing data pipelines and data streams using Azure.
- Optimized database performance and conducted monitoring and tuning on database servers to meet specific requirements.
Configuration Specialist
Tech Mahindra
03.2018 - 11.2019
- Completed a 3-week training bootcamp conducted by the Unqork team and collaborated on a Proof of Value (POV) project for Ameritas.
- Demonstrated proficiency in configuring flows and creating visualizations using Unqork, showcasing capabilities in flow design, graph creation, PDF generation, dashboard views, and data visualization.
- Configured flows for the developed POV project, ensuring alignment with project requirements.
- Conducted testing of Unqork applications to ensure functionality and quality.
- Assisted project manager in estimating durations for tasks, deliverables, and activities, contributing to project planning and scheduling.
- Participated in day-to-day activities of the Shared Services development team, supporting team goals and objectives.
- Supported data gathering and analysis efforts to facilitate risk mitigation and issue resolution.
- Designed and implemented complex enterprise integrations with internal systems to facilitate data access and processing.
- Created new process models to enhance functionality and efficiency.
- Conducted unit testing of application components to ensure reliability and performance.
Jr Software Developer
Tech Mahindra
11.2016 - 03.2018
- Developed custom calculated measures using DAX in Power BI to meet specific business requirements.
- Played a key role in designing dashboards to visualize customer-related information effectively.
- Created visualizations in Power BI according to business users' requests.
- Managed Power BI Admin portals, including user creation and access management.
- Established Power BI Workspaces & Apps in the Power BI Service for efficient content organization.
- Utilized DAX expressions such as Total YTD and Total MTD to calculate sales figures accurately.
- Scheduled data refreshes for dashboards and reports to maintain live data updates.
- Built and maintained multiple Power BI dashboards, reports, and content packs.
- Designed and structured data sets in Power BI Desktop based on customer requirements and dashboard specifications.
- Implemented complex DAX expressions including user relationships, summarization, and calculation.
- Developed Power BI Dashboards using both Tabular and Multi-Dimensional Models.
- Provided visual and graphic analysis based on data content for improved insights.
- Contributed to solution creation and test plan preparation by applying knowledge of dimensional cube data modeling techniques, including DAX scripting.
Education
Master of Science - Business Analytics
Pompea College of Business, University of New Haven
Bachelor of Technology - Mechanical Engineering
Vignan's University
Skills
- SQL
- Data Modeling
- ETL(Extract,Transform,Load)
- Power BI
- Data Analysis
- Statistical Analysis
- DAX(Data Analysis Expression)
- Data Warehousing
- ADF(Azure Data Factory)
- Communication Skills
Certification
Microsoft Certified Power Bi Data Analyst (PL-300)
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Sr.BI Developer
Bank of America
04.2023 - Current
Power BI Developer
Intel Corporation
10.2022 - 04.2023
Business Intelligence Developer
Tech Mahindra
11.2019 - 07.2021
Configuration Specialist
Tech Mahindra
03.2018 - 11.2019
Jr Software Developer
Tech Mahindra
11.2016 - 03.2018
Master of Science - Business Analytics
Pompea College of Business, University of New Haven
Bachelor of Technology - Mechanical Engineering
Vignan's University