| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Software Engineer Computer Science Syracuse, NY Computer Science Data Syracuse, NY System Administrator Information Security Ithaca, NY Auto Service Plan Administrator Syracuse, NY Manager, supervisor, team leader, computer skills, etc. Syracuse, NY Audio video control engineer at Audio-Video Corporation Liverpool, NY DevOps Engineer II Syracuse, NY |
|
Click here or scroll down to respond to this candidateCandidate's Name
Email:EMAIL AVAILABLEPhone:PHONE NUMBER AVAILABLEEducationComputer Science and Engineering, Computer Science, Visvesvaraya Technological University, IN, Street Address
LanguagesEnglish - FluentPublicationsIBM Elegancy Newsletter vol-2, 2010Profile16 + years of IT industry as a results-oriented Mainframe Database administrator. DB2 Objects Designer, Architect, Analyst and Developer. Excellent communication and interpersonal skills help facilitate productive interactions with clients, colleagues and superiors. Dedicated, motivated and detail-oriented with a strong commitment to consistently delivering a quality product in a timely manner and a proven track record of meeting aggressive deadlines, also Im an ITIL Certified professional, accomplished technical expert skilled in architecture modeling, developing, and managing Best Practices, Policies and Procedures for Database Development, Administration and Modernization to support Business solutions. Knowledge and understanding of Agile Methodology and tools for database migrations.Key skills Strong background in Database administration, data architect capabilities, normalization, data analyst, building database from scratch, disaster recovery `data virtualization, and support for application software using COBOL, JCL, DB2, SQL, CICS, IMS-DB, MQ, VSAM, Oracle-Siebel, Peoplesoft, SAP technologies.Key courses and trainingTrainings:* ITIL Certified Professional* IBM Certified Cloud Architect Professional* Advanced JCL* Architectural Thinking* Consulting profession by IBM.* IDAA DB2 v11* zSQLMON* CICS at IBM India* JCL, VSAM, DB2, COBOL, CICS.* Quality Trainings in IBM QPACE, Reviews and Inspection, Estimation, SCM, Defect Prevention, Metrics.* Took up DB2 DBA Administration training* DB2 Application Performance Tuning training* Configuration Management and Presentation Skills* Effective Communication in Global Environment* RTC, Agile, Geno and Geno 2.0 Process and toolsCertifications & Awards:* IBM Certified Advanced Cloud Architect* IBM Certified Architect V5* IBM Certified DB2 12 System Administrator for z/OS* Google Certified Professional Cloud Architect* Google Certified DevOps Professional* IBM Certified Database Associate - DB2 Universal Database V10 Family* IBM Certified Database Administrator of Z/OS - DB2 Universal Database V10* IBM Certified System Administrator of Z/OS - DB2 Universal Database V10* IBM Certified Database Administrator of LUW - DB2 Universal Database V10* ITIL Certification - IT management.* Microsoft Azure Certified Architect Expert* Microsoft Azure DevOps Engineer Expert.* Eminence and excellence award for the outstanding DBA work.* Part of International IDUG DB2 conferences.* Agile explorer Badge.Work experienceSenior DB2 Database AdministratorIBM, United States Mar 2024 - PresentSummary:National Grid is the largest energy companies providing New York, Rhode Island and Massachusetts with natural gas and electricity for homes and businesses. National Grid is an electricity, natural gas, and clean energy delivery company that supplies the energy for more than 20 million people through its networks in New York,Massachusetts, and Rhode Island. It is the largest distributor of natural gas in the Northeast. National Grid also operates the systems that deliver gas and electricity across Great Britain. National Grid is transforming its electricity and natural gas networks to support the 21st century digital economy with smarter, cleaner, and more resilient energy solutions.As a Senior DBA, leading the DBA team working on Mainframe DB2 DBA area, taking care of critical C2C client project from all the database perpective24x7 support along with new database design and development for the upcoming projects withing National Grid.Working as a Lead Database Administrator for C2C Project, Customer Data Platform project, Customer Service Mainframe systems migration to new Mainframe environment.C2C represents migration of data from CRIS to CSS Application. This migration enhanced the customer experience, streamlined the operations, simplified the billing process and improved meter services, all while supporting clean energy programs.Customer Record of Information System (CRIS) is used for billing 2.2 Million customers of National Grid in Downstate NY (DNY) and Massachusetts area for Gas customers. Customer Service System (CSS) is a critical business application that is used for Billing the end customers in Upstate New York (UNY).This project - CRIS To CSS (C2C) represents the consolidation of clients customer information systems to a single unified billing system. A unified customer information system will improve the customer experience while decreasing costs to serve. This includes Improved call center utilization, improved web experience for customers and provide single bill for all MA dual fuel customers.The key benefits for IBM and client with this consolidation project includes -1. Eliminates functionality development duplication2. Reduce integration complexity3. Reduced IT support costs4. Reduce operational issuesOverall I worked as system integrator for this consolidation that would help the client in improving customer experience and reduce operating costsThe Major benefits are heighted as mentioned here:* Increased resiliency & positioning for componentization* Single source of data, access, & format* Processing efficiencies, resource optimization and elimination of duplicate work- Worked on preparation of the complete plan for cloning database from productionregion.- Proactively took part in getting knowledge on NG systems during initial months and started taking more responsibilities from Support and development activities from DBA perspective, involved more on projects.- Took part in creating audit reports for the production DB2 systems on need basis and as requested from the audit teams.- Took care of DB2 production support on 24x7 basis, took care of incidents and changes on a timely manner, to meet SLA.- Worked with DB2 utilities like DSN1COPY, Re-org, Runs tats, Image Copy, Data base repairs, DSN1PRINT on production and non-production regions.- Proactively took DB2 12 upgrade activities from Application DBA perspective and worked closely with our team and with DB2 system programmers team to address risks/ issues on a timely manner, took responsibility of testing the DB2 utilities pre and post upgrade activities. Had a discussion with the team for any dependencies.Assignment historySenior DB2 Database AdministratorNational Grid U.S, India Oct 2020 - PresentProject name: National Grid Application Development and supportAs a Senior DBA, working on Mainframe DB2 DBA area, taking care of 24x7 support along with new database design and development for the upcoming projects withing National Grid.Working on Customer Data Platform project, Customer Service Mainframe systems migration to new Mainframe environment.National Grid is an energy company operating in the UK and US. It delivers electricity and gas safely, reliably and efficiently to the customers and communities it serve all while working towards a clean energy future.Contribution:As a Lead DB2 database administrator:- Worked on preparation of the complete plan for cloning database from production region.- Proactively took part in getting knowledge on NG systems during initial months and started taking more responsibilities from Support and development activities from DBA perspective, involved more on projects.- Took part in creating audit reports for the production DB2 systems on need basis and as requested from the audit teams.- Took care of DB2 production support on 24x7 basis, took care of incidents and changes on a timely manner, to meet SLA.- Worked with DB2 utilities like DSN1COPY, Re-org, Runs tats, Image Copy, Data base repairs, DSN1PRINT on production and non-production regions.- Proactively took DB2 12 upgrade activities from Application DBA perspective and worked closely with our team and with DB2 system programmers team to address risks/ issues on a timely manner, took responsibility of testing the DB2 utilities pre and post upgrade activities. Had a discussion with the team for any dependencies.- Worked on DB2 system refresh from PDAN to training, PERF, CTRN1 regions via DSN1COPY on need basis.- Involved on GBE project activities such as DB2 replication setup, discussions and setup of stored procedures.- Took DBA responsibilities part of DB2 V11 fallback maintenance testing - this was crucial, as DB2 version was already out of support, took part of testing once the maintenance applied on the DB2, to make sure all the DB2 utilities and tools working perfectly.- Took lead role in close monitoring of production databases whenever there was a STORM alert, to have smooth business operations on 24x7 basis.- Provided support for FTP from mainframe to non-mainframe systems for the requirement from client.- Suggested and supported performance-based simulation on CDB3 for complete day (like PDB1 production jobs) from DBA perspective.- Trained junior members in the project, helped them to resolve technical issuesSenior DB2 Database AdministratorUnited Parcel Services, India Feb 2020 - Oct 2020Project name: Peoplesoft to Workday MigrationAs a Senior DBA, worked on preparing the DB2 environments for the migration of Peoplesoft to workday project and I also took care of external interfaces connecting with complex architecture.Conducted regular meetings with colleague DBAs and stakeholders for the discussions about current proceedings and to discuss about blocking issues if any.Major Contributions:* Worked on preparation of the complete plan for cloning database from production region.* Took lead role as a DB2 Administrator for the estimation of storage and CPU forthe complete activities involved.* Took initiatives to automate refresh process from one region into the other, tohelp client in a better way.* Lead DBA meetings to co-ordinate about regular updates along with stakeholders in scrum calls.* Worked towards new IBM tools, methods to have improved performance/processes.* Worked with a team in agile methodology, to help client in a more efficient manner.* Extensively took part in performance testing activities across the project DB2 systems.* Make sure that UPS project database system's health checks are good always across Development and production environments.* Extensively involved in Interface testing from DB2 across project landscapes to production Systems.* Extensively took part in performance testing activities across the project DB2 systems.* Worked on buffer pool tuning tool, to identify performance improvement options in a big picture.* Regularly worked on DB2 health check activities on all production and non-production Systems across the landscapes and worked on maintenance of DB2 objects* Worked on Performance Tuning for Application program and User Queries* Extensively involved on all issues which are relevant to DB2 DBA, actively involved in the meetings and coordinated until the issue get resolved and took precautions wherever possible to avoid similar issues which will help client and business and resolved technical query from team on DB2.Senior Database AdministratorRABOBANK Netherlands, Netherlands Feb 2016 - Jan 2020Project name: RABOBANK NetherlandsRabobank Group is an international financial services provider operating on the basis of cooperative principles. Rabobank Group offers retail banking, wholesale banking, asset management, leasing and real estate services, with emphasis on providing a comprehensive package of financial services in the Netherlands. Internationally the Rabobank Group is focused on the food and agriculture sector.As a Senior DBA, worked on more challenging project where I performed Database administrator role, performed Siebel Innovation pack 2016 upgrade, successfully completed Siebel Innovation Pack 2019 upgrade. My responsibilities are to work with client requests and to perform CRM releases from DBA perspective in the project. In this role, I have also performed Lead DB2 development DBA activities and I also took care of external interfaces connecting with complex architecture.Major Contributions: As a Senior DBA, worked on more challenging project where I performed Database administrator role, performed Siebel Innovation pack 2016 upgrade, successfully completed Siebel Innovation Pack 2019 upgrade. My responsibilities are to work with client requests and to perform CRM releases from DBA perspective in the project. In this role, I have also performed Lead DB2 development DBA activities and I also took care of external interfaces connecting with complex architecture.Conducted regular meetings with colleague DBAs and stakeholders for the discussions about current proceedings and to discuss about blocking issues if any.* Worked on Siebel Innovation Pack 2016 and took complete ownership for Siebel 19 upgrade project from DBA grade activities for Rabo bank.* Took lead role as a DB2 Administrator for CRM 37, CRM 38, CRM 39, CRM 40, CRM 41, CRM 42 and 43, 44, 45, 46, 47, 48,49,50,51 SIEBEL Releases.* Took initiatives to automate CRM data fixes, to help client in a better way.* Lead DBA meetings to co-ordinate about regular updates along with stakeholders in scrum calls.* Worked towards new IBM tools, methods to have improved performance/processes.* Worked with a team in agile methodology, to help client in a more efficient manner.* Completed all the relevant trainings and won IBM think academy practitioner badge.* Provided mentoring support to the new DBA and working towards B&E DBAs to gain more Knowledge on Production work and to help clients.* Took initiative and worked towards SIEBEL Innovation Pack 2016, Siebel 19 world's largest Siebel system.* Took initiative regarding DB2 analytics accelerator (IDAA) from Development and production systems perspective.* Took care of Development and Chain Siebel systems performance across Siebel CRM Releases.* Make sure that RABO BANK project database system's health checks are good always across SIEBEL development environments.* Extensively involved in SIEBEL Innovation Pack 2016 and Siebel 19 migration from DB2 across project landscapes to production systems.* Extensively took part in performance testing activities across the project DB2 systems.* Make sure that RABO BANK project database system's health checks are good always across SIEBEL development environments.* Extensively involved in Interface testing from DB2 across project landscapes to production Systems.* Extensively took part in performance testing activities across the project DB2 systems.* Worked on buffer pool tuning tool, to identify performance improvement options in a big picture.* Regularly worked on DB2 health check activities on all production and non-production Systems across the landscapes and worked on maintenance of DB2 objects* Worked on Performance Tuning for Application program and User Queries* Extensively involved on all issues which are relevant to DB2 DBA, actively involved in the meetings and coordinated until the issue get resolved and took precautions wherever possible toavoid similar issues which will help client and business and resolved technical query from team on DB2.Database Administrator for DB2 and SAPAIG, India Jul 2013 - Jan 2016Project name: AIG Eminence and Center of ExcellenceAIG ECoE Project is Insurance based project and ECoE deals with PAYGO reporting and Reinsurance activities for the AIG Clients. My role is to handle database and table design, by using IBM DB2 Administration tool, required for AIG new development systems in accordance with process followed by IBM DB2 system, Also to maintain the production database and address any issues arising out of production, Figure out the factors that are clogging the performance of the existing application and suggest client with new solutions designs which will have finer performance using IBM DB2 Performance Expert tool. Work on Ad hoc request tickets raised daily. Involve in Coordinating and execution of DB2 system cloning activity for DB2 production systems.Major Contributions: As a Senior Database Administrator for z/OS with SAP, my responsibilities are to work on code change requests from clients and to perform any DBA request in the project. In this role, I have also performed DB2 application programmer activities I also took up peer code reviews.* Maintain Production Database system.* Monitoring Production Batch cycles and addresses the tickets raised.* Responsible for production system maintenance and monitoring for problems. Provide database administration assistanceusing IBM DB2 Omegamon tool. Effectively communicating with all the stake holders and Team lead for project updates, ongoing tasks and also closely working with the IBM System Support teams in z/OS Upgrade, Installing new DB2 versions etc.* Assist in coordinating the implementation of special DB2 Subsystem backup requests* Extracting of the Views from the source DB2 Subsystem just prior to the backup being used and then applied to the targetsystem.Database AdministratorInternational Business Machines, Europe, India Sep 2008 - Jul 2013Project name: Nordic International Leasing SystemNiLS (Nordic International Leasing System) Application manages the financing contracts of IBM Global Financing and controls the financed assets for a country's credit organization. This spans the life of each contract from inception to termination and the life of each asset from first recording to final disposition. This application is currently deployed in 17 countries and 20 instances. As a System Engineer, responsible for Analysis, design, development, testing and implementation of maintenance and enhancement requests for mainframe applications in NiLS.Major Contributions: As a Database Administrator, I was responsible for DB2 maintenance in test and production:* Deliver new and complex high-quality solutions to clients in response to varying business requirements* Any issues and errors will be resolved and thereby helping the client to overcome business bottlenecks* Ensure that development is performed as per requirements* Helped development team in tuning DB2 queries to increase performance in production system.* Responsible for effective communication between the project team and the customer.* Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results* Utilize in-depth knowledge of Technical experience in Mainframe technology to deliver solutions to customer.Additional information and Major accomplishments:I received an award from John Granger, Senior Vice President, IBM ConsultingReceived outstanding contributor award for the excellence C2C Program from National Grid.It was great to receive an award from him for the top certification holder in CIC India.Trainings Completed:* IBM GenAI and data science training.* Advanced JCL* Architectural Thinking* Consulting profession by IBM Consulting Academy* IDAA DB2 v11* zSQLMON* CICS at IBM India* JCL, VSAM, DB2, COBOL, CICS training at IBM India* Completed various Quality Trainings in IBM such as QPACE, Reviews and Inspection, Estimation, SCM, Defect Prevention, Metrics.* Took DB2 DBA Administration training at IBM India* DB2 Application Performance Tuning training at IBM India* Configuration Management and Presentation Skills at IBM India* Effective Communication in Global Environment at IBM India* RTC, Agile, Geno and Geno 2.0 Process and tools at IBM IndiaCertifications & Awards:* IBM top Certification award from John.* IBM Certified Advanced Cloud Architect* IBM Certified Architect V5* IBM Certified DB2 12 System Administrator for z/OS* Google Certified Professional Cloud Architect* Google Certified DevOps Professional* AWS Certified Cloud Practitioner* IBM Certified Database Associate - DB2 Universal Database V10 Family* IBM Certified Application Developer - DB2 Universal Database V9 Family.* IBM Certified Database Administrator of Z/OS - DB2 Universal Database V9 Family.* IBM Certified Database Administrator of Z/OS - DB2 Universal Database V10 Family.* IBM Certified System Administrator of Z/OS - DB2 Universal Database V9 Family.* IBM Certified System Administrator of Z/OS - DB2 Universal Database V10 Family.* IBM Certified Database Administrator of LUW - DB2 Universal Database V10 Family.* ITIL Certification - IT management.* Microsoft Azure Certified Architect Expert* Microsoft Azure DevOps Engineer Expert.* Eminence and excellence award for the outstanding DBA work.* Part of International DB2 conferences.* Agile explorer Badge.* DevOps Engineer badge. |
