SUMMARY

• 7+ years of experience in Information technology industry involved in a variety of stages which includes development, requirement gathering, planning and user acceptance testing.
• 5 + years of Experience as Business Analyst in Information Technology include understanding of Business Requirement Gathering, Business Analysis, and Joint Application Development (JAD) sessions with clients and referring to accessible documentation and procedure.
• Experience in Finance, retail and telecom domain
• 2 + years of experience in SQL developer, working on SQL Server 2005 and 2008, Validating change requests, modifying database structures, performing backup and restoring of databases.
• In dept. knowledge of Software Development Life Cycle (SDLC) methodology (such as Agile, Waterfall and RUP).
• Efficient in writing Business Requirements Document, Use Case Specifications, Functional Specifications and Workflows.
• Team Centric Business Analyst delivering highly valuable outcomes to delight Stakeholders.
• Excellent experience as a business analyst working with Business stakeholders, Product Owners, Development, DevOps and Quality Assurance teams to plan the releases/sprints.
• Extensive Experience in Functional, Integration, Regression, User Acceptance (UAT) testing.
• Strong experience in website development using hardcoded HTML and WordPress.
• Knowledgeable working with ETL process (Extract, Transform and Load) of data into a data warehouse.
• Experienced in creating Dashboards, pivot tables, speedometers for analyzing KPI in Excel
• Designed and implemented basic SQL queries for testing and report/data validation
• Effective communication with senior management and PMO office on sprint plans, velocity, backlogs, delivery schedules, risks, mitigation plans and other major updates.
• Proficient in Developing and executing Test Plans, Test Case, & Test Scenarios, also performing functional, usability testing and ensuring that the software meets the system Requirement.
• Experienced in process improvement using LEAN approach.
• Excellent working knowledge in Project Life Cycle and clear understanding of Project Management.
• Strong Experience as Agile Business Analyst in projects to create user stories, back logs, user interface design/prototypes with appropriate tools and work closely with scrum master, product owner and development teams to plan and deliver the sprint cycles.

TECHNICAL SKILLS

• Agile Principles • Value Based Prioritization • Story - Based Development
• SQL, Oracle • Mobile application • Development/QA Manager
• Use cases/User Stories • Iteration/Sprint Planning Meetings • Web Developments
• Prototypes • Task Meetings/Retrospectives • POS/Sales/Education

PROFESSIONAL EXPERIENCE

Confidential

Technical Business Analyst

Responsibilities:

• Technical BA Supporting multiple technical projects simultaneously
• Adhering to Agile development processes
• Using Jira and Confluence tracking and collaboration tools for day to day task
• Creating and maintaining system architecture diagrams (Rationale, OmniGraffle, System Architect, etc.)
• Developing business cases, functional and non-functional requirements for technical applications
• Assessing proposed solutions to determine which fit the business need, identify gaps and shortcomings in solutions and determining the necessary workarounds and/or changes to the solutions proposed
• Cultivating productive relationships with our partners in order to understand and translate their business requirements into functional and systems requirements supported by data model diagrams and attaching them to specific customer personas.
• Delivering the elements of systems design, including detailed requirements, data migration rules, business rules, wireframes, or other detailed deliverables.
• Reporting on common sources of technical issues or questions and make recommendations to product team
• Facilitating the negotiation of requirements amongst multiple stakeholders through design sessions, wireframes, and thorough documentation.
• Communicating with senior leadership and all the development and design teams involved
• Technical writing and the ability to quickly develop and deliver high-quality documentation
• Communicating (written/oral) with technical and non-technical personnel
• Working with web and/or mobile software development, QA and operations teams

Environment: Agile, Microsoft Office Suite, Confluence, UML, Windows 10, MS Visio, JIRA, SharePoint

Confidential

Business Analyst / Data Analyst

Responsibilities:

• Functioned as the liaison between the business finance team, operations, and the technical areas throughout the project life cycle.
• Developed business process models in Agile environment using TFS platform
• Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and Flow Charts to depict the data flow system for trade life cycle.
• Interfaced with the traders, brokers, business users, SMEs as part of requirements gathering and elicitation to finalize the project scope.
• Conducted JRD sessions with SME and manager to understand business processes, functionality detail.
• Assisted to create Product Breakdown Structure (PBS) for Capital market products like Equity, Bonds and other types of securities.
• Used Bloomberg platform for reconcile the reference data system
• Link the system with Bloomberg to get real time data like bid / ask prices for various securities
• Support data analysis efforts by providing data management support
• Use simple / complex SQL queries like joins, sub query etc. to access the financial products data from various tables in database.
• Use SQL to perform data analysis of capital market products of clients data like checking data quality, data profiling and data validation
• Check of any missing values of client data, portfolio data, and investment products data and if any treat them accordingly.
• Used SQL / Excel to sort and gather data pertaining to client portfolio investment accounts and various capital market products like Equity, Bonds & other type of securities
• Identified "As is" process and "To be" process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with the project roadmap.
• Created Mock-up forms in Just in Mind for better visualization and understanding of the GUI
• Assisted the Project Owner to develop both high-level and detailed application architecture to meet user requests and business needs.
• Used Microsoft SharePoint for efficient team collaboration and document management
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Conducted User Acceptance Testing (UAT) to ensure all the business requirements have been fulfilled by the application.
• Worked with development and testing teams to accomplish timely release objectives.
• Prepared user manuals and conducted training sessions.

Environment: Agile, Microsoft Office Suite, Confluence, UML, Windows 7, SQL Server management studio, Doors, MS Visio, JIRA, SharePoint

Confidential

Business Analyst

Responsibilities:

• Played the key role as a scrum master in the implementation and maintenance of various features but limited to search and order management functionalities of website, which generates millions of dollars Business every day.
• Managed and facilitated the development of a POS system, automatic quote generation system and a API integration in agile methodology.
• Facilitate to build requirements log (product backlog) and prioritize them.
• Coordinate with the Product Owner, Architect, Technical SMEs, Dev and QA Teams in support of Scrum Methodology.
• To conduct Scrum Daily standup, Product backlog, Sprint Planning, Sprint Review & Sprint Retrospective meetings.
• Determined the team capacity from historical data. Created Work Break down structure (user stories) and corresponding activities (tasks).
• Developed and followed agile project management plan.
• Closely interact with Product managers/owners, development team, QA team and track the progress of the sprint.
• Monitored the project progress and radiated the information to stake holders.
• Communicate milestones clearly to development and QA leads.
• Protect team from over-commitment, manage backlog, and prioritize resolution of defects/bugs.
• Work with the Dev and QA leads on the resource planning for the sprints.
• Identify and mitigate team risks and impediments (Blocking Issues, Critical Defects) on daily basis.
• Make sure the blocking issues and defects are resolved on time to meet the delivery.
• Work with Senior Management, Business & Release Management to understand the vision of the product, prioritize and develop software release planning.
• Communicate the progress to senior management on a regular basis.
• Monitor the Quality metrics and mentor the team though effective project management processes.

Environment: MS SQL Server 2005, 2008 R2, 2012, MS Access, TFS, SQL Query Analyzer, SQL Developer, Microsoft Visio, Microsoft project

Confidential

Web Analyst

Responsibilities:

• Designed the website for Confidential official TV channel, UFTV
• Designed and implemented websites from initial concept, site architecture, and user interface to finished deliverable
• Coded and implemented WordPress sites from Photoshop layout through html/CSS to a custom theme, functions, and plugins, Upgrading the website to current user requirements.
• Used revenue management to make sure that the project is completed with no additional costs.
• Developing the application to be a cross functional application to be used on both web and mobile platforms
• Design and implement new features, enhancements, and content of existing templates
• Maintaining and updating the website and YouTube channel with latest developments, videos and news
• Designing UI screens according to client requirements

Confidential

JR. Business Analyst

Responsibilities:

• Created and designed specifications as requested by sales and account management unit.
• Liaised with consultants and managers to document business processes effectively.
• Ensured that various appropriate infrastructure elements, including documents, periodicals, manuals, policy documents, etc are kept up to date and are available.
• Created and develop functional requirements of systems to improve quality, performances, external interfaces, and constraints.
• Supervise requirements traceability information and record requirements status in the course of the project.
• Monitor changes to baseline requirements with the use of effective application of change control processes and tools.
• Make contributions in the development of Test Plans and Test Scripts, and also perform test execution as required.

Confidential

Assistant Software Engineer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005 and 2008 also worked on Oracle database engine like 10g to provide the background data collection
• Validated change requests and made appropriate recommendations. Standardized the implementation of data
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning
• Handled and processing data over distributed server infrastructure.
• Streamlining the data centers over the network and making sure the data is properly being saved in the distributed servers
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server
• Updated the statistics information for both the old and new servers
• Provided back-end support for functional testing and performance testing.