Ms. Venkataraman
brings in a wealth of expertise as Senior Java Developer and an IT
Analyst. She has more than 5 years of experience in analyzing business
requirements, engineering optimal solutions, designing, developing and
deploying applications that drive the company's growth and technological
innovation. She has worked with business users to solve critical
problems, documented business processes, designs and solutions and has led
cross-functional and cross-geographical teams to effectively build and
deploy applications. A Sun-Certified Developer, Ms. Venkataraman also has
strong expertise on working with databases and reporting tools. A
competent professional, she also led Cognizant Women's network (CWoN) at
3M, a group striving for personal effectiveness and career development.
SUMMARY OF QUALIFICATIONS
> 5.25 Years of professional experience in Analysis, Design,
Development, Testing and Documentation in the IT industry
> Strong expertise in developing web applications and customizing
existing applications using Java/J2EE
> Extensive experience in the full life cycle of the software
development process including requirements definition, proof of
concept, design, development, testing, deployment and maintenance
> Has effectively led small to medium sized development teams to build
and deploy softwares
> Good coding experience in languages like Java, C, C++ and Visual Basic
> Sound experience in working with HTML, XML, JavaScript, Struts, Spring
and SOAP
> Well-versed in Object oriented Analysis and Design, Data modeling and
Data structures
> Has thorough knowledge of SQL 2000 and SQL 2005 databases and a good
understanding of Oracle database systems
> Exhibited sound logical and trouble-shooting skills in prior work
engagements
> Proficient in business analysis and IT solutions deployment to solve
real time problems that require keen business acumen, strong
analytical capability and working closely with the business teams
> Competent in UI design and Software testing
> Designed and developed complex data flow and transformations for data
migration/extraction using SQL tools like DTS, SSIS from old legacy
systems in non-standard platforms and text based systems
> Possesses strong expertise in Object Oriented Design and Unified
Modeling Language, with skills ranging from writing problem statements
/ definitions to creating well - documented designs
> Mastery in handling multiple projects, without compromising on the
quality of the deliverables
> Proficient in using Microsoft Office Suite, Rational Design tools and
Crystal Reports
> Firm project planning skills with good communicational capabilities
> Demonstrated proficiency in leading and mentoring individuals to
improve levels of productivity while forming cohesive teams
> Has been commended for strong interpersonal, written and presentation
skills
> A highly motivated professional who is always on the lookout for a
challenge
> Demonstrated leadership and networking skills through the 'Cognizant
Women's Network at 3M' (CWoN)
TECHNICAL EXPERTISE
> Certifications: Sun Certified Java Programmer, Sun Certified Web
Component Developer
> Development Environments: Web sphere application server 5.1, Rational
Application Developer 6.0 & 7.0
> API's: JavaScript, VBScript, Servlets, JSP, Struts, JDBC and Java
Transaction API's, Portlets
> Programming Languages: Java, HTML, XML, C, C++, VB
> Reporting Tools: Crystal Reports XI
> Databases: SQL, SQL 2005, Oracle, Access
> Concepts: RDBMS, UML, OOPS, OOA and OOD, Design Pattern, Data modeling
> Softwares: Visio, Rational Suite (Rose, Clear Case, Clear Quest),
SSIS, Microsoft Office Suite, Microsoft Project Plan, DOS
> Operating Systems: Windows XP/NT 4.0, Windows 2000 Server and Vista
> Content Management Systems: Documentum 5.1 & 5.3
> Source Control Software: Visual Source Safe (VSS), Concurrent
Versions System (CVS)
PROFESSIONAL EXPERIENCE
3M, Saint Paul, MN
IT Analyst & Lead Developer
Medical Information Systems May 2006 - Sept
2009
The system is a one stop shop for the Medical department for maintaining
and analyzing medical information of employees. Medgate is the product
behind the project. The product is customized and new business processes
are defined to merge various medical systems into one. The system keeps
track of the employees' health records/ medical transcripts, validates
their claims, and helps the clients to examine the medical data for
research studies and compliance. The system transcends borders and needs a
know-how of international insurance claims management business. The various
medical modules involved are Audiometry, Clinic Visit, Clinical Testing,
Case Management, Drug Testing, Immunization, Incident Management, Travel,
Questionnaire and Pulmonary Function.
> Worked pro-actively with the business to analyze and define the
requirements of the system
> Facilitated discussions and provided solutions to bridge the gaps
between the new business processes and the product features
> Used Site Minder and internal tools to authenticate users, track user
activities, analyze actions and troubleshoot problems
> Examined data compatibility between systems and designed data
flows from various system to Medgate
> Wrote use cases to design interfaces and interactions between
systems
> Led data migration from older applications to MIS by effectively
analyzing the sustainability,
designing the data migration and testing the final system
> Designed customizations and configurations into the system using
JavaScript, business rules etc
> Developed reports and led team members to build custom reports using
Crystal Reports
> Built interfaces for interactions between old and the new system
> Effectively coordinated activities with various groups like 3M
Infrastructure, IT Security, Central Quality and Performance testing
group to bring out an effective solution which would fit perfectly
into the organization
> Documented and maintained various artifacts like requirements
traceability matrix, supplemental specification, disaster recovery
plan, backup recovery plan and provided production support as and
when the need arose
3M, Saint Paul, MN
IT Analyst & Lead Developer / Medical Surveillance Program Metrics
Oct 2008 - Sept 2009
3M has been conducting employee medical surveillance to comply with OSHA
for many years. This application facilitates the planning and conducting
the surveillance programs along with reporting and metric tracking
capabilities. The global application helps the business to assure that the
right people are included in surveillance programs, encourage 100% of
eligible employee participation and control costs.
> Analyzed business requirements and IT solutions
> Led the design and development of two releases of this project
> Gathered requirements and defined data flow to interface with MIS
> Coordinated with Quality Assurance team to facilitate the test the
application
3M, Saint Paul, MN
IT analyst / SQL 2005 Upgrade
Apr 2008 -Dec 2008
Various medical department applications were upgraded to SQL 2005 from SQL
2000 Database servers to comply with the organizational infrastructural
standards.
> Analyzed the existing jobs and formulated a plan for the upgrade
> Designed and developed SSIS jobs replacing the old DTS packages
> Was instrumental in unit testing and systems testing of the new
solutions
> Did a smooth transition of the databases from SQL 2000 to SQL 2005
3M, Saint Paul, MN
IT analyst / Vista Upgrade
Oct 2008 -Dec 2008
The multitude of medical department applications in different technologies
was scrutinized for their compatibility in Vista operating system.
> Studied the intricacies involved in the Vista upgrade process
> Examined the applications for Vista conformity
> Provided recommendations and changes for a smooth transition
> Devised a roll out plan to the users
3M, Saint Paul, MN
Lead Developer /Web sphere 5.1 to RAD 6 Upgrade
Aug 2007 - Dec 2007
The various applications in the Medical department needed a major upgrade
and reconfiguration from WAS (Websphere Application Server) 5.1 to RAD 6.
The system level upgrade called for in depth knowledge of the existing
system and business behind it and also the capabilities of the latest
software.
> Effectively visualized, planned and prioritized tasks required for
the upgrade
> Worked with the business in analyzing the impact of the upgrade and
coordinated with the other groups to minimize the impact
> Led the development and implemented the required changes
> Coordinated with the Quality and Performance Testing group to
effectively test the upgrade
> Planned and organized User Acceptance Testing
3M, Saint Paul, MN
Lead Developer / Environmental Targets Database
May 2006 - Mar 2007
Environmental Targets Database system is a centralized system to collect
emissions data from all plants in different geographical locations and
compare the goals/achieved targets. This system also helps the plant and
corporate users to generate reports. The reports are used to monitor global
company wide waste emissions performance. The reports are helpful for
corporate management to make business decisions based on factors such as
Product Output and NPO (Non product output).
> Did project planning and metrics collection for two of the releases of
this application
> Designed and validated the architecture of the system for the two
versions
> Effectively coordinated activities between teams located at offshore
and at onsite
> Involved in Unit testing, Integration testing, Systems testing and
User Interface testing
> Responsible for audits and reviews of the project
Cognizant Offshore Development Center, Chennai, India
Lead Developer / MSP
Feb 2005 - Sep 2005
3M has been conducting employee medical surveillance to comply with OSHA
for many years. This application facilitates the planning and conducting
the surveillance programs along with reporting and metric tracking
capabilities. The global application helps the business to assure that the
right people are included in surveillance programs, encourage 100% of
eligible employee participation and control costs.
> Designed the database structure and architecture of the system for the
global rollout (MSP V3.0)
> Co-Developed the application for MSP V3.0
> Effectively handled teams located at various locations and was
instrumental in the global roll out of this project
> Was responsible for audits and reviews of the project
> Coordinated activities with code review and design review teams
Cognizant Offshore Development Center, Chennai, India
Developer/ Environmental Targets Database
Sep 2005 - Apr 2006
Environmental Targets Database system is a centralized system to collect
data from all plants in different geographical locations and compare the
goals/achieved targets. This system also helps the plant and corporate
users to generate reports. The reports are used to monitor global company
wide waste emissions performance. The reports are really very helpful for
corporate management to make business decisions based on factors such as
Product Output and NPO (Non product output).
> Did project planning and metrics collection for two of the releases of
this application. Had been a developer for the first version and
developer/team lead for the next version
> Responsible for audits and reviews of the project
> Designed and validated the architecture of the system for the two
versions
> Effectively coordinated activities between teams located at offshore
and at onsite
> Involved in Unit testing, Integration testing, Systems testing and
user interface testing
Cognizant Offshore Development Center, Chennai, India
Developer / ToxDocs
May 2005 - Aug 2005
3M Corporate Toxicology and Regulatory Services stores information on
Toxicology studies conducted on chemicals and materials. They system helps
the users to locate documents easily, track studies and also has the
ability to generate reports.
> Developed and deployed release V2.3 of the ToxDocs Application
> Worked on implementing document search using DFC (Documentum
Foundation Classes - Documentum API)
> Supported the onsite team for the upgrade from Documentum 5.2 to
Documentum 5.3 SP3
3M - Cognizant Offshore Development Center, Chennai, India
Developer / EWCD
Sep 2004 - Feb 2005
Enterprise Website Creation and Delivery (EWCD) is a frame-work developed
on IBM Portal server and divine content server. This framework enables the
corporate e-business team to develop intranets for the corporate network.
This framework eliminates issues related to compatibility among various sub-
systems and sets up a standard for other applications. This solution will
be a co-development initiative and involves setting up of processes and
building a solution in a phased manner.
> Developed Import Module in "Automatic Place Publishing Portal"
> Integrated the Import Module with other Modules of the system
> Performed Unit, Integration, System and User Interface testing of the
Module
> Deployed the Import Module on the Portal Server
EDUCATION
Symbiosis Institute of Management, Pune, India
Corporate Post Graduate Diploma in Business Management, Graduated in 2006
Vellore Institute of Technology, Vellore, India
Bachelor of Engineering, Major in Computer Science, Graduated in 2004
Awards
> "Rock Award" in Mar 2006 for project delivery excellence
> "Icon Volunteer Award" in Oct 2008 for leading 'Cognizant Women's
Network at 3M'
OTHERS
> Program Lead, 'Cognizant Women's Network at 3M'
> Active participant of "Business Analysts" focus group at 3M-Cognizant
> Was an effective team member of Design Review and Code Review teams
> Was an active member of 3M-Cognizant celebration committee both at
onsite and at offshore