Ashwini A.

Ashwini A.

9+ years of experience in Application Support and ETL testing

Pune , India

Experience: 7 Years

Ashwini

Pune , India

9+ years of experience in Application Support and ETL testing

42784.2 USD / Year

  • Start Date / Notice Period end date: 2024-02-20

7 Years

Now you can Instantly Chat with Ashwini!

About Me

As a Support Professional having 5+ Years of experience working in Application support with UNIX, SQL, Shell Scripting at Support Level and Automation.
Trouble shooting and configuration of various Networking components such as Router and Swit...

Show More

Portfolio Projects

Description

  • Translate business requirements into granular data needs.
  • Capture metric/ measures definitions and calculations as part of business metadata.
  • Discover data sources to address data needs.
  • Analyze discovered data for usage (profiling, critical data elements, quality analysis).
  • Communicate data understanding to Data Architects for modeling purposes.
  • Communicate data understanding to DE Team.
  • Validate data mapping to ensure coverage of To-Be reporting needs.
  • Ensure logical / physical modeling decisions of IT/ Data Architect are aligned to the functional and non-functional requirements (NFRs).
  • Plan, organize and lead the testing activities i.e. Test Preparation, Test Execution, Defect Management and Test Closure.
  • Provide oversight to Source-to-Target Mapping and Data Model to ensure requirement coverage.
  • Ensure solution design meets business data needs.
  • Report Standards (look and feel), Practices and Methods, Training Material.
  • Productionize BI Visualization.
  • Validation of dataset that is created to requirement specs.
  • Set standards for UAT and ETL testing perform Test plan execution.

Show More Show Less

Description

Responsibilities:

  • Analyzing, reviewing and assessing requirements and design specifications.
  • Review and analyze the project requirements and define test strategy, test plan and query tracker.
  • Preparing of test scenario, conditions and scripts for SIT, ETL, DWH testing.
  • Plan, organize and lead the testing activities i.e. Test Preparation, Test Execution, Defect Management and Test Closure.
  • Creation the end-to-end test scripts for Database testing and Functional Testing.
  • Create/review SQL queries based on the received mapping documents.
  • Creation, analysis and execution of the Manual Regression scripts.
  • Executing test scripts, logging defects, consolidate & report the test results to the stakeholders.
  • Review and share daily/weekly status reports with the on-site/offshore team members and all stakeholders.
  • Test case Preparation and Test Execution using TOSCA-BI Automation Tool.
  • Also worked on :
  1. Testing reconciles (initial) and delta (daily) ETL loads.
  2. Data validation by writing SQL queries on different databases.

Show More Show Less

Description

CENT Application:

Role : Assistant Manager

Duration : Jan-2017 to 25-Jul-2019

Responsibilities:

Working as Operation Specialist and provide support in the CENT (Customer Interaction Management Enterprise) system PROVIS (Vodafone Germany Commissioning System).

Daily activities and monitoring task description

As a Single resource of the Production Support, I am responsible for the follows:

Working on Automation in different systems, which has reduced lot of manual tasks and saved time.

Also worked on the Business Process Transformation, which helped team in reduction of tickets/ incidents.

Monitoring the TWS Job scheduler.

Operating & monitoring nightly CENT (and Salesforce) lifecycles.

First contact for business department (not sales staff!)

Ensure that all request are processed successfully and no orders are lost.

Ensure that all components are up and running.

Monitoring of predefined jobs & database with the ability to solve the problems and to restart the jobs / application.

Incident and Problem management including Service request.

Troubleshooting & coordinating incident management.

Create and maintain tickets in TTWOS

Ensure availability of the applications through proactive / reactive activities for the portfolio.

Timely resolution of tickets / incidents, no gaps in performing daily activities related to monitoring

Interfaces with various vendors for issues / fixes.

DO Application:

Role : Assistant Manager

Duration : Mar-2017 to 25-Jul-2019

Responsibilities:

Working as Operation Specialist and provide support for Digital Order Application.

Digital Order is an ECRM Application used for creation of digital order for the German customers with the help of PEGA and Sigma database and system. Overall Operation and maintenance of this System is taken care by ECRM with help of TWS (Tivoli Workload Scheduler), Control M, TTWOS ticketing tools.

Daily activities and monitoring task description

As a Team Member (with a team size of 4) of the Production Support Group, I am responsible for the follows:

Managing Monitor PEGA server nodes of Digital Order Application.

Responsible for ensuring the smooth collection of digital order via PEGA Based Application

Analyze system performance data such as error logs, order xml, system logs, PAL reports and escalate the bugs to vendor.

Monitoring the TWS/Control M scheduled jobs and the Lifecycles.

Restarting of the PEGA Servers on ever Monday at the start of the Business.

Coordinating with Business networking/infrastructure team in case of connectivity issues.

Analyzing the Order capture issue by checking the clipboard, tracer and by setting different log level.

Log and close issues in the TTWOS ticketing system.

Creating Test orders from Designer studio and testing of the flow for the analysis of the issue.

Verification of daily operational activities and Health of the DO application.

PROVIS Application:

Role : Assistant Manager

Duration : Jun-2017 to 25-Jul-2019

Responsibilities:

Working as Operation Specialist and provide support in the PROVIS (Vodafone Germany Commissioning System).

Daily activities and monitoring task description

As a Team Member (with a team size of 4) of the Production Support Group, I am responsible for the follows:

To ensure that all incoming interfaces are successfully loaded into the database and all outgoing files are created with all relevant information and transferred to their desired destination.

Monitoring of predefined jobs and schedules in the maestro environment with the ability to solve the problems and to restart the application.

Preparation of all data, which are used to calculate the commissions. As well as the launching and monitoring of all parts of the commission run like calculation, reporting, creating and transfer of interfaces and invoices.

The maintenance of all conditions and calculation rules for mobile and fixed wire external payments, as well as all needed reference data for commission points for the variable payments of sales employees.

Incident- and Problem management including Service request related to the mentioned topics above.

Working in projects :

Technical operational expert for project and business department.

Effort estimation for solution design and implementation.

IT – technical advice for Technical Project Leader TI.

Review of project documentation, in view of feasible solution and Possibility to operate.

Provide Information to business departments and vendors.

Manage the installation of bug fixes and software deliveries with modification of reference data and configuration files.

Show More Show Less

Description

Worked as Senior Technology Support Executive and provide support to IP Configuration, End to end configuration of networking Applications.

Daily activities and monitoring task description
As a Team Member (with a team size of 10) of the Technology Support Group was responsible for the follows:
End to end configuration of various Networking components like routers and switches.
Checking for the Level3 Network ONNET part (ONNET: all network will be level3 network) and OFFNET part (OFFNET: Some part of network will be level3 network and another part will be different vendors).
For OFFNET network need to take Edge details from corresponding vendor.
Checking of LAN cables.
Configuring different data services like IPVPN, EVPL, etc… for the enterprises and carrier customers edge JUNIPER, CISCO, ALCATEL (Brands of Router) routers and switches.
Testing and checking of devises after installation.
Monitoring Applications and servers, which runs the Application.
Configuring IP in UNIX.
Rectifying various issues at Application level.
Log and close issues in the Level3 ticketing system (EON and OMC tracker).

Show More Show Less