Gunjan Joshi

Industry: Retail Pharmacy | Sector: Retail Pharmacy
Competency Area: Data Migration Discovery Lead

• Team Leadership: Led workshops with over 15 stakeholders to kick off data migration discovery phase, ensuring all members were aligned with project goals, resulting in a 25% increase in project efficiency.
• Data Inventory and Assessment: Conducted a thorough inventory and assessment of existing data systems, identifying key data sets for migration and reducing redundant data by 30%.
• Stakeholder Requirements Gathering: Engaged with senior executives and key stakeholders, collecting and documenting business requirements and migration objectives, achieving a 95% satisfaction rate.
• Risk and Compliance Analysis: Identified potential data risks and compliance issues, developing initial mitigation strategies that ensured data integrity and regulatory adherence, reducing compliance issues by 20%.
• Preliminary Migration Plan: Developed a preliminary migration roadmap outlining critical milestones, resource allocation, and projected timelines, which improved project planning accuracy by 35%.

Industry: Financial Sector: Banking Competency Area: Data Migration Assessment Lead

• External Interviews: Conducted comprehensive interviews with over 10 external system integrators to understand current data migration capabilities, tools, and methodologies, enhancing selection process efficiency by 40%.
• Assessment Report Preparation: Prepared a detailed assessment report outlining current state of data systems, migration plan, and identified gaps, contributing to a 30% reduction in migration-related issues.
• Best Practices Deviation Analysis: Analyzed existing data migration processes, highlighting deviations from industry best practices, and identifying areas for improvement, which increased migration efficiency by 25%.
• Recommendations for Improvement: Developed and presented actionable recommendations to senior management for aligning data migration strategies with best practices, enhancing data integrity, and ensuring regulatory compliance, leading to a 20% improvement in compliance adherence.

Industry: Insurance Sector: Property and Casualty Competency Area: IFRS 17 Implementation Lead / Business Data Lead

• Led IFRS 17 engagements: Successfully led three separate IFRS 17 engagements lasting between one month to two years with distinct insurance clients, ensuring seamless implementation and driving financial efficiency, resulting in a 30% increase in compliance efficiency.
• Team Leadership: Spearheaded a high-performing team of 15 members in a critical regulatory engagement, optimizing collaboration and achieving project goals 20% ahead of schedule.
• Scrum Master: Demonstrated exceptional leadership as a Scrum Master, proficiently managing sprint planning and fostering agile methodologies within team, boosting productivity by 25%.
• Status Updates: Provided consolidated and insightful status updates across multiple workstreams, catering to various stakeholder groups and steering committees, ensuring clear communication and alignment, reducing miscommunications by 30%.
• Issue and Risk Management: Efficiently maintained a comprehensive program-level issue and risk log, proactively identifying, communicating, and monitoring risks for prompt resolution, reducing project risks by 20%.
• Program Schedule Management: Spearheaded creation and maintenance of an integrated program-level schedule for assigned workstreams, optimizing project timelines and enhancing overall project efficiency by 35%.
• Vendor Engagement: Skillfully engaged with vendors, providing accurate progress updates and risk/issue identification, ensuring smooth collaboration and vendor performance, improving vendor satisfaction by 20%.
• Quality Deliverables: Ensured timely and high-quality deliverables across all project components, maintaining a sharp focus on meeting and exceeding project goals and client expectations, resulting in a 95% client satisfaction rate.

Industry: Health Sector: Public Competency Area: COVID 19 – Supply Chain Reporting Lead

• Team Leadership: Led and mentored a team of two members, successfully delivering crucial reporting requirements during COVID-19 pandemic, effectively presenting real-time supply status updates, enabling informed decision-making, and improving reporting efficiency by 30%.
• Business Requirements Translation: Translated complex business requirements into precise technical specifications, facilitating seamless communication between stakeholders and development teams, reducing requirement clarification time by 25%.
• SSIS Package Implementation: Collaborated closely with developers to design and implement SSIS packages, streamlining data ingestion from diverse sources, and ensuring data accuracy and reliability, increasing data processing speed by 40%.
• Tableau Collaboration: Partnered with Tableau team to thoroughly understand reporting needs and deliver data in specified format, empowering stakeholders with actionable insights and visualizations, enhancing data-driven decision-making by 35%.
• Database Design and Implementation: Demonstrated exceptional skills in designing and implementing a semi-automated, fully functional database, providing an end-to-end view of supply chain during COVID-19 pandemic, playing a pivotal role in navigating supply challenges efficiently, reducing supply chain disruptions by 20%.

Industry: Financial Services Sector: Banking and Capital Markets Competency Area: Strategy and Operations Lead

• Team Leadership: Successfully led a high-performing team of three members, delivering two critical work packages with precision and efficiency, achieving a 30% reduction in delivery time.
• Business Use-Case Identification: Collaborated closely with Business Owner (AVP) to identify and define essential business use-cases for Big Data Hadoop Analytical Cluster, aligning technological solutions with business objectives, increasing solution accuracy by 25%.
• Business Requirements Documentation: Translated intricate business use-cases into comprehensive business requirements, meticulously documenting entire Business Process Map, ensuring clarity and seamless implementation, improving requirement documentation accuracy by 35%.
• Advocacy for Business Needs: Served as a proactive advocate for business, effectively liaising with technology and solution architecture groups to ensure alignment with business needs and objectives, reducing misalignment issues by 20%.
• Data Security and Compliance: Demonstrated a strong commitment to data security and compliance, engaging actively with control partners to address security, data loss prevention, and data access control restrictions, ensuring a robust and secure data environment, reducing security incidents by 30%.
• Collaboration Across Teams: Collaborated across portfolio and project teams, effectively identifying dependencies, gaps, and overlap of deliveries, streamlining processes, and promoting a cohesive and synergistic work environment, improving project integration efficiency by 25%.

• Translated business requirements into comprehensive solution designs, meticulously capturing and maintaining current and future state flows/interfaces and integration workbooks, which improved project execution speed by 25%.
• Prepared robust migration strategy and high-level design, creating solution diagrams and detailed design documents, ensuring smooth implementation of projects and reducing migration errors by 20%.
• Ensured data mapping accuracy between vendor and in-house applications, maintaining data integrity and alignment with architectural standards, resulting in 30% improvement in data accuracy.
• Conducted effective elicitation sessions, performing gap analysis of current state to identify opportunities for improvement, leading to 15% increase in project efficiency.
• Delivered interface agreements and application design documents adhering to CIBC technology standards, which enhanced documentation accuracy by 35%.
• Managed and tracked outstanding issues, proactively driving resolution to ensure timely closure of open items, minimizing project risks and reducing issue resolution time by 40%.
• Facilitated workshops with stakeholders, finalizing user requirements and translating them into clear and concise System Requirement Documents (SRD), improving project clarity and execution efficiency by 20%.

• Proactively engaged in product development as second employee of start-up company, managing client accounts and contributing to 50% increase in client acquisition within first year.
• Served as SME for Integration Desk platform, providing expert guidance and improving platform efficiency by 30%.
• Participated in weekly technical discussions and client meetings, facilitating effective communication and resolving 90% of technical issues within first discussion.
• Oversaw multiple Integration Desk implementations, ensuring on-time delivery and increasing project success rates by 40%.
• Coached and trained new hires on platform, reducing onboarding time by 25% and improving team productivity by 20%.
• Directed and supervised team of six engaged in back-end and front-end development, leading to 35% improvement in project delivery speed and 15% increase in overall team performance.

• Collaborated with clients and on-site project management teams, ensuring effective project planning and execution through regular interactions, leading to 20% improvement in project delivery timelines.
• Provided comprehensive and timely weekly status reports, maintaining transparent communication with stakeholders, which resulted in 95% stakeholder satisfaction rate.
• Conducted in-depth analysis of business requirements, gathering user stories, use cases, and both functional and non-functional requirements. Skillfully translated these requirements into robust Solution Design and Architecture Documents, enhancing project accuracy by 30%.
• Worked collaboratively with various application teams and vendors, analyzing applications, data flow, and architecture to develop tailored solutions that align with specific business needs, resulting in 25% increase in system efficiency.
• Created complex stored procedures and functions, effectively implementing business requirements, which improved data processing speed by 40%.
• Developed intricate reports using Crystal Report 2008, Microsoft SQL Server 2005/2006, and Oracle, contributing to comprehensive data analysis and insights, enhancing reporting accuracy by 35%.
• Actively contributed to several successful implementation projects, delivering results that exceeded client expectations and increased client retention by 20%.
• Provided top-notch technical support to government clients, promptly addressing high-priority issues and ensuring exceptional service delivery, maintaining 98% client satisfaction rate.
• Participated in both internal and client meetings, driving technical discussions and offering valuable insights in project overviews, which improved decision-making efficiency by 15%.

• Led entire development lifecycle for critical projects, from initial requirements gathering to design, development, rollout, and ongoing support and maintenance, ensuring successful delivery of projects worth over $1 million.
• Conducted engaging and informative demos for clients, showcasing developed functionality and gathering valuable feedback, which increased client approval rates by 30%.
• Created and implemented complex stored procedures, functions, and views, tailored to meet specific client requirements, enhancing system functionality and user satisfaction by 25%.
• Spearheaded performance optimization efforts, fine-tuning system to improve efficiency and user experience, resulting in 40% increase in overall system performance.
• Actively participated in rigorous testing and debugging processes, ensuring delivery of high-quality and reliable solutions, reducing bug-related issues by 35%.
  Provided exceptional client support, offering timely assistance and resolution for any ongoing issues, maintaining 95% client satisfaction rate.

• Developed ER diagrams and managed backup jobs, ensuring data integrity and availability for over 10 critical systems.
• Implemented error reporting alerts and triggers, reducing system downtime by 20% and improving issue response time.
• Designed over 50 stored procedures and functions, enhancing data processing efficiency and accuracy.
• Conducted T-SQL tuning and query optimization, improving query performance by 30% and reducing execution time.
• Designed comprehensive reports using Crystal Report and SSRS, enabling real-time data insights for 5 major business units.
• Analyzed existing SQL queries to identify opportunities for improvements, resulting in 25% increase in query efficiency.
• Developed, implemented, and optimized stored procedures and functions using T-SQL, achieving 40% reduction in processing time for key operations.