Lead Solution Architect Resume Example

DRAW (Data reporting and Analytics Warehouse): This is a centralized data warehouse built in MS-SQL Server. The central repository primary goal is to provide key stakeholders various Digital Campaign performance KPI's and performance metrics

• Architected the entire data warehouse solution from conception to reality.
• Migrated the entire SQL 2008 data warehouses into SQL 2012 and later to Azure SQL databases
• Used Kimball's methodology and design principles.
• Established Data Architecture guidelines and developed various custom data quality components which audit the quality of the data entering the warehouses.
• Clients served include Unilever, Facebook, GMI, KC and many other enterprise clients.
• Supported continuous process and performance improvement for manufacturing issues, robustness and compliance.
• Managed implementation of new technological improvements resulting in increased efficiency.
• Managed minimum of 5 projects each year while maintaining adherence to budget, schedule and scope requirements.
• Establishing SQL Standards and Review Process for the Data Team and also internal Technology Team
• Establishing plan and process for resolving defect backlogs by leveraging source safe tools like Team Foundation Server
• Mentored and developed a staff comprised of Senior Business Intelligence Developers, IT Summer Interns.

• Created various SSIS modules, SQL Store procs to populate the warehouse.
• Created DAX and VB scripts for calculated dimensions and Excel reporting.
• Used various SSIS Transformation routines like Lookup, Merge, Union, Conversion, Derived Column, Aggregations
• Developed various custom tools which support the DATA transfer and Data Processing from various flat files to central CRG system.
• Created store procedures in VBA Excel to retrieve data from Database and re-routed them to higher authorities for financial analysis.

• Gathered requirements from Doctors, Healthcare professionals and Financial Analysts for designing and providing effective solution for EHR Reporting project, which involved both Doctor & Patient Orders.
• Enhanced the Electronic Health Reporting (EHR) Reporting application wherein the new version integrated both the Doctors and the Patient Orders in a single report directly.
• Created various Functional Specification Documents for Outsourcing Department for identifying the sourcing agencies and Contractors.
• Enhanced the Stat Tax Information Reporting (STIR) application where the new version integrated both the web server and excel report directly.
• Created store procedures in VBA Excel to retrieve data from Oracle database and maintained Tax Report Generator (TRG) for the company.