MOHAN KUMAR SURA
Toronto,Canada
Summary
Detail-focused Data Consultant having 4 years of software experience with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Seasoned collaborator experienced in meeting needs, improving processes, and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills. Data Consultant bringing exceptional abilities in competitor analysis, business intelligence development and trend assessment. Successful at promoting company advancements and boosting team performance. Consistently reaches revenue targets by reviewing accurate data and producing creative recommendations. Hardworking and passionate job seeker with strong organizational skills eager to secure Data Scientist position Ready to help team achieve company goals. Having experience in the development of Database & BI Reporting using technologies such as MSBI (SSIS, SSAS, SSRS), Power BI (DAX), Azure BI, IBM Cognos, and SQL Server. Prepared ETL processes according to business requirements and incorporated all business requirements into all design specifications. Good in Data Analysis with demonstrable proficiency with Microsoft Excel, including Query, Pivot Tables, macros, connections to external data sources, Data Analysis Expressions (DAX), REST API's, chart, T-SQL Queries and Complex Stored Procedures Communicated with key project stakeholders to ascertain project requirements. ACCOMPLISHMENTS Made recommendations on business intelligence tools and Python programming to cut processing time by a week. Expertise in constructing T- SQL, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule. Awarded with the "Bravo Award" in Capgemini for excellence in maintaining the Business Flow and Analyzing the transaction data. Used Microsoft Excel to develop inventory tracking spreadsheets. Documented and resolved Top Priority Incidents which led to continuity in the Daily Business Transactions. Developed methods to integrate Redshift and Power BI to significantly improve workflow efficiency.
Overview
6
6
years of professional experience
Work History
Data Analyst
Global University Systems Canada
08.2022 - Current
- Coordinated statistical data analysis, design, and information flow
- Developed an automated solution using Python to generate and streamline student finance reports, resulting in increased efficiency and accuracy
- Designed and implemented a robust data processing pipeline that extracts, transforms, and loads financial data from various sources into a structured format
- Leveraged Python libraries such as Pandas and NumPy to manipulate and analyze large datasets efficiently
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
- Integrated APIs and web scraping techniques to retrieve real-time data from external sources, ensuring up-to-date and accurate financial information
- Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results
- Developed ML algorithms to analyze huge volumes of historical data to make predictions
- Applied statistical and algebraic techniques to interpret key points from gathered data
- Leveraged analytics to drive business development, productivity and process improvement
- Developed data-gathering and reporting structures from ground up and strategized methods capitalizing on system features
- Scaled analytical capabilities across all business areas, evolving analytics to influence bank's strategic planning and executives' decision-making
- Modeled predictions with feature selection algorithms
- Developed a professional-grade Accounts Payable (AP) portal using Power Apps, leveraging its intuitive interface and low-code capabilities
- Integrated Power Automate workflows to automate key AP processes, such as invoice approval, payment processing, and vendor communication, reducing manual effort and streamlining operations
- Utilized SharePoint as a robust data storage and collaboration platform, ensuring secure and centralized access to AP documents, invoices, and related information
- Developed a detailed migration plan, including resource allocation, data transfer methods, and application migration sequencing
- Leveraged AWS services such as AWS Database Migration Service (DMS) and AWS Server Migration Service (SMS) to migrate databases and virtual machines, respectively
- Implemented best practices for security, scalability, and fault tolerance, utilizing AWS Identity and Access Management (IAM), Auto Scaling, and Elastic Load Balancing
- Produced monthly reports using advanced Excel spreadsheet functions
- Successfully established seamless connectivity between Amazon Redshift and Power BI, enabling efficient retrieval and analysis of data from Redshift for report generation
- Implemented data transformation and modeling techniques to ensure accurate and meaningful reporting
- Leveraged Redshift query optimization strategies and Power BI's data modeling capabilities to enhance data retrieval speed and report performance
- Utilized indexing and aggregation techniques to optimize query execution and improve overall reporting efficiency
- Implemented robust security measures to protect sensitive data, adhering to data governance policies and industry best practices
- Utilized Redshift's access control mechanisms and Power BI's role-based security features to ensure secure data access and maintain data integrity
- Collaborated closely with stakeholders, including data analysts, business users, and IT teams, to gather report requirements, incorporate feedback, and ensure the generated reports met their specific needs
- Provided training and documentation to empower end-users in exploring and analyzing Redshift data through Power BI
- Researched and resolved issues regarding integrity of data flow into databases
- Developed tables, views and materialized views using SQL
- Identified and documented detailed business rules and use cases based on requirements analysis
- Collaborated with Student Finance team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
- Monitored incoming data analytics requests, executed analytics, and efficiently distributed results to support Data Prediction strategies.
Capstone Project Team Leader
Solv4x.inc
01.2022 - 05.2022
- Worked with cross-functional team and supplier teams throughout PJM region energy resource departments
- Communicated technical information to variety of audiences
- Performed Machine learning models in predicting daily load usage of PJM region in USA
- Demonstrated leadership of complex projects and business acumen
- Built and evaluated business cases for product offerings
- Web scraped data using Python and created data suitable for performing Machine learning models
- Developed visualization and dashboard leveraging Tableau, Power BI to provide home insights into analytics.
Informatica and EDI Developer
Capgemini Technology Services
02.2018 - 11.2020
- Expertise in analysis, design, and development of end to end business intelligence solutions using the MSBI suites such as SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) & SQL Server Reporting Services(SSRS)
- Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS
- Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services
- Responsible for Creating and maintaining various database objects like stored procedures, Triggers, Tables, views and user defined functions using SSMS
- Documented technical requirements and project templates based on agile methodology
- Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc
- Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting
- Developed mappings, workflows and tasks using Informatica Power Center
- Created, updated and maintained Azure security standards and best practices across Azure domain
- Authored clear, concise and complete communications for change, incident and problem management
- Maintained and built VMs and containers through Azure and Azure Kubernetes Services
- Worked with developers to integrate resources within projects using Azure and Azure DevOps
- Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle DB etc.)
- Maintained Data warehouse, Created ETL Jobs, Created new database objects and SSIS Packages
- Created and maintained EDI customer maps
- Transmitted records and files to customers efficiently to maintain operational timelines
- Tracked files from origin to destination and troubleshot errors
- Trained customer service personnel in strategies for supporting electronic data interchange activities
- Designed and implemented Parameterized and cascading parameterized reports using SSRS
- Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically
- Extensively used custom R-Visuals, Clustered Bar Charts, Clustered Column charts, Donut Charts, Hierarchy slicers, Waterfall charts, Scatter charts, Area charts in Power BI reports
- Involved in creating robust complex power BI models, writing complex DAX logics involving rank, filters and data massaging
- Worked with visual filters, page filters, report filters and drill through filters in power BI reports
- Coordinated statistical data analysis, design and information flow
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources
- Participated and contributed to implementation of JIRA and Confluence in data warehouse
- Perform data cleansing, data massaging and data modelling for OLTP and OLAP database for master and transactional data
- Working on Microsoft Business Intelligence (MSBI) Technologies (SSAS (DAX, MDX), SSIS, SSRS) and Azure Data Factory, ADLA(U-SQL), Power Query, Azure Data Bricks & Power BI
- Extensively worked in data Extraction, Transformation and Loading data from source to target system-using SSIS
- Participated in requirements meetings and data mapping sessions to understand business needs
- Developed visualization and dashboard leveraging SQL and Tableau, Power BI to provide home insights into analytics
- Worked under AGILE methodology.
Education
For Business Decisions -
St. Clair College of Applied Arts And Technology
05.2022
Bachelor of Engineering Technology - Electronics And Communication Engineering
Jawaharlal Nehru Technological University
India 06.2017
Skills
- Microsoft Power BI
- Tableau
- AWS management
- Azure SQL Database, Azure Data Lake, Azure Data Factory
- Informatica power center 86x, Data stage
- JIRA and Confluence
- Microsoft Visio
- Microsoft Power apps
- Microsoft Power Automate
- SQL Server Management and Database Programming
- Tensorflow, Keras and Pytorch Libraries
- Visual Studio 2013/2015/2017,
Timeline
Data Analyst
Global University Systems Canada
08.2022 - Current
Capstone Project Team Leader
Solv4x.inc
01.2022 - 05.2022
Informatica and EDI Developer
Capgemini Technology Services
02.2018 - 11.2020
For Business Decisions -
St. Clair College of Applied Arts And Technology
Bachelor of Engineering Technology - Electronics And Communication Engineering
Jawaharlal Nehru Technological University