Microsoft Office Project
Resume:
Upali Pattanayak
**** ********** *****, *****, **, 75074 contact number#214-***-**** *****.**********@*****.***
Experience Summary
Around 11 years of sustained advancement in the areas of telecom customer care and billing in computer application for wireless & wireline telephony.
Expertise in ‘Telecom Billing Business Analysis & Implementation’ in various roles such as ‘Business Analyst’ & ’Technical Operational Analyst’.
Currently working on Amdocs TLG implementation in ATT.
Extensive work experience in analysis of Telecom Usage mediation, Rating, Billing and Product Catalogue.
Very good expertise in Software implementation and SLDC.
Worked in Agile Methodology and participated in scrum planning. Written stories in JIRA.
Vast experience in interacting with Business and analyzing the requirement. Translating the business proposals to Technical requirements.
Have done extensive client interaction
Performed troubleshooting and root cause analysis for billing and invoicing incidents
Analyzed incidents & gaps related to Amdocs BSS solutions and proposed remedy adhering to SLA & KPI.
Coordinated & facilitated working sessions and meetings with Business Units & technical teams.
Conducted Join Application Design (JAD) sessions with Subject Matter Expert's and business stakeholders to gain high level knowledge of business processes and drafted relevant documentations accordingly
Prepared business and process flow diagrams.
Excellent knowledge in MS Office and SharePoint.
Ensure Billing reconciliations and provide reporting on billing disputes to management.
Performed ticket analysis, service interaction analysis, triaging of issues, follow up
Performed stakeholder’s requirement analysis, analysis of current and future state business process.
Developed solution requirements and design specifications for client engagements
Translated business requirements to technical requirements.
Performed extensive communication with clients on business needs and IT personals.
Participated in scoping sessions, facilitating creation of solution related documents.
Participated in review of Test Scenarios and help formulating test cases for UAT.
Performed creation of specification documents to meet business requirements.
Led teams to address business and system related issues across platforms.
Prepared traceability matrix for new projects. Identified gaps and suggested process to mitigate gaps for future initiatives.
Appreciated in the organization and by clients for strategic thought process, innovative process improvement changes and proactive approaches.
Worked in different phases of Systems Development Life Cycle (SDLC) in Waterfall and Agile/Scrum.
Good knowledge in creating Test Plan, Test cases.
Good knowledge CRM software application.
Maintained & balanced transactions and immediately corrected any discrepancies.
Good knowledge of Amdocs Billing system
Good working experience in Mercury Interactive Tools (Test Director, Quality Center)
Good working experience in IBM process tools like Net Cool, Tivoli.
Good Experience working in Microsoft technologies
Good working experience in developing UNIX scripts, SQL scripts.
Good working experience in Amdocs Tools like BRAT tool, AMC tool, AOTS
Excellent knowledge of SDLC and QALC.
Very Good experience working in a team and also independently.
Excellent communication, technical and interpersonal skills.
Worked for clients like AT&T, USA, O2-Telefonica, and Ireland.
Have done extensive client interaction and worked in team across different geographical locations
Employment History
Ignite Management Consulting - Sr. Business Analyst (Aug’10-Till Date)
IBM - Business Analyst (Jul’08- Apr’10)
Amdocs Inc., USA - Senior Business Operations Analyst (Aug’07 – Feb’2008)
Genesis Network., USA - Billing Operation Analyst (Jan’07 – Aug’07)
TEKSystem, USA - Billing Operations Analyst (Sep’06 – Dec’07)
Domain specific product Skills
Amdocs Ensemble, Invoicing, Amdocs Rating, Amdocs Customer Management
Comptel Mediation, Alcatel IN
Portal Testing
Telecom Long distance
Areas of Expertise
Telecom Business Analysis
Telecom Operational Analysis
Telecom Billing Testing
Telecom Billing production support
Agile Methodology
Unix & SQL scripting
IBM tools for process and Alerts
Amdocs Ensemble, Invoicing, Rating
Manual & Automated Testing
Different Testing tools
Software Testing plan & process
Selected Achievements
Past performances recognized by high professional estimation marks, customer appreciations and special bonuses.
Mentoring new joinees in IBM.
Professional Trainings Attended
Name of the Course
Name of Institute
Duration
Major Topics
Diploma in Software Engineering and Testing
Centre for Advanced Computing (CAC)
2 years
Software Engineering, Software Analysis & Design, Operating System, Testing Engineering,
And Industrial Management etc.
Technical Skills
Telecom Billing Systems
Amdocs Ensemble, Amdocs Billing, Invoicing, Telecom Customer Management, Amdocs Rating, Telecom Reject Handling, Alcatel IN, Comptel Mediation, Amdocs RBMS
Languages
UNIX shell script, SQL, SQL/PL-SQL scripting
Databases
Oracle 8.0/8i, SQL, MS Access 97/2000., TOAD
Operating Systems
UNIX, Windows 95/98/2000/XP/NT
Testing Tools:
Quality Center, Test Director, NetCool, Tivoli, ESP workstation, Remedy, Clarity, BRAT tool, JIRA
Other
Microsoft Office 97, Microsoft Office 2000., AOTS, SharePoint
Educational Qualifications
Bachelor of Technology (B.Tech) – 2004
National Institute of Technology, Rourkela
WORK EXPERIENCE
Organization: - Ignite Management Consulting, USA (08/23/2010 – Till Date)
Project Details:-
Position: - Sr. Business Analyst
Project: - AT&T Telecom Billing System, USA
Roles and Responsibilities:-
Analyzed business requirements and prepared technical specifications.
Identified gaps and facilitated closing the gaps with best practices.
Converting business requirements into process flow.
Prepared traceability matrix and analyzed business problems and suggested process and plan to delivery teams.
Communicated with business teams to create requirements.
Handled TLG defect management and reporting
Conducted scrum planning. Written stories in JIRA.
Performed analysis of defects and assigning to proper team and follow up.
Analysis of any Enabler & telegence core and custom code changes and doing change management.
Performed Test estimation and planning.
Prepared various status reports for higher management.
Making sure that the proposed solution provided by Amdocs is efficient and fulfill the business needs.
Worked closely with end-users to determine scope, identified tasks and dependencies, provided estimates and revised project plans to reflect progress and changes in scope and priorities
Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
Coordinated & facilitated working sessions and meetings with Business Units & technical teams.
Supported the System Test, E2E Test & UAT
Assisted in Business Readiness and Cutover activities. Creating mini-specs and process documents.
Responsible for analysis, root cause analysis, fallout exception Process and end to end system integration.
Participate in solution build and deployment activities.
Performed Long Distance operation and maintenance.
Tracking issues and alerts in NetCool ( an IBM tool for alerts)
Analyzing billing rejections in BRAT tool ( an Amdocs Tool)
Preparing daily & weekly project status report and help management understanding the bottlenecks.
Customer facing for new changes in the system and analysis
Called meetings to discuss the findings in the executed bill cycles and decide the next steps.
Clearly documented all the process & mentoring new joiners.
Coordinating with development team regarding the complex reject scenarios and to check for possible code issue.
Communicate across multiple levels of the organization including senior leaders within the
Business and IT
Product:- Amdocs Telecom Billing, Amdocs Ensemble, Microsoft Office, HP Quality Center, JIRA. NetCool, Tivoli, Remedy, Clarity, BRAT tool, ESP work station, AMC tool, Oracle TOAD
Environment: UNIX, Oracle, Windows 2000, Windows Words, Excel, PowerPoint
Technical Programming Language:- UNIX shell scripting, Oracle SQL programming
Organization: - IBM (07/25/2008 – 04/21/2010)
Project Details:-
Position: - Business Analyst (Telecom Billing Software)
Project: - O2 (Telefonica), Ireland
Roles and Responsibilities:-
Interacting with the customer and understanding the business need.
Translating the business requirement into technical terms for vendors like Amdocs.
Lead multiple projects for solution offering, developing solution strategy.
Translate system requirements into software design documentation
Helping in designing test plans, development plans and understanding the requirements.
Participated in scrum planning and have written stories in JIRA
Creating proposals and gap analysis. Doing recommendation to the customer.
Called meetings to discuss the findings in the executed bill cycles and decide the next steps.
Clearly documented all the process & mentoring new joiners.
Coordinating with development team regarding the complex reject scenarios and to check for possible code issue.
Communicate across multiple levels of the organization including senior leaders within the
Business and IT
Performed Test estimation and planning.
Prepared various status reports for higher management.
Making sure that the proposed solution provided by Amdocs is efficient and fulfill the business needs.
Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
Discuss with the client on any gap or test result expectation and if needed change in test plan.
Defect management via Quality Center
Analysis of any performance issue and take it to the architects
System issues analysis and new change requirement analysis.
Preparing daily & weekly project status report and help management understanding the bottlenecks.
Participate in deployment planning and release.
Interacted with the development team to understand some functionalities of the application.
Called meetings to discuss the findings in the executed tests and decide the next steps.
Clearly documented all the project related work.
Mentoring new joiners.
Participated in Client on job training and UAT.
Product:- Amdocs Telecom Billing, Amdocs Ensemble, Microsoft Office, HP Quality Center, Remedy, Clarity, Oracle TOAD, JIRA
Environment: UNIX, Oracle, Windows 2000, Windows Words, Excel, PowerPoint
Technical Programming Language: - UNIX shell scripting, Oracle SQL programming
Organization: - Amdocs Inc., USA (08/27/2007 -02/22/2008)
Project Details:-
Position: - Senior Business Operations Analyst.
Project: - Cingular Telecom Billing Operations System, AT&T, USA
Roles and Responsibilities:-
T1- Application support for Telecom Billing
Ongoing support for operations & Telecom billing system implementation
Customer facing for new changes in the system and analysis
Maintaining & Updating scripts for Bill Cycle run rejection handling.
Maintaining UNIX shell scripts
Maintaining Oracle SQL & PL/SQL scripts.
Running Amdocs Telegence Billing cycles in various modes.
Preparing daily & weekly project status report and help management understanding the bottlenecks.
Called meetings to discuss the findings in the executed bill cycles and decide the next steps.
Clearly documented all the process & mentoring new joiners.
Tracking issues and alerts in NetCool ( an IBM tool for alerts)
Processing jobs and system operations in Tivoli ( an IBM tool for system operations).
Analyzing billing rejections in BRAT tool ( an Amdocs Tool) .
Participate in deployment planning and release.
To do the 1st level of investigation for any kind of rejection that occurred during the cycle.
To fix the commonly happened rejects, mostly data related issues.
Coordinating with development team regarding the complex reject scenarios and to check for possible code issue.
To run various pre-billing and post-billing scripts to ensure that the Billing cycles should be closed in targeted periods.
Was part of a team that extensively worked to achieve and maintain the target of K+5 in Cingular model.
Product:- Amdocs Telecom Billing, Amdocs Ensemble, Microsoft Office, HP Quality Center, NetCool, Tivoli, Remedy, Clarity, Oracle TOAD
Environment: UNIX, Oracle, Windows 2000, Windows Words, Excel, PowerPoint
Technical Programming Language:- UNIX shell scripting, Oracle SQL programming
Organization: Genesis Network (Dallas, USA) (01/02/2007-08/25/2007)
Project Details:-
Position: - Billing Operational Analyst
Project: - Cingular Telecom Billing Reject Testing AT&T, USA
Roles and Responsibilities:-
T1- Application support for Telecom Billing
Ongoing support for operations & Telecom billing system implementation
Customer facing for new changes in the system and analysis
Maintaining & Updating scripts for Bill Cycle run rejection handling.
Maintaining UNIX shell scripts
Maintaining Oracle SQL & PL/SQL scripts.
Preparing daily & weekly project status report and help management understanding the bottlenecks.
Running Amdocs Telegence Billing cycles in various modes.
To do the 1st level of investigation for any kind of rejection that occurred during the cycle.
To fix the commonly happened rejects, mostly data related issues.
Tracking issues and alerts in NetCool ( an IBM tool for alerts)
Processing jobs and system operations in Tivoli ( an IBM tool for system operations).
Analyzing billing rejections in BRAT tool ( an Amdocs Tool)
Participate in deployment planning and release.
Called meetings to discuss the findings in the executed bill cycles and decide the next steps.
Clearly documented all the process & mentoring new joiners.
Coordinating with development team regarding the complex reject scenarios and to check for possible code issue.
To run various pre-billing and post-billing scripts to ensure that the Billing cycles should be closed in targeted periods.
Was part of a team that extensively worked to achieve and maintain the target of K+5 in Cingular model.
Product:- Amdocs Telecom Billing, Amdocs Ensemble, Microsoft Office, HP Quality Center, NetCool, Tivoli, Remedy, Oracle TOAD
Environment: UNIX, Oracle, Windows 2000, Windows Words, Excel, PowerPoint
Technical Programming Language:- UNIX shell scripting, Oracle SQL programming
Organization: TEKSystem (Dallas, USA) (09/05/2006-12/31/2006)
Project Details:-
Position: - Billing Operational Analyst
Project: - Cingular Telecom Billing Reject Testing System, AT&T, USA
Roles and Responsibilities:-
Maintaining & Updating scripts for Bill Cycle run rejection handling.
Maintaining UNIX shell scripts
Maintaining Oracle SQL & PL/SQL scripts.
Running Amdocs Telegence Billing cycles in various modes.
To do the 1st level of investigation for any kind of rejection that occurred during the cycle.
Preparing daily & weekly project status report and help management understanding the bottlenecks.
To fix the commonly happened rejects, mostly data related issues.
Coordinating with development team regarding the complex reject scenarios and to check for possible code issue.
Tracking issues and alerts in NetCool ( an IBM tool for alerts)
Processing jobs and system operations in Tivoli (an IBM tool for system operations).
Analyzing billing rejections in BRAT tool ( an Amdocs Tool)
Called meetings to discuss the findings in the executed bill cycles and decide the next steps.
Clearly documented all the process & mentoring new joiners.
To run various pre-billing and post-billing scripts to ensure that the Billing cycles should be closed in targeted periods.
Was part of a team that extensively worked to achieve and maintain the target of K+5 in Cingular model.
Product:- Amdocs Telecom Billing, Amdocs Ensemble, Microsoft Office, HP Quality Center, NetCool, Tivoli, Remedy, Windows Words, Excel, PowerPoint, Oracle TOAD
Environment: UNIX, Oracle, Windows 2000
Technical Programming Language:- UNIX shell scripting, Oracle SQL programming
Management Concepts:
Leadership & organizational behavior.
Contact this candidate