Vishwanath Iyer
Senior Software Engineer - MSBI
Summary
A diligent, result-oriented & accomplished Software Engineering professional offering 6+ years of experience in Business Intelligence, Data Analytics, Data Warehousing, SQL Development Targeting assignments preferably in IT industry.
Overview
6
6
years of professional experience
8
8
years of post-secondary education
1
1
Certification
Work History
Senior Software Engineer - MSBI
Addeco
07.2022 - Current
- Worked with project managers, developers and business analyst to resolve technical tickets.
- Trained and mentored junior developers and engineers, teaching skills in SSIS and working to improve overall team performance.
- Worked with Data and Analytics Team to develop KPI reports and run test scenarios.
- Provided production support by trouble-shooting and fixing failure of automated jobs.
- Worked with SMEs for modifying existing architecture and improving the performance by reducing runtime.
- Worked as a Delivery Lead for the project by creating, validating and deploying the build on to Quality, Pre-Production and Production environments.
- Created process documents.
Senior Consultant - SSIS
B R Raysoft Global Pvt Ltd
10.2021 - 07.2022
- Lead a Team of 3 developers.
- Changing the existing implementation of Data Warehouse.
- Migrating from existing implementation of Merge Scripts to Change Data Capture (CDC).
- Configuring and setting up CDC Attunity Service and Designer on DB Server.
- Modifying existing packages and creating new packages to incorporate the new implementation.
- Identifying the scope and bottle necks of new implementation.
- Creating solution design for the proposed solution.
- Deployment, Testing and Validation along with Test case document on Dev, QA, UAT, Pre-Prod and Prod.
- Performance optimization and improving efficiency by refactoring code.
- Extending knowledge of Business Intelligence to provide ongoing refinement of processes to improve operations
Data Warehouse Engineer
Civica Resource Pvt. Ltd.
01.2021 - 08.2021
- Creating In-house Data Warehouse; using star schema.
- Creating Stored Procedures to refresh data from source system to Data Warehouse.
- Optimizing stored procedure to refresh data in a quick.
- Creating procedures regarding collating & analyzing data; developing new data analysis processes.
- Critically evaluating and screening data, plus profiling to identify any issues, assessing analytics on an ongoing basis.
- Monitoring the data warehouse, including the collection and utilization of all data.
- Extending knowledge of Business Intelligence to provide ongoing refinement of processes to improve operations.
MS Systems Analyst
All Scripts India LLP
12.2018 - 12.2020
- Maintaining client database and data warehouse; providing customized solutions and reports; providing on call support.
- Automating the processes using SSIS (ETLs).
- Creating procedures regarding collating & analyzing data; developing new data analysis processes.
- Critically evaluating and screening data, plus profiling to identify any issues; assessing analytics on an ongoing basis.
- Monitoring the data warehouse, including the collection and utilization of all data.
- Extending knowledge of Business Intelligence to provide ongoing refinement of processes to improve operations.
- Automated Cognos Cube Refresh.
- Provided support and technical guidance to ensure architecture and framework are aligned with BI application needs.
- Reduced cycle times and improved usability of Business Intelligence (BI) projects.
- Designed project health-check and technical roadmap for Business Intelligence (BI) Data Warehousing (DW) projects.
SQL Developer
Stemmons Business Services Pvt. Ltd.
09.2018 - 12.2018
- Created SSRS reports based on the business requirements.
- Monitored server performance using SentryOne.
- Reviewing & suggesting suitable improvements in stored-procedures to optimize performance.
Software Engineer
Zeus Learning Pvt. Ltd.
06.2016 - 07.2018
- Followed through all Agile ceremonies; performed requirement analysis, unit testing, code review & application deployment.
- Designed & developed web-based e-learning solutions such as learning management systems & technical education interactives.
Education
Master of Science - Machine Learning And Artificial Intelligence
07.2021 - Current
Post Graduate Diploma - Machine Learning And Artificial Intelligence
03.2020 - 03.2021
Bachelors of Engineering - Computer Engineering
06.2012 - 06.2018
Skills
System Analysis
Database Management
Process Automation
Reports & Solutions
Performance Monitoring/ Optimization
Issue Resolving / Troubleshooting
Internal/External Liaison & Coordination
Team Leading & Development
Stakeholder Management
IT Skills
- Programming Languages: C, C++, JavaScript, SQL
- Reporting Tools: SSRS
- Analytical Tools: SSIS, Power BI
- Monitoring Tools: SentryOne, IBM IDX, Optum Auto Loader
- Scripting Tools: Batch, VB
- Modelling Tools: Microsoft Visio, Draw IO
- Source Control: GIT, TFS
- Dev Methodologies: Agile, Waterfall
- Story Mapping and tracking: Jira, Dev-Ops
Certification
Microsoft Certified Solutions Associate - Credential ID H322-9087
Accomplishments
- Received Performer of the Month Award as well as GEM Award (Go the Extra Mile Award) in Allscripts India LLP.
- Optimized an SSIS package from 7 hours to 40 seconds; optimized a search application from 15 minutes to 1 minute.
- Skilful in designing & developing web-based e-learning solutions such as learning management systems & technical education interactives
- A keen communicator with honed interpersonal, problem-solving, and analytical skills.
- Experienced in working on KPI Metrics Dashboards in finance domain and data analytics in US IT Healthcare Domains
Timeline
Senior Software Engineer - MSBI - Addeco
07.2022 - Current
Senior Consultant - SSIS - B R Raysoft Global Pvt Ltd
10.2021 - 07.2022
Liverpool John Moores University - Master of Science, Machine Learning And Artificial Intelligence
07.2021 - Current
Data Warehouse Engineer - Civica Resource Pvt. Ltd.
01.2021 - 08.2021
IIIT - Bangalore - Post Graduate Diploma, Machine Learning And Artificial Intelligence
03.2020 - 03.2021
Microsoft Certified Solutions Associate - Credential ID H322-9087
12-2019
MS Systems Analyst - All Scripts India LLP
12.2018 - 12.2020
SQL Developer - Stemmons Business Services Pvt. Ltd.
09.2018 - 12.2018
Software Engineer - Zeus Learning Pvt. Ltd.
06.2016 - 07.2018
Gujarat Technological University - Bachelors of Engineering, Computer Engineering
06.2012 - 06.2018