Technical Business Analyst

• May 2022 - Present

Business Analysis and Support

• Feb 2020 - May 2022

• Conducted requirement gathering workshops to understand business process and business needs from a varied group of stakeholders for both web application and mobile application development. • Worked closely with business, system architect and development team to shape the direction of the complete solution architecture, and to provide support in delivering components. • Developed prototypes by creating screen designs for websites and mobile applications using Adobe XD and gain agreement and sign off from customer. • Clearly articulated and produced Business Requirement Specification(BRS) and Functional Requirement Specification(FRS) document in the form of AS-IS and TO-BE and including process diagrams using BPNM Bizagi modeler tool. • Translated business needs into product requirements with clear, concise and testable user stories using JIRA. • Provided assistance in QA testing by reviewing test scripts to ensure all functional requirements are being tested and carried out and show through of deliverables to customer. • Monitored test plans and test strategies and performed defect management and bug tracking using JIRA. • Contributed to the team's understanding of the user stories and prioritization during sprint planning meetings. • Provided ongoing support to the business and interrogated databases to support post production issues. • Documented release notes, user manuals and built knowledge repository for several projects in Sharepoint. Show less

Business Analyst

• Mar 2016 - Jul 2019

• Requirement Gathering and Analysis: A complete experience of Requirements Engineering (RE) framework which encapsulates a rigorous approach to requirements definition in both Agile and waterfall development process. • System Analysis: In depth understanding of the ‘Prophet’ product and its various functionalities. • Gap Analysis: Understand the client requirements and the purpose behind to come up with a feasible solution to satisfy their requirements. • Client interactions: Directly interact with the clients to gather the requirements and understand the business perspective for their requests to be able to offer feasible alternate solutions. • Solution Designing: Create functional solution write-ups in response to the requests raised by the Clients. • Business Case development: Create Business cases for the requirements at hand, which includes current system analysis, data analysis, Risk & Impact assessment and Recommendations for way forward. • Co-ordination/Partnering with Development and Testing teams for operational synergies - Worked closely with Subject Matter Experts, software development and testing team members to design and develop robust solutions to meet Client requirements for functionality, scalability and performance. • Solution walkthroughs - Present the solution designed to the internal teams and upon solution implementation; present it to clients with all the relevant stakeholders. • UAT support and business sign off on solutions - Post solutions/ builds delivery to the client, provide support during SIT and UAT phases. Show less

Senior Software Engineer

• Jan 2014 - Aug 2015

BI/SQL Development Lead, leading efforts for data extraction and cleansing using Snaplogic which is a Cloud based integration tool. The objective of the role was to provide Optimised prescription data for Pharmaceutical marketing campaigns. • Coordinate and produce technical vision, design and estimates in response to tenders and proposals. • Understand existing business model, customer requirements and preparation of functional design document and Data mapping Documents. • Involve in requirement gathering phase, analysis, preparation of Technical Design Document. • Develop ETL packages to load data through Snaplogic ETL to Nexxus Marketing product. • Performance Tune SQL Query where needed, analyze and troubleshoot issues for quick resolution. • Document Unit Test and System Integration Test plan and maintain highest of standards throughout the project. Show less

Senior Software Engineer

• Jun 2013 - Jan 2014

MSBI/SQL Developer for Security project , the objective was to enable Product Delivery to visualise Vulnerabilities and threats and other insights. • Define the acceptance criteria for user stories and requirements to ensure clarity following Agile Scrum methodology. • Gain a thorough understanding of the clients’ business and be able to gather, refine and articulate their analytical needs, using a defined methodology including workshop facilitation and discussion with BA's. • Work with Business Analysts to prioritise the product backlog and defects based on business value. • Gather data across different systems using SSIS and SQL to generate insight into businesses. • Create dashboards to help Leadership team to visualise vulnerabilities and remediation and its impact on the business. Show less

Associate - Projects

• Nov 2009 - Jun 2013

MSBI/SQL Developer to provide data extraction cleansing and analysis to provide insights on Cost/Revenue Analysis using MSBI for Centrica(British Gas)• Created SSIS Packages to integrate data coming from Text files and Excel files.• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.• Created SSIS/DTS packages to copy tables, schema and views and to extract data from Excel, text files Show less

Programmer Analyst

• Jan 2007 - Nov 2009

MSBI/SQL developer to perform development activities in data extraction cleansing and analysis for applications related to Quality management system and Billing systems• Analysis of massive data using SQL, MS Excel & SSAS.• Helped clients to get insights from their data.• Handled clients in both technology & energy sector.• Clean, transform and convert data using SSIS and load data to relational tables.• Migration of Legacy DTS packages to SQL Server 2008 using Business Intelligence SSIS Packages.• Importing & Exporting of data from multiple source like text, CSV, HTML, XML• Designing and planning BI solutions.• Creating Dashboards & visualization for the insights using SSRS.• Conducted market research and prepared analytical reports. Show less