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




Jersey City, NJ, United States



Preferred Environment

Win, Mac OS, Unix (AIX/Sun Solaris), Linux, CVS

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: AWS S3, AWS Redshift, Cloudera Big Data Distribution (HDFS, Hive, Impala), Redshift, Talend, Waterline Data, Trifacta, Python, Spark
  • 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: Informatica, Oracle, AIX
  • 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: Informatica 8.x, Teradata, MicroStrategy 9.3, Pivotal HD Big Data Ecosystem (Hadoop, Hive, Hawq), Tableau 8.1
  • ETL Architect

    2011 - 2013
    Union Bank
    • Analyzed requirements and impact.
    • Designed databases and ETL.
    • Reported regularly on project status.
    Technologies: Informatica 8.x, Oracle 9i, Hyperion, OBIEE
  • 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: Informatica 8.x, Teradata V2R5, Cognos Report net, BO XI, OBIEE, Sun Solaris
  • Technical Project Manager

    2009 - 2010
    GE Aviation
    • Led the implementation of the Proactive Fleet Management project.
    Technologies: Informatica 8.x, Teradata V2R5, Cognos Report Net, Sun Solaris
  • 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: Solaris 5.8, Win 2k, Oracle 8i, TeraData V2R12, Informatica PC 8.1


  • 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, Hadoop
  • Tools

    Tableau, Cloudera, Spark SQL, Matillion ETL for Redshift
  • Paradigms

    ETL, Business Intelligence (BI), Agile
  • Platforms

    Oracle, AWS EC2, Linux
  • Storage

    Teradata, Redshift, AWS S3, Apache Hive, HDFS
  • Other

    Data Warehousing, Data Architecture, Informatica, Data Warehouse Design, Data Warehouse
  • 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