Scroll To View More
Bikas Anand

Bikas Anand

Jersey City, NJ, United States
Member since June 8, 2016
Bikas is a seasoned and expert developer with approximately 14 years of ETL and data warehouse implementation experience. He has worked on various projects with clients including GE Healthcare, GE Aviation, Union Bank, NBC Universal, and First Hawaiian Bank.
Bikas is now available for hire
Portfolio
Experience
  • SQL, 14 years
  • Informatica, 14 years
  • ETL, 14 years
  • Teradata, 10 years
  • Data Warehouse Design, 8 years
  • Oracle, 8 years
  • Cloudera, 2 years
  • Hadoop, 2 years
Jersey City, NJ, United States
Availability
Part-time
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.
Employment
  • 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
Experience
  • 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.

Skills
  • Languages
    SQL, Python, Java
  • Tools
    Tableau, Apache Sqoop, Cloudera, Spark SQL
  • Paradigms
    ETL, Agile
  • Platforms
    Oracle, AIX, Linux
  • Storage
    Teradata, HDFS, Apache Hive
  • Other
    Data Warehouse, Informatica, Data Architecture, Data Warehouse Design, Business Intelligence (BI), Technical Project Management
  • Frameworks
    Apache Spark, Hadoop
  • Libraries/APIs
    Spark Streaming
Education
  • Bachelor's degree in Computer Engineering
    1998 - 2002
    Vinoba Bhave University - Hazaribagh, India
I really like this profile
Share it with others