SUMMARY

• Oracle Certified Professional having 14+ years of experience in Oracle Application Development, OSS/BSS Solution Design, E2E Functional Consulting, System Engineering, Business Analysis, Development, implementation of commercial application and Production Support of critical business centric systems/applications.
• Over 9 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client - Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, Oracle Developer, TOAD and SQL*LOADER.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap, Reverse Key and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied Packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience in detailed design of Business Process Workflows using Case tools Such as Oracle Designer, Subversion. Strong customer interfacing, consulting experience; Proficient in client interaction and communication.
• Led large complex projects in parallel spanning across multiple technologies. Experience on Project transitioning, requirement gathering, client interfacing.
• Responsible for providing project status to all stakeholders, IT Management, Budget Analysis and PMO reporting.
• Well-versed in Data warehousing/BI Applications, architectural framework, dimensional modelling, ETL design strategy, and data presentation services using BI tools
• Extensive experience in Oracle SQL, PLSQL, Informatica, Abintio, OWB, BO, Cognos Reportnet, Rational Software Architect (RSA), Pro*C and Shell Scripting.
• Completed short learning, familiarity with syntax and implementation of Python, R, Hive and Hadoop.

TECHNICAL SKILLS

Databases: Oracle 8,8i, Oracle 9i,Oracle 10g, Oracle 11g,Oracle 12C, PL/SQL

Data and Analytics Tools/Languages: Python, R, Hive, SQL, Hadoop

Programming Languages: Cobol, C, C++, Pro*C

ETL and BI Tools-: Informatica, Oracle Warehouse Builder 9i, Abintio

Application and web Servers: Web Logic, Tomcat, Oracle 9i Application server

Reporting Tools: Cognos Reportnet 8.0, Oracle Report Reports 9i, Crystal Report 7.0

GUI Tools: Visual Basic v6.0, VC++ 6.0,Developer 2000, Forms 6i

Operating Systems: Unix, Linux, Windows

Operating System: UNIX SUN Solaris, Sco UNIX, HP, Windows 9x/2000/NT/XP/2009.

Internet Technologies: HTML, Java Script, JDBC, XML, Servlet, RMI, Java Swing, JSP

Design Tool: IBM RSA 8.0(Rational Software Architect)

Auto Deployment: Jenkins and Centops

Other tools: TOAD, SQL Developer, Eclipse

PROFESSIONAL EXPERIENCE

Confidential

System Engineer

Environment: TDP,Oracle12,Jdk1.8,Spring(4.2.4),ODI,JBOSS6.4,Hadoop,HDP,Pig,Hive,Python,R,H20,Spark,R,Mongo DB

Responsibilities:

• Collaborate and provide business analysis support to the product owner, business sponsors, SMEs and testers during development
• Proven ability in capturing requirement in BDD format for various Scenarios and to utilise the same approach in documenting system behaviour
• Answer ad hoc questions and provide clarification/direction to development and support teams regarding user stories and functions
• Support short and long term operational / strategic business activities through analysis, review, forecasting, and trending complex data
• Keen on delivering value and innovation through the product line.
• Maintaining functional specifications using TDP tool.
• Working closely with Product Owner and other Business Analysts within the program to ensure integrity of the end-to-end solution.
• Staying up-to-date on the latest process and IT advancements to automate and modernize systems.
• Develop improvements to existing processes to deliver improved business performance and effectiveness
• Assists in performing system design, development and product verification testing on control systems, software, hardware, and equipment
• Work as a part of the team and communicate effectively with software developers, product managers and other staff
• Work with a team of geographically distributed users and developers responsible for the program’s applications development function
• Work closely with the development and product teams and clearly communicates with all stakeholders .

Confidential

Solution Specialist

Environment: TOAD, SQL Developer, SQL, PL/SQL, UNIX shell scripting, Informatica Power Center 9.6, Confidential, Centops, Jenkins

Responsibilities:

• Improved application stability by Implementing and configuring changes as per industry standard, migrating to newer software and hardware and ensure continued vendor support which has reduced risk to application availability
• Post Intellicloud migration worked on performance optimization items (Hugepage, File System Binary, Storage and SQL & Informatica Performance Tuning etc.) and stabilized the Datawaerhousing environment.
• Driven multiple automation and system stabilization initiative with defined goal and target. Rolled out the Confidential Dashboard for Business intelligence Data warehousing (BIDW) platform which provides analytics and alerting mechanism on SLAs, DB trends, Golden Gate Replicate Status and many more features.
• Implemented Automation on Alerting for Password expiry, Auto monitoring and auto restart of abend jobs, Auto deployment using Centops and Jenkins and Developed & customized fa.AI, Q-bots for operational efficiency.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows 10

Confidential

Solution Specialist

Environment: TOAD, SQL, PL/SQL, UNIX shell scripting

Responsibilities:

• Developing and maintaining a thorough up-to-date understanding of the ITND platform and its various customizations and configurations for Confidential &T
• Providing software application support by answering functionality inquiries and by addressing issues through basic and advanced research and troubleshooting, as needed
• Communicating with customers and Oversight representative via phone, instant messaging, email,, online ticketing system and providing cross-functional leadership
• Managing all incoming support cases, ensuring that service level agreements are met for clients and issues are fully resolved
• Managing client reported issues, clarifying as needed with client contacts and working closely with the technical support team until resolved
• Maintaining and updating help center assets for the platform, including training materials, help quality, consistency, up-to-date accuracy and relevance of all help center assets desk materials, and videos, ensuring
• Supporting communication and knowledge sharing related to new releases, via knowledge management assets and customer service
• Owning overall client communication for scheduled maintenance, outage, security incidents, and updates.
• Overall proactive internal communication between all departments to ensure top support for clients
• Passionately coach maintenance team to change behavior from fixing problems to preventing problems through weekly team meetings and individual attention.
• Developed and implemented preventive maintenance and inventory programs for all production lines that increased productivity by 10% YOY

Confidential

Functional Consultant

Environment: TOAD, SQL, PL/SQL, UNIX shell scripting

Responsibilities:

• Attending SBP Touch Base/Status Call, Client meeting and oversight, Onshore-offshore handoff meeting
• Administrative documentation, Work Request Ananlysis,Proactive Order Fall Out issue identification and resolution
• Conduct working sessions for issues, Attend and Review SIS & RN. Attend and review High Level Design and Application Interface Document for new/changed functionalities
• Attend Defect Management call, Attend Weekly Meeting with Finance Support and estimation.
• Triage Initiation and update the Issue with oversight, Outage Management, POC for upstream/downstream apps - Call to Work, root cause analysis etc.
• Preparing Process Improvement plan, Develop and maintain Call flows, Update Operational Manual with new changes, Contribute, Review Lessons Learned after Release & Participate in Lessons Learned discussion.
• Develop, review and sign off Interface Agreement document with other interfacing applications stakeholders
• Document and communicate mitigation methods, temporary fixes, and procedures to production issues
• Identify and communicate opportunities for transaction flow and/or transaction flow through improvements
• Follow-up with Dev and ST teams for Release activities
• Gather requirements for necessary tool for monitoring, Provide SME in configuration/deployment issues, Support interfacing teams in troubleshooting, Interface with sustainment t team
• Provide support during internal and external audits
• Monitoring blocking locks in Balance Manager and ensuring higher interface latency.
• Provide input into the ongoing development of the Business Change
• Coach and mentor Business Design Analysts on the skills and capabilities required by high performing change professionals
• Manage and provide objective feedback on Business Design Analysts during each project assignment
• Influencing / networking developing internal and external business relationships and using own knowledge, skills and experience to influence others opinions and actions
• Provide design expertise to the business change projects that the Business Design Analyst is assigned

Confidential

Designer

Environment: IBM RSA 8.0(Rational Software Architect)

Responsibilities:

• Customer Requirement analysis and e2e design analysis - Analyzing customer requirements and preparing the product model for BT retail.
• Understanding the e2e design and procuring the required input from retail through e2e design.
• Defining and preparing the service products (BB access services,ISP services, VoIP Service), base and overlay promotions, contracts, discounts, Bolt-Ons, Fiber Activation Charge products, Welcome Packs, VAS products for the new product offering.
• Defining all attribute list e.g. Billing Tariff, Tariff Start Date, Geneva Tariff Name, Duplicate Tariff Flag,CON-IDs,Sales Channels, ecommerce Tariff Start Date & Effectively Start Date, Online Display & Online Display Override, Product Price Override, override attribute group etc
• Raise and resolve issues related to new product offerings.
• Define and capture the data requirements in co-ordination with e2edesign.
• Working on various product streams like BT Vision, Consumer PSTN, Broadband, and DF products etc.
• Capturing the new products attribute data and defining the flows to end systems e.g. One View, Geneva, Amdocs, OFS, Austin, ORCA, CMF, SAS, MCSO, KCI, CMF, Collaboration etc.
• Arrange design walkthrough workshops e2e designer and other stake holders and obtain sign-off

Confidential

Environment: IBM RSA 8.0(Rational Software Architect)

Responsibilities:

• Study TO-BE processes and identify the ‘best-fit’ Platforms and components.
• Gathered requirements, analyzed and wrote the design documents.
• Scheduling and conducting the CA/CFT.
• Prepare E2E Solution Design document including the Platform View, Common Capabilities, end to end component interaction diagrams and component requirements
• Lead architecture to review the solution architecture, arrange design walkthrough workshops with IT / Principal Architect and obtain sign-off
• Identify and escalate issues impacting Solution Design phase
• Define all the systems and interfaces that will be involved in the design scenarios.
• Explain the dynamic design for various scenarios
• Cover all agreed stakeholder requirements
• Provide the key data elements to be passed between components
• Describe all scenarios applicable for proposed solution