Silvi Joseph
Business Intelligence Developer · Randstad
Work Experience
Business Intelligence Developer
Randstad2018 – 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
Copart2017 – 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 Arlington2016 – 2016
Graduate Teaching Assistant
The University of Texas at Arlington2016 – 2016
Senior Systems Engineer
Infosys Technologies Limited2013 – 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 Limited2012 – 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 University2008 – 2012
Bachelor of Technology
Master of Science
The University of Texas2016 – 2017
Master of Science