- Solo Hiker
- Humane Society Volunteer
- Community Cleanup
- Youth Development Programs
- Sharing travel tips, recommendations, and insights with fellow enthusiasts
Shresh Mohan
Data Analyst
Greater Minneapolis area,MN
Work Preference
Summary
Experienced Data Analyst specializing in BI/DWH and ETL/ELT. Actively seeking positions in: Data Analyst, Data Engineer, BI Reporting, Test Manager. Based in Greater Minneapolis area, and open to remote and hybrid work.
Work History
Software Engineer/Data Analyst
Platform Science (PS)
San Diego, CA
01.2025 - 09.2025
- In this position as BI reporting Data Analyst, I have worked on transitioning Trimble (now PS) ELD data feeds to Platform Science HOS feeds. My daily focus would include:
- Establish upstream large-scale data structures, data sources and data pipelines (Apis/Kafka feed into Snowflake tables)
- Efficient ETL/ELT workflows to address complex problems and support business cases.
- Continuous effort in converting nightly batched reports to Real Time reporting for end users.
- Knowledge Transfers/Handoff to QA for testing.
- Delivered unit-tested systems within customer-prescribed timeframes.
- Responsible for Production release of Reports and Code Deployment (CI/CD) to production using Github/Buildkite
- Provide a detailed document to the Product team for release of deliverables.
- Working with DevOps on Network Policies and Rules for Snowflake for account user (roles and permissions)
- Ability to work across multiple environments and services. Worked closely with the product owner and Product Manager on Feature Development initiatives. Peer Reviews from cross team code collaboration (Github repos/PRs/Visual Studio Code)
- Worked in a team with Software Design & Architecture. Created Lucidchart diagrams for the team and knowledge transfer.
- Acts as a resource for colleagues with less data/backend experience or from different work domains like CSM (Customer Success Managers / Customers/ TSRs)
- Tools: SSRS Reporting, Power BI, Domo, DBT(Data Build Tool), Visual Studio Code, Github, Buildkite, Jira, Confluence, SQL Server Management Studio 2012, Snowflake
Software Engineer/Data Analyst
Trimble Transportation - Fleet Management
04.2016 - 01.2025
- I actively lead and contribute to an enterprise reporting and development team (BI Mobility) in the complete rollout of a new reporting platform /custom reports that is integrated into our applications system. As it is a very fast-paced work atmosphere, generally we work with many CSM and cross teams and often have ambiguous requirements.
- Fun things I did under this role:
- Develop and maintain data models in DBT (Data Build Tool) for data ingestion/Data transformations.
- Filter, clean, and transform data from source into snowflake (view/tables/dynamic tables) for further analysis.
- Focus on Data accuracy and performance of the (SSRS) reports.
- Support data inspection, data quality, governance, transparency, and compliance.
- Extensive experience with query language (SQL,SnowSQL) for data analysis and profiling.
- Has solid understanding of SOLID Principle, Clean Code and Design Patterns.
- Leads code quality initiatives, such as refactoring for code performance.
- Efficient in working with Jira/Confluence.
- Expert in leading Standups and technical meetings.
- Scrum Activities: Assist team with writing Jiras, pointing them, and maintaining/pruning backlog items under epics.
- Tools: SSRS Reporting,Birst Reporting (now Infor), Power BI, Domo, DBT (Data Build Tool), Visual Studio Code, Github, Buildkite, Jira, Confluence, SQL Server Management Studio 2012, Snowflake
Team Lead (ETL/BI/Data Test Analyst)
PeopleNet Fleet Management (Trimble Nav)
10.2014 - 04.2016
- From driver performance assessment to managing safety, compliance and maintenance costs, PeopleNet’ reporting application is designed to maximize customers’ ROI. PeopleNet develops its own applications and partners with third-party cloud services (Birst) to deliver leading-edge solutions encompassing Safety and Compliance, End-to-end Vehicle Management and Costs. The reporting team is integrated with Vusion in providing cutting-edge analysis on fleet data. My role as a leader is to deliver products to the customer with unprecedented quality, efficiency and performance. As an SME on devices and hardware technology out in the field, I track and test device data flow and transformations in the code. Managed testing single handedly business Intelligence model of Peoplenet from project initiation, planning to production roll out. My ability to understand the data and handle data quality issues and respond to customer queries makes me to go person of the reporting team.
- Responsible for creating test plans and timeline estimation for ETL and automation testing efforts.
- Analyze and solve complex business scenarios and conversion requirement specification from Project Managers.
- Provide internal support/data investigations to the PMO/Call center team with customer issues.
- Create test scenarios and related SQL scripts aligned with the mapping document and business requirements.
- Create reference architecture QA handbook document for the knowledge transition with QA/Beta team.
- Review peer test cases and scenarios for report testing.
- Execute SQL stored procs and do step by step data integration validations.
- Testing of web API consisting of dozens of SOAP requests.
- Validate data for completeness, quality, and referential integrity.
- Review data loaded into the data warehouse or data mart for accuracy and usability.
- Written testing standards, guidelines and procedures around DW test/quality test items
- Experience of testing in Birst cloud, M2M, and Cube.
- Perform data validation from frontend of the application via system generated reports and UI.
- Developed SQL queries (temp files, Unions, Joins, Case statements) for ETL validations.
- Worked with Dev/DBAs on job monitoring and failure root cause analysis.
- Worked with DBAs on automation of partitioning of tables.
- Own and Coordinate Production Deployments of SQL packages.
- Support and investigate Internal Customer Issues on Daily basis and report to Project/Client managers.
- Environment manager for QA and Report Dev environments.
- Strong knowledge of Data Warehouse Architecture and designing Star schema, Fact and Dimensional Tables. OLTP and OLAP data models.
- Interface with other technology teams to iron out data issues.
- Interface with business/customer/beta team to gather requirements.
- Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support.
- Tools: SQL Server Management Studio 2012, M2M, Cloud testing, Cube, Data warehouse, Jira, VersionOne, Bugzilla/Testopia, Qtest, Jmeter ,Wimmerge, Splunk, Birst,SVN,GitHub, .NET applications, Web Service testing, JSON
Data Quality Analyst
Data Recognition Center
Maple Grove, MN
12.2013 - 09.2014
- DRC provides research, technology, process consulting, and complete project administration—in-house, in one integrated process. They design government and commercial surveys. I worked as a Quality Assurance specialist in their Survey Services Department. As a QA I was involved in testing large scale data returns from surveys as small as 10 questions to 70 questions. My responsibilities included:
- Responsible for creating test plans and timeline estimation for testing efforts.
- Used complex SQL queries for testing.
- Checked database integrity to determine successful transaction of test data from the application by establishing database connectivity and querying with SQL commands
- Web and CATI Validation of data after commercial survey returns
- Testing frontend and backend of commercial websites. (Grey Box testing)
- Testing commercial reports on SAS and Tango platforms.
- Understanding of surveys developed in SURVANT.
- Extensively involved in launching and testing their new CATI system (phone assisted interviews/survey)
- Involved in testing the automation processes.
- Working on various government projects that were high profile and had a lot of visibility.
- Part of TFS Guild: Setting QA processes and workflow for Microsoft TFS.
- Multitasking 3-4 projects at a time and delivering on time with no fault.
- Learning: Implementation of corrective actions through analysis techniques. Used SQL extensively for data analysis. Sound knowledge of databases.
- Accomplishments: handed Company’s huge effort in moving from SAS to Tango platform within a tight timeline.
- Tools: Microsoft SQL Server, Microsoft VB TFS, .NET development platform, SAS reporting, Elixir TANGO reports, Compart tool, SURVANT
Quality Assurance Consultant
Verizon NetworkFleet (Magenic)
Minneapolis, MN
11.2012 - 12.2013
- Company Overview: An Aha! from Magenic Technologies
- Our Client provided both hardware and software products to customers, ranging widely in size from small company fleets to very large government and commercial clients. This includes white-labeled versions of their web-based application for several customers, involving significant customization and data exchange dependencies. They also have integrated back office systems for sales and billing as well as a message processing system.
- Performed manual regression testing support, testing for new features for upcoming releases.
- Provided analysis documents for the long-term test planning for both manual and automated test suites.
- Provided deliverables such as Regression Test plans, weekly Summary and Charters.
- Also tested across following test portfolios: Nightly dev builds, QA stage releases, Feature change or redesign focused tests, and Pre-Prod release.
- Coordinating nightly build deployment testing within the team as lead tester.
- Leading Bug Triage meetings bi-weekly with the client and UAT team.
- Worked in parallel with End users to resolve the issue. (Customer Care Tickets)
- Involved in new feature roll outs every month from creation of MRD to Release testing.(Full SDLC)
- Training juniors (new hires) and creating training documents for clients.
- Tools: Java based application, JIRA, Confluence, BackOffice (Clients Administrative Interface) and ARCH for raw data.
Quality Assurance Consultant
Bright Horizons (Magenic)
, MN
03.2012 - 10.2012
- Performed manual testing for client’s website under development
- Developed, edited, and executed test cases, tracked test runs
- Created and communicated defect reports
- Hosting Bug triage calls with senior management and UAT team
- Created and executed automated test cases using Visual Studio (Coded UI)
- Participate and provide feedback during daily standups and sprint planning meetings.
- Coordinated with developers to understand complex features of the application.
- Database CRUD testing using SQL Server Management.
- Extensive exposure of Microsoft CRM.
- Assisted third party UAT Team in transfer of knowledge and bug triage on a daily basis.
- Maintained Burn reports and Weekly Status reports for the group of 4 testers.
- Tools : ASP.Net based web application, MS Visual Studio 2010 , SQL Server Management Studio, Test Manager, SharePoint 2010, Coded UI
Mobile Tester ( iOS/Android)
YourMPG (Magenic)
Minneapolis, MN
04.2013 - 12.2013
- The web version of the app is at fueleconomy.gov and has recently been renamed MyMPG. It allows you to enter the MPG of your vehicle and share it with the world if you wish. Because of the sharing, it also provides the ability for anyone to search for the real-world MPG of vehicles. I tested iOS 5 iPhone and on XCode IDE on Mac.
Overview
14
14
Years of professional experience in Development and Testing
3
3
Certification( SQL and Snowflake)
Education
BSEE, four-year college degree - Bachelor of Engineering in Electrical Engineering, Minor: Mathematics
RGPV
Skills
- Technical reporting
- Programming languages
- Agile methodologies
- Customer support
- User interface design
- Virtualization
- API integration
- Testing and debugging
- Engineering standards
- Efficient data management
- JIRA
- Data synchronization
- Code reviews
- UI/UX
- Requirements gathering
- Team collaboration
- Code debugging
- Data extraction
Certification
- ISTQB Certified Tester Foundation CTFL, 2014
- SQL Certification Normandale Community College, 2012
- Snowflake Data Warehousing Workshop
Interests
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Work Authority:
US CITIZEN - Authorized to work for any employer within the United States and would not need any sponsorship now or in near future.
Timeline
Software Engineer/Data Analyst
Platform Science (PS)
01.2025 - 09.2025
Software Engineer/Data Analyst
Trimble Transportation - Fleet Management
04.2016 - 01.2025
Team Lead (ETL/BI/Data Test Analyst)
PeopleNet Fleet Management (Trimble Nav)
10.2014 - 04.2016
Data Quality Analyst
Data Recognition Center
12.2013 - 09.2014
Mobile Tester ( iOS/Android)
YourMPG (Magenic)
04.2013 - 12.2013
Quality Assurance Consultant
Verizon NetworkFleet (Magenic)
11.2012 - 12.2013
Quality Assurance Consultant
Bright Horizons (Magenic)
03.2012 - 10.2012
BSEE, four-year college degree - Bachelor of Engineering in Electrical Engineering, Minor: Mathematics
RGPV