Vishwas Hegde

Technologies: SQL (Teradata), PL/SQL, Control - M, Skybot, Bamboo, Bitbucket, Git, UNIX

Major projects worked on as part of the Marketing Team:

• Developed a Credit Card & Personal Loan leads to Application conversion model using the Star Schema Approach and catered it to the Qlik Sense dashboard. This helped analysts review their leads' performance and take action accordingly.
• Worked on Migration of Attributes and Tables from legacy Oracle DB to the new Teradata DB and helped the campaign team to map the campaigns.
• Successfully Designed, Developed, Tested, Deployed, and Supported Marketing-related DB Objects, Scripts, Attributes, and jobs using Data Vault, Star Schema Modeling and CI/CD approach in Teradata.
• Monitored the marketing-related jobs using Control-M and Skybot tools and fixed issues within a short interval.
• Utilized Agile methodologies to manage tasks efficiently, including creating JIRA tickets, participating in daily stand-ups, and contributing to planning calls for streamlined project execution.

Major Projects Involved:

Technologies: SQL (Oracle), PL/SQL, SSIS, Visual Cron, Salesforce.

• Designed and developed an End-to-End TPA Support model, which consists of claims and transactions of employees of the clients. Catered data to Salesforce Dashboard, acting as a bridge between major clients like Amazon, Walmart, and TPA companies.
• Designed a complex financial algorithm using Views & Procedures. This helped TPA’s & clients to keep track of all the claims & transactions of the insured people, settle claims fast, and keep their data up to date.
• Monitored and fixed production data issues in day-to-day data loading from source to destination.

Major projects worked on as part of the Marketing Team:

Technologies: UNIX scripting, SQL (Oracle/Teradata), PL/SQL, Autosys

• Designed and developed various DB objects, stored procedures, and Unix Shell scripts to extract customer and product data from different sources and load it into the Teradata database to support Apple Marketing Campaigns running in a tool called Unica.
• Developed Unix shell scripts & Autosys jobs to monitor the daily run of the campaigns and send reports through email to higher management and Ops team, allowing issues to be rectified within a short interval.
• Used a ticketing system to receive both auto and user issues raised by clients or business analysts and provided solutions in a timely manner.
• Monitored the data flow from source systems to destination through Autosys, Cron Jobs, and fixed data and platform-related issues.
• Designed and developed DB objects and Unix Shell scripts to extract and send customer data as per GDPR regulation when someone requests their data from Apple Inc through privacy.apple.com.
• Managed and guided a team of 8 members. Acted as the bridge between the client and the team by taking requirements and delivering what matters.

• worked on configurations and installations Solaris and Linux servers using Custom jumpstart and kick start.
• Good working experience with Redhat satellite server for upgrading and patching linux servers.
• Troubleshooting issues related to DNS,NIS,NFS,DHCP, Sendmail on Linux and Solaris OS.
• working on partition backups/snapshots related tasks
• Shell scripting in bash to automate the repetitive admin tasks.
• user administration which included creating backup account for new users and deleting account for the retired or deleted users
• Created, modified, and deleted user accounts and permissions according to company policies and procedures.
• Managed user access rights and ensured data security and integrity.
• Provided technical support to end users regarding Linux desktop operating systems, applications, and hardware-related issues.
• Experience in performance monitoring of CPU, Memory, Disk, Network.
• Incident Management:
• Responsible for planning and coordinating all the activities required to perform monitor and report on the process.
• Represent the first stage of escalation for incidents.
• Identify, Initiate, schedule and conduct reviews.
• Ensure the closure to the incident process coordinators.

• Provide first level contact and convey resolutions to customer issues.
• Properly escalate unresolved queries to the next level of support.
• Track, route and redirect problems to correct resources.
• Update customer data and produce activity reports. Walk customers through problem solving process.