Azure Architect Resume
Bellevue, WA
SUMMARY:
Proven record of success orchestrating and delivering large - scale development projects.Solutions-oriented professional with extensive experience leading design, development, and implementation of enterprise software and database solutions supporting complex business needs. Provide focused leadership and direction to teams of on-site and globally dispersed resources. Expertise across corporate finance, sales & services, and supply chain management, including developing robust business intelligence and analytics solutions to support data-driven decision-making. Fluent in English and Tamil.
AREA OF EXPERTISE:
- DB Design/Development
- BI Analytics / Reporting
- Cloud-based Solutions
- Global Team Leadership
- ERP Solutions Development
- Master Data Management
- Strategic Project Planning
- Requirements Alignment
- Expectation Management
TECHNICAL SKILLS:
- Data Architecture
- Microsoft SQL Server
- Microsoft SQL Azure DB
- Azure Data Factory
- Azure SQL Data Warehouse
- Azure Data Lake
- T-SQL
- C#
PROFESSIONAL EXPERIENCE:
Confidential, Bellevue, WA
AZURE ARCHITECT
Responsibilities:
- Microsoft SQL Azure Database and ADF Services: Set up the Azure Infrastructure for this Data Warehouse project. Performed System Analysis, designed and implemented the next generation of Worldwide Payment Solutions Data Warehouse with the help of the remote development team. Leveraged the Azure Data Lake for storing external data sources files received from Banks. Integrated data from internal relational data sources and as well as the Data Lake. ADF pipelines were used for Data Movement and Orchestration. Also, designed and developed a Metadata driven Test Framework for Quality Assurance purposes. Business users were able to develop their own Power BI Reports from this reporting database built.
Confidential, Redmond, WA
SENIOR SOLUTIONS ARCHITECT and BI Architect
Responsibilities:
- Microsoft SQL Azure Data Services: Integrated a few metrics of SQL Azure Data Services for Microsoft in their SQL Azure Data Warehouse.
- Salesforce and Azure SQL Data Warehouse integration: Responsible for development of Azure SQL Data Warehouse for integrating the Blackbaud’s Salesforce data for Opportunity management and on-premises SQL Server data.
- Oracle and Azure SQL Data Warehouse integration: Responsible for development of Azure SQL Data Warehouse for integrating Lipman Produce’s Sales data from Oracle Data Warehouse
- Environment: Microsoft Azure SQL Data Warehouse, Azure Data Factory, Salesforce, Oracle.
Confidential, Redmond, WA
BI Architect
Responsibilities:
- Supply Chain Management Operations: Contributed to development of BI System for Retail Stock to monitor inventory and calculate stock-out percentages by store, location, and product for 30+ dimensions.
- Liaised with program managers for requirements gathering and project planning.
- Designed and developed databases, dimensional data modeling, SSAS cube enabling side-by-side comparison of forecasts, budgets, sales, and inventory metrics.
- Environment: Microsoft SQL Server, SSAS, Microsoft SQL Azure.
Confidential, Redmond, WA
Database Architect & Development Lead
Responsibilities:
- BI Engineering Team, Enterprise Data Warehouse (EDW): One of four-member team tasked with defining EDW standards and guidelines to build centralized, metadata-driven solution integrating common domain data used across the company.
- Owned EDW common database, designed metadata-driven data cleansing rules and deferred foreign key updates, and built database for enterprise and customer service scorecards based on user roles and geographically determined permissions. Managed on-site and off-shore team members.
- Tax Data Warehouse (TDW): Served as development lead directing off-shore team for data warehouse for all tax requirements, including 50+ sources for sales tax data and data-driven ETL, job scheduling, job chaining, and job dependencies / business rules. Designed metadata database for ETL platform to load sales tax data from companies acquired by Microsoft.
- Learning & Readiness Application (L&R): Designed and developed code for metadata-driven database backup and restore operations and third-party file transfers. Developed C# and T-SQL code.
- Served as development lead working with third-party team to coordinate data transfer; supervised off-shore developers.
- Microsoft Sales Ad-hoc Reporting Tool, Microsoft Reports Analytics (MSRA): Developed middle-tier code in C# for MSRA app manager, designed and developed database to house user preferences / requests, and wrote backend T-SQL code for UI and middle-tier.
- Microsoft Partner Programs, Resource Directory & DataMart: Worked on development of solution to store complex data related to partner programs based on detailed business rules.
- Managed multiple onsite and third-party development teams. Designed and developed database, invoicing & fulfillment system, and partner scoring model database. Wrote and performance tuned T-SQL code.