Senthil Krishnaswamy Email & Phone Number

Canada

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Brampton, Ontario, Canada

Course1:Business Problem Solving & Data AnalyticsCourse2:PowerBI, ETL SSIS and DAX

Toronto, Ontario, Canada

Toronto, Canada Area

Environment & Tools:MS Visual Studio 2017 (SSIS), MS SQL Server 2018, Transact-SQL, MS Visio, Jira, Confluence, Microsoft CRM 2013, Microsoft Dynamics Online, Azure ADF Pipelines.

Toronto, Canada Area

Responsibilities: Developed and documented ETL tasks in confluence for data migration activities. Developed SSIS package for sourcing data from HIVE tables through SSH command and landed in local PDW for reporting. Captured and documented the requirements in Confluence and subsequently, delivered the report data through SSIS/Alteryx packages. Developed.

Responsibilities: Created functional, non-functional, reporting, security requirements and created technical Specs documentation. Liaise with the SMEs to prioritize the requirements and traction the project for the stakeholder approval. Conducted workshops with business to understand the reporting process, current pain-points and subsequently.

• Responsibilities:
• Pitched in the dashboard versions of traditional paper-based reports to the SMEs and automated reporting process using alteryx and tableau.
• Built reporting workflows, data extracts and dashboard samples of the existing paper-based reports.
• Created ETLs to migrate data from different internal databases and subsequently modeled the data for reporting in SAP BO.
• Optimized the existing workflows, VB Macros and SQL scripts resulting in run-time savings of 55 %.
• Gather user requirements, investigate issues/variances and develop prototypes of reporting application model.

• Responsibilities:
• Designed and developed BI reports to support reporting requirements for different internal lines of business.
• Identified/recommended sales promotions for different products based on regional store specific sales demands and historical data using Alteryx – Tableau.
• Conducted requirements analysis, documentation, design, implementation and gap analysis of new applications/enhancements to existing ones.
• Validated functional specifications by modelling business processes, STM and developing proof of concept (POC) prototypes.
• Conducted workshops with relevant stakeholders to elicit requirements and documented them subsequently.

• Responsibilities:
• Acted as SME on application knowledge and trained various banking concepts like Anti-Money Laundering and Payments to new joiners.
• Trained new mentees within project/technical functions and assisted in knowledge management and to integrate trainees into the project team.
• Conduct workflow analysis, define user requirements, identify issues and implement solutions.
• Create system requirement documents and business requirement documents through continuous-iterative interaction with technology and business stakeholders.
• Created data mapping for migrating data from different external sources into the in-house systems.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering

Master Of Business Administration - Mba