Oracle PL/SQL Developer
Resume:
Veerender Singh
**********@*****.***
Professional Experience
● Total experience 14 years
● Working with NVIDIA as Sr.Oracle Consultant and Developer
● Telecommunication industry experience 11 years
● Worked on CRM and Billing systems like Oracle BRM,Kenan OM &BP,BSCS and Seibel
● Face to Face interaction with Client
● Effective Communication Skills and a ‘Can Do’ attitude Certification
● Oracle Certified Professional (DBA)
● Sun Certified Programmer (JAVA)
● 2003 Master of Science(IT)from Punjab Technical University Jalandhar,India Development
● Oracle PL/SQL development with large Telecoms around the world like Vodafone, Etisalat, DU,OPTUS (Singtel),MTN and Airtel
● Experience in Amazon SaaS Database
● Working knowledge in MySQL and DB2.
● End-to-End Oracle Architecture and Data model knowledge.
● JAVA,UNIX shell,Pro*C development experience.
● HPUX, Solaris, UBUNTU, Red Hat, dev and test environments, cron-jobs, sudo access etc.
Functional
● AGILE scrum-master.
● Scrum Master, Sprint management and daily burndown/stand-ups management
(AGILE)
● Team Management and mentoring
● Managing documents through to sign off like SOW, SOE, CBR, Testing (UTP, UAT), Design Description (HLD &LLD)
● Providing analytical guidance in building solutions to the business client
● Provides leadership to the project team and client on the impact of market and regulatory changes and the future directions of the core products
● Responsible for delivering feedback to the core product teams to ensure that future releases of the products meet the ongoing needs of the client/business
● Managing workshops with Vendors and internal teams Experience
Sr.Oracle Consultant
NVIDIA October 2015 -Present
● Formulated billing application requirements for end user community.
● Administering multiple Unix and Oracle based environments
● Installation and management of Apache Web Server for all NON production environments
● ANT scripting for release management
● Oracle management,PL/SQL Development and JAVA development
● ETL using XML Parser and XMLType
● Enhanced the performance of several processes using advanced PL/SQL development techniques including bulk processing and analytical functions.
● Created and enhanced hundreds of stored procedures to support functionality throughout several key areas of the business, including electronic commerce, account login validation and fingerprint capturing.
● Overall responsible for Linux/Unix servers and Oracle DBA Tasks (Oracle Development DBA)
● AGILE environment
● Analysing User stories (AGILE)
Sr.Oracle Consultant
SYDNEY Trains June 2014 -October 2015
● Oracle PL/SQL development
● Scrum Master,Sprint creation,JIRA administration and daily stand-ups &burndown.
● Overall responsible for Oracle databases &DBA Tasks
● AGILE environment
● Solution Designing
● Gathering requirements from business users (multiple level)
● Analysing User stories (AGILE)and deliver solution in response to it
● Creation of test cases and specification documents Oracle Team Leader
EMAGINE August 2012 -June 2014
● Leading Oracle PL/SQL,JAVA and PHP developers team
● Oracle PL/SQL and JAVA development
● Amazon SaaS &Cloud Database
● Implementation of Enterprise Serial Bus using JAVA and PHP plugins
● Overall responsible for Oracle databases &DBA Tasks (Oracle Development DBA)
● Scrum Master [AGILE]
● Solution Designing
● Guiding developers team in regards to Oracle Interaction and SQL query tuning
● Gathering business requirement from the internal/external client
● Analysing User stories (AGILE)and deliver solution in response to it
● Working on ETL tools and Database Migration project Sr.Oracle Developer
Vodafone July 2010 -August 2012
● Oracle PL/SQL development and UNIX Shell scripting
● Analyzing &formulating Business requirements
● Synchronizing more than 14 Oracle Databases
● Functional Behavioral Testing
● Automation of existing Business Processes minimizing human efforts
● Guide project team through implementation and testing of the system requirements Oracle Specialist
IBM October 2006 -July 2010
● Worked with multiple clients like Airtel, Department of immigration & Citizenship Australia and Customs department of Belgium .
● Leading a Team of 13 Oracle,J2EE &UNIX Developers
● Development in Oracle PL/SQL,Oracle XML,Pro*C,Java and UNIX shell scripting
● Performing Oracle DBA tasks for Application development
● Oracle BRM
● Develop and provide practical &viable solutions to obtain the strategic view
● Gathering,Understanding &Documenting business functional and nonfunctional requirements
● Identification and documentation of functional and physical characteristics of products
● Documentation (Statement of Work,UTP,Business Cases,Presentations)
● Functional Point Analysis used to estimate time-lines/efforts
● Handover to Operations for Production Support &Knowledge Transfer of existing applications
● Working on Kenan Arbor/FX Telecommunication Billing System Oracle Developer
Hutchison September 2003 -October 2006
● Development in Oracle Database,Java Core,Pro*C,UNIX Shell,C++
● Client interaction and Vendor Management
● Designing &technical review of the requirements.
● BSCS Billing System
● MSISDN number management &Activation
● Requirement analysis and feasibility
● Coordinating UAT and Implementations
● Team Management
● BSCS Telecommunication Billing System
Projects
Multi DB Interaction: Earlier we used to support only Oracle database in terms of Data interaction. So, clients were restricted to export data from other databases and provide as flat file for further processing. After this development, client/users were able to create an External DB source, where data can be collected from other non-Oracle databases and directly inserted into local Oracle database. Users were also able to configure the SQL statements via front end GUI. SMS Engine: The main problem in the existing SMS engine was maintenance and lack of speed. Tough maintenance was due to quick patches and fixes overtime, whereas speed was due to the initial design of application which was exacted to deliver 100 TPS (Transaction per Second). After designing and few tweaks the way it used to interact with Oracle DB, we were able to achieve 1200 TPS, and much easy to understand maintain for Operations Team.
Managing Roaming partners: The management of the Roaming partners is an active Business Process in Telco. Few times in the month, Roaming Team used to give the requirement of roaming partners configuration in Billing systems for proper CDR Rating. Most of the time the actual change in Billing System and requested change were not same. After analyzing I came to conclusion that there was a gap in understanding the E2E Business Process of Roaming Partners Management. Both teams were aware of specific part of process, but not as a whole. After realizing this gap, I informed this to managers of both teams and had a couple of workshops. On top of awareness and transparency in teams, I also implemented a process of providing the data dump (excel with search macro) to roaming team so that they can do initial analyses of the requirement at their end. Due to this process, both team saved time and efforts up to 70%and also deleted non useful and duplicate records. Sales Incentive Program (SIP): This requirement was to replace the existing manual logging system of sales team target setting, achieving & performance based incentives, where targets can be traced, logged and reported. Due to the nature of the requirement, that is, management of Sales Team Hierarchy, it was hanging in-between from more than a year before it came into my bucket. After analyzing I pointed out the "show stoppers" and planned a workshop with all the dependent stakeholders at same time. Finally, all the requirements were gathered and documented in less than a month. The end product was a GUI based portal where all the members of sales team across country can set/get their monthly targets. Targets and achievement were properly reported and managed, which were earlier near to impossible.This project was a bold change in existing Business Process. Drilled down Interactive Customer Engagement (DICE): Earlier the process was to get the Customer Care executive's feedback from customer via phone call in the end of closure of raised ticket. A report of all the closed tickets was extracted and customers were called randomly. Problem was that most of the customer find it disturbing or waste of time, hence this process was treated as a business formality. I came up with new process of messaging customer rather than calling. In this way we could also restrict customer’s response in set of words like 'Yes', 'No' or 'May be'. For responding to the feedback questions, customer can be delighted with gifts or lucky draw. This process is going to be more stable in achieving valuable feedback, as well as dynamic in configuration of questions asked to customer, and on top of it, saving multiple resources. The output of this system was reports provided to concerned department/people. After implementing this process, CSR got excellent response from the customers with heaps of relevant feedback. The number of questions, type of questions, and questions were configurable on the go, giving more much more control to business they earlier had. This approach also opened a new window for customer engagement where customer is delighted for providing feedback rather than taking it as overhead.
BULK data load (ETL) - This development was required to load massive data (5GB/min) in Oracle database. It also adds a challenge of maintaining input file inventory, like total rows, processed data, errored etc. The frequency of input flat files was very high (1 sec or 3mb). Though Oracle has inbuilt utilities for loading data, but somehow it was not able to manage the inventory. To solve this I wrote a C++ and Pro*C to manage all the input data files then load data into database. This development started a new culture of loading data among other team. This code was copied over many time for other projects to load big data.
Legacy Database Migration (ETL): I was leading this project for one of our stakeholders, where they need to migrate data from legacy system to Oracle database with new structure. Firstly, I worked with Project managers to divide the project into smaller modules and helping them in defining the time lines based on the development complexities. I was responsible for assigning individual modules to developers and code reviewing.I was also responsible for daily stand ups and maintaining burndown. GTFS Daily timetable feed:In this project we delivered real-time feed and static 30-days trains timetable to mobile Application developers following General Transit Feed Specification protocol and in JSON to web hosts.I was managing the database to store and process timetable.In this project I also developed module to process real time trains location feed and push out to app developers every 3 seconds.One of my responsibility was to maintain location (track Signals)mapping with GPS coordinates to help locate trains precisely.
Run-time transformations:Earlier station managers use to manually manage the trip transformation
(detour)by calling each other and then changing the displays on station manually.After this development,all the station managers will be provided with tablets so that they can change the existing running trips on the fly.After that all the data transformation to station displays and inside trains will be automatic.My job here was to provide Db interface API to APP developers Custom Crontab for UNIX - One of the challenges we are facing in managing CRON job on few non-production servers was high volume of usage, hence repetitive failure of cron daemon process. Each server was shared among 100+ users, that ended up to hundreds of cron jobs. To overcome this issue I developed a custom build crontab daemon using Python and Shell scripting. This process used to read input parameters same as OEM crontab. This not so big development made a big impact, not just in productivity but also elevate the team’s moral.
Java/UNIX/SQL request through SMS – This was an interesting development. We, IT team, were facing the problem when processes in Java, UNIX Shell or SQL get stuck or hanged or killed. So, anybody from the team member will have, actually, rush to the office and restart the process. I thought of a trick solution and developed a UNIX shell script, which pick the command from oracle database and executes in NOHUP mode as a back-end process. This DB table was filled by any IT team member through sending the command via SMS. We used to send the command as an SMS to Nokia SMS-C with a specific keyword in it.
Contact this candidate