Information Technology Manager
Resume:
Vivek Ananda PMP
Streamwood, IL 50107
***************@*****.***
Over 15 years of extensive experience covering wide array of areas
including Project Management, Application Development, Risk Management,
Change Management, Data Conversion, Configuration, Testing, End user
training and methodologies for clients within the Manufacturing, Services
industries, U.S. Federal Government and Law enforcement Agencies. I have a
wide breath of knowledge of both current and emerging technologies allowing
me to often identify innovative technical solutions to customer problems.
Experience Summary
. Strong expertise in Oracle Tools which include Oracle Forms,
Oracle Reports, PL / SQL, Apex, JDeveloper, Toplink.
. Strong expertise in Visual Basic, Visual C++ and .NET framework.
. Strong expertise in Oracle Databases, SQL Server, DB2 Database,
Oracle Lite, Oracle Application Servers, Internet Information
server.
. Strong expertise in J2EE technologies.
. Proficient in varies project methodologies.
. Possess excellent creative and problem solving skills.
. Ability to work effectively with various professionals like
peers, executive management and senior management.
. Managed teams with up to 10 team members on numerous
successfully projects.
Certifications, Recognition & Awards
. PMP Certified - Since 2009
. Citizens Award of Appreciation -Automated Arrest System-Chicago
Police Department
1. Oracle - QOOL Award
2. Oracle Consulting Innovator of the Year Public Sector,
Technology West
. Oracle Consulting Outstanding Teamwork Award Public Sector,
Technology West
. Technical Excellence - ACS Government Solutions Group
Education
. Masters of Science in Computer Science, Oklahoma City University
at Oklahoma City
. Bachelors in Engineering (Electronics), RVCE at Bangalore, India
Technical Skills and Training
Platform and Oracle Database High Availability
Architecture Oracle Application Server Performance Tuning
Internet Information Server MS SQL Server
Oracle 10g Lite (Release 2 and MySQL
Release 3) IBM DB2
Development Forms 4.5, 5 6x, 9i and 10g Oracle J Developer
Tools and Reports 6i, 9i, 10g Top Link
Programming Designer 6i, 9i, 10g Portal
Languages APEX XMLDB
XML Publisher PL/
SQL Developer SQL
Java Toad C++
C HTML /DHTML
.Net Javascript
Visual C++ iQuery
Visual Basic
Hardware & Windows NT, 2000,2003 & 2008 HP-UX 11.11
Operating Windows XP, Vista and Windows Red Hat Linux
Systems 7
Solaris
Testing Tools Mercury - Quick Test Pro
Project Microsoft Project
Management
Tools
Training Project Management Lifecycle Oracle 9i Security
Oracle J Developer Oracle 10g AS Disaster and
Oracle XML Recovery
Oracle 10g IAS Installing Oracle Top Link
Professional Experience
Illinois State Police - Forensic Science Command (FSC)
Information Technology Manager (Sep 2010 to present)
Manage systems used by over 250 forensic analysts to analyze and
report findings on criminal evidence submitted to FSC by law
enforcement agencies in the state.
Responsibilities include
. Conduct feasibility studies to determine the cost effectiveness
and benefits of proposed application improvements.
. Liaison for FSC for other agencies regarding information data
exchange.
. Conduction Joint application design (JAD) sessions to gather
business requirements.
. Evaluated and approved purchases for all computer / server
hardware.
. Responsible for all aspects of the day-to-day IT operations.
Computer Aided Laboratory Management System (CALMS) - CALMS is the
laboratory evidence tracking and report generation system used by FSC.
All of six labs through the state run a dedicated instance of CALMS
database. A custom build visual basic application is used to access
the information.
Sample Tracking and Control System (STaCS) - STaCS application is used
by Forensic Biology and DNA sections. This application is used to
track all samples and controls for DNA analysis. The system also
provides quality assurance check points which will stop the analyst
from choosing a non-operational instrument or use expired reagents to
process the sample. We have a single instance of the application which
is used by all forensic biology and DNA sections through the state.
All samples, controls, instruments and reagents are tracked in the
system via unique barcodes generated at various phases of the DNA
analysis process.
FORAY Digital Workplace - Latent Print section and Forensic Biology
section use the forensic science document management system which
tracks all analyst worksheets, pictures taken to analyze the evidence.
The system keeps revisions of assets uploaded and modified during the
period of analysis.
ORACLE CORPORATION
January 2001 - September 2010
COMCAST - Seattle (July 2010 to September 2010)
Technical Lead - Oracle Corporation
Technical Lead for a 5 developer's team to migrate a custom
application from forms 6i to forms 10g. All the forms were generated
Oracle Designer 6i using Oracle head start template. Migration
included upgrading the designer repository to Designer 10g and
regenerated all 60 forms using Oracle 10g head start template.
Installed and configured multiple Application Severs to host both
development and production instances.
Illinois State Police ICASE phase 3- 4 (Feb 2007 - May 2010)
Project Manager - Oracle Corporation
Project manager for implement phase 4 statewide incident management
system requirements with a team of 6 and budget of $700 K. The
application is being used by Illinois State Police and other law
enforcement agencies in the state. Responsibilities included
. Responsible for the initiation, planning, execution, control and
completion of the project
. Handle the tasks of leading project teams and update on software
development activities as appropriate to the software team
leader
. Responsible for identifying cross-project issues and work with
management to identify and implement solutions
. Handle the tasks of providing technical leadership and guidance
to other team members
. Responsible for software design reviews, peer code reviews and
software acceptance test activities on a regular basis
Cablevision - Bethpage, NY
CPOD application using Oracle Lite (August 2008 - November 2008)
Technical Lead - Oracle Corporation
Technical advisor for a 5 developer team to design and implement a
mobile solution for CPOD application. The application CPDOS was going
to be used by service technicians in the field. This would allow them
update service tickets remotely. Responsibilities included.
. Defining and documenting scalability testing goals and
objectives.
. Preparing scalability test scenarios.
. Executing and evaluating scalability tests.
. Implemented production system.
FLSMIDTH - Bethlehem, PA
Forms and Reports Upgrade (March 2008 - April 2008)
Technical Advisor - Oracle Corporation
Technical advisor for a team 14 developers to address issues
encountered in Forms 6i to 10g upgrade project. List of issues address
and resolved:
. Problem with Object linking and embedding ("OLE") calls,
namely OLE calls to Microsoft Excel using
. WebUtil feature of Forms 10g
. Getting errors when compiling Oracle Reports in AIX
environment
. Performance of forms navigation
Illinois State Police ICASE phase 1 and 2 (November 2005 - February 2007)
Development Lead - Oracle Corporation
Development Lead for a 15 developer team and budget of $2M to design
and implementation of a statewide incident management system for the
State of Illinois and other law enforcement agencies. By replacing the
present paper based system I-Case will standardize incident reporting,
enhance data sharing. Once deployed on mobile device (Oracle Lite) I-
CASE will provide faster access to case reports. I-Case application is
built with full compliance with J2EE. It also adheres to data
collection standards defined by various state and federal agencies.
Responsibilities included
. Conduct requirements gathering, systems analysis, and design of
the application
. Responsible for preparing detailed program specifications for
the application from which programs will be designed, coded,
configured, visually developed, tested, and debugged
. Perform responsibilities of designing, installing, coding,
configuring, developing, testing, debugging, and documenting
application programs by following program specifications
. Handle the tasks of developing business knowledge and
relationships to integrate activities with other IT and business
personnel
. Responsible for ensuring successful implementation of projects
and production support efforts
. Responsible for software design reviews, peer code reviews and
software acceptance test activities on a regular basis
. Handle the tasks of providing technical leadership and guidance
to other team members
Chicago Police Department (September 2002 - November 2005)
Technical Lead - Oracle Corporation
Responsibilities
. Conduct requirements gathering, systems analysis, and design of
the application
. Generate use case documents.
. Handle the tasks of providing technical leadership and guidance
to other team members
. Identifying and implement solutions for cross-project issues.
. Responsible for ensuring successful implementation of projects
and production support efforts
. Responsible for software design reviews, peer code reviews and
software acceptance test activities on a regular basis
Projects
. Administrative Notice of Violation (ANOV)
Technical lead for a 5 consultant team to design and
implementation of a Web Services for capturing information
and identifying subjects by finger print search to determine
if the subject is wanted for any crime.
. Migration of APEX
Technical lead for a 6 consultant team to migrate from an
unsupported version of APEX (HTMLDB) to a supported version.
Tasks included installing the new version of APEX and
complete testing of all the system, Identifying Modules that
are affected by the upgrade and analyzing the problem and
finding a solution.
. Automated Incident Management System (AMIS)
Technical lead for a new incident management system to work
for both the Chicago Police Department and Illinois State
Police. This project is to understand both department
processes and designing a system to work for both
departments. This system is designed allowing other law
enforcement agencies the State of Illinois want to use. The
non-mobile version of the system is going to be developed in
APEX (HTMLDB). This entire application will replace present
Client Server application for Chicago Police Department..
. Citizen Law Enforcement Analysis Reporting (CLEAR)
Technical lead for a 3 developer team to design and
development of HTML GUI Licensing Application using Designer
9i, HTML DB, Reports 6i and Oracle 9i. The web based system
will help City of Chicago process background checks for
customers who request Licenses for a business. The
information entered into the system is transferred to a
Fingerprinting system which after completing a background
check stores the finger prints and notifies the system if the
person has any criminal background.
. Automated Arrest (CLEAR)
Technical lead for a 10 consultants team to design and
development of HTML GUI modules for Automated Arrests System
(part of CLEAR) using Designer 9i, APEX (HTMLDB), Reports 6i
and Oracle 9i. This web system replaced the existing client
server arrest system modules. With this system the arrest
process was made automated from the time the offender was
arrested till produced in court. This system will interface
with Fingerprint, Mug Shot, FBI and the State department
system. The entire application is converted from Forms 6i to
APEX (HTMLDB).
Chicago Police Department (January 2001- September 2002)
Software Consultant - Oracle Corporation
. Conducted classes on APEX (HTMLDB) for about 30 Chicago
Police Department Developers and Oracle Consultants working
on the CLEAR project.
. Worked on the Proof of Concept HTML prototype using APEX
(HTMLDB). Which was used as a baseline reference for future
development using the tool?
. Criminal History Record Information Systems - CHRIS
Responsibilities included design and development of GUI
modules for Criminal History Records Information Systems
(CHRIS) using Developer Forms 6i and Reports6i, Designer 2000
and Oracle 8i also involved in maintaining and trouble
shooting CHRIS system. CHRIS system is a high availability,
mission critical system. This system is a transaction
processing system, through which every day Criminal History
Records such arrests, cases, stop orders, warrant and
internal affairs are entered. The system has complex
interfaces with Fingerprint, Mugshots and FBI Systems.
U S Air force, Tinker AFB, Oklahoma - APCINS (March 1998- January 2001)
Senior Software Development Specialist - ACS Government Solution Group
Designed and developed Automated Computer Program Identification
Numbering System (ACPINS), which provides US Air Force Software
Managers and worldwide ACPIN customers with an easy access, user
friendly, web-based system consisting of Oracle Forms, Oracle Reports
and Oracle PL/SQL web pages to access information from an Oracle
database. Other responsible included maintenance of the production
environment and design and develop upgrades. Performing maintenance
for Oracle database servers, Oracle web servers, online support and
training for users.
Contact this candidate