Sai Teja

• Having around 6+ years of experience in Information Technology with extensive experience in SQL Server, Business Intelligence tools SSIS,SSAS ,SSRS and Power BI.
• Worked on the Power BI(Power Pivot, Power Query) reports & dashboards with SQL Server. Used to create diff visualizations like table,matrix,bar,card, gauge, Table, Matrix,slicers etc and custom visualizations.
• Extensive experience in using SQL (DML, DDL) in SQL Server 2008/2005 platforms. Experienced in creating Tables, Stored Procedures, Views, Indexes, Triggers, and User Defined Functions in observing Business Rules.
• Good in writing DAX in MS Power BI Desktop. Experience in creating calculated Measures and Columns with DAX in MS Power BI Desktop. Experience in using custom visuals and Groups and Hierarchy creation. Experience in Publishing reports to app.powerbi.com and setting up the necessary connection.
• Designed and developed the Power BI Reports & Dashboards using SQL Server, SSAS Tabular and Excel Sources. Created rich visualized Power BI reports (Used Pie charts, Line charts and Tree Maps, Bar & Column charts, Tabular, Matrix, Cards, Slicers, Gauge, KPI's and Custom Visualizations.
• Comfortable in working with Filters/Calculated Columns/Measures/Relationships and Transformations of Edit Query section. Published Power BI pbix files from Power bi desktop to Power bi service. Shared the reports by creating a Content Packing app.powerbi.com. Worked on On-Premises Gateway to refresh the data sources. Created new calculated columns and calculated measures using DAX Expressions. Getting the data from On-Premises data source bases to perform visualizations using Power Bi Desktop. Created rich visualized power bi reports and dashboards using KPI.
• Created charts like Pies, Lines, Tree Map, Area, Scatter, Table Heat Maps, Combo, Tabular, Matrix, Funnel, Single Card, Multi row card, Gauge and Slicer etc. Imported Custom Visuals from Microsoft Power Bi gallery as per client request. Comfortable in working with Filters/Calculated Columns/Measures/Relationships and Transformations of Edit Query section. Implemented Row Level Security (RLS) as part of security.
• Published the reports into Power BI Service & shared the dashboards to the users. Worked on On-Premises Gateway to refresh the data sources in Power Bi Service. Created Content packs that package up a dashboard, report and dataset. Performed required calculations using DAX Expressions as per business needs (Table, String, Date and Logical functions).
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions. Very good Experience in T-SQL Programming skills and Experience in developing complex store procedures, efficient triggers, required functions, creating indexes.
• Experience in Data warehouse design and end to end implementation. Experience in power BI report design and implementation. Experience in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation. Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages. Experience in SSRS report deployment and report server configuration.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports, Link reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. Good understanding of the Data Warehousing Concepts. Knowledge on Star Schema and Snowflake Schema.
• Experienced in SQL-based data transformations with working knowledge of dbt for building modular, scalable data models. Familiar with ELT concepts, incremental loading, and data validation in modern data pipelines.

Title: PowerBi Developer