Prateek J Email & Phone Number

Vancouver, British Columbia, Canada

• As a Technical Business Analyst at Traction Rec in Vancouver, BC, I specialize in leveraging my extensive experience in RUP methodology to drive iterative and incremental development across complex projects. My role involves close collaboration with development teams to clarify functionality, resolve issues, and ensure strategic alignment with business goals.• I have successfully led the migration of transactional databases to Azure Cloud, utilizing SQL Server Stretch Database and advanced business data modeling techniques. My expertise in UML and visual modeling has been instrumental in documenting system design and architecture, while also re-engineering functional flow diagrams to optimize system performance.• In addition to technical skills, I excel in project management, coordinating work plans, scheduling resources, and running status meetings to ensure projects are delivered on time and within scope. My strong analytical skills enable me to evaluate existing systems, introduce innovative features, and thoroughly test applications to enhance performance.• With a focus on continuous improvement and efficiency, I actively engage with stakeholders and Subject Matter Experts (SMEs) to gather and document functional requirements, define business processes, and identify areas for improvement

Markham, Ontario, Canada

• Led surveys and questionnaires to capture business user feedback, ensuring IT solutions aligned with user expectations and enhanced UI/UX design.• Facilitated JAD sessions and workshops to gather and document business and functional requirements, collaborating with cross-functional teams.• Applied RUP methodology throughout SDLC phases, focusing on requirement gathering, design, testing, project management, and configuration management.• Spearheaded the migration of on-premises databases to Microsoft Azure Cloud, optimizing performance and data management.• Conducted GAP analysis and developed Traceability Matrices to ensure alignment between requirements and test cases.• Tested complex SQL scripts for Teradata database, supporting the creation of a BI layer on the data warehouse for Tableau reporting.• Played a key role in transitioning to IT-supported Business Intelligence Data Mart, facilitating data-driven decision-making.• Operated within a Scaled Agile Framework (SAFe 4.0) environment, integrating DevOps practices and enhancing team agility.• Collaborated with scrum teams to translate functional requirements into system specifications, including Java microservices in Azure Cloud.• Implemented Continuous Integration and Continuous Deployment (CI/CD) pipelines, streamlining the development lifecycle.• Integrated Azure AD with Salesforce to improve customer sign-in processes, enhancing system security and user experience.• Extensively utilized SharePoint for team communication, document sharing, and version control, ensuring smooth collaboration and project tracking.• Served as a peer review member, ensuring the accuracy and completeness of technical and business documentation.

Played a key role in translating complex business requirements into technical specifications, ensuring the successful deployment of financial management software.• Conducted and documented User Acceptance Testing (UAT) for newly developed applications, aligning testing outcomes with business objectives and technical standards.• Provided ongoing production support, troubleshooting and resolving technical issues to ensure seamless operation and user accessibility.• Developed advanced SQL queries, performed in-depth data analysis, and generated detailed reports from financial management applications to support data-driven decision-making.• Created comprehensive Business Process Models using top-down, leveled techniques, representing both high-level business activities and detailed procedural workflows.• Collaborated with the CRM team to gather and document functional and non-functional system requirements, ensuring technical feasibility and alignment with business goals.• Led Joint Application Development (JAD) sessions, facilitating discussions between business stakeholders and technical teams to ensure accurate scoping and system architecture alignment.• Maintained and enhanced the Insurance Analyst process, detailing rating requirements using Advanced Quality System (AQS) and assisting in the development of user stories.• Executed comprehensive testing phases, including Functional System Testing, Integration Testing, and Regression Testing, utilizing manual Black Box Testing techniques.• Developed and executed UAT plans with extensive test cases, recorded defects using Rational ClearQuest, and engaged in iterative testing cycles to ensure system robustness before production deployment.

Evaluated and optimized business processes and financial management applications, identifying opportunities for automation and improvement to enhance operational efficiency.• Collaborated with financial management, accounting teams, and developers to plan and execute application development and upgrades, ensuring alignment with business objectives.• Led Joint Application Development (JAD) sessions, utilizing MS PowerPoint to present and refine requirements with stakeholders, facilitating clear communication and consensus.• Developed interactive simulations using real-time data, working closely with designers and software developers to ensure the application functionality met user needs and expectations.• Authored detailed functional and technical specifications, ensuring accurate requirement translation and seamless communication with development teams.• Managed project schedules and deliverables using MS Project, coordinating timelines and milestones for successful project completion.• Created comprehensive development plans encompassing functional specifications, use case modeling, risk assessment, and workflow documentation.• Utilized Rational Requisite Pro for requirements management, establishing and maintaining a Requirements Traceability Matrix to track project scope and deliverables.• Conducted defect tracking and change control procedures using Rational ClearQuest, while managing configuration and version control through Rational ClearCase.• Developed and executed detailed test plans and cases, coordinating with the QA team to validate new features and enhancements, ensuring high-quality deliverables.