Home

Niharika - Microsoft MSBI/BI Developer/Azure Cloud Specialist

[email protected]

Location: Herndon, Virginia, USA

Relocation:

Visa: H4EAD

Experienced IT professional with around 8 years of experience in database designing, architecture, and maintenance of SQL server, Oracle, and other large-scale databases with strong interpersonal skills, and communication skills. Experience in SDLC methodologies & Agile/Waterfall project methodologies in Analysis, Design, Development, Testing, and Implementation of client-server-based applications. Experience in data modeling, data management, data presentation, advanced data analysis, data visualization, data optimization, predictive analysis, and quantitative analysis. Experience in MS SQL 2019/2017/2016/2014/2012/2008 R2 with emphasis on design development, automation, tuning, optimization, performance and security. Good experience creating stored procedures / integrating cloud sources using Storage Integration with AWS storage and automating migrations from On-Premise to Snowflake using tools like Talend and managing Metadata around Snowflake. Experience in analyzing business user requirements analyzed data and designed business intelligence solutions using a suite of SSIS, SSAS, SSRS, Power Bi, Tableau and other BI tools. Expertise in writing complex SQL queries, stored procedures, views, Conditions and clauses and used joins and sub queries to simplify complex queries involving multiple tables using primary key and foreign key constraints and Experience using performance monitor, SQL profiler and database tuning advisor to solve deadlocks and long running queries. Proficient in SSIS using various Control flow task, Data flow tasks, dynamic configuration of packages, Custom Script using Scripting tasks, deploying packages and scheduling package for automation in SQL Agent in SQL Server management Studio. Proficient in extracting data from various heterogenous sources (Flat file, CSV, Excel), SQL Server, Oracle, DB2, Teradata expertise in creating, fine tuning ETL packages using DTS, SSIS. Expertise in designing, building and maintaining cubes using SSAS, developed facts and dimensions tables with star schema and snowflake schema. Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/Power BI. Expertise in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and processing SSAS objects. Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model. Interpreting and working with data models, data flows and data dictionaries, logical & physical Data modeling, Normalization and De-Normalization techniques for both OLTP and OLAP systems. Highly skilled in developing OLAP cubes using SSAS calculating measures, measure groups and dimension members in SQL Server Analysis Services using multi- dimensional expression (MDX), mathematical formulae, and user-defined functions. Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting, creating aggregates, hierarchies, charts, filters, quick filters, table calculations with Power BI/Tableau/Qlik/business Objects. Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS. Experience with Power BI Desktop, Power BI Mobile and the Power BI Service. Experience in calculating measures and dimension members using DAX, mathematical formulas, and user-defined functions. Expert in using various type of charts, graphical representations, dashboard design patterns and visuals and guide the users on functionality and performance of the dashboard and reports. Experience in converting Legacy Reports to Tableau dashboards connecting to SQL server. Experience in Azure infrastructure management (Azure Storage, Azure AD and Office365). Worked on Microsoft Azure Data Factory, Azure Storage Explorer and coping data in on-premises SQL Server and write to Azure Data Lake Store in ORC format. Experience in Performance, Tuning operation on Azure Data Lake for big data analytics. Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse, Azure Storage Explorer. Experience on extracting data from Azure HDInsight and publish the transformed data into Azure SQL Data Warehouse and build reports on BI platform. Hands on experience in working with Applications Migration and App Development in AZURE. Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL. Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic. Excellent Interpersonal, Communication, Problem solving, and analytical skills. Technical Skills: RDBM/Databases MSSQL Server 2019-2008, Oracle 12c, MS Access, Microsoft Azure Programing Languages T-SQL, PL/SQL, C, MDX, XML, HTML, Java, Python, C Data Modeling FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-Normalization Techniques BI Tools SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI (Power Pivot, Power View), Power Query, Power Map), SQL Server Analytical Services (SSAS), Visual Studio, BIDS, Tableau, Power BI. Tools/Database Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Visual Studio Team Foundation Server (TFS). Application Packages MS Office, Microsoft SharePoint Server (MOSS) Operating Systems Windows XP/Vista/7/8 and 10; Windows 2003/2008R2/2012 Servers. Cloud Service Microsoft Azure, Amazon Web Service (AWS), IBM Cloud and Oracle Cloud Education: Master of Information Technology Central Queensland University, Melbourne, Australia. Bachelor s degree in computer science engineering Jawaharlal Nehru Technological University. Hyderabad, India. Professional Experience: Client: Baptist Memorial Health Care Corporation, Memphis, TN (April 2024 present) Description: Baptist Memorial Health Care regularly serves communities in the Mid-South by offering safe, integrated, patient-focused, high quality, innovative and cost-effective medical care. But serving a community is about more than just helping patients feel better. Role: Data Analyst/Power BI Developer Roles and Responsibilities: Interact with end users and business representatives for requirement analysis and to define business and functional specifications. Analyze various heterogeneous data sources to extract, transform and load data into the target data warehouse based on the requirements using SSIS Implemented data mapping, design, develop and perform ETL solutions using SSIS. Worked with end users in the life cycle of the major projects within the organization for requirements gathering, development, testing and maintenance of the reports. Optimized databases by creating various clustered and non-clustered indexes and indexed views. Implemented PowerShell scripts for creation of user, contacts for bulk modification in active directory. Involved in performance tuning using SQL server profiler. Used transformations like lookup, derived column, union all, merge to modify the data. Write complex SQL store procedures using joins, subqueries and correlated subqueries. and maintain Database objects in data warehousing environment. Involved in the implementation of data warehouse for healthcare analytics, which improved the data integrations practices from various EMR systems. Involved in design and development of Epic Integrated BI platform for healthcare analysis for clinical decision support. Deployed machine learning algorithms inpatient data analysis for predicting readmission rates and enhancing patient care plans. Developed custom BI solutions for real time patient monitoring by streamlining care processes. Implemented data governance practices while adhering to HIPAA regulations while handling sensitive patient data within BI systems. Facilitated the automation of data pipelines for healthcare clients for accurate and up to date reporting solutions for clinical operations. Developed complex Power BI reports using formulas, setting parameters for some dynamic reporting, creating sub reports and incorporating the use of graphs. Used various visual representations like graphical charts, graphs, KPI s to better communicate data to stakeholders. Environment: SQL Server 2016/2014/2012 Enterprise Edition, .Net 3.5, SQL BI Suite (SSAS, SSIS, SSRS), OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access & Windows Server 2008R2, Oracle, Crystal Reports, Cogno's, Business Objects, SharePoint, ER/Studio, Tableau 9.1(tableau desktop, tableau server, tableau online). Client: T. Rowe Price, Baltimore, MD (July 2023 March 2024) Description: Rowe Price Group, Inc. is an American publicly owned global investment management firm that offers funds, subadvisory services, separate account management, and retirement plans and services for individuals, institutions, and financial intermediaries. Role: SQL/Power BI Developer Roles and Responsibilities: Involved in Planning, Defining and Designing data, based on business requirements and provided documentation. Developed Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic. Used Joins, CTE's, 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 data warehouse and data marts from scratch based on data structures and reporting needs. Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS). Created SSIS packages for Uploading of different formats of files (Excel, Access) and databases (SQL server, Flat files) into the SQL Server data warehouse using SSIS and was responsible for ETL job scheduled to run daily. Solved the issues associated with ETL Data Warehouse Failure. Imported data from Excel, SQL Server DB and Azure SQL DB to Power BI to generate reports. Creating and maintaining Power BI Reports and Dashboards and embedding them inside on premises Organizational apps for the larger audience to view them. Explore data in a variety of ways and across multiple visualizations using Power BI and used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data. Assigning Power BI pro licenses to the users, configuring role base security by creating row level security in Power B|I desktop. Used Power BI Gateways to keep the dashboards and reports up to date and installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Published reports and dashboards using Power BI Key deliverable. Worked on Creating Dynamic Parameterized Power BI reports to filter the Data from One report To the Other. Worked on Paginated reports in Power BI Cloud and scheduled them to mail in form of PDF reports for End users Consumption. Developed Azure data factory pipelines to move data from source systems and transform the data in Azure blob storage and created ADLA USQL jobs to transform the data in Azure. Involved in data migration from SQL, SQK Azure, Azure storage, and Azure data factory using SSIS. Created applications to load data from Azure storage blob to Azure SQL, to load data from web API to Azure SQL and scheduled jobs for daily loads. Involved in creating internal and external tables in AZURE SQL data warehouse and created stored procedures to move data from external to internal tables. Involved in designing, developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft Azure and scheduling the cube through Azure functions. Setting the policies, limits for the Azure data lake analytics and provide access to the users to process USQL jobs. Involved in configuring and upgrading the on-premises data gateway between various data sources like SQL server to Azure analysis services and power BI service. Involved in the meetings with the business users to understand the requirements. Priorities and estimate development and deliverables to Project manager. Created technical documentation for the future maintenance purpose. Followed Agile Methodology to provide update on the day-to-day processes. Environment: SQL Server 2012, SQL Profiler, SSIS, Power BI, Visual Source Team Foundation (VSTF), .Net 3.5, SQL Server Data tools (SSAS, SSIS, SSRS), Enterprise manager, Azure SQL XML, MS PowerPoint, MS Project, MS Access & Windows Server, Crystal Reports, Business Objects, SharePoint and MS Office. Client: BAPCOR, Melbourne, Australia (Feb 2019 June 2023) Description: Bapcor Limited is Asia Pacific's leading provider of vehicle parts, accessories, equipment, service and solutions. Bapcor's core business is the automotive aftermarket. Our businesses span the end-to-end aftermarket supply chain covering Trade, Commercial Vehicles, Specialist Wholesale & Retail. Role: BI Developer (Tableau) Roles and Responsibilities: Worked with Subject Matter Experts, in understanding, documenting, developing and testing their BI solutions. Responsible for Knowledge transfer and training existing and newly recruited resources on processes such as report development, deployment, coding and tools used for managing and developing reports, deploying or executing components, and batch application. Developed various database objects like Tables, T-SQL procedures, Stored Procedures, Views and complex queries using joins. Created and modified tables using SQL statements like Select, Insert, Drop, Alter, Update, Delete. Extracted large volumes of data from various data sources and loaded the data into target data sources by performing various kinds of transformations using SQL Server Integration services (SSIS). Generated matrix reports, tabular reports, drill down, drill through, sub reports and multi-parameterized reports using Tableau and SSRS. Designed and deployed graphic visulizations with drill down and drop down menu option and parameters using tableau. Created different KPI using calculated key figures and parameters. Worked on advance analysis actions, calculations, parameters, background images, trend lines, statistics and table calculations. Utilized tableau server to publish and share reports with business users. Migrated DTS packages from Legacy system like PARAGON to SQL SERVER 2012. Deployed Global and Zonal reports to Report server weekly, monthly and quarterly using Anthill and well as manually using Report Manager. Experienced in building groups, hirerarchies, sets to create detail level summary reports and dashbopards using KPIs. Demonstrated solid Reporting and SQL skills to coordinate changes to existing reports and develop new intraday and batch reports needed. Designed ETL processes for extracting, transforming and loading of OLTP data into a central data warehouse. Worked on development of SSIS packages for various inbound/outbound data, OLAP data architecture as well as Report functionalities in SQL Server 2016. Performed modifications to DB2SQL code used to deliver data to downstream application interfaces. Created Cubes using different types of OLAP methods like Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP). Involved in Analyzing, designing, building of OLAP cubes with SSAS 2012(R2) Identified and defined Fact relationships in SSAS. Provided production support to tableau users and wrote custome SQl to support business requirements. Shared tableau reports using techniques like packaged workbooks, PDF to different user community. Ran the Autosys batch jobs every week to generate reports in the LIQV(Web Application) after the scheduled LIQ batch runs for respective environments in SIT and UAT. Worked with financial systems team members to document systems and process environments. Presented excellent communication skills and coordination skills to effectively work with other team members and get the development completed as per the deadline. Promoted the company culture by approaching each day with team-oriented and can-do attitude. Environment: Microsoft SQL Server 2012, SQL Server Management Studio, SSIS,SSAS, Microsoft Visual Studio, Tableau, SQL Server Business Intelligence Development Studio (BIDS), AutoSys, JIRA, SSRS, SharePoint, MS Office. Client: HP, India (May 2017 January 2019) Description: Hewlett-Packard Company, American manufacturer of software and computer services and a major brand in the history of computers and computer-related products. The company split in 2015 into two companies: HP Inc. and Hewlett Packard Enterprise. Role: MSBI Developer Roles and Responsibilities: Developed various database objects like Tables, T-SQL procedures, Stored Procedures, Views and complex queries using joins. Created and modified tables using SQL statements like Select, Insert, Drop, Alter, Update, Delete. Interacted directly with end users in gathering requirements, analysis, planning, developing and testing. Developed ETL packages by extracting data from Excel, CSV, SQL server, XML files and Oracle Server. Used various transformations for Data Conversion, Derived Columns, Lookup, Conditional Split, Merge. Developed Cubes using SQL Analysis Services (SSAS) and Dimensions using cube wizard and Generated Named calculations and named queries. Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL. Generated Drill down, Drill through reports and made cross functional tabs using SSRS and Deployed reports using Reporting Services Report Manager. Used various report items like tables, sub report and charts to develop the reports in SSRS. Migrated Crystal reports to SSRS reports. Environment: MS SQL Server 2010/2012, T-SQL, PL/SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP and Crystal Reports. Keywords: cprogramm business intelligence database active directory information technology hewlett packard trade national microsoft procedural language Delaware Maryland Tennessee