Manish Dua

Project: Data ETL (GWAM)

• Performed extensive data validation and fixes, including advisor fee analysis, CRS/FATCA updates, and AML industry corrections, ensuring regulatory compliance.
• Addressed data record discrepancies and improved reporting integrity through thorough requirement collection.
• Authored full documentation on production issue tables and fields in Confluence.
• Assisted in the change management by successfully completing training, ticket handling, and validation.
• Directed a team in a hackathon to discover business issues, implementing effective market data research solutions with AI and PowerBI.

Project: Light Year (LY GWAM)

• Facilitated data conversion and compliance activities throughout mock and go-live phases.
• Performed risk assessments, managed PII data, and designed project plans for Jira migration.
• Collaborated with product owner to devise agile strategy for product development and release management.
• Designed reports to share the data load volume and availability for analysis and dashboards using Power BI.
• Collaborated with data engineers in ETL support and orchestration process.
• Generated SQL queries to facilitate comprehensive data curation.
• Assisted in the curation of data from different sources, merging CRM (Salesforce) and Amazon transcript data.
• Coordinated with stakeholders and vendors to streamline communication and secure sign-offs for critical activities.
• Developed runbooks and use cases to facilitate smooth transitions, enhancing data integrity, and ensuring compliance with regulatory requirements.

Project: Voice of Customer (VOICE/John Hancock & GWAM)

• Supported the agile implementation of the Medallia platform. Collaborated with stakeholders to gather business requirements.
• Designed and developed data dictionaries and schemas. Troubleshot PII scrubbing models. Wrote scripts and SQL queries for data curation.
• Supported ETL and data orchestration processes. Built pipelines for automation.
• Coordinated production stages. Designed reports and dashboards.
• Strategized an Agile approach for development. Conducted UAT, and coordinated outcomes.

• Managed research and implementation of Salesforce CRM system.
• Evaluated existing company procedures and suggested ways they could be improved utilizing the full potential of Salesforce platform.
• Identified areas where existing business processes can be improved through automation or customization of Salesforce applications.
• Applied ETL strategies to gather and adapt data from older systems for seamless ERP integration.
• Coordinated with developers on coding best practices and standards while ensuring that all development is performed in accordance with established guidelines.
• Assisted users in troubleshooting issues related to Salesforce application usage and functionality.
• Oversaw the maintenance of a comprehensive repository of reusable knowledge resources.
• Integrated CRM data from Salesforce to minimize manual input.
• Leveraged PowerBI to enhance data visualization.

• Created project plans with established timelines, assigned to appropriate teams and managed workflow throughout construction.
• Led meetings with internal team members, consultants and contractors.
• Collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts.
• Build and designed risk assessment tool using SQL Management System.
• Created Database schemas and structures to support the risk engine model to store information from various sources.
• Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
• Streamlined reporting processes by evaluating data sources, compiling data and redesigning output.

• Collected data in field, evaluated findings and produced reports and presentations.
• Data maintenance and governance with SAP ERP system.
• User provisioning and CRM related Data access.
• Organized and executed strategies for migrating and consolidating data.
• Supported API integration within internal modules and business operational cloud and web services.
• Computed, recorded and proofread data in preparation of records and reports.
• Developed and updated SOPs for key functions and features of each system.
• Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
• Developed data models and database designs to plan projects.

• Data Lead for complete data migration from Legacy system to SAP ERP System.
• Serve as a liaison between Business and Functional areas and technology to ensure that data-related business requirements are defined to develop complete solutions, including data flows, business rules, and reporting elements.
• Manage the creation, implementation, and maintenance of master data (Vendor, Customer, Materials, Quality, Production, Finance Master Data, Supply Chain Data).
• Governed MDM with execution and implementation of 3 Data Phase.
• Cleaned, Manipulated, and optimized the legacy raw data.
• Data transformation from legacy files to migration cockpit templates and loading into the system.
• Pre-validation and post-validation Data plan executed with Business approval.
• Generated reports from SAP and integrated with PowerBI to develop dashboards for business insights.
• Assess data quality and collaborate with SMEs and cross-functional teams to facilitate data issue resolution.

• Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.
• Defined database design specifications based upon project requirements.
• Build Database using AWS and the schema tool for migration of the data.
• Performed quality assurance processes to support data warehouse improvements.
• Analyzed code and corrected errors to optimize output.
• Assessed code during testing stage to determine potential glitches and bugs.
• Recommended improvements to facilitate team and project workflow.

Clients:

AditumHealth https://aditumhealth.com

Designed the application and built analytical reports for patients and monitoring health via mobile app using interactive dashboard.

Bush Systems https://www.buschsystems.com/en-ca/

Major research project – Predictive analysis for the products and financials.

Napoleon https://www.napoleon.com/en/ca/welcome

Major analysis reports – Complete analytical results performing ETL process (Python-Pandas), massaging data and fetching it from different legacy system (Excel, quick books).

Designed high-level dashboards and hosted on client’s server

• Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
• Automated data mining (ETL) process from various resources using python.
• Contributed to maintaining VAULT database in conjunction with data development and software engineering teams.
• Designed, built, implemented and maintained REST API's for internal applications.
• Wrote scripts and processes for data integration and bug fixes.

• Planned and implemented automated testing scripts with Selenium (Java).
• Completed unit and regression tests on application designed by developers
• Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
• Documented, triaged and managed defects in Jira and worked with developers to facilitate timely resolutions.

• Major in Data Analysis

• Major in Computers and Programming