Summary
Overview
Work History
Education
Skills
Timeline
Generic

Prasad Subbella

Hyderabad,Telangana

Summary

Over 20+ years of experience in the field of application software analysis, design and development including testing, implementation, Deployment, support and user training for proposed systems. Proven Leadership abilities, demonstrating skill in spearheading project initiatives, creating and implementing both change and release management policies and procedures, while providing the highest quality of design, development, implementation, support, and maintenance. Exceptional Communication skills with intuitive approaches to customer relationship management, team building, and business needs consulting; actively support training and mentoring of junior professionals Excellent program, project management skills – ability to track progress versus defined plan; identify and mitigate release-level risks; facilitate resolution of issues/conflicts; validate status Conduct Release Readiness reviews, Milestone Reviews, and Business Go/No-Go reviews. Technical aptitude and strong problem-solving skills – ability to quickly identify, triage and facilitate remediate of release-level conflicts/issues Collaborate with business stakeholders, subject-matter experts, and technical teams to define organizational data management, storage, and retrieval requirements. Design database solutions to meet business accessibility and usage needs; enable 24 / 7 on-call production support for application restoration. Utilize proven project management and software development life cycle skills to play key role in implementation of new applications, business processes, and hardware supporting new products and services. Expertise in Design, document data content, relationships, structure and flow, processes that manage, transform data, business rules that govern data and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data Experience includes defining Data Architecture for Global Equipment Management Project (GEM) and Data Modelling. Extensively worked on database design and developed SQL, PL/SQL programs. Written many SQL and UNIX shell scripts to handle different database jobs and batch process requirements. Involved in application tuning using optimizer hints and database indexes to enhance system performance. Work experience includes Applications development using Oracle 8/8i/9i/10g/11g databases on Windows 2000 / UNIX (Sun OS) platforms. Developed scripts to execute the process of ETL for the data migration from the existing source to the designated target system in Foxtel Data migration Project. Adept in working on different SDLC models – waterfall, iterative and Agile.

Overview

2025
2025
years of professional experience
2004
2004
years of post-secondary education

Work History

Sr. Delivery Manager

Matilda Cloud
1 2020 - Current
  • Matilda Optimize is a powerful cloud optimization tool that helps companies optimize and improve their cloud operations
  • It provides deep analysis of application profiles, cloud asset recommendations, and application modernization recommendations, all while aligning with the well architected frameworks of major cloud providers
  • Create a comprehensive project plan that outlines the project scope, timeline, budget, and resources required
  • Leads a team comprising 40 or more members
  • Manages the coordination and productivity of this sizable team effectively
  • Organizing Project Team, assign tasks, and ensure that everyone understands their roles and responsibilities
  • Monitor the project's progress, identify risks and issues, and take corrective action as necessary to keep the project on track
  • Responsible for ensuring that the project meets the desired quality standards and that all deliverables meet the client's requirements
  • Communicate regularly with stakeholders, including clients, team members, and management, to keep them informed of the project's progress and any issues that arise
  • Identifying potential risks and developing strategies to mitigate them
  • Managing project changes and scope creep to ensure the project stays on track and within budget
  • Prepare project status reports by collecting, analyzing, and summarizing information and trends
  • Monitor the performance of project team members, providing and documenting performance feedback
  • Coordinate recruitment or selection of project personnel
  • Responsible for developing and managing the project budget, ensuring that costs are kept within the allocated budget
  • Identify, review, or select vendors or consultants to meet project needs

Technology Manager

BNSF Railways
10.2013 - 12.2019
  • The project aims to implement Master Data Management solution for Managing data at BNSF
  • There are multiple source systems which maintain their own databases which is the cause for inconsistent data of the customer
  • To achieve accurate and consistent data BNSF has aimed at implementing the Master Data Management solution to have a unique consistent details of the customers they have
  • Initial data load to MDM from existing source systems has to be performed by integrating with power centre ETL to handle data extract, transform and load
  • Development of services to perform Create, Read, Update and Delete operations on MDM
  • Development of Informatica Data Director application to perform Data governance activities like search, insert, update, and delete using work flow capabilities
  • Configuring message trigger when data changes in hub store
  • The project will be rolled out in phases, the first of which was a POC delivered successfully in Jan followed by other milestones in Agile methodology
  • Responsible for Team Management, Resource Planning (till Post Implementation Phase), Assigning the work to subordinates, involved in Preparation/Reviews of all Strategy document and Run sheet for Implementation
  • Managed in resolving tickets raised in Post Implementation Phase
  • Involved in Requirement Analysis, Data Mapping, Design, Coding(Performance Tuning of Scripts), Testing, Test Specification Preparation, Reviews, Execution (System Testing/ Dry Runs 1,2,3,4/Trial Run/Implementation), Reporting Bugs- tracking them to closure(using Track record tool) and Final delivery of bug free product
  • Responsible for communicating with the Offshore team and client, on a regular basis regarding queries in the work requests and updates on work status/status Call from Design Phase
  • Involved in Project Management / Quality related activities, trained/ mentored team members
  • Data modeling for various entities in Informatica MDM HUB and Price Translator applications
  • Provide proactive ideas and the solution approach to the client to make the application perform better
  • Perform performance optimizations on Services
  • Work with cross work streams, and determining solution design impacting the core frameworks and components
  • Design and development of Hub, Soap based Web services, Informatica Data Director (IDD) application according to High level design document
  • Provide proactive ideas and the solution approach to the client to make the application perform better
  • Perform performance optimizations on Services
  • Worked closely with Business Users to understand the MDM and IDD requirements
  • Worked closely with Informatica support and developed several custom solutions for scenarios that are not addressable by Out-Of-The-Box features of the Informatica MDM tool
  • Environment: AIX, Informatica MDM 9.7, DB2, Java and Unix

Technology Manager

Nordstrom
01.2012 - 10.2013
  • Currently all the preferences are calculated in CKW Data warehouse and fed back to MDM and other downstream consuming systems
  • This processing is all done in batch mode and there is a maximum latency of 48 hrs
  • For a customer’s preference to be calculated and made available to required applications
  • Customer Preference Platform is envisioned keeping in mind the need for a flexible and extendable platform for managing customer preferences in near real-time and also with an objective to support a personalized customer experience by providing highly available, complete and timely customer preference data to support communication growth strategy
  • Collaborate with business stakeholders, subject-matter experts, and technical teams to define organizational data management, storage, and retrieval requirements
  • Design database solutions to meet business accessibility and usage needs
  • Actively conducted triage meetings to analyze test results, identify and track the issues reported in Quality center and work with development staff to isolate and resolve issues
  • Prepared detailed work breakdown structures and installed shared accountability for achieving project milestones
  • Resolved numerous project issues including staffing shortages, tactical matters, scope creep and divergent business and user needs
  • Maintains the release schedule for all core services and ensure alignment across key partners and vendors
  • Continually work towards making improvements in the release process
  • Lead and co-ordinate the Go-Live activities including the execution of the deployment Plans and checklists
  • Involved in implementing the Land Process of loading the customer data Set into Informatica MDM Hub using ETL tool that was coming from various source systems
  • Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups
  • Worked on data cleansing and standardization using the cleanse functions in Informatica MDM
  • Environment: AIX, Informatica MDM, ORACLE 11g, PL/SQL, Web Services

Technology Architect

NOL
09.2010 - 01.2012
  • Global Equipment Management Project is a Legacy Transformation of client’s mainframe application to a web based application with enhanced feature and more accessibility to end users and customers
  • Created high level DB design, GEM Data architecture documents
  • Helped Data Migration team in creating data models, data migration scripts
  • Created Strategy and developed programs for GEM OLTP to EDW Data flow
  • Helped teams in oracle query tuning
  • Designed Strategy for Data Archival and Purging process
  • Worked with DBA Team in developing automated scripts for Database monitoring scripts and health check-up scripts
  • Environment: AIX, JAVA, ORACLE 11g, PL/SQL

Team Lead

The Nielsen Co. (US) Inc
06.2008 - 08.2010
  • Company Overview: The Nielsen Company provides market research, information, analysis and insights to the consumer products and service industries
  • The Nielsen Co
  • Currently uses the Retail Systems, which is a collection of data proprietary systems and applications that provides internal end-users and external clients with access to The Nielsen Company’s information services
  • These systems include the necessary visual layers to view and analyze marketing and sales information
  • Nielsen has embarked on a major corporate initiative to improve the services on IT Development and IT Support
  • Deployed DIPE (Desktop i-sights Production Engine) Application in APAC and LATAM Countries
  • Coordinated with users for testing the application
  • Trained users on DIPE Application
  • Go live preparation co-ordination with business users
  • Worked on Oracle Migration Activities undergoing in Nielsen
  • The Nielsen Company provides market research, information, analysis and insights to the consumer products and service industries
  • Environment: Windows XP, Windows 2003, SQL Server, ASP.NET, Oracle 10g, PL/SQL

Software Engineer

FOXTEL
05.2007 - 05.2008
  • Company Overview: FOXTEL is Australia’s most popular Television Subscription Service Provider
  • This ViVA Data Migration project was to migrate the dynamic billing and customer data identified for migration from Wizard Source Billing System to Kenan FX 2.0 Target Billing System & Conexon Provisioning System
  • Three main stages of Data Migration involving: Data Extraction from legacy system, which is Wizard
  • Data Transformation in staging system
  • Data Loading from staging into the target system, which is Kenan
  • As well, Reconciliation at every ETL stage
  • Understanding the requirements and functionality of data to be migrated
  • Developed mapping documents to map the various entities of the Wizard system (source) to the Kenan system (Target) as per business
  • Developed scripts to execute the process of ETL for the data migration from the existing source to the designated target system
  • Co-ordinated development activities at the offshore with onsite team and client
  • Provided 24
  • 7 support during implementation in delivering adhoc reports and results, and excellent post-implementation support as well for over a month period
  • FOXTEL is Australia’s most popular Television Subscription Service Provider
  • Environment: Unix - Sun Solaris 5.8, Oracle-SQL, PL/SQL, Unix - Sun Solaris 5.8, Oracle 10g, SQL
  • TOAD, SQL
  • Developer, SQL
  • Loader

Software Engineer

AGILENT Technologies
05.2004 - 04.2007
  • Company Overview: Agilent Technologies is on the leading edge of nearly every major trend in communications and life sciences
  • With the Go-Live of TC application, 10 Legacy applications become obsolete, how ever, still there was need to retain the data for future audit purposes
  • There were lot of challenges as the applications were home-grown within Agilent and were running on obsolete/Unsupported software and Hardware
  • I worked on this project End to End Accountability in converting all the MPE databases from Turbo Image to Oracle 9i and also involved in upgrading Oracle Databases from Oracle 8 to oracle 9i
  • Migrated MPE Databases data from Turbo Image Database to Oracle 9i
  • Involved in upgrading Oracle Databases from Oracle 8 to Oracle 9i
  • Coordinated with Agilent Management, Hosting Team and Database Team in finalizing the requirements
  • Agilent Technologies is on the leading edge of nearly every major trend in communications and life sciences
  • Environment: Unix, Oracle-SQL, PL/SQL, Unix - Sun Solaris 5.8, Oracle 9i, PL/SQL Developer, Brio

Education

Bachelors of Technology - Computer Science

B.V.C.Engg College

Post Graduate Program - Artifical Intelligence and Machine Learning

University of Texas at Austin

Skills

  • Windows

  • Linux

  • Oracle-SQL

  • Oracle-PL/SQL

  • Shell Scripts

  • C

  • C

  • Java

  • Oracle 8i

  • Oracle 9i

  • Oracle 10g

  • Oracle 11g

  • Oracle 12c

  • DB2

  • SQL Server

  • MS Access

  • Data Modeling

  • Data Migration

  • Data Profiling

  • SQL

  • ToadSQL

  • DeveloperPL/SQL DeveloperSQL

  • PlusMS-VSSInformatica MDMInformatica Power CenterIBM PIMMS ProjectMS SharePointVersion OneKenan/Arbor

Timeline

Technology Manager

BNSF Railways
10.2013 - 12.2019

Technology Manager

Nordstrom
01.2012 - 10.2013

Technology Architect

NOL
09.2010 - 01.2012

Team Lead

The Nielsen Co. (US) Inc
06.2008 - 08.2010

Software Engineer

FOXTEL
05.2007 - 05.2008

Software Engineer

AGILENT Technologies
05.2004 - 04.2007

Post Graduate Program - Artifical Intelligence and Machine Learning

University of Texas at Austin

Sr. Delivery Manager

Matilda Cloud
1 2020 - Current

Bachelors of Technology - Computer Science

B.V.C.Engg College

Similar Profiles

CREATE PROFILE
Prasad Subbella