Sudha Manian
Mississauga,Canada
Summary
Experienced Senior BI/ETL developer with nearly 15 years in Agile (Scrum) and Waterfall SDLC models, excelling in Database (Oracle, MS SQL), ETL (SQL loader, Informatica, SSIS), and reporting tools (POWER BI, SAP Crystal Reports, SAP Business Objects, SSRS). Strong MS-SQL programming skills for complex queries, and adept at leading and mentoring teams, facilitating seamless communication, collaboration, and delivering high-quality data solutions. Background includes data mining, warehousing and analytics. Proficient in machine and deep learning. Quality-driven and hardworking with excellent communication and project management skills.
Overview
18
18
years of professional experience
5
5
Certification
Work History
Sr. BI/ETL Developer – Data Management & Data Quality
Arterra Wines
Mississauga , ON
01.2022 - 08.2023
- Analyze and enhance ADF pipelines to support quality checks and data inconsistency during data load
- Develop exceptional Power BI reports and dashboards from various sources, including Data model, Raw data (Json, Parquet,.csv and Excel files) for validation and quality control
- Develop, enhance and supervise the daily data loads in ADF pipelines, ensuring data quality control and offering expert root cause analysis for load issues
- Conduct Data analysis, Data extraction, Data mapping, Data loading, data profiling and data classification (Azure Purview) for sensitive customer data
- Create Data models and Develop POWER BI Data validation reports to alert business on threshold breaches and write/enhance Oracle stored procedures to report data anomalies
- Utilize Power BI for visually engaging/interactive reports and dashboards, connecting to heterogeneous data sources not limited to Azure analytical services, Azure Synapse and Azure Blob storage
- Write DAX formulas for application on data models and performing intricate calculations to derive complex measures
- Utilizing Power Query to facilitate data transformation and manipulation.
Sr. IT Analyst
Cambridge Global Payments
10.2017 - 12.2021
- Provided exceptional Tier 3 support and maintenance for B2B FX front end applications and back-end issues
- Created stored procedures for complex business process, SQL agent jobs; designed tables following RDBMS rules
- Managed and spearheaded the process of backlog refinement and oversight, taking charge of prioritizing user stories, formulating acceptance criteria, and steering testing and delivery efforts of one of the Major Brand change and product release for CGP(CORPAY) Reduced incident occurrences by 20% through guided solutions and ongoing monitoring and by mentoring the business in implementing less technically complex solutions
- Actively contributed to product management and roadmap development for product launches and enhancements
- As Acting product owner, worked with agile team, including project managers, business analysts, developers, UX designers, and business stakeholders, ensuring comprehensive understanding of requirements and on-time product deliveries
- Collaborated with business partners to design and develop data models, Crystal Reports, Tableau reports, and application enhancements that align with user needs
- Implemented Agile and Kanban methodologies to ensure transparent project management in Production Support and Development, leading cross-functional teams during sprint planning and review meetings.
Analyst / BI Developer
Morneau Shepell
07.2014 - 10.2017
- Thrived in the development and testing of reporting and ETL solutions across a diverse BI toolset
- Worked with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008
- Worked on Control Flow Tasks, Data Flow Tasks and Dataflow Transformations to build SSIS packages including For Loop and For Each Loop containers with Execute SQL and Script Tasks
- Write complex stored procedures in MS SQL and packages for implementation of business logic and cost calculation for plan and benefits and extract data for client reporting and analysis
- Converted/replaced and Automated 100+ legacy reports from Complex SQL & Stored Procs into SSRS, as a part of reports optimization; Configure benefits system, develop HR / payroll data import jobs and PL/SQL based data export jobs; create, Execute and monitor SSIS packages to extract data from heterogeneous data sources and export them to excel and DataMart as per client requirements
- Develop new SSRS reports, enhances existing reports, creates dashboards and handles complex parameterized reports and sub-reports in SSRS.
Senior BI Developer
Cognizant
01.2012 - 01.2013
- In a leadership capacity, I managed the project of migrating more than 50 legacy Crystal Reports while also taking the lead in the development of DataMart’s and Universes using SAP BusinessObjects Web Intelligence (SAP BO WebI)
- Created SAP business objects Web Intelligence reports using variables, breaks, sections, ranking, sorting, drill down, slice and dice with reports having charts and crosstabs
- Design and developed Data Mart SAP WebI universe, as per the agreed design
- Prepare entity relationship diagram and define primary key and foreign key constrains, measures, dimensions, their hierarchy and granularity for the DataMart
- Enhanced performance of reports using alias tables, contexts and short cut joins, eliminating Cartesian products; worked on BOE to schedule, deploy and run the Business objects reports in info view and CMS.
Technical Onshore Lead
Cognizant
01.2011 - 01.2012
- In a team lead role overseeing six offshore team members, I took charge of offshore delivery for both development and enhancement teams
- I efficiently coordinated and scheduled release procedures in collaboration with multiple IT sector teams within our asset servicing division
- Development, enhancement, maintenance and testing of ETL process using PL/SQL - SQL loader & control files and custom application for asset servicing
- Completed pilot project to compare and submit the advantages Informatica over SQL data loader script and to check the compatibility with the existing legacy systems
- Preparing detailed technical specification for the Dataflow, DataMart and Reports based on the client requirement Successfully completed a time-sensitive and critical migration project focused on asset servicing statements for major banks, encompassing approximately $150 million in assets
- This project was not only time-sensitive but also of utmost importance Mentored offshore team on the migrated application, serving as the subject matter expert (SME) for the application
- Additionally, I compiled a manual for operational procedures and troubleshooting critical issues within the application
System Analyst
Cognizant
01.2006 - 01.2011
- Responsible for the data load from an OLTP source to the OLAP/ DataMart using transformation and logics to filter out required data and apply business logic to the data, before loading them to main database
- Monitor overnight data load, cleanse the data if there any exceptions during data load and load them back to staging table and provide production support for asset servicing applications
- Created complex Business Objects Web I reports with charts and crosstabs (bar and pie charts)
- Developed treasury web modules in Java /J2EE with Oracle as back end & Experienced in Eclipse and RAD Framework for building GUIs; screened with HTML -CSS style sheet and developed UI screens in CORE Java for custodial services.
Certification
- Microsoft Certified: Power BI Data Analyst Associate, 2023
- Oracle Certified Associate (SQL and Pl-SQL), 2011
- SAP Certified professional in Crystal Reports 2008, 2012
- SAP Certified in BO WEBI XIr3, 2013
- SUN Certified Java Professional, 2007 - 2008
- Certified Scrum Product Owner, 2019 - 2020
Skills
- SQL loader
- Data Migration
- Technical Support
- Informatica
- ADF pipelines (Azure Data Factory)
- SSIS
- SQL Programming
- ETL Modeling
- Data Warehousing Expertise
- Report Generation
Education
Bachelor of Electrical and Electronics Engineering (BE. Eng) -
Anna University
Personal Information
Title: Senior BI/ETL Developer
Languages
English
Full Professional
Timeline
Sr. BI/ETL Developer – Data Management & Data Quality
Arterra Wines
01.2022 - 08.2023
Sr. IT Analyst
Cambridge Global Payments
10.2017 - 12.2021
Analyst / BI Developer
Morneau Shepell
07.2014 - 10.2017
Senior BI Developer
Cognizant
01.2012 - 01.2013
Technical Onshore Lead
Cognizant
01.2011 - 01.2012
System Analyst
Cognizant
01.2006 - 01.2011
Bachelor of Electrical and Electronics Engineering (BE. Eng) -
Anna University
- Microsoft Certified: Power BI Data Analyst Associate, 2023
- Oracle Certified Associate (SQL and Pl-SQL), 2011
- SAP Certified professional in Crystal Reports 2008, 2012
- SAP Certified in BO WEBI XIr3, 2013
- SUN Certified Java Professional, 2007 - 2008
- Certified Scrum Product Owner, 2019 - 2020
Similar Profiles
Parvinder SinghParvinder Singh
Picking Associate at Arterra winesPicking Associate at Arterra wines
Eric Cesar De Mello Da SIlvaEric Cesar De Mello Da SIlva
Sales Associate at Arterra Wines CanadaSales Associate at Arterra Wines Canada
Logan ElingLogan Eling
Real Estate Salesperson at Arterra Luxe Collection LLCReal Estate Salesperson at Arterra Luxe Collection LLC