SUMMARY:

• Twenty five plus years of experience in project management, financial/ economic analysis, data warehousing, enterprise architecture, statistical analysis/forecasting, and systems analysis. Strength lies in strong analytical skills, business intelligence, data warehouse/big data related etl, machine learning/statistical analysis, and predictive model development.

TECHNICAL SKILLS:

RDBMS: Oracle 10g, 11g, 12c, DB/2, Sybase

Other Software: PL/SQL, C, SAS (up to Version 9.3), MS Office

Operating Systems: UNIX, Windows, IBM MVS, Z/OS

PROFESSIONAL EXPERIENCE:

Senior Economist

Confidential

Responsibilities:

• Currently, working as a senior economist at the Credit Research Analytics and Modeling (CRAM) group on a project to develop a web service to provide the data and adjustment discrepancy messages on a real - time basis to lenders on appraisal submissions. The development of web service is to provide feedback to lenders at submission time if the appraisals are of a suspect quality and to reduce the likelihood of potential put-back of delivered loans to lenders. Also, developed and implemented several ETL processes to extract source data to feed into Collateral Underwriter proprietary model for appraisal fraud detection.
• The model detects for data, adjustment and comparable selection discrepancies using machine learning algorithms. These discrepancies are used for detecting and targeting appraisal fraud. Use of machine learning algorithm using SAS Enterprise miner and statistical procedures from SAS/STAT were required to find suitable models.
• Earlier, I was responsible for developing/implementing two End-User-Computing (EUC) applications for Collateral Data System. While in this position, also developed reports for use by the lenders to provide them feedback as to the quality of appraisals submitted. Revised and productionalized the loan matching algorithm to match loan delivery data to the appraisals. Another algorithm based on a fuzzy match between appraisals and the appraiser ids was also developed. Supported predictive analytics model development using PD, LGD analysis to support credit research.

Senior Developer and Tech. Lead

Confidential

Responsibilities:

• Worked as a project manager and technical lead for the CERRTS (Credit Enhancement Research and Report Tracking System) enhancement / standardization project. The project enabled transition of the application to Production Support group, thereby, supporting segregation of duties between development and production support roles. This also enabled implementation of proper access controls for developer and production support team so that non-public information is properly protected from any unintended exposure.
• Worked as a technical lead in development of the datawarehouse and reporting system for prepayment modelers and economists. The job entailed full lifecycle development using Clearcase/Clearquest for Version control, Unix/Oracle/SQL and SAS for development. Autosys for production control and remedy for production support management. This assignment needed extensive interfacing with portfolio finance business users.

President

Confidential

Responsibilities:

• Worked as president and founder of Confidential . Responsible for financial management and marketing of services. Managed the Confidential schedule and other subcontracts at the company. Also responsible for planning, cash flow analysis and financial-statement preparation. In addition to these office duties, managed and supported the projects in following areas for various clients:

Cost/Benefit Analysis and Business Case Development

Confidential, Lanham, MD

Responsibilities:

• Updated the baseline business case for PRIME’s CADE project. The activities include budget formulation and re-validating the costs and benefits for the project over the project’s current expected lifecycle. The revisions were needed because of cost/schedule changes. Assisted in the development of OMB Exhibit 300 for CADE in conformance with OMB Circular A-11 to satisfy the Clinger-Cohen Act and to increase the OMB’s score assigned to E-300 for continued funding approval. Major areas of emphasis are to improve the Security and Privacy sections of the exhibit to show conformance with Confidential and OMB Circular A-130. Developed/reviewed architecture sections of project’s OMB-300. The conformance of OMB-300 documents with Federal Enterprise Architecture Framework (FEAF) and Technology Model (TRM), Services Model (SRM) and Data Model (DRM) was analyzed and changes incorporated.
• Reviewed requirements in Rational Rose, UML Object Oriented techniques. Developed business case evaluating the costs/benefits of Customer Account Data Engine (CADE) Confidential modernization project. Investigated Business Process Re-engineering achieved by the project. Estimated resource needs and costs using COCOMO and Estimacs parametric models. Involved in a Function point analysis to estimate the project’s future resource needs. Project’s disaster recovery, security plans were studied to quantify the full lifecycle costs and benefits of the project. Quantified and studied the Business Rules implementation approach to processing tax returns.

Confidential, Gaithersburg, MD

Responsibilities:

• Reviewed proposals submitted by various research organizations for approval of funding under Advanced Technology Program at Confidential . The proposals were reviewed on technical as well as economic evaluation criteria.

Confidential, Arlington, VA

Responsibilities:

• Updated the Business Case for e-Travel initiative of Confidential . The initiative provides an online booking and voucher processing system for Federal travel. The costs and benefits for the project were estimated and various approaches to implement the initiative were evaluated. The Business Case was developed to be in accordance with the OMB Circular A-11 and other OMB 300 requirements. The Architecture sections of the OMB-300 were reviewed for enhancement/improvement.

Confidential, Washington, DC

Responsibilities:

• Supported World Bank in its pre-appraisal mission to Islamabad for the Tax Reform Project of Pakistan. Reviewed plans for IT investments and provided Aide Memoire comments to the Central Board of Revenue, Pakistan.

Confidential, Phoenix, AZ

Responsibilities:

• Supported Confidential in its development of Technical Feasibility Study for Information System Outsourcing Initiative for the Bureau of Internal Revenue, Philippines. Assisted in developing Mid-term Report and business case for going ahead with outsourcing the data-entry, helpdesk and hardware provisioning functions.
• Worked on a US TDA mission to help Kenya Revenue Authority (KRA) with feasibility of computerization and procurement of an Integrated Tax System to address processing needs of KRA. Various E-filing options and their impacts on need for network bandwidth and taxpayers’ IT literacy were studied to recommend on an e-filing implementation suitable in Kenyan context.

Confidential, Reston, VA

Responsibilities:

• Developed a Convenience Food Substitution Model for the Department of Navy, US Army Aviation and Troop Command, Natick, MA under a subcontract from Confidential, Reston. The model was Foxpro based and was used to analyze the costs/benefits of substituting Convenience Foods in Navy menus. The project included optimization modeling of Navy Menu Planning process onboard a ship. The data driving the model were raw food ingredients and equipment needed for various navy recipes. The database and the front-end modeling tool provided can be used to analyze navy menus and identify cost-savings by ingredient substitutions.

Confidential, Mclean, VA

Responsibilities:

• Developed programs for analyzing seasonality and holiday calling patterns in telephone call traffic. Also developed a reporting system from which geographically distributed users could request several different types of reports from legacy data sources. The data sources were on mainframe and a user-friendly interface based on SAS and Powerbuilder software was provide to the users for getting summarized or detailed reports. Also developed ad-hoc reports to analyzing billing issues and billing credits as needed. Data accessed was stored in MS SQL.

Confidential, Washington, DC

Responsibilities:

• As a team member of the Data Warehousing group at Confidential, provided technical and project management support to the Portfolio Analytics and Financial Management Information Systems group. Responsibilities include analyzing business rules, developing data warehouse load programs from various source systems, and analyzing inconsistencies across various database platforms. Developing and maintaining data marts, producing ad hoc analytical reports using Oracle (SQL and PL/SQL) and SAS. The data warehouse is implemented in Oracle on DEC Alpha machine running Unix. The source systems are a combination of mainframe, Sybase client server operational system and outside vendor systems. Extensive use of SAS/SQL and Unix/JCL is required. Consulted with the client to identify the business and technical requirements of the user group (financial modelers and statisticians) and conducted detailed business analysis of business rules and processes, which was incorporated into the design of the database. Created data models, ERDs, and requirements documents.

Confidential, Baltimore, MD

Responsibilities:

• Developed conversion programs to load data from source systems on mainframe DB/2 platform to Oracle datawarehouse. Using ETI Extract tool set, which runs on UNIX platform and generates code in either COBOL or PL/SQL, developed the conversion programs. The generated programs were tested and implemented. Developed several SAS based adhoc query programs to analyze the direct mail data put in the warehouse. The data warehouse was used to better target the direct mailings of the company. By better targeting the direct mail literature Confidential expected to achieve substantial cost reductions. Also developed test plan/programs to test the validity of data in the data warehouse. The programs were written in SAS and compared the source systems and warehouse data items. The test results were presented to the users as part of the User Acceptance Testing.

Confidential, Arlington, VA

Responsibilities:

• As part of the Sabre systems group’s team, developed requirements to migrate Confidential payroll systems from legacy IBM IMS/COBOL database to Peoplesoft/Oracle based system. Analyzed the business rules imbedded in the legacy programs. Confidential payroll system is quite different than a cookie-cutter organization’s payroll system as an airline has several different pay groups (pilots, flight attendants, mechanics and other managerial staff). Modified and tested existing payroll system programs for conversion related to migration of the software from Confidential ’s computer system to Sabre’s computer system.

Senior Associate

Confidential

Responsibilities:

• Duties included developing optimization models of electric power systems operations. Developed models for simulating the hour-by-hour minimum cost operation of a utility's power plants. These tasks involved stochastic and probabilistic modeling for system-wide reliability assessments. Electric utility load forecasting models using econometric relationships were also developed. Use of SAS, FORTRAN, Clipper and C was required to perform these duties. Supported testimony write-ups and depositions in utility rate cases and other proceedings.

Senior Operations Research Analyst

Confidential

Responsibilities:

• Designed Inter-PADD Movement System. The system was designed to present inter-padd petroleum movement data at various levels of aggregation (national, regional and state, etc.). Studied the least-cost flows of petroleum from the Strategic Petroleum Reserves to refineries in emergencies. Used a network flow model (NETFLO) and developed front-end and back-end interfaces to this model.
• Developed a SAS based interface program for running electric utility planning and forecasting models. Estimated econometric relationships to forecast cost of capital for electric utilities. Developed statistical relationships for estimating maintenance expenses for power plants based on type, age, vintage and capacity factor of power plants.

Adjunct Assistant Professor

Confidential

Responsibilities:

• Concurrent with the above position worked as part-time adjunct faculty for the Confidential . The course taught surveyed various languages, their strengths and weaknesses for various applications. The languages reviewed included, C, Pascal, Smalltalk, Prolog and LISP.

Senior Analyst

Confidential

Responsibilities:

• Developed electric utility financial models for the Energy Information Administration clients. Helped in the development of various energy policy analysis models for the Department of Energy. Analyzed financial impacts of electric utility regulation. Wrote a financial report writer for electric utility financial analysis.

Research Assistant

Confidential

Responsibilities:

• Computer and mathematical modeling of the capacity expansion decision of power companies. An algorithm to solve electric utility capacity expansion problem to minimize costs was developed. Published papers on least-cost generation planning and mathematical programming techniques.