We provide IT Staff Augmentation Services!

Database Architect Resume

SUMMARY

  • Database architect and senior engineer specialising in data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake, Databricks, Data Lake Analytics, Azure Synapse, Logic Apps and Microsoft SQL Server business intelligence stack.
  • Extensive experience in large Database design and data Modeling .
  • Extensive experience in SQL Server query tuning, optimization, and development .
  • Experience in Microsoft Azure Cloud Platform (Azure Data Factory), AAS, Azure Data Lake store, Azure DWH, PowerBI etc.).
  • 3+ year of experience in Azure cloud platform.
  • Having 8+ year of experience in MSBI stack (SSRS, SSIS and SSAS - Tabular Model )
  • 3+ year of experience in Power BI
  • Extensive experience in data warehouse designing .
  • Having experience in creating and modifying cube in Tabular model.
  • Currently apart from design & development, Also responsible for activities like effort estimation, resource performance review etc.

TECHNICAL SKILLS

Databases: SQL Server 2005 to SQL Server 2019

Azure Cloud Platform: Azure, Microsoft SQL Azure, Data Lake Storage, Azure Data Lake Storage Gen2, Azure Data Factory, Azure Data Analytics, Azure Synapse(Azure Data Warehouse), Azure Analysis Services, Azure Logic App

Database Tracing/Utility Tools: Import/Export, SQL Jobs, SQL Profiler, Extended Events

Integrated Development Env. (IDE): SQL Server Management Studio 18.0 (SSMS), Visual Studio 2017

Extract Transfer Load (ETL) Tools: SQL Server Integration Services (SSIS)

Reporting Tools/Data Visualization: Power BI

DB Modeling Tools: DBeaver, SAP Power Designer, MS Visio

Application Development: .Net

Scripting Language: PowerShell

Source Code Management: MS Team Foundation Server (MS - TFS)

Methodologies: Agile/Scrum

PROFESSIONAL EXPERIENCE

Confidential

Database Architect

Responsibilities:

  • Direct customer engagement
  • Database Design for the entire project from scratch. The project consists of 8 large modules.
  • Data Migration using SQL Scripts and SSIS Packages from multiple legacy systems (SQL 2000, SQL 2014, Csv’s, Excel’s, JSON’s) to new database solution (SQL Server 2017).
  • ETL performance optimization, monitoring and logging of ETL jobs.
  • Complex database development - Stored procedures creation, batch jobs, Query tuning & Performance optimization etc.
  • Creating large scale reports using SSRS.
  • Executive level reporting using PowerBI.
  • Complex Troubleshooting, Problem Identification and Root cause analysis
  • Define/Maintain database coding practices, guidelines & review checklist
  • Create/Update, review and maintain both high and low-level design database documents
  • Development team supervision and Code Reviews
  • Sprint planning and Deployment activities

Confidential

Senior Data Engineer

Responsibilities:

  • Migration from existing operational systems (Sales, Financials, pay labor and Time, Merchandize, Warehouse) to the new system in Azure Cloud. This step had around 1800 data dynamic pipelines.
  • Worked on various type of data sources i.e. structured, unstructured data and API endpoints (XML and JSON).
  • ETL performance, monitoring and logging of ETL jobs.
  • Built Data Analytics, Enterprise ready and advance Reporting Solution using Power BI using Modern data warehouse architecture.
  • Reporting Dashboard - Power BI
  • Automating manual tasks by PowerShell and Python.
  • NumPy and Pandas has been used to process the excel files and store in Azure SQL DWH.
  • Worked with various business stakeholders and internal teams to align the materialization of business requirements into Data Model, ETL and semantic layer for report design.
  • Stored procedures creation, Query tuning & Performance optimization etc.
  • Development team supervision and Code Reviews
  • Sprint planning

Confidential

Senior Data Engineer

Responsibilities:

  • Understand & analyze existing BI landscape and operational challenges
  • Proposed a BI architecture & a roadmap to cater to customer's current & future reporting requirements.
  • Worked with the business analysts to finalize the functional requirements
  • Design and Develop a Unified portal for all reporting using Power BI.
  • Central repository with historical data, Self-service BI, and Accessibility of report on mobile, tablets etc.
  • Created SSRS reports (Pooling Engine Report, Rate Card Report per Partner)
  • Development team supervision and Code Reviews
  • Sprint planning

Hire Now