PROFESSIONAL SUMMARY:

• Around 6+ years of IT experience as Business Analyst in analysis, design, development, implementation, deployment and interacting with department managers, subject matter experts, and end - users.
• Proficient in Business Data Analysis, Business Writing, Telecom and Cable domain.
• Solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling and Analysis, design documentation.
• Highly proficient in working with users and stakeholders to gather requirements, analyze them and subsequently use design tools to model the requirements.
• Proficient in interacting with Subject Matter Experts (SMEs), System Analysts and Technical team with excellent communication and interpersonal skills.
• Ample experience in gathering, documenting and analyzing business requirements and worked on many project methodologies like Waterfall, RUP, Scrum and Agile.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Impact Analysis, Cost benefit analysis, Process Modeling, Business Process Re-Engineering and ROI analysis.
• Skilled in the areas of writing Business Requirements Document (BRD), Functional Requirements Document (FRD), Functional Specifications Document (FSD) and System Requirement Specifications (SRS), design and development of use case scenarios and creating UI Mock up's using MS Visio.
• Experienced in facilitating requirements gathering through research, formal-informal sessions and JAD sessions with SMEs and end users, Gap analysis, data analysis business process improvement and systems integration.
• Expertise in Microsoft Office Suite including - Word, PowerPoint, Excel, Access, Visio.
• Strong experience in leading UAT/ SIT (System Integration testing) plans and test cases based on the Business/System Requirements.
• Expert knowledge in generating - Use Case Diagrams, Sequence Diagrams, Activity Diagrams, Data Flow Diagrams, Class Diagrams and State Chart Diagrams.
• Worked in all phases of software development lifecycle (SDLC) including requirements gathering, designing, development, testing and maintenance using Agile and Waterfall Model.
• Experience in Web Services testing using Rest, SOAP, and good understanding of JavaScript, HTML and XML.
• Highly proficient in using SQL for developing complex Stored Procedures, Tables, Views, Indexes, Triggers, User Defined Functions, SQL Joins and performance-based query writing.
• Performed significant data analysis and report development using BI tools like SSRS and Tableau software.
• Expert in managing SharePoint sites and admin related work.
• Strong analytical and project management skills and was a good team player with flexible and adaptable approach to work.
• Experience in reviewing Test Cases, Test Scenarios created by testing teams & involved in functional Testing, Manual Testing, Regression Testing, analyzing bugs and defects using JIRA, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Diverse background with fast learning skills and creative analytical abilities with good communication and technical skills.

TECHNICAL SKILLS:

Project Methodologies: Agile, Waterfall, Scrum, Lean, RAD

Operating Systems: Windows 98/XP/7/8, Mac OS X, UNIX, Linux.

Languages: SQL, Confidential -SQL, UML, HTML, CSS, XML, JavaScript, jQuery, VB Script, XML,

Databases: MS SQL Server, Oracle 8i, MS Access SQL Profiler, SQL Server Management Studio

ETL and Reporting Tools: Crystal Reports, Excel, MS BI, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Tableau

Document Management: MS SharePoint 2007, 2010, 2013

Project Management Tools: MS Project, MS Visual Studio, JIRA, Slack

Other Tools: Exchange server, SharePoint, Outlook Client, MS Visio, MS Office (Word, ExcelAccess, PowerPoint)

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

Business Analyst

Responsibilities :

• Conducted and facilitates business requirements gathering sessions and meetings, document review, working sessions, Creates Charter and Business Requirements and Technicalities document based on the user stories defined in rally and execute the same in different iteration or sprint.
• Worked closely with Java development team in Agile Environment to build and support current dashboards and portals.
• Worked closely with developers and a variety of end users to ensure technical compatibility and user satisfaction.
• Coordinated with various organizations and teams (Sales, Operations, Engineering, OSS dev teams, Test teams, etc.) to provide understanding of the project business requirements
• Created Use - Cases and Business Use-Case Model after accessing the status and scope of the project and thoroughly understanding the business processes.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and thoroughly understanding the business processes .
• Responsible to enhance the User Interface using HTML, JavaScript, XML, CSS as per the requirements
• Participated in various Scrum ceremonies like Sprint Planning Meeting, Daily Stand-up Meeting, Sprint Review, Meeting, Sprint Retrospective Meeting, and Backlog Grooming and achieved towards a release goal.
• Extensively used JIRA to record and maintain the artifacts like Product backlogs, Sprint backlog and user stories.
• Maintained the Agile process to be consistent to the methodology.
• Analyze and prepare the High-level design (HLD), AID, System Requirement Design (SRD), business requirements, Functional requirements, Design use cases, technical requirements and testing approach, Take the UAT (User Acceptance) from the stake holders.
• Sound proficiency in analyzing and creating business Use Cases and diagrams using MS Visio and Rational Rose
• Process new business applications - ensure paperwork is in good order
• Prepared the Technical design document which include the Process flow, web services (API field mapping with database) with all logical and condition/query systematically. Which help developer to develop the system
• Groomed and trained the development team on complete User story with High level and Low-level design requirement.
• Responsible for project delivery on time, budget, reporting and analysis.
• Excellent analytical and problem-solving skills, ability to think strategically and take ideas and create solutions for the customer
• Co-ordinate with cross-functional Team and gathering database requirements and to designing / supporting application migration, enhancements.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people
• Responsible for gathering requirements, data mapping, gap analysis, and process flow and activity diagrams
• Responsible for reviewing all the scope items in the queue, prioritizing requests with business and documenting/updating requirements and process flow diagrams for the upcoming release.
• Processed on boarding compliance documentation utilizing internal systems.
• Translated functional business requirements into technical specifications
• Served as a liaison between the client and corporate office to resolve escalated application issues
• Coached staff in efficiently and effectively feed verbal and written materials to regional user groups.
• Designed Conceptual, Logical Models, and prepared supporting documents and description of the relationship between the existing data elements/entities keeping the business requirements in site.
• Originated & processed wholesale mortgage loans in a direct lending capacity (warehouse line) as well as a broker/banker capacity.
• Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to conducting UAT
• Provided written instructions directly to users to help them grasp and better perform complex system activities.

Environment : Visual Studio, MSOffice, MS Access, MS Project, MS Share Point, Java, JavaScript, MS Visio, HPE CMS, UML, SQL, Agile/Scrum, Tableau Oracle, SQL, JIRA

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Work closely with business owners and product owners in gathering requirements.
• Extensively working on identifying the gaps between the AS - IS and the TO-BE scenarios so as to analyze the variance between the system capabilities and business requirements and documented the GAP ANALYSIS.
• Responsible for handling production environment onsite and by leading the team in delivering solutions to our customer in the communication sector.
• Facilitating collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro.
• Created Use-Case diagrams, Sequence Diagrams and Activity Diagrams using MS Visio after accessing the scope of the Project and understanding the business processes.
• Developed business cases and diagrams
• Designed and populated specific tabled databases for collection, tracking and reporting of data.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements.
• Have been debugging issues/bugs and performs root cause analysis to minimize risk.
• Extensively used SQL queries to analyze the data and write test cases as part of UAT.
• Implemented effective solutions for break/fix issues and appropriate development initiatives with direction.
• Analyze the customer sessions in Tealeaf and understand the real customer impact.
• Develop dashboards to track trends
• Setup dashboards using Adobe experience tool.
• Analyze the application server and web server logs in Splunk for production errors.
• Worked for Splunk query automation to monitors the application logs and raise alerts as and when needed.
• Making sure all the JIRA/ITSM tickets/tasks assigned are addressed to meet the deliverables.
• Used complex SQL queries for statistical analysis of quantitative data.
• Being aware of all the changes planned for the applications and provide weekend supports during the deployments when needed.
• Have been creating User stories regularly on need basis.
• Involved with three Scrum teams to manage product backlog and successful delivery of functionalities in a three weekly scrum cycles.
• Setup alerts to track real times issues using Splunk.
• Responsible for creating Bi-hourly reports on production monitoring status.
• Involved in client discussions using the Requirement gathering Stage and prepare Proof of Concept (POC) documentation.
• Have been organizing and participating in periodic meetings with end users and technical team to provide appropriate planning strategies.
• Continuously monitoring the health of application, application servers and web servers.
• Use document generation software packages such as MS Office Suite, InDesign, and Adobe Creative Cloud to develop documents templates.
• Complete overall layout and production design for scientific plans and reports which includes laying out text, graphics, integrating video, and assembling other materials.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Conducted user interviews, one to one session with the managers and the critical users, and arranged JAD Sessions.
• Confer with software engineers about billing system. Defined data mapping specifications for the Interchecks Production System / Billing System Interface. Developed integration test cases and documented the expected test results for the Interface.
• Custom Billing Solutions - Requirements and implementation of custom billing solutions requiring IT development
• Developed documentation for Data Warehouse tables from the Product, Program, Pricing, Agreement, Order, Billing, & Organization subject areas.
• Conducted multiple requirements gathering sessions with every stakeholder; inputs are gathered from documents, organized into formatted user stories, updated in tools like Jira Agile.
• Managed and prioritized user stories using JIRA. Worked with the development team to identify blockers and provide resolution.
• Created a Requirements Traceability Matrix (RTM); Kept a track of product backlog, sprint backlog, and time estimates using Agile tools like Jira.
• Worked closely with users and program developers to ensure that the application development met the user expectations and was also a part of User Acceptance Testing (UAT).
• Strong, end-to-end understanding and experience with knowledge of Software development life cycles (SDLC) and Methodologies of Agile/Scrum, Waterfall, RAD and RUP.
• Worked with OSS to resolve Quality Assurance issues, software updates and enhancements for Amdocs quote to cash CRM Billing software
• Worked on service-oriented architecture (SOA) designs for the sales projects of Confidential & Confidential
• Worked on XML and SOAP for integrating applications with web services.
• Developed Oracle PL/SQL Query to report reject and success rates for various types of converted data.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for enhancement. Coordinated activities of multiple business groups such as AS-IS and TO-BE using Agile, and supported strategic planning, goal settings and plan implementation.
• Provided process maps and recommended improvements such as streamlining workflow, enhancing defect traceability, defining customer's critical to quality issues and providing integrated defect view for all stakeholders.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Conducted Requirements Management workshops that include brainstorming and interview sessions with the business team, SMEs and product owners.
• Liaison between the Business and the IT Development teams in the requirement gathering process.
• Provided application demo and showcase sessions to Product Owners and Business users using PowerPoint presentation
• Developed user interface designs and wireframes for new application enhancements Apple Music and Confidential Care Project.
• Created user stories in JIRA's and tracked the user stories till delivery.
• Played the role of the JIRA Administrator for the Wireless Billing Organization.
• Created Wireless Billing Architecture diagrams and documents and Presentations and presented the same to the Development and testing teams.
• Conducted workflow, process diagrams and GAP analysis to derive requirements for existing systems enhancements using MS Visio.
• Translated all the business requirements in discovery phase to business process modeling using UML. Also used activity diagrams and process flow.
• Created the As-IS Model of the system and performed a complete analysis to identify problems and inconsistencies with business requirements.
• Conducted weekly status meetings and circulating the status reports to internal and external (Client) stakeholders
• Assisted the Project Manager in developing project plans, tracking progress and analyzing workloads using MS Project.
• Demonstrated ability to solve problems in a technical environment; with strong analytical skills.
• Performed User Acceptance testing for the user stories created in JIRA.
• Created the reports in Tableau for Apple Music Launch.
• Experienced in handling / working on multi-projects Confidential one time