Lead Associate (Senior IT Program / Project Manager)
Booz Allen Hamilton
Total years of experience :25 years, 9 Months
• Provided leadership and oversaw several key system implementations at the Pension Benefit Guaranty Corporation (PBGC), including the implementation of a Pension Plan Genealogy system that allowed the client to accurately determine the status of multiple pension plans covered by the PBGC. The system was the first to provide PBGC an accurate picture of plans covered by PBGC, and garnered praise from business leaders and the CFO ($4.5 million).
• Successfully led the implementation of a key system (Suspense Processing and Validations) that allowed the PBGC to significantly reduce the manual processing of suspended plans and resulted in savings of over a million dollars in labor costs. Responsibilities included determining project and system requirements, defining project scope, managing project resources and assigning project tasks, managing project risks, providing direction on assignments and priorities to the project team, and meeting with clients and senior management to discuss issues and present solutions ($2 million).
• Managed a team of multiple technical analysts, enterprise architects and business analysts to perform a technical assessment of the Premium and Practitioner System (PPS) at the PBGC. This system comprises of Oracle Financials and other COTs products. Task involved coordinating and leading brainstorming approaches to perform a technical review of PPS, establishing project schedule and key milestones, and forging relationships with key PPS stakeholders. The analysis helped PBGC identify key risk areas in moving forward with the PPS implementation, and provided a realistic LOE for planning a complete implementation ($500, 000).
• Led a data center migration project that involved consolidating 7 data centers into 2 data centers. This involved coordinating tasks with several teams across the country, understanding the unique needs of each system to be migrated, developing project timelines and escalating issues. Planned and successfully executed the migration in a manner to minimize interruption to business operations.
• Led a team of offshore DBAs/developers responsible for administering the Atlas system. Responsibilities included training the DBAs to manage the applications independently, planning tasks to capitalize upon the time difference between the two countries, assigning tasks efficiently, and providing guidance.
• Successfully led the implementation of two critical COTS products that enabled Sprint to better manage integration between multiple disparate mission critical systems, reducing the impact of system downtime and eliminating costly error-fixing.
• Performed database performance analysis, capacity and growth planning, system sizing and ongoing maintenance/tuning to ensure optimal performance. Implemented database security to meet SOX/regulatory requirements.
• Analyzed infrastructure needs and proposed purchase of hardware to meet system requirements.
• Created and implemented Continuity of Operations (COOP) plans for multiple mission-critical systems.
• Led a team of developers to implement a PL/SQL interface to send and receive data from external provider of medical terminology dictionary (MedDRA). Project involved creating logical and physical data models; designing and developing procedures to send and receive data using FTP.
• Developed ETL (Extract, Transform & Load) procedures to load data from source systems to an Operational Data Store (ODS) and a data warehouse, using PL/SQL, Java, and XML.
• Tuned several SQL queries and PL/SQL procedures using tools such as TKPROF, trace files and Explain Plans to reduce response time from several hours to a few minutes.
• Mentored application developers on design of high performance and highly scalable applications using efficient data models and transactions.
Worked on designing B2B PL/SQL interfaces and tables/views on Oracle databases in OLTP and OLAP environments, using stored procedures, functions, collections and triggers. Technologies used include PL/SQL, SQL, Perl, Korn Shell, XML, C and Java.
• Implemented XML standards for B2B data exchange using XDK and Oracle’s XML APIs.
• Created multiple PL/SQL interfaces using industry-specific EDI standards, e.g. X12, 1003, and 1008.
• Implemented new features such as External Tables as part of Oracle 9i upgrade project.
• Mentored junior team members and shared technical knowledge with peers.
Member of Radian’s Environmental, Health & Safety application development and consulting team. Primary responsibilities included creating, customizing and maintaining forms and reports using Oracle Forms and Reports, creating PL/SQL procedures and triggers, analyzing and documenting business requirements, and modeling business data.
Developed several migration and conversion scripts to migrate data from disparate systems into Oracle databases.
Applied Oracle software patches and upgraded several forms and reports.
Attended User Group Meetings and conducted technical presentations and interviews.
Completed my Masters in Business Administration (MBA) with a major in Management Information Systems (MIS).
Completed my Bachelor's of Science (BS) with a major in Information Systems Management.