Rajesh R

Company: BONbLOC Technologies
Client: McLane OMS

Project Name: Order Managment System (OMS)
Location: Hyderabad
Duration: Sep 2024 – Till date
Role: Software engineer

Description:
McLane Company, Inc. is one of the largest supply chain services leaders in the United States, providing grocery and foodservice solutions for convenience stores, mass merchants, drug stores and chain restaurants. Through McLane Grocery and McLane Foodservice, McLane operates over 80 distribution centers and one of the nation’s largest private fleets. The company buys, sells and delivers more than 50,000 consumer products to nearly 110,000 locations across the U.S. Additionally, McLane provides alcoholic beverage distribution through its subsidiary, Empire Distributors, Inc. McLane is a wholly owned unit of Berkshire Hathaway Inc (NYSE: BRK) and employs 24,000 teammates.

Responsibilities:
● Involved in requirements gathering, analyzing and designing based on the business requirement.
● Developing and implementing stored procedures.
● Testing store procedure in various scenarios to meet the requirements.
● Preparing test documents.
● Peer Reviews.
● Provided end-to-end production support,including troubleshooting deployment failures,analyzing logs,performing root cause analysis.
● Monitored production systems and proactively resolved issues to ensure high availability and minimal downtime.
● Documented deployed procedures,operational steps,and ansible workflows to improve team knowledge sharing and onboarding.
● Participated in on-call rotations, providing time support for production incidents and coordinating fixes.
● Created Ansible playbooks and templates to automate job schedulin

• Using multiple versions (12,14) 0f postgreSQL as part of the project.
• Developed different stored objects like Functions, Procedures, Triggers, Tables etc.
• Applied different replications like logical and physical by using external extensions (pg logical, repmgr, barman)
• Install, Configure, Test, Monitor, Upgrade and Tune new and existing PostgreSQL data.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Studied and stayed current on features and functionality of PostgreSQL.
• Prepares and/or Reviews activity, Progress and Performance reports.

Project:

• Organization : Infosys
• Project : Market Analytics-Real Page
• Role : Developer
• Environment : PostgreSQL
• Duration : March 2024 to June 2024

• Expertise in Client-Server application development using Oracle 12c/11g/10g, PL/SQl, SQL*PLUS
• Proficient in data migration projects Oracle to postgres.
• Hands-on experience in PostgreSQl database development.
• Created Schema, Users, and Tables, Constraints, Indexes, privileges, Cursors, anonymous blocks, directories, and sequences.
• Developed Complex database objects like stored Procedures, Functions, Packages and PL/SQL.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Worked extensively on Dynamic SQL, Collections and Exception handling.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Analyse the functional and technical specifications and convert to PL/SQL programs and modify Existing PL/SQL packages.

Project :

• Organization : IQVIA
• Project : Liberty, USA
• Role : Database Developer
• Environment : Oracle
• Duration : June 2021 to Feb 2024

• Extracted and collect data to create needed reports
• designed and maintained sql scripts
• Validated accuracy of data to ensure database integrity
• created and optimized diverse SQL queries
• Generated reports and spreedsheets detailing database.

Project:

• Oraganization : Cognizant
• Project : Statefarm Insurance, USA
• Role : Associate Engineer
• Enivorment : Oracle
• Duration : August 2018 to June 2021