Business Intelligence Analyst with *+ years of experience interpreting and analyzing data to drive successful business solutions. Experienced at creating data regression models, using predictive data modeling, and analyzing data mining algorithms to deliver insights and implement action-oriented solutions to complex business problems. Seeking to apply excellent understanding of business operations and analytics tools as a Business Intelligence Analyst Areas of Expertise

SQL · PL/SQL · Azure Data Lake · Hadoop · oracle 12 · Python (Programming Language) · HDFS · ETL Tools · OLAP · SSAS · SSRS · Tableau · MapReduce · Scala · HBase ·SSIS. Azure Data Lake · Hadoop · oracle 12 · SSIS,AWS (Amazon web series). Data modelling, Data warehousing, Data Mining

• Provide rapid development services for critical reporting and process improvement projects

• Support with the creation of, maintenance of, and integrate of metrics related to into a common reporting and analytics solution

• Assisted with the definition of metrics and measurements to provide governance to processes

• Performed ad-hoc reporting and analysis

• Assist with the development of and performance of predictive analytics and the transformation of data to business intelligence

• Support with the execution of project plans

• Support and act as a leader with end-to-end process of data sourcing, importing, cleaning, transforming, validating and modeling into a meaningful purpose such as illustrative charts, graphs, tables, dashboards, etc

• Developed data models and algorithms to identify trends and patterns in customer data

• Implemented data analysis techniques to improve operational efficiency and customer satisfaction.

• Develop and propose new analytics ideas about our markets, services, competitors and regulatory environment.

• Develop dashboards and scorecards using advanced visualization techniques and data capabilities such as embedding analytics in clinical and business process tools or designing dashboards tailored to strategic goals Company: Scotiabank March 2020 -Present

Designation: Business Intelligence Analyst

Role:

• Employed Tableau visual analytics techniques and best practices, including structuring dashboards, optimizing layout, emphasizing key data, utilizing tooltips, and enhancing performance for complex reports.

• Managed data refresh schedules using Tableau Bridge and oversaw user groups and permissions in Tableau Online.

• Handled administrative tasks such as setting permissions, managing ownership, and granting access to specific user groups.

• Distributed Tableau reports in various formats, such as Packaged Workbooks and PDFs, to different user communities.

• Designed and implemented MapReduce jobs to process data in various file formats like XML.

• Followed Test-Driven Development within an Agile methodology to ensure high-quality software delivery.

• Developed horizontally scalable APIs using Python Flask.

• Worked with cloud providers and APIs, including Amazon Web Services (AWS) components such as EC2, S3, VPC, and GFS storage.

• Tuned and optimized complex SQL queries and managed data ingestion, querying, processing, and analysis for big data.

KOUSHIK North York, ON 647-***-**** ad2zrg@r.postjobfree.com Business Intelligence Analyst

Database Management • Data Visualization • Data Mining• SQL • Azure • AWS • Agile Methodologies SUMMARY

Professional Experience

• Achieved a 40% efficiency improvement by automating manual reports using Tableau and other ETL tools, resulting in a reduction of man-hours.

• Designed, developed, and implemented data models to generate meaningful insights and provided self-service analytical data visualizations to business users using Power BI reports.

• Collaborated with various users and stakeholders using Power BI to work with live data sources and generate insights based on business requirements.

• Created Power BI apps and linked them to live data sets for real-time analysis.

• Gained experience with Terraform for provisioning infrastructure on AWS, Azure, and GCP.

• Performed Extract, Transform, and Load (ETL) processes from source systems to Azure Data Storage services. Company: Tecordeon Software Private Limited May 2017 -August 2018 Designation: Business Intelligence Analyst

Role

• Develop a deep understanding of business and the key metrics to measure performance of Growth campaigns

• Extract required data from internal systems, develop reports and analyses them to derive insights and understand and monitor key trends in relevant metrics

• Communicate effectively with small teams, formal presentations, and at business unit events with engaging storytelling

• Develop written communications to address varied styles and information needs

• Build strong working relationships at all levels with internal clients and build problem-solving partnerships with clients and colleagues.

• Hands-on knowledge of database manipulation through environments such as MySQL.

• Proven ability in Python or similar

• Solid experience with machine learning and data mining

• Expertise in decomposing a problem and working through a technical approach and attacking a problem in a systematic way

• Experience working with digital product teams in an Agile environment

• Strong analysis and experimental design skills with a keen sense for data gaps and inconsistencies

• Experience managing data-driven research from project inception to client communication

• Experience in developing data visualization independently or with tools

• Self-starter with the ability to work in a constantly changing environment

• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Master in Applied Manufacturing Management

from Conestoga college.

Bachelors in Mechanical

From SR university

EDUCATION

Contact this candidate