SANTOSHI REDDY

Mobile - +91-824*******, adm4tk@r.postjobfree.com

Profile

·6+ years of technical experience at Infosys with multiple projects in

oDevelopment

oTesting (ST/SIT/UAT)

oSupport

·Work experience includes:

oUNIX

oShell Scripting

oOracle RDBMS

oSQL, PL/SQL (Oracle), SQL Developer, etc.

oPostgreSQL, pgAdmin

oIBM DB2

oProject Management

·Worked with customers:

oWestpac (Australia)

oBacardi & Kimberly Clark (US, Nigeria, India)

oTOLL Technologies (Australia, Singapore)

oTelstra (Australia)

oWalmart (US & Canada)

oT-Mobile, Orange (EEL) – UK

·Good Communication and Interpersonal skills, self-motivated and quick learner.

·Have 1.5 years of Stock, Financial Markets & Accounting experience as Portfolio Manager.

Academic Qualifications:

·M.B.A. (Finance) from Sambalpur University, 2010.

·B.A. (Economics Tons.) from Utkal University, 2008.

Employment Summary:

Employer / Company

Designation

Duration

Infosys Ltd.

Technology Specialist

Since April-2011

AM Financial Services

Portfolio Manager

Jan-2010 to Feb-2011

IT Skills/Tools Used:

Programming : UNIX, Shell Scripting, SQL, PL/SQL, IBM DB2, ORACLE, MySQL, PostgreSQL

Development Tools : SQL *Plus, Oracle SQL Developer, pgAdmin, SSIS

Other Tools : tfs, Control-m, Putty, Teradata, Informix, QueryMan, BMC Remedy, Service Now, Pentaho

Operating Systems : Windows, MacOS X, UNIX, Linux/Ubuntu

Support tools : BMC Remedy, SAP, Excalibur (BAS tool)

Projects Description:

Project #1

Customer : Westpac

Role : Team Leader, SQL Developer (MS SQL Server)

Duration : Since January 2020

Description :

Westpac Banking Corporation (Westpac) is one of the Australian leading Bank.

Roles and Responsibilities:

·Working on the Agile project, where we have to finish work in estimated hours.

·SQL, TSQL Developer.

·Good knowledge of TFS, SSIS and source control.

·Working on control-m to run job/batch.

·Worked on ST,SIT,UAT.

·DB, Tables, Stored Procedures, Batch Jobs analysis, development, maintenance.

·Analyzing the client requirements and accordingly resolve their issues within SLA.

Project #2

Customer : Bacardi & Kimberly-Clark(KCC)

Role : Team Leader, SQL Developer (PostgreSQL)

Duration : October 2018 – December 2019

Description :

Bacardi is one of the oldest and largest spirit company in the world. Kimberly-Clark (KCC) is an US based multinational personal care company, which mostly deals with paper based consumer products. Kimberly-Clark also listed among the fortune 500. Bacardi (India, Lebanon, South Africa, Greece, Philippines & Japan) & KCC(Nigeria) IT operations are being managed by Infosys where I worked as a Technical Team Leader cum SQL Developer.

Roles and Responsibilities:

·Technical Team Leadership and escalation management for SQL development and delivery.

·Analyze Business-Requirements and prepare appropriate SQL queries, Stored Procedures, etc.

·Review team deliverables and rectify any code-level discrepancies. In case of data discrepancy, reconcile and report to client.

·Handle client’s operational weekly calls to understand the challenges and optimize the business.

Project #3

Customer : Toll Technology Center

Role : Project Management, Team Leader

Duration : October-2017 – September-2018

Description :

Toll Group, part of Japan Post Holdings, is a transportation and logistics company with operations in road, rail, sea, air and warehousing. It has three principal businesses, Global Forwarding, Global Logistics and Global Express Services, with some 1200 sites in about 50 countries, mostly in Asia Pacific and Oceania.

Roles and Responsibilities:

·Technical and Team Leadership and attend monthly calls with account head from India and Australia for TTC governance meetings.

·Resources allocation, on/off-boarding, profile screening and submit weekly reports to delivery head.

Project #4

Customer : Walmart Stores Inc.

Role : PL/SQL, UNIX Developer

Duration : August 2013 – October 2017

Description :

Team Leadership, Reports preparation, Tickets Resolution, Pager handling and Support activities in the Time Attendance, Payroll, Sales, CRM and Employee practices systems for Walmart.

This project involves both UNIX and IBM Mainframe. There are 2 DBs used – Informix and IBM DB2. We use Mainframe to check the details in the DB2 and analyze the code to fix issues. Unix is associated with Informix database. The data from Informix flows to DB2. There are several batch/CRON jobs which unload the data from Informix and load to the DB2.

Roles and Responsibilities:

·Analyze DB Tables, Stored Procedures, Triggers, Databases and relevant Technical Requirements.

·Coding in UNIX, Shell Scripting, PL/SQL.

·Assess DB and data issues when reported by customer and developers.

·Team Leadership & Escalation handling.

·Analyze and identify the data flow to fix the issues where the flow from Informix or UNIX files to DB2 is obstructed.

·Predicting and identifying the issues in advance to avoid escalations.

·Supplying Weekly and Monthly Status reports to relevant stakeholders.

Project #5

Customer : Telstra

Role : Business & Technical Analyst (Commissions)

Duration : Jan 2013 – Apr 2013

Description :

Telstra is Australia’s leading telecommunications and technology company, offering a full range of communications services and competing in all telecommunications markets.

Roles and Responsibilities:

·Interact with channel partners, business operations and different teams in Telstra.

·Prepared weekly and monthly reports to coordinate onsite and offshore leadership. Analyze business requirements and document them for development teams and other technical resources.

Project #6

Customer : Everything Everywhere Ltd. (T-Mobile & Orange JV)

Role : Business & Technical Analyst (Commissions)

Duration : July 2011 – Dec 2012

Description :

Everything Everywhere is the 50-50 joint venture between T-Mobile (Deutsche Telecom) and Orange (France Telecom).

Roles and Responsibilities:

·Worked as Business Analyst for EEL for its Commissions Reconciliation.

·Worked for commission payment reconciliation using SAP and Excalibur applications and took care of SOX Compliance activity and performed it on time with high importance.

Languages Known:

Speak : English, Hindi, Oriya, Telugu, German (Basic)

Write / Read : English, Hindi, Oriya

Contact this candidate