Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Aravind K

Vancouver,Canada

Summary

  • Over 5 years of experience as a Business Analyst, specializing in understanding business processes, developing precise technical requirements, and ensuring the delivery of effective solutions.
  • Collaborated with stakeholders to gather user requirements, translating them into technical solutions, and designed reports based on business needs.
  • Designed and developed databases using SQL Server 2014/2016, optimized stored procedures, and maintained performance through SSIS packages, tables, and views.
  • Utilized SQL scripts and ETL processes to perform data cleansing, transformation, and validation, ensuring data accuracy across systems.
  • Worked with development teams to design, test, and implement API integrations, improving system interoperability and streamlining processes.
  • Led the migration of SharePoint from 2010 to Online, and assisted with migrating on-premise applications to the cloud, ensuring smooth transitions and minimal disruptions.
  • Developed custom applications using Power Apps, Power Automate, and Power BI, automating workflows and creating actionable reports for better decision-making.
  • Gained experience with Big Data tools (Hadoop, Spark, Kafka), working on high-performance computing clusters, and built real-time data pipelines for advanced analytics.
  • Implemented and maintained ERP systems (SAP, Oracle), and enhanced database performance using SQL Profiler and tuning tools.
  • Hands on experience in web designing using HTML, CSS, and JavaScript to display reports on the server.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Sr.Business Analyst

CIBC
Vancouver, Canada
11.2022 - Current
  • Gather requirements from stakeholders, translating user requirements to technical, designing reports, researching solutions.
  • Designed and created mock web portals to support various business functions, ensuring seamless user experience and stakeholder alignment.
  • Collaborated with development teams to design, test, and implement API integrations to enhance system interoperability and streamline processes.
  • Utilized SQL scripts and ETL processes to perform data cleansing, transformation, and validation, ensuring data accuracy and consistency across systems.
  • Utilized Power Apps, Power Automate, and Power BI to develop custom business applications, automate workflows, and generate insightful reports for decision-making.
  • Led the migration of SharePoint from 2010 to SharePoint Online, ensuring data integrity, collaboration efficiency, and alignment with modern cloud architecture.
  • Developed complex stored procedures and functions in SQL to automate ETL tasks and streamline data integration processes.
  • Assisted in the migration of on-premise applications to the cloud, working closely with project managers and technical teams to ensure smooth transitions and minimal disruptions.
  • Provided assistance to the project manager with Azure-related tasks, including planning, coordination, and monitoring of cloud-based projects.
  • Engaged with cross-functional teams and stakeholders to gather requirements, define business objectives, and deliver effective technical solutions.
  • Automated consistency check of the database (DBCC) for SQL Server
  • Create and maintain ETL processes, dashboard and report
  • Expertise in conducting gap analysis between application and stated customer requirements and collaborated with Architects and Developers to estimate project impact.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.

Business Analyst

ADP
Hyderabad, India
02.2017 - 08.2019
  • Developed and structured databases to align with business needs and operational goals.
  • Produced data-driven visualizations and performance metrics using SSRS and Power BI dashboards.
  • Developed KPI visualizations in both SSRS and Power BI to provide actionable insights for business stakeholders.
  • Created dynamic metadata views using advanced T-SQL, troubleshooting and resolving issues related to database integrity, performance bottlenecks, deadlocks, and blocking.
  • Extracted data from OLTP systems into OLAP using SSIS, identifying and connecting various data sources for reporting purposes and building data source views.
  • Played a key role in the setup of new databases, including the strategic placement of data files, indexes, and transaction logs across disks.
  • Delivered comprehensive functional specifications, facilitating clear communication between clients and development teams.
  • Developed and implemented advanced SQL components like stored procedures, triggers, and views.
  • Optimized queries and improved performance using tools like SQL Server Profiler and Database Engine Tuning Advisor, ensuring efficient execution of SQL queries and stored procedures.
  • Assisted with the technical aspects of deploying databases from development stages to testing and production environments for multiple systems.
  • Created complex stored procedures, triggers, tables, views, and SQL joins.

Business Analyst

Genpact
Hyderabad, India
01.2016 - 01.2017
  • Designed and developed databases with expertise in SQL Server 2014/2016, including the use of SSIS, DTS Packages, SSAS, DAX, OLAP cubes, and both star and snowflake schema designs.
  • Created and optimized SSIS packages, stored procedures, tables, views, and functions to maintain optimal database performance.
  • Experience with Big Data technologies, including Hadoop (HDFS and MapReduce), Hive QL, Sqoop, Pig, and Apache Spark (PySpark).
  • Worked on high-performance computing clusters using AWS, Spark, and Hadoop, and built real-time data analysis pipelines with Kafka and Spark Streaming. Familiarity with tools like Qlik, Tableau, and Power BI.
  • Implemented and maintained ERP systems, working with platforms such as SAP, Oracle E-Business Suite, and Microsoft Dynamics AX.

Education

Bachelor of Commerce -

Osmania University
Hyderabad, Telangana

PG Diploma in Financial Management -

Langara College
Vancouver, BC

Skills

  • Windows 7
  • Windows 10
  • Linux
  • Ubuntu
  • Azure Data Factory
  • T-SQL
  • PL/SQL
  • NET
  • Python
  • R
  • HTML
  • C
  • C
  • C#
  • Agile Scrum
  • Waterfall
  • Microsoft SQL Server 2008 R2, 2012, 2014, 2016
  • MS Access
  • MySQL
  • Power BI
  • Tableau
  • SSIS
  • SSRS
  • Clear Quest
  • Excel
  • Microsoft SQL Server Management Studio
  • DTS
  • Analytics Server
  • VB Macros
  • Visual Studio 2015,2019
  • Git
  • API
  • HTML
  • Windows MS-Office 2016

Certification

  • Microsoft Certified: Azure Fundamentals
  • Microsoft Power Platform Fundamentals

Timeline

Sr.Business Analyst

CIBC
11.2022 - Current

Business Analyst

ADP
02.2017 - 08.2019

Business Analyst

Genpact
01.2016 - 01.2017

Bachelor of Commerce -

Osmania University

PG Diploma in Financial Management -

Langara College

Similar Profiles

CREATE PROFILE
Aravind K