PROFESSIONAL PROFILE:

• A Senior Data Analyst / Business System Analyst with a strong technical background and 9 years of experience in planning, developing, and implementing IT solutions in various domains.
• Extensive experience in diverse capacity of a System Analyst, User Interface Designer and Development, UAT lead, QA Testing primarily for large consumer facing sites and mobile application platform.
• Experienced in the Software Development Life Cycle process (SDLC), from Gap Analysis, to Requirements Gathering, Design, Testing, Implementation, and Maintenance.
• Hands - on experience with all stages of software development life cycle (SDLC) in Waterfall, Agile-Scrum and hybrid methodology
• Expertise Confidential Agile methodology, story creation, backlog story grooming, Attended Sprint retrogression meetings and continuously improved our sprint process.
• Managed multiple projects & teams, negotiated with partners, worked across business and IT to optimize scope, manage resources and deliver quality products on time. Proven expertise in managing and leading J2EE based web applications, eCommerce Applications, B2C, and Consumer facing Websites
• Collaborated with Stakeholders, End users, SME, Third Party vendors to analyze and document information needs and functional requirements delivering accurate and detailed artifacts such as Business Requirements (BRD), Functional Specification Design, Process Workflows, High Level System Design Documents, Proof of Concept (POC), Blue Print Design, GAP analysis, Data mapping and Test Plans for a broad range of business applications and IT solutions throughout all phases of the project life cycle (SDLC).
• Served as a liaison between internal business teams and the technology teams.
• Participated in Black and White Box testing as part of the Quality Assurance team, performed UT, UAT, Regression, and Integration testing. Good experience as QA Analyst in writing Test Plans, Test Cases and Requirement Traceability Matrix based on business requirements.
• Extremely self-motivated and a quick learner in taking on new challenges and situations
• Team player with excellent analytical, problem solving and communication skills to facilitate collaboration among different teams

TECHNICAL SKILLS:

Programming Languages: Unix, Java, XML, J2EE, JDBC, JSP

Web Technologies: XML,XSD,XSLT,XPATH,CSS,HTML

Software development Model: Waterfall, Agile

Relational Databases/DB Tools: MySQL, Oracle 10g, DBDesigner

BI: Tableau

Microsoft Tools: Word, Excel, PowerPoint, SharePoint, Project, Visio, Access, OneNote

Modeling Tools: MS Visio

Middleware Applications: OracleFusion, TiBCO Business Work, TiBCO AMX BPM

API Management Tool: APIGEE

Tools: Eclipse, Altova XML Spy, SOAP UI, JDeveloper, ITKO LISA 7.1, Jenkins

Application Server: WebSphere Application Server V6.1

Agile Tool: JIRA

Testing Tools: SOAP UI, Selenium WebDriver, HP Quality Center/ALM, JMeter, TestNG, JUnit,Maven, HP ALM/ Quality Center, JIRA

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential, El Segundo, CA

Responsibilities:

• Supported several sales incentive payouts where BI is the direct source of data for Technicians, Vendors, Dealers, HSP, and Care.
• Engaged with business to integrate data and design logic for combined Legacy DTV and Confidential & Confidential stack data as business needs are identified.
• Work with cross-functional teams to support data requirements operationally and reporting: e.g. Unified 360 project to ensure Protection Plan follows the customer correctly during account unification/ de-unification
• Delivered 8 Business Ready Dataset’s throughout 2018
• We are the sole data provider both operationally and reporting for a $1.1 Billion revenue stream, expected to grow to $4.5B when adding the Mobility and Integrated offers.
• Product subscriber base reporting to Finance affecting financial statements.
• Call Center Care Agents Incentivized to sell where BI is source for payout of $240K yr.
• Reviewed Cognos Decision Stream ETL codes and prepared source to target data mapping document for DataStage development
• Created Operational extracts for multiple regulatory compliance issues for monthly and daily reporting and documented them via Application Interface Document
• Created Dashboards in Tableau using features such as worksheets, functions and actions for Product marketing and forecasting
• Sprint tracking, business value tracking and user story lifecycle tracking through JIRA
• Engineering the automation of manual extracts and writing complex Teradata/Oracle Sqls for data analysis and data validation checking

Senior Data System Analyst

Confidential, El Segundo, CA

Responsibilities:

• Leading the Hardware and Software architecture design to set up the mobile application testing platform to capture ad revenue generation on the Confidential NOW application for Video on Demand and Live content. The highlight of the project involves setting up a “Device Farm” consisting of iPhone, iOS, Windows, Android, Roku, FireTV, Chromecast,STB etc. and creating advanced Analytics software to run on the collected data to provide decision making information regarding critical ad revenue markers to business.
• Designing a relational MySQL database to quantify and capture ad request and response parameters.
• Capture business to customer(B2C) user stories through technical flows, context diagrams, sequences diagrams, etc
• Defining requirements and coordinating the development effort of the automation code on Appium and Selenium on an Agile Methodology.
• Defining testing scenarios, writing test cases for setting up the automation testing framework for testing ads displayed on Confidential NOW application.
• Produced detailed functional design specifications, Proof of Concept (POC) and business requirements developed UML flow, activity, sequence diagrams, class, use case, process flows and workflow diagrams using VISIO.
• Elicited new reporting requirements, incorporated reports design as part of the Functional requirements, use cases, developed test plans and objectives.
• Produced data dictionary mappings for the inventory of reports to be generated via extensive Excel work using pivot tables and complex formulas to manipulate large data structures
• Worked on capturing network traffic from client devices to third party ad servers using Charles Proxy, Wireshark and Fidler.
• Worked with third party content providers to onboard dynamic ad insertion enabled content into the Confidential NOW app and troubleshoot rendering issues
• Provide extensive support during Production release.

Data Analyst / Business System Analyst

Confidential, El Segundo, CA

Responsibilities:

• Worked to create enhancements to the Confidential .COM web application customer order flow through a Priority based Agile-model driven Sprint planning release schedule while working in coordination with the Product Owner, Scrum Master, Business Analysts Enterprise Solution Architects, Development team, SQA
• Actively participated in Sprint planning sessions and the Daily stand up meetings to provide inputs and status of the project on behalf of the Middleware team. Assisted the scrum master and product owner in defining the requirements for each sprint in a phased approach and to categorize the users story into batches for an iterative data migration to the new system
• Worked with Product Owner, scrum master and development team to create user stories for the Confidential .COM customer order flow application in story writing workshops. User stories were captured using activity use case diagrams, sequence diagrams etc.
• Gained a deep level of understanding of the existing business processes in the Enterprise Integration Middleware system and served as the SME and primary POC for multiple projects
• Was the key representative all Requirements elicitation sessions with the business and other application teams and played a critical role in understanding and analyzing the Confidential business requirements. Responsible for approval of Detailed Business Requirements and High-Level Design
• Facilitated review sessions with cross-functional teams to analyze Epics and reach team consensus on proposed design
• Translated complex business requirements into application specific functional requirements and produced the functional specification document. Developed use cases, use case diagrams, swim lane diagrams and workflows to decompose requirements, accurately capture various scenarios and business rules and further elaborate process definition. Organized deep dive sessions with the technical team
• Successfully launched several multi-million-dollar products
• Successfully executed the project to launch new Set-Top Boxes through multiple phases for residential and commercial customers.
• Singlehandedly supported the project to enable programming changes for customers undergoing conversion to the Confidential & Confidential enabler platform from the Legacy Confidential platform over conversion weekends.
• Executed the implementation of regional sports network pricing changes based on commitment length for residential customers
• Demonstrated excellence in data modeling, application architecture, data architecture, business process modeling/management defining “As-Is” and “To-Be” processes
• Defined KPIs for projects assigned (key performance indicators) and provided timely updates to the PMO regarding planned and utilized capacity and thus helped forecast any additional resourcing required for the project
• Created the functional Specifications for the Middleware application, Level of Effort and conducted review sessions with the IT development team for validation
• Identified and managed risk, scope, change requests and cost throughout the life-cycle of the project using Clarity PPM
• Served as the primary point of contact for Development and the SQA team for requirement clarification and to bridge gaps during the development and testing phases
• Actively supported System Testing and User Acceptance testing with root cause analysis of defects logged and followed through to closure.
• Prepared Test Plans, Test Scripts and Test Cases based on functional specifications and user requirements.
• Implemented and worked on Acceptance Test Driven Development (ATDD) agile methodologies completing releases ahead of schedule.
• Analyzed the SRS (System Requirement Specifications) and developed Test Suites to cover the overall quality assurance testing.
• Performed Defect tracking in JIRA. Defects were linked via traceability to specific test case.
• Supported UAT and Production Releases.

Developer

Confidential

Responsibilities:

• Designed, developed and tested new services on the NGM as well as the legacy Middleware platform.
• As part of the migration of the services to the NGM platform captured the AS-IS process and designed the TO-BE Process and performed the Gap Analysis between current and the future state of the application.
• Supported the migration effort by coordinating consumer walkthrough sessions of the NGM version of the services.
• Documented the technical implementation of the services in Detail Design Documents and Unit Test plans.
• Prepared and executed unit test cases to ensure the delivery of accurate functionality and provided support during UAT testing.
• Designed test plans to validate software functionality against requirements.
• Was responsible for setting up testing stubs using the LISA tool for over 300 Middleware web services to allow testing when backend provider systems were unavailable.
• Singlehandedly created the Regression Testing Flow suite involving over thousand test cases for new Receiver activation suite of web services thus eliminating many hours of manual testing effort
• Maintained and executed Regression automation scripts and framework using Selenium WebDriver to test Set top box activation, modify Customer Product, Get Customer Profile.
• Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.
• Performed Smoke, Functionality, Integration, System, Regression tests based on Analysis, and understanding of the requirements, non-functional specifications, and end-user needs.
• Developed API proxies on API Management Platform (APIGEE) to allow client to enable its Partners to seamlessly integrate with its backend services for capturing new subscribers in Point of Sales setting.
• Supported Production Releases

TiBCO AMX BPM Business Analyst

Confidential

Responsibilities:

• Designed, developed and tested a Proof-of-Concept Authorization Flow using TiBCO AMX BPM tool for the Client

TiBCO Business Works Analyst

Confidential

Responsibilities:

• Designed and developed an optimized model of the business to business gateway(B2BGW) layer existing between the client and a “pay for subscription” television services company to simplify the complex operational model supporting the role of the telecommunication major as the “reseller “of the Pay TV services.
• Was involved in all phases of the SDLC lifecycle including
• Requirement reviews, design reviews, System Testing/UAT reviews
• Preparation of high level design, detail design, technical specifications
• Development for the optimized PayTV B2B structure using TiBCOActiveMatrixBusinessWork, unit testing and CAT testing using GHTester
• Code walkthrough, resolving technical and design issues, performing independent Unit, System testing, provide support for UAT defect testing
• Identified and developed a critical reusable business process component that helped to further streamline the design of the solution.
• Created test data, test cases and setup test environment in HP Quality Center/ALM and ensured test cases were mapped to appropriate business requirements.
• Performed Functional End-to-End testing of the application in various environments.
• Used HP Quality Center/ALM to log and track defects.