Bikas Anand, Data Warehousing Developer in Jersey City, NJ, United States
Bikas Anand

Data Warehousing Developer in Jersey City, NJ, United States

Member since June 8, 2016
Bikas is a seasoned and expert developer with approximately 18 years of ETL and data warehouse/data lake implementation experience in both on-premises as well as cloud. He has worked on various projects with clients including GE Healthcare, GE Aviation, Union Bank, NBC Universal, First Hawaiian Bank, and Bayer.
Bikas is now available for hire


  • Bayer
    Spark, Python, Trifacta, Talend, Apache Impala, Apache Hive, HDFS, Big Data...
  • First Hawaiian Bank
    AIX, Oracle, Informatica
  • NBC Universal
    Tableau, Big Data, Apache HAWQ, Apache Hive, Hadoop, MicroStrategy...



Jersey City, NJ, United States



Preferred Environment

CVS, Linux, AIX, Unix, Mac OS, Windows

The most amazing...

...thing I've made is Sochi Olympics reporting for NBC Universal and fleet data management for GE Aviation.


  • Data Warehouse Technology Architect

    2017 - PRESENT
    • Led the team for impact analysis and business coordination Oversaw the ABBI support team for any technical issue/enhancements working with Bayer stakeholders 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.
    • Successfully implemented data discovery working with the business and other stakeholders before getting into data warehouse implementation on a modernized platform.
    • Played a key role in AS-IS and TO-BE data analysis for the modernization program.
    Technologies: Spark, Python, Trifacta, Talend, Apache Impala, Apache Hive, HDFS, Big Data, Cloudera, Redshift, AWS S3
  • EDW Architect

    2015 - PRESENT
    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 EDW team to implement solutions.
    Technologies: AIX, Oracle, Informatica
  • Business Intelligence and Analytics Architect

    2013 - 2015
    NBC Universal
    • Led the team for integration of different systems to a big data (Pivotal HD) environment and sourced data from HDFS to the data warehouse for 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.
    Technologies: Tableau, Big Data, Apache HAWQ, Apache Hive, Hadoop, MicroStrategy, Informatica, Teradata
  • ETL Architect

    2011 - 2013
    Union Bank
    • Analyzed requirements and impact.
    • Designed databases and ETL.
    • Reported regularly on project status.
    Technologies: Informatica, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Hyperion, Oracle 9i
  • EDW Architect

    2010 - 2011
    GE Healthcare
    • Built business user interactions.
    • Conducted requirements and impact analyses.
    • Designed databases and ETL.
    • Documented processes and reviewed code.
    Technologies: BusinessObjects, Cognos ReportNet, Teradata, Solaris, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Informatica
  • Technical Project Manager

    2009 - 2010
    GE Aviation
    • Led the implementation of the Proactive Fleet Management project.
    Technologies: Cognos ReportNet, Teradata, Solaris, Informatica
  • ETL Lead

    2004 - 2009
    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.
    Technologies: Informatica, Teradata, Oracle, Windows, Solaris


  • Technology Architect (Development)

    Bayer Pharmaceuticals data warehouse modernization program where the existing on-premises data warehouse and reporting solution is being migrated to AWS Cloud and Cloudera big data infrastructure for shorter time to market. The modernized data warehouse will also provide support for existing BI and operational reporting as well as better data science and analytical capabilities.

  • First Hawaiian Bank - EDW (Development)

    System integration with Oracle Data Warehouse and reporting solutions implemented to automate management and regulatory reporting which includes CCAR, IHC, and call reports.

  • NBC Universal Advertising Sales and Analytics Technology (Development)

    Analytics Technology: Integrated different systems to the big data (Pivotal HD) environment and sourced data from HDFS to the data warehouse for BI reporting to meet the growing need for extracting value from data assets.

    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 (Development)

    Implemented a centralized, automated financial reporting platform for the regulatory, S.E.C., BTMU, and D.E.C. reporting groups that improved accuracy, processing time, and audit ability, reduced risk by improving reporting controls, quality, and transparency, and effectively enabled future state reporting under IFRS and integration of acquisitions.

  • GE Healthcare - BI COE (Development)

    Architecture for data integration and reporting for GE Healthcare's business intelligence solution, one of world’s largest warehouses running on Teradata. It is supporting a more than 175 source system which includes CRM, ERP, and legacy systems.

  • GE Aviation - Proactive Fleet Management (Development)

    Proactive Fleet Management was developed to give insight of customer fleet maintenance, events, and utilization for GE Aviation fleet data 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 (Development)

    Service Statement Invoicing: Service statements for customers was generated on a monthly interval, which included invoices for contracts, hourly billed service, OSM, and back bills and credits both at the line-item level and individual invoice detail level.

    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.


  • Languages

    SQL, Snowflake, Java, Python
  • Frameworks

    AWS EMR, Apache Spark, Spark, Hadoop
  • Tools

    Tableau, Cloudera, Spark SQL, Matillion ETL for Redshift, CVS, Apache HAWQ, Hyperion, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Cognos ReportNet, Apache Impala
  • Paradigms

    ETL, Business Intelligence (BI), Agile
  • Platforms

    Oracle, AWS EC2, Windows, Mac OS, Unix, AIX, Solaris, Talend, Linux
  • Storage

    Teradata, Redshift, AWS S3, Apache Hive, HDFS, Oracle 9i
  • Other

    Data Warehousing, Data Architecture, Informatica, Data Warehouse Design, MicroStrategy, Big Data, BusinessObjects, Trifacta
  • Libraries/APIs

    Spark Streaming


  • Bachelor's degree in Computer Engineering
    1998 - 2002
    Vinoba Bhave University - Hazaribagh, India


  • AWS Certified Solution Architect - Associate
    NOVEMBER 2019 - NOVEMBER 2022
    Amazon Web Services (AWS)

To view more profiles

Join Toptal
Share it with others