Ramesh S. Phadke
Naperville, IL 60540
******.******@*****.***
PROFILE
Proactive Database Programmer with over 10 years of experience working with emerging technology to create innovative business solutions. Skilled in development, implementation and troubleshooting of Web-based and e-commerce applications. Customer-focused relationship builder with ability to multi-task in a fast paced, deadline-driven environment.
TECHNICAL SUMMARY
Applications:
Apache, SSH, FTP,
Databases:
MySQL, MS Access, Oracle SQL, 1032/1022 Database Management
Interfaces:
TCP/IP, SIP, Sniffer (trouble shoot), Ethernet, Routers, Wi-Fi/Wired
Languages:
Perl, XML, PHP, Visual Basic, Ruby, Java, Machine Languages (Intel/Motorola), Pascal, COBOL, Fortran, Runoff, Troff, SGML
Scripts:
Shell, Awk, MySQL, Sed, Tcl/TK
Operating Systems:
Processors:
Windows XP/7, UNIX, Linux, Solaris, Cygwin on Windows, VMS on VAX
3B2 Family (Fault Processors), PC, VAX family, PDP family
PROFESSIONAL EXPERIENCE
RR DONNELLEY, Elgin, Illinois
2009-2015
Database Programmer/Analyst
Responsible for programming to generate XML-driven/TYP-driven format for XPP team members with VB Script, Perl, MOOSE type, Shell Script, Tcl/TK, MySQL, CSS, CPAN and Ruby Gems modules. Maintained multiple applications for internal customers. Documented procedures for programmers/XPP team members.
Developed programs in PERL to automatically convert large data to XML format for publishing a range of marketing materials including books, directories, and catalogues.
Developed tools in PERL to provide more flexibility to the programmers for converting large data from EXCEL, SQL and Microsoft Access to CSV files.
Translated VBA into Perl modules to automatically generate the XML-driven (100,000 lines) format for XPP team members, which significantly improved efficiency.
Organized an array of data formats and encoding – XML, HTML, CSV, Excel, with UNIX, Perl and MySQL- to automate procedures, analyze data, generate reports, create/modify documents, improve processes and increase the simplicity and versatility of our procedures.
Wrote several tools in Perl with the use of CPAN (open source) modules and Shell scripts to automate the reading of very large data packets (up to 1 million records) with multiple columns in Excel into CSV files, streamlining the process.
Managed the design, development and maintenance of an internal web application that utilized Apache, MySQL, PHP, JavaScript, AJAX, CSS, transactions, and custom database functions/stored procedures that tracked and reported the status of 400+ directories in quickturn production for a key client. Improved 10MB of Shell and Perl scripts that worked with over 75G data to carry out the project’s filtering, sorting, reporting, business rules, and XML creation, achieving KPI of 99.1% accuracy.
PURPLE COMMUNICATIONS, Chicago, Illinois
Acquired MCI/Verizon – Video Relay Division
2004-2008
VRS Technical Support Engineer
Provided technical support to external customers on use of video relay service. Recommended possible solutions for the customers’ network configuration with TCP/IP, Network Configuration, and Sniffer.
Coordinated troubleshooting and collection of data regarding issues on the video device feature for point-to-point calls and point-to-multiple-point calls (e.g., conference calls), and performed laboratory tests to ensure stability of the connection when using this feature. Reported the issues to the VRS engineering team for feedback.
Recorded and documented test calls and results for the VRS as new features and services were developed.
Created a framework to offer live customer support in a variety of formats and mediums; including live video, E-mail and text chat. Handled all technical support questions and provided live customer assistance to individuals accessing Verizon’s Video Relay Service.
Researched and tracked advancements in the Video Relay business among competitors and presented updates to management and technical staff.
Provided training to Video Relay Interpreters and Outreach Staff regarding technical capabilities of Verizon’s system including updates, changes, improvements, and limitations.
Provided consultation to Customer Care for Quality Assurance process.
Studied and tested Mobile Video Phone device and Video Sign 3.0 application program. Gained knowledge of H.323 and SIP protocols.
AT&T/Lucent Technologies Inc – Bell Lab Innovation, Chicago, IL
Formerly AT&T Bell Laboratories
1986-2002
Feature Tester, (1996 – 2002)
Diagnostic Developer, (1990 – 1995)
Quality Assurance/Test Stability, (1986 – 1989)
Scripted in Awk and Shell Script to collect and analyze data and to generate reports for system engineers and hardware engineers. Developed tools to improve the processors for the hardware developers, using 3B2 family architecture, and Sun’s MIDAS hardware simulator.
Designed, Developed, and Tested (White Box and Black Box) for the expansion of time slots and channels for Cost Reduction - the request messages were sent by the users or administrators and the messages were driven to perform – restoral, removal, switch.
Performed tests on each load, collected data and analyzed the results in order to verify the appropriate behavior of the request message. Tested various scenarios for the conversion of two protocols between Land/Mobile, Mobile/Land, and ATM Switch/Packet Pipe Switch, all used for cell towers. Ensured that functional connectivity was sustained through different types of interference.
Diagnostic Developer for Memory Unit, Data Manipulation Unit, Store Addressing Translation, Micron Control, Store Interface. Performed physical fault insertion for diagnostic.
Hardware Simulator - to simulate the main memory controller using SUN MIDAS tools. This code allowed the hardware developer to debug the main memory controller interface before producing the physical hardware circuit.
Led test strategy for SCSI disk drive.
Education:
MS, Computer Science, North Central College, Naperville, Illinois
BS, Computer Mathematics, Gallaudet University, Washington, DC
Activities:
Gallaudet University Alumni Association
Naperville Municipality Mayor’s Office People with Disabilities, Board Member