Lead Business Analyst and Test Manager
The City of Calgary
Total years of experience :22 years, 9 Months
Implementation of COTS product for Facilities Management using Archibus
Elicit Requirements, Solution Design, Testing and verification and Implementation.
Tools: Jama, Jira, HP ALM, Automated testing using Sprinter.
Specific responsibilities include:
• Work on automating of work orders using COTS CMMS system that allowed customers and internal users to send issues related to facilities that are assigned, scheduled, resolved and archived.
Define daily, monthly, quarterly and annual metrics based on industry standards and available data.
• Elicit SMART functional, data and non-functional requirements via document analysis from previous phase, interviews and requirements workshops with myFM leads.
• Translate and verify business needs to high-level requirements (Epics / feature sets) based on input from previous phase prior to getting approval sign-off by stakeholders
• Define improvements to business processes, assist decision-makers in gathering information to make decisions and design user interfaces.
• Define set of requirements as a standalone document to outline what must be done by the organization to move to new CMMS and then prepare the user stories in a just in time approach for an agile team.
• Work closely with VAR/Vendor, IT and QA teams to ensure full understanding of the requirements and their business context.
• Write test case scenarios of assigned processes for QA team and provide BA support to Development and QA teams during build and test cycles.
• Troubleshoot and implement Agile Analysis, which includes communicating with stakeholders, working with development teams to configure and customize COTS software, providing direct feedback to teams, and using a quick and personal approach to solve business issues.
• Review test sets in HP ALM(HPQC) to ensure that they are properly aligned with the business processes as well as have direct coverage for requirements.
• Facilitate the UAT sessions to follow the use case scenarios and report the defects/feedback/comments for any deviation from the acceptance criteria.
• Facilitate and promote awareness of Agile principles and philosophy within the team for new members.
Specific responsibilities include:
• Elicit SMART requirements using interviews, document analysis, requirements workshops, business process descriptions, use cases, and swim-lane diagrams.
• Critically evaluate information gathered from multiple stakeholders, reconcile conflicts, functional decomposition of legal and compliance processes into details to a general understanding, and distinguish user requests from the underlying true needs.
• Derive requirements captured from various sources and facilitate Evolutionary prototyping, and functionality design to validate CLM solution requirements.
• Document the requirements using CLM workbook specifically designed for workflow, UI, Alerts and security components.
• Work with developers to ensure that any ambiguity is clarified to align with the actual requirements.
• Test the CLM features and report any bugs in Jira as per process defined by QA lead
• Facilitate the UAT sessions to follow the use case scenarios and confirm the requirements in the traceability matrix.
Specific responsibilities include:
• Lead set up of a new LOB focused on energy sustenance
• Developed feasibility plan using market research to identify Auto LED products that have demand in the target market
• Developed strategies to identify suppliers and preparation of RFQs with product technical specification using B2B platform
• Reviewed and evaluated contractual terms / Technical specification of Bid offers
• Procurement status reporting and forecasting based on the sales and customer feedback
• Defined and refined vendor qualification criteria that aligns with the company size, vision and market conditions
• Lead vendor management including constant follow-up on new product offerings as well as product enhancements
• ‘As-Is’ analysis of decades old legacy systems to understand the business processes, business rules, validations and other pertinent information due to lack of formal documentation and erosion of know-how.
• Perform gap analysis between the current state and future state to determine remedies, actions and proposals.
• Work on multiple complex projects across cross-functional teams and multiple client groups.
• Elicit requirements using variety of techniques such as document analysis, interviews, brainstorming and focus groups for the implementation of new systems that will eventually replace the legacy systems.
• Derive Business rules by executing the REST endpoints due to lack of documentation for decades old legacy system.
• Create and maintain Requirements Traceability Matrix to track the lineage of each requirement, including its backward traceability (derivation), its forward traceability (test cases) and its relationship to other requirements.
• Communicate written and verbal business requirements into technical language - service document and Input-Output mapping document
• Facilitate & assist the project team in prioritizing requirements to create release backlog as per the Agile philosophy practiced at Shaw.
• Collaborate with consumers and technical team to define application Oracle SOA based service integration scope and objectives.
• Identify and queue Oracle SOA integration solutions for corporate functions, business units and/or enterprise-wide functions.
• Collaborate with application owners to manage and administer the delivery of data to and from provider systems.
• Create provider-consumer-middleware documentation (IO mapping, service document, Error Catalog) based on the Telecommunication standards set by CableLabs and business processes practiced at Shaw.
• Analyze the requirements on data cleansing, data migration, validation rules, synchronization and reconciliation reports developed using .NET and web services for its consumption.
• Provide ad hoc as well as scheduled reports to business and data cleanse team using SQL queries by create dashboards for monitoring the data quality, reconciliation and exceptions.
• Perform code review after development is complete and assist UAT.
• Facilitate work between developers and testers for any bugs reported during UAT using JIRA.
• Assist project team in Risk Assessment, Change Management, Training and Planning activities with regular updates on portal.
• Advise clients in evaluating, selecting and implementation of best of the breed Enterprise Contract Management and Sourcing solutions that can streamline their processes, bring efficiency in place of their legacy systems while maximizing ROI.
• Elicit requirements using interviews, document analysis, requirements workshops, site visits, business process descriptions, use cases, and activity diagrams.
• Timely deliverables for multiple projects by multitasking and prioritizing activities.
• Perform gap analysis between the out-of-the-box functionalities of COTS and desired state in order to determine the customization required.
• Critically evaluate information gathered from multiple sources, reconcile conflicts, decomposition of features details to a general understanding while distinguishing user requests from the underlying true needs.
• Derive requirements from the information captured from various sources and facilitate evolutionary prototyping, and functionality design to validate requirements.
• Analysis and Design of ETL process for legacy contract meta-data, Terms along with attachments using proprietary tools e.g. BLU, Fast loader, SSIS.
• Configuration and testing of various areas in ECM and sourcing around reference data, reports, security and nightly jobs.
• Design and Configuration of InfoPath forms within Upside Contract Management Framework to directly connect to database/webservice using WSDL and integrate with external systems.
• Manage and administer of subsites, views, reports, configuration of workflows, lists, libraries, etc.
• Design, Analysis and Configuration of forms related to the contract management for pharmaceutical product using InfoPath designer and complicated workflow conditions.
• Use third party webparts from Corasworks, Bamboo and Nintex for enrichment of websites.
• Support migration of data from 2007 to 2010 using bulk loader tool
• Analysis and Design of pre-contract business rules that drive the workflow in selection of templates as well as dynamic list of approvers using Interview wizard or custom forms.
• Prepare IO mapping documents for integration between ECM and other enterprise applications e.g. LDAP, HR Systems, ECM, SAP SCM (BAPI)
• Lead project quality assurance activities, including performing technical QA reviews on components, code documentation and UAT.
• Facilitate client and internal meetings, present application architecture and design solutions. Supervise IT staff on project engagements.
• Provide support and instruction to less experienced co-workers, through classroom training sessions or on-the-job mentoring. Act as a mentor and assist or present training development environments to peers, customers and other stakeholders.
• Support and report to engagement manager while assigned to active customer engagements. Advise account manager on level of effort required to perform assigned implementations.
• Prepare, maintain and submit activity/progress reports and time recording/management reports in accordance with published procedures. Keep Engagement Manager informed of activities, alerting of any issues promptly. Provide knowledge transfer throughout and at the completion of assigned projects.
• Adopt and evolve solution accelerators to expedite ready-to-go implementation cycles.
Develop a good understanding of the project's requirements and document need for changes to requirements and communicate the impact of requirements changes.
Interact with business users to create business process flow and use cases to capture the functional requirements.
Lead project planning, scheduling, monitoring and reporting activities for the successful delivery of assigned projects within Law Department e.g. diCarta (Emptoris), electronic Invention Disclosure Form, Immigration Tracker, IP Master, etc.
Develop an understanding of the project management standards documented by the company PMO and ensures that all project standards are followed
Facilitate resolution to issues related to project requirements, scope, and change management
Utilizes established project change management processes and ensures appropriate execution and escalation
Ensure adherence to legally binding agreements
Creates the project plan and control status updates to the plan
Analyze and report on project progress and cost as measured against the project plan and budget
Assess and manage risk factors throughout the project
Identify and recommend contingency plans to address schedule revisions, risk, fund allocations, and work requirements
Work with the IT Manager to plan, direct, and manage the allocation of all project team resources
Create of communication plans, ensuring that appropriate information is exchanged among key stakeholders
Facilitate status review meetings among core and extended project team members
Design, manage, and administer SharePoint sites within Law Department.
Design and Architect Enterprise solutions based on InfoPath and SharePoint.
Interacting with the stakeholders to gather their “AS -IS” flow in reports.
Documentation of FSD’s with mockups for “To-Be” reports
Data Mapping for reports data elements from heterogeneous databases for consolidation.
Calculation of WAE (exception criteria at AE, BR and SY level) for SRCS program.
Layout of data elements (Mock-ups) for Proclarity, Actuate and Crystal Reports for Indirect and direct sales.
Writing QA Test Plans and Test cases for testing of reports.
Testing the reports and reporting defects using defect tracking system.
Maintaining logs of issues related to bugs and resolve them as per the business priority.
Managed the operations of computers and development systems that are critical to organisation which includes Geographical Information System \[GIS\], managed medium but dynamic databases with archival system.
Gather requirements from multiple business units, including Alban UK and Alban India.
Provide and review the design with the business and software team members from internal or external organization. Make sure various system components and business processes are working well together.
Provide Database design Specifications with necessary documentation to the GIS development team to suit the software as well as client requirements.
Managed the development of a new data management system that allows media planners, Ad agencies and media clients to have faster access to information with GIS modules. Improving executive Information Systems (DSS), and saving USD 50, 000 over vendor bids..
Developed strategic plans to address competitive advantages, actions plans, operational necessity for upgrades, and total estimated life cycle costs of integrating future technology.
Hire, supervise, motivate, and evaluate the performance of software engineers, network administrators, web designers, graphics designers, multimedia specialists, and hardware technicians.
Reduced cost 75% by installing the broad band internet through Cable Internet services to be used for intranet LAN for organisation’s internal usage.
Plan, prepare, and administer yearly budget for all IT functions.
Initiated and Built an advanced multimedia presentation team which enhanced the corporate presentations and image building of the company, resulting in tie-up with UK's media giant ALBAN.
Managed all aspects of automation within the organisation including LAN, Web Portal management, Servers / Workstations, and various databases like Oracle, MS SQL server.
Participating in these projects from start to finish allowing me to do the complete cycle through analysis as well as design and development, and testing. Be responsible for the development of web project integration with desktop version.
Worked with Visual Designers and Information Designers to bring the navigational structure to life within web sites and determine the appropriate level of interactivity/technology required for site content, audiences and browsers as per requirements of client.
Advanced positive image through public presentations. Experienced in joint application development, benchmarking, capacity planning, project and resource management, cross-functional team training.
Provided recommendation on various technologies and their benefits.
Worked in tandem with clients to get their requirements to be converted into fully functional software.
Increased the productivity by making converting the earlier foxpro application to java and oracle based environment.
Created new type of web sites using Flash, Dreamweaver and photoshop.
Received outstanding praise from management for completing web sites way before deadlines.
Two year full time management course affiliated to Mumbai University College topper for the final year amongst all streams.
Four year full time degree course affiliated to Mumbai University