Ranga Naras, Ph.D.

**** ***** ***** *****, *********, VA 20151

703-***-**** (Residence) 703-***-**** (Cell)

acbjxg@r.postjobfree.com U.S.Citizen

Primary Skills

Requirement

Analysis

System Analysis

Software

Development and

Methodology

Business Rules

Analysis

Project

Management

Feasibility Studies

Database System

Architecture and

Design

Data Modeling

Business process

Modeling

Cost Benefit

Analysis

Statistical Data

Analysis

Techniques

Unified Modeling

Language (UML)

Entity-Relationship

(ER) Modeling

“Agile” techniques

(e.g. Scrum)

Analysis/Design

Tools

Requisite Pro

Visio

DB Artisan

ER Studio

Microsoft Project

ILOG Rules

DROOLS Rules

ARIS

Database Platforms

Sybase SQL

Server

Oracle

Netezza

DB2

Languages

Java

C / PL1

Fortran/COBOL

SAS

SPSS

SQL XML

Summary

Over 20 years of experience in the Information Technology

industry. He has performed the roles of Project Manager, Lead

Business Systems/Process Analyst, and Technical Architect. He

has executed, managed and delivered several projects and has vast

experience in Software Processes and Procedures (ISO 9001 and

SEI CMM). He has good analytical, communication and

interpersonal skills. He has good ability to work under pressure.

His experience spans planning, managing, and reviewing full life

cycle Federal Program Management Office (PMO) initiatives,

technology and system modernization and transition programs; IT

Architecture (ITA) and Enterprise Architecture (EA) planning and

management; Federal IT Privacy and Security Life-Cycle

Management, Internet, Intranet, Extranet, Web, and Electronic

Commerce technologies; and digitization projects.

He has also worked in reputed international organizations in U.S.,

Canada, and India and covers requirement specifications gathering

and analysis (including use cases, process flows and process

models) through extensive interaction with stakeholders,

application architecture and system design specifications,

graphical user interface specifications (control-wise / event-wise

actions and validations), external interface specifications (data

mapping and transformation), process diagrams, dataflow

diagrams, activity diagrams, object diagrams, entity relationship

models and decision tables, business system analysis and design,

data mapping, data conversion, customized business applications

development, data representation, SAS & ETL tools, Reporting

(Financial & other), data warehouse, Re-Engineering, Fit GAP

Analysis, Project Management – full SDLC, project execution,

management and coordination including Offshore Development,

QA planning and test coordination - ISO-9001; SEI Capability

Maturity Model (Levels 4 and 5), cost effective and timely

delivery of quality deliverables, information strategy planning,

rapid prototyping and iterative approach, and user interaction,

mentoring, training & liaison.

Education

• Ph.D. (Management Science)), Queen’s University, Canada.

• MEng (Computer Science), National Institute of Technology,

Tiruchi, India.

• MBA, Indian Institute of Management, Bangalore.

• BEng (Honors), National Institute of Technology, Tiruchi, India.

Finished at or near top of the class in all the above programs

Awards and Certification

• NIAID CIO award for excellence in performance:

o Enterprise Performance Life Cycle implementation, and

o Clinical and Medical Informatics Program implementation

• Certified PMP Professional

PROFESSIONAL EXPERIENCE

Consultant (7Delta Inc.) supporting PMO at the Department of Veterans Affairs 05/2013-

Present

• Support core PMO services including project portfolio planning and management, project

planning and scheduling activities with PMs and other project Stakeholders for the Human

Resource Line of Business (HR LOB), Human Resource Information System Shared

Services Center (HRIS SSC).

• Facilitate Integrated Project Team discussions and meetings aimed at effective management

of projects to ensure that they are aligned to organizational goals and priorities.

• Monitor project progress to resolve issues, risks, and action items with respect to the

following Integrated Project Teams: Requirements, Interfaces, Transition, Communications,

and Training.

• Provide data analysis and data review support.

• Review project artifacts for completeness and compliance with PMAS/ProPath.

• Meet with application owners, application developers and analysts, coding staff and the like

to determine business needs and functionalities desired for new or revised application.

• Plan course of projects, including milestones, resources needed, budget, use of technology

and tools and document in project plan, following established project management

methodology.

• Track course of project from meetings, conferring with developers, and receiving reports.

Update project plan as needed. Document changes to scope or functionalities with change

ticket, project plan, or other format.

• Assess compliance of development process with accepted methodology and communicate to

responsible managers or staff. Document exceptions or deviations as needed. Convene

meetings and plan agenda to ensure important issues are aired and resolved.

• Provided status reports and issue summaries to the IPT leads for monitoring and course

correction.

Consultant (Wyle Inc.) supporting OCIO at Federal Motor Carrier Safety Administration

12/2011-05/2013

• Managed Business Requirements Gathering efforts for a new registration system, as part of

system design and modernization; facilitate cross functional stakeholder meetings via

teleconference and web conference to include geographically dispersed federal participants;

Interact with business and subject matter experts to elicit the "as is" business processes.

• Analyzed these requirements from multiple perspectives using graphical techniques such as

process flowcharts, business process modeling (swim lanes), input-output diagrams, and

decision tables/trees for business rules. Identify process improvement potentials.

• Socialized the analysis to the federal stakeholders and subject matter experts through an

iterative process and use collaboration tools such as StarTeam and SharePoint; Document

and track the requirements using Caliber, a requirement management tool; derive and refine

the high level requirements that are complete, well-formed, testable, and traceable using

standard templates and checklists.

• Derived business requirements with technology solution comprising forward linkage to

design, build, test and user acceptance stages, and with strategic drivers comprising

backward linkage to business needs most pressing to the agency.

• Prepared documentation and presentations describing the approach, content, and roadmap for

the Unified Registration System Architecture.

• Support EA development Activities; Assist and Contribute in the development and

documentation of the as-is FMCSA Enterprise Architecture

• Participated in the solution architecture assessment, segment architecture, and architecture

transition plan discussions; assist in the Vision and Scope document deliverables for the

Unified Registration System including Cloud solutions. Contribute to the transition plan for

the unified registration system from the current architecture to the evolving target

architecture

• Participated in the definition of authoritative source information model.

• Participated in evaluating transition of Unified Registration System to cloud based solutions.

Senior Business Process Analyst (Lockheed Martin) Federal Aviation Administration

(Supporting NextGen) 01/2011-12/2011

• Led the efforts for gathering and finalizing Functional Requirements for Aircraft

Certification Audit Information System (ACAIS), a system modernization project:

o Facilitated interaction with federal staff from different time zones across US through

teleconferencing for developing business process flows, use cases, state transition

diagram, security matrix, and interface and data requirements. :

o Analyzed existing database elements, mapped all existing data elements to the new

system, developed source-to-target mapping design specifications and data

dictionaries, and reviewed database schemas; Gathered high level requirements;

Elicited requirements within the context of the business need by interacting with the

end-users; Assisted the key stakeholders involved in each process modeling session.

o Developed role based security matrix; Derived notification matrix and RACI chart

o .Monitored Requirements risk by modules; Identified and derived requirements for

interface systems

• Participated in the architecture discussions

o Participated in the technical framework discussions to determine the type (Service-

Oriented Architecture) and technology standards for software and environment.

o Assisted in identifying components of the system for using interoperable enterprise-

wide applications that adhere to the enterprise data architecture comprising Data

Access, Configuration, Security, Utilities, Logging, E-mail, Enhancement Reporting,

Application Help, Alerts or Notification, Splash Screen Template, Enterprise Master

Page, Cache Management, Cryptology, Exception Handling and Redirector, Service

Locator

o Supported efforts in identifying components of the system for Enterprise Business

Services that provide business processes within and between business units of the

enterprise to include application of business rules, workflow definition, data analysis

and transformation, and reporting of events, metrics, and findings.

National Institute of Allergy and Infectious Diseases February 2010-January 2011

Principal Consultant (Supporting HHS OCIO)

• Received two outstanding awards from CIO:

Excellence in performance in the implementation of Enterprise Performance Life Cycle

o

Excellence in Clinical and Medical Informatics program

o

Architect:

• Participated in the creation of database architecture projects, contributed to memory pool

optimization discussions, provided solution options for database storage enhancement

efforts, researched procedures for streamlining disaster recovery, business continuity, and

planned maintenance activities.

• Researched and wrote documentation for the following sub-architecture domain artifacts:

-- Governance, Business, Technology, Security, Performance, Services

• Supported corporate business development by storyboarding and technical writing for major

proposals.

• Provided technical expertise to assist in the development and maintenance of the annual

business case (Exhibit E300) and accompanying Exhibit 53.

Information Security:

• Assisted in Certification and Accreditation reviews of operational systems based on NIST

Special Publications 800-37.

• Coordinated Program Level and System Level Plan of Action and Milestones; coordinated

efforts to address Corrective Action Plan and Action Tracking Plan.

• Ensured systems maintain the documentation, configuration and controls commensurate with

Federal Information Processing Standards (FIPS) 199 security classifications.

Initiatives and Achievements:

• Successfully monitored and implemented three production deployments (2 major and 2

minor releases) of mission critical software in production on schedule.

• Tailored Enterprise Performance Life Cycle for Software Engineering Branch Projects and

rolled out. Provided acquisition support for major IT competitive contracts (requirements

development, Statement of Work formulation and post-award contract administration).

• Led efforts to obtain Privacy Impact Assessment approval for an operational system,

• Participated in the Big-IP configuration discussions while migration of applications from

external to internal servers with special focuses on data availability, confidentiality and

integrity.

Management and Leadership:

• Managed and increased the effectiveness and efficiency of Vendor Services.

• Identified key client business issues and utilize innovative approaches to achieve strategic

and organizational goals.

• Supervised the quality of deliverables and progress of projects to ensure exceptional

performance.

Software Related Expertise:

• Supported the PMO in project management activities relating to contract Management,

release management, and requirements management.

• Helped in Certification and Accreditation efforts.

• Performed post implementation reviews.

• Established SDLC rollout in Software Engineering Branch.

• Supported and monitored testing automation using software testing tools such as

Caliber/Calista/PVCS.

• Reviewed test plan and test cases.

Coordination of Technical Engineering Activities:

• Conducted regular meetings with COTR on weekly project progress, risks and risk

mitigation strategies.

• Prepared briefing materials, papers, reports and responses to inquiries relating to Enterprise

Performance Life Cycle activities.

• Participated in the development and presentation of proposals for business development

activities.

• Conducted regular meetings and forums to address business and technical issues with

production staff, administration staff and contract managers.

• Communicated and coordinated with outside vendors to ensure service level agreement

satisfaction.

Senior Business Systems Analyst, AOL, USA November 2003 to January 2010

• Maintained, managed & pursued efforts for Data Completeness, Quality, consistency,

Timeliness & Integrity.

• Worked with data modeling tools such as ER Studio for Entity-Relationship mapping,

cross reference tables design for the real-time transaction system.

• Analyzed data relationships and put together Logical Data Model and Physical data

model options

• Created and maintained data dictionaries with attribute level descriptions

• Steward for metadata repository for centralized real-time database for Customer

Relationship Management.

• Analyzed data for Alarms and Monitoring

• Coordinated with data analysts and technical analysts for implementation

• Mapped data to interface with star schemas of 3rd party marketing data warehouses

• Mapped data and linkage to external vendor applications

• Map customer disclosure data for online storage and offline reporting.

• Coordinated with date warehouse architect and DBA for data transformation and use of

stored procedures

• Maintained the definition (data dictionary), structure, integration, and maintenance of

data in the real-time transaction database.

• Worked closely with business owners, end users, BI developers, and database

administrators to devise conceptual, logical and physical data models, data flows, and data

dictionaries

• Developed and enforced standards for metadata management to maintain the integrity of

transaction data

• Mentored new members of the team for the overall quality of data warehouse design and

development.

• Deliver Product and Technical requirement documents incorporating use cases, sequence

and collaboration diagrams, and dataflow diagrams.

• Participate in Joint Applications Development and Design Center activities to finalize

project estimates and deliver conceptual solution.

• Translate business requirement into technical requirement.

• Analyze and Design Member Management and data warehousing Campaigns.

• Instrumental in designing a number of POR Project solutions.

• Introduced new features across the system for Process Improvements.

• Represent team in SDLC process including Agile methodology.

• Design and code Qualifications / Recommendations Rules for Campaign paneling.

• Improved Business Rule structure & user interface

• Support business logic in IVR and Telephony Enhancement applications (Phone Home

data)

• Translated business logic in legacy applications and code in ILOG and manage versions

using CVS.

• Support and Mentor contractor Analyst Teams.

• . Regulatory Compliance Project:

Role: Lead Systems Analyst

• Developed diagnostic and manipulative scripts using Structured Query Language (SQL) to

diagnose and resolve data quality issues

• Consolidated data from multiple sources

• Identified the criteria for and led random security audits to verify data integrity. Provided

trends and early warning metrics

• Designed reports on service or system performance based on the negotiated SLAs and

improvement initiatives.

• Prepared test data for Development Integration testing

• Handled data quality issues and resolved them quickly

• Mapped and Managed alignment of online data for disclosure and offline data for reporting

• Ensured data integrity for Customer Relationship Management conducting data cleansing of

8 critical database tables improving data integrity by nearly 700%

• Defined technical requirements for CRM Administration Tool, which helped maintain data

integrity of the CRM databases. Developed functional and design documentation for the tool.

• Verified CRM and data integrity requirements had been addressed in software design

specifications of CRM client systems.

• Prepared Technical Requirement Document

• Reviewed documents for SDLC compliance

• Received cash award for good work done

Support Portal Project:

Role: Lead Systems Analyst

• Identified and corrected major reporting issues with the Smart Transfer Reporter website,

generating additional revenue

• Configured Business Rules using ILOG (rules engine)

• Followed Rapid Application development Methodology (“sprints”/Agile Methodology)

• Configured metadata

• Participated in “Sprints”.

Rules Migration Project:

Role: Systems Analyst

• Documented and extracted business rules from legacy applications

• Coded rules modules in ILOG using Java Rule Language

• Tested the rules using Fitnesse testing tool

Revenue Management Project:

Role: Systems Analyst

• Functional requirement analysis and development of use cases, activity diagrams and process

flows (discussions with business users)

• Requirement traceability

• Data analysis and mapping with data of other applications for efficient customer

communication

• Developed physical and conceptual data architecture models for data capture and reporting

Consultant, World Bank, USA July 2003 to October 2003

Responsibilities:

Gathered top level specifications for the information security portal for the security

•

department of the Bank.

Developed the technical architecture as well as implementation plans.

•

Consultant (Systems Analysis), AOL, USA April 2002 to June 2003

Responsibilities:

Reverse engineering of main frame (Stratus) based billing system - PL/I, Visio, Stratus.

It is a large scale reverse engineering of existing billing system. The task complexity arises from

the availability of minimal documentation and knowledge repository. The importance of this

exercise lies in the migration to a new object oriented billing system (Portal Infranet).

• Analyzed the existing programs to derive business rules and validation rules and represent

them in terms of process flow charts, data flow diagrams, control flow diagrams, and state

transition diagrams.

• Analyzed data files/databases to derive entity relationship diagrams.

• Collected Requirements for the ETL processes of the BSAPI Reject File.

• Designed the system and prepared the High Level Design Document for dataflow

• Designed ETL processes using Ab Initio 1.10

Technical Manager, DePuy Orthopedics, USA Jan 2002 to March 2002

Responsibilities:

Electronic Data Capture Project - PDA, MS-Access 2000, MS-Project

The objective of the project was to integrate PDA devices with Access database for data capture

and data analysis; in the next phase, to scale it up for DNA architecture.

• Designed the Data Capture Architecture.

• Managed a team of 5 consultants and steered them towards achieving project objectives by

setting up targets, measuring progress with respect to targets, and providing appropriate

course corrections.

• Chalked out a detailed project plan incorporating resource requirements, time schedule and

cost estimates.

• Provided weekly status reports to top management and the client and sought the views of the

client in regular interim project review meetings.

• Controlled for risks by identifying them, assessing their impacts, and taking remedial actions

in a proactive manner.

Consultant (Systems Analysis), Aetna Insurance Co., USA August 2001 to Dec 2001

Responsibilities:

• Analyzed the legacy billing system (COBOL/CICS) with a view to migrate to Client/Server

Architecture.

• Reverse engineered and reengineered from the prevalent systems and programs to derive

system flowchart, data model, dataflow diagrams, system documentation, and application

sequence.

Project Manager, eCognito.net, USA Feb 2001 to July 2001

Responsibilities:

Oracle Financials R11i –implementation

The objective of the project was to chalk out the complete financial system right from scratch to

implement it in Oracle Financials 11i.

• Managed the project for scope, cost, and skill set.

• Interacted with the users and other technical areas to specify the sources of revenue, costs

and integration with various online modules of high security.

• Led a team of 4 functional consultants and 6 technical consultants, application DBA.

• Successfully completed the project against major integration challenges.

• Supervised and facilitated offshore configuration and testing and onsite installation in USA.

Project Manager, PSINet, USA Feb 2000 to Jan 2001

Responsibilities:

Oracle Financials R11.0.3 implementation

The objective of the project is to migrate the data and application from R10.7 to R11.0.3 after accounting

for changes in the Chart of Accounts, Multi-Org and introduction of two new tax engines.

• Managed the project for scope, time, cost, skill set (human resource) and integration.

• Successfully completed the project and handed over to the customer meeting the project

objectives, and profit targets.

• Led the team of 15 functional/technical consultants, application DBA, testers facilitating

resolution of issues with 6 Subject matter experts.

• Guided the testing team in test strategy development.

• Trained the end-users in the new system.

• Designed the technical architecture for interfacing two tax engines (COBOL based Comm

Tax 21 and C based Vertex) with Oracle Financials – a challenging task given that we were

the first ones to do that.

• Designed and reviewed test plan, data validation, loading and unloading of data.

• Used analytical tools such as SAS to verify the integrity of data conversion and migration.

Project Manager, Onemain.com, USA Nov 1999 to Jan 2000

Core ISP, LAN/WAN and Business Applications

Responsibilities:

• Managed the project within quoted time and cost across 27 ISP sites in USA. At the peak,

there were nine teams working simultaneously in nine sites.

• Provided guidance to the teams on methodology, reviewed progress and appraised top

management of Megasoft and Onemain.com of progress as well as risks.

• Resolved technical and managerial issues by escalating to appropriate levels in a timely

fashion.

• Completed systems analysis for Y2K compliance of a number of infrastructure components,

Operating systems, billing and other business applications.

• Project Outlay: half a million.

Project Manager, PSINet, USA Apr 1999 to Oct 1999

Responsibilities:

Unix, Solaris, Oracle Database, Oracle Financials

The objective of the project is to analyze systems for Y2K compliance of a number of

infrastructure components, billing and other business applications including Oracle Financials

(Purchasing, Inventory, Fixed assets, Accounts Payable, Accounts Receivable and General

Ledger).

• Managed the project within the budgeted cost and time.

• Guided and inspired a team of 15 consultants.

• Interacted with the managers, technical consultants, and business analysts of PSINet to

resolve interface issues, report periodical status reports and arrive at mid-course corrections.

• Apprised the PSINet top management of progress.

Technical Analyst, Northwest Airlines, USA Dec 1997 to Mar 1999

Project: Origination & Destination Based Yield Management

Responsibilities:

IBM/MVS, TSO, Utilities, SAS, DB2/COBOL MS-Project, MS-PowerPoint, MS-Access

• The overall project is designed to enhance airline yields by changing the world view of Yield

Management from leg-based to passenger origin & destination based. Consisted of highly

complex forecasting, network optimization, seat allocations and forecast accuracy

measurement modules.

• Designed the system and coordinated the development effort by an off-shore team. This task

entailed user requirements analysis, feasibility studies, design, preparation of cost and time

estimates, coordination with off-shore developers, project monitoring, design and review of

testing strategies, and implementation.

• Led a major component (Forecasting and Network Optimization) module accounting for

70% of development effort and algorithmic complexity of the first phase of development.

• Used SAS extensively to explore integration of diverse data sources (DB2, SAS, Sequential

Files), to analyze data problems and to investigate remedial measures.

• Created a process flow for issues management and change control process. Created and

maintained an MS Access based database for tracking resolution of issues and changes.

• Worked with the Operations Research Department at Northwest Airlines to compose highly

quantitative methods oriented algorithmic approaches to business issues in Yield

Management.

• Prepared the complete logical and physical data flow diagram (DFD) including potential

customer touch points.

• Worked extensively with the Data Administration group in preparing the logical model of the

data.

• Debugged the system and added several features as required by the customer.

• Created extensive documentation for this legacy system.

• Designed a high level solution to integrate an existing legacy database with a new proposed

DB2 database. This activity entailed data extraction using BMC utilities, transformation, and

loading into test databases for verification.

• Designed reporting procedures using SAS/Macros, SAS/Basics and SAS/Reports.

Assistant Professor in MIS, Acadia University, Canada July 1995 to Dec 1997

Responsibilities:

IBM PC, Internet, HTML, _JavaScript, Excel, Access, Lindo, Props, SAS, SPSS

• Organized and analyzed surveys. Worked on six different research projects. Projects include:

Canadian manufacturing Competitiveness, Cross-Cultural managerial effectiveness, Status of

women in managerial positions (a longitudinal study), Impact of multiple levels of

advertisement exposures on the retention and buying behavior.

• Taught introductory and advanced MIS courses covering topics such as relational databases,

business process reengineering, electronic commerce etc.

• Member of the taskforce that was responsible for the design and implementation of first-ever

hi-tech classrooms in Canada.

• Contributed to a number of new teaching initiatives as a member of the first team to teach in

a wired classroom. One such is the design of automatic evaluation and feedback system to

the students interfacing HTML forms, Email, Access, and Excel.

• Taught Excel involving ‘what if’ analysis and accounting gyrations in the preparation of

financial statements.

Research Associate, Queen’s University, Canada Sep 1989 to June 1995

Responsibilities:

IBM Mainframe, VM/CMS, Access, SAS, SPSS, Excel, Lindo

Organized and analyzed surveys. Worked on six different research projects. Projects include:

Canadian manufacturing Competitiveness, Cross-Cultural managerial effectiveness, Status of

women in managerial positions (a longitudinal study), Impact of multiple levels of advertisement

exposures on the retention and buying behavior.

Deputy Manager, Bharat Heavy Electricals Limited, India Jan 1980 to Aug

1989

Responsibilities:

Univac mainframe, Fortran IV, ICL mainframe, Calcomp graphics software, PERT

Led the design and development of a simulation package for corporate planning and evaluation

(SCOPE) that would facilitate risk analysis of the corporate plan. My unique contribution was in

the generation of Fortran modules that were computationally intensive probability distributions.

Led the design and development of a project appraisal package for the preparation of financial

analysis required for the preparation of feasibility reports. It is a communication exercise in

getting the details of taxation and working capital parameters from the finance group and closely

liaise with the developers as a team to take the project to completion.

Assistant Systems Analyst, Tata Consultancy Services, Bombay July 1979 to Dec 1979

Responsibilities:

Burroughs Mainframe, COBOL

Worked as a developer. Received intensive training in structured COBOL and Database management

Systems. As a member of the project team, developed application modules using COBOL in Payroll

processing, fixed deposit accounting, interbank reconciliation etc. Worked on the large-scale linear

programming model for staggering of office hours in the downtown Bombay so as to minimize peak hour

rush in public transportation.

Contact this candidate