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