Bikas Anand
Verified Expert in Engineering
Data Engineering Developer
Bikas has over 20 years of data engineering, data analysis, and architecture experience. He has worked on several large DW and analytics implementations on-premises/cloud for GE, Union Bank, NBC, First Hawaiian Bank & Bayer, which included new implementations and modernizations while supporting legacies. He is proficient in SQL, databases such as Snowflake, Redshift, Postgres, and Teradata, Data Engineering Tools such as Informatica, Matillion, and DBT, and scripting languages such as Python.
Portfolio
Experience
Availability
Preferred Environment
Databases, Data Engineering, Data Analysis, SQL
The most amazing...
...work I've done was for Sochi Olympics, reporting for NBC Universal and fleet data management for GE Aviation.
Work Experience
Oracle Developer
SIG - Data Technologies Team
- Developed and delivered several integrations from various source files to Oracle using PL/SQL and Oracle to Hive using PySpark for traders to consume data and make decisions.
- Created a POC to use the Airflow scheduler instead of the existing Tidal Job scheduler.
- Developed a generic script to export data from Oracle to Hive using PySpark based on parameter values passed.
Data Engineer
Kalderos Inc
- Worked on building new integrations using Data Build Tool (dbt) and Snowflake for the reporting.
- Implemented several optimizations in the As-is process and improved data accuracy with data quality check implementations.
- Designed a new model for their customer reporting.
Data Modeler
Pfizer - Pfizer Cloud
- Worked on redesign of their existing data warehouse on AWS Cloud.
- Helped the data engineering team during new integration development.
- Designed and developed data model and integrations for DQ reporting solution for Pfizer.
Data Warehouse Technology Architect
Bayer
- Led the team for impact analysis and business coordination. Oversaw the ABBI support team for any technical issue/enhancements, working with Bayer stakeholders and maintaining an excellent relationship with key members from business as well as IT.
- Worked closely with Bayer's project architecture team, helping define the data flow and overall architecture for their data warehouse modernization.
- Implemented data discovery by working with the business and other stakeholders before implementing the data warehouse on a modernized platform.
- Played a vital role in the modernization program's As-is and To-be data analysis.
Enterprise Data Warehouse Architect
First Hawaiian Bank
- Defined initial roadmap and architecture process flow.
- Designed and developed credit analytics for the customer-facing 360 view for the bank.
- Designed and developed customer portfolio reporting.
- Defined ETL strategy and planning for different reporting requirements for the bank.
- Led the enterprise data warehouse (EDW) team to implement solutions and mentored the team members.
Business Intelligence and Analytics Architect
NBC Universal
- Led the team to integrate different systems into a big data (Pivotal HD) environment and sourced data from HDFS to the data warehouse for business intelligence (BI) reporting.
- Led the Sochi Olympics reporting implementation and support.
- Integrated the new source data, Operative One (sales system), DFP Premium (traffic system for displaying ads), and Freewheel (traffic system for video ads) for single view reporting.
ETL Architect
Union Bank
- Analyzed requirements and performed impact analysis.
- Designed databases and developed new integrations to support business requirements.
- Reported project status weekly to the Union Bank leadership team.
EDW Architect
GE Healthcare
- Built business user interactions.
- Conducted requirements and impact analyses.
- Designed databases and ETL.
- Documented processes and reviewed code.
Technical Project Manager
GE Aviation
- Led the implementation of the Proactive Fleet Management project.
ETL Lead
GE Healthcare
- Designed and led the development for a service invoicing project to send electronic statements to customers.
- Designed and developed Deal Analyzer, a project required to provide the functionality to retrieve historical quotes and customer history and to allow the user to analyze and decide upon quotes based on historical deal data, margin analysis, and other functions.
Experience
Technology Architect
First Hawaiian Bank - EDW
NBC Universal Advertising Sales and Analytics Technology
Sochi Olympics: Implemented event reporting for generating following daily reports and send it to key business stakeholders and ad planners.
BI Ad Sales Reporting: Responsible for design and development of data integration for sales and traffic systems.
Union Bank - Finance Reporting and CCAR Projects
GE Healthcare - BI COE
GE Aviation - Proactive Fleet Management
These reports were a combination of summary report with event count for each event type and drill down to each event type gives different charts, which included trend lines for the customer, comparison group, fleet, Pareto for component event drivers, reliability growth charts for forecasting, and trend lines for reliability growth.
GE Healthcare - BI Reporting
Deal Analyzer: The deal analyzer was intended to provide facilities for allowing the pricing team to compare and analyze a deal based on margin, historical data, and other aspects of a given portfolio.
C360: Consolidated customer data in a comprehensive manner to provide knowledge and understanding of customers from a more holistic view and provided the data to help GEHC improve its relationship with the customer and to make smarter, more customer-focused business decisions.
Skills
Languages
SQL, Snowflake, Python
Tools
Tableau, Amazon Elastic MapReduce (EMR), Cloudera, Spark SQL, Matillion ETL for Redshift, Apache Airflow, Amazon QuickSight, CVS, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Cognos ReportNet, Apache Impala
Paradigms
ETL, Business Intelligence (BI), Agile, ETL Implementation & Design
Platforms
Oracle, Amazon EC2, Talend, AWS Lambda, Amazon Web Services (AWS), MacOS, Unix, AIX, Solaris, Linux
Storage
Teradata, Redshift, Amazon S3 (AWS S3), Databases, Apache Hive, HDFS, PostgreSQL, Oracle9i, Oracle PL/SQL
Other
Data Warehousing, Data Architecture, Informatica, Data Warehouse Design, Data Engineering, Data Modeling, ETL Tools, Data Analysis, Google BigQuery, Data Build Tool (dbt), Big Data, SAP BusinessObjects (BO), Trifacta, Fivetran
Frameworks
Apache Spark, Hadoop
Libraries/APIs
Spark Streaming, PySpark
Education
Bachelor's Degree in Computer Engineering
Vinoba Bhave University - Hazaribagh, India
Certifications
AWS Certified Solutions Architect Associate
AWS
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring