Synopsis:

• 7+ years of experience as a Business Analyst in Telecom and Media Industry and experience as a business analyst in Telecom sector with solid understanding of Business Requirement Gathering, Business Process Flow, and Business Process Modelling.
• 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.
• Skilled in conducting online marketing campaigns using Adobe Tag Manager, Adobe Marketing cloud, Adobe Ad Hoc analysis, Google Tag manager, Google AdWords, Facebook Ads and SEO website optimization.
• Strong experience in end-to-end Adobe Analytics implementation using Adobe Dynamic Tag Management (DTM).
• Crafted and reviewed various business documents including SRS, BRD, Use Case Specifications, FSD, SDS, Data Mapping Documentation, Requirement Traceability Matrix (RTM)
• Experienced in conducting marketing research, customer survey, analyzing customer feedback and web analytic data to understand customer and business needs.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying, and analyzing risks using appropriate templates and analysis tools.
• Support different business units by developing detailed site maps, user flows, wireframes, mockups, and other product deliverables to effectively communicate UX designs and product requirements and help to create usable and interactive web experiences.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration into the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Design and review of various documents including the SRS, FRD, SRS, Use Case Specifications, data requirements, RTM, GUI Requirements, SLA's, RFP and project initiation document.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Expert in Root Cause Analysis, Feasibility studies and Risk Assessment studies.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• In-depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Expertise in writing JavaScript, HTML, DHTML, VBScript, XML and XSLT.
• Experience in Agile and Scrum Methodologies and related terminology such as Daily Scrum, Product Backlog, Release Burndown, Scrum Master, Sprint Planning Meeting, Tackboard, To-do and Work in Process Charts.
• Expertise in using the testing tools such as Mercury Quality Center (QC)/Test Director and Quick Test Pro (QTP).
• Sound in Suggesting system automation solutions to business problems or opportunities; providing automated solutions that are cost effective and that meet user requirements.
• Conducted successful Joint Application Design (JAD) sessions for requirements gathering.
• Extensive knowledge of Object-Oriented Analysis and Design using UML, Rational Unified Process (RUP), Requisite Pro, Rational Clear Case and Visio.
• Experience working on JIRA/Confluence/Clarity or other job/resource tracking tools and Microsoft office skills.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
• Involved in Creating tables and schemas using SQL on MySQL Workbench to design a system and extensively used SQL queries for business analytics and analysis of data using data manipulation language.
• Involved in Tuning the TSQL queries using Performance Tools like Query Analyzer, Execution plan, SQL Profiler.
• Skilled with Data Analysis concepts of Data Modeling, Data Dictionary and Normalization, Involved in Creating Data Mapping Documents to transfer data from legacy to target system and to reduce data and duplication.
• Supporting developers with unit testing and troubleshoot where the issues emerging.
• Experienced in creating tableau dashboards, worked with different types of data visualization charts in tableau.
• Expertise in GUI testing, Functionality testing, System testing, Unit testing, Integration testing, Front end testing, Back-end testing and Regression testing of Client/Server and Web based applications
• Demonstrated capability in managing people, leading teams on various complex projects.
• Experienced in writing System Use Case Specifications, Object Oriented Analysis and Design, Change management, Risk Management, Workflows and Unified Modelling Language (UML) diagrams, Web Portal Content Management
• Excellent written, communication and interpersonal skills.
• Highly motivated team player with excellent communication, analytical and interpersonal skills.

WORK EXPERIENCE:

Sr. Business Analyst

Confidential, Bellevue, WA

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Captured requirements for Confidential billing enhancements and performed source to target data mapping for Confidential billing ODS.
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concerns.
• Performed ICOMS, CSG, Cable Data software application conversions and implementations.
• Project duties included multiple task project assignments, scheduling and tracking, facilitating meetings with all levels of the business community for requirements gathering, project development, design considerations, impact and risk analysis, and quality control of client acceptance testing.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Produced Salesforce reports monitoring group progress.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• Reviewing the existing IT processes in ServiceNow to identify the areas of improvements and enhancements.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Performed a gap analysis between the current TWG control framework and COBIT.
• Helped with data modelling and defining the conceptual and logical model of the data warehouse.
• Conducted extensive Joint Application Development (JAD) sessions for all business-related issues.
• Involved in Logical & Physical Data Modelling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Prepared High-Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Participate in integration analysis and studied critical dependencies on ServiceNow modules.
• Involved in designing corporate wide LAN/WAN /infrastructure
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Service Management: improved ITIL - Incident, Problem, Change, Event, Asset Management
• Initiate discussions between Change Management, CI owner groups and release management to resolve data and process issues affecting the quality of data in the CMDB.
• Provided data modelling support for numerous strategic application development projects.
• Documented the meeting minutes with issues of about discussed and solutions resolved.
• Involved in developing comparative statements, reports to examine the existing functionalities and present to the stakeholders. Also create Business Process Workflow Diagrams.
• Involved in designing high-level workflow charts and application mock-ups to illustrate and clarify customer- requested functionality.
• Analyze requirements utilizing various methods. (E.g., sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Successfully designed and implemented scalable, highly available database architecture (UDM, Unified Data Model) to support various Path applications.
• Expertise in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Ensured that project requirements are properly tracked and documented.
• Requirements Gathering/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
• Conducted JOINT APPLICATIONS DEVELOPMENT (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
• Implemented RUP recommended visual models to draft business requirements by using Use Cases.
• Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Monitored test scripts developed by QA team to check the integrity of the test plans.
• Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.

Business Analyst

Confidential - Las Vegas, NV

Responsibilities:

• Interact with business leadership to understand the business objectives.
• Oversee marketing analytics, KPI's, promotion/channel/product ROI's, a/b testing and price variance analysis.
• Prepare User Stories for Responsive Marketing self-serve model in Adobe AEM CQ for Pod Users
• Interact with development team to ensure they get all the details for developing the stories.
• Prepare Gap analysis between As-Is and To-Be states for online part of Consolidated Offers.
• Interact with UX team and gave the development and inputs for intuitive user experience.
• Prepare Studio Business Process flow for responsive marketing highlighting the systems involvement.
• Define inter-dependencies of projects and prepare a road map for executing each project at right time.
• Prepare project plans including project charter, resource requirement, budget allocation and timeline.
• Plan sprints and monitor development activities
• Extensive experience in gathering, analyzing and documenting content management needs from Business (digital marketing and branding) and translated requirements in terms of AEM templates, components and workflows.
• Worked with digital marketing to gather requirements for ad management, leads, campaign tracking and reporting.
• Align IT efforts with business strategies by proper planning of each project.
• Generated project plans including project charter, resource requirement, budget allocation and time line.
• Develop sprints and monitor activities of each track (UI, tech design, front end design, content strategist)
• Prioritize development efforts based on business value and technical complexities.
• Establish expectations and deliverables from each track within the team.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Involved in Creating use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational RequisitePro.
• Plan, gather requirements and managed vendor for POC (Proof of Concept) to evaluate Adobe CQ suitability for generating print catalogues that requires controlled digital content
• 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.
• Analyzed, converted and documented business requirement into BRD, User Stories and SRS.
• Conducted JAD sessions for better understanding of the project goal and refined the business requirements in coordination with multiple teams.
• Helping functional teams in managing and analyzing digital marketing campaigns
• 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.
• Kept track of Company's web analytics, search engine ranking, applied email, coupon, and online discount promotion advertising campaign to maximize web traffic.
• Provide SEO analysis and recommendations in coordination with elements and structure of websites.
• Involved in developing customer online survey and analyzed results for website content and design management.
• Conducted Scrum meeting, Involved in Creating user stories and delegated each team member responsibilities.
• Actively involved with the marketing strategy teams for the advertising campaign idea and conducted the marketing strategy into our web content catalog.
• Maintained and monitored project progress and status through MS Project. Presented periodic/monthly status reports to the Project manager to serve as the team's assessment of the project and its schedules.
• Documented project and communicated with cross-functional partners to create and maintain standardized Omni-channel reporting which includes daily reporting dash boards, operational metrics reporting, Ad hoc trouble shooting and strategic reporting.
• Maintained the product catalogs, search and navigation, search engine optimization (SEO), Business Intelligence (BI) and personalization, etc.
• Maintained the Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements have been developed into a solution and it has been tested and tracked.
• Worked closely with the developer team to implement the application and responsible for the user accepting test (UAT)

Business Analyst

Confidential - Dallas, TX

Responsibilities:

• Worked on Verizon application and CSG preferred, including the ability to screen, print, and gather information to resolve inquiries. Maintained with ability to adapt to changing priorities, develop alternative solutions, and work in a team environment.
• Involved in designing Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Gathered and documented business requirements for existing and future business systems.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database.
• Involved in Dynamics CRM data capture, integration, auditing, data mapping, importing data and creation of interfaces.
• Developed Sprint Planning, User Stories, Tasks in Version One.
• Provide best practice recommendations in the areas of Order Management System and CRM.
• Expertise in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Involved in creating the workflows in ServiceNow as per the requirements from business team and functional specifications.
• Involved in creating source table definitions in the Data Stage Repository by studying the data sources by importing the data from Mainframe.
• As an analyst, working with the Process and Functional Requirements to select the necessary IT/OSS/BSS components CRM and the service provider's required preparation for adapting the existing components, while supporting the target processes. To obtain a high-level design of the service provider's IT/OSS/BSS applications, the impact of the tool chain supporting the main end-to-end operation processes has to be assessed based on the assurance, fulfilment, billing, operation support and readiness process.
• Oversaw end-to-end OSS/ BSS solution architecture including: Real-time and offline Billing, Ordering, Provisioning, Porting, Payments, Customer care, Point of sale, Web self-care and network real-time access: IN and Diameter protocols.
• BSS/OSS integration architecture of client and service control systems.
• Generated Surrogate ID's for the dimensions in the fact table for indexed and faster access of data.
• Working with other investment departments such as compliance to understand and integrate their workflow in FI MM application.
• Implementing and supporting Order Management System.
• Identified opportunities for improving business processes within systems and assists in the preparation of proposals to implement Dynamics CRM.
• Documented, communicated, and mitigated issues and risks in a timely manner using ServiceNow.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Involved in creating diagrams and sequence diagrams to analyze the requirements and recommend solutions.
• 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.
• Translated the user business requirements into functional requirements for OSS/BSS development.
• Data transfers from text files and Access databases using BCP and DTS; Data mapping and transformations while loading data using VBScript.
• Involved in creating hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
• Preparation of integration functional documents for integration of Quotation system Siebel with Order management and manufacturing systems.
• Involved with Release Management for multiple build/release related dashboard updates.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Enabled Proper selection of the hash table design parameters for faster table look-up.
• Involved in creating re-usable components using shared containers for local use or shared use.
• Imported and exported repositories across projects.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Generated XML documents using the XML Output Stage.

Business Analyst

Confidential, Denver, CO

Responsibilities:

• Defined the customer’s critical to quality (CTQ) issues and requirements for current Defect Management process.
• Measured performance of the “As-Is” process and collected metrics such as defect resolution rate and cycle time.
• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Involved in Performance Measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for enhancements, Cost benefit analysis and ROI analysis.
• Coordinated activities of multiple business groups such as ASI, IS within the organization and supported strategic planning, goal settings and plan implementation.
• Conducted user interviews, one to one session with the managers and the critical users and arranged JAD Sessions.
• Provided “To-Be” process maps and recommended improvements such as streamlining workflow, enhancing defect traceability, reducing manual handshakes, and providing integrated defect view for all stakeholders.
• Acquired appropriate business rules in coordination with users to understand the business functionality.
• Estimated time and cost, developed schedule, budget and determined communication requirements of certification and support initiatives.
• Analyzed and reviewed project elements involved in traceability including testing artifacts, end-user support documentation and training materials to provide tractability across the project.
• Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Assisted Test Lead, Testers understanding business process and help them successful completion of Testing.
• Involve in Creating user guide and production documents for NGSS and thereby improved productivity of production application support groups.
• Collaborated with the ARM/ARC throughout the documentation effort.
• Documented process flows, process dependencies, and production environment configuration.
• Install, deploy and configure applications, perform installation verification.
• Apply vendor patches as released, software testing, certification and implementation of NPA.
• Writing queries or data analysis and QA report testing
• Coordinate and install new vendor releases, and assisted users with troubleshooting functionality issues.
• Managed project initiation, planning, execution, controlling, scheduling, support test, training, and production environment management.
• Manage change, release, and problem events, produce tech plans for new or changed solutions.

Business Analyst

Confidential ., Richardson, TX

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Provided data modeling support for numerous strategic application development projects.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Was responsible for indexing of the tables in that data warehouse.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Implement relational repository in the UDM, Microsoft Universal Dimensional Model.
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Helped in creating end user manuals and procedure manuals.
• Worked extensively with MS Excel and MS access.