Harika K
Bothell,WA
Summary
Detail-oriented, organized, and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team leader and player ready to contribute to company success.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Business Intelligence Engineer
Microsoft
08.2019 - Current
- Working as a team lead (team of 5) for the past one year and maintained 4.80/5 and above CPE almost consistently
- Debugged and resolved, escalated, complex technical user issues on the Power Bl Platform and delivered Technical Support against CPE (Customer -premises equipment) and workflow efficiency targets
- Work with the Power Bl Engineering team to prioritize the product bugs
- Keep escalations to PG operations below 10% of the volume
- Retrieve the network logs using Fiddler, Network Monitor tool, etc
- Troubleshoot any user errors with the help of Request ID; verify request and response between the dataset and applications using Kusto
- Reproduce the user issue both in test environment, and end user's environment as needed
- Once the issue is identified, would share the root cause to the users, and fix it on given ETA.
- Used pivot tables, custom visuals, Groups and Filters like Visual level, page level, Drill through and Report level in Power Bl
- Worked on creating Parameters, formatting, sorting, and grouping
- Created customized and interactive dashboards using multiple data sources (SQL Server, Oracle, PostgreSQL, on-prem and cloud sources), publishing reports to Power Bl services, setting up the necessary connection details, and scheduling
- Worked on assigning permissions and report access based on user roles (Power BI Admin tasks.)
- Setting up new users in Azure Active Directory
- Handled support delivery on breaking fixing the issues, providing technical support in an often- ambiguous environment, to Power Bl and Dynamic 365 customers throughout the world.
Microsoft Business Intelligence Developer
Assurant
10.2015 - 09.2017
- Worked in the mortgage department which provides services including real estate appraisal, inspection, etc.., for banking clients
- Specifically, our team develops and maintains the database for transactions of home inspections / preservations as well as a reporting server for easy analysis
- Extended the existing database and added new features to support the updated requirements from Wells Fargo
- Implemented new SSIS packages to load data into the database from flat files sent by the Aspen Grove (Vendor)
- Also, scheduled a daily job for data ingestion
- Implemented a store procedure to schedule recurring inspections order for home loans in Wells Fargo based on the latest inspection / occupancy status
- Worked on 5-member team, which migrated servers from Austin to a data center in Woodbury, Minnesota
- Created staging environment for the inspections / preservations database as well as the reports server to test changes with real data before loading into production
- Created dev environment for all the above databases for faster development
- Modified all the package paths to point to the newly updated location
- Manually validated that the dimensions, indices, etc..
- Loaded properly in production post-migration
- Implemented new functionality in business intelligence reports like adding drill downs, drill-throughs for richer analytics
- Developed new SSRS reports with stored procedures pulling a different slice of the SQL database
- Improved the running time latency of store procedures used to generate reports to prevent timeouts over large scale data
- Provided production support on service desk tickets for existing reports by making incremental updates to data/ code
- Raised Cherwell tickets requesting DBAs to push updated code to production.
SSIS Developer
Assurant
10.2014 - 09.2015
- Worked on Global Warranty Program which unified claim/ policy management process for all product lines (vehicle, electronics, and mobile warranty) across 12 countries
- Migrated insurance policies / claims data from SQL database to MS Dynamics (CRM tool) to provide an actionable user interface for case management
- Implemented the SSIS packages to the load the data into CRM tables, according to the data mapping specification
- Applied various business logic transformations on the extracted source data from the SQL server
- Performed data validation for each stage of the ETL process and handled the data errors
- Used UC4 (job scheduler) to schedule and run the jobs to execute the SSIS packages
- Checked in all the SSIS package code to maintain TFS source version control.
Microsoft Business Intelligence Developer
UPS
01.2014 - 09.2014
- Worked on a 2-member team, which built an OLAP analytical data model from the users’ transactional data about orders/ shipments
- Extracted the data from Oracle databases, applied ETL transformations and loaded the data into SQL server destination (OLAP data model)
- Incrementally loaded the data to handle the large scale (> 10 million records)
- Created the dimension/fact tables in the OLAP data model
- Applied various control flow and data flow transformations in SSIS to clean the multidimensional data
- Wrote reusable, well-tested, performant child packages and organized them into a parent package for ease of use
- Created and maintained log tables to record the size of data for each package and reject tables to store the rejected/bad data
- Manually unit-tested the packages and validated the destination/log/reject tables
- Debugged production errors in both control flow level and dataflow level transformations
- Scheduled regular runs for all the packages using SQL server agent job to maintain a continuously updated OLAP model
- Cleanly documented all the tasks in the project for easy knowledge transfer to other members in the team.
Education
Bachelor of Technology (B. Tech) - Electronics and Communication Engineering (ECE)
Jawaharlal Nehru Technological University (JNTU)
Hyderabad, TG05.2009
Skills
- Power BI, Power BI administration, DAX
- MSBI (SQL, SSIS,SSRS, SSAS)
- Python
- Excel
- Azure Cloud, Azure SQL, Azure Data Lake
- Basics of Layer 7 Azure Networking
Certification
Power BI Base Advanced by Cloud Academy,Inc.
issued June 2021
Credential ID 21287843
Timeline
Business Intelligence Engineer
Microsoft
08.2019 - Current
Microsoft Business Intelligence Developer
Assurant
10.2015 - 09.2017
SSIS Developer
Assurant
10.2014 - 09.2015
Microsoft Business Intelligence Developer
UPS
01.2014 - 09.2014
Bachelor of Technology (B. Tech) - Electronics and Communication Engineering (ECE)
Jawaharlal Nehru Technological University (JNTU)
Similar Profiles
Shubham SinghShubham Singh
Software Developer II (Level 62) at MicrosoftSoftware Developer II (Level 62) at Microsoft
DIVJOT SINGHDIVJOT SINGH
Software Engineer II at MicrosoftSoftware Engineer II at Microsoft
Premlata KumariPremlata Kumari
Technical Program Manager at MicrosoftTechnical Program Manager at Microsoft
REAGAN M. HARKINREAGAN M. HARKIN
Customer Experience Program Mgr., Dragon Copilot at MicrosoftCustomer Experience Program Mgr., Dragon Copilot at Microsoft
Jennifer HallmanJennifer Hallman
Registered Behavior Technician at Avery Behavior Consulting Inc.Registered Behavior Technician at Avery Behavior Consulting Inc.