PL/SQL, Matlab, C++, Shell, Perl, Unix, Telecom, Lte, Rf, Optical

DHANYA DEVARAJAN

****, * ********* ****, *** #***0, Irving, TX 75038

act74f@r.postjobfree.com Ph: 972-***-**** Work Visa: H1B (Sept 2018)

Versatile Software/Systems Engineer, with around 6 years of experience using Oracle PL/SQL, UNIX shell script, Perl, ETL, data mapping, data integration, MATLAB, C++ also sound Telecom domain exposure

Exposure working on U.S. based client projects and internships, in Telecom as well as Banking domain, with INFOSYS, Indian Space Research Organization (ISRO), AIT Resource Group

Involved in all phases of Software Development Life Cycle (SDLC), experienced with working on critical projects with extremely tight deadlines

Experience with Software development, UAT support and basic testing

Expertise in Telecom domain especially, RF, LTE, Optical, Satellite, Networks, Antennas, Electromagnetics, from Masters’ in Telecommunication Engineering and Telecom projects

Expertise in forming complex SQL queries, including joins, sub queries, constraints also adept with performance tuning/query optimization from 5 projects worked till date

Proficient in creating complex database objects like Stored Procedures, Functions, Packages, Cursors, Triggers, sequence, and schema objects like tables, view, index

Experienced with data analysis, data mapping; Extract, Transform, Load (ETL) of XML files, flat files using PL/SQL, scripting, Informatica

Experience in writing numerous Perl scripts in *NIX and Windows systems for file handling, file manipulation, implementing business logic, exposure using CPAN, CGI, DBI

UNIX shell scripting experience, for invoking PL/SQL scripts, job scheduling, automating batch processes/repeated processes, file handling, implementing requirement logic

Extensive experience in using Command Line Interface (CLI) commands, exposure working in both UNIX and Linux servers

Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity Relation modeling and design techniques

Expertise in Client-Server Application Development using Oracle 11g/10g, PL/SQL, SQL * PLUS, TOAD and SQL*LOADER

Advanced expertise in MATLAB programming from 2 innovative and highly complex projects worked with ISRO

Experience in devising and implementing Simulations, Algorithms, Workflows using MATLAB

Exposure with C++ programming, creating library files, extensively used file handling, pointers, classes, OOP, memory management, STL

Exposure creating C++ programs using Vim editor in UNIX, Visual Studio, also adept with debugging, compiling and executing in both

Written javascripts for form validation, and also for HTML script

Single handedly developed a WebServices project using Eclipse, involving technologies XML, HTML, XSD, SOAP, REST etc.

Used CVS, SVN & VSS for Source code management, and utilized tools like REMEDY, JIRA for issue/project tracking

Also proven expertise in designing and developing software tools, Graphical User Interfaces (GUI), proficient with LabVIEW, Simulink, MS Access, Excel advanced functionalities and programming from projects worked

Technical Skills

Programming (Advanced) : Oracle PL/SQL, shell scripting, XML, MATLAB

Programming (Expert) : Perl, LabVIEW, javascript, C++, Simulink, JAVA

Programming (Intermediate) : Visual Basic, Python, Oracle Forms, DSP programming (TMS320C6713), 8086, 8051

Database : Oracle 9i/10g/11g, MS Access

Web Technologies : javascript, XML, HTML, Webservices, SOAP

Platforms : UNIX, LINUX, Windows, Ubuntu

Tools/Platforms : TOAD, Eclipse, SQL *Plus, SQL Server, RDBMS, Visual Studio, DB2, Informatica Power Center 8.x 9.x, SQL *Loader, MS Access, MS Excel, PSPICE, OrCAD, ANSYS HFSS, ADS, MapInfo, WireShark, Jira, Remedy, VSS, SVN, CVS, Padre

Telecom Domain Knowledge : Satellite Communication, Cellular Communication, System Design, Algorithms, Link Budget, Optical Communication, OFDM, MIMO, Signal Processing, Lasercom, RADAR, RF, Antennas, Channel Modeling, TCP/IP, IPSec, 4G, LTE, VoLTE, LTE Call flow, PHY, IMS, CDMA, GSM, 3GPP, Electromagnetics, UMTS, GPS, Earth Station

Professional Experience

Software Developer Oct, 2015 – Feb, 2016 AIT Resource Group (Chicago, IL)

Client: Sears Holdings

Project Description: Mobility Solutions based product development as both mobile App and Web-based, aimed as an Enterprise solution for managing home delivery services in optimal way. The application integrates efficient shipment routing solution and mobility solution. The routing solution implemented by third-party, has real-time GPS fleet tracking mechanism, optimal route scheduling algorithm based on destinations, technician skill set, third-party carriers and many more. The mobility solution comprises data management and user-interface for Warehouse Management System, in-store point of sale system, carrier partners, customer notifications etc. It has rich user interface, location based services, content management, database management, report generation etc. An end-user can use specific dashboards, use built-in features like task delegation, get accurate estimate, update orders, push notifications, monitoring and managing shipments, requesting customized reports and many more. The prospective uses of the product are in aiding a Warehouse Associate in managing daily shipments of retail outlet, getting its reports/analytics, task assigning, or POS associate to give accurate delivery windows etc.

Mobility Solutions had various layers, front end with rich UX/UI, and second layer for APIs, WebServices, especially using JAVA, Oracle SOA gateway and scripting, third layer for Database Management, Analytics, Report generation, job scheduling etc., which eventually connects to routing solutions.

Responsibility: Developed modules primarily in the Database layer, implementing business requirement logic primarily using PL/SQL, Perl scripting, UNIX shell script. Created LLD, test cases, carried out testing of modules developed. Assisted with integration, improvising product features, product documentation etc.

-Developed modules as per the business logic using PL/SQL, developed Stored Procedures, Functions, Packages, implemented complex SQL query logic, created Cursors, dynamic SQL, table creation, insert, output formatting etc. in PL/SQL blocks

-Developed complex SQL queries, created Tables, Indexes, Views, sequences

-Extensively used TOAD, SQL *Plus, SQL * Loader for each module development

-Performed query optimization/performance tuning for every requirement implemented

-Written Perl script files as well as UNIX shell scripts, to extract data from files, create and manipulate files, to invoke PL/SQL scripts, job scheduling, also extensively used UNIX /Linux command line interface (CLI)

-Created workflows, mapping etc. for Extracting, Transforming, Loading data files between databases using Informatica tool

-Developed Forms, Reports for end-user to add/edit/read/delete data entries and reports

-Designed and developed location based services feature, providing telemetry information, design for integration with IP telephony systems

-Did constant discussion and brainstorming with team-mates on improvising the product’s features, usability, efficiency etc.

-Assisted in devising ideas for location based service modules, from insight in Telecommunication domain

-Written and executed Unit Test Plan (UTP) and did smoke testing, for each of the requirement developed

-Assisted in creating and executing Integration Test Plan (ITP), regression testing, functionality testing etc.

-Helped with documenting Product features, with technical specifications, flow-chart, performance matrix etc.

Technologies: Oracle 11g, PL/SQL, TOAD, SQL *Plus, Perl, UNIX shell scripting, SQL *Loader, SQL Developer, Padre

Project Fellow June, 2014 – May, 2015 Indian Space Research Organization (Trivandrum, India)

Project: Software project development for ISRO through University of Kerala, as part of ISRO funded projects. Project aimed to study and improve telecommunication link performance in different channel conditions, along with better data rates, lower latency. A software based systems was implemented which has an Atmospheric channel modeling, telecommunication system simulation, database, algorithms, learning mechanisms etc. This system adaptively optimizes the Telecommunication link, based on channel conditions. The software prototype had set of algorithms, workflows implemented in MATLAB, MS Access based Database, data analyzing and interpreting mechanism, learning mechanism etc. which were software implemented. This holistically acted as a complete system in achieving the desired result. The crux of this prototype is in analyzing and interpreting external data against the Database, and invoking workflows accordingly.

The base programming was developed in MATLAB, and MS Access being accessed by SQL queries from MATLAB. The MATLAB programs were linked to specific modules developed in LabVIEW and C++ as well. It also accessed MS Excel in reading and writing data sheets/reports.

Responsibility: Assigned role of Project in-charge, due to a yearlong commendable GUI based software tool development for ISRO as an Intern, during Masters’ from 2012-2014. Played pivotal role in this from project conception, proposal writing, planning, requirement gathering, software/simulation development and testing

-Developed modules in MATLAB, LabVIEW and C++, which were linked according to the process flow

-The channel simulations, algorithms, complex mathematical computations, modeling were programmed using MATLAB and C++

-System design and simulation implemented using LabVIEW

-Designed & created a Database in MS Access for telecommunication parameters

-Created complex Database objects like Cursors, Triggers, Procedures to simple DDL, DML statements, which were invoked from within the MATLAB programs during the process of the overall system execution

-Created Excel sheets, which are read, also created and written based on complex logics from MATLAB programs, utilizing Excel advanced features

-Did exhaustive analysis and interpretation of real time data provided from ISRO, for database creation as well as testing

-Created test cases, test plans etc. for Unit testing, integration testing, functional testing, regression testing etc.

-Did systems set-ups, with proper driver installations, to integrated MATLAB with MS Access, LabVIEW and C++ programs

-Created the whole project as a single executable, that can be invoked as a platform independent product

Technologies: MATLAB, PL/SQL, LabVIEW, C++, Database Explorer, MS Access, Excel, GUI, odbc

Research Intern Jan, 2013 – May, 2014 Indian Space Research Organization (ISRO)

Project: Project: A GUI based software tool development in wireless communication domain, based on novel proposal submitted. It aimed to give an optimum system design parameters based on user inputs and other factors, for any link propagation channel condition. This extensively used MATLAB, C++, LabVIEW and MATLAB GUI programming.

Responsibility: Single-handedly designed and developed the software tool, which comprised research, system design, modeling, software development, testing etc.

-Proposed and designed a novel design optimization methodology as a solution, through close collaboration with Space Physics Laboratory (SPL) scientists, that can be used in future telecommunication projects

-Developed high level design of system, process flow, algorithm and flowchart

-Developed a complete communication system’s software prototype, using mainly MATLAB, LabVIEW, C++, GUI, Database Explorer, SQL, MS Access

-This involved atmospheric channel modeling and real time atmospheric condition simulation

-Simulating system for different communication parameters like modulation, wavelength, data rate, transmit power etc.

-Testing phase had unit testing, integration testing, acceptance testing, functional testing, performance testing, regression testing and usability testing

-System was tested against conventional communication system as well

-Performance tuning in terms of speed and effectiveness of system were made

-Research work focused on telecommunication link budget analysis & optimization, signal processing, optical systems, system design & optimization, atmospheric channel characteristics and its modeling, interconnecting system design parameters with adaptive performance, industry standards etc.

Systems Engineer July, 2008 – June, 2012

INFOSYS Technologies Ltd. (Bengaluru, India)

Exceled in the 7 months training that comprised RDBMS, Oracle PL/SQL, VB, Java, C++, Pearl, UNIX, scripting, Client-server concepts, personality development etc. Later assigned in software development project for U.S. banks.

Client: Union Bank of California (UBOC), California (Mar 2009-Aug 2011)

Project Description: Long term and big-budget project, to develop and customize FINACLE Banking Software in accordance with the requirement for UBOC banking strategies.

Responsibility: Part of System Integration/ETL off-shore track during development phase, mainly to develop modules in extracting Banking data files, transforming and sending to Third-party systems like Government Security systems, Validation systems. Later SPOC for Interface track UAT support phase, leading a team of three.

-Did PL/SQL programming, developed stored procedures, triggers, cursors, packages etc. to read flat pipe-separated files, XML and similar files, to transform and load, based on the requirement logic

-Performed query optimization for every requirement implemented etc.

-Developed tools, written script files using Perl in Linux, to extract data from inbound files, creating workflows, data transformation, invoking database objects, naming outbound files accordingly etc.

-Developed several complex UNIX shell scripts, to implement banking logic on each Interface requirement, to automate many batch process, file handling etc.

-Worked in Test and Development environment in Unix/Linux Servers, for creating new script files, deploying codes, using internal tools, testing etc.

-Designed and generated Reports, in XML, PDF, for interface modules using Oracle Reports, internal tools like Finacle Reporting Tool (FINRPT) etc.

-Prepared and executed Unit Test Plans (UTP), Integration Test Plans (ITP)

-Developed HTML web pages and used javascripting for input validation

-SPOC for the Interface track’s production test phase support (UAT support), mentored and lead a team of 3

-Instrumental in solving high priority issues, handled and monitored all tickets using REMEDY IT service tool, always maintained SLA time

-Maintained and owned issue tracker, RCA document, weekly status update

-Prepared documents on overall workflow of Finacle Interface Architecture, addressing new joiners especially

Client: Discover Financial Services (DFS), Chicago (Sep 2011-June 2012)

Project Description: Customization and development of Finacle Banking Software, with numerous interfaces as per DFS requirement

Responsibility: Part of System Integration/ETL off-shore track, acted as SPOC for a specific track within, in carrying out Project’s initial phase activities

-Was part of preparing Business Requirement Document (BRD), Technical Requirement Document (TRD), Requirement Traceability Matrix (RTM) etc. for the new project’s particular track

-Acted as a System Architect, for the Integration between Bank legacy system and third-party system, identified transformation logic and created data mapping sheets

-Created HLD and LLD for more than 15 external system’s integration with the legacy Banking system, writing pseudo codes using Oracle PL/SQL and scripting

-Developed mapping and workflows in Informatica, for data mapping between Banking Finacle system and external systems, invoking Procedures with transformation logic etc.

-Initiated and developed a Webservices (SOAP, REST) project using JAVA in Eclipse, as Proof of Concept (POC), foreseeing prospective requirements

-Mentored and delegated tasks for new joiners in team, team management and monitoring, took webinars on different tools

Software: Oracle PL/SQL, Shell scripting, javascripting, JAVA, UNIX, XML, XSL, XSD, WebServices, HTML, SOAP, WSDL, REST

Tools: Eclipse, TOAD, SQL *Plus, SQL *Loader, Oracle (10g, 11g), Informatica, Finacle Workflow Manager, Finacle Reporting Tools, VSS, REMEDY

Education

Masters in Telecommunication Engineering (2012-2014)

University of Kerala, India GPA: 3.5/4

Course Work: Digital Signal Processing, Cellular & Satellite Communication, Optical Communication, Adv. Digital Communication, Image Processing, Probability & Random Process, Antenna Design & theory, Advanced Information Theory & Coding

Bachelors in Electronics and Communication Engineering (2004-2008)

University of Kerala, India Percentage: 75%

Course Work: Electromagnetic Theory, Digital System Design, Antenna & Wave Propagation, Signals & Systems, Electronic Circuits, Network Analysis, Radar

Industrial Endeavors

i.ISRO Research Internship : The proposal was accepted and admitted for research work at SPL, ISRO, that gave a good exposure on its infrastructure, industrial standards and satellite communication

ii.BSNL In-plant Training (India Government’s Telecommunication Company) : Had in-plant training at Bharat Sanchar Nigam Limited (BSNL), that gave hands-on experience and special training in Telecom technologies like WiMax, FTTH, GSM, 4G, LTE, UMTS, SNMP, Syslog, OFDM, CDMA etc. Also got exposure with testing telecom devices, monitoring, and Telecom software tools.

iii.DDK In-plant Training (India Government’s Television Broadcasting Organization) : Had a short-term training at Doordarshan Kendra (DDK), India, which gave hands on exposure with TV recording, editing, storage, playback, earth station, antennas, terrestrial and satellite transmission

Accomplishments/Recognitions

Best Performer in one quarter, for test phase support of the project, with 100% closure of issues well ahead of time, also for proactive contributions

Developed a tool for automatic script generation that improved task completion

Voluntarily proposed and devised a root-cause analysis tracking mechanism

Single-handedly authored Banking Software’s overall architectural workflow document

Groomed and mentored around 8 new joiners in the team, at Infosys

Identified, studied and took webinars on prospective tools, that made tasks easier

Proposed and developed a novel project for ISRO, which received high acclaim

Elected as College Secretary, IEEE Student’s Chapter in B.Tech pre-final year and the ‘Best IEEE student branch’ award was bestowed following year

Had organized & coordinated 4 International Technical conferences at college

Recognized for giving excellent seminars, presentations, with prizes won for many

Contact this candidate