SUMMARY:

• Over 10+ years of Information Technology (IT) experience as a Business Analyst in different industry domains such as Insurance, Retail, Marketing, Ecommerce, Sales, Finance, Mortgage, Banking, Payment, Digital Asset Management (DAM), Media & Entertainment, Television, Home Entertainment, Product Licensing organizations.
• Over 5+ years of IT experience working as Atlassian tools Expert, JIRA Agile Admin, Confluence, Clear Quest defect tracking System, Configuration Management, Build and Release Management using GIT, CVS, Subversion, TFS in Unix/Linux environments.
• Expert in Business Analysis, Systems Analysis, Requirements Gathering, Requirements Gap Analysis, Managing Change Requests (CR), Defects Resolution, Problem Notifications (PN), Risk Analysis, Impact Analysis, Design, Development and Business Applications.
• In - depth knowledge of all the phases within the Information Technology Infrastructure Library (ITIL), Software Implementation Life Cycle (SILC), Software Development Life Cycle (SDLC), Software Delivery Life Cycle (SDLC), Software Testing Life Cycle (STLC) such as Requirements, Analysis/Design, Development, UAT Testing and Project Management (PM) Fundamentals.
• Solid understanding of CDP (Customer Data Platform) and DMP (Data Management Platform).
• Experience in conducting Joint Application Development (JAD), Rapid Application Development (RAD) & workshops to converge toward a design acceptable to the customer and feasible for the technical team.
• Demonstrated leadership in identifying and implementing appropriate technology solutions, application testing, User Acceptance Testing (UAT), Quality Assurance, specification gathering, team co-ordination, solving business problems, supporting company strategies while maintaining personal accountability.
• Excellent Training skills, facilitation, PowerPoint presentations, maintaining performance metrics, develop training manuals, documentation & communicating to users.
• Proficient Confidential creating and transforming business requirements into Software Requirements Specification (SRS) using Rational Requisite Pro and designing business models using UML diagrams such as Activity Diagrams, Sequence Diagrams and Collaboration Diagrams in Rational Rose and MS Visio thereby helping the development and QA teams in understanding the requirements.
• Strong web development, Web content management, Enterprise Content Management (ECM), workflow, and integration experience.
• Exposed to Software Engineering Processes such as Personal Software Processes (PSP) and Team Software Processes (TSP).
• Worked on Build Automation and Continuous Integration tools like ANT1.8, Maven2.x/3.x, Jenkins, Bamboo.
• Experience in working with Tracking Tools Remedy, and JIRA. Working with application infrastructure architects to establish the physical environments to effectively perform the software builds and deployments with an emphasis on quality, Integrity, and Security.
• Highly efficient, demonstrated superior time management and multi-tasking skills by accomplishing cross-functional tasks.
• Proven aptitude to work independently and within a team environment to meet project deadlines.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse and Business Intelligence.
• Design and development of several reports and Dashboard utilizing Tableau Visualizations tools like Heat Maps, Geographic Visualization, Pie-charts, Bar Graphs, Scatter Plots, Custom Color Palettes to identify KPI's to the client.

TECHNICAL SKILLS:

Programming Languages: Java, UML, BPM.

Web Technologies: HTML5, CSS3, Java Script.

Databases: Oracle, SQL, MySQL, DB2, Teradata, Grid Gain Cache.

IDEs: Eclipse, IntelliJ, Sublime, Visual Studio.

Version Control: GIT, CVS, Subversion, Source Tree.

XML Editors: XML Spy, Stylus Studio.

Operating Systems: UNIX, Linux, Windows, IOS.

Methodologies: Scrum, Kanban, Waterfall, SDLC, TDD.

Bug Tracking Tools: Jira, Microsoft TFS.

Microsoft Office Tools: MS Word, MS Excel, MS Visio, MS Power Point, MS Outlook.

Content Management: Confluence.

Data Base Tools: SQL Server Management Studio, PL/SQL developer, My SQL, TOAD, Flyway.

Project/Test Mgmt. Tools: Postman, Informatica (ETL), Soap UI, Ready API, HP Application Lifecycle Management (ALM), Quality Center (QC), SharePoint.

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI.

Areas of Expertise Include: Requirements Gathering & Analysis, Business Proposals, Systems Development Life Cycle, Service Oriented Architecture (SOA), Event-driven architecture (EDA), KPI Dashboards & Scorecards, User Acceptance Testing (UAT), Ad hoc Reporting, Project Management, Salesforce, BRDs/SRDs, Vendor selection, ETL- Data Warehouse, SCRUM Master, Adobe Professional.

PROFESSIONAL EXPERIENCE:

Senior Technical Business Analyst

Confidential

Responsibilities:

• Supported Confidential &T and Confidential for television and wireless media commercial operations.
• Configured Confidential television and audio services to subscribers through satellite transmissions.
• Assisted stakeholders for gathering business requirements, delivering and deploying new processes into a high level User Interface design (UI) systems/platforms.
• Created and assisted Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Technical Requirement Documents and High level design architecture.
• Designed and assisted in complex workflows for end-to-end integrations for Media Sales and Satellite distributions.
• Generated reports and worked with stakeholders to provide recommendations to third party vendors for future enhancements and goals.
• Acted as a liaison between project stakeholders and technical team to meet business requirements.
• Involved in reviewing and approving test plans and test scripts using Test Rails.
• Performed Sanity checks and User Acceptance Testing (UAT) for developers, business partners and clients.
• Worked on offshore model to assist developers and testers for requirements, testing, deployments and releases.

Environment: JIRA, Confluence, MS Office, SQL Server, PL/SQL, Oracle, SDLC, STLC, ITIL, Agile, Kanban, Scrum, Tableau, Test Rails, Soap UI, Postman.

Technical Business Analyst / Data Analyst Lead

Confidential, Irvine, California

Responsibilities:

• Lead and involved in functional and non-functional requirements gathering activities with end users, managers, stake holders and SME’s.
• Played a key role in the Scrum team and used the bug tracking tool Jira for clarification and prioritization of tasks in the project backlog.
• Wrote user stories defining the system functionality in Jira tool.
• Configured JIRA/Confluence projects and JIRA/Confluence Add-Ons using the JIRA/Confluence Administration tools.
• Conducted Meetings and review sessions using PowerPoint with different teams, business requestors and Project Managers for all documents requiring signoff’s and Approvals.
• Worked with the PM and higher management to determine the project timeline and plan the timeframe required for requirement gathering sessions.
• Implemented End to End Testing and assisted business in User Acceptance Testing (UAT) and performed Post Production validation.
• Worked with development teams to discuss, resolve production issues and improve performance of the payment domain application.
• Acted as a liaison between the offshore development team and onsite business team within PMO.
• Performed Data Analysis using Oracle as a backend and PL/SQL developer as the querying interface.
• Performed Data mining and cleansing for large sets of data across all financial systems using SQL and Business Objects.
• Designed Business Process Management (BPM) and Enterprise Content Management (ECM) products which included working with vendors creating roadmaps, future growth estimations, infrastructure middleware design, metrics, installation of software, and upgrades.
• Liaison between BPM Development team and business partners to resolve questions and or issues related to software and design requirements.
• Analyzed current processes and recommended future-state process models using BPM best practices, in order to enhance business processes, improve user productivity, and streamline data.
• Migrated data using FLYWAY migration tool for Oracle and SQL servers.
• Worked on ETL Informatica processes to load data from various source systems such as Oracle and Teradata.
• Performed Data modeling, data extraction, data manipulation, data definition, data control, data query and performance tuning.
• Experience in improving reporting performance significantly in tableau using extracts and context filters.

Environment: JIRA, Confluence, MS Office, BPM, SQL Server, PL/SQL, File manager, FileNet, Oracle, Informatica Power Center 9.5.1(Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Teradata 14.10, SDLC/Agile, Kanban, Scrum, Tableau, Power BI.

Senior Business System Analyst / Data Analyst Lead

Confidential, Riverside, California

Responsibilities:

• Implemented End-to-End Fully-Integrated Enterprise Reporting and Planning (ERP) System.
• Designed a prototype using silver stream designer for building a custom web-based ERP system for RCOE and all the school districts in Riverside, which consists of 20 different modules.
• Gathered requirements for two different web applications Gal Web and Electronic Time and Attendance (ETA).
• Worked with end client Confidential (RCOE) to deliver and maintain the applications for Financial, Payroll, Risk Management/Health & Welfare Benefits, Budget Development, Accounts Payable, Purchasing, Accounts Receivable, Asset Management, Credentials and Retirement System which provides and protecting information of government employees.
• Recommended process improvements and alternative solutions for Electronic Time and Attendance (ETA).
• Conducted meetings with Executives, Product Owners, SMEs, Developers and key stakeholders to gather requirements, document and present the results.
• Translated stakeholder requirements into different tangible deliverables such as functional specifications user cases, user stories, workflow/process diagrams, and data flow/data model diagrams.
• Created several Business Requirement document (BRD) and Functional Requirement document and maintained the Requirement Traceability Matrix (RTM) related document.
• Worked directly with the Business Operations Director to prepare business proposals for vendors and collaborated with attorneys and subject matter experts to develop supporting documents and coordinated the vendor selection process.
• Prioritized epic, features, requirements, issues and groomed the Business Backlog in MS TFS on a weekly basis using Agile Project Management.
• Performed quality assurance, system integration and User Acceptance Testing (UAT) facilitating on-time on-budget and acclaimed "go-live" of enterprise implementations.
• Made mock-ups to illustrate current-state and future-state functionality and change requests.
• Scripted several SQL queries to create ad-hoc reports for different business teams to validate and maintain data integrity.
• Created JIRA/Confluence workflows according to business needs while keeping up existing projects/agile boards.
• Prepared and documented Use-Cases using UML based on requirements gathered from stakeholders.
• Created executive KPI reports and dashboards using Microsoft Excel, Tableau and Power BI.
• Creating of verifying Tableau reports by writing complex SQL statements to verify the reports.
• Created and maintained all the documents in Single Point Access SharePoint link access in Enterprise Content Management (ECM) system.
• Experienced in Data Conversions, Data Migrations, Data Integrations, Data profiling, DataQuality, Data Cleansing, and Data Mapping.

Environment: JIRA, Confluence, MS Visio, MS Project, MS Office, UML, SQL Server, PL/SQL, File manager, FileNet, Clear Case, Oracle, MS Excel, SDLC/Agile, HP Quality Center (HPQC), SharePoint, Tableau, Power BI.

Programmer Analyst Internship

Confidential, Long Beach, California

Responsibilities:

• Programmer Analyst responsible for development, support and enhancement of Confidential system.
• Designed and developed JSP pages and Security Realms for Client survey.
• Implemented the associated business modules integration using spring (Core, MVC and Boot).
• Analyzed and identified components for the Presentation, Business, Integration, Resource and Service Layers.
• Worked on spring boot, Spring Rest full template to develop Application Level Micro Services.
• Developed GUI interface for an Administration Portal using CSS3, HTML5, node JS, jQuery, Java.
• Working with business stakeholders to translate business requirements into functional requirements.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Followed TDD (Test Driven development) and Junit tests.
• Used Spring Boot API’s to develop RESTful based Web Services.
• Worked in a SCRUM based Agile Environment.
• Used GIT for version control.
• Extensively configured the build files to different Environments.

Environment: Java, J2EE, JSP, Servlets, spring (Core, MVC and Boot), JavaScript, AngularJS, NodeJS, Apache Tomcat, PL/SQL, GIT, GitHub.

Business System Analyst / Data Analyst Lead

Confidential

Responsibilities:

• Act as lead in production release of Mobile media across several countries, providing point-of-contact for queries & issues for service media partners, on time release within project deadline.
• Participated in the conversion of business requirements to actionable system requirements such as functional specifications, user cases, user stories and workflow/process diagrams in conjunction with developers and system architects.
• Documented project features and requirements on Microsoft TFS for creating user stories, tasks and bugs.
• Onsite Client Interactions: Confidential, Confidential during their production environment testing of Pilot Version release.
• Managed third parties to video encode and deliver the entire Confidential Media Mobile proposition including, personalized content, ringtones, SMS, MMS, TV and video across 30 different countries with a million budget.
• Responsible for ensuring contract adherence of all of Confidential UK Media content partners which included but not limited to Confidential 18 countries.
• Project managed timely delivery of media-on-demand content, liaising extensively with Media content providers and service enablers, progressing and updating on encoding & roll-out schedules, achieving 90% turnaround globally within Business days with 24/7 support.
• Reduced the Confidential, Confidential Mobile project costs by over 35%. Spending less than 15%the previous year despite double increase in countries supported.
• Involved in documentation and designing of delivery of video assets globally with content partners, building content partner confidence and increase in media assets.
• Moved between Agile and Waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Redefined use cases, process flows and activity diagrams using MS Visio for a clear understanding of the requirements.
• Worked as an offshore coordinator for the daily status and defect triage calls with technical teams.
• Interacted with the software developers and SME’s to liaison the business requirements to ensure that the application under development confines to the business requirement.
• Gather and document user requirements for both internal business users and external clients.
• Create mock ups enhancements for user interface screens as well as design new user interface screens.
• Involved in requirement gathering and creating Business and User requirement document for approval and sign off.
• Created Functional Specifications document and conducted walkthrough sessions with the stakeholders to get approval and signoff.
• Created Test approach and Test plan for the project, conducted walkthrough for both documents and achieved approval and signoff form all stakeholders.
• Analyzed the Business Requirements document and the system requirement document to come up with a detailed Test Plan.
• Developed generic ETL graphs for loading data to Oracle DB tables from the load ready files and have good experience in building surrogate keys in serial and multi file and chaining the records.
• Extracting, Scrubbing, Transforming and loading data from Main Frame Files, Oracle, SQL Server, DB2, Teradata and then loading into Oracle database using Informatica.
• Developed customized SQL queries and reports for management for monthly reports.
• Interacted with sales channel teams and leads for customer feedbacks which helps for requirments.

Environment: Informatica Power Center 8.5.1, 9.1, UNIX / Oracle Platform, MS Visio, MS office, RUP, Rational Rose 2002, Rational Clear Quest, Rational Clear Case, Documentum Rational requisite pro, Rational test manager, Rational Robot, SQL Server, SSRS.

Business System Analyst / Quality Analyst

Confidential

Responsibilities:

• Two Years of software testing and business system analyst experience in working across all phases of STLC (Software Testing Life Cycle) on multiple projects defining processes and tools best suited to each project.
• Experience in SQL Server and extensively used SQL queries for data validation and backend testing.
• Performed GUI, Functional, Integration, Regression, Database, Stress, Load and System testing on different web-based applications and defining the tests required to verify applications based on complicated business logic.
• Gathered and maintained Business Required Documents (BRD’s) for the Insurance policies added to the projects and transform to Functional Requirement Documents (FRD’s).
• Highly proficient in preparing test deliverables such as Test Strategy, Test Plan, Test Cases and Reports.
• Designed automation test scripts using HP UFT and Selenium and executed manual test cases using HP Quality Center (ALM).
• Worked with product owners and executed Initiatives for an online payment processing tool called pentameter.
• Collected and documented test data for functional testing as documented in test plan.
• Performed manual and Selenium testing of a web-based application.
• Automated and executed regression test suites in Firefox browser via Selenium IDE.
• Performed Automated System/ Regression testing using Selenium for the Policy and Claims applications.
• Developed Automation Scripts for Functionality and Regression testing using QTP (Quick Test Professional).
• Developed VBScript for different modules.
• Developed Data Driven Automation Framework and separated test scripts and test cases to achieve the maximum reusability in the Automated Scripts.
• Deployment of SOA services to Oracle Application server and testing the services.
• Analyzed defects status using QC (Quality Center) and interacted with developers to fix defects/bugs of the application.

Environment: UNIX / Oracle Platform, QTP (Quick Test Professional) 10.00, QC (Quality Center) 10.00, VBScript, Selenium RC and WebDriver, Selenium Grid, Confidential Rational Clear Quest, SQL Server, SSRS.

Quality Analyst / Data Analyst

Confidential

Responsibilities:

• Assisted to senior QA people in writing manual test cases.
• Tested test cases against to system and validated.
• Tested VBScript and VB.Net applications by running them.
• Used Record and Replay (Linear) Framework.
• Used TSL (Test Scripting Language) as a scripting language in the project.
• Testing application and sending test reports to management.
• Software Testing, Software Quality Assurance, Automated Test Tools (Mercury Win Runner/Test Director).

Environment: TSL, VBScript, Test Director, Linear Framework, DB2, Load Runner, Win Runner, SSRS.