Bonny is available for hire
Hire BonnyBonny Pradhan
Verified Expert in Engineering
Data Engineer Developer
Location
Edina, MN, United States
Toptal Member Since
December 8, 2021
Bonny has worked in global data analytics teams as a business intelligence consultant, team lead, ETL, and reporting developer. 她的数据分析客户群来自零售领域, 包括全球顶级零售商. 她的工作包括理解业务需求, 提出最优解决方案, 开发满足客户期望的解决方案. Bonny takes ownership, delivers on time, 目标是在任何情况下都能得到最好的结果.
Portfolio
FLYR, Inc.
Looker, Google BigQuery, SQL, BigQuery，仪表板设计，数据报表
气象组-主台
Looker, Redshift，商业智能(BI)， Microsoft Excel, CSV, OLAP...
黄色社交互动
Looker, PostgreSQL, Google BigQuery, pgAdmin，数据仓库设计...
Experience
Availability
Full-time
Preferred Environment
PyCharm, Snowflake, Microsoft Power BI, Tableau, Oracle BI, Teradata, PostgreSQL, Oracle SQL Developer, Looker, Bitbucket
The most amazing...
...thing was the Oracle retail data warehouse implementation project: the legacy reporting was switched from Excel to an OBIEE platform, with KPI-based reports.
Work Experience
数据分析师和仪表板创建者
2023 - PRESENT
FLYR, Inc.
- 通过数据可视化帮助运输领导者进行收入管理.
- Architected data modeling for KPIs, cubes, and metrics in Looker and BigQuery SQL.
- Carried out the technical design of Looker dashboards with cosmetic enhancements.
- Managed source control using application lifecycle management (ALM) tools like Jira and GitHub.
- 使用高级SQL查询创建新的Looker指标.
Technologies: Looker, Google BigQuery, SQL, BigQuery，仪表板设计，数据报表
Looker Expert
2022 - PRESENT
气象组-主台
- 构建和设置Looker仪表板和报告. Used advanced Looker concepts like merge reports to derive time transformation logic to date and previous year in Looker.
- Developed profit and loss dashboards, balance sheets, and income statements on Looker.
- 排除数据集成和同步的潜在问题.
- Managed Looker更新和市场分析可用.
- 设置其他实例并进行数据迁移.
- Worked with back-end data sets to understand and work on the current data structure.
Technologies: Looker, Redshift，商业智能(BI)， Microsoft Excel, CSV, OLAP, Data Visualization, Data Analysis, Data Analytics, CSV File Processing, Office 365, Dashboard Design, BigQuery, Consulting, Google Cloud, Data Privacy, Data Reporting
分析工程师和Looker开发人员
2022 - 2022
黄色社交互动
- Deployed the Looker reporting interface for hundreds of users in the company for easy access to data.
- 为不同的数据维护适当的临时环境(探索), 比如支付方式或玩法.
- 从遗留系统迁移了大约20个分析和操作报告.
- Understood the data structure in Google BigQuery and PostgreSQL and created various analytical reports for the client.
- 在提供支持的同时，作为所有报告需求的联络点.
Technologies: Looker, PostgreSQL, Google BigQuery, pgAdmin，数据仓库设计, Query Optimization, Data Architecture, PL/SQL, SQL, Reporting, Snowflake, Data Modeling, Dimensional Modeling, Data Visualization, Data Analysis, Data Analytics, CSV File Processing, Office 365, Data Migration, Dashboard Design, BigQuery, Consulting, Google Cloud, Data Privacy, Data Reporting
ETL and BI Consultant
2020 - 2021
Torrid
- 在Snowflake DB和Power BI上实现了Robling数据仓库.
- Wrote Snowflake and Google BigQuery SQL for complex customer logic such as rewards and Torrid credit cards.
- Integrated customer data from disparate sources like flat files and Oracle Retail Sales Audit (ReSA) into Snowflake.
- 在Snowflake上编写分层查询，用于报告显示产品层次结构.
- 使用Looker创建了一个临时报告接口.
Technologies: Snowflake, Python, PyCharm, Looker, Git, Data Engineering, Data Warehouse Design, Query Optimization, Azure Data Factory, 数据分析顾问, Data Management, 商业智能顾问, Data Architecture, PL/SQL, Star Schema, SQL, Data Modeling, Reporting, Microsoft Power BI, Data Pipelines, Microsoft Excel, CSV, Dashboards, OLAP, Google BigQuery, Data Visualization, Data Analysis, Data Analytics, CSV File Processing, Office 365, Data Migration, Dashboard Design, Consulting, Google Cloud, Data Privacy, Data Reporting
首席软件工程师
2020 - 2021
LIS Nepal Pvt
- Developed Python scripts for ETL processes on Snowflake DB, Power BI, and Tableau.
- 在Snowflake上为ETL编写高级查询，并在Power BI上编写报告.
- Led a team of more than five members and supervised go-live activities and hyper-care support for different phases of Robling data warehouse in Snowflake DB and Looker reporting interface.
- Tracked and fixed bugs on Jira for user acceptance testing as offshore reporting lead.
- 带领历史转换团队进行十年数据的转换.
- Developed around 1,500 metrics on Looker, 包括像YTD这样的时间转换指标, last year, and more.
Technologies: PyCharm, Snowflake, Looker, Python, SQL, Data Visualization, Excel 365, Technical Documentation, ETL, Data, Git, Data Engineering, Redshift, Data Warehouse Design, Query Optimization, 数据分析顾问, Oracle, PL/SQL, Star Schema, Analytics, Tableau, Microsoft Power BI, MySQL, 亚马逊网络服务(AWS), Azure, 谷歌云平台(GCP), Oracle Cloud, Azure Data Factory, Data Pipelines, Microsoft Excel, Data-level Security, CSV, Dashboards, Dimensional Modeling, Data Analysis, Data Analytics, CSV File Processing, Office 365, DAX, Power Query, Data Migration, Dashboard Design, BigQuery, Consulting, Oracle Database, Google Cloud, Data Privacy, Data Reporting
ETL Consultant
2020 - 2020
Accent Decor
- 将10年的历史数据从SQL server转换为雪花.
- 与Azure数据工厂(ADF)管道一起将数据加载到Snowflake DB中.
- 写查询验证和测试数据一致性在Snowflake数据库.
Technologies: Snowflake, Bitbucket, Python, Git, Data Warehouse Design, Query Optimization, 数据分析顾问, Data Management, 商业智能顾问, Data Architecture, PL/SQL, Microsoft SQL Server, Star Schema, Microsoft Excel, CSV, Dashboards, OLAP, Dimensional Modeling, Excel 365, Data Visualization, Data Analysis, Data Analytics, Office 365, Data Migration, Dashboard Design, Consulting, Google Cloud, Data Privacy, Data Reporting
商业智能顾问
2016 - 2018
Matahari
- 与客户利益相关者合作，使用Oracle构建强大的BI系统, Power BI, 和Tableau用于不同的部门.
- Designed, planned, and developed around ten major company dashboards with variation and security for stores, buyers, and vendors.
- Gathered requirements and analyzed them for the design of analytical and operational reporting.
- 指导和监督10人左右的BI技术团队.
Technologies: Oracle BI, Oracle BI Publisher, Oracle Fusion中间件, Oracle SQL Developer, Data Warehouse Design, Query Optimization, 数据分析顾问, 商业智能顾问, Data Architecture, Oracle, Star Schema, Oracle Cloud, Microsoft Excel, Data-level Security, CSV, Dashboards, OLAP, Dimensional Modeling, Excel 365, Data Visualization, Data Analysis, Data Analytics, CSV File Processing, Office 365, SAP, DAX, Power Query, Data Migration, Consulting, Oracle Database, Google Cloud, Data Privacy, Data Reporting
高级软件开发人员| BI顾问
2016 - 2018
LIS Nepal Pvt
- 积极配合OBIEE服务器和RPD进行设置, developing, testing, 部署Oracle数据仓库和报表服务.
- Modeled dashboards to report daily sales and profit figures to top management of retailers.
- 在系统开发生命周期的所有阶段领导和监督团队, such as design, coding, testing, tuning, integration, and support.
- Carried out successful deployment and stabilization of data warehouse projects in different phases.
- Provided capacity building to the client's business users and IT users for project handover and support.
- 为全球零售商做了近两年的顾问.
- 撰写Tableau和Power BI的运营和分析报告.
Technologies: Oracle BI, Oracle SQL Developer, Oracle BI Publisher, ETL, Data, Query Optimization, 数据分析顾问, Data Management, 商业智能顾问, Oracle, PL/SQL, Star Schema, Analytics, 亚马逊网络服务(AWS), Azure, 商业智能(BI), Reporting, Tableau, Microsoft Power BI, SQL, Snowflake, MySQL, Oracle Cloud, Microsoft Excel, Data-level Security, CSV, Dashboards, OLAP, Dimensional Modeling, Excel 365, Data Visualization, Data Analysis, Data Analytics, Office 365, Redshift, DAX, Power Query, Data Migration, Dashboard Design, Consulting, Oracle Database, Google Cloud, Data Privacy, Data Reporting
Software Developer
2013 - 2016
Yomari Inc
- Worked on reporting and security module of a web application for Nepal Stock Exchange board.
- 为定制模块开发ETL脚本，以替换遗留系统.
- 对shell脚本进行单元测试和系统集成测试.
技术:Linux, Teradata， .NET, WinSCP, Unix Shell Scripting, SQL, Microsoft Excel, CSV, Excel 365, Data Visualization, Data Analysis, Office 365, Redshift
Experience
罗布林数据仓库实现
Robling数据仓库是为一家零售商实现的. The database was migrated to a cloud-based Snowflake database using Python scripting. Looker reporting application provided an ad-hoc interface where the client's business users could create interactive reports.
BI Reporting Project
I was a consultant who worked with top leadership at a national-level retailer in Indonesia with 150 stores to implement an Oracle data warehouse system and BI reporting platform.
The Oracle retail analytics system was implemented for the enterprise using Oracle DB, 五年的数据被转换. 我们开发了全公司的Power BI仪表板, 店铺计划报告, 并为买家提供安全的数据. An ad hoc reporting environment was also set up, and access was provided to specific users. I collaborated with stakeholders at the management and operational levels to validate the data in reports. I also provided training on the reporting system to the client's business and technical customer support. The project needed advanced SQL queries for ETL for its complex source systems and reporting.
The Oracle retail analytics system was implemented for the enterprise using Oracle DB, 五年的数据被转换. 我们开发了全公司的Power BI仪表板, 店铺计划报告, 并为买家提供安全的数据. An ad hoc reporting environment was also set up, and access was provided to specific users. I collaborated with stakeholders at the management and operational levels to validate the data in reports. I also provided training on the reporting system to the client's business and technical customer support. The project needed advanced SQL queries for ETL for its complex source systems and reporting.
Logic Retail Data Model
A large retailer in the US had a large ERP system and need to analyze and utilize their data for decision making. A customized data warehouse product was developed for the project and shell scripts were developed for the ETL module.
一些数据集市，如商店计划和商店流量，相对来说更复杂. 高级SQL是为这些数据集市的数据提取而编写的, 通过从客户那里全面收集需求来实现. Legacy scripts used were then migrated and the data model was designed to incorporate them in the data warehouse.
一些数据集市，如商店计划和商店流量，相对来说更复杂. 高级SQL是为这些数据集市的数据提取而编写的, 通过从客户那里全面收集需求来实现. Legacy scripts used were then migrated and the data model was designed to incorporate them in the data warehouse.
点播服务的利基市场研究
A master's thesis was done on on-demand services niche markets for an application of a ride-hailing service for women.
A model was developed to show the identifiers and key success variables for a niche market for an on-demand service. The model was validated by a questionnaire survey and quantitative data analysis with SPSS. The model was also illustrated for a ride-hailing service for women and an app was developed for the same.
A model was developed to show the identifiers and key success variables for a niche market for an on-demand service. The model was validated by a questionnaire survey and quantitative data analysis with SPSS. The model was also illustrated for a ride-hailing service for women and an app was developed for the same.
尼泊尔证券交易所Web应用程序
The national stock exchange (NEPSE) in Nepal needed some upgrades to its web application.
Customizations were done in the centralized trading application to add certain features. 高级MySQL查询也在安全模块中编写用于报告. 使用这些查询开发了八个报告，包括, 循环交易报告和经纪人关系报告.
Customizations were done in the centralized trading application to add certain features. 高级MySQL查询也在安全模块中编写用于报告. 使用这些查询开发了八个报告，包括, 循环交易报告和经纪人关系报告.
Education
2018 - 2020
信息管理硕士学位
亚洲理工学院-泰国巴吞他尼
2009 - 2013
信息科学学士学位
Siddaganga理工学院-印度卡纳塔克邦
Certifications
JUNE 2019 - PRESENT
NVivo Certification
亚洲理工学院
JUNE 2012 - PRESENT
DB2数据库和应用程序基础
IBM
Skills
Tools
Microsoft Power BI, Tableau, Looker, Microsoft Excel, Power Query, BigQuery, PyCharm, Oracle BI Publisher, Git, Bitbucket, WinSCP, Shell, Oracle SQL Data Modeler, SPSS, Visual Studio, pgAdmin
Languages
Snowflake, SQL, Python
Paradigms
商业智能(BI), ETL, OLAP, Dimensional Modeling, Qualitative Research
Platforms
Oracle, 谷歌云平台(GCP), Oracle Database, 亚马逊网络服务(AWS), Azure, Linux
Storage
Teradata, Oracle SQL Developer, MySQL, Databases, Redshift, MariaDB, PL/SQL, Oracle Cloud, Data Pipelines, Google Cloud, Microsoft SQL Server, PostgreSQL, IBM Db2, Oracle 11g, Oracle SQL
Frameworks
.NET
Other
Oracle BI, Data Modeling, Data Warehousing, Excel 365, Data Visualization, Technical Documentation, Data, Excel Expert, ETL Tools, Communication, Datasets, Google Data Studio, Google BigQuery, Data Engineering, Analytics, Data Warehouse Design, Query Optimization, Azure Data Factory, 数据分析顾问, Data Management, 商业智能顾问, Data Architecture, Star Schema, Reporting, Data-level Security, CSV, Dashboards, Data Analytics, CSV File Processing, Office 365, DAX, Data Migration, Dashboard Design, Consulting, Data Reporting, Decision Support Systems, SAP, Data Privacy, Information & 通讯科技(ICT), Semantics, Data Mining, Information Retrieval, Project Design, Research Methods, 软件开发生命周期(SDLC), Computer Networking, Oracle Fusion中间件, Unix Shell Scripting, Oracle BIP, Shell Scripting, MicroStrategy, NVivo, Data Analysis
有效的合作
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
开始你的无风险人才试验
与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.
对顶尖人才的需求很大.
Start hiring