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
undefinedIT 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
Similar Profiles
Steven HangSteven Hang
Production Line Lead Assistant at AddecoProduction Line Lead Assistant at Addeco
Leny VillafaneLeny Villafane
Assembly Line Worker at AddecoAssembly Line Worker at Addeco
Navjot KaurNavjot Kaur
Picking Packer at AddecoPicking Packer at Addeco