SHINOJ PANNIYOOKIL
Database Specialist
Wayne,NJ
Summary
Driven Database Specialist with 15 years of experience in full lifecycle development. In-depth understanding of data management projects in diverse domain such as as Banking, Education, and Finance. Excessively worked on OLTP database design, Reporting model design, Performance Tuning, Data Extraction and Transformation, Data Visualization, High Availability, Data Backup, Data Security, etc. Goal-oriented team lead succeeds working with various colleagues and clients by maintaining communication. Motivated with keen analytical, problem-solving and task management abilities.
Overview
16
16
years of professional experience
5
5
years of post-secondary education
2
2
Certifications
Work History
Database Administrator
Orion Innovation
Edison, NJ
07.2022 - Current
- Cloud Optimisation : Objective of project is to reduce the Azure cost incurring to KPMG Global Services.
- There are different aspects of optimisation, such as identifying the costly resources, identifying unwanted resources, identifying improper licensing types, etc. My major contribution to the team is pulling the cost data from Azure portal and related business Master data and combining all those to a "single source of truth", further frame that data to insightful reports (MIS)
- Team Size : 5
- Technology: SQL Server, SSIS, Power BI, Azure SQL and Azure Data Factory
Technical Lead (Architect)
Orion Innovation
KOCHI, INDIA
03.2012 - 06.2022
- #1. Orion Live Ink Character Recognition) OLICR suite is an integrated set of software applications that facilitate speedy evaluation of examinations transcripts using OLICR sheets and Tablets (and Pen). OLICR system developed mainly for Council for the Indian School Certificate Examinations (CISCE), one of India’s most prestigious school education boards, having more than 2000+ schools expanded over multiple countries. OLICR helped CISCE to cutdowns approximately 35% of traditional evaluation period, and did result publishing in best ever short duration!
- Same application used for Goa Board of Secondary and Higher Secondary Education and Tamil Nadu High School Certification
- I designed data movement (ETL) from OLICR to Result Processing Systems (RPS). I reviewed and enhanced the Data Objects (Table, View, Procedure, Index, and Triggers) in OLICR to ensure speedy and reliable working of the application as it is time critical and data critical
- Team Size : 20
- Technology :, SSIS)
- Responsibilities : Design, development and maintenance of Database objects. ETL and Data Visualisation
- #2. CAREERS suite is an integrated set of software applications that streamlines various tasks like affiliation of a school, registration of students then conducting of examinations and publishing of results, etc. The system developed for the Council for the Indian School Certificate Examinations (CISCE).
- I was leading the database team, and developed database model and objects ( Table, View, Procedure, Index, etc.) along with assisting team in database development. Implemented best practices in SSRS reports to ensure team efficiency and quality. Production Database Server administration also I headed
- Team Size : 40
- Technology : SQL Server 2012 ( SSRS, SSIS,)
- Responsibilities : Development and Maintenance of SSRS Reports (Data Visualisation), Development and Maintenance of Database objects and SSIS packages. MS SQL server administration.
- #3. TitleMax DW Reporting (TitleMax, USA): TitleMax, Inc is a privately owned title lending business with corporate offices in Dallas, Texas and Savannah, Georgia. The company has more than 1,100 stores in sixteen states. This DW solution is indented to bring all the stores application to a centralized database and perform analysis on that to make MIS reports. Data Integration jobs are developed in SSIS
- I do performance tuning on SSIS package SPs and SSRS report SPs. I mostly work with stored procedures, Views, Indexes
- Technology : SQL Server 2008 (SSRS, SSIS)
- Responsibilities : Development and Maintenance of Database objects. ETL and Data Visualisation.
Database Developer
TEKsystems
Bangalore, India
10.2010 - 03.2012
- #1. Time Warner Cable, Time Warner: IssueTrack Reporting and Archiving (, Cable (TWC) is one of the biggest cable TV providers ( and media) in USA. TWC uses a web application, called IssueTrack for managing customer issues. IssueTrack keeps track of issues registered, response made, unsolved issues, etc.This application is developed in .NET with MS-SQL Server 2008 as backend.
- Onsite Database Developer and I are responsible for populating reporting and archiving database by fetching data from IssueTrack application live database. Often, we do performance tuning on Reporting and Archiving databases.
- We would deeply work with Stored procedures, Views, Indexes. Timely response on Production issues is mandatory for our role.
- Reporting database should provide reliable data because all kind of MIS and transactional reports are generating from this database not from application database
- Team Size : 2
- Responsibility : Design, Development and Maintenance of Database objects. ETL development.
- #2. QUEST Reporting (Hawaii Medical Service Association -USA) This project of Hawaii Medical Service Association (USA) is to convert the existing line of business reports which is developed in Crystal Report (8.5/9) to SSRS 2008. We analyse the existing Crystal report templates and make equivalent reports in SSRS keeping business logic report format intact. Report size, style, alignment and all such things need to match exactly with the Crystal reports. Sometimes we touched the query also to make an equal SSRS output.
- Team Size : 12
- Technology :, 2008 (SSRS ), Crystal Report 8
- Responsibilities : Design and Development of SSRS reports.
Programmer
Sesame Software Solutions
KOZHIKODE, INDIA
11.2006 - 10.2010
- #1. ALM Reporting (Asset Liability Management Reporting) The ALM Reporting project developed as per the instruction from RBI (Reserve Bank Of India) to Co-operative Urban Banks. ALM is intended to inspect the financial status of the Bank for the particular day as well as for the future years. It’s complex in calculation but give prudent view of all Assets and Liabilities of the Bank.
- I heavily worked with Stored procedures, Functions and Views to implement the business logic
- Major clients are Calicut Co-operative Urban Bank and Iringalakuda Town Co-operative Urban Bank and many other Urban Banks in Kerala.
- Technology : SQL Server 2000/5/8, Crystal Reports, VB 6.0
- Responsibilities : System Study, Design, Development, Implementation, and Customer training.
- #2. Beacon (Banking Solution) This is a core-Banking solution for Service Co-operative Banks. This software facilitate the requirements of various departments of Bank, including Deposit (of different schemes), Loans (of different schemes), Bill Clearance, Accounts, etc. This application uses MS-SQL Server as database and implement the core business logic in DB. I worked to the highest degree with Stored procedures, Functions, Views, Triggers and Indexes to build the business layer. This product has a wide installation all over Kerala more than 150 Banks.
- Technology : SQL Server 2000, Crystal Reports, VB 6.0
- Responsibilities : Design, develop and enhance software in VB 6.0 and SQL Server.
- #3. PayRoll This application manages establishment related functionalities of the Bank. It includes basic and advance features like leave capturing, salary processing, re-fixation, pay revision, etc. This software has implemented in more than 100 Banks all over Kerala.
- Technology : SQL Server 2000, Crystal Reports, VB 6.0
- Responsibilities : System Analysis, Design and Develop modules in VB 6.0 and SQL Server.
Education
Master in Computer Application -
IGNOU
KOZHIKODE 05.2001 - 05.2005
Advanced Diploma in Computer Applications -
DOEACC
KOZHIKODE 05.2002 - 05.2003
Skills
MS-SQL Server
SSRS
SSIS
T-SQL
Power BI
Azure Data Factory
Azure SQL
T-SQL coding
Software development proficiency
Agile Methodology
Data visualizations
Critical Thinking
Problem-Solving
Maintenance and Repair
Data extracting
SQL development
Certification
MCTS - SQL Server 2008, Database Development Microsoft
Accomplishments
- ETL development and report optimsation done for the project of Time Warner Cable got the appreciation from onsite manager and elected me as "Best performer of the quarter" in TekSystems.
- In CAREERS project developed an Analysis report of 200+ pages, which has complex calculations and stunning presentation. The client CISCE and team much appreciated the work.
- Identified bottlenecks (glitches) in OLICR first version and provided immediate solution to resolve the production problem, which helped the business in large extend as business hours were spoiling due to latency issue in application.
- Implemented better solution to avoid the SQL database Full backup failures in production (over 50 + databases with aggregate 2 TB size) which was a nightmare to restart FULL backup and properly keep backup chain.
- In 2020, all CISCE Evaluation Centres got closed due to Covid pandemic. And everybody was uncertain when evaluation can be started. We developed an Online Mark Capturing System with in 4 weeks, which is capable of replacing existing legacy system. I alone handled database development and administration of this application. In short time we made the product live and evaluators able to use the application from their home using laptop, PC, Tablet, mobile, etc. 1.8 million transcripts were fed to the system using this application with zero errors. This is one of much praised achievement.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
It is never too late to be what you might have been.
George Eliot
Timeline
Database Administrator
Orion Innovation
07.2022 - Current
Microsoft Power BI Data Analyst Associate
04-2022
MCTS - SQL Server 2008, Database Development Microsoft
03-2012
Technical Lead (Architect)
Orion Innovation
03.2012 - 06.2022
Database Developer
TEKsystems
10.2010 - 03.2012
Programmer
Sesame Software Solutions
11.2006 - 10.2010
Advanced Diploma in Computer Applications -
DOEACC
05.2002 - 05.2003
Master in Computer Application -
IGNOU
05.2001 - 05.2005