Rohit Gupta
About Rohit Gupta
Rohit Gupta is a Lead Data Analyst at Epiq Systems, specializing in data transformation and reporting. He holds a Master of Science in Computer Science from San Diego State University and a Bachelor of Science in Electronics & Instrumentation from SVITS.
Work at Epiq
Rohit Gupta has been serving as the Lead Data Analyst at Epiq Systems since 2011. His role involves transforming Business Requirements Documents (BRD) into Software Requirements Specifications (SRS) and Functional Requirements Specifications (FRS). He is responsible for developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading processes. Gupta also creates and manages various database objects to meet the needs of front-end applications. His extensive experience includes conducting Joint Application Development (JAD) sessions with auditors and business users.
Education and Expertise
Rohit Gupta holds a Master of Science (MS) in Computer Science from San Diego State University-California State University, which he completed from 2008 to 2010. Prior to this, he earned a Bachelor of Science (B.S.) in Electronics & Instrumentation from SVITS, studying there from 2004 to 2008. His educational background provides a strong foundation for his expertise in data analysis, database management, and software development.
Technical Skills and Responsibilities
Gupta specializes in utilizing SQL Server Agent for job scheduling and monitoring related to package execution and cube processing. He develops SSIS packages to facilitate data handling from various sources, including flat files and Oracle servers. Additionally, he creates and deploys reports using SQL Server Reporting Services (SSRS), focusing on security during the deployment of drill-through, linked, and sub-reports. His technical skills also include the management of materialized views and the development of stored procedures, triggers, indexes, views, and user-defined functions.
Background
Rohit Gupta has over 13 years of experience in data analysis and database management, primarily in the Portland, Oregon area. His career at Epiq Systems has equipped him with a comprehensive understanding of data requirements and the technical skills necessary to meet them. His work involves collaboration with auditors and business users to ensure accurate documentation of business requirements.