RAMCHARAN CHALAMALASETTY

+1-515-***-**** addi3h@r.postjobfree.com https://www.linkedin.com/in/ramcharan-chalamalasetty/ EXECUTIVE SUMMARY

• 4 years of experience in providing technical solutions to assist customer needs by developing, deploying and supporting applications and databases

• Efficient skills in gathering requirements and understanding business requests

• Assistive, innovative and proven expertise to work with multiple projects in different technical areas

• Hands on exposure in analyzing data and performing ETL operations

• Enthusiastic about learning new concepts and emerging technologies

• Excellent communication, analytical and problem-solving skills with ability to work as a team player TECHNICAL SKILLS

• MS SQL Server, SSIS, SSRS

• MySQL (ETL)

• Python

• C, C++

• Contiki OS, CPLEX (OPL)

• Informatica (ETL)

• Linux, UC4

• MATLAB

• HFSS, CAN bus

• Team Foundation Server

• Oracle (ETL)

• Microsoft Azure

• VB.NET

• HTML, CSS

• Microsoft Office

PROFESSIONAL EXPERIENCE

Application and Build Engineer @ Proplanner.NET Feb. 2018 – Present Application Engineer

• Modeled and documented an archival procedure which copies data from On-Premise database to Azure

• Handled a project to launch a new tool for one of the manufacturing plants which was held up for 3 years

• Collaborate with development team, project managers and clients to manage requirements weekly

• Build Proof of Concepts and business cases to validate new requirements

• Traveled to multiple client locations to train users and collect requirements for new projects

• Engaged in product design reviews to recognize the customer impact of new requirements and designs

• Testing of new features/identified bugs and report defects to development team

• Provide Tier 2 support for issues with interfaces between Proplanner and multiple MRP systems in the plants

• Understand and handle Client’s requests to manage their data

• Perform Ad-hoc analysis of large volumes of data for resolving issues

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

• Reduced support time by undertaking preventive measures of issues every month

• Detailing of all the business processes for each plant to minimize new issues

• Create and run SQL Queries for daily maintenance to alert users regarding failures Build Engineer

• Plan and take decisions on build releases of the software

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

• Deploy software build packages (.NET Web applications on IIS and databases) in virtual client environments

• Manage different versions of the software across multiple manufacturing plants (approx. about 15 plants)

• Execute new installations (Go-Live) for applications and databases

• Run maintenance scripts regularly on databases improving performance and reducing server overhead Ad-Hoc Developer

• Build SQL queries to troubleshoot issues from daily support and for Unit/Integration testing of new features

• Design and deploy SSIS packages to export data to Flat Files and import from other data sources like SQL Server

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

• Create and schedule SQL Server Agent jobs and investigate to resolve any issues Graduate Research Assistant @ Iowa State University May 2017 – Dec. 2017

• Assisted Prof. Dr. Matthew Darr with his software needs and issues

• Meetings with clients and end users for understanding and collecting the specifications

• Developed an application that can send data through an API

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

• Programmed an application for loading data from API to SQL databases using Python

• Solved technical issues in the applications of MATLAB and SQL Programmer Analyst @ Cognizant Technology Solutions Ltd. (Chennai, India) Sept. 2015 – Dec. 2016

• Worked as an ETL developer and as a Support Analyst

• Designed and developed databases for clients of Pfizer from Philippines and Malaysia

• Provided technical support for maintaining the daily loads of data and troubleshot issues

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

• Performed Unit Testing for the developed code and handled escalations

• Automated data loads to run according to schedules with ‘UC4’ 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

• Designed an optimization algorithm in assistance with Prof. Ahmed Kamal to minimize the cost of placing Virtual Network Functions with Precedence in Unicast networks

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

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

• Programmed some applications to analyze the performance of sensors and protocols in Contiki Design and performance analysis of Micro-strip Band pass filter with tuneable notch 2014 – 2015

• Developed a low loss filter that can be applied in different areas of communication

• Implemented with HFSS (advanced 3D simulator) for analyzing the bandwidth and insertion loss of the filter ACHIEVEMENTS AND CERTIFICATIONS

• Accolades from users for solving the critical issues 2018-2020

• Appraisals from business for extended support and maintenance 2018-2020

• Appreciations from clients for successful completion of goals within deadlines 2016

• Cognizant’s certification for graduating from Campus Associate Training Program 2015

• Published a paper in International Journal of Applied Engineering Research (IJAER) 2015

• Appreciations for organizing events in the Sathyabama University 2011-2015

• Merit certificates for being top in Chemistry and Database Management Systems (DBMS) 2011-2015

Contact this candidate