Power BI Developer - 6+ Years BI Experience

VENKATA SURESH BABU CHITTIGARI

Business Intelligence Developer

Legal Status: Canadian Citizen

Email: ******.***@*****.*** Phone#: +1-647-***-**** Professional Summary

Results-driven Business Intelligence Developer with 6+ years of experience designing, developing, and maintaining Power BI dashboards, Microsoft SQL Server databases, SSIS, SSRS and data warehouse solutions. Strong expertise in transforming complex data into actionable insights, optimizing queries, and supporting data-driven decision-making. Proven ability to work with cross-functional teams and deliver high-quality reporting solutions on various business domains like Financial and Retail industries. Core Skills

Power BI Dashboard Development

Microsoft SQL Server (T-SQL, Stored Procedures, Views)

Data Modeling & Data Warehousing

ETL Development (SSIS)

Data Visualization & Reporting

Performance Tuning & Query Optimization

DAX Functions & Power Query

SSRS Reporting

Data Analysis & Business Insights

Git, Jira, Visual Studio.

Agile / Scrum Environment

Areas of Expertise

Full Life Cycle Experience in Model, Design, Development of Data warehouse/ETL/BI solutions.

Proven ability to work with business users to gather requirements and translate them into technical designs to facilitate BI reports and analytics.

Expertise in creating database objects such as Tables, Views and Scripting T-SQL Queries, Complex Stored Procedures, User defined functions and Indexes.

Experience in Extracting, Transforming and Loading (ETL) data from varied sources like Excel, Flat file, Oracle to MS SQL Server using SSIS services.

Extensively involved in data cleansing and data enrichment to ensure data integrity using various transformations in SSIS.

Expertise in creating different types of reports in SSRS - parameterized reports, linked reports, sub-reports, drill-through reports, and drilldown reports.

Developed and Scheduled SQL Server Agent jobs to execute SSIS packages and database scripts, implementing job step sequencing, failure handling, logging, and monitoring to support enterprise data warehouse and reporting pipelines.

Expertise in dimensional modelling using components of Kimball Methodology, like building Star and Snowflake Schemas, junk dimensions, degenerate dimensions, role-playing dimensions, conformed dimensions, transaction and snapshot fact tables.

Experience in creating reports and dashboards using Power BI Desktop and publishing the reports to Power BI service.

Worked as an Onsite coordinator - USA and offshore team delivery model. Professional Experience

Business Intelligence Developer

Tech Mahindra Americas Inc., Southfield, MI, USA Oct 2024 – Jan 2026 Project: U.S. Bank Mortgages

Responsibilities:

Worked on BAU requests to provide the data feeds required for Finance and Credit Analytics teams.

Created Power BI dashboards to show the number of Loan Applications, Completions and Targets on Wallboards.

Created SSIS packages to load data into Data warehouse from core systems and external sources like Equifax.

Participated in creation of data quality framework to confirm data accuracy when exporting data.

Worked on Retentions project to develop data mart and showcase the important KPIs using Power BI Dashboards.

Produced data feeds for external parties in the form of data files. Environment: SQL Server, SSRS/SSIS, Power BI

Business Intelligence Developer

Tech Mahindra Ltd., Toronto, ON, Canada April 2019 – Sep 2024 Project: Old Navy (Retail – Apparel Industry)

Responsibilities:

Involved in decommissioning the old Data Warehouse and designing the new Data Warehouse.

Supported the Financial Planning and Analysis (FP&A) and Merchandising teams in generating reports and adding required information to the Data Warehouse.

Implemented the delta data loading process to reduce the data loading time into Data Warehouse from the source systems.

Created Power BI dashboards to showcase Online and Retail sales figures to monitor the business on daily basis.

Created and scheduled SSRS reports to send daily demand and sales information to end users

Created SSIS Packages to load the data from heterogeneous data sources like CIMS (ERP), flat files, and Facebook etc.

Environment: SQL Server, SSRS/SSIS, Power BI

Education

Master of Business Administration (MBA) in Information Technology. Soft Skills

Strong analytical and problem-solving skills

Excellent communication and stakeholder management

Attention to detail

Ability to work independently and in teams

Additional Technical Experience

Unix/Linux/Cloud System Admin/System Testing - 10+ years (as a Project Lead - USA & India) References

Available upon request

Contact this candidate