Team Lead of small team of developers as an ETL BI Solutions Architect for a staging database to result into a full Data Warehouse solution.Overseeing the automation design and architect of the solution to transform data into a staging area from MySQL server into a SQL Server database as the SME to accomplish the task.In charge of designing the system process to get meta data structures from both source database and destination database, capturing changes in data types and column changes, transforming the data with a transformation lookup to ensure no data loss.Full understanding of MySQL data Types and SQL Server Data Types and how they converted back and forth between systems to create the lookup table process and SSIS packages to handle the task.Created C#.NET Script tasks in SSIS.In charge of creating user tasks for junior and mid-level developers, code reviews and testing and QA.Handled complete architecture of the overall design, documentations including Visio road maps, ETL Design, database staging table design, stored procedure requirements and validations and creation, naming conventions, and testing of final proof of concept to promote to production with SOP’s for modification process to live system and full lifecycle process for the ELT solution.Developmental work in SSIS for both proof of concept and final modifications of application data transformation process. In charge of change control and release scheduling, project deadline goal planning and overseeing the goals are met in a timely fashion and on schedule. Creation of T-SQL triggers for auditing. Also planned SSRS reports and MDX Queries for Data Warehouse analytics for the company dashboards, and reports based off user request, to show the company how well the business is doing and if realized company goals were being met.

Skillsets used : SQL Server 2012 & 2014, SQL Reporting Services 2014 (SSRS), Visual Studio 2015, SQL Server Data Tools Business Intelligence 2014 (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), C#.NET, MySQL and MS Team Foundation Services (TFS).

Lead on migration of data from current outdated system to new mapping of Government accident system using SQL script and SSIS packages. Also migration of second product of web based system backend for public viewing of accidents. SSRS Reporting and stored Procs. Query tuning and database troubleshooting. Correspondents to the White House and US Government for Accident data and safety recommendations.

Skillsets used : SQL Server 2012 & 2014, SQL Reporting Services 2014 (SSRS), Visual Studio 2015, SQL Server Data Tools Business Intelligence 2014 (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), C#.NET, MySQL and MS Team Foundation Services (TFS).

Developed, enhanced, tested and debug database systems in SQL Server 2005/2008/2012/2014, including stored procedures, functions, T-SQL triggers and database backups. Developed Web Services class in Visual Studio and created ASP.NET Pages to use the Web Services for providing things like defining which database to connect to for local development, QA, and Production. Created and modified databases and tables in SQL Server on various versions for multiple server databases. Created Linked databases for MySQL database to SQL Server for data access. Maintained database security, adding new users with specific database and table accesses. Troubleshoot existing MS Dynamics processes and creating reports from Dynamics database system for upper management in SSRS. Maintained high level of documentation for all work done. Created auditing tables and scripts to capture data processes for reporting. Created and modified SSRS reports in 2005, 2008 and 2012 versions of SSRS. Developed high level job processes to ease daily work for coworkers in SQL server jobs and automation to pull data from MySQL and Oracle 10g. Defined database specifications and requirements as per customers’ requirements. Created proof concepts for ideas and then implemented them into daily requirements as they meet and exceeded the workplace requirements. Mentored other programmers in application design and concepts, training on new software ideas that have been proven to work and database concepts. UsediDirect and iModem Satellite software and learned the database backend for data transformations into SQL Server. Accessed Great Plains 10.0 Data from the backend to use in various reports and to populate an ERP system for matching data.Learned backend database of SolarWinds network monitoring software and MS Dynamics CRM to add data to data warehouse for match up validations of un-relational database systems. Application development in Alert Software by Fieldpoint both front and backend to adhere to workplace workflow requirements as per user specifications and troubleshooting issues in ASP.NET and C#.NET. On call lead for Alert systems software issues and ERP data issues. Created SSIS Packages to migrate data into multiple database systems.On call for database issues and general administration. Developed new applications for satellite communications network in C#.NET and ASP.NET and maintained existing applications in VB.NET and C#.NET. Minor exposure to Linux, MapReduce, RabbitMQand Amazon AWS. Used RedGate and Altova to compare database differences and make changes between Development, QA and Production database systems. Migrated MySQL, Oracle, SQL Server, and flat files into data warehouse for daily analysis and reporting to upper management. Provided data mining for upper management using power pivot for management to make business decisions.

Worked on many various projects, Please follow link