Vasavi N Email and Phone Number
Over 5 years of IT Experience in Database Design, Development, and Business Intelligence of Microsoft SQLServer 2019/2017/2016/2014/2012 in Development, Test and Production Environments.Experience with Power BI, including DAX and data modeling, data mart and Data Warehouse architecture.Expertise in Power Query to acquire data and pull data into Power BI Desktop from sources such as Azure Data Lake, Oracle, SQL Server, Azure SQL, Amazon redshift, SharePoint, OneDrive, Excel etc.Applied data transformation functions, Relationships management, Calculations, Roles, Slicer, Filter and Hierarchies, designed rich visuals in Power BI desktop.Developed numerous financial models, BI reports, defined built countless key metrics, KPIs, scorecards chart rich reports using complex excel functions, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX.Excellent experience in creating DAX queries to build formulas and expressions in Power BI Desktop.Expertise in Data Visualization development, using Power BI desktop to create complex, instinctive, and imaginative Dashboards.Good understanding of BI semantic model and how Microsoft’s Business Intelligence stack (SSAS Cubes, SSRS, Performance Point, Power Pivot) fits into SharePoint.Experience in developing, implementing, documenting, monitoring and maintain the data ETL process in various industries like Financial, HealthCare, etc.Experience in Data Migration from MS SQL Server to Oracle ERP Systems.Experience with Azure Data Factory V2, Data Flows, Snowflake, Azure Data Lake, Azure analysis services. Experience in publishing Power BI Desktop reports to the Power BI service. Deployed Power BI Pro for Business users to view reports on the service and local report server.Experience in publishing and sharing BI objects in Power BI Workspace, designed and maintained Power BI dashboard in Power BI App. Experienced in analyzing user requirements, sourcing data, and building front-end BI applications for end-users.Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities.Expertise in Developing and Tuning T-SQL, Packages, User Defined Functions, Indexed Views, and error handling techniques.Design and implement new ETL processes and adapting current ETL processes to accommodate changes in source systems/new business user requirements SSIS.
Banc First Corporation
View- Website:
- bancfirst.com
- Employees:
- 1486
-
Sql And Power Bi DeveloperBanc First CorporationPrinceton, Nj, Us
-
Sql / Power Bi DeveloperBanc First Corporation Apr 2021 - PresentOklahoma City, Ok Experience in getting data from different data sources like SharePoint, Excel, CSV, APIs etc., and transforming raw data as per requirement. Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS). Added new users and applied roles in the QNXT UI in the Development and UAT Environments. Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals). Mentored business power users to create reports/dashboards using tableau desktop. Configurated and Deployed of all reports across various SDLC environments and deployed the packages to production using XML package configuration. Implemented row level security by restricting the users for the data access. Responsible for the design and development of key indicators (KPI) and the appropriate tracking reports to assist in the management campaigns. Experience on Power BI Gateways. Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database. Designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS). Performed tasks like execute SQL task, data flow task, file system task for ETL process. Imported Data from Oracle DB, SQL Server DB and Azure SQL DB to Power BI to generate reports. Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2017-2019 version. Good Skilled of calculated columns, Measures queries in Power BI desktop to show good data analysis techniques and Generated reports in Power BI Modelling and usage of DAX. .
-
Powerbi DeveloperMedical Mutual Nov 2019 - Mar 2021Ohio, United States▪ Designed different types of reports like drill down, drill through, sub reports, parameterized reports and cascading reportsin SSRS and Power BI.▪ Designed and documented the entire Architecture of Power BI for Poc.▪ Implemented acquisition processes to fetch the data from the disparate sources.▪ Extracted data from SQL Servers, excel sheet, flat files, CSV files.▪ Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.▪ Involved in validating data between Qlik Sense and Cognos reports.▪ Used Power BI and Power Pivot to develop data analysis prototype, and used Power View and Power Map for visualizingreports.▪ Worked on the design and development phases, testing various Power BI and Tableau visualizations for dashboard andad-hoc reporting solutions by connecting from different data sources and databases.▪ Strong experience in creating advanced chart types, visualizations and complex calculations to manipulate the data▪ as per business need through Power BI.▪ Created Azure Data Factory for Data movement from various sources to Azure SQL Data Warehouse.▪ Worked with various scripting languages like Shell and Python, Wrote Python scripts for pushing data from Mongo DBto SQL Database.▪ Engaged in the design of Key Performance Indicators (KPIs) and the creation of star schema and snowflake schema inAnalysis Services (SSAS).▪ Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2012/2014/2016/2017/2019 Analysis Services (SSAS).▪ Integrated custom visuals based on business requirements using Power BI Desktop.▪ Participated in all the agile planning, daily stand-up meetings and Provided updates.▪ Published Power BI Reports in the required originations and Made Power BI Dashboards available in Power BI Service(premium). -
Sql DeveloperIngram Micro Inc Nov 2018 - Nov 2019Irvine, California, United States▪ Created advanced SQL query, defined Function, View and Store Procedure to do data ETL, extracted data and clean datain the SQL server, pulled out all the features related to Project.▪ Connected with SQL server and Azure SQL Database dataset, transform data, designed star schema, defined fact tableand dimension table, created relationship, built visualization reports by Power BI desktop, showed data insight on theKPI.▪ Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.▪▪ Design data model and creating the schema on Azure SQL.▪ Build reports in Power BI Desktop, applied different visualization (Bar Chart, Column Chart, Pie Chart, Donut Chart,Line & Column Chart, Map, Slicer, Card, KPI etc.) in Power BI according to the business requirements.▪ Published reports to Power BI Pro, created and managed workspace, built and shared Dashboards with team member andother department. Shared dashboards in the App.▪ Created SSIS packages to validate, extract, transform and load data to data warehouse databases and data mart databases.▪▪ Developed dashboards and content packs for organizations to access the latest Power BI Reports. Implemented refreshtimes for each tile in the dashboard and established roles to set row-level security when users shared the dashboard.▪ Shared Power BI Reports with the necessary department and ensured availability of Power BI Dashboards for users.▪ Exported model outcomes to Excel to validate results across various scenarios and assessed the model's capability tomanage abnormal data.▪ Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and performed data cleansing.▪ Used Alteryx, Python scripts and SQL queries for Data Ingestion, analysis, and transformation.▪ Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.▪ Created data marts and multi-dimensional models like Star schema and Snowflake schema.
Vasavi N Education Details
-
Master Of Computer Applications - Mca -
Bachelors Of Computer Science
Frequently Asked Questions about Vasavi N
What company does Vasavi N work for?
Vasavi N works for Banc First Corporation
What is Vasavi N's role at the current company?
Vasavi N's current role is SQL and Power BI Developer.
What schools did Vasavi N attend?
Vasavi N attended Andhra University, Acharya Nagarjuna University.
Who are Vasavi N's colleagues?
Vasavi N's colleagues are Doug Hogue, Bradley Burchfield, Mary Scudder, Johnathan Harris, Mustafa Coban, Donna Aton, Pratik Pradhan.
Not the Vasavi N you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
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