Bharadwaj Mateti
- Role
- Sql Bi Developer at Massmutual Ascend
- Location
- Cincinnati, OH, US
- LinkedIn followers
- 500 followers
About Bharadwaj Mateti
I am a SQL BI Developer, my expertise is mostly with the Microsoft BI Stack that…
Experience
Sql Bi Developer
Oct 2018 — Present
Expand the company’s use of data as a strategic enabler of corporate goals and objectives. • Facilitated information-gathering sessions and provided data analysis and data mapping. • Worked with various customers, prospects, and stakeholders, understands, and translates business use cases and/or requirements into data models, data integration routines, and analytics reports. • Involved in identifying data sources, developed, and maintained data architecture/data model using ER Studio, designed data catalogs, and data decomposition diagrams provided data flow diagrams, and documented the process. • Facilitated the development of data integration efforts with the development team in addition to hands-on design and development of large complex SSIS ETL jobs. • Designed, implemented, and maintained database objects (tables, views, indexes, etc.) and database security in EDW and various DataMart’s. • Migrated data from legacy Data Warehouse system using SQL, Visual Studios 2016, and other technologies. • Scheduled and maintained ETL jobs using UC4. • Created user test cases for SSIS packages which loads data into EDW using ICEDQ tool. • Create UNIX batch scripts for scheduling, deployment of database objects, and ETL Packages while promoting to other environments. • Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision-makers for strategic planning. • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. • Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources. • Check-In SSIS solutions to TFS-GIT and promoted code using Octopus for the deployments.
Education
Southern Arkansas University
Master's degree, Computer Science
Southern Arkansas University
Master's degree, Computer Science
2015 — 2016
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.