Preetham Kumar William

Curriculum vitae Email:-Mobile: - • • • • • • Family name: WILLIAM First names: Preetham Kumar Date of Birth:- Nationality: Indian Civil status: Single Education: Institution (Date from – Date to) Newcastle University, NSW, Australia From Jan 2015 – March 2018 (one semester to finish the degree) Dr. M.G.R. University, Chennai, India From June 2006 – May 2010 St. John’s Matriculation Higher Secondary School, Chennai, India From June 2003 – March 2005 Indian Embassy School, Sana’a, Yemen From 1991 – May 2003 • Degree & Major MIT Degree: Master of Information Technology Australia –obtained 110 units/credits Project: 80% B. Tech. IT (First Class) Bachelor Degree in Information Technology Class XII Nursery - Class X Language skills: English: Excellent PTE Score: Valid till 5 June 2020 Overall Score: 74% Listening: 70%; Reading: 78%; Speaking: 90%; Writing: 68% PTE Score: Valid till 17 July 2019 Overall Score: 81% Listening: 82%; Reading: 81%; Speaking: 90%; Writing: 72% Other Languages: Tamil (Mother Tongue) Hindi Arabic French 8. Technical Exposure: Speaking Very Good Very Good Good Good OPERATING SYSTEM: Red Hat Enterprise Linux 3.0/4.0/5.0, Windows 2000/2003 server, Oracle Enterprise Linux. DATABASES: ORACLE 9i (9.2.0.4/9.2.0.5/9.2.0.7), ORACLE 10g (10.2.0.1, 10.2.0.3), (10.2.0.4) LANGUAGES: Oracle, C, C++, Dot Net. • Areas of Expertise • • • • • • Hands on experience in Oracle 9/10g/ Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions and Backup & Recovery (RMAN). Successfully upgraded Oracle database 9i to 10g / 10g to 11g Expertise in using Microsoft Office for documentation of work, preparing reports for various levels of assessment. Expertise in User Managed Database Backup & Recovery and also using backup utilities like RMAN, and Export & Import. Administering & Managing Oracle Users, roles, privileges & creating Database objects. Professional experience: • Dates Location Company Position Description - up to- Chennai, India Start up Company Ancarp.com UK Company’s Indian Branch General Manager Fully in charge of Branch office in India Managing and running the Cab Call Center Developing software for new project Exploring new opportunities to expand the center Dates Location Company - to- Chennai, India BPosition PAGEONE Sr. Software TECHNOLOGIES Engineer Description Sr. Software Engineer: See below for details of the Job Responsibilities Job responsibilities: • • • • • Responsible for Understanding of complete functionalities of various modules implemented in the application and participated in requirement gathering and interpreting specifications during the initial phase. Involved in Requirement gathering while communicating with client and creating the technical designs to build the flow charts, layouts, diagrams, charts, code comments and clear code to support it. Responsible for designing, developing, coding, debugging, diagnosing and correcting errors and faults in an applications programming language.’ Developing the software applications and creating workflows using integration tool WMB for movement of data in form of messages within various streams. Develop program code to meet system requirements, system designs and technical specifications using appropriate programming techniques, software tools and scripting languages. • • • • • • • • • • • • • • • • • • • • • Involved in coding for language conversion which involved the basics of other languages (French and German), Followed up with testers and pro actively resolve issues that were raised, developed and deployed the code using water fall model. Working on software development lifecycle activities at various stages and Worked in an Agile / Test Driven Development (TDD), Continuous Integration environment using WMB. Responsible for building the architecture for development and contributed in initial phase of estimating the timeframe. Worked in Enhancement and Maintenance projects where the code was debugged to find the fixes for the issues and completed. Testing successfully before implementing the code changes in production. Involved in developing, analysing and maintaining tools that support and automate processes for software product releases. Write automation scripts and programs to improve workflow. Involved in simultaneous integration, end to end testing, deploying the code at multiple environments. Intense knowledge gathering on Insurance Domain as most of the software developed were Insurance companies and clients. Development of the new change requests which involves Coding, Unit testing and Documentation to meet system requirements, system designs and technical specification. Involved in constructing technical specifications from a given business functional model. Contributed in maintaining technical documentation for the software developed. Obtains and licenses software by obtaining required information from vendors; recommending purchase; testing and approving products. Determines operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions. Maintaining Redo Log files & Data files control files. Prepares and installs solutions by determining and designing system specifications, standards, and programming. Improves operations by conducting system analysis; recommending changes in policies and procedures. Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities, reading professional publications, maintaining personal networks; participating in professional organizations. Export & Import tables, schema & database Protects operations by keeping information confidential. Provides information by collecting, analysing, and summarizing development and service issues. Managing an Oracle 10g & 11g Instances. Develops software solutions by studying information needs; conferring with users; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle CDates Location 2006 to 2010 Chennai, India Company Dr. M.G.R. University Position Description Student Final Year Project Efficient Broadcasting in mobile ad-hoc network PROJECT DETAILS (done in PAGE ONE Technologies) Client Environment Role Domain : : : : Cyma Logistics, Canada Oracle 10g, Linux Database Administrator Logistics Description Cyma logistics is one of the leading shipping Transportation firm in Canada having branches in various countries. The Database maintaining for the client having two different modules. The first module holds the information about the (LTL), shipping mode details, customer lists and freightquaote details. The second module of the database consists of information about (TL), services, destination list and costing details. The privileges are granted to the authenticated people to update the day to day information. Monitoring tools and applications in the system analyse and fetch data from the database and prepare the reports. Responsibilities • Installation, configuration the ORACLE Server and maintenance of servers in various environments. • Creation of table spaces, adding or resizing data files in oracle. • Responsible for solving the workday issues faced by the development users. • Managing schemas, roles, and profiles. • Performing periodical backups using hot backup strategy. • Performing monthly cold backup during planned down time. • Monitoring space and index usage. Rebuilding indexes on that objects and coalescing the unused segments. • Performing schema, table level Exports / Imports. • Loading data into table using SQL* Loader from different sources. • Detecting and eradicating row chaining and row migration. • Monitoring the database for the usage of latest statistics on manipulating data and Analyse the database objects such as tables and indexes for better performance, if in case of old statistics. • Checking the alert log files for any errors. • Cloning the production database when required. • Configure Statspack and constantly monitoring the database through the Statspack report, Explain plan and SQL trace. Kind Regards, William Preetham Kumar