• Consolidate and optimize available data warehouse infrastructure.• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.• Developing data warehouse process models, including sourcing, loading, transformation, and extraction. Thus, creating and implementing metadata processes and frameworks.• Create visually impactful dashboards in Tableau for data reporting by using various charts to show trends and… Show more • Consolidate and optimize available data warehouse infrastructure.• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.• Developing data warehouse process models, including sourcing, loading, transformation, and extraction. Thus, creating and implementing metadata processes and frameworks.• Create visually impactful dashboards in Tableau for data reporting by using various charts to show trends and flow.• Creates support documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. • Analyze large databases and recommend appropriate optimization for the same.• Prepare various code designs and ensure efficient implementation of same.• Monitor data warehouse work and provide subject matter expertise.• Provide support/mentor to team members in all technical matters. Show less

• Consolidate and optimize available data warehouse infrastructure.• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.• Developing data warehouse process models, including sourcing, loading, transformation, and extraction. Thus, creating and implementing metadata processes and frameworks.• Creates support documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.… Show more • Consolidate and optimize available data warehouse infrastructure.• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.• Developing data warehouse process models, including sourcing, loading, transformation, and extraction. Thus, creating and implementing metadata processes and frameworks.• Creates support documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. • Analyze large databases and recommend appropriate optimization for the same.• Prepare various code designs and ensure efficient implementation of same. Show less

• Database Development, which includes creation of stored procedure, functions, tables, views, triggers, and Scripts using Transact SQL.• Support to the client deployed databases, analyze, test queries.• Optimize queries, stored procedures, and indexes to improve reporting performance (SSRS).• Architect the database for reporting efficiency, and implement best practices.• Work with Business analyst group to ascertain their database reporting needs.• Take the database… Show more • Database Development, which includes creation of stored procedure, functions, tables, views, triggers, and Scripts using Transact SQL.• Support to the client deployed databases, analyze, test queries.• Optimize queries, stored procedures, and indexes to improve reporting performance (SSRS).• Architect the database for reporting efficiency, and implement best practices.• Work with Business analyst group to ascertain their database reporting needs.• Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into meaningful reports. Show less

1 - Database Development, which includes creation of stored procedure, functions, tables, views, triggers, and Scripts using Transact SQL.2 - Creation of SSIS (ETL) Package.3 - Support to the client deployed databases, analyze, test queries.

• Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.).• Write scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers.• Provide primary support for the organization’s data repositories and will be responsible for requested SQL reports.• Work with project managers of Scan & Capture clients to identify and… Show more • Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.).• Write scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers.• Provide primary support for the organization’s data repositories and will be responsible for requested SQL reports.• Work with project managers of Scan & Capture clients to identify and prioritize data information needs, requirements and documentation.• Create clinical and financial reports to user specifications using commonly available report writing tools and queries for SQL databases.• Identify reporting requirements, writing and optimizing SQL queries, stored procedures, and views to extract the information, trends, or patterns contained in the data.• Assist with the import and export of data from stakeholders.• Working knowledge and experience in Qlikview analytics platform.• Intermediate consulting skills.• Experience in BMC remedy ITSM.• Experience in developing and maintaining Interface with/to ERP systems Show less