Engineer Data

Summary:

Over ** years of experience in Application Development, Distributed Systems Management and Data Management

Carried out many Enterprise-wide initiatives involving Systems & Infrastructure Planning, Server Migrations & Consolidations, Enterprise Application Integration and Systems Re-Engineering

Experienced in implementing VLDB Data Warehousing, Information Integration and Business Intelligence solutions

Technical Expert on System i, i5/OS Architecture, DB2 UDB for iSeries, Performance Tuning and Optimization

Played leadership role in IT Delivery Services managing Daily Operations and Data Center with responsibilities for midrange and mainframe servers

Consistently top performer and received many recognitions and awards for outstanding performance on the job.

Excellent Presentation skills with experience in training & mentoring Application Developers and System Engineers

US Citizen

Core Competencies

High Availability & Business Continuity

Data Warehousing & Business Intelligence

Application Development

Performance Tuning & Query Optimization

Data Center & Operations Management

Skills & Tools:

RDBMS: DB2 UDB for iSeries

Languages/Platforms: SQL, RPG, RPGIV, Free-Form RPG, CL, CLLE, Java, WebSphere, COBOL

Performance Tracing: iDoctor JobWatcher & PEXAnalyzer, insure/SQL, Database Monitor

High Availability: Vision Solutions – OMS/400 & ODS/400

Middleware: WebSphere MQ (MQ Series)

Operating Systems: V5R3, V5R4 i5/OS, OS/400, Windows

Change Management: Turnover

Cross Reference Tool: Hawkeye

Certifications & Achievements:

2008-09 - Outstanding Performer Award and Rose Award Nominee

2007 - Countrywide’s FASTER Silver Certified and team member on FASTER Gold Project

2006 - Served on Enterprise Architecture and DBA committees at Countrywide Home Loans

2004-05 - Member of Countrywide Financial Data Management Advisory Board

2000 - IBM Certified Specialist – AS/400 RPGIV Developer

Education:

Masters in Computer Applications from Nagarjuna University, India

Experience:

Countrywide Home Loans/Bank of America, Plano, TX

May 1998 – Mar 2019

Roles:

As a Technical Architect, lead complex projects, improve performance and availability of Systems and Applications, collaborate with other Architects in the enterprise to develop best practices and establish methodologies.

As Operations Architect, ensure smooth functioning of Computer Operations and lead the Systems Engineers and Developers on complex enterprise-wide projects, develop technology roadmaps, design solutions and plan HA infrastructure and establish IT vision for both Operations as well as IT Delivery Services.

As a Sr. Software Technical Specialist, lead various application development projects for Web Solutions Center Customer Contact Systems.

As a Change Management Engineer, taught Turnover to various teams within the company and played a critical role in establishing change management procedures for SQL applications and Java applications.

As a Security Engineer, involved in creating user menus and created the auditing process.

Responsibilities & Accomplishments:

-Developed source scanners and automated programming modification tools using table based input that have reduced cost and development effort tremendously in several projects.

-Improved Operating efficiencies by bridging gaps in the processes & developing Standard Operating Procedures

-Develop Best Practices, Mentor, Train, Direct and Supervise Systems Administrators and Operators and help them reach their Job Objectives

-Assist MIS Architecture team in Information Integration and Data Warehousing efforts

-Improved Security and Systems Integrity via better Change Management in QA and Production environments

-Developed Loan History Information System, a Data Warehouse project implementing snowflake schema that was chartered to provide a more flexible & accessible research environment for the Loan Servicing division.

-Worked with Data Analysts and Data Architects to create a Meta Data Repository and Operational Data Store

-Optimized database & query performance on several production systems and achieved significant improvements

-Benchmarked query run times on CQE & SQE to prepare the applications and queries for V5R2 & V5R3 upgrades

-Served on various technical boards and forums as a Subject Matter Expert for iSeries and Database technologies

-Developed statistical analysis models and database activity metrics and deployed them onto Database and System Performance Dashboards for the executive management

-Created and Presented White Papers, Benchmark reports and other technology topics as Brown bag sessions

-Evangelized SOA within the organization and Developed numerous reusable components and services for the Enterprise Asset Repository

-Designed and developed a website for automating end-user signoff process without which users have to approve in mail and Turnover team need to keep track of these mails. This website was developed using J2EE and WebSphere technology and used internally in Countrywide.

-Designed and Architected the entire middle and backend tiers for https://customers.countrywide.com, https://business.countrywide.com and the biz partner website for Portfolio Services group

-Developed an innovative “Store & Forward” framework that is based on queuing mechanism implemented via data files, user spaces, and message queues for 24X7 application availability for online customers

-Developed an API for Loss Mitigation application so other Loan Administration systems could interface with it

-Converted or Transformed many of the legacy applications into browser based systems available via intranet

-Worked on various Y2K Conversion projects for Countrywide Home Loans

-Consolidated various disparate applications and screens into one “Home base” to facilitate rapid and efficient call processing by the Customer Service representatives

-Early adopter of Integrated Language Environment on iSeries (AS/400) and mentored many developers on ILE

-Mentored and trained many students on AS/400 concepts, RPG and CL/400 at Indus Campus in Torrance, CA

-Developed Multimedia rich Computer Based Training modules for elementary school students under the guidance of APTS (A Govt. of Andhra Pradesh sponsored organization)

-Created numerous multimedia presentations for various organizations and training institutes in India

Environment:

AS400 at V3R7 thru V4R5, iSeries at V4R5 and V5R1, RPG/400, RPGIV, COBOL, ILE, CL, SQL, XML, MQ Series, Java

Contact this candidate