 Develop, optimize, and maintain advanced T-SQL queries, stored procedures, functions,and views for complex data manipulation and retrieval. Design and implement sophisticated data integration and ETL processes using SQLServer Integration Services (SSIS). Ensure optimal performance and efficiency of SQL queries and SSIS packages. Collaborate effectively with cross-functional teams to translate business needs intotechnical solutions. Conduct advanced database… Show more  Develop, optimize, and maintain advanced T-SQL queries, stored procedures, functions,and views for complex data manipulation and retrieval. Design and implement sophisticated data integration and ETL processes using SQLServer Integration Services (SSIS). Ensure optimal performance and efficiency of SQL queries and SSIS packages. Collaborate effectively with cross-functional teams to translate business needs intotechnical solutions. Conduct advanced database tuning and query optimization. Maintain comprehensive documentation for all database designs, coding, andmaintenance processes. Provide expert-level support and troubleshooting for SQL Server and SSIS-related issues. Stay abreast of the latest developments in SQL Server technologies and best practices. Show less

• Current SQL DBA Developer in the Healthcare industry.• Developing and changing existing ETL, in stored procedures, FTP and SSIS packages• Development work with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)• Database migration and upgrade engineer• Developing Dynamic SQL and stored procedures

Responsible for design of scalable MSSQL database architecture and implementation of design for a rapidly growing claims processing company. • Data Modeling for proposed and existing structures • Resource and performance analysis and planning/tuning • Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services using Spotlight. Responsible for testing of these plans. • Provide technical DB &… Show more Responsible for design of scalable MSSQL database architecture and implementation of design for a rapidly growing claims processing company. • Data Modeling for proposed and existing structures • Resource and performance analysis and planning/tuning • Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services using Spotlight. Responsible for testing of these plans. • Provide technical DB & Application support and guidance to the IT staff • Ensure Backup, Recover & Business Continuance for DB & Applications Show less

Responsible for design of scalable MySQL database architecture and implementation of design for a rapidly growing healthcare company in an opensource environment.• Data Modeling for proposed and existing structures• Resource and performance analysis and planning/tuning• Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services using Spotlight. Responsible for testing of these… Show more Responsible for design of scalable MySQL database architecture and implementation of design for a rapidly growing healthcare company in an opensource environment.• Data Modeling for proposed and existing structures• Resource and performance analysis and planning/tuning• Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services using Spotlight. Responsible for testing of these plans.• Provide technical DB & Application support and guidance to the IT staff• Ensure Backup, Recover & Business Continuance for DB & Applications Show less

• Manage, monitor, & maintain the DB & Application in PROD environments to meet SLAs in SQL 2008 environment. • Provide technical DB & Application support and guidance to the IT staff• Ensure Backup, Recover & Business Continuance for DB & Applications• Data Modeling for proposed and existing structures• Active hands-on member of development, support and maintenance projects• Resource and performance analysis and planning/tuning• Stored Procedure development, SSIS… Show more • Manage, monitor, & maintain the DB & Application in PROD environments to meet SLAs in SQL 2008 environment. • Provide technical DB & Application support and guidance to the IT staff• Ensure Backup, Recover & Business Continuance for DB & Applications• Data Modeling for proposed and existing structures• Active hands-on member of development, support and maintenance projects• Resource and performance analysis and planning/tuning• Stored Procedure development, SSIS package development, relational Database design, Implementing Referential integrity. Developing with large datasets of millions of rows.• Establish and maintain multiple database environments including Development, Test, and Production and ensures database management policies and procedures are established and communicated to the department staff for all relational database applications.• Responsible for all production databases and approved deployments, clustering and replication• Scrum environment with 5 weeks sprints.• Daily, weekly, monthly and annual monitoring and fine tuning of all relational database backups, maintenance plans and disaster recovery services using Spotlight. Responsible for testing of these plans.• Reviews all migration scripts for changes into production for all applicable applications, operating systems, and hardware to ensure departmental migration standards are followed. • Certified training in SQL 2012 internals and architecture. Show less

Developed ETL extracts from Meditech 5.6 to a SQL 2008 Data repository using Visual studio 2008 for SSIS and SSAS development.Developed new reporting environment for the 6.0 Meditech data on a Sharepoint environment using SSAS and stored procedures to server data from repository.

Setting up a data warehouse and data marts of patient data to use for SSRS for the client. Once the warehouse is completed I will begin developing robust reports using SSRS.The goal here is to architect the warehouse so the power users at DCI Services can create their own reports with Reporting Services Reoprt builder without having to hire a fulltime SSRS report developer.

• Responsible for design, development, testing, and implementation of database systems primarily in a Microsoft SQL Server environment, SharePoint 2007,.• Develop technical system documentation.• Implement Team Foundation Server for entire company source control and document management.• Implement Reporting Services server for financial and services department. Responsible for entire life cycle of reporting services and SharePoint servers..• Designed, architected and developed… Show more • Responsible for design, development, testing, and implementation of database systems primarily in a Microsoft SQL Server environment, SharePoint 2007,.• Develop technical system documentation.• Implement Team Foundation Server for entire company source control and document management.• Implement Reporting Services server for financial and services department. Responsible for entire life cycle of reporting services and SharePoint servers..• Designed, architected and developed an asset management and inventory tracking system with all automated procedures using SSIS & ETL processes. • Developed an automated new hire processing system that replaced all paper documents on the new hire procedure.• Responsible for design, development, testing, and implementation of Enterprise Reports using Microsoft SQL Reporting Services.• Responsible for all database backups, recovery, mirroring and disaster recovery for all SQL databases 10 terabyte scale database.• Developed stored procedures, SSIS, SSRS, SSAS for small scaled projects for all departments to be integrated with existing systems and new SharePoint environment.• Developed ETL methodologies, business intelligence reporting .Implemented data warehouse principles, approaches, technologies and architectures in a healthcare environment for SCRI that helped reduce man hours by 30% for Finance and Sales department.• Developed a Financial/Services reporting system in SSRS syncing data from Siebel with Oracle 9i to allow QA team to analysis trip monitoring for clinical trials enabling SCRI to become compliant with FDA guidelines. Show less

• Entire SQL server database migration onto new server hardware. From SQL 2000 on Server 2003 to SQL 2008 on Server 2008• Responsible for design, development, testing, and implementation of database systems primarily in a SQL Server 2005 environment • Optimizing SQL Server indexes and performance tuning• Created DTS and SSIS packages in addition to Scheduled Jobs• Setup SQL Server 2005 Reporting Services (SSRS). Created and deployed robust SSRS solutions.• Created stored… Show more • Entire SQL server database migration onto new server hardware. From SQL 2000 on Server 2003 to SQL 2008 on Server 2008• Responsible for design, development, testing, and implementation of database systems primarily in a SQL Server 2005 environment • Optimizing SQL Server indexes and performance tuning• Created DTS and SSIS packages in addition to Scheduled Jobs• Setup SQL Server 2005 Reporting Services (SSRS). Created and deployed robust SSRS solutions.• Created stored procedures , ETL and triggers to modify and enhance current custom WMS system. The system was built on VB 6.0 platform. Upgraded to .Net and SQL 2008.• Setup server clusters, Linked Servers and backup procedures for a 40 million record database at 30 GIG file size. • Developed software and applications using ASP.net, HTML and Javascript.• Modified current EDI system and mappers in an automotive EDIX12 environment Show less