Business Intelligence and Data Analyst

• Jan 2019 - Present

Business Intelligence & Data Analyst

• Sep 2017 - Jan 2019

Project Description:• Project deals with building actionable dashboards to empower IT executives, to make informed business decisions.• Review with each IT department executives on monthly basis.• Enabling real-time analytics to deliver new business processes.• Project Delivery reports measure the performance project delivery in meeting costs, customer needs, schedule and quality standards.• PNC IT Dashboard as a framework to have centralized dashboard for project teams for Financials, Workforce and Incident details.• Software Quality Assurance to perform review of deliverables and activities on DEV projects to verify that the best practices and process controls of each Project delivery process owner are executed.• Reports are based on the data available across all Business LOBs.• Actionable dashboards to empower IT executives to make informed business decisions.• Enabling real-time analytics to deliver new business processes.Responsibilities:• Understand and document the business for IT reporting applications.• Data mapping from Application to BO Objects. • Co-ordination of tasks and activities between Onsite and Offshore IT Team.• Business Objects Web Intelligence reports and universe development.• Business Objects Webi and Universe specification creation.• Business Objects Reports and Universe maintenance.• Application changes impact analysis on Reporting.• Data analysis of applications data mart.• Designing Xcelsius dashboards based on technical specification.• Regression testing of applications while the database changes happens.• Supervised the Business Objects reports and universes across environments using BO tools.• Root cause analysis for the Production defects and impact analysis for new requirements.• Software Quality Assurance reporting to provide Project review updates through monthly dashboard.• Quality Cup reporting updates to recognize teams that implement best practices for Quality. Show less

BI Analyst

• May 2015 - Aug 2017

• Understand and document the business for IT reporting applications.• Data mapping from Application to BO Objects. • Co-ordination of tasks and activities between Onsite and Offshore IT Team.• Business Objects Web Intelligence reports and universe development.• Business Objects Webi and Universe specification creation.• Business Objects Reports and Universe maintenance.• Application changes impact analysis on Reporting.• Data analysis of applications data mart.• Designing Xcelsius dashboards based on technical specification.• Regression testing of applications while the database changes happens.• Supervised the Business Objects reports and universes across environments using BO tools.• Root cause analysis for the Production defects and impact analysis for new requirements. Show less

BI Analyst

• Sep 2014 - Apr 2015

• Understand and document the business for IT applications.• Data mapping from Application to BO Objects. • Co-ordination of tasks and activities between Onsite and Offshore IT Team.• Business Objects Web Intelligence reports and universe development.• Business Objects Webi and Universe specification creation.• Business Objects Reports and Universe maintenance.• Application changes impact analysis on Reporting.

System Analyst

• Jul 2014 - Aug 2014

Responsibilities:• Understand and document the business for BULK application.• Co-ordination of tasks and activities between offshore and Client.• Data mapping from Application to BO Objects. • Business Objects Web Intelligence reports and universe development.• Business Objects Webi and Universe specification creation.

Business Intelligence Analyst

• Mar 2012 - Aug 2014

BI Developer

• Apr 2012 - Jun 2014

Carried out following activities: • Involved in understanding and customizing framework as per requirement. • Analysis of the UI and finding possible flaws (so that it can be corrected at the time of coding) • Writing Test Plan and test cases for the new functionality introduced in the release. • Manual testing for the new functionalities introduced by the client. • Regression testing for different Environments and stages. • Reporting defects in QC and following up with the developers until the defects are fixed. • Defect tracking & Management of test scripts done using Quality Center. • QA Testing before the sign off for the initiative. Responsibilities: • Understand and document the business for Life and Health reporting applications. • Co-ordination of tasks and activities between offshore and onsite IT Team. • Data mapping from Application to BO Objects. • Business Objects Web Intelligence reports and universe development. • Business Objects Webi and Universe specification creation. • Business Objects Reports and Universe maintenance. • Application changes impact analysis on Reporting. • Data analysis of applications data mart. • Regression testing of applications while the database changes happens. • Supervised the Business Objects reports and universes across environments using CMC. • IT Testing for BO Reports and universe. • User Incidents' support. • Root cause analysis for the UAT and Production defects and impact analysis for new requirements. Show less