JOHN BRITTO AROCKIAM

[US Permanent Residence Holder]

ad4pt8@r.postjobfree.com 703-***-****

Objective

Seeking for any challenging role as Solution Architect, Production Support Manager, Technical Team lead, Database Engineer, Application Administrator, Sr. Data Analytics Engineer in UNIX, Oracle & WebLogic, Big Data, Hadoop, Snowflake, Cloud environments.

Summary

Excellent knowledge in Client Server application design & development using ORACLE in HP-UX, Oracle Solaris, Linux, WebLogic, Developer 2000 Tools, SQL, PL/SQL, Pro*C, UNIX Shell, awk scripts.

Expert in Oracle data migration, data analysis, extraction, validation, loading and data analytics in a big data and Snowflake cloud environment, telecom billing integration & migration, capacity planning, process automation and improvement.

IT professional with 29 years of experience in system design, development, testing, implementation, solution architecture, data center migration, disaster recovery, application administration. monitoring and production operation support for various Telecommunication, Mortgage and business applications.

More than 19 years of Telecommunication industry experience in Mediation, Customer Care, Order Management Systems, Service Provisioning, OSS/BSS, Number Management System, Number Porting System, Rating & Billing, Billing Conversion and System Integration for Wireline & Wireless, Pre-paid, voice, Data, VoIP and Cable products in major Telecom Service providers like Sprint, Verizon, AT&T, TWC in U.S.A. and Malaysia.

Education

Master Degree in Physics (Electronics specialization) (1987–89)

Post Graduate Diploma in Computer Science and Applications (1989-90)

Diploma in Oracle RDBMS

Training course in Oracle (Bea) WebLogic Administration

Certification in Portal System Administration (ORACLE-CBRM)

Skill Set

Operating System : DOS, UNIX, HP-UX 11.0/11i, Sun Solaris 8/9 Oracle Solaris 10/11, Red Hat Linux,

Windows family, UNISYS/DB2 – Mainframe

Cloud platform : Amazon Web Services [AWS] EC2, Big Data, Snowflake.

RDBMS : Oracle 7.X/8i/9i/10g/11i, Forms 3.0, Report Writer 1.1, PL/SQL, SQL*PLUS,

SQL*Loader, TOAD, SQL*Navigator, DB2, Netezza Data warehouse.

Reporting GUI tools : Oracle BI Discoverer 10g, Developer 2000, Forms 4.5, Report Writer 2.5,

PowerBI, Tableau

Scripting/Languages : BASIC, COBOL, C, UNIX Shell & awk, cron jobs, Perl, Pro*C, SQR, Python,

PeopleCode, J2EE, JSP java scripts, EJB, struts, HTML, XML.

Software Packages : BSCS (Business Support & Control System) Customer Care & Telecom Billing

System, Order Management System, MABEL, Amdocs-Number Management

System, CBRM (Portal), WLNP, FusionWorks Mediation product.

ERP Application : PeopleSoft HRMS 7.5

Tools : PeopleTools, PS/nVision, Process Scheduler, Ab Initio (ETL), PM4DATA,

CVS, Remedy, SharePoint, Quality Center, DOORS, EDP, DocShare, Visio,

PS/Query, Application Server, Import Manager, Tree Manager, Data Mover,

Business Objects, Maestro, AutoSys, Control-M, SFTP, MFT, SSH, Telelogic Change

Synergy, Guardium, Net-Cool, BigBrother, Arris-NSM, JDSU-NetComplete,

HPOV-SiteScope, Splunk, Big-Panda, NimSoft, Dynatrace, CyberArk,

Kibana, Elasticsearch (ELK), Openshift MicroServices, DevOps, Agile, CI/CD

Middle ware : EAI, Bea Tuxedo 8.0, IBM MQ Series 5.3

Web application Server : Bea WebLogic 6.X/7.0/9.X/10, Tomcat & Apache server.

Hardware : IBM PC /AT 486, Pentium Pro, DEC 8400 Model 5/300 AXP,

IBM RS6000 model J50 Servers, IBM Mainframe, UNISYS mainframe, HP-UX,

Sun Fire V20z, x4100, SPARC-Enterprise-T5220, F5-Load balancer.

PROFESSIONAL SUMMARY

Freddie Mac (Client) Sr. Data Analytics Engineer Feb 2023 – Feb 2024.

Managed daily data loading process for Freddie Mac's PRD [Property Reference Data], LAS [Loan Advisory Suites] applications by loading Hive source data loading in Big Data – Hadoop SpySpark framework in EC2 with Hive source to Snowflake target data base for consumer reporting and analytics.

Worked on monthly data reconciliation process to validate Hive source data with Snowflake target data for any missed/mismatch/duplicates by using Hive SQL and Snowflake SQLs.

Performed daily validation on DMC [Data Movement Controls] reports and DQ reports for successful data loads.

Involved in data loading requirements and Code review, AutoSys jobs Jil updates for new and existing application data feeds, performed production deployments and maintained Operational Process documents.

Responsible for daily process monitoring and troubleshooting AutoSys, Control-M data loading jobs failures and MFT [Managed File Transfers] for incoming and outgoing files for external customers.

Automated data load jobs monitoring process.

Worked on creating stories in JIRA and participated in Sprint ceremonies to track production deliverables.

Freddie Mac (Employer) Application Management Sr. Aug 2016 to Oct 2022

Managed 400 plus Freddie Mac’s Single Family, Multi Family and I&CM applications by providing production support on 24X7 basis to ensure high availability to customers.

Involved in trouble shooting critical incidents based on SLAs and also provided solutions to fix potential issues for various applications on Windows, UNIX/Linux, Mainframe, Openshift MicroServices, Middleware, Weblogic, Oracle, DB2, MongoDB, AWS. Incident follow-up to find RCA for P1/P2 issues and vendor follow-up for any bugs/issue.

Participated in change management process, reviewing requirement, system flow/architecture changes, design specification and functionals testing documents.

Gathering requirements to set up alarms for monitoring application logs, performance to capture potential issues/failures using monitoring tools - Dynatrace, NimSoft, SiteScope, Splunk, Kibana, Elastic, BigPanda.

Supported Production deployment and post production validations and monitoring activities.

Designed and developed ServiceNow dashboards and reports – Infra Inventory by applications, Incident trends, planned changes.

Supported Affinity Group AG disaster recovery [DR] practices on routine basis to handle emergency on-demand data center switch overs for Single Family – Sourcing and Servicing applications.

Lead automation efforts in automating various manual processes - BCAS monthly schedule, eTrust reconciliation, CSP Health Checks and proactive support for CSS Bond Admin monthly process using UNIX Shell scripting, Oracle SQL, PL/SQL, DB2.

Provided monitoring and troubleshooting support for AutoSys, Control-M job, Jobtrac jobs and MFT [Managed File Transfers] for incoming and outgoing files transfers for external customers.

Maintained Process documentations through KBA process, Confluence, SharePoint and JIRA.

Supported/implemented application Infra validations, Application validations through internal health checking tools ISVT/INVENT, AAVT.

Time Warner Cable / Charter Communications (Employer)

OSS – Application Administrator July 2015 to Aug 2016

Responsible for designing and setting up new environments to support OSS applications.

Supporting RIO data acquisition tools to monitor various TWC network elements.

Set up monitoring tools such as Splunk to monitor OSS application health, real time network traffic and also unauthorized user access.

Automating various manual monitoring processes, installation and admin processes.

Administrated and maintained Oracle BI running in WebLogic environment.

Configured SOAP messaging using WSDL for reporting and metrics application.

Responsible for DB migration, ETL scripts and Java deployment and support.

Trouble shooting and resolving Oracle database issues.

SWIFT (Client) Sr. Database Engineer Jan 2015 to Jun 2015

Worked as an Oracle database specialist in data conversion for SWIFT messaging FIN application which maintains financial transaction message data.

Involved in UNISYS data analysis and data mapping, conversion of messaging data from UNISYS to Oracle database in HP-UX environment.

Developed data conversion scripts using UNIX Shell, PL/SQL and Perl scripting.

Created Oracle SQL reports for validating converted messaging data from Oracle with UNISYS data.

Created process documents and mentoring team members about the data conversion process and messaging validations techniques.

Worked with performance testing team in gathering performance data and required Oracle AWR, ASH, SQL health check reports for performance improvement.

Created Oracle database server and client on Windows Server 2012.

Deployed application on various application hosts in EMC VMware environment.

Maintained Oracle database and monitored through OEM.

Time Warner Cable Inc., (Client) Production Operation Manager Mar 2010 to Nov 2014

Worked as Lead Engineer at Openet and Production Operation Manager for managing TWC TVE (TV EveryWhere) – Operations team and coordinating TWC operation efforts with Off-shore GPOC – Malaysia Operation team.

Mentored and managed offshore (India, Malaysia) team size of 10 operational resources to support TWC’s real time application with high-availability to customers.

Implemented mediation solution for Openet’s clients (Wireless Voice & Data, Cable providers) by using Openet’s mediation product – Fusion Works suites.

Interacted with internal and external customers in analyzing customers’ business requirements and implemented effective solution to meet their mediation needs in generating CDRs (Call Detail Records) by applying business logic and delivering CDRs for downstream billing applications.

Build new environments, system configuration, installing Openet products and UNIX tools in non-production and production environments.

Worked on new data center project in planning IT infrastructure for internal and external application connectivity by using SOAP technology, TCP/IP, SNMP in Oracle and UNIX platform.

Provided solution for data center migration to maintain high-availability with dual data center setup (Active/Passive).

Provided disaster recovery plans in dual data center automated data center failover to avoid application downtime with F5 global/local load balancer controls.

Responsible for gathering monitoring requirements for application health and hardware and preparation of configuration setup document to implement by using HP-Openview, SiteScope and Splunk monitoring tools.

Developed admin scripts to automate various operational processes checking, setting up alarms & alerts and processes monitoring using UNIX shell scripts, awk and Perl scripts.

Worked on daily (CVC) and monthly bulk data loading for STARS process, GIS data loading for identifying Geo based customer’s location specific data and resolved many data load performance issues.

Proficiency in big data extraction and loading onto Netezza data warehouse.

Worked on various TWC (Time Warner Cable) projects - AM (Audience measurement for Cable TV), CBB (Consumption Based Billing) and also TVE (TV EveryWhere).

Worked on AT&T Projects – Data re-architect project, Jasper IMSI extraction, IPv6 conversion.

Time Warner Cable Inc. (Client) Sr. Technology Engineer Feb 2009 to Dec 2009

Worked as a Sr. Technology Engineer for Time Warner Cable’s Operation System Support (OSS) Group and administrated their Network Services Management (NSM) application servers.

Responsible as an Application administrator in automated installation, jumpstart configuration, upgrading servers, installing capacity upgrades and user’s security administration.

Worked on application deployment, upgrades, process engineering and providing production support (24/7 on-call rotation basis) for NSM (UNIX Sun Solaris, Weblogic, Tomcat, Apache servers) and other monitoring applications for various TWC’s regional data centers (RDC).

Managed escalations from Regional Network Operations Centers (NOC) and troubleshoot the key system integration points between Monitoring Tools Applications/Software (such as NSM).

Installed and monitored the overall health of the application servers using monitoring tools like Big brother, MicroMuse Netcool.

Worked on trouble shooting system / network performance issues in production by monitoring the flow of traps, alarms using monitoring tools, working with other system integration groups to drive them to a resolution.

Designed and developed various reports on daily outages of VoIP, Cable and other Network devices for various divisions by using Oracle PL/SQL with BULK COLLECT.

Supported the Broadband Provisioning System (BPS) applications in resolving various Business and residential customer’s VoIP / digital phone & cable modem provisioning issues by working with customer Service Representative and Order management & Billing groups.

NRTC (Client) Database Analyst - Administrator May 2008 to Dec 2008

Worked as an Oracle database analyst and administrator for National Rural Telecommunications Cooperative (NRTC) applications Members Relations Management and other revenue reporting data warehouse applications.

Involved in application data analysis, data modeling, data mapping, data loading and data refresh activities for the NRTC billing application migration project using Oracle 10g Data Pump.

Maintained data quality, resolved various data migration & data mapping issues.

Involved in Oracle database related projects requirement gathering, technical design, migration, production implementation and maintenance activities.

Worked on installation, configuration for Oracle database applications and upgrading Oracle server related products & applying patches.

Build new databases and maintaining database servers in non-production and production Implement and maintain database security (create and maintain users and roles, assign privileges)

Performed application tuning and performance monitoring.

Created and maintained Oracle PL/SQL stored procedures, triggers and shell scripts to manage and monitor day to day database operations.

Designed and generated various business revenue reports using Oracle BI Discoverer 10g.

Sprint-Nextel (Client) Technical Team Lead Aug 2007 to Apr 2008

Worked as a technical lead for the EGS (Encrypted Gateway Servers) file transfers projects including Sprint Xohm – 4G (WiMax) Projects and Data Center UNIX server migration projects with team size of 8 development and testing resources.

Provided IT infrastructure solution for various projects & resources for Sprint-Nextel production applications to set up File transfer interfaces using SFTP through EGS by using PM4DATA, MQ Series, Connect:Direct, Ab Initio (ETL) in the EAI middleware architecture, UNIX Sun Solaris, Oracle, Weblogic and Ab Initio (ETL) with SOX compliance based encryption and auditing.

Worked with various Sprint’s external trading partners, Sprint-Nextel’s internal application groups and Data warehouse team in maintaining business relationships, gathering requirements, technical design reviews, providing LOE’s, preparing Interface design document, test case documents for UAT and managing release coordination efforts.

Lead development and testing resources to meet the project time lines & deliverables.

SunRocket Inc. (Employer) Sr. Systems Administrator Jan 2007 to July 2007

Worked as a Sr. System administrator for the VoIP billing application ‘ORACLE - CBRM' (Portal).

Involved in requirements gathering analysis, billing architecture design and Implementation of Oracle - CBRM application on UNIX – Sun Solaris servers in development, staging and production environments.

Responsible for customer, price plan & other billing data mapping and conversion.

Designed and setup various production applications monitoring scripts using UNIX Shell scripts.

Supported data conversion activities using Oracle PL/SQL procedures.

Managed VoIP - CDR (Call Detail Records) rating process by using Pipeline process.

Fannie Mae (Client) Database Audit Specialist Sep 2006 to Dec 2006

Worked as a ‘Database audit specialist’ and lead all Oracle database monitoring efforts for database modifications, privileged activities, security events for about 30 Fannie Mae applications to fulfill SOX compliance.

Reviewed DB native logs which include sys & audit logs from various Oracle databases on daily basis to identify unauthorized events and issuing incident report tickets.

Designed and developed Oracle logs monitoring automation process by using UNIX shell scripts.

Monitored database activities for restatement applications using Guardium monitoring tool.

Generated unauthorized DB activities reports to various application point of contacts.

Sprint-Nextel (Client)

Data Analyst May 2006 to Aug 2006

Responsible as a data analyst for the SIMS to NetCracker data conversion project (DNS service provisioning system).

Involved in data mapping and conversion meeting, requirement gathering, data analysis and providing solution for better conversion results.

Designed data modeling and developed data conversion ETL scripts for data extraction & loader scripts using UNIX Shell scripts, Oracle, PL/SQL, Toad.

Managed data migration activities, mapping issues and provided problem resolution.

Architect / API Interface Specialist Jun 2005 to Apr 2006

Worked as an API Interface Specialist and managing all Nextel & Amdocs Billing APIs used by all Nextel and Partners applications.

Maintained price plan and billing APIs inventory, gathered forecast data for all APIs from various Sprint-Nextel applications for reporting purposes.

Managed Forecasting & capacity planning based on current & future demands and recommending additional API capacity purchase.

Analyzed and promoted process improvements on heavy Java, API usage applications such as Ensemble - wireless post-paid and Boost/BCGI pre-paid applications.

Involved in new environment build discussion, application data conversion, requirement analysis, process improvements and provided recommendation to overcome capacity issues.

Provided various Amdocs and EAI API usages statistical transaction metrics using BI to the business group and help them in managing the hardware and application resources effectively.

IBM (Employer) IT Specialist - Architect Sep 2004 to Jun 2005

Worked as an Application administrator, Production support analyst and Subject Matter Expert (SME) for Sprint PCS application ‘Number Management system’ (NMS) and Operation Support System department.

Managed and coordinated production releases for various NMS releases, WebLogic Server build / deployment, code enhancement and code fixes

Configured back-end and front-end codes for NMS/NPS/DMT-DST applications in various system testing, product testing non-production environments & training environments using HP-UX and Sun Solaris, ORACLE, MQ on EAI architecture and provided support to resolve various issues.

Worked on various application integration tools to build new environments with tuxedo & configuring MQ queues set up for message transaction to Business Support System (BSS) and other interface and deployed web applications on the WebLogic server on EAI architecture.

Provided 24 X 7 production support to NMS application and resolving production issues with customer activation, batch errors and other Wireless Local Number Porting (WLNP) issues.

Automated data migration process for the Qwest subscriber’s data conversion to handle the port in & port out MDNs and sending auto mailing to the client by using HP-UNIX korn shell and awk scripts.

Scheduled and managed cron jobs, Control-M, Maestro and daemons in production to kick off production batches, server startup & shut down and reporting process

Worked as the project lead for MEID (Mobile Equipment Identification) conversion project and designed conversion methods with PL/SQL package to increase the efficiency.

Proactive support to front end billing systems (P2K – Convergys) on resolving various billing issues, EAI out of synch data issues and resolved NMS internal data issues and resolving customer’s issues.

Supported data warehouse data feed activities for the Business Intelligence group.

Sprint PCS. (Employer) Software Engineer III Jul 2002 to Sep 2004

Responsible as an application administrator, provided production support for Sprint PCS applications such as Amdocs’s NMS (Number Management System), NPS (Wireless Local Number Porting System) and DMT/DST (Data Management Tool/Data Synchronization Tool) on EAI architecture.

Worked as project lead for various NMS releases, DMT (Data Management Tool) release and Long Term Picture Mail projects. Assessed user/customer’s requirements, developed project deliverables, prepared implementation plans and successfully implemented into production.

Configured Maestro for NMS batch job scheduling, UNIX daemon & cron job scheduling and troubleshoot the job scheduling issues.

Provided production support for NMS/NPS and resolved various customers’ activation/deactivation issues, batch job failures & other Wireless Number porting issues.

Analyzed various Numbering solution requirements such as Number pooling / donation, prepared SIA (System Impact Assessment) documents, requirement, functional and design specification document.

Automated WLNP (Wireless Local Number Portability) MDN related data extraction reporting tool, NMS GUI user ID administration tool by using Unix Shell scripts and PL/SQL function & stored procedures, UNIX cron jobs.

Designed and developed ETL scripts to extract data from one data base and load the formatted data into another database using UNIX Shell scripts, PL/SQL, SQL*Loader and export/import utilities and also prepared test cases, conducted unit testing, UAT and provided testing coordination to system testers.

Developed scripts for Long Term Picture mail, ESN validation for Qwest subscriber’s data using PL/SQL and UNIX Shell script.

Verizon Wireless Inc. (Client) Sr. Telecom Consultant Jul 2001 to Apr 2002

Responsible as a Business Analyst for their billing data conversion from ‘Prism’ billing system into new billing system ‘Vision’.

Data Analysis on price plans, Features. promotions and validation on the uploaded data in the new system.

Involved in requirement gathering, analysis, development for changing the existing billing application source codes in COBOL as per the conversion requirement in DB2 mainframe environment.

TeleCorp Inc. (AT&T) (Client) Sr. Telecom Billing Consultant Jul 1999 to Jun 2001

Worked as a Sr. Programmer Analyst and responsible for the overall billing integration and production support for BSCS ver. 5.01

Scheduling the bill cycles and monitoring the billing process, fixed various billing batch errors.

Designed and developed various production reports such as rating reports, billing revenue reports using UNIX Shell script, awk scripts, PL/SQL and cron jobs.

As a BSCS functional analyst, analyzed and recycled all the RIH rejected call records (CDR).

Technical team lead role in administration for the Cap Gemini’s MABEL (Major Account Billing Exchange Logistical) system for Corporate accounts for National accounts discounting and also supported the corporate accounts payment processing system using the Lockbox system.

Maintained C, PRO*C, PL/SQL stored procedures & code changes to fix the system defects.

Binariang Sdn. Bhd., Malaysia (Client) Sr. Telecom Consultant Dec 1998 to Jun 1999

Designed and developed a Service Order processing system called ‘High Capacity Provisioning System’ using Oracle & Developer 2000, Designer 2000 for Maxis Binariang, Malaysia.

Prepared system design specification document.

SHELL Petroleum Pte. Ltd., Singapore (Client) IT Consultant May 1998 to Nov 1998

Responsible for the overall production support and coding changes for the trading business system.

Developed SAP interface PL/SQL scripts for the Finance Module.

Designed and implemented Y2K compliance for this system.

Cron jobs and UNIX shell scripts maintenance.

Binariang Sdn. Bhd., Malaysia (Client) Telecom Billing Consultant May 1996 to Mar 1998

Responsible for the overall billing & production support for BSCS Ver.3.03, 4.02, Order Management system (OMS - Oracle Corp. Product) for FNW product service order provisioning and processing

Configured services and designed various Rate Plans with pricing structures & discount models.

Responsible as a Team Leader to lead the team for migrating rate plans from BSCS 3.03 to 4.02.

Involved with LHS team in setting up base line set up, analyzing the table structures, data mapping.

Designed, coded the data migration scripts for data uploading using Pro*C, PL/SQL and SQL*Loader.

Implemented Centronics pre-paid billing system and maintained tariff & other reference tables.

Designed and developed ‘Malaysian Dialing Plan System’ which provides the various possible dialing destination information available in Malaysia according to its charge area using Developer 2000.

Developed script to reserve & manage special category of MSISDN numbers.

Celltech Systems (P) Ltd., INDIA. Systems Consultant (Telecom) Nov 1995 to May 1996

Developed the master maintenance module of a Cellular Billing Package (STATUSS) with GUI front-end and OPEN RDBMS at the back-end. Tested the codes to detect defects in procedures and ensure quality.

Tuticorin Social Service Society, INDIA. System Executive Mar 1993 to Sep 1995

Kamlavati Hr. Sec. School, INDIA. Instructor cum Programmer Jul 1991 to Mar 1993

Contact this candidate