Ravi Hanjan
** ****** **** ( Avon, Connecticut 06001
Mobile 860-***-**** ( Home 860-***-**** ( ********@***.***
Summary of Qualifications
Project Management ~ Information Systems Expertise ~ Collaborative
Leadership
Highly-accomplished, visionary project management strategist with
exceptional business development and IT skills and experience. More than 20
years of demonstrated achievements in applying technology to solve real
business problems contributing to increased IT capabilities and reduced
costs in diverse industries in public and private sectors. Superior
leadership, interpersonal and team-building attributes with the ability to
motivate team members, both as consultant and corporate employee. Dynamic,
natural problem-solver and fast-learner committed to success.
Core cOMPetencieS
Project/Change Management ( Visio ( Project Planning ( Data Base Management
( Customer Satisfaction ( Problem Identification/Resolution ( Quality
Assurance ( Lean Methods ( Project/Team Leadership ( Strategic Planning (
System Integration ( Regulatory Compliance ( Data
Analysis/Modeling/Warehousing ( Web Applications ( Process Improvement (
IT/Software Implementation ( Organizational Transformations ( Cost Cutting
( Relationship Building ( Communications ( Employee Development ( Problem-
Solving ( Team Building/Training
sElEcted ACCOMPLISHMENTS
. Optimized technical performance, increasing efficiency by 300%, through
effective project management strategies and innovative IT initiatives to
execute projects for greatest long term value/growth. Successfully
planned/executed projects and generated reports in significantly less
time. Motivated high-performing teams.
. Improved operational capabilities through delivery of skilled Enterprise-
level services, including design, implementation and support of network
infrastructure and services. Provided project oversight, process
improvements, new technology deployment and cost savings that resulted in
database run-time reduction from 26 hours to 6 hours.
. Expanded customer service, by establishing key client relationships to
stimulate business development and growth. Increased productivity by 150%
with customer service programs resulting in greater customer satisfaction
and increased retention of customers.
PROFESSIONAL EXPERIENCE
Advanced Information Techniques, LLC 02/2009 - Present
Project Manager - (SDLC Methodology)
. Develop consultancy methodologies for improving performance.
. Cultivating relationships with corporate decision makers.
. Manage the day-to-day activities of multiple complex business-sponsored
IT projects to deliver tasks on time, within budget, and within scope.
. Document the project requirements according to the organization
standards.
. Write and managed proposals for State contracts.
. Develop and maintain budgets.
UTC Power, Enterprise Project Management Environment
09/2007 - 02/2009
Microsoft Project Consultant
. Rally resources to assess regulatory requirement and identify actions to
comply.
. Proactively managed systems development, implementation and risk via the
use of SDLC and Waterfall.
. Negotiated with other teams in the organization.
. Ability to communicate and negotiate effectively with Sr. Management.
. Negotiated support cross-organizationally.
. Managed the day-to-day activities of multiple complex business-sponsored
IT projects to deliver tasks on time, within budget, and within scope.
. Documented the project requirements according to the organization
standards.
. Managed effective utilization of resources assigned to the project team,
and communicated resource capacity and shortages to the appropriate
Resource Manager.
. Increased operational efficiency by 75% through implementation of
standard work and streamlining of the process for extracting/compiling
Microsoft Project data from MS Project server.
. Introduced highly-effective reporting methods to boost reporting
productivity of engineering department by 60% and improved technical
capabilities through deployment of Visual Basic for Applications (VBA).
. Utilized Visio in creating network diagrams.
Advanced Information Techniques, LLC 01/2003 - 09/2007
Project Manager (2006-2007)
. Proactively managed systems development, implementation and risk via the
use of SDLC.
. Stimulated business growth through deployment of effective
strategies/procedures for acquisition of partners and new consulting
engagements, as well as marketing of exemplary PM services to the
private/public sectors.
. Valued by clients as trusted advisor/leader cultivating key relationships
with corporate decision makers by holding regular meetings and delivering
PowerPoint presentations.
. Provided consulting services in proposal management; preparation of
technical and cost proposals for submission to State agencies.
. Directed proposal development activities, including RFP review and
analysis, bid determination, proposal management, proposal team
management and coordination.
. Improved operational capabilities and ensured compliance with 21 CFR Part
11, an FDA electronic record-keeping requirement, for pharmaceutical and
biotech client companies through expert planning and plan execution
utilizing MS Project and Excel with deliverables and documentation.
. Provided expert management/oversight of planning/scheduling and project
functions in the areas of quality, communications, HR, cost, procurement
and risk/change management.
. Utilized Visio in creating organizational charts, data flow, Gantt
Charts.
United Health Group, Enterprise Project Management Environment 07/2006
- 09/2006
Project Manager
. Managed scope of the project, and ensured that scope changes were
reviewed and approved by the Client.
. Achieved significant operational efficiencies through creation of project
and communications plans to create project structure and coordinate
activities of business and project teams and supporting staff.
. Tracked software customization, defects and issues via the use of SDLC
IT Principal Consultant 01/2003-07/2006)
. Demonstrated advanced technical expertise and strong analytical
capabilities in assessment of project requirements and performance of
highest-quality consulting services.
. Delivered significant improvements in IT implementation for dynamic
client base of Fortune 500 insurance companies and the State of
Connecticut.
. Tracked software customization, defects and issues via the use of SDLC
Cigna Healthcare, Enterprise Project Management Environment 03/2000
- 01/2003
Principal Consultant
. Comply with Enterprise Change Management Standard and related procedures
across development, system test, customer test and production
environments.
. The process was tracked using tickets.
. Rally resources to assess regulatory requirement and identify actions to
comply.
. Led a matrix project team in executing assigned tasks and coordinating
the efforts of internal and external project team members.
. Monitored and held project resources accountable for meeting performance
metrics.
. Managed project budget, and reported project cost and schedule
information in an accurate and timely manner.
. Managed projects requiring data feeds, data integration and/or data
movement between systems which required validation, Cleansing and
mapping.
. Played a pivotal role as principal consultant on large Enterprise
transformation program to provide an integrated application
infrastructure in support of corporate goals and strategies.
. Contributed to leadership excellence by managing a development team of
consultants over entire lifecycle of project, including
definition/deployment and testing of application and integration
architecture.
. Utilized outstanding technical skills/experience to design front-end
screens for Visual Basic (VB) application and guide application into
production. Interfaced with DBA to define/add tables to databases.
. Directed system testing of front-end and back-end programs divided into 4
different regions, including unit testing, system testing, acceptance or
integration testing, and production. Worked with Integration Team to
perform integration testing, with fall outs returned to appropriate
teams.
. Tracked software customization, defects and issues via the use of SDLC.
. Managed multiple applications, encompassing VB, DB2, COBOL, TSO, JCL,
XPEDITER, CICS, MS Project, and Visio.
Department of Motor Vehicles 02/1999 -
08/1999
Principal Consultant
. Tracked software customization, defects and issues via the use of SDLC.
. Worked with key functional areas (e.g., DMV Commissioner, IT Manager) to
understand the impact of the project on the organization. Identified and
capitalized on interdependencies. Directed a team of independent
consultants/IT professionals in design and launch of new Motor Boat
Registration System for the State of Connecticut.
. Increased operational efficiency and enhanced departmental productivity
by 60% through introduction of integrated system that presents unified
approach to registration across multiple vehicles.
. Upheld integrity of organizational mission by establishing standards for
consulting excellence and instituting best practices in project
management and project planning. Mentored staff in areas of methodology.
. Exhibited outstanding communications/relationship-building attributes by
meeting with clients to define business requirements and present
data/deliver final presentation. Built strong relationships and
communicated changes to Commissioner of Motor Vehicles and department
manager.
. Employed VSAM, DB2, COBOL, TSO, JCL, XPEDITER, CICS, and MS Project in
execution of project.
THE HARTFORD
01/1997 - 01/1999
Principal Consultant
. Led a team of in-house employees and consultants on a Personal Lines and
Homeowners project.
. Built strong relationship with the client.
. Provided remediation strategy for the applications that were not Y2K
Compliant.
. Managed Y2K project which included a limited assessment of the
application portfolio for the Personal Lines organization.
. Utilized: VSAM, DB2, COBOL, TSO, JCL, XPEDITER and CICS.
CIGNA
04/1992 - 01/1997
Principal Consultant
. Designed, coded, tested and implemented client requirements for a
computer security system.
. Partnered with development team to define application and integration
architecture for a project.
. Team members kept abreast of changes.
. Enhancement team was notified for changes.
. Managed projects requiring data feeds, data integration and/or data
movement between systems which required validation, Cleansing and
mapping.
. Utilized: VSAM, DB2, COBOL, TSO, JCL, XPEDITER and CICS.
Technical SkillS
Software Applications: DB2, Oracle, ActiveX Data Objects (ADO), JAVA, MS
Visual InterDev 6 Web Application Development, ASP.NET, VB.NET, GUPTA SQL,
SQLTALK, SQL Server, Remote Data Service (RDS), MS Transaction Server
(MTS), HTML, ASP, VB, Data Modeling, PowerBuilder, SQL, Cobol 370, Cobol
II, Microfocus Cobol, JCL, Easytrieve Plus, Lotus Notes, VSAM, Information
Engineering, IEF Case, Yourdon, CICS Command Level, Data Warehouse, MS
Office, including Access, Excel, Project.
Hardware: IBM 360/370, IBM 30XX/43XX, Windows (95/98, NT, XP) Client
Server, Sun Micro Systems, RS/6000 UNIX, MVS, AS/400, HP-Unix.
FDA Compliance: 21 CFR Part 11 Compliant Services.
EDUCATION
University of Hartford
Master of Business Administration in Management Information Systems
Bachelor of Arts in Management
PROFESSIONAL DEVELOPMENT
Courses, Seminars, Workshops: Continuing education in areas of technology,
leadership, communications, team-building and management. Technical
coursework included: Logical & Physical Design and Data Modeling,
Structured Design, Structured Programming, Introduction to CICS, JCL, MVS
Dump Reading, TSO/SPF, and Native Calls to DATACOM, Introduction to Ideal,
Strategic Issues in Managing Information Technology, AD / Cycle.