SJ

Silvi Joseph

Business Intelligence Developer · Randstad


Work Experience

Business Intelligence Developer

Randstad

2018 – Present

Independently designed and implemented data pipelines to integrate billion-row datasets from various databases, process them and store into SQL Server and Google BigQuery • Created and maintained advanced BI visualizations (~20% of the 200 Pentaho/SSRS reports) • Automated reports based on recurring data pull requests, reducing the manual effort by 20 % • Aggregated multiple revenue tables into a single source of financial data, thereby achieving a reduction in maintenance time by 90% • Worked closely with users including VPs and SVPs to understand the business needs and to translate them into real-time reports • Actively participated in the technical analysis of new programs, to determine feasibility, cost, and time • Optimized existing reports by providing suggestions and design changes, to increase the processing speed • Triaged issues based on priority and provided quick resolutions. Number of defects reduced by 10%, and time to resolve defects reduced by 18% over a period of 1 year • Successfully led and executed multiple migrations to production • Assisted and groomed junior team members by conducting knowledge transfer sessions

Data Services Analyst

Copart

2017 – 2017

Developed, executed, and maintained ETL scripts and jobs to extract and transform data from source systems • Analyzed data to design and create the underlying data warehouse, facts, and dimensions • Coordinated the design and implementation of the data model, schema of cubes and measures • Created new reports and dashboards, and suggested requirement changes that could fully utilize the tool's capability • Improved report performance from 20 seconds to 2-3 seconds by transforming MDX reports to SQL- based reports, and by effective utilization of the Mondrian cache • Held meetings with clients to document requirement changes and explore potential solutions

Student Assistant

The University of Texas at Arlington

2016 – 2016

Graduate Teaching Assistant

The University of Texas at Arlington

2016 – 2016

Senior Systems Engineer

Infosys Technologies Limited

2013 – 2015

India • Controlled database changes in SQL for customizing the data model • Performed Root Cause Analysis and contributed expertise in solution design for issue resolution • Reviewed and commented on technical solutions • Built data marts over the cleansed data and analyzed various aspects of the system to find patterns or trends • Created dashboards and reports using Cognos

QA Analyst

NCR Corporation Private Limited

2012 – 2013

India • Performed bug trend analysis to discover the potential focus areas for development, and proposed changes to avoid potential issues • Co-led a team of four members and took the initiative to train them on the product and processes • Coordinated and performed quality assurance, system integration and UAT for on -time releases • Implemented ETL and dashboard testing of Jaspersoft reports, along with test case creation

Education

Bachelor of Technology

Jawaharlal Nehru Technological University

2008 – 2012

Bachelor of Technology

Master of Science

The University of Texas

2016 – 2017

Master of Science