Over 8+ years of IT experience having multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying and managing applications and services through a global network of Microsoft - managed data centers. Experience in writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs). Experience in developing interactive Web applications using HTML/HTML5, CSS/CSS3, JavaScript, jQuery and Bootstrap for Business Intelligence domains and repositories. Experienced in client requirement analysis, physical, logical design, development, debugging, testing, deployment, support and maintenance of business applications using SQL Server. Expert database engineer, NoSQL and relational data modeling using Microsoft Sql Server. Hands on Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column. Hands on Experience working with Azure Data Lake Analytics to analyze the structured, nonstructured data from various sources.
Fannie Mae
-
Sr Power Bi DeveloperFannie Mae Feb 2022 - PresentPlano, Tx Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation. Import data from different data sources to create Power BI reports and Dashboards. Transform, define, navigate the data from data source and performed merge and append queries using Power Query. Gathering and Analyzing requirements of clients, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation. Import data from different data sources to create Power BI reports and Dashboards. Transform, define, navigate the data from data source and performed merge and append queries using Power Query. Implemented complex query techniques of passing multi-Valued parameters and cascading parameters in MDX. Performed different types of context like Row context, filter context and query context using Power BI Desktop. Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query. Performed Query Folding using Power Query to filter data in the data source server.
-
Power Bi DeveloperAvaility Mar 2020 - Nov 2021Jacksonville, Florida, United States Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process. Developed reports to visually explore data and create an interactive report Excel and Power BI. Using a query editor in Power BI performed certain operations like fetching data from different file. By using Power BI desktop connected to various data sources, working with different visualizations. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. Designed and developed data warehouses, ETL packages, multi - dimensional OLAP cubes, data mining models, performances dashboards and reports. Written complex DAX functions in Power BI and Power Pivot like COUNT (), SUM (), RELATED (), LOOKUP VALUE(), RANX(), CALCULATE() etc. -
Power Bi DeveloperZensar Technologies Aug 2018 - Feb 2020Chicago, Illinois, United States Used advanced calculations using Power BI Desktop Aggregate functions, Date functions, Logical functions, String functions and Table functions. Connected Power BI to Azure SQL Database along with a key configuration before connecting Power BI to Azure. Extensive use of DAX (Data Analysis Expressions) functions for reports and for the tabular models. Designed/Developed table driven ETL process with Perl and shell scripts, which in turn calls OWB mappings, Informatica oracle code to load EDW. Created Power BI reports by using Joins in multiple tables from multiples database using complex SQL queries. Designed a Power BI data model with multiple fact tables and dimensions depending on the business requirements. Working experience with column store indexes, table partitioning in SQL. Involved in implementing Key Performance Indicator (KPI) Objects in SSAS. Create Calculate member in MOLAP cube using MDX in SSAS. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and derived Column. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. -
Power Bi DeveloperAcuvate Software Pvt Ltd Jan 2017 - Jul 2018Hyderabad, Telangana, India Used Power BI to create customized, on-demand reports & ad-hoc reports from Excel and involved in the automation process of the reports from the Corporate Data Models. Worked as Data Analyst to identify the sources and model the data for reporting. Worked in the Agile Methodology using the Microsoft VSTS leveraging the Scrum Process to finish the tasks in the Sprint time frame. Used Power BI’s power query and power pivot functionality to transform and model the data. Designed and developed Power BI graphical solutions as per business objectives. Implemented several DAX functions for various fact calculations for efficient data visualization. Used time intelligence functions for time series analysis. Installed and configured enterprise gateway & personal gateway in Power BI Service to keep dashboards and reports up to date. Implemented Row Level Security. Designed various Landing pages related to different functions of the Product Line pointing to relevant dashboards using the specified templates. Created dashboard for school system financial information which includes revenue and expenditure by district.
-
Msbi DeveloperXoriant Solutions Jun 2015 - Dec 2016Hyderabad, Telangana, India Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data. Created numerous efficient stored procedures to perform data cleansing and loading task when data is loaded into staging area. Created SSIS Packages to integrate data coming from Text files and Excel files. Migrated DTS packages from SQL server as SSIS Package. Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code. Created SSIS packages to validate, extract, transform and load data to data warehouse databases. Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
Frequently Asked Questions about Sruthi G
What company does Sruthi G work for?
Sruthi G works for Fannie Mae
What is Sruthi G's role at the current company?
Sruthi G's current role is Sr Power BI Developer.
Not the Sruthi G you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial