Onsite Sme Resume
SUMMARY:
I am an associate with Confidential Consultancy Services for the last 7.10 years. My main area of experience has been with PL/SQL development and Oracle BPM Production support. My technological forte is Oracle (PL/SQL) and Kenan implementation in Telecom domain and also application support in banking and Financial services. Adept at support and maintain critical computer platforms with strong ITIL skills and immediate awareness and reaction to application issues affecting internal and external customers.
TECHNOLOGY:
Languages: PL/SQL, JAVA, Shell scripting and Pro*C
Application: Kenan FX 11.7
Database: Oracle 9i, 10g
Tools: TOAD, SQLPlus, Eclipse, RAD and Rational Clear case
Operating Systems: WINDOWS - XP, Solaris
Server: Oracle BPM,JBOSS and Apache Tomcat
KEY COMPETENCIES & SKILLS:
- Ability to work effectively in a team
- Flexibility with respect to technology
- Good analytical skills
- Strong communication, interpersonal, learning and organizing skills
PROFESSIONAL EXPERIENCE:
Confidential
Onsite SME
Solution Environment: SQL, JAVA, Unix Shell Scripts
Tools: Toad,SQL developer, MS SQL, Putty, Eclipse
Responsibilities:
- Implementation of new functionalities and functionality changes according to business requirements.
- Ensured delivery of OATS FINRA files and other compliance issues and queries.
- Automation of monitoring/health checks
- Created scripts for automatically checking the systems and generating relevant status updates/alerts Perform manual health checks
- Providing support to application users
- Coordinating support between application users and the offshore team Reduced efficiently the outage time during DR activities by proper co-ordination and maintaining the stability of the environment.
- Weakly/Monthly status reporting to TCS/Client management
Confidential
Onsite SME
Solution Environment: SQL, JAVA, Unix Shell Scripts
Tools: Toad,SQL developer, MS SQL, Putty, Eclipse
Responsibilities:
- Analysis, design, development, testing, integration and implementation of new functionalities and functionality changes according to business requirements.
- Performance improvement of several time taking procedures which was causing a delay in the subsequent processes as well. This could some time create inconvenience to the users due to information which was not timely updated.
- Automation of monitoring/health checks
- Created scripts for automatically checking the systems and generating relevant status updates/alerts Perform manual health checks
- Providing support to application users
- Coordinating support between application users and the offshore team
- Weakly/Monthly status reporting to TCS/Client management
Confidential
Onsite SME
Solution Environment: Oracle BPM10.3.1, SQL, JAVA, Unix Shell Scripts, ECCO(Knowledge Management System).
Tools: BPM Studio,SQL developer, MS SQL, Putty, Eclipse
Responsibilities:
- Onsite SME for two applications(Oracle BPM and ECCO-Extra Ordinary Customer Care Online) used by Confidential Customer care professionals. The responsibilities handled include
- Impact Analysis and fixing issues
- Perform code analysis, cross reference with requirement documents and identify the root of issue. Implement fixes and workarounds
- Automation of monitoring/health checks
- Created scripts for automatically checking the systems and generating relevant status updates/alerts Perform manual health checks
- Providing support to application users
- Coordinating support between application users and the offshore team
- Weakly/Monthly status reporting to TCS/Client management
Confidential
Developer
Responsibilities:
- Configuration of Packages, Non Recurring Charges, Payments and Adjustments for Kenan billing system.
- Configuration of services for provisioning system (SCMS).
- Real time balance and expiry date calculation on every financial transaction using Pro*C and Oracle PL/SQL Triggers.
- Developed Deactivation/reactivation based on balance/expiry-date/services using Oracle PL/SQL.
- Framing text for Broadcast mail (Alerts) and identifying customers for Deactivation/reactivation based on balance/expiry date/base packages using Oracle PL/SQL packages.
- Data mapping between CRM and Billing which is used by integration layer to transfer data using EJB objects.
- Developed multi-threaded backend Java application for service suspension and package modification.
- Performance tuning for billing queries, long running SQL queries and Tuxedo.
- Involved in Multi server Architecture (MSA) for Kenan billing system to improve and maintain performance with the defined SLA.
- Involved in production support activities
- Generation of Tuxedo reports, Billing process (BIP and BIF), Key financial journal reports and management reports, Archival scripts and Provisioning system activities.
- Handling Pre/Post Bill cycle issues, clarifications & corrections are done to enable smooth bill run and to get customer satisfaction by producing error free bills and handling of customer complaints (help-desk) within SLA time.