Data Architect Resume
Software Architect Software, DesigneR
SUMMARY:
- Confidential is an accomplished Software Architect, Software Designer, and Developer specializing in Microsoft SQL Server Technologies. With a background in Object - Oriented design and development specializing in the .NET framework and Windows-based server software, Mr. Confidential has worked extensively in designing, developing, and implementing software packages for financial and sales systems. Mr. Confidential has the technical expertise and background to lead the development effort for .NET projects with SQL Server. He has extensive experience in the product lifecycle, including project planning, requirements gathering, architecture, design, and development. Mr. Confidential has expertise in understanding the client's reporting needs and developing reporting models in Ad-hoc Reporting and OLAP/OLTP using various technologies, including SQL Server Reporting Services and Power BI.
- Confidential has a proven ability to lead and mentor developers in complex projects, from initial requirements gathering through testing to final product delivery. He has proven his ability to translate complex business processes into technical products, and navigate the business's required documentation and release procedures, leading to successful solution delivery. Mr. Confidential is a dedicated worker who cares deeply about his client’s success and can deliver quality work under a tight schedule.
- Mr. Confidential is a certified SQL Server 2012 Database Developer.
TECHNICAL SKILLS:
Technology and Tools: C# SQL Server LINQ Business Objects Crystal Reports Power BI ASP.NET JavaScript XML SharePoint .NET Framework RDBMS Azure SQL SSRS Web Services (SOAP, REST) Azure Data Factory Power Automate Azure Functions SQL Server Analysis Services SQL Server Integration Services (SSIS) Microsoft Dynamics GP Dynamics GP eConnect Nintex Workflow Telerik Dynamics 365 Power Apps Azure DevOps (Agile)
PROFESSIONAL EXPERIENCE:
Confidential
Data Architect
Responsibilities:
- Created database objects - tables, views, stored procedures, functions, etc.
- Responsibilities include but are not limited to developing, testing, staging, and releasing business applications and supporting data structures using DevOps Agile methodology and a frequent release cycle.
- Maintenance activities include monitoring data feeds and ETL processes and addressing data feed anomalies and data errors in the databases.
Confidential
Data Architect
Responsibilities:
- Developed and managed Azure Data Factory pipelines to integrate data between The National Electronic Disease Surveillance System Base System (NBS) and Confidential contract tracing portal based on Dynamics 365.
- Developed and managed Power Apps dataflow to integrate data between The National Electronic Disease Surveillance System Base System (NBS) and Confidential contract tracing portal based on Dynamics 365.
- Designed and managed a Contact tracing SQL Azure database to consolidate data from NBS and Confidential call centers into one centralized database to generate Power BI reports for decision-makers at Confidential .
- Assisted the Power BI team in developing Reports and dashboards.
- Developed and managed Power Automate flows to monitor and notify end users of critical system issues.
Confidential, CT
Responsibilities:
- Designed and developed a new 'MarketPortal' database to consolidate various data sources into one centralized database to generate reports for Markets, Stores, and Headquarters.
- Designed and developed SSIS packages to extract, transfer and load data from various data sources, including customer portal database, SUBS market database, Receivables application, and Dynamics GP ERP application.
- Designed and developed HQ internal reports to reconcile Account Receivables, Account Payables with General Ledger.
- Developed SQL queries for the initial data load into the new 'MarketPortal' database.
- Designed and Developed Pivot Table reports for HQ Admins to view ledger details with drill-down.
Confidential, CT
Responsibilities:
- Designed and managed Subway Account Payables (AP Workflow) Approval Workflow web application.
- Helps Subway manage invoice submissions from various vendors, Advertising agencies, and local administrators.
- The system allows submitters to initiate the submission of invoices for review and upload one or more files with their submission.
- The system-generated review parallel & sequential workflow tasks are assigned to appropriate reviewers (per workflow diagrams) based on the selected brand, region, project and/or market.
- It allows reviewers to add comments, which can be viewed by the Submitter, all reviewers, and anyone else with access to that record.
- It also allows reviewers to escalate the task to other reviewers.
- A windows task is created with an executable console windows application. The windows application calls eConnect functions to generate AP Transaction entries in Microsoft Dynamics GP in more than 15 GP Companies.
- The solution is developed with Reporting capabilities to send notifications to Approvers on a timely basis.
- Stored procedures are created with XML parameters to insert and update bulk data from UI grids.
Confidential, CT
Responsibilities:
- Designed and managed Subway Advertising Review Board (ARB) Approval Workflow SharePoint Custom Application.
- Helps Subway manage submissions from various Advertising agencies and local market administrators.
- The system allows submitters to initiate the submission of files for review and upload one or more files with their submission.
- The system-generated review tasks are assigned to appropriate reviewers (per workflow diagrams) based on the selected brand, region and/or market.
- It allows reviewers to add comments, which can be viewed by the Submitter, all reviewers, and anyone else with access to that record.
- The solution is developed with Reporting capabilities to send notifications to Approvers on a timely basis.
- Power BI reports are developed for HQ users to compare consolidated submissions from advertising agencies and workflow approvers’ efficiency with KPIs.
Confidential CT
Responsibilities:
- Designed and managed Subway Great Plains (GP) Import tool: GP Import tool can be used to download data from various sources into Microsoft Dynamics GP.
- GP Import library uses JSON to convert data from GP Import Tool.
- GP Import tool helps Subway to rapidly integrate their financial sources with Microsoft GP and better manage their financial processes.
- GP Import tool is flexible and allows data from various sources to be easily imported into Microsoft Dynamics GP. The sources include Excel, CSV, TAB delimited formats, and ODBC.
- GP Import Tool can import data from a single source file into more than one GP company.
- GP Import Tool allows mapping of sources into the GP database with options to set default and calculated values.
- GP Import Tool allows administrators to customize and import desired information. GP Import tool allows users to run their SQL stored procedure before and/or after the transaction.
- GP Import Tool allows easy integration of financial transactions with Microsoft Dynamics GP
Confidential, Washington DC
Responsibilities:
- Analyzed data from different sources (like Excel, MS Access, SharePoint list, and SQL Tables), and converted them into a single centralized SQL Server database
- Designed and developed migration scripts and SSIS package to migrate data from different sources into SQL Server database.
- Designed and developed Project Management Tool Version 2.0/3.0 in ASP.NET.
- Developed Silverlight-based Reporting dashboard with maps and charts.
- Designed, developed, and deployed the Young Scholar Program (ILP) SharePoint application.
- Designed and migrated 60 SharePoint lists with SharePoint object model-based windows application.
- Designed and developed a Custom SharePoint web page with 20 tabs and hierarchical grids to enter data efficiently.
- Designed and developed SharePoint event handlers to enforce business rules.
- Designed and developed SQL tables, views, and stored procedures and functions in SQL Server 2008.
- Modified and tested C# based web services to be used as an integration platform between Salesforce and Softrax.
- Modified and tested Customized Reports written in Crystal Reports.
- Designed and developed a reporting module to generate SQL reports (SSRS) and CSV files.
- Modified and tested Cast Iron Orchestrations.
- Modified and tested SSIS packages.
Confidential
Responsibilities:
- Designed and developed a SharePoint site to gather information from different sources.
- Designed and developed a Custom SharePoint page to create a better end-user experience on the SharePoint site.
- Designed and developed SQL stored procedures and functions to generate SQL views for SharePoint lists in SQL Server 2008.
- Designed and developed SharePoint Event Handlers in C# 2005 with back-end SQL query to extract SharePoint data directly in SQL views.
- Designed workflows to allow administrators to manage the changes in the SharePoint site.
Confidential, Confidential CT
Responsibilities:
- Designed the SharePoint custom application.
- This module allows SFAFT to manage online requisitions for the marketing department.
- The system allows users to generate requisition in SharePoint 2007 environment with a customized AJAX-enabled user interface.
- The system uses native SharePoint lists with custom webpart, Windows Communication Framework, and Nintex workflow. Technologies used were SharePoint MOSS 2007, C# 2005, SQL Server 2005, Nintex Workflow 2007, Microsoft Dynamics GP, Windows Communication Foundation (WCF), and Visio 2007.
Confidential, Confidential CT
Responsibilities:
- Designed the SharePoint-based data warehouse application and reporting subsystem. 200 old reports were consolidated into a single OLAP cube in SSAS with four different measure groups and mapped Old COA (Chart of Accounts) to New COA with different dimension groups.
- Responsibilities include designing and developing all related SQL tables, views, and stored procedures in SQL Server 2005, developing base SSRS reports run using different parameters, and presenting 200 variations of 5 base reports. Deployed SSRS reports in SharePoint 2007 with integrated security.
- Involved in the design and development of SharePoint web part in C# 2005 with AJAX-based Custom Control to give an enhanced user interface, Web Services to generate custom SSRS reports and attach them to SharePoint list item and SharePoint workflows with Nintex Workflow 2007 to go through multiple levels of approval on 2 different SharePoint lists (Header-Detail).
- Designed workflows that call web services to post Purchase Order entries into Microsoft Dynamics GP. The technologies used were SSAS 2005, SSRS 2005, SharePoint 2007, C# 2005, SQL Server 2005, SSIS 2005, Visio 2007, and Microsoft Dynamics GP.
Confidential, VA
Responsibilities:
- Responsible for generating a billion-record database with all possible SSNs with unique random client IDs and encrypted SSNs.
- Responsible for generating SQL scripts to update Dynamics GP SQL database with new client IDs. Technologies used were C# 2005, SQL Server 2005, and Microsoft Dynamics GP.
Confidential, Washington DC
Responsibilities:
- Designed, developed, and implemented the C#.net-based windows system. The system allows users to enter Budget data in a tree structure format in Microsoft Dynamics GP.
- The system gets the input at the bottom of the tree structure and rolls up the budget automatically to generate the complete Budget Tree in a complex database structure.
- The system allows users to update the tree's child level dimension, and the amounts will automatically roll up to the parent level dimension and up to the highest level of the tree.
- Technologies used were C#, Crystal Reports 9, SQL Server 2000, Microsoft Dynamics GP, and Infragistics Ultrasuite.eSportsmanager
- Developed to accommodate the business practices and procedures of community sports organizations.
- The system comprises two web registration modules - one for parents and players and one for field information to be accessed by coaches, assistant coaches, and managers - and an administrative windows application based on an extensive database.
- Responsibilities for these various projects include gathering user requirements and designing and coding the applications.
- Technologies used were C# 2003, ASP.NET, Crystal Reports 9, SQL Server 2000, Great Plains, and Infragistics Ultrasuite.
Confidential, VA
Responsibilities:
- Designed C#.net-based application with SQL Server backend. Responsibilities included gathering user requirements and designing applications, and coding the applications.
- The projects allow AER to manage their donation and pledge data and integrate it into the Great Plains.
- The system allows users to enter donation and pledge data, donor information, and Import gift, pledge, and donor data from AER Sections.
- It also allows users to manage monthly repayments of pledges from ACH data from DFAS.
- Technologies used were C# 2003, Crystal Reports 9, SQL Server 2000, Microsoft Dynamics GP, and Infragistics Ultrasuite.
Confidential, VA
Responsibilities:
- This system handles Loan Management tasks for Army Emergency Relief (AER) employees.
- The system handles al loans and other assistance loans. It takes Loan or Grant information from sections across the world.
- It Imports all the data into SQL Server and displays the details to the user at Headquarters.
- The user can modify the details and post all loan details to Great Plains Dynamics' accounting software.
- The Accounting Software Great Plains Dynamics is customized for Army's specific requirements.
- The system also handles Bankruptcy, Recurring Widow Grant payments, and other assistance loans.
- Responsibilities included designing and developing the application, creating DTS Packages in SQL Server and Reports and OLAP cubes in MS Analysis Server for Management Reporting.