Jerry John

  • 6 Kessels rd , Salisbury QLD
Jerry John

Work History

Work History
Apr 2015 - Present

Data Base Developer (Intern)

Bizprac octal8 pty ltd

Working  as  a data base developer (Microsoft Sql server) for Bizprac estimating software
 Installing, Upgrading and Configuring Microsoft SQL Server 2012.
Data Base migration  from firebird inter base database  to Microsoft sql server DB
Design of  logical and physical database 
Developing T-SQL stored procedures and triggers.
Creation of tables, views, sequences,  index, constraints
Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS Client requirement Analysis, Physical, Logical design, development (using SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000, SSIS, SSAS and SSRS 2005/2008.
Creation of complex SQL queries involving multiple tables inner and outer joins.
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Data base backup, restore.
Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modelling concepts.
Good understanding of Financial Domain.

Jul 2012 - Jun 2013

Data Base Developer/Admin

Big Whale Digital Marketing (Cochin ,India)

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
Expert in TSQL DDL/DML, performs most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
Worked Extensively on ETL process using SSIS package.
Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. 
Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

Nov 2011 - Jun 2012

Systems Executive

Hindustan Unilever Limited. Bengaluru, India

Worked as Systems analyst (supply chain management SAP-APO) for Unilever Fusion landscape - India.
Coordinated with systems partners to finalize designs and confirm requirements.
Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
Developed work-flow charts and diagrams to ensure production team compliance with client deadlines.
Plan and manage projects to meet business requirements in cooperation with the IT Department.
Provide project monitoring and support for the review, development and acceptance of final proposed solutions, user acceptance testing and signoff, implementation, identification of training needs and post-implementation evaluation of project delivery.
Resolve operational system problems reported by the end user, and provide technical support for all areas of the department, monitor data quality and report errors and inconsistencies.
Extensive experience in business analysis, design, modelling, implementation of SAP APO   applications.
Providing Systematic solutions for improving the daily distribution Planning run on Unilever Fusion landscape.
Experience in Unilever Demand Planning (DP), Supply Network Planning (SNP), R/3 (ECC) and Business Information Warehouse (BW).
Working knowledge of all aspects of Integration of Master Data and Transactional Data.
Expertise in configuring and customizing Master Planning Object Structures, Planning Areas, Aggregates.
Good Understanding in APO DP statistical forecasting and modelling techniques.

Sep 2010 - Nov 2011

IT-Executive Applications

Jubilant Group

Worked as IT-Executive for Administrating Oracle, sql server database and Baan IV ERP.
Providing technical and functional solutions to key users & end users of BAAN IV ERP.
Experience in planning, installing, configuring, and administering multiple Oracle (9i, 10g, and 11g) and SQL Server (2000/2005/2008) databases in Windows NT/2000/XP.
Solid skills in database optimization and performance tuning for servers, applications, and SQL queries.
Experience in performing RMAN backup and recovery, cold as well as hot backups.
Creating and editing PL/SQL Packages, Procedures, Functions, and Triggers both in Oracle and SQL Server.
Good knowledge in Microsoft business intelligence (ssis/ssas/ssrs)
Manage database instances, monitor server performance, tune the database server and applications, and perform backup and recovery.
Good knowledge in various modules of Baan IV ERP.
Creation of different Baan Users & Management of user/ Package combinations and companies    & User authorization management and user access to different companies & Session authorization at different levels.
Generation of reports & taking care of daily/ weekly/ monthly backup.
Root cause analyses of the problems.
Handling Tools Issue at table level maintenance.
Understanding business requirements of customers and providing the solutions.


IT professional with more than three years of combined experience in Data base  administration and development, system analysis, ERP support, and Business Intelligence.


Jul 2013 - Jun 2015


James Cook University
Jun 2004 - May 2009

B.Tech Computer Science & Engineering

University Of Kerala MIT



SQL SERVER 2008,2012 (Administration & Development)


ORACLE (9i,10g,11g) , Oracle App Express




Microsoft Business Intelligence (SSIS , SSAS , SSRS), Visual Studio

Firebird database



Mar 2009 - Jul 2009

Oracle Certified professional


Data Base Administration (9i)

May 2009 - Jul 2009

Oracle Certified Associate


PL/SQL Developer


Peter Donovan – General Manager & Software Developer

BizPrac Software’s

Unit 8, 45-49 Commercial Drive

Shailer Park, Qld, 4128

Ph. (07) 3806 2817