Shibani Patra
Perry Hall,MD
Summary
- Over 10+ Years of experience in Business Intelligence and Data warehousing technologies
- In-depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools.
- Working closely with the Stakeholders, Business teams (Department specific managers). To understand their requirement, gather the source data & specific metrics methodologies.
- Capturing & analyzing the business requirements in BRD & developing very complex visualization dashboards as per the organization's standards
- Capable of taking responsibility & accountability for developing, deploying & maintaining the Database & BI projects
- Hands-on experience in developing financial reports in various areas like Brightscope Data, Strategic Insights Data, EVestment Data, MorningStar Data
- Extensive experience in developing Web based application using Microsoft Power BI, Tibco Spotfire, Tableau, Alteryx, Qlik Sense, and Qlik View
- Ability to work independently and manage multiple tasks concurrently
- Extensive knowledge in writing Queries, Stored Procedures, Functions, Cursors, and Triggers.
Overview
12
12
years of professional experience
Work History
BI Developer
Vanguard
04.2017 - Current
- Working on 3rd party data SIMFUND, Evestment, and MorningStar.
- Built an end-to-end dynamic "Investment Performance " Dashboard. This Dashboard provides Historical Assets and Flow in the entire US Market
- Attend daily stand-up calls with IT teams.
- Making sure data is loaded into Snowflake Database on a weekly, monthly, and yearly basis.
- Creating different views in Snowflake as per the reporting needs.
- Scheduling reports to the corresponding groups
- Working extensively on "Transform Data" using Power Query in PoweBI
Business Intelligence Data Analyst
Alcon Labs
09.2011 - 03.2015
- Designed customized data collection models for specific visualization tasks.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Maintained proficiency with latest database technologies.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
- Created data analysis tools to allow teams and [Job title]s to query acquired information for unique details.
- Collected data from wide-ranging sources.
- Optimized system and platform performance capabilities in most efficient, practical way possible.
Business Intelligence Consultant
Xtellen
04.2009 - 09.2011
- Designed customized data collection models for specific visualization tasks.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data.
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
Education
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Seemanta Engineering College
INDIA03.2009
Skills
- Power BI
- Qlik Sense
- Tibco Spotfire
- Cognos
- Tableau
- Snowflake
- BI Tool and System Design
- Business Requirements
- Database Building
- Extraction Transformation and Loading (ETL)
- Technical Specifications
- Microsoft Excel
- Business Solutions
- Model Development
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
BI Developer
Vanguard
04.2017 - Current
Business Intelligence Data Analyst
Alcon Labs
09.2011 - 03.2015
Business Intelligence Consultant
Xtellen
04.2009 - 09.2011
Bachelor of Technology - Electrical, Electronics And Communications Engineering
Seemanta Engineering College
Similar Profiles
Akua Amos-AbanyieAkua Amos-Abanyie
Security Automation Manager at VanguardSecurity Automation Manager at Vanguard
Devyn RunningDevyn Running
Advisor Support Representative at VanguardAdvisor Support Representative at Vanguard
Eric S. BrownEric S. Brown
Sales Trainer, Specialist at VanguardSales Trainer, Specialist at Vanguard
Man LauMan Lau
Priority Operations Specialist at VanguardPriority Operations Specialist at Vanguard
Daniel NwokochaDaniel Nwokocha
Intern at Michnuel Systems LimitedIntern at Michnuel Systems Limited