Srinivas Bikki
Liberty Hill,TX
Summary
Software engineer with over 20 years of Information Technology experience in Oracle development and administration and E-Business suite development.
Significant focus on managing client expectations and a record of consistent achievement in creating efficient and productive work environment.
Ability to handle multiple responsibilities, manage, coordinate, and execute complex projects.
Extensive experience in relational database design, data modelling, development and administration using Oracle tools and utilities.
I am a professional with domain experience in POS, Banking, Telecom, hospitality and manufacturing
with a strong application development experience in Oracle database. I can leverage the skills to
work on big data projects and analytics
Overview
21
21
years of professional experience
Work History
Software Developer
Apple
03.2018 - Current
- ·Enhancing Oracle database and middle-ware programs used for automation and new requests made by the business teams
- ·Setting up and maintain code of Oracle database on private cloud and AWS.
- ·Designed and implemented AWS RDS Oracle application deployment using Cloud-formation, Flyway, Python, PL/SQL
- Managing Oracle data induction and out-bound interfaces
- ·Releasing of production implementation plan, getting sign-off from all required stake holders and providing warranty support for production
- ·Coordinated projects for smooth execution with onshore – offshore model
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
Software Engineer
Verizon Wireless
03.2017 - 07.2017
- Established successfully the development of PL/SQL packages to generate the customer needed reports for unbilled usage data plans
- Created Materialized views, Normal views as per the business requirement
- Worked the Hadoop echo system for data migration to Big Data Platform using Hive
Oracle PL/SQL Developer
Electronic Transaction Consultants
05.2016 - 02.2017
- Providing an automated PL/SQL procedural solution on Tag Store database to run the above process. Co-ordinate Daily standup and conduct retrospective meetings.
- Successfully established and implemented the development of PL/SQL packages for toll authority system that collects funds from several different agencies
- Participated in the QA process through code review and Prepared Portfolio of Deployment Plans
Oracle PL/SQL Developer
Worldwide Express
02.2016 - 04.2016
- Implemented Advanced PLSQL concepts for better performance of PLSQL application
- Developed and recommended the PL/SQL package solution for full truck load Carrier Payment and less than a truck load Carrier Payment billing system that would improve at least 10% in sales annually
- ·Debugged existing code for business logic issues.
Oracle PL/SQL Developer
Ocwen Financial Corporation
03.2015 - 01.2016
- Spearheaded the Mortgage business portfolio products in developing reports to be automated using PL/SQL code to increase the productivity and reduce the turnaround time from 2 days to 1 day and manually generate any time
- Unpaid Principal Balance daily report & amortization tool report
- Adjustable Rate Mortgage Reconciliation report
- Home Affordable Modification Program Recast Projection report
- Credit Reporting reports on Foreclosure and Forbearance
- Provided an automated PL/SQL procedural solution for credit reporting on Foreclosure and Forbearance report
- Data Conversion work from current system to automated work
Oracle DBA
JP Morgan Chase
12.2011 - 03.2015
- Established successfully all databases administration activities for development team that are required for development, testing, and production environment pertained to ETL work
- Regularly Performed the capacity planning work required to create and maintain the databases up and running with no downtime
- Participated in design reviews and responsible for Database upgrades which involved migrating of code, database changes through the various stages of the development life cycle
- ·Supporting Development team and Application team to perform database administrator duties of creating Tables, Tablespaces, Schemas, Views, Materialized views, Table Partitioning, Procedures, Packages, Functions, Triggers using TOAD / PLSQL developer.
- Spearhead the Oracle Performance tuning activity to improve the performance of slow performing ETL activities
Oracle DBA
AT&T
02.2004 - 10.2008
- Day to Day DBA activities for development team including schema management, user management (creating users, synonyms, privileges, roles, quotas, table, indexes, sequence).
- ·Supporting Development team and Application team to perform database administrator duties of creating Tables, Tablespaces, Schemas, Views, Materialized views, Table Partitioning, Procedures, Packages, Functions, Triggers using TOAD / PLSQL developer
- Monitored data growth and re-organized the table structures in separate Tablespaces.
- Developing appropriate support structure indexes, partitions that comply with data security best practices and implemented Oracle advanced encryption methods as necessary.
- Performance tuning of application using Query Optimizer, Toad to reduce execution time of the query and check joins used by queries and perform Index usage tests by monitoring the SQL Plan generated and provide recommendations to developers.
- ·Following the process of SDLC from the development environment to QA and staging environment through the build process and ultimately migration to production.
- · Creating range, list partitions and hash sub partitions
Education
B.E. in Computer Science And Engineering -
Sri Jayachamarajendra College of Engineering
Mysore, IndiaSkills
- Languages: SQL, PL/SQL, Python
- DevOps: Amazon Web Services, Git, Docker, Flyway DB
- Database: Oracle Performance Tuning
- Tools: PL/SQL Developer, TOAD, Data Modeler, SQL Loader, Data Pump
- BIG DATA: Hadoop, Hive
- Operating System: Unix, Linux
- RDBMS: Oracle 10/11g/12c/19c/21c
- Oracle EBS: Oracle 107 and 11i E-business suite
Timeline
Software Developer
Apple
03.2018 - Current
Software Engineer
Verizon Wireless
03.2017 - 07.2017
Oracle PL/SQL Developer
Electronic Transaction Consultants
05.2016 - 02.2017
Oracle PL/SQL Developer
Worldwide Express
02.2016 - 04.2016
Oracle PL/SQL Developer
Ocwen Financial Corporation
03.2015 - 01.2016
Oracle DBA
JP Morgan Chase
12.2011 - 03.2015
Oracle DBA
AT&T
02.2004 - 10.2008
B.E. in Computer Science And Engineering -
Sri Jayachamarajendra College of Engineering
Similar Profiles
Jason LouisJason Louis
Specialist at AppleSpecialist at Apple
Akeya KimbroughAkeya Kimbrough
Tier 1 Technical Support Advisor at AppleTier 1 Technical Support Advisor at Apple
Jon MolinaJon Molina
Technical Support Specialist at AppleTechnical Support Specialist at Apple