Business Intelligence Reporting Analyst
Resume:
Bhagwati Mishra
Sr. Business Intelligence Engineer
Visa – L2S, Visa Validity - Feb 2026
Location: Denver, CO – Pin code - 80112
**************@*****.***
To be the part of a team of high-caliber professionals for challenging new assignments and responsibilities in the field of Analysis, Design and Development thus sharpening my own professional skills, while at the same time, contributing my best to the overall development of the organization. Committed to organization growth with Open and Growth Mindset
Experience Summary:
I am a BI Professional with 15+ years of experience in IT, over a decade of experience in Analysis, Design, Development, Testing, and Implementation of BI applications using QlikSense, QlikView, MSRS, Tableau & Power BI. Many describe me as a passionate agile practitioner with strong customer focus. I work as an SME for everything under BI solutions including data loading or scripting, application architecture, report building visualization, Nprinting, task scheduling, QMC or administration, release management, resource management, coaching, mentoring other team members and much more.
Work Experience:
Company ANZ, Bangalore
Designation Senior BI Engineer
Duration From Aug 2011 – till date
Domain/Special Skills Business Intelligence/ Data Analytics
Location Bangalore
(From Aug 2011 till June 2012 worked as contractor from Magna, then after ANZ hired me on their payroll)
Company United Health Group, Gurgaon
Designation Software Engineer
Duration Nov 06 – Oct 09
Domain/Special Skills Web/Windows Developer
Location Noida
Company Softmart, Dehradun
Designation Trainee
Duration Jan 06 – Nov 06
Domain/Special Skills Web Developer
Project Details (Current):
ANZ (Enterprise Finance and Data)
Project Title : TB Insights
Duration : (From Feb 2018 – till Date)
Role : Qlik Sense SME
Team Size : 12
Platform : Tableau, Qlik Sense, Nprinting, Teradata, Excel files, SharePoint, KNIME Confluence etc.
Involvement : 100 %
The following dashboards consolidate data from multiple core systems across ANZ to help provide a better view of our customer’s relationship with ANZ.
Project#1: Cashsight
Tools: Qlik sense, NPrinting and Qlik sense Server
Aim of the Project:
The dashboard provides single interface for the Account Managers/Product owners alike to review the billing data from various source systems used by ANZ for billing customers on their various products. Cashsight will assist Account Mangers to better understand their customer’s PCM Product utilization and needs by delivering insights of their key Billing and Pricing activity. Key Billing system includes, Cache, Midanz, AF, CTM, IEB, commercial card & Vision Plus etc.
Project#2: Fulcrum
Tools: Tableau & KNIME
Aim of the Project:
A new advanced analytics solution Fulcrum, designed to help TB users unlock viable new commercial opportunities by accessing a consolidated and comprehensive view of their customer’s payables, receivables and payment landscape. It displays all AU domestic transactions, incoming and outgoing from a customer’s account. including associated information on origination, destination, description, and associated products (i.e. PCM Transactional Billing and TSC Instrument ID).
Project#3: TradeSight
Tools: Qlik sense and Qlik sense Server
Aim of the Project:
Provide the business graphical and/or tabular views of Customer Trade Activities and Transactions (Trades Insights) via the Enterprise Qlik Sense reporting platform.
The Dashboard provides Sales, Coverage, Risk, Product and Operations teams dynamic information about their Trade customers, allowing them to better understand customer activity and have more insightful interactions to improve service and identify new revenue opportunities. Trade Sight provides a rich dataset to manage business performance through an understanding of thier risk portfolio and customer trends.
Project#4: ProductSight
Tools: Qlik sense and Qliksense Server
Aim of the Project:
This is combination of data from Cashsight & Tradesight and few manual files directly loaded in QS to get insights at the product level for the product managers, To provide a overview and details of health check data sets related to Products.
Roles and Responsibilities:
A passionate agile practitioner with strong customer focus.
Time Management, Multi-Tasking, and ability to Prioritize work for the team.
Ensuring confidential data and information is stored appropriately.
Extensive Business Intelligence and operational solutions experience.
Fluency in both technical-analytical and functional knowledge of business process matters relating to solving business problems and having better stakeholder engagement skills.
Involved in full life cycle implementation of Business Intelligence projects with Design & Development of Dashboards.
Ensuring backup planning for each team member including self.
Mentoring the team for solving complex problems and sharing knowledge which empowers the team.
Ensuring services comply with policies, processes and standards.
Develop, Present and deliver Proof of Concept (POC) / Seeing is Believing (SIB) for Business Intelligence solution.
Building insights from large volume of data with the use of complex reporting and trend analysis.
Create, modify, and troubleshoot complex reports.
A clear understanding of dimensions and facts tables as part of the data warehouse database structures (Star Schema & Snowflake Schema).
Ensuring the data model is free from errors and testing the linkages across multiple sources.
The development and use of facts and dimensions for business intelligence.
Experienced in Extraction, Transformation & Loading (ETL) of data.
Work with functional team members to develop & design documents.
Excellent team player with solid interpersonal, technical and communication skills.
Deep understanding about Project Lifecycle Management using agile methodology.
ANZ (Markets)
Projects Handled:
Project#1: : Global Markets Confirmation Processing (GMCP)
Duration : Mar-16 – Feb-18
Role : BI Specialist
Team Size : 15
Platform : SQL Server 2008, Qlik View, SSRS, SSIS
Involvement : 100 %
Tools: QlikView 12, QlikView Server and Publisher, Nprinting, MSRS, SSIS, Control-M.
Aim of the Project:
The STP Dashboard is used to understand the statistics of STP and NON STP Rates over the period with Asset Class, Trade Type, Delivery Type, Entity Name, Counterparty Type and Counterparty Name as Selection Criteria. The Qlik Dashboard is broking down into four parts, the first being the overall STP/Non-STP Stats, followed by this being broken down into Outgoing and Incoming figures and then a final tab on Outgoing split by Product.to cover non STP breakdown MSRS reporting has been used.
Responsibilities:
Technical decision making for Business requirements – Interacted with Business users, framed the Business rules for the Qlik Dashboards & MSRS Reports.
Analyzed different source systems, transformed the data of various systems into desired format using Qlikview
Scheduled jobs in the Qlik Server, Maintenance of QlikView Server through job schedules.
Wrote complex SQLs and tuned them for performance on databases like Oracle,Sybase and Microsoft SQL Server
Used SSIS extensively for Reconciliation of data between multiple systems and scheduled them using control-M.
Designed complex SSRS reports using cascading parameters concept and dynamic SQL queries
Created Subscriptions and managed the Report Manager and Report Servers of SSRS
Played key role in migration of Reports and DB from Sql Server 2008 to SQL Server 2012.
Optimized queries and enhanced the performance of databases using Execution Plan, SQL Profiler and Database Engine Tuning Advisor.
Created SSIS package for loading the data coming from various interfaces and used multiple transformation in SSIS and also Script task and script components to achieve more customized function.
Used SSRS Reports and Power Pivot for providing Adhoc reporting for the clients.
Created Sql Server Jobs to trigger the Procedures and SSIS Packages.
Developed Stored Procedures, Triggers, and SQL scripts.
Implemented incremental loads using created Qvd files
Project#2 Asset Backed System (Reporting)
Duration : Feb 13 – Mar-16.
Role : System Analyst
Team Size : 4
Platform : SQL Server 2008, MSRS
Involvement : 100 %
Aim of the Project:
An asset-backed security (ABS) is a security whose income payments and hence value are derived from and collateralized (or "backed") by a specified pool of underlying assets. Since its Third-party tool we are responsible to apply new patched & deploy the enhancement change to the application given by the vendor and we have taken complete ownership of SSRS reports which is heart of the application and very much used by business analyst for everyday use.
Responsibilities:
Extracted data from internal data warehouse system to SSRS
Tracked trouble ticket request for request made by end users
Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
Analyzed data models, data relationships, and dependencies for greatest optimization
Created SSIS package for loading the data coming from various interfaces and used multiple transformation in SSIS and Script task and script components to achieve more customized function.
Release Management: Responsible for monthly release for new enhancement and report deployment, must coordinate with other team for their involvement in release like Window, DB, BI & access control Team.
Project#3: Confirmation Engine & Documentum, Bidoffer reporting, Regnetting reporting
Duration : Feb 13 – Mar-16.
Role : System Analyst
Team Size : 4
Tools : VB, ASP, MS Visual Studio 2008, ASP.NET, SSRS, control-M
Responsibilities:
Supporting various application which are running in production like Confirmation engine process, LDR, FSRA.
Worked on day-to-day activities like monitors servers & generated daily TLM & LDR reports for critical business.
Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users
Organization: United Health Group, Gurgaon
Designation : Software Engineer
Time Period : From November 2006 – 30th Oct 2009
Project#: IDT (Intelligent Desktop)
Technology Used: MS Visual Studio 2003, VB.Net, ASP.Net, Web Services, SOAP, Crystal Reports
Language : VB.Net, ASP.Net
Team Members : 25
Aim of the Project
IDT is the call-center application for United Healthcare Group (UHG). It's mission critical as all customer service representatives use this application when taking customer calls.
Responsibilities:
Worked as Developer in the team.
Requirement understanding and elaboration.
Coding and Unit Testing.
Achievements:
1.Recognized by end-to-end Delivery of Global Markets Confirmation Processing (2016)
2.Received monthly R&R awards (8 times) in 6 years
3.Received Appreciations for completing inhouse trainings on or before time (Tableau, GCP & AIML
Education
Master of Computers from HNB Garhwal University
(Bhagwati Mishra)
Contact this candidate