SUMMARY

• Around 8+ years of IT experience as Business Data Analyst in Telecom, Broadcasting, Media & Entertainment 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.
• Comprehensive knowledge and working experience in Agile Software Development Cycle.
• Knowledge on Customization and configuration of Salesforce CPQ.
• Highly experienced applying analytical tools including Google Analytics, Adobe Analytics, to report key e - commerce indicators such as conversions rate, page review, web traffic, bounce rate, social media engagement tracking & email tracking.
• Experience in Collecting, understanding, and transmitting the business requirements for the project and translating these into functional specifications along with customization oftelecomsoftware products.
• Strong Understanding of Enterprise OSS/BSS architectures for billing system and Customer service.
• Experience in performing a variety of tasks, such as designing, documenting, integrating local and Sales cloud based systems.
• Experience in translating the Business Support Systems (BSS) to Operational Support System tasks (OSS).
• 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.
• Strong knowledge in project planning sessions which involved release planning, staff augmentation, and implementation timelines.
• Extensive work experience in analysis and driving the execution of Telecom Usage mediation, Rating, Billing and Product Catalogue projects.
• Extensive experience with Web service (SOAP, JSON, REST) API Testing.
• Experience in Entity Framework, AJAX, Web Services, Source Control and Visual Studio.
• Facilitated 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.
• Having multiple domain knowledge-Virtual Reality App Testing,Mobile & Web ApplicationTesting,IoT-Internet of Things,Telecom(OSS/BSS).
• Expert knowledge in generating - Use Case Diagrams, Sequence Diagrams, Activity Diagrams, Data Flow Diagrams, Class Diagrams and State Chart Diagrams.
• Good understanding of IP networks and Voice Over IP (VOIP) as well. Strong experience in Telecom BSS/OSS customization.
• Worked on enterprise Confidential strategy for data integration, mobile first approach in designing the dashboards, worked with the Elicitation techniques used for gathering the requirements which are interviewing, document analysis, introspection from the client and SME’s.
• Experienced in performing Gap analysis by identifying existing technologies, documenting the enhancements to meetthe end-state requirements
• Extensive knowledge of Microsoft Excel and Microsoft Visio for data analysis and data manipulation.
• Worked in all phases of software development lifecycle (SDLC) including requirements gathering, designing, development, testing and maintenance using Agile and Waterfall Model.
• Proficient in various management tools like JIRA, Confluence, Version One and Rational Requisite Pro.
• Highly proficient in using T-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.
• Good experience in ETL using SQL Server Integration Services (SSIS).
• Experience in interacting with QA / Dev teams in fixing errors, development of Test Plans & Test Cases and conducting User Acceptance Testing (UAT).
• Strong experience in UAT/ SIT (System Integration testing) plans and test cases based on the Business/System Requirements.
• Strong analytical and project management skills and was a good team player with flexible and adaptable approach to work.
• Diverse background with fast learning skills and creative analytical abilities with good communication and technical skills.

PROFESSIONAL EXPERIENCE

Confidential, San Mateo, CA

Sr. Business Data Analyst

Responsibilities:

• Responsible for collecting and documenting the business and technical requirements for the Network applications which interface with the OSS/BSS applications.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Worked with applications like Unified Messaging, Alcatel Lucent IMS core applications and Microsoft MOM, Microsoft SMS.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Involved in creating and maintaining the email templates to be used in the Workflows, Auto Assignment Rules and Auto Response Rules related to Lead Management module in Sales Cloud.
• Involved in creating, modifying and completing the change requests for various applications using the CR tool.
• Worked with interface detail template (IDT) to update the information contained in the IA.
• Worked on developing the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Involved in developing Test Plan with a Test Strategy for the System testing. Instrumental in creating design and framework for automation.
• Strong Understanding of Enterprise OSS/ BSS architectures for billing system and Customer service.
• Worked with OSS to resolve Quality Assurance issues, software updates and enhancements for Amdocs quote to cash CRM Billing software
• Performed GAP analysis by identifying existing business process (AS-IS) and documented the enhancements to meet (TO-BE) the end state requirements.
• Interacted with stakeholders to finalize the Business Requirements Document (BRD) in terms of Content, Pricing and Store / WAP Page Structuring.
• Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project and extracting and cleansing of XML, JSON, and otherhealthcaredata using XQuery, SQL and ETL
• Validated multiple web services used by the client, both REST and SOAP.
• Responsible for creating Use Cases, Business Process Modeling and Workflow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Created a Requirements Traceability Matrix (RTM) kept a track of product backlog, Confidential backlog, and time estimates using agile tools like Jira.
• Analysed system requirements, developed detailed Test plan, test cases, Test scripts for testing the functionality, GUI and security testing.
• Analysed the business and functional requirements of the application and helped in developing detailed test plan and test cases.
• Involved in testing Web services and XML with tool called SOAP UI to locate WSDL file on internet, create Test cases, run them, do load testing, security testing.
• Created BRD’s in confluence and linked BRD’s with JIRA stories.
• Creation of Features and User Stories for the DBT (Define, Build & Test) teams in Agile SAFe implementation.
• Defined the test criteria, project schedules and base lined the Test Plan with the help of project meetings and walkthroughs.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications
• Responsible to design the Software Business Requirement (BRD), Interface Agreement (IA), System and Feature Design (SFD), High Level Design Document (HLD) and Detail Design (DD).
• Participated in Developing UML Use Case model for the application using MS Visio and assigned to prepare the detailed Workflow diagram based on the proposed enhancement for the system.
• Involved in each phase of SDLC to ensure smooth and proper functioning of the project.
• Prepared Test Cases based on base-lined Requirements Document, prepared Requirements Traceability Matrix and provided Performance Testing Requirements.
• Prepared training materials in the form of User manuals by preparing step-by-step guide to all screen flows in CMS.
• In depth knowledge on Creating Use Cases (Business Use Cases, System Use Cases) and modelled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
• Used JIRA to track defects, report defects, and maintain log for the system.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Participated in developing strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, process and revenue streams.

Confidential -Overland Park, KS

Business Data Analyst

Responsibilities:

• All phases of the Project Development from Project Kickoffs, requirements gathering (Functional and Database), Testing (System and UAT) for new projects and existing projects.
• Worked with external teams from legacy time Warner and legacy Confidential in understanding the database model and data flow.
• Managed IT/Telecomstart-up of Confidential first regional call center. Much of the technology used was the prototype for Confidential 's regional call centers introduced nationwide.
• Successfully managed the migration planning stages, including creating artifacts for requirements elicitation and managing the coordination of key stakeholders’ engagement within a highly matrixes environment. (VoIP, Video, Core, Data Center,WiFi)
• Conduct JAD sessions to finalize the Billing system design, re-architect and streamline existing design changes impacting other BSS projects for Middleware services, Ensemble Billing, XIUS Prepaid and Retail systems.
• Closely working with Team members and leading them in Confidential Planning and efficiently breaking the epics to Confidential level user story and assigning to developers based on skill set.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts
• API testing validates the JSON output with the expected output, and also compares the JSON output with XML input.
• Worked on Data mapping, logical data modeling and created class diagrams and ER diagram using SQL queries
• Involved in developing a single page, mobile-first, cross-device/cross-browser web application for real-time location sharing utilizingAngularJS, JavaScript API.
• Translated the user business requirements into functional requirements for OSS/BSS development.
• Participated in project planning sessions which involved release planning, staff augmentation, and implementation timelines.
• Generating complex SQL stories based on the requirement and assisting the developers in generating SSRS reports
• Created the Build Turn over document or report on every build. Facilitated functional requirement gathering from system users and prepared business requirement documents (BRD).
• Active participation in Implementing IBM’s Mobile First.
• Knowledge about ecomap portal in Confidential with life cycle management of VNFs (virtual firewall and virtual DNS)
• Validating The data and Finding for Any DATA Mismatch Before sending to user, sharing knowledge with user regarding reporting data
• Expertise in maintaining Agile tools like JIRA, KANBAN Boards and making sure the user stories move
• Created UML diagrams- Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio. Story Creating, detailing business requirement according to customers, and using Agile/Scrum mythology
• Prioritized deliverables, identified gaps, tracked defects, defined software requirements, created artifacts for testing and development.
• Used Jira/Confluence to track and delegate defects on the current system.
• Analysed, maintained and updated FAQ knowledge base in SharePoint for better data accuracy and better timely data availability
• Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthrough.

Confidential -Chicago, IL

Business Data Analyst

Responsibilities:

• Worked on designing the DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Worked on data modeling and produced data mapping and data definition documentation.
• Gathered and documented business requirements for existing and future business systems.
• Manage the product development of a proprietary system enabling the integration of electronic invoicing with traffic, billing systems, and order fulfilment.
• Interacted with stakeholders to finalize the Business Requirements Document (BRD) in terms of Content, Pricing and Store / WAP Page Structuring.
• Responsible for creating Use Cases, Business Process Modeling and Workflow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Partially involved in the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Good experience in Telecom Projects related to NMS, OSS, BSS.
• Responsible for collecting and documenting the business and technical requirements for the network applications which interface with the OSS/ BSS applications.
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs to align them with the product release roadmap.
• Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
• Conducted (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
• Involved in creating workflow diagrams, sequence diagrams, use cases, Analysis & Design Document, Interface Control Document, and Data Mapping Document for incorporating design changes.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Responsible for troubleshooting and resolving LAN/WAN problems users encounter during the workday
• Used CSS, HTML and JavaScript for GUI front end designing and validations.
• Used Confluence for project issues and back-end process integration and documentation.
• Work closely with Business Owners and Stakeholders to outline Business Requirements using Rational requisite pro.
• Worked on designing and developing the Use Cases and UML models using Microsoft Visio.
• Reviewed the Defects entered by the QA team and prioritized the defects and assigned them to the development team.
• Analysed system requirements, developed detailed Test plan, test cases, Test scripts for testing the functionality, GUI and security testing.
• Exposed to Agile methodology. Captured and managed the user stories and requirements in to JIRA. Categorized and tracked by the Confidential cycle, project and portfolio.
• Prepared UAT Materials, including the UAT Process, UAT Test document which would include step-by step process for UAT as well as all the tests that would cover all requirements.
• Experience in reviewing and maintaining Test Cases, Test Scenarios, Test Procedures for Regression Testing, Analyzing Defects, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Worked with the Training Group to build training materials as well provided any suggestions/ tool tips to assist in User Training.

Confidential, NYC, NY

Business Data Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Worked on DataStage ETL jobs for extracting data from heterogeneous source systems transform and finally load into the Data Marts.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Involved in designing the universes by creating the Business Objects data model.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Worked with SQL queries using MS Access for data manipulations.
• Report results and project status to Business owners and teams. Maintain a very close relationship with the business & development team to go over widely & constantly changing social media apps and how our product can support in an efficient manner.
• Assist in the migration and upgrade of workstations from Windows XP to Windows. Manages, upgrades, and worked in the migrating Office 365 to G Suite.
• Was responsible for indexing of the tables in that data warehouse.
• Analyze business requirements and segregated them into Use Cases and activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Assisted in developing and maintaining sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Involved in designing the user experience interface UI/UX strategy, UI requirements, converting findings into UI designs.
• Worked on GSuite apps to technical and business teams. Used Excel and Visio for reporting and process mapping to senior leadership during multiple assignments.
• Translated Business processes into Informatica Mappings for building Data marts.
• Reviewed Requirements & deliverables for delivery timeline.
• Consulted UX/UI developer in developing wireframe for user stories.
• Created uses cases and QA requirements for Confidential new broadcast system.
• Stored and modified requirements in MS - Word and using Test Director.
• Responsible for creating and executing test cases for testing the Integrated application with external systems using a combination of web services
• Report results and project status to Business owners and teams. Maintain a very close relationship with the business & development team to go over widely & constantly changing social media apps and how our product can support in an efficient manner.
• Involved in managing organizational migration from Office 365 to G Suite platform.
• Gathering and documenting business cases, business rules & data mapping documents, workflows, wireframes, and mock-ups for trading strategies, enhancements to trading systems platform, and high-level requirements gathering for product development research.
• Worked very closely with the UI/UX teams providing inputs/ suggestions flows/call flows based on as and when the UI was being developed.
• Coordinated data Analysis, SQL queries, Analyzed XML Data, Request, Data lifecycle and Response API and Enhancements with PMO. Interaction and Integration with Broadcast scheduling system.
• Maintains internal Office 365 account and makes recommendations to clients’ needs for choosing appropriate plans.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Involved in providing user support during our transition from MS Exchange email to G Suite Google Mail
• Organize requirements into high level Use Cases and low-level Use Case Specifications and modelled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Highly skilled in using Adobe Tag Manager to monitor various multichannel marketing and advertising (mobile, website, social media, blogs) initiatives to increase publicity, conversion and retention rate.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements
• Assisted in designing and Administering Teradata Scripts, Tables, Indices and Database Objects.
• Coordinated with the developer, on day-to-day basis, during the development process.
• Involved in Creating Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Modified System flow diagrams using SDLC.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Helped with Data Mapping between the data mart and the Source Systems.

Confidential, NYC, NY

Business Data Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Extensively involved in data modeling
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Developed and provided formal training and presentations/lectures to all DWH users ensuring an understanding of the dimensional model, metadata, and effective usage.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Deployed several projects using Microsoft Access, Sybase SQL, and Abacus/Endur AVS scripting in support of energy trading applications and data migration from legacy systems.
• Involved in developing a valuation engine to monitor and continuously calculate mark-to-market and profit and loss based on user-entered energy trades and published energy index prices.
• Created the logical models and generated the physical models in the databases using Erwin.
• Reverse Engineered the existing ODS into Erwin.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Involved in designing and developing the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Generated server-side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Design, development, implementation and roll-out of MicroStrategy Business Intelligence applications
• Built a matrix organization around third-party vendors, IT, broadcast technical operations, and business users. Initiated change control procedure for the duration of a project.
• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
• Organize requirements into high level Use Cases and low-level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Collaborate with Dev team for Confidential Planning, Analysis, UI/UX Design, Design, Development, Integration, and Lead/Perform UAT
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. Interface with internal customers. Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Work with UX Design Team for UX Design; Review UX Design with Business Stakeholders
• Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Review the Test Plan developed by the testing team for testing the application.
• Assist the QA personnel in the creation of Test Cases using Rational Test Manager.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Confidential - Quincy, IL

Business Analyst

Responsibilities:

• Oversee negotiations for all digital publishing, print, and multi-platform sales programs.
• Built digital publishing team approval solution, replacing inefficient analog process.
• Analyzed key business processes and recommend improvements with respect to the supply chain and inventory control.
• Involved in business analysis, requirement gathering, conducting requirement review meetings, addressing budget issues, creating functional requirement documents and creating test plans according to the business requirements.
• Actively involved in taking minutes of meeting and allotting action items to the relevant team
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Facilitated capture, documentation, and acceptance of business requirements across the business.
• Translated business requirements into functional specifications.
• Identified, gathered and documented the requirements for different releases and their dependencies to the previous projects in order to enable a smooth project flow.
• Conducted regular business review meetings with other parties, Transportation and Retail.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.
• Involved in developing and tracking release schedules. SharePoint and Excel to manage Scrum projects Backlog, Task Board and Burn down Charts etc.
• Involved in Creating and maintained SQL Queries for back-end testing.
• Report results and project status to Business owners and teams. Maintain a very close relationship with the business & development team to go over widely & constantly changing social media apps and how our product can support in an efficient manner.
• Involved in Developing and maintain strategic forecasting and supply chain monitoring systems to update.
• Kept track of Company's web analytics, search engine ranking, applied email, coupon, and online discount promotion advertising campaign to maximize web traffic.
• Crafted Data Mapping Documents, data flow description document and attribute description document for the development team's simplicity.