SUMMARY:

• Expert in developing Dashboards, reports using Power BI technologies.
• Experience with DAX, Power Pivot and Excel
• Exposure to Business intelligence/data warehousing technologies and Microsoft BI stack (SQL Server, SSAS, SSRS, Power BI, and TFS)
• Experience with Tableau reporting platform
• Good knowledge of Oracle and SQL database technologies
• Service Now, RPA Tools (Blue Prism, UiPath, Automation Anywhere)
• Experienced in translating business requirements into technical specifications to design and deliver optimum solutions for business needs.
• Strong business analyst skills, able to work with many different stakeholders to elicit and document requirements.
• Strong estimation skills and strong track record of accurate estimations for BI solutions.
• Data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs
• Six Sigma Methodologies, SPC XL, Design of Experiments (DOE), FMEA, Requirements tracking, Risk Analysis, Cost benefit analysis, Activity Diagrams, Critical Path Methods, Statistical Analysis.
• Problem Management, Change Management, Incident Management, Knowledge Management, Project Management
• Documentation and JAD sessions, Requirements gathering, SDLC methodologies, ITIL Methodologies.
• Service Now, RPA Tools (Blue Prism, UiPath, Automation Anywhere)

WORK EXPERIENCE:

Confidential, Corning, NY

BI Analyst

Responsibilities:

• Creating Power BI models for various Divisions of Corning In corporation and writing complex DAX queries
• Work with Businesses, manufacturing plants and IT to create analytics in Power BI platform
• Designing and Developing Complex Data Models and to Provide continuous maintenance and development of bug fixes for the existing and new Power BI and Tableau reports.
• Gathered requirements from business users and created KPI's and visuals which enabled them to take better decisions
• Onboard new data to SSAS Tabular model and create power bi reports using live connection to cube.
• Training end users, Stakeholders and Business Partners on Power BI and Tableau system features Globally
• Write SQL queries to slice and dice data for various dashboards.
• Extract data from SQL Server, share point lists, MS Access, Web pages, Service Now, OData Feed, Salesforce reports etc. to perform analysis, ad - hoc reporting and create dashboards for management.
• Participated in various stages of project from requirements gathering to development of reports and pushing the reports to production
• Upgrading Application servers, Monitoring the Performance and providing necessary recommendations for improvement.
• Acted as Power BI admin parallelly managing various requests from users in ServiceNow
• Worked intensively with Microsoft team to deploy any changes related to Power BI application in dev and prod environments.
• Worked with Neal analytics to monitor performance of the application.
• Worked with restricted, special controls and personal data and applied row-level security depending on the requirements from the users
• Worked with report server power bi version to manage special control and personal data
• Worked on establishing gateways for different sources and configuring them for users.
• Deployed monthly updates to application while working with Altiris team in releasing packages and deploying it to user machines.
• Followed Performance Excellence methodologies such as DMAIC, DESGN in implementing the projects, also participated in the general Non - Performance Excellence projects. Lean principles are followed for projects with support of belts in the team.
• Followed ITIL methodologies for improving and mitigating the gaps in the processes.
• Worked with Corning Environmental Technologies division forecasting team to build a content tracker report in report server power bi application with row-level security design at database level, for green book process.
• Worked with Corning Optical fiber communications division in creating price Pressure calculation inside power bi for different periods using DAX queries
• Worked with Corning Specialty Material division to create PGS reports to have a track on Inventory and Work In progress shipments for various factories and sites.
• Tracking all the problem tickets that were reported to IT Infrastructure Operation team from all the IT Site Leads

Confidential, Dublin, CA

Business Analyst

Responsibilities:

• Worked as a Business Analyst on various projects of the company to gain the experience.
• Worked with clients of the company for multiple projects to gather requirements, conducted JAD sessions with various stakeholders, prepared BRD and got approval from business team, IT department.
• Involved in the study of Historic data, understanding and collecting the requirements from client. Brainstorming with the team to extrapolate the requirements that are not stated.
• Created use cases, activity diagrams and process diagrams using Microsoft Visio.
• Created AS-IS and TO-BE business process flow diagrams, integrate process flow diagrams to show one end-to-end business model and process mapping exercise including swim lanes.
• Identify GAP in various business processes. Conduct discussion sessions with various business owners and redefine business processes.
• Work with IT project manager to Implement and prioritize change request from the Stakeholder and SME in Service Now and maintain all project documents on Share Point.
• Provide reports to management on a weekly basis about the progress of the project.
• Conduct and participate in various meetings and provide weekly status report to the management.