PL/SQL developer

PREETHI VEMURU

SUMMARY

• * plus years of professional experience in IT industry involving in scoping, design, development, testing, maintenance and production support in Telecom, and Banking domains across North America,EMEA and ASPAC markets.

• Good knowledge on IRB (Infinys Rating and billing) Telecom product and application functionality, production and operational support.

• Experience in writing UNIX and shell scripting, Perl scripting, PL/SQL stored procedures, SQL queries for various on-demand Operational needs.

• Strong skills in Requirement gathering and study, Business Analysis, Recommendations to Business Process Improvements, Development and documentation of Procedures.

• Good knowledge on RBA tool (Rating and Billing Automation) that is extensively used in Production environment to automate Operational Process and streamlining them.

• Perform Advanced Diagnostics, i.e. activities which include examining the system configuration for any possible problems, looking at the UNIX system and error logs,checking customer data to the extent required to identify the cause of the problem and the area of the software in which the problem is located.

• Troubleshoot, replicate in a controlled environment (and documenting how this was achieved), and resolve critical production problems which get reported and facilitate rapid problem resolution.

• Ensure compliance with production-related Support Agreements.

• Proficiency in working with multiple UNIX platforms / Applications and Sub Systems.

• Quick Learner, good analyst with organizational ability and can blend in, taking initiative and relish new challenges.

• Having good Communication and Client facing skills.

EDUCATION

B.Tech in Electronics and Communication Engineering - Sree Vidyanikethan College - 2006-10

TECHNICAL SKILLS

Database - Oracle 11g

Operating Systems - Sun OS 5.10, HP-Unix, Windows XP

Languages - Perl, Shell programming, Oracle SQL/PLSQL

Billing Systems - Infinys

Mediation Systems Digital Route - Active Mediation

WORK EXPERIENCE

Bank of America Continuum Solutions Ltd, India Aug 2015 – July 2016

Development & Post Production Support

Environment (with skill versions) Software Languages: Shell script, XML, SQL & PL/SQL

Database: Oracle 11g. O/s: UNIX Solaris

DataLink is a messaging application, which integrates various systems within Bank of America Merrill Lynch including some external clients. It is a middleware application providing reliable, scalable and flexible message transformation, filtering and routing services to many application teams across EMEA and AMRS region. It also applies various business rules, values based routing, message based routing, and transform messages between applications.

Roles & Responsibilities

• Analyze the system and business requirements and designing operational solution.

• Construct the enhancements as per requirements provided by the clients and delivering fixes.

• Prepare the implementation strategy for Daily/Monthly Operational processes and providing the support for implementation of the applications within the strategy limit.

• Automation of daily running Operational processes and schedule the jobs in AutoSys.

• Monitor the health of the application in ITRS framework and configure the alerts accordingly.

• Monitor Server logs in case of any issues or recent changes being moved to production.

• Working on code releases, right from gathering requirements from Client/trader and leading the release till implementation.

• Understanding the issues and suggesting the possible way of implementing technically.

• Handling critical incidents in Production and engage respective teams to resolve issue and ensure SLA's are met.

• Ensure the Completion of Batch/Monthly jobs in Production within agreed upon SLA, and stabilizing the solution platform.

• Coordinate with Onshore team and clients.

NetCracker Technologies Ltd, India Aug 2013 - Aug 2015

Programming Analyst

Environment (with skill versions) Software Languages: Perl, Shell script, SQL & PL/SQL Database: Oracle 11g. O/s: UNIX Solaris

Telefónica UK are launching a new payment option, whereby subscribers will be able to purchase services from 3rd party merchants (Aggregators) and be charged for these purchases via their O2 bill. Convergys has been engaged by Telefonica to provide the scope for a full billing system upgrade.

ViaSat delivers affordable two-way broadband Internet access via satellite to virtually any home and small business throughout rural America (for approximately 425K customers) to any location for both government and commercial customers. In the last quarter of 2009, ViaSat announced plans to acquire WildBlue. Convergys has been engaged by ViaSat to provide the scope for a full billing system upgrade.

Roles & Responsibilities

• Accountable for gathering user requirement, analysis and design, development, testing and implementation of Operational processes and their daily maintenance.

• Handled CR's of ViaSat and Telefonica Client, Using PL/SQL procedures and Perl scripting.

• Automated Telefonica's complete Rating and billing flow using Perl and PL/SQL.

• Develop reports and scripts as per requirements.

• Engaged in inter-line initiatives for minimizing human error and streamline processes to improve the issue turnaround time and reduce human errors.

• Provided technical inputs to team for streamlining operational processes.

• Pro-actively Automated several Daily/Monthly Backup/purge scripts to handle huge customer volume in Production environment, and developed several pre and post validation scripts of billing and finance jobs and application start up and shut down scripts.

• Closely monitor all the Operational jobs and trouble shoot that includes checking the the UNIX system and error logs, customer data to the maximum extent to identify the cause of the problem and fixing the problem.

• Provided Level 2 and 3 supports, ensured that issue SLA's are met.

• Co-ordinate with Release and Change Management teams for deploying the emergent patches supplied by third and fourth line support within agreed timescales.

• Mentor the junior team members

NetCracker Technologies Ltd, India Sep 2011- Aug 2015

Programming Analyst

Environment (with skill versions) Software Languages: Perl, Shell script, SQL & PL/SQL Database: Oracle 11g. O/s: UNIX Solaris

Worked on Cricket Project(North American Telecom Service Provider)where I got the opportunity to work on multiple IRB Components like IAM, OM/OFM(Order/Offer Management) a Customer Self Service portal for various functions includes Viewing account transaction and usage history, registering payment methods for customer balance replenishment and seamlessly interacting with Service Provisioning and Activation modules that interfaces with network elements and Cricket ESP component to supply provisioning.

Roles & Responsibilities

• Developed SQL scripts, PL/SQL stored procedures for several adhoc data requests from client in Production and delivering the required needs in time and received appreciations.

• Provided support for Post Production issues and managed the Operational Support as well. Initially, I was the only person and key resource from offshore team who was supporting prepaid solution by interacting with client as well as the onsite team. Later, we have developed a team of 4 members for its post-production support.

• Co-ordinate with SIT and UAT testings for the new custom enhancements and testing the features in Performance environment with huge volumes and identified performance issues and resolving them in advance and resulted in quality delivery.

• Configuration of alerts and monitors for all the real time Rating/Billing/Finance/Collection Receivable Jobs using RBA and Perl Scripting and maintenance of this project.

• Debug the functional issues raised by Client and replicating the same into Test/DEV environments and providing solution and improved my analytical skills.

• Identified and fine-tuned several performance issues for daily/monthly operational jobs to improve the performance.

• Provided RCA for critical issues.

• Following proper Escalation process during critical issues in Production environment and jumping on to Client Conference bridges and provide status updates.

• Mentor the junior team members and help them to come up to speed.

Convergys Information Management, India June 2010- Aug 2011

Associate Programming Analyst

Environment (with skill versions) Software Languages: Perl, SQL & PL/SQL Database: Oracle 11g. O/s: UNIX Solaris

Worked on T-Mobile (Wholesale) solution, a US based carrier for wholesale billing and solution is a fully integrated system having multiple components Mediation and Billing. I was completely responsible for end to end process includes Active Mediation (IAM) Collects usage data from telecom networks and forwards the processed information to downstream systems, primarily for Rating (online/batch) based on multiple service schemes and billing of initiation, product and service charges based on various cycle basis and integrating into single invoice and delivering to the end customer without missing SLA’s (Service Level Agreements) with the business.

Roles & Responsibilities

• Accountable for gathering user requirement, analysis and design, development, testing and.implementation of Operational processes and their daily maintenance.

• Going through Design documents for the new enhancement features for the customization in Rating and Billing products and analysing the functional and performance impacts and delivering fixes.

• Designed and developed various Wrapper scripts (Perl and shell scripts) that internally invokes core and custom binaries and developed data validation scripts.

• Automated various daily/monthly Operational stats and reports and stats through various PL/SQL procedures and designing several Perl modules using RBA (Rating and Billing Automation) tool for the on-time availability of reports and gaining Client confidence.

• Proactively identified several functional and performance issues during Product Readiness Testing issues (PRT) for the new features and resolved them to improve the quality of deliverables.

• Organize weekly meetings with onsite team for day-to-day operations and identify opportunities to improve the collaboration.

• Closely monitor all the Operational jobs and trouble shoot that includes checking the UNIX system and error logs, customer data to the maximum extent to identify the cause of the problem and fixing the problem.

• Streamline and automate operational processes, using new RBA framework.to reduce manual intervention.

AWARDS AND HONOURS

• Received Spotlight Employee Excellence (SEE) Award for RBA Automation of Cricket project for reducing the manual intervention and human errors and also improving the team's productivity.

• Received NetCracker Excellence award for dedicatedly working on Cricket RB Upgrade project and implementing the solution in new environment and fixing the issues.

• Got SEE award for being flexible to enhance the support for Telefonica and ViaSat solutions and providing support meticulously, RBA Automations that helps reducing the manual intervention and improving the team's productivity without missing anything in a short span of time and gaining Client confidence.

• Received Global Recognition - Silver and Bronze awards in Bank of America for grasping the solution quickly and effectively supporting critical Production activities in a short span of time.

Contact this candidate