We provide IT Staff Augmentation Services!

Azure Data Architect Resume

0/5 (Submit Your Rating)

SUMMARY

  • Azure Data Architect Professional with 14 years of Technical experience in Data warehousing, ETL and Business Intelligence Applications like Informatica, ODI, Azure Data Factory, Databricks, Datalake, Delta Lake, Snowflake, OBIEE, OACS, ADW, DAC, SQL, PL - SQL, Siebel Analytics, BI Publisher, Tableau, Power BI, APCC.
  • Functional and technical knowledge of design and development of robust and scalable Business Intelligence solutions for Manufacturing, Finance, Supply Chain, Procurement & Spend, HR Analytics, Retail and Telecom Domains.
  • Demonstrated excellence in leading enterprise-wide BI effort with accountability of working as BI Architect within BI Practice and involved in vendor qualification, architecture/design, installation, configuration, migration & documentation
  • Experience in working and executing Data Integration and Migration projects.
  • Extensive experience of working with Clients and Business users during project lifecycle including Requirement gathering and User Acceptance Testing.
  • Good experience in Azure platform - Azure Data Factory (ADF), Data Lake, Synapse Analytics, Storage Options, Azure Databricks, PySpark.
  • Created workflows in Logic Apps to send email notifications from ADF and Synapse Analytics.
  • Experience with Azure Data Factory (ADF)/Synapse Analytics for creating linked services, pipelines, data sets, data flows, triggers and activities etc.,
  • Extensive experience in Data Ingestion, Data Governance frameworks.
  • Experience Handling Multiple team’s w.r.to ETL and Reporting technologies and closely work with Scrum Master and Business Analyst in Agile methodologies and Delivery Management.
  • Excellent Knowledge working within Business Intelligence domain via Data Modelling, Customization and Enhancements of BI solutions as per Customer need, Performance Optimization of ETL executions, Visualization and Reporting Analytics design as per Customer Expectations.
  • Positive attitude working with/along the team, Mentoring, Inspiring and providing Guidance and get them to consistently perform at a very high level and realize their full potential.
  • Involved and Volunteered in Practice Contributions in the form identifying the right people as per Practice restructuring, Publish Case studies for BI proposals, Lead Innovation initiatives to Demonstrate Practice Competency
  • Involved in end-end testing (Unit testing, System testing and Business Users Acceptance testing)
  • OBIEE 11g Certified Professional
  • Expert in delivering the technical trainings to users.
  • Attended Mule Soft trainings to enhance my skill set

Areas of Expertise

  • Development and Management of Large-scale Data warehouse and Business Intelligence Systems
  • Gathering Business User Requirements
  • Design and Data Modelling
  • Data Governance
  • Team Management and Mentoring juniors
  • Project Management
  • Strategic Planning
  • Business Process Improvement

TECHNICAL SKILLS

Azure: Data Factory, Synapse Analytics, Logic Apps, Key Vaults, Data Lake Gen2, DevOps, Azure Databricks

Apache Spark: Spark Core, Data Frames, Spark SQL, PySpark

BI Tools: OBIEE 10.X/11.X/12C, BI Publisher

Visualization Tools: Tableau 7.0/8/0/8.1, Power BI

BI Apps: BIAPPS 7.9.X, BIAPPS 10.X

Planning: APCC, LOGILITY

ELT Tool: Oracle Data Integrator (ODI) 10.x/11.x, Adaplink

ETL Tool: Informatica 8.X/9.X

Databases: Oracle 10g/9i/8i/12c, SQL Server, Snowflake

Database Client: SQL Developer, SQL*Plus, Toad

Source Application: Oracle E-Business Suite, Siebel CRM modules

Scripting: Shell Scripting

Operating Systems: UNIX, Windows Family

Programming Languages: C, PL/SQL, Python

Oracle ADW: Oracle Cloud & Autonomous Data warehouse

PROFESSIONAL EXPERIENCE

Confidential

Azure Data Architect

Responsibilities:

  • Environment/Technologies Worked: Azure Cloud- Azure Data bricks, Azure Synapse Analytics, Azure Databricks, Azure Storage (BLOB Storage), GitHub
  • Migrated existing data warehouse from Oracle/SQL Server to Azure Synapse DW and perform ETL operations.
  • Translate business requirements into technical requirements for implementation.
  • Understand data from different subject areas and implement business logic based on user stories.
  • Utilize Azure services for best design, performance and cost-effective solutions.
  • Created pipelines to extract data from multiple sources like EBS, OTM, Logility, SQL Server, REST API, Service Cloud, Flat Files, JSON Files, Data Lake etc.,
  • Created Pipelines to load data into Synapse DW, Data Lake etc.,
  • Created automated workflows with the help of triggers.
  • Worked on provisioning dedicated SQL Pool, Spark Pool.
  • Setup DevOps GIT in data factory.
  • Created release pipelines in Azure DevOps for CI/CD.
  • Resolve production issues.
  • Effective documentation for design, development and testing.
  • Extensively worked on Azure Databricks developed data pipelines post transforming data sourced from Azure EventHub (Sensor Data) from Control systems of refinery.
  • Extensively worked on Azure Synapse analytics used & Spark cluster for processing data.
  • Developed/designed schedule plan using Azure Data Factory (ADF).
  • Created Delta Lake from the landing zone.
  • Used Azure Tables for building low latency systems.
  • Worked on Invoking Databricks notebook to get the Data Science models outputs using REST API to publish in Power BI dashboard.

Confidential

Data Architect

Responsibilities:

  • Worked on Azure Data Factory in creating pipelines from ADLS for any raw data format
  • Extensively used Python Spark module (PySpark) to retrofit the ETL/ELT code into the server less platform, thereby achieving higher scalability & performance.
  • Created Big query external tables from the files Viz Avro, Parquet, ORC, XML, JSON, CSV formats created post Spark processing.

Confidential

Senior Azure Data Engineer

Responsibilities:

  • As part of Global ERP Program, we have implemented Financials, Supply Chain and Order Management, Procurement Spend, Planning
  • Involved in requirement gathering for new requirements and enhancements to existing requirements
  • Involved in tuning lot of jobs both OOTB and Custom and reduced 20 hrs of Incremental load to 8 hrs.
  • This is the major win on performance tuning reducing the incremental load time
  • We have tuned SDE, SIL and PLP including OOTB and Custom design
  • Implemented Data Level and Object Level security to safeguard the reports ADW and Golden Gate Replication
  • We are planning to implement golden gate for replicating data in ADW(Autonomous Data Warehouse) following necessary design standards
  • Maintaining a team offshore, gather new requirements and share across the team
  • Daily interaction with team to ensure deliverables are met on time
  • Responsible in supporting production activities on priority

Confidential

Technical Specialist

Responsibilities:

  • Responsible for implementing Enterprise Data Warehouse Solution for Financials, HR and Procurement and Spend modules using BI Applications using EBS as source system
  • Configured all the required retail parameters as per retail source

Confidential

Principal Consultant

Responsibilities:

  • Responsible for implementing Enterprise Data Warehouse Solution for Order Management, Manufacturing modules using BI Applications
  • Implemented OOB and Custom Data warehouse Solution for HR Analytics implementation with Oracle BI Applications
  • Travelled to Johannesburg, South Africa for requirement gathering, phase1 for DR remediation process, phase 2 implementation for upgrading the current BI Applications
  • Worked as Informatica and OBIEE developer for Custom Enterprise Data Warehouse Solution
  • Worked on gathering new requirements with client and delivered custom reports
  • Implemented Oracle Demand Signal Repository(DSR) with custom OWB Mappings and OBIEE Reports
  • Worked for upgrading OBIEE 10g to OBIEE 11g and worked on implementing new requirements

Confidential

Trainee Engineer

Responsibilities:

  • Worked for migrating reports from Cognos reporting to OBIEE Reporting and BI Publisher Reports
  • As a junior developer responsible for writing SQL queries
  • Responsible for creating monthly reports and built custom ETL solutions using plsql.

We'd love your feedback!