BUSINESS ANALYST Resume

SUMMARY:

IT Professional with over seven years of experience in all the phases of SDLC
Areas of specialization include -
Client Relationship Management
Conceptualization of business needs and translation into viable technical solutions
Documentation - Technical and functional
Report analysis and development
AGILE Methodology

TECHNICAL SKILLS:

Web Technologies: ASP.NET, VS 2010

Languages: C#.net, T-SQL

Databases: SQL Server 2005, SQL Server 2008

BI Tools: BIDS, SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS)

Reporting Tools: SSRS, RDLC, DevExpress, Crystal Reports

Requirements Management Tools: Agile project management tool in Team Foundation Server (TFS), Rally, and MS Excel

Documentation tools: Confluence (Atlassian Cloud), MS Visio, HelpNDoc and MS Word

PROFESSIONAL EXPERIENCE:

Confidential

BUSINESS ANALYST

Responsibilities:

Analyse business processes and user needs to create use cases
Conduct client meetings to understand functional and technical requirements
Analyse complex workflows and data issues
Defining solutions in collaboration with the Subject Matter Experts, technical team, Project Managers, and globally located Account Managers and Sales Managers
Develop functional/ technical design specifications (Software Change Requests - SCR) of the solution
Create mockups of proposed technical solutions and creating presentations of the proposed solutions
Assist Product Owner to prioritize and schedule software development tasks in rally
Assist software development team in ensuring requirements are addressed correctly. Create user stories for software development team in agile environment
Work with service teams to coordinate delivery of technical solutions to customers
Analyse reporting requirements and designing the mockup of the report based on underlying infrastructure. Estimate the report development efforts
Create custom reports using DevExpress reporting tool and writing complex SQL queries
Support tickets requiring urgent attentions to client questions/problems on ticketing system (Zendesk/Salesforce)

Confidential

BUSINESS ANALYST

Responsibilities:

Team management - Team selection, work allocation and team appraisal
Involved in business requirement gathering by conducting stakeholders interviews (Onshore)
Document clear and detailed Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) in accordance with guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
Develop Prototypes (screen mock-ups and wireframes)
Perform Gap analysis and identify business rules and interfaces;
Perform Failure Mode and Effect Analysis (FMEA) and determine the risks in budgeting
Assess financial and effort estimate and monitor budgets
Lead, coordinate and analyse system requirements and developed Business Impact Analysis (BIA) document
Follow Agile Scrum methodologies and conducted sprint/stand-up sessions
Use MS Excel to write user stories, analysed the Iteration Burn Down charts and reviewed defects
Develop SQL queries to validate the data and provide ad-hoc reports
Analyse data to identify errors and provide solution by working with developers
Conduct Manual Testing, User Acceptance Testing (UAT) and document Test Cases to ensure all the functional requirements are met and valid.
Develop manuals which helped in conducting end user

Confidential

SENIOR SOFTWARE DEVELOPER/ ANALYST

Responsibilities:

Designed and implemented datamart, facts, dimensions and OLAP cubes using dimensional modelling standards in SQL Server 2008
Actively supported business users for change requests

Confidential

Responsibilities:

Developed a web tool for Confidential ’s client (UAE based bank) for carrying out effective cost allocation across their cost centres
Created Database, tables, stored procedures, triggers, views, user defined data types, functions, cursors and indexes

Confidential

Summer Intern

Responsibilities:

Researched about Web 2.0 tools and technologies and implemented for creating rich user experience and user participation

Confidential

PROGRAMMER/ANALYST

Responsibilities:

Developed reports using SQL Server Reporting Services (SSRS) and created various types of reports like drill down, Table, Matrix, Chart and SubReports.
Integrated Navision ERP database with the e-commerce database to pass order from e-commerce website to ERP by writing supporting routines in C#.net and MS SQL 2005
Developed and debugged stored procedures and functions for use on Crystal Reports and C#.NET/VB.
Developed Order tracking system to support management decisions for purchase and sales
Deployment of application, including troubleshooting, configuration and implementation support
Performed analysis for developing Time Attendance/Payroll system, subsequent migration from MS Excel to automated system.