SUMMARY:

IT Specialist AWS Certified Solutions Architect - Associate with strong background in software application development for the financial and telecommunication manufacturing industries using a variety of technologies like Informatica ETL Tool, Unix Shell Script, SAP ABAP program monitoring, Connect Direct, Autosys job scheduling tool, Tivoli Scheduling Tool, Hyperion Intelligence Explorer, Oracle, Teradata, SQL, C++ and Visual Basic.

EXPERIENCE:

Senior Software Systems Engineer

Confidential

Responsibilities:

• Coordinate the roll out of a new the new CISCO based Computer and Telephony Integration (CTI) architecture to 29 Confidential managed call centers and 39 vendor managed call centers. CTI is used to deliver audio calls and the corresponding customer data to 18,000 agent providing customer support to Confidential Wireless customers.
• Provided day to day CTI tier 2 troubleshooting of issues raised by the call center agents. Coordinate bi-weekly and sometimes weekly deployments of the CTI code.
• Workhub is a Confidential Wireless home grown application set to replace Cisco Tool Kit Desktop application due to end of life of the tool kit. Responsible for the setup of the back end configuration tables used by Workhub, setup of the Workhub agent profiles, setup of Workhub call center profiles, dial options and department transfer configuration.
• Provide onsite support for the call centers where Workhub was deployed during the pilot phase, before roll out to the rest of the call centers. Collected feedback from the agents and a list of issues encountered to work on their resolution alongside the development and QA teams.
• Member of the multi-disciplinary team that worked on the capacity planning and architecture. Deployment of the back end infrastructure with support from our IAAS (Infrastructure as a Service) Team.
• Coordinate Workhub load tests to ensure that the new infrastructure would be able to support the work load during peak traffic. Monitored the application during the mentioned load tests.
• Gather feedback from agents, put together new requirements and feature enhancements for the development team. Responsible for rolling out Workhub to the Confidential Wireless call center during phase 1. Provide tier 2 support to resolve escalated tickets or tickets that require a deeper knowledge of the workhub application. Coordinate bi-weekly and sometimes weekly deployments of the Workhub code.

Senior Software Systems Engineer

Confidential

Responsibilities:

• Provide day to day guidance for the Catalog Management team. The team in comprised of 3 employees and 5 - 9 contractors
• Interact with Vendors and act a link between them and Confidential Wireless
• Help plan and Coordinate Database Maintenances, Infrastructure Changes, Server Patching to avoid impacting the users of the CMP systems.
• Provide a clear and concise plan for the CMP team members on the activities that need to be taken during maintenance windows.
• Work with the CMP team members to provide feedback to the Development team on code improvements and bug fixes.
• Open Jira tickets to track defects.
• Participate in deployment planning meetings with the different teams: Development, Quality Assurance, Requirements and Management as well as external teams.
• Create configuration files for Map Loading of the Confidential Data Grid.
• Work alongside with the CMP team members to Deploy new code such as shell scripts, Oracle packages, properties files, XML files, preload strings, ear files using Websphere application console. Deployments could take place weekly for small improvements and bug fixes. Validate code deployments made by other team members to minimize errors and customer impacting issues.
• Provide a detailed plan and time line to follow during. Enterprise Releases. Enterprise releases are releases where there are interdependencies with other systems within Confidential wireless. These releases take place once a month and the release window could take 24 to 36 hrs.

Technologies used: UNIX/AIX Solaris, HP-UX; K-shell scripting, XML, Oracle sql.

Senior Software Systems Engineer

Confidential

Responsibilities:

• Monitor program execution for expected performance
• Batch processing of stocking feeds from various vendors
• Work with vendors troubleshooting issues experienced by the customers while purchasing the various types of items available through the various store fronts.
• Loading of the Confidential Data Grid which is a repository containing customer related information in Memory (as opposed to RDBMS on disk).
• Participate in deployment meetings
• Deploy new code such as shell scripts, Oracle packages, properties files, XML files, preload strings, ear files using Websphere application console. Deployments could take place weekly for small improvements and bug fixes.
• Deploy code during enterprise releases.

Technologies used: UNIX/AIX Solaris, HP-UX; K-shell scripting, XML, Oracle sql.

Confidential, Somerset, NJ

Level 3 Support

Responsibilities:

• Maintain and Develop shell scripts to extract and process data from SAP using Informatica into a DB2 database.
• Maintain existing jobstreams to control the execution of scripts and develop new ones using Tivoli Job Scheduling Console
• Maintain existing Informatica Workflows and Mappings.
• Provide Level 3 support to help the production and L2 teams troubleshoot problems that occurred during the daily execution the jobstreams across 3 geographies (EMEA, Asia Pacific & America’s) this could involve any of the following: Informatica workflows/mappings and/or its server, Perl Scripts, Shell Scripts, Data related issues, SAP, DB2 or Websphere middleware communication links.

Technologies used: DB2, SQL, Perl, UNIX/AIX shell scripting, Informatica ETL, SAP ABAP program monitoring.

Confidential

Responsibilities:

• Maintain and Develop new features for the validation excel macro tool that verified forecasting data to be uploaded by the users into the DB2 Confidential database.
• Help business users troubleshoot problems found while uploading forecasting data into the Confidential database. These problems could involve the excel macro mentioned above, the upload java program or data inconsistencies.
• Help the business users with report related issues. This involved back tracking data from the Hyperion Explorer report to the DB2 Confidential database.
• Help selected business users set up database connections, oce (configuration) files to access the Hyperion reports
• Perform the yearly changes to all the Hyperion bqy’s
• Every 90 days change the passwords used by the code to access DB2, UNIX/AIX & Mainframe accounts.

Technologies used: DB2, SQL, UNIX/AIX shell scripting, Hyperion Explorer, Visual Basic/Excel Macros

Confidential

Supply Chain Production Manager

Responsibilities:

• Maintain and improve the Separation of Duties ( Confidential ) Excel macro to speed up the Confidential yearly validation process. I took over the maintenance of the code behind the sheet from another developer, with the improvements of the code made by me we were able to reduce the time of the detection conflicts between the roles own by each user by about 50%.
• Assist the user community to create new ID’s to access the system. I helped answer questions from the E2Open help desk about the new ID requests submitted by the users as well as changes to the roles owned by existing ID’s
• Provide support to the user community when submitting changes to the forecast calendars in Confidential .
• Provide night and weekend production support on a rotation basis to respond to any problems related to the network links used by Confidential .
• Work with the business owners and user community to do a yearly validation of the user id’s that were no longer needed and validate that the roles owned by each user id had no conflict in terms of separation of duties.

Technologies used: UNIX/AIX shell, network and file system, Visual Basic/Excel Macro

Confidential, Murray Hill, NJ

Responsibilities:

• Develop scripts and utilities to monitor the performance of the EDW (Enterprise Data Warehouse) financial data extraction processes.
• Provide troubleshoot support on a rotation basis for the nightly extract of data for EDW. As well as code migration for system improvements.
• Worked on the implementation of Sarbanes-Oxley
• Provide production support for BSB (Billing Shipping and Backlog) system.
• As well as code migration for system improvements.
• Provide production support for the data load of inbound feeds and data manipulation processes for the OASIS system.
• Provide production support for the data load of inbound feeds and data manipulation processes for the FTS system.
• Found the source of a memory leak bug and developed a fix for it. The fix was implemented after I left the project, based on the fix I developed. After I left the project.

Technologies used: UNIX shell scripting, C++, Oracle

Confidential, Middletown, NJ

Responsibilities:

• Provide production support and minor enhancement for the systems Confidential
• Both applications had been outsourced to India but concerns regarding government data handled by them raised the need to bring them back to the use.
• I was part of the team doing that transition.
• Later on the idea came up to encrypt the data and that strategy allowed this projects to be outsource back to India.

Technologies used: UNIX shell scripting, C++, Oracle

Confidential, Warren, NJ

Teradata & Unix Developer

Responsibilities:

• Develop data extraction and data manipulation mappings using Informatica Power Center
• Develop teradata and shell scripts for data extraction, conversion and loading into the data warehouse.
• Develop Job flows for the nightly extract process using Autosys scheduler.
• Develop an application for updates to the data warehouse’s control tables Using Visual Basic, ODBC and Teradata.
• Provide documentation for all the mappings, shell scripts and procedures mentioned above.

Technologies used: UNIX shell scripting, Teradata/Oracle relational databases, Informatica, Visual Basic, ODBC, SAP, Connect DirectMarch 1999 - June 2001 Confidential Technologies Warren, NJ

Oracle & Unix Developer

Confidential

Responsibilities:

• Produce corporate financial results
• Develop financial systems migration to the latest SAP Technology
• Development of applications that allow monitoring of the performance of the Data Warehouse system
• Develop system test strategies for the LBK ( Confidential Business Knowledge system)
• Provide production support and troubleshooting during the execution of data extraction.

Technologies used: UNIX shell scripting, Oracle relational databases, Informatica, ODBC, SAP, Connect DirectJanuary 1997 - March1999 Confidential Technologies/PCC Piscataway, NJ