Bhavna Panwar
Auckland,Mount Wellington
Summary
Proactive and goal-oriented professional with excellent time management and data-driven problem-solving skills having 3+ years of experience in analytics, business strategy & consulting. Known for reliability and adaptability, with swift capacity to learn and apply new skills. Committed to leveraging these qualities to drive team success and contribute to organizational growth.
Overview
6
6
years of professional experience
Work History
Business Consultant
CGI
03.2022 - 02.2024
- Provide application support to major Canadian banks, primarily responsible for Scotia bank
- Schedule regular calls with clients to address ongoing issues, demonstrating effective client management skills and maintaining a consistent 10/10 rating for overall performance
- Execute DFAR (Data Fix) requests from clients, ensuring timely and accurate resolution
- Work in a high-pressure, multi-technology production support environment, demonstrating the ability to analyze, troubleshoot, and resolve production incidents by examining code and logs
- Effectively communicate and interact with both business and IT management, providing regular status updates on incidents and issues
- Possess a strong working knowledge of programming languages and relational databases, such as UNIX scripts, SQL Server, and DB2
- Act as a technical troubleshooter across the Finance IT application portfolio, ensuring prompt and accurate resolution of incidents
- Manage and resolve production incidents raised by application users within the defined Service Level Agreements (SLAs)
- Monitor application incident queues actively and collaborate with assigned analysts to track progress in incident resolution
- Log and consistently review incidents to identify trends and common root causes
- Ensure that team members understand the processes to mitigate, remedy, and prevent recurrences of outages
- Continuously evaluate and recommend enhancements and optimization opportunities for production processes
- Play a vital role in preventing and resolving production disruptions, managing risk, improving support effectiveness, and driving technical process improvement
- Proficient in utilizing advanced tools such as WinSCP, Jenkins, Jira, and Confluence
- Demonstrate strong problem-solving abilities and possess excellent communication skills.
- Collaborated with cross-functional teams to ensure seamless execution of complex projects while meeting all stakeholders'' expectations.
- Built strong relationships with clients by consistently delivering actionable insights.
IT Production Support
Honda of Canada Mfg
10.2021 - 03.2022
- Support the implementation of production hardware and equipment such as scan guns and mounting equipment
- Run scripts on the terminal window to start and stop KVM servers using the TightVNC remote platform
- Assist in implementing new code and communication interfaces for the production floor
- Resolve technical issues while providing excellent customer service and effective communication with users
- Configure corporate smartphones for email and access to business applications
- Provide support and deployments for Microsoft Teams and Office 365
- Manage file restoration, file and folder permissions, and Active Directory
- Troubleshoot printer issues and administer the Print Server
- Assist and manage Cisco Video Conferencing equipment, scheduling, and execution
- Conduct asset management and tracking
- Troubleshoot issues related to Java, internet browsers, and Citrix for web-based enterprise applications
- Familiarity with Microsoft server management tools, including Active Directory, DHCP, DNS, and file and folder permissions
- Respond promptly to production system hardware and software issues on the production floor and over production radio
- Execute PPA (Production Process Availability) and recovery procedures to ensure continuous system operation
- Document incidents in detail, including timelines and root cause analysis using ServiceNow
- Participate in meetings, take notes, and communicate relevant information to stakeholders
- Support IT management through scheduling and cost control
- Assist the Service Desk during overflow periods as needed
- Ensure a customer service-focused approach by meeting or exceeding SLA (Service Level Agreement) expectations.
Data Scientist
Over the Bridge
12.2019 - 04.2020
- Participated in a study called “Post-Post Performance Mood Responses (PPMR) in Musicians: How Emotional Highs and Lows are Managed Backstage” under the McMaster University ethics guidelines
- Worked extensively to analyze the data collected from the survey, to evaluate when musicians have positive or negative mood responses after performances and identify how positive or negative mood responses are managed
- Created data visualization graphics, translating complex data sets into comprehensive visual representations
- Write complex SQL queries to extract and integrate data from multiple database sources
- Build analysis reports/dashboards using data visualization tools, such as Tableau, Power BI and SAS
- Implemented NLP algorithm for extracting meaning out of the multiple lines text data (theory and approaches of applied linguistics, statistic, and NLP tools)
Data Analyst
LanceSoft
04.2018 - 05.2019
- Worked in an Agile environment, with an ability to accommodate and test the newly proposed changes at any point of time during the release
- Worked on database testing, wrote complex SQL queries to verify the transactions and business logic
- As Architect delivered various complex OLAP databases /cubes, scorecards, dashboards, and reports
- Created monthly and quarterly business monitoring reports by writing Teradata SQL queries includes System Calendars, Inner Joins and Outer Joins to retrieve data from multiple tables
- Presented data and complex analyses into stories understood by business leads
- Reviewed and modified SAS Programs, to create customized ad-hoc reports, processed data for publishing business reports
- Performed cluster analysis to find segmented profiles of different process and vendors for selection
- Prepare the data rules spreadsheet using MS Excel that will be used to update allowed values, findings, and profiling result
- Imported data from multiple data sources into Excel workbook, created relationships between heterogeneous data, created calculated columns and measures using VLOOKUP and formulas, built Pivot Tables and Pivot Charts using Power Pivot skill
Education
Post Graduate Degree - Artificial Intelligence
Durham College
Oshawa, ON04.2021
Post Graduate Degree - Big Data Analytics
Georgian College of Applied Arts And Technology
Barrie, ON04.2020
Bachelor's Degree - Computer Science & Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
2015
Skills
- Programming Languages: SQL, Python (Matplotlib, NumPy, Pandas, Scikit-Learn, TensorFlow, OpenCV),SQL analytics, Unix/Linux
- Database Systems: MySQL developer
- BI Tool: Tableau, Power BI, Advanced Microsoft Excel
- Soft Skills: Communication and Presentation skills, Problem-Solving, Attention to detail, Time Management
- Certification: Data analysis with Python Coursera
Timeline
Business Consultant
CGI
03.2022 - 02.2024
IT Production Support
Honda of Canada Mfg
10.2021 - 03.2022
Data Scientist
Over the Bridge
12.2019 - 04.2020
Data Analyst
LanceSoft
04.2018 - 05.2019
Post Graduate Degree - Big Data Analytics
Georgian College of Applied Arts And Technology
Bachelor's Degree - Computer Science & Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Post Graduate Degree - Artificial Intelligence
Durham College
Similar Profiles
Shloka TukeShloka Tuke
Senior Test Engineer at CGISenior Test Engineer at CGI
SELVAM SARAVANANSELVAM SARAVANAN
Simcorp Dimension Consultant at CGISimcorp Dimension Consultant at CGI
Sri Harsha BhogapurapuSri Harsha Bhogapurapu
Lead Engineering Consultant @ PNC at CGILead Engineering Consultant @ PNC at CGI