Ashish Jain

FAQ About Ashish Jain

• What is Ashish Jain's address?

  Ashish Jain is located at
  Beaverton, Oregon, United States

• What is Ashish Jain's job title?

  Ashish Jain is a
  10+ years of experience in SQL Server design using SQL SErver management studio, SSIS, and SSRS. 10+ years of total IT experience in Business Requirement Analysis, Application Design, Development, Implementation & Testing of Data Warehousing, Data Migration, and Database business systems for Class action. Involved in interacting with Business users by participating in Joint Requirement Development (JAD) sessions to analyze the business process and requirements. Involved in analyzing Business Requirement Documents, Technical Specifications, and Data Mapping and drawing up the Process Flow Charts, and ERDs using MS Visio. Analyze the functional requirements into sizable efforts (Service requests), assign them a priority level, and provide a high level of the estimate. Translate the functional requirement document into technical design documents. Wrote multiple queries, nested queries using joins, aggregate function, and involved in query optimization. Build ETL interfaces for data ingestion using Data transformation services (DTS) and SSIS. Hands-on experience in performing complex data transformation. Hands-on experience using T-SQL in constructing tables, stored procedures, triggers, views, indexes, data integrity, query optimization, database optimization, and table partition schemes. Adept in implementing indexing strategies, analyzing the execution plans, creating partition schemes, and partition functions to improve the performance, reduce the contention and increase the availability of data. Worked with transactional statements to implement the commit and rollback feature of the SQL Server. Implemented error-handling techniques like user-defined errors and system-generated errors using the error severity and error message function of the SQL Server. Assisted software Developers in data modeling. Automated the ETL jobs /scripts using the SQL Server Job Agent. Experience in working on Team Foundation Server (TFS). Trained in Microsoft cloud services such as Azure data factory, Azure synapse, and ADLS. Trained in python scripting. My goal is to establish myself as a valuable team member and an asset to the company I work Specialties: T-SQL Queries Using joins and subqueries and different inbuilt functions, Stored Procedures, Triggers, functions Epiq Systems

• What industry does Ashish Jain currently work in?

  Ashish Jain currently works in the
  Epiq Systems

• What is Ashish Jain's area of expertise?

  Ashish Jain specializes in
  10+ years of experience in SQL Server design using SQL SErver management studio, SSIS, and SSRS. 10+ years of total IT experience in Business Requirement Analysis, Application Design, Development, Implementation & Testing of Data Warehousing, Data Migration, and Database business systems for Class action. Involved in interacting with Business users by participating in Joint Requirement Development (JAD) sessions to analyze the business process and requirements. Involved in analyzing Business Requirement Documents, Technical Specifications, and Data Mapping and drawing up the Process Flow Charts, and ERDs using MS Visio. Analyze the functional requirements into sizable efforts (Service requests), assign them a priority level, and provide a high level of the estimate. Translate the functional requirement document into technical design documents. Wrote multiple queries, nested queries using joins, aggregate function, and involved in query optimization. Build ETL interfaces for data ingestion using Data transformation services (DTS) and SSIS. Hands-on experience in performing complex data transformation. Hands-on experience using T-SQL in constructing tables, stored procedures, triggers, views, indexes, data integrity, query optimization, database optimization, and table partition schemes. Adept in implementing indexing strategies, analyzing the execution plans, creating partition schemes, and partition functions to improve the performance, reduce the contention and increase the availability of data. Worked with transactional statements to implement the commit and rollback feature of the SQL Server. Implemented error-handling techniques like user-defined errors and system-generated errors using the error severity and error message function of the SQL Server. Assisted software Developers in data modeling. Automated the ETL jobs /scripts using the SQL Server Job Agent. Experience in working on Team Foundation Server (TFS). Trained in Microsoft cloud services such as Azure data factory, Azure synapse, and ADLS. Trained in python scripting. My goal is to establish myself as a valuable team member and an asset to the company I work Specialties: T-SQL Queries Using joins and subqueries and different inbuilt functions, Stored Procedures, Triggers, functions

• Which languages does Ashish Jain speak? 

  Ashish Jain speaks the following languages:
  No languages available.

• Which industries has Ashish Jain previously worked in?   

  Ashish Jain has prior experience in the following industries:
  Optum , Epiq Systems , Youth Connection Charter School

• What is Ashish Jain’s work experience?  

  Ashish Jain has the following professional experience:
  Epiq Systems , Optum , Epiq Systems , Youth Connection Charter School .

• How can I find Ashish Jain on LinkedIn?  

  You can view Ashish Jain’s
  LinkedIn profile at LinkedIn URL.

• What are Ashish Jain’s work email addresses?  

  Ashish Jain’s work email addresses are
  [email protected] .

• What company does Ashish Jain work for?  

  Ashish Jain works at
  Epiq Systems