SUMMARY:

• Versatile Software/Systems Engineer, around 7 years of experience, seasoned in scripting languages, databases, automation & backend programming, *NIX, OOP, Webservices/API, Systems/Solutions Engineering with U.S. Telecom OSS/BSS Systems/Processes and Banking domain knowledge
• Expertise in the order of Perl, Oracle PL/SQL, MySQL, shell script, XML, HTML, SOAP/REST Webservices, API, BRMS iLog, JSON, javascript, C++, Matlab, python
• Involved in all phases of Software Development Life Cycle (SDLC), experience working on critical projects with extremely tight deadlines
• Both Agile & Waterfall Software development and tools exposure, along with Test Driven Development ( TDD ), UAT support and testing
• Acclaimed for quickly understanding new System designs & complex processes in detail, recognized for applying novel & creative techniques to existing processes/applications
• Requirement gathering & Solution Engineering experience, designing & developing process workflows using Camunda BPMN, to act as liaison between Business and IT
• Well - seasoned in scripting advanced data structures , optimized codes, backend & frontend spanning multiple platforms/applications from implementing numerous scripts especially Perl (*NIX & Windows) realizing complex & critical business logics
• Implemented file handling, report generation, proactive email alerting, extensively used libraries/packages and different error handling techniques
• Proficient with Object-Oriented Programming (OOP) concepts from over 10 years of academic & industrial OOP based project implementation in C++, Perl, Matlab
• Developed Event-driven automation processes using IBM BRMS iLog Rules Language JRules - Business Rule Management System (BRMS) programming
• UNIX shell scripting experience, for invoking PL/SQL scripts, job scheduling, automating batch processes/repeated processes, file handling, implementing requirement logic
• Worked in UNIX & Linux systems, Oracle Virtual Box, maintained proper procedures of testing, deployment & monitoring across Test, Development and Production environments
• Extensively used CLI commands , vi & vim editor, crontab, adept with awk, sed, grep
• Developed complex SQL ( Oracle & MySQL ) queries, including joins, sub queries, constraints , in all 5 projects worked till date
• Created several PL/SQL objects Stored Procedures, Functions, Packages, Triggers, on versatile & challenging requirements, domains and applications
• Extensive experience using Webservices both SOAP & REST, Web API , handling WSDL files, XML and JSON input payloads and responses
• Written JavaScript for front-end applications, form validation, and also for HTML script
• Acted as UAT support SPOC for a track, managing a team of 3; effectively handling tickets, solving issues, issue tracking, weekly status update
• Used GIT, CVS, SVN & VSS for Source code management, and worked on REMEDY, JIRA for issue/project tracking
• Proven expertise in devising novel ideas/designs, technical writing/documenting, driving technical discussions, taking-up responsibility and interpersonal communication skills

TECHNICAL SKILLS:

Programming (Advanced): Perl (backend and frontend, Object-oriented), Oracle PL/SQL (Packages & Procedures), MySQL, shell script

Programming (Expert): BRMS iLOG JRules, JAVA, C++, Matlab, Simulink, Python

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

Web Technologies: javascript, XML, HTML, JSON, Webservices (SOAP/REST), WSDL, Web API, LAMP

Platforms: UNIX, LINUX, Windows, Ubuntu, xubuntu

Tools: /Platforms: Eclipse (Mars/Kepler with perl, database, git, camunda plug-ins), iLOG (BRMS), Oracle Virtual Box, TOAD, SQL *Plus, PL/SQL Developer, MySQL Workbench, SQLYog, Soap UI, Postman, MS Access, Visual Studio, JMeter, Altassian-Jira, Altassian-Confluence, Remedy, Git, Camunda BPM (bpmn & dmn), VSS, SVN, CVS

Telecom Domain Knowledge: Networks, OSS, BSS, SDN, VNF, Ethernet, Confidential & Confidential Switched Ethernet (ASE- topologies, circuit elements, diagnose procedures), Satellite & Cellular Communication, System Design, Algorithms, Link Budget, Optical Communication, MIMO, Signal Processing, Lasercom, RF, Antennas, TCP/IP, LTE, 3GPP, Electromagnetics, UMTS

PROFESSIONAL EXPERIENCE:

Solutions Engineer

Confidential, Dallas, TX

Responsibilities:

• Lead a critical high profile project to automate end-to-end processing of Service Assurance ticket in WFA Access Network. The process aimed to automate from customer ticket creation to do initial filtering for DS1 service lines, initiate diagnose on circuit to identify and isolate trouble in circuit, decision on doing next actions based on diagnose results.
• Developed multi-system based complex work flow process which was well accepted and appreciated across team.
• Worked with development team, created Dev workflows, decision making tables, testing sub-workflows
• Actively involved in testing Confidential & Confidential application/system’s API using Soap UI/Postman , creating different XML payloads, documenting, load testing API using JMeter to import these to Talend API Gateway
• Instrumental in creating different document template for whole team to address different purposes. Created numerous well written documentation.
• Continued Perl and iLog JRules programming during transitioning period from Application developer to Solution Engineer.

Technologies: Camunda BPMN Workflow Modeler, DMN tables, SQLyog, Soap UI, Postman, Eclipse, Perl, javascript, BRMS iLog Rules Language JRules, HTML, XML, JSON, API, SQL Developer, MySQL Workbench, Oracle VB-xubuntu

Application Developer

Confidential, Dallas, TX

Responsibilities:

• Automation scripts are written adhering to TDD , after accurately understanding business process, unit tested thoroughly with test tickets before deployment, and monitored for a while to make sure automation didn’ Confidential break any existing unforeseen processes and executing intended business logic.
• Any deployment is critical to business, impacting customers, affecting in large scale- did white-box testing utilizing TDD, black-box testing along with Business client, regression testing as improvising existing automations were frequent
• Created UI & its backend processes where front-end aids Network Technicians to execute the automation. Eg: UI to input a bunch of tickets for closure, associated with major event like hurricane. Technician can key in common comments and level of automation. Automation will act on each ticket, identify billing, close all pending referrals, identify and act on any dispatch and finally close the ticket with proper close codes. This saves days of manual touch and business revenue is significant.
• Automated many processes by extensively using cron-jobs, perl script logic
• Designed and implemented automation for a part of Federal government project, that involved creating new tables and loading data after cleaning-up raw data, creating UI for end-user, clubbing event driven iLog programming which in turn invokes perl scripts.
• For internal infrastructure betterment, created a monthly reporting logic , proactive alerting on system’s downtime by utilizing API transaction failures on each system, conversion from old IBM 3270-terminal screen-scraping processes to API transactions, processes’ health check etc.
• Undergone 2 weeks Confidential & Confidential Ethernet training Layer 1 & Layer 2 , which included different topologies, circuit layouts, equipment details (switch, router), common language codes, tools/application, troubleshooting and isolating trouble etc. Took additional Confidential & Confidential specific training - Mobility Transformation, Tools etc.

Technologies: Eclipse, Perl, javascript, BRMS iLog Rules Language, HTML, XML, JSON, API, SQLyog, Soap UI, Postman, SQL Developer, MySQL Workbench, Oracle VB-xubuntu

Software Developer

Confidential, Chicago, IL

Responsibility:

• Developed modules primarily in the Database layer, implementing business requirement logic using PL/SQL, Perl scripting, UNIX shell script .
• Created Stored Procedures, Functions , Packages , complex queries to implement business requirement logic, also for publishing functionalities through Oracle SOA
• Perl scripts were written to open inbound files, extraction, implementing business logic on data, writing outbound files etc.
• Unix shell scripting were used to invoke PL/SQL scripts, file handling, job scheduling, also extensively used command line interface (CLI)
• Written numerous Triggers to account for actions made by user and other scenarios, invoked Stored Procedures from within Triggers
• Created Indexes to improve the performance, Views to eliminate the complexity of complicated queries, written User-defined Exceptions
• Worked on both High level Design and Low Level Design of the product, was part of designing system architecture, identifying process flow
• Attended discussions on improvising the product’s features, usability, efficiency etc.
• Written and executed Unit Test Plan (UTP) , Integration Test Plan (ITP), regression testing, functionality testing etc.
• Assisted in creating and executing 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

Project Fellow

Confidential

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 . Played pivotal role in this from project conception, proposal writing, planning, requirement gathering, software/simulation development and testing

Responsibilities:

• Developed modules primarily using MATLAB, SQL, MS Access, Excel
• The channel simulations, algorithms, complex mathematical computations, modeling were programmed using MATLAB and C++
• Designed & created a learning Database in MS Access for telecommunication parameters
• Created Database objects involving complex logic, also 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 the Excel advanced features
• Generated Excel Reports based on SQL queries in MATLAB program, for auditing and analysis purposes Confidential set intervals
• 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.

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

Systems Engineer

Confidential

Responsibilities:

• Developed Stored Procedures, Triggers, Cursors, Packages to read flat files, XML and similar files, to transform & load, based on interface requirement logic
• Created Perl scripts to extract data from inbound files, creating workflows, data transformation, invoking database objects, naming outbound files accordingly etc.
• Developed tools, and written UNIX shell scripts , to implement Interface requirement logic, job scheduling, automate many batch process, file handling etc.
• Worked in Test and Development environment in Unix/Linux Servers
• Developed tools to automate many batch processes, did Interface jobs batch scheduling using Control M and internal tools
• Prepared and executed Unit Test Plans (UTP), Integration Test Plans (ITP)
• Developed HTML web pages and used java scripting for input validation
• Used VSS for source code control and versioning
• 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