Hari Chandana B
SQL Server/Power BI Developer
- Role
- Sql Power Bi Developer at Transamerica
- Location
- Pontiac, MI, US
- LinkedIn followers
- 500 followers
About Hari Chandana B
Experienced SQL/Power BI Developer with over 5 years of expertise in designing and…
Experience
Sql Power Bi Developer
Aug 2023 — Present · Cedar Rapids, IA, US
Actively participated in interaction with users, technical manager to fully understand the requirements of the system. •Experience in developing Reports, Charts, and Dashboards using Power BI Desktop and managing security based on requirements •Import data from different data sources to create Power BI reports and Dashboards.•Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.•Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.•Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.•Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement using the TOP operator to limit the Select Statement in certain Queries.•Created views to restrict access to data in a table for security.•Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.•Created different chart types and drill-down reports using Power Bi Desktop (SSRS).•Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process. •Work closely with IT and the Business group to understand business reporting requirements and analyse logical model, and develop subject matter expertise in a short time.•Analysed the data using Statistical features in Power BI to develop trend analysis and published the reports on the Power BI Services.•Created measures, calculated columns, and performed time series analysis using DAX in Power BI•Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.•Defines and captures metadata and rules associated with ETL processes
Education
University of Central Missouri
Master's degree
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.