Senior Software Engineer - ETL Development/Support - Cloud Solutions

RAMCHARAN CHALAMALASETTY

+1-515-***-**** ***.**************.******@*****.***

EXECUTIVE SUMMARY

• 8+ years of experience in providing technical data solutions and support to complete customer requirements

• Passionate in analyzing data and performing ETL operations

• Adept at troubleshooting complex technical issues, optimizing database performance, and managing IT/System infrastructure exceeding customer expectations

• Self-motivated, results-oriented team player with curiosity to learn new concepts and emerging technologies TECHNICAL SKILLS

• Database and ETL Technologies: MS SQL Server, Oracle, MySQL, SSIS, Informatica, Talend, Snowflake, Cosmos DB

• BI & Data Visualization Tools: Looker, SSRS, Jaspersoft

• Languages & Systems: Java, JavaScript, Python, CPLEX, VB.NET, GraphQL, MATLAB, Unix/Linux, Windows

• DevOps & Cloud Services: Git, Jenkins, Ansible, AWS (S3, EC2, SQS, SNS, Lambda, API Gateway) and Microsoft Azure

• Monitoring Tools: Zabbix, OEM, JConsole, AWS CloudWatch, Stackify, IDERA

• Project Management: Atlassian Tools (Jira, Confluence), Freshdesk, Zendesk, Team Foundation Server (TFS) PROFESSIONAL EXPERIENCE

Model N – CDM Team Aug. 2022 – Present

Product Description: Channel Data Management (CDM) automatically manages channel sales providing real-time data and insights into partner performance, increasing channel revenue in High Tech industry. Actively working with customers like AMD, Samsung, Micron, Seagate, SONOS, Western Digital, etc. Role: Senior Product Engineer 2

• Versatile role encompassing Development, Network troubleshooting (TCP/IP/FTP), Support, Server administration and DevOps

• Provide Escalated Tier 3 support through Zendesk for 5+ applications, resolving about 200+ tickets annually

• Resolve issues in existing Jenkins deployment pipelines and develop new pipelines

• Successfully migrated servers from CentOS 7 to Oracle Linux 8 for all environments

• Determine root causes (RCAs) for incidents and communicate critical information across multiple teams

• Identify and fix system anomalies through reviewing logs in Linux, and application configurations o Debugging the applications and applying code fixes in Java

• Monitoring of all servers across environments and pro-actively identifying and solving issues

• Training Tier 1 and Tier 2 teams on technical aspects and new features

• Building ETL pipelines for loading POS, and Inventory data from Oracle to Snowflake through AWS

• Debugging and fixing python scripts for custom application setups

• Developing python scripts for gathering and analyzing data from the Looker API

• Ad hoc designing and developing of Jaspersoft reports

• Debugging and administering Looker reports, dashboards, and user setups

• Oracle query tuning/optimization and troubleshoot problems in Informatica designs and workflows o Improved query execution time by at least 50% for several views

• Collaborating with Professional Services, Quality, Partner On-Boarding teams on customer data integrations

• Reduced storage costs by 9 TB and optimized resource utilization by removing unused Looker users, resulting in monthly savings of $1000

• Possess a foundational understanding of Large Language Models (LLMs) - AI POC to redefine existing Talend pipelines Environment & Tech Stack: Linux servers, AWS, Oracle RAC Cluster, Snowflake, Java, Python 3.10, Talend, Informatica 10.4.1, Informatica 10.5, JavaScript, Looker, Jaspersoft, Zabbix, OEM, JConsole, Git, Jenkins, Ansible, Jira, Confluence, Zendesk Proplanner Inc. Feb. 2018 – Aug. 2022

Product Description: Proplanner is the leader of PLM-MDM (Manufacturing Data Management for the Product Lifecycle) solutions, focusing on streamlining the release of new product introductions and product updates for assembly plants. Worked with customers - CNH (Worldwide), GSI, Whirlpool, Polaris, CAT, Safran, etc. Role: Product Support Manager Sept. 2021 – Aug. 2022

• Managed the Product Support team

• Managed Support Portal (Freshdesk) for all issues o Restructured support metrics based on historic analysis o Assigning support tickets by priority

o Hiring and mentoring new support associates

o Supported all levels of issues through audio/video/email communication

• Handled deployments and managed delivery of builds for all customers

• Subject Matter Expert (SME) for product support and deployments

• Co-ordinated and executed server migration plans for European environments Role: Application/Build Engineer Feb. 2018 – Sept. 2021

• Administered an automated process to replace multiple existing tools at a manufacturing plant

• Implemented Single Sign On (SSO) procedure for the PLM system (Assembly Planner) and MES tool

• Cross functional collaboration with internal and external teams to manage projects and resolve issues

• Identify and test features/bugs internally using TFS

• Built Proof of Concepts and business cases to validate new project requirements

• Troubleshoot performance issues on database and application servers using IDERA and Stackify respectively

• Handled Tier 2/3 technical support, and on-call support

• Improved the resolution of issues as per SLA by 10% in 2020

• Detailing of all the business processes to minimize new issues Ad-Hoc Developer

• Design and deploy SSIS ETL pipelines to import from multiple data sources and export data to Flat Files/databases

• Developed ETL pipelines to send data to downstream MRP systems (WMS, CMS, JDE)

• Collaborated with data analysts to understand requirements and translated them into technical solutions

• Develop and install ad-hoc SSRS reports for Client’s requests

• Create and schedule SQL Server Agent jobs and investigate issues

• Executed an archival procedure that copies data from an On-Premises DB to Azure Cosmos DB

• Implemented data quality checks and monitoring processes to ensure data accuracy and consistency

• Detailing of all the complex data management processes to minimize new issues

• Optimized SQL view queries and database performance to improve data retrieval and analysis o Increased data processing efficiency for several pipelines by 30%

• Ran maintenance scripts regularly on databases improving performance and reducing server overhead Build Engineer

• Plan and take decisions on build releases of the software for each client

• Document and communicate the changes in each application release to the business stakeholders

• Manually deploy software build packages in virtual client environments o .NET Web applications on IIS in Windows servers

o Backed-up SQL Server databases and ran PowerShell scripts to upgrade database structure

• Reduced the error rate to less than 3% from 10% while deploying applications Environment & Tech Stack: Windows Servers, SQL Server, .NET, SSRS, SSIS, Microsoft Azure, IDERA, Stackify, Microsoft TFS, Freshdesk

Iowa State University May 2017 – Dec. 2017

Role: Graduate Research Assistant

• Assisted Prof. Dr. Matthew Darr with new software requirements and existing issues

• Meetings with clients to understand and collect the specifications

• Designed User Interface (UI) and automated email reader application through VB.NET

• Programmed an application for loading data daily from a REST API to SQL Server databases using Python

• Solved technical issues in the applications of MATLAB and SQL Environment & Tech Stack: Windows Servers, SQL Server, Python, MATLAB, VB.NET Cognizant Technology Solutions Ltd. Sept. 2015 – Dec. 2016 Role: Programmer Analyst - Pfizer

• Worked as an ETL developer and as a Support Analyst

• Designed and developed database table structure based on data files for clients from Philippines and Malaysia

• Implemented ETL pipelines in Informatica to load the data into Oracle databases

• Performed Unit Testing for the developed code

• Provided technical support for monitoring the daily loads of data in Informatica and troubleshot issues

• Modified and enhanced existing table structures to remove bugs and increased efficiency of the application

• Automated data loads to run according to business schedules with ‘UC4’ Environment & Tech Stack: Windows Servers, Informatica, Oracle, UC4, Unix commands ACADEMIC QUALIFICATIONS

Master of Science Computer Engineering Jan. 2017 – May 2019 Iowa State University (ISU), Ames, IA

GPA 3.74/4.00

Bachelor of Engineering Electronics and Communication Engineering Aug. 2011 – Apr. 2015 Sathyabama University, Chennai, India

CGPA 8.55/10.00

ACADEMIC PROJECTS

Minimizing cost of placing Virtual Network Functions May 2018 – May 2019

• Formulated an optimization algorithm in assistance with Prof. Ahmed Kamal to minimize the cost of placing VNFs with Precedence in Unicast networks

• Scripted code in CPLEX (OPL) for this algorithm hosted on Linux machines to validate its performance IoT: TelosB Sensor Motes Jan. 2017 – May 2017

• Developed an application to connect and send messages between two sensor motes

• Designed some programs to analyze the performance of sensors and protocols in Contiki

Contact this candidate