Anoop Mishra

Data Engineer

Sydney, Australia

Experience

Technically Sound & Business Savvy Professional with 12+ years of rich and cross-cultural & functional expertise in Database Design, Data Architecture, Data Analytics, Data Integration, Data Migration, Data Warehouse, Software Development and Technology Consulting in Cloud( AWS/GCP), Oracle and SAP technologies.

Education

Master’s in computer application

Certificates

  • ICAgile Certified professional.
  • Oracle Cloud Infrastructure Architect Associate

Anoop Mishra

Data Engineer

Domains

Banking, Manufacturing, Supply chain, Resources, Telecom and Insurance.

Core Capabilities

Liaised with clients for requirement gathering, conducted workshop, system analysis and finalising technical / functional specifications along with high-level design documents (HDD) and Technical
design document (TD) for the project.
Capable of leading & motivating individuals to maximize levels of productivity; a customer-centric professional and knack for motivating large workforces for exceeding customer expectations in
delivery of committed services.
Responsible for deliverable, team handling, work allocation, Build, Code review and Unit testing.

Technical capabilities

  • Database Design, Development, Data Warehouse Concepts- Star schema, Snowflake, ETL (Extract, Transform and Load), Data Integration, Data Analytics and Data Migration.
  • In-depth knowledge of Query Tuning, SQL Trace, Profiling PL/SQL (DBMS_TRACE, DBMS_PROFILER, DBMS_HPROF) and AWR report
  • Familiar and worked in all phase of software development life cycle(SDLC).
  • Worked with different Software methodologies like Waterfall and Agile.
  • ICAgile Certified professional.

Technologies

Database: Oracle, SAP HANA, SQL Server, Teradata and Azure
Data Modeling: MS Visio, Toad & Erwin
Data Analytics/ Reporting: Power BI, Qlik sense, Tableau, Oracle BI Publisher & Oracle Reports
Language/Applications SQL, PL/SQL, T-SQL, XML, Python, Fiori, ABAP, HTML, Oracle Forms and JavaScript
Integration: Mulesoft
Big Data: Datastax Cassandra, Pivotal Greenplum, Pivotal HD (Haddoop, Hive, Sqoop etc)
Cloud: AWS IDM, S3, Redshift, Azure and GCP

Familiar with SAP functional module and respective tables:

SD  MM  FICO
 SAP IBP- Demand planning, Inventory Optimisation and Sales and Operations Planning

SAP HANA data Modeling:
 Familiar with Column store and SAP HANA SQL
 Created Attribute Views, Analytical View and Calculation views
 Created Calculation view using SQLScripts

Good hands-on experience on SAP HCI/CPI and done integration with SAP IBP, C4C, Salesforce and Ariba.

Recent Projects

Anoop led the reporting and analytics stream for Novo Nordisk, a strategic initiative to give the executives visibility to their data including cross-border orders, sales and service support.
Read Case Study