Chitra Roy Email & Phone Number

Canada

Toronto, Ontario

• Developed and maintained Power BI dashboards to provide business insights, track KPIs, and support operational decision-making.
• Automated data transformations and reports using Power Query in Power BI, streamlining manual workflows.
• Created Pivot Tables to dynamically group, filter, and sort data for better visualization and analysis.
• Utilized macros to streamline the process of importing and cleaning data, ensuring consistency and accuracy across reports and dashboards. reporting to the Commercial Planning manager and territory managers.
• Developed and optimized macros in Excel to automate data preparation, report generation, and repetitive calculations, significantly reducing manual work.
• Created macro scripts to handle ad-hoc requests and perform automated tasks, including data aggregation, formatting, and summarization.

• Analyze existing business processes and workflows that align with business requirements and ensure effective execution of development and infrastructure changes.
• Utilize the ServiceNow platform to configure and customize workflows, manage change requests, and streamline service delivery processes.
• Use Jenkins for building, fetching Git repositories, testing, and validating software projects, ensuring efficient and automated software development processes.
• Coordinate with development and operations teams to ensure the proper configuration and running of Jenkins pipelines for continuous integration and delivery of software changes.
• Run end to end application testing, Regression testing, Functional Testing to validate solutions against business requirements and ensure high-quality delivery of development and infrastructure changes.
• Create detailed documentation, release notes, functional specifications, use cases, process flows, and user stories, to communicate requirements and solutions effectively.

• Contributed to client data analysis, data cleaning, data mapping, and business logic testing within the Capital Markets and Wholesale Client Onboarding team.
• Built interactive Power BI dashboards to visualize client data, enabling teams to identify trends and patterns effectively.
• Applied VLOOKUP functions to cross-reference client information and validate data accuracy across multiple sheets, enhancing the reliability of business insights.
• Created macros in Excel to automate data masking processes, ensuring sensitive information was securely handled and anonymized before analysis and reporting.
• Created and utilized macros to automate repetitive tasks in data mapping and analysis, ensuring consistent data quality and efficient processing for business reports.
• Developed SQL queries on Oracle databases to generate business reports, providing data-driven insights to stakeholders.

• Assist the enterprise architecture team with a wide range of activities in areas (business, data, application, technology, security)
• Conduct the collection of information, conducts analysis, and present findings
• Contribution to the development of business documentation and models.
• Interact with internal and external stakeholders to understand and document requirements, evaluate options, and communicate recommendations
• Develop project plans, coordinate the implementation of activities, and monitor and report progress

Toronto, Ontario, Canada

• Trained on handling customer queries, workplace ethics, handling transaction, proper attention to detail on customer reports and feedback as an experienced retail associate.

Toronto, Ontario, Canada

• 1 and a ½ years of experience in retail merchandising for RONA as a merchandising team lead. Working as lead on mega-selling events, yearly inventory updates, summer promotion.

Ontario Collège Advance Diploma, Software Engineering Technology (Artificial Intelligence)

Master'S Degree, Geography And Cartography

Bachelor'S Degree, Geography