Oracle Project
Resume:
** ****** **, *******, ** *****
Email:************@*******.***
CHANDRAN KARAKADAN
OBJECTIVE
A strategic, focused, and business oriented senior technology manager with
25+ years of experience in information technologies. To make a significant
technical contribution to a growing/progressive organization in the areas
of Oracle applications, EDI and software development
SUMMARY
. Over 25 years' experience as an IT professional with extensive experience
in EDI Project Management, Oracle Development and ERP Integration
. Visionary IT leader with a track record for defining, building and
optimizing best-in-class IT infrastructures and operations
. Recognized for defining enterprise technology strategies/solutions that
reduce costs, improve efficiencies, support organizational goals and
maximize the technology investment
. Highly valued strategic partner at the top management levels
. Proven track record of identifying and understanding business needs for
Information Technology
. Well-rounded knowledge and experience in Enterprise Application
Integration (EAI) and B2B areas
. Extensive experience in managing all aspects of EDI life cycle from the
establishment of trading partner relationships to the design and
integration of EDI business models
. Exceptional Project/EDI Management skills, with ERP integration
experience
. Ability to establish and maintain effective working relationships with
senior level executives as well as to work closely with associates on the
project team so that the nature of the work is always collaborative with
everyone participating in the process
. Excellent oral and written communication skills and resident go-to person
and resident expert for analysis and solutions
TECHNICAL SKILLS
. Gentran EDI Applications, FTP, VAN, UCCnet solutions, Cyclone AS2
Protocol, Salesforce.com CRM
. GENTRAN EDI installation, Gentran Integration Suite(GIS)/Sterling B2B
Integrator, Mapping, Partner Setup, Mail Box Control, Process Control,
Archive Control
. Oracle 10g/9i/8i/7.0, SQL, PL/SQL, Procedure and Functions, Pro-Cobol
(SQL Embedded), MF Cobol, Cobol 74, DMSII, UNIFY, DMS1100
. Oracle Discoverer Reporting, Oracle Forms, Oracle Report Writer, SQL
Plus, SQL Loader, DDL, SDDL, ADMLP, MAP, ERGO, CANDE and JCL Commands
. Windows, HP-UX, UNIX, MCP, OS-1100, EXEC 1100, LINUX
. HP 9000, Unisys A Series, Unisys 1100/60 C1, Horizon III
. Microsoft Office Suite (Word, PowerPoint, Excel, Visio, Access)
EDUCATION
MS in Computer Management, Pune University, 1984
EXPERIENCE
Director Programming Operations (IT)
August 2004 - Present
Home Care Industries, Clifton, NJ
. Provided technical leadership and direction to cross functional teams -
operations, sales, marketing, and technology
. Responsible for Project Management activities including project
scheduling and phasing
. Spearheaded new technology research, product and vendor evaluation
. Architect, design and lead customization implementation of EDI,
Distributed Order Management(DOM) and interfaces using Sterling products(
GIS(Gentran Integration Suite) aka Sterling B2B Integrator
. Architecture design and development in EDI, to include converting
business requirements to development with Inbound/Outbound flow charts,
data managers, queues, scripting, translation, encryption and
communication modules
. Maintaining an EDI system that has more than 500 partners and processing
around 1200 transactions each day and integrated
with Mainframe Order Processing and Oracle Data warehouse
. Strong in EDIINT (AS1,AS2 Protocol), FTP/SFTP, SMTP, HTTP/HTTPS, UCCnet
Solutions
. Utilized Sterling Commerce Gentran Integration Suite (GIS)/ Sterling B2B
Integrator on all platforms
. Installing GIS in various environments viz. development, test,
production, applying patches, managing migration of business processes,
configurations from one environment to another
. Provide day-to-day Gentran Integration (GIS)/ Sterling B2B Integrator
administrative support, system tuning and capacity planning
. Enhanced old business processes, created new ones and manage the
promotion through the SDLC
. Provided business rules and project planning for in-house application
technologies
. Configuration, installation and administration of the company's EDI
systems; install and configure trading partner data and mappings for new
EDI documents
. Write and debug scripts and programs that run the EDI software on WIN/NT
servers
. Create and run test scenarios against mappings to ensure correct
operation
. Maintain daily EDI data communications, quickly resolving exceptions that
may arise
. Working with trading partners to determine requirements for
implementing new EDI documents or updates
. Lead, coordinate and administer key process improvements in both legacy
and new Internet based EDI implementations
. Maps for EDI Formats (ANSI X12 4010, 4030, 5010, 5030, 5060). XML
including XPath, DTDs, and XSchema for Data Mapping and Process Models
. Correct the Mailbox errors OR report to EDI Coordinator OR Report to
internal function team
. Work with VAN's to resolve transmission issues and retransmit EDI
Documents
. Work with trading partners and internal function teams to troubleshoot
data issues and mapping issues
. Designed and created an interface between custom application and order
processing system
. Led the upgrade process of Oracle database from 8i to 10g including the
setup of the 10g Oracle development environment
. Oracle Discoverer Administrator for multiple EUL's production issues
. Liaising between users and consultants to resolve specific business needs
and coordinating technical enhancements of systems and reports
. Interfacing with users, identifying functional and technical gaps,
estimating work, architecting system interactions, designing custom
solutions, leading developers and preparing documentation
Consultant
June 1998 - July 2004
Home Care Industries, Clifton, NJ
. Managed the day-to-day e-commerce technical activities between Home Care
Industry and its business
Customers/ suppliers
. Provided daily technical support for all EDI activity
. Worked as an EDI specialist and created more than 500 GENTRAN EDI
837,270/271,276/277,278,835, 810, 850, 860,855,856, 812,820, 816,
864,875,880 maps and partner profile setup
. Partnered with multiple levels of management to establish effective e-
commerce solutions for a variety of company operations
. Developed and maintained relationships with internal e-commerce users
such as Logistics, Vendor Compliance and Accounts Payable
. Served as a Mentor and Technical Lead for designing, developing and
implementing of projects
. Establishing cross-functional e-commerce systems or processes,
standardizing procedures, providing/developing technical training and
coaching to identified groups
. Installing GIS in various environments viz. development, test,
production, applying patches, managing migration of business processes,
configurations from one environment to another
. Provided administration and support of EDI and related applications to
ensure a high level of system integrity
. Aggressively managed the implementation of new EDI customers and
additional services to existing customers
. Provided high-level departmental and customer EDI support
. Developed and maintained systems documentation relating to critical EDI
information, policies and operating procedures
. Involved in requirements gathering, functional gap analysis, application
design, configuration, module setup, test script generation, preparing
training guides, training end users and production support
. Developed an in-house Oracle 8i data warehousing system by converting
data from DMSII database to Oracle database; data was populated by using
SQL Loader; Developed all DDL and DML statements
. Performing the day to day maintenance of data warehouse
. Installed and configured Oracle Developer suite environment on
Development machine
. Created more than 250 matrix reports using Oracle Discoverer
. Mentored junior programmers in Oracle database design and development
Development Manager
September 1994 - April 1998
Hindustan Aeronautics Ltd, Bangalore, India
. Led teams of system designers, software developers and testers to project
completion
. Managed various large scale oracle application projects
. Provided technical leadership and direction to cross functional teams,
responsible for transformation of legacy systems into oracle
. Involved in all phases of software development lifecycle - analysis,
design, technical specification, database architecture, programming,
testing, implementation system maintenance and support
. Drive the analysis and requirements activities associated with a given
project or initiative; and design the specifications
. Designed, developed prototype forms, reports in Oracle and developed all
the major modules in the ERP system
. Responsible for creating and validating data and loading it to Oracle
tables
. Created and debugged various kinds of Database objects including PL/SQL
procedures and functions, tables, triggers, constraints etc. to support
various areas of development as well as maintenance and support of the
Application
TRAINING AND CERTIFICATIONS
. Training on Oracle Warehouse Builder and OLAP
. Oracle BI Tools training by Oracle Corporation
. Training on UNIX & C, UNIX & Oracle 7.0 for application developers, SQL
Plus, Data Modeling and RDBMS concepts.
. GENTRAN EDI Mapping training by Sterling Commerce.
Contact this candidate