Sirivarsha Bheemireddy

Scottsdale, AZ ***** • 915-***-****

adlajp@r.postjobfree.com • https://www.linkedin.com/in/sirivarshab/

DATA ENGINEER

Customer-Oriented, Results-Driven, Team Player

* ***rs of extensive experience in the development, maintenance, and operation of business information systems. Able to combine a wide range of technical experiences to solve problems and synthesize new ideas. Unique ability to communicate effectively across business units and resolve and improve processes by implementing technical solutions. Background includes working successfully with teams and customers across the organization and around the world.

• Well Versed with Database Processes

• Extensive Technical Knowledge of database Processes for

• Big Data

• Data Modelling

: Oracle SQL, PL/SQL, SQL Server 2008-2012, MySql

: Database designing,Tuning, Archival Procedures

: Good knowledge of MapReduce, hdfs in Hadoop

: ERWin, Visio

• Application Development

: OracleForms,Reports9i-11g,OAF,XML Publisher

• Oracle Apps Development

:R11/R12.1.3

• Linux

• UNIX (Solaris)

• C, Java, Shell Scripting

• jDeveloper, SQL Plus,SSMS

• Quality Center, PVCS, GIT,SVN, TFS

• Jira, Confluence, Crucible+Fisheye

Professional Experience

Data Engineer

WELLSFARGO

May 2017 - Present

Chandler, AZ

• Developed and delivered training presentations on logical data modeling, application process modeling and metadata management for business units.

• Created and implemented the logical model for a Metadata Management system.

• Analyzed and resolved issues relating to database application performance.

• Supported operation tasks such as backup, replication and schema modifications.

• Involved in User authentication process, creating users, roles and reports.

• Used ERWin for the data modelling

• Created database related code to meet the requirements for LOB(Line of Business and OPSEG Operating Segments) which involves 9 different levels of hierarchy.

• Wrote and optimized PL/ SQL code under Oracle 10g to handle large data sets using partitioning.

• Part of the .Net team which involved in developing a UI tool for handling Loans, Leases, Portfolio and Guarantor Attributes where the data get to the data lake for the downstream partner to consume.

• Uploaded pre-defined data formats (e.g. spreadsheet to the UI).

• Worked with QA to finish the sprint tasks, test plans and test scenarios.

• Followed code check-in process to GitHub and Sprint planning on Jira.

Senior Database Developer

Verizon Telematics / Networkfleet Division

Jan 2015 - Present

San Diego, CA

Responsible for new development, bug fixing, documentation, data security, performance tuning, technical debt cleanup, and all database code deployments for a GPS Fleet Management application.

• Involved in gathering requirements for new projects designed and implemented logical and physical models.

• Increased code quality by following a process of formal code reviews for database development team.

• Solved complicated runtime errors collaborating with DBA team and majorly focused on performance issues.

• Solved production issues on emergency basis.

• Involved in new feature projects like UDL, Driver schedules, Elastic search with Cassandra.

• Worked on the issues on priority in the sprint and worked with QA for testing fixes.

• Mentored new programmers.

Oracle Senior Consultant

United Parcel Service

Oct 2013 – Dec 2014 Ramsey, NJ

New Implementation and Production Support

• Involved in the Implementation of Oracle Apps R12 and involved in the technical and functional documenting

in Finance modules.

• Analyzed Business requirements, product requirements, module specific functionality’s, identified testing requirements and formulated functional test plans.

• Created user defined functions to enhance the maintainability of test scripts and handled exceptions.

• Worked closely with the end users during User Acceptance Testing.

• Designed and developed forms using Oracle Forms 10g to allow end users to manage customer relation effectively.

• Created FNDLOAD, SQL and Shell scripts for migrating code from one instance to another instance.

• Designed and developed scripts for uploading data from flat files and XML files into database.

Oracle Apps Developer

Ge Capital 2009 – Aug 2013 Hyderabad, India

Interact with Business and work on New Change Request.

• Worked closely with functional specifications, design to work on new requests.

• Worked on finance modules AP, AR, GL, OM, Purchasing and created RICE components for the requests.

• Developed new MD 70 and functional specs and deployment documents.

• Monitored deployment for every release and performed performance tests.

• Worked on Oracle Apps form personalization as per customization.

• Transferred transaction data from Legacy to Oracle with an efficient invoice interface and designed Customer AR and

PO vendor conversion.

• Developed OAF custom pages for fund requisition.

• Implemented out bound interfaces for AP, GL, AR and OLFM.

• File transferred using SCP, FTP and SFTP.

• Developed API to import customers using TCA(Parties, Party Sites, Party Accounts, Party Account Uses)

from legacy system.

• Created concurrent programs, Request sets, Descriptive Flex Fields, Value sets.

• Actively responsible for the execution of Oracle Alerts and notify users upon failure of jobs and improved performance

using TKPROF and explain plan.

Oracle Apps Developer

Hyatt

2008 – Jan 2009 Hyderabad, India

• Design of detailed Technical Design of code.

• Design of Installation Instruction (Migration Document).

• Created PL/SQL packages, procedures and functions in TOAD necessary for validations before loading records into interface tables.

• Created SQL*Loader scripts as a part of conversion process to load the legacy data from existing

flat files into tables.

• Reviewing of code and testing.

• Developed Discoverer reports and scripts for Code Migration.

• Implemented the Oracle reports for delinquent customers and customer notes.

• Worked on Customer Interface from legacy systems base tables.

• Involved in release for the project. Identified, established test requirements and documented for requirement management.

• Based on use cases translated the information to test cases and test procedures

• Conducted System and Regression Testing and identified application errors

• Conducted Database testing using SQL Queries

• Handled unexpected errors using inbuilt Exception Handling

Academic and Professional Qualifications

Bachelors of Engineering in Computer Science

Jawaharlal Nehru Technological University, India

Java Programming Certificate (in progress)

Big Data Certification with Coursera(in progress)

Contact this candidate