We provide IT Staff Augmentation Services!

Global Technology Analyst Resume

Dallas, TX

SUMMARY

  • Dynamic and creative with strong Database, Security and Software Development skills with over 8 years of experience in defining stable, secure and scalable applications and producing robust code for high - volume companies. Eager to join your team.

TECHNICAL SKILLS

  • Programming and frameworks: COBOL, REXX, CLIST, CICS, APS, Mainframe BMS, Db2 Stored Procedures, Perl, C, C++, JAVA, C#, Clojure, Julia, Python,, Prolog, SR,ASP.Net
  • Web PHP, HTML, XML, JavaScript, Dreamweaver, Ajax, CSS, Flex, JQuery, WordPress, SVG
  • Databases Confidential Db2, SQL, Oracle, MS-Access
  • Software Packages BMC Catalog and Change Manager, BMC Main View, Confidential Info Sphere Data Replication, Apptune, Omegamon, ZOS Explorer, ISPF, Spufi, QMF, Endevor Package Creation and Job Migration, Changeman, Xpeditor, FILEAID for Db2, SAR, Quick, File Manager, RACF, CA7, ACF2, ITSM BMC Remedy- Change, Incident Ticket and Problem Management Tool, OS/390 Data Warehouse(Internal App), DB2RQRY(Internal Query Tool for RACF), ARM-Access Request Management Tool, PODS-Production Online Datacenter Scheduling Tool, Confidential Data Studio, Power Designer, Nexus- Work Request Management Tool, Juno, Jupyter, Hadoop, Git, Net Beans, Apache, ESRI MOJ20, Visual Studio, VMWare, MATLAB, Service Now, Confidential TRIOLE
 

PROFESSIONAL EXPERIENCE

Global Technology Analyst

Confidential, Dallas, TX

Responsibilities:

  • Verified SQL code with DB2 Explain for production implementation and ensured their performance by tuning them for optimal 4 Hour Rolling Average, resulting into $200000 savings
  • Served as DBA for 46 Confidential applications and designed Data Models and Implemented heavy changes for them in Production as part of Application Releases. Handled projects requiring around 400 to 600 hours of DBA work for release
  • Provided RACF and ACF2 Security Consulting to Application teams for setting their Service ids and User ids Security Profiles
  • Lead a team of 6 people in recovering critical US and UK Production Db2 tables in the event of data corruption. Fastened the recovery process by coordinating between the application and system team. Made improvements in recovery process by keeping around 24 hours of DB2 logs readily available on disk. Built post recovery documentations for the team
  • Loaded and Refreshed databases for application testing in various lower test environments. Handled 23 such concurrent application testing for major production releases. This required more than 500 hours of DBA work
  • Provided 24x7 ONCALL Support for Live Production Environment on Rotation Basis for all Db2 applications of GWIM ( Confidential ), Retail and Confidential Services for the Bank. Handled hours of Triage Calls as sole DBA representative and provided DBA level Monitoring and Support wherever required. Helped reduce the count of FCI - Failed Customer Interaction
  • Worked on few confidential Projects for the Bank. Modified some of the most critical tables for CARDS and Points application, few of which required outage window
  • Handled US Trust application for Confidential . The app required agile methodology for creation and changes to more than 200 Db2 objects and deployment of more than 300 Stored Procedures in a single PROD release
  • Attended Confidential Tech Conferences. Participated in 2018 Confidential Orlando Tech Conference in Florida. Participated in many Confidential Db2 User Group meeting at Confidential, Dallas. Attended Confidential workshop on Db2 as a REST service
  • Assisted many Confidential Intern joiners. Organized Bootcamp s for them and guided them for project presentations. Handled 3 such Summer Intern batch from 2017-2019

Technology Intern Analyst

Confidential, Dallas, TX

Responsibilities:

  • Implemented Db2 Image Copy Modernization Project for Europe and North America Confidential Apps thus automating the Image Copy Process for 2 applications during my internship period
  • Worked on Utilities for Image Copy, Data Recovery, Reorg, Runstats, Binds, Data check, Load, Unload, REXX/ISPF Panel Automation, Db2 objects creation and maintenance in DEV and SIT regions
  • Extensively used BMC Catalog Manager and BMC Mainview and Apptune for doing analysis related to ICM project
  • Performed Tablespace Analysis for backup requirements, setting up more than 60 JCLs in DEV and QA as per production standards, Testing of JCLs, GDG Creations and Staging the Image Copy Modernization jobs thru Endevor Change Manager
  • Visited Confidential ’s Data Center at Richardson location and learnt about the hardware involved behind Mainframe

Graduate Senior IT Assistant

Confidential, San Diego, CA

Responsibilities:

  • Desktop and Software Security and Admin settings, Web Programming using HTML, CSS, ASP .Net and SQL, Ticket management, Hardware-Software upgrade and configuration and Inventory and Purchase Order management

Graduate IT Assistant

Confidential, San Diego, CA

Responsibilities:

  • Incident ticket management, Hardware-Software upgrade and configuration, classroom and remote arrangements, WordPress, SumTotal and Qualtrics Web Services API interaction for Survey and LMS

Software Engineer Analyst

Confidential

Responsibilities:

  • Handled Application Design, Development and Maintenance of 12 mainframe db2 applications for a US Retail client
  • Implemented Confidential Messaging Queues architecture on Mainframes and trained 8 people in MQ, CICS, REXX and Cobol-Db2
  • Coded automated tools in REXX saving around 125 DBA team hours in a week and also supported critical Db2 and ZOS upgrades
  • Coded 22 new client applications in Cobol Db2 to help transform from a catalogue-led business to a digitally enabled business
  • Monitored critical Mainframe batch cycle and resolved production issues within SLAs for a UK retail client
  • Resolved nearly 10 incident tickets/day on Service Now and Confidential TRIOLE and also solved around 4 problem tickets per week
  • Provided release coordination for Unix and Mainframe modules by facing quarterly audits and monthly release metrics

Hire Now