Senior Software Engineer Network & Applications
Resume:
RALPH CARLSON
PROFESSIONAL APPLICATIONS DEVELOPER – SR. NETWORK / SOFTWARE ENGINEER
CONTACT
*********.****@*****.***
PROFILE
I am a technology professional with 30 years of experience in information technology. For the past 23 years I have been a lead developer and analyst at AT&T. During that time I have developed, tested and maintained applications and databases written in and using java, c, html, visual basic(a/s), json and a variety of other languages. Along with creating packages and procedures in SQL Server/Visual Studio respectively. Additionally I have gathered and analyzed information from multiple sources (Oracle,Teredata,Access,SQl) to build data for automated processes.
SKILLS
Hardware
Personal Computers: IBM PC and clones, Mac.
Midrange Computers: AS400.
Mainframe Computers: IBM DB2.
Server: SQL, Sun.
Software
Automated Test Tools: WinRunner, Quick Test Pro, Unified Function Test, Quality Center, Test Director, LoadRunner, Rational Robot, Silk, Automation Anywhere, Selenium.
Relational Databases: ORACLE, Access, SQL.
Operating Systems: Windows 3.1, 95, 98, 2000, XP, NT, Vista,7,8,10. Unix, X/Windows,
MVS/XA-ESA, AS400, Mac. CITRIX.
Other Software: Via Soft Smart Test, Trans Century Date Simulator,
TSO, ISPF, Word, Excel, Lotus Notes, GIX, JCL, Reel Librarian, PVCS,
JES2, Apriori, VI Editor, Rumba, Extra, Reflection, TOAD, Attachmate.
Languages used
JCL, SQL, TSL, C, C++, Visual Basic, VB Script, VBA, Extra Basic, HTML, Java.
Key technologies used:
json, angular,
SQL, oracle, office 365 (access/excel/outlook),
code cloud, git repository, tsl (c++ mockup),
Teradata sql assistant
AZURE
Applications Accessed
Dtv scripts, act sharpoint, rome, granit, boss/ bocris / dpss, gpc bcm remedy, gecep, crm, telegence, oracle web app.
ITRACK
XWINDOWS
FME
POWER BI DESKTOP
EXPERIENCE
AT&T
2021 - Present
Title - Sr. Software Engineer (Network Planning and Engineering)
Summary:
Member of the Integrated Planning team responsible for data retrieval and manipulation to aid core business needs dealing with future forecasting and current actual site data. Work with both department personnel as clients and source internal and third parts data vendors and warehouses. Supply assistance in testing group software. Azure process and feasibility testing and system administrator backup. In addition to the forementioned roles a revolving knowledge is needed to keep up with new trends in technology. Whether it be cloud or new data streams, tools and platforms.
Responsibilities:
Responsible for data retrieval and manipulation to aid core business needs dealing with forecasting and current actual site data.
Work with department personnel as clients and source internal and third party data vendors and warehouses
Assist in testing group and external software.
Azure process and feasibility testing (IAAS VS PAAS) and system administrator backup.
Streamline existing data retrieval processes by updating procedures and packages.
Create and maintain reports using Sharepoint, Excel, Excel Pivot,Power BI and FME.
Pull data from DODGE and external sources (EGIS,Instar,Canopi,Tirks)
Create stored procedures, ssis packages, Power BI queries and FME processes.
Trouble shoot issues and repair as needed. This may require learning and using new softwares or configurations
AT&T
2016-2021
Title: Professional-Applications Developer
Summary:
Lead developer for the FBO QTP/UFT Gui automation team responsible more than 3 million yearly transactions and a savings of 250 FTE.
Responsibilities:
Update and maintain code for the FIT (FBO Issue Tracker) site using Visual Studio (json/angular),SQL, code cloud and GIT.
Create solutions for DTV Script conversion from SAP to SQL management system by writing code in VS and SQL to process the request and query EDW.
Analyze information gathered from EDW, Oracle, excel, SQL and flat file sources to supply correct processing data for automation requests.
Create SSIS packages in Visual Studio for data import and export to client.
Create procedures in SQL server for data import, export and job creation.
Create and maintain tables and processes for automation framework.
Analyze submitted requests for feasibility of automation.
Work with clients to determine and create automated solutions whether through gui interface or database transfer.
Create tools macros tools that can be handed off for standalone automation.
AT&T
2002 – 2007 (sd3)
2007 – 2016 (at&t)
Title: Solution Specialist / Senior Automation Lead / Developer.
Summary:
Work with and mentor team through various projects ranging from DB2 emulation to client server to Web apps.
Assign resources based on business priority. Determine cost management for automation lab. Primary contact for project assessment. Develop solutions for data transfer between various applications and data bases. Maintain working knowledge of new client software in order to develop solutions that fit such client software.
Responsibilities:
Create automated solution for data transfer from Oracle database to BMC Remedy application by incorporating a cross platform solution using QTP, vbs, Oracle and Windows scheduler.
Issue ORACLE database queries and updates using SQL through TSL and VB based applications.
Run SQL queries on third party credit application.
Develop an automated process to simulate end user functionality on a Citrix based front end systems
(WEB / VB / Power Builder/ Terminal Emulator) using Mercury's WinRunner/QTP/UFT.
Work with third party vendor to implement credit scoring application.
Trouble shoot data transfer to ORACLE databases.
Define business objectives and system requirements.
Test feasibility of OLI data transfer.
Create test plan and document data model.
Develop cross environmental data transfer to production system using automated tools.
Develop and test end to end scoring process from file transfer to system update.
Test Citrix based Telegence system life cycle from application to ORACLE database update.
Work with end users as mentor on new system.
Train and mentor current business personnel.
Assist in department processes including Fraud, Credit and IT.
Monitor production ORACLE data bases using TOAD.
Implement automated ‘real time’ scheduling for WinRunner processing.
Develop automatic letter creation using Word, Excel, ORACLE and Mercury interaction.
Develop auto dialer scripts and update process.
Perform administrator duties on various Access data bases.
Additional tasks:
1.Using automated tools, designed and developed cross platform end user data transfer lab replacing the workload of 140 people.
2.Develop, code and implement real-time data transfer and application update from offsite ORACLE databases through in house applications using TOAD and WinRunner’s TSL to navigate and issue SQL and DOS commands.
3.Created automated data input for POCITS system by incorporating a cross platform solution using WinRunner and system specific macros written in HAScript.
EDUCATION
Mt. Prospect/DeKalb
Program: General Studies
Level: High School Diploma
Certifications
Transformation Learning Series: Technology Transformations Track
Issuing Organization
AT&T University
Contact this candidate