Data Service

APARNA PAUL

Consultant Business Analyst

************@*****.*** 973-***-****

Professional Summary

Solutions-driven and skilled professional with experience in managing complex IT projects & leading cross-functional teams in development, maintenance, documentation and delivery of process innovations driving the business goals.

Domain Experience in Banking & Lending Financial Services, Telecom & Energy Sector.

Have expertise in working in shared services and infrastructure services environment.

Excellent work experience in Project Management, Project Release Management, Change management and Configuration Management Plans.

Have worked across SDLC methodologies like Agile, Scrum, Kanban & Waterfall model

Defect reporting and Tracking using tools like Jira, Rally, QC ALM and Internal tools

Adept in creating Business Requirement, Solution Summary, Functional Requirement and Design Documents to formulate Test Plans, Use Case Analysis, Activity Diagrams, Entity Relationships & Data Flow Diagram.

Versed with API REST/ SOAP Testing for functional Project modules, Black box and functional Testing.

Worked on SQL to manipulate and extract data from large relational databases.

Versed with BI Tools and Tableau for analytical problem-solving.

Have knowledge and worked on build management tools and build and release engineering tools (Jenkins, ServiceNow, TERMS)

Troubleshoot, investigate and execute complex data related tasks (manipulation of data, reports design).

Professional Certifications

CERTIFIED SAFe5 Scrum Master: Scaled Agile, Inc: 642*****-****

CERTIFIED SAFe4 Scrum Master: Scaled Agile, Inc: 264*****-****

ITIL 2011 Foundation Certified: APMG International: 02307888-01-28VV

Tableau 10 A-Z Hands on training: Udemy-UC-W90UBM9A

Project Management Certification:

EXIN-PRINCE2 Foundation (PR2F) Certified-5122424.20304805

EXIN- PRINCE2 Practitioner (PR2P) Certified-5122424.20306417

Areas of Expertise

Software Development Life Cycle

Impact Analysis

Strategic Planning/Analysis

Agile Project Management

Quality Assurance

Object-Oriented Analysis

Defect and Bug Tracking

Release Management

Data Analysis

Use Cases

Relationship Building

Product Management

Skills Profile

Technical

Database management and User Interface and Query Software

Microsoft Access, Microsoft SQL Server, Structured

Query Language SQL, Procedural Query Language PL/SQL

Languages

SQL, C, C++, Core Java

Application server Software

GitHub, Pivotal Cloud Foundry (PCF), WebSphere

Content workflow software

JIRA, CA Technologies Rally, ServiceNow

Program Testing Software

API Testing using POSTMAN, Defect Tracking Software HP ALM, Rally, JIRA, HP QC.

Project Management Software

Microsoft SharePoint

Analytics Tools

Microsoft Excel, Tableau, BI Desktop

Operating System Software

Unix, Linux, Windows XP/7.0/8.0/10.0

Access Software

Citrix

Other

MIRO board, Clarity, AppDynamics, Autosys, Real Time Board, Eclipse, Technical Business Analysis, Business Consulting, Business Process Mapping, Data Architecture, MDM, Agile Scrum, Project Management

Functional

Management and Leadership Skills

Excellent Analytical & problem-solving skills

Excellent in providing consultancy services

Ability to respond to pressure situations with minimum ETA

Excellent client interfacing skills with proven client appreciation

Excellent Communication skills

Presentation & Interpersonal Skills

Adaptability to any given work conditions

Ability to be a good team player.

Professional Experience

Capgemini America Inc., Illinois, USA

Client: Discover Financial Services

Mar 2018 – Jan 2021

Business System Analyst

Client Description : Discover Financial Services is an American Financial services company, which issues the Discover card and operates the Discover and pulse networks. Discover Card is the third largest credit card brand in the United States, when measured by cars in force, with nearly 50 million cardholders.

Project Description : Orion-Customer Service Engagement contains many service applications . Orion is Discover's critical and premier application used by card member service and banking agents to access Card Member account information. This information includes balance, payments, account status, history authorization and many others. Orion is a client/server Java Swing application having 550+primary screens, supporting 100+ business processes and calling more than 40+ external services.

Key Responsibility Areas:

Work with software application and data architectures/SMEs as required for Business and Software mapping and creation of roadmaps for implementing technology solutions relevant to executing on specified strategy.

Responsible for managing all aspects of the project such as project planning, requirements gathering, elicitation and definition, risk management, communication and implementation planning following Agile Model.

Act as a single point of contact for offshore team and other vendors/application teams in tracking and review of deliverables.

Create ServiceNow (SNOW) tickets for network changes/issues and assigned them to respective functional teams.

Involved in gathering business requirements for the data warehouse as well as business intelligence reports.

Created a Master spreadsheet with information and governed the deployment of approximately 1025 servers which was migrated to a higher version of different OS.

Troubleshoot, investigate and execute complex data related tasks (manipulation of data, mathematical calculations, reports design).

Modeled core Agile principles of collaboration, prioritization, team accountability and visibility. Ensured consistent application of Scrum methodologies across the team.

Prepared Software Requirement Specifications, Functional Specification Document, converted functional and non-functional requirements into user stories for Agile-Scrum development framework.

Developed Test Scenarios/Scripts and Test Plans. Prepared User Acceptance Test Cases, UAT issue log for tracking the defects in JIRA and collaborated with system users to conduct UAT.

Reviewed and assisted the team in functional testing of the application prior to demo in the sprint review meeting.

Responsible to review the development with respect to requirement documented in detailed design documents, Rally and coding standards provide by the client for the respective modules.

Work on functionalities for ORION Application with the help of offshore team and by referring to detailed design documents and user stories in Rally using various tools, technologies and software development programming languages i.e., SOAP/REST Web Service, JWT, PCF Pivotal Cloud Foundry.

Perform coding, code review and document review for Functional, Design and Test Cases.

Participate in the Program Increment (PI) events for the sprint planning.

Responsible to design documents like High Level Design Documents (HLD) for converting business requirements into technical design together with architectural team based on functional knowledge and also creating Go Live Document, RDT Document as part of project closure activities.

Helps the team embrace SAFe Core Values, adopt and apply SAFe Principles, and implement SAFe practices.

Software/ Special Tools: Agile, Scrum, ServiceNow, RALLY, QC ALM, Postman tool, GitHub, Jenkins, Pivotal Cloud Foundry (PCF), App Dynamics, JIRA, SQL, MS Share Point, MS Visio, MS Project, Waterfall, WebSphere, Tableau, Power BI

Capgemini India Pvt. Ltd., Mumbai, India

Client: Total SE

Apr 2015 – Aug 2016

Business Analyst

Client Description : The Total group is a French multinational energy player, which produces and markets low-carbon fuels, natural gas and electricity.

Project Description: Project dealt with Marketing Services for developing Internal Reporting system based on data management tool to analyze, visualize, understand and use information about customer buying expenditures. Marketing services are EJB-RMI middle tier services exposed as Web-Service which fetches data from backend, applies common logic and provides them to various frontend application . As these services returns data for statement, transactions, promotion and related functions, availability of these services is critical and being common between many front-end applications makes it more important.

Key Responsibility Areas:

Driven the Lean improvement plan to achieve the target of service request breaches to be less than 2% and maintained the SLA compliance at 98%.

Collaborated with Business Users to gather requirements for Change Controls and ensured that change management procedures are followed across the project.

Conducted sprint planning and finalized story backlog in a 4-week sprint cycle and also participating in retrospective meetings to enhance stories with more specifications.

Worked on documenting and automating the existing manual project log- process for release into ServiceNow.

Worked with Process Owners and Subject Matter Experts to incorporate BAU requirements and enhancements.

Documents business processes and system workflows, documents and maintains end-user and internal system documentation ensuring that all required documentations are complete, comprehensive, and delivered on time.

Estimation of development, review and testing activities and prepration of milestone and share milestone plan with client and offshore team.

Engaged with management team and key stakeholders to determine product, growth and company strategy based on analytics and insights.

Provided continuous stage and production release support.

Assists product teams in implementing product strategies and participates in the user testing process.

Performed data analysis using regressions, data cleaning, excel v-look up, data representation for the service request using SQL to produce weekly and monthly reports for trend analysis.

Software/ Special Tools: Agile, Scrum, ServiceNow, RALLY, QC ALM, Postman tool, GitHub, Jenkins, Pivotal Cloud Foundry (PCF), App Dynamics, JIRA, SQL, MS Share Point, MS Visio, MS Project, Waterfall, WebSphere, Tableau, Power BI

Global Cloud Xchange, Mumbai, India

Network Operations Center

Aug 2012 – Apr 2015

Business and Change Analyst

Client Description : Global Cloud Xchange sells access to the world’s largest private undersea cable system. It offers comprehensive portfolio of solutions customized for carriers, enterprises and new media companies.

Project Description : Providing transmission and IP based services to most of the carriers for Assurance, Fulfillment and Service Management. Handled the change management activities for multiple service providing carriers.

Key Responsibility Areas:

Translated customer requirements into functional/technical requirements & deliver the same to offshore development team.

Assist Product Owner and Scrum Master on a day to day basis to keep business strategy/vision and IT processes in the alignment of the defined roadmap. Contributing business stakeholders in formulating business requirements /overall Product Scope.

Deliver effective presentations of findings and recommendations to multiple levels of stakeholders, creating visual displays of quantitative information.

Perform detail data analysis at component level and provide detail technical design document for requirement.

Work with client to assist in the design of solutions that satisfy all business requirements.

Perform issues/rework analysis of the developed code and reduce the defects.

Troubleshooting, fixing, and implementing bug fixes and enhancements within tight deadlines.

Work with front-end team to setup the data for all the expected test cases. And verify the result for flawlessness. Identify and capture the defect at UAT and escalate to project lead for mitigation/resolution.

Ensure proactive fault management for managed customers.

Activation of new services onto the network and ensure quality is maintained ensuring any network changes are recorded and logged onto Configuration databases.

Take care of Change ticket creation, participate in planned works and drive the ticket to completion.

Reduced quality assurance expenses by 20% maintaining a uniformity between requirements from client side and development team to ensure network database integrity.

Provided guidance and coaching to program sponsors and business unit management to facilitate successful transformation.

Software/ Special Tools: ITSM, BMC Remedy7.1/8.1, Tableau, JIRA, Visio, Rally, Operational Support Systems (CLARITY-OSS / CRAMER / FAST)

Tata Communications Transformation Services, Mumbai, India

Client: Telstra

Aug 2011 – Jul 2012

Graduate Engineering Trainee

Client Description : Telstra is Australia’s largest telecommunications solution provider including network, cloud services, data hosting and satellite services, mobile, internet and other service.

Project Description : Project involved Design, Configuration & Service Activation of Broadband services and Activation, Modification & Disconnection Of PSTN (Public Switched Telephone Network).

Key Responsibility Areas:

Worked as Graduate Engineering trainee for service activation team for Telstra, Australia client and was responsible for trouble ticket handling and network activation (e.g., PSTN, ADSL, ISDN etc.)

Work with business team, cross functional team in providing inputs on detail level business process flows and identifying important business processes that need technical improvements.

Was responsible for Activating, modifying and disconnecting the wireline voice and data services.

Manage Master Data Management – to identify where and how the legacy data is stored in oracle tables.

Configuration of service using a web-based system -Order Manager.

Worked on configuring Multiplexing Devices namely CMUX (Customer Multiplexer) and RIM (Remote Integrated Multiplexer).

Troubleshooting, fixing, and implementing bug fixes and enhancements within tight deadlines.

Provide technical and procedural support for User Acceptance Testing (UAT).

Owned and followed customers’ issue until final resolution, meeting productivity and quality targets.

Software/ Special Tools: Order Manager, Unix, JIRA, RALLY, Excel, ALM

Education

Educational Record (In Reverse Chorological Order Starting Highest Degree)

Course of Study

Specialization

Name of University

Address of University

Year of Completion

Master of Science

Information Technology and Analytics

Rutgers, the State University of New Jersey-Newark

Newark, New Jersey, USA

Dec,2017

Bachelor of Engineering

Electronics

University of Mumbai, India

Nerul, Navi-Mumbai, India

May,2011

Contact this candidate