Azure Data Architect Resume
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.
