ANISH GOPI B.G.

DATABASE ARCHITECT

OBJECTIVE

Looking for the position of data architect in a well reputed organization that helps me to grow professionally utilizing my experience and skills to upgrade the standard of works.

SUMMARY

9+ years of experience in Software Architecture, Analysis, Design and Development experience.

7 years experience as database developer and data architect in application development and migration projects.

Over 6+ years experience in T-SQL Microsoft SQL Server 2005/2008/2012/2014

Over 3+ years experience in PL/SQL programming in Oracle 10g/11g/11gR2

Experience in working highly-transacted OLTP systems.

Experience in Data modeling.

Experience in ETL, OLAP and data warehouse systems.

Experience in SSIS development.

Strong experience in SQL queries to retrieve data for the business and to write simple to complex procedures, functions and packages to manage data in our applications.

Involved in all phases of a migration projects from MS SQL 2008 to Oracle 11gR2

Done the data conversion from SQL Server and Oracle.

Strong Experience in SAP Business Intelligence Reporting tool Crystal Reports.

Experience in Data Visualization tool Microsoft Power BI.

Knowledge in Data Visualization tool Tableau.

Familiar with BIgdata ecosystems.

Knowledge in NoSQL MongoDB.

Extensive experience in Microsoft Excel.

Loaded the data from MS Excel to Oracle Table and Oracle table to MS Excel.

Experience as a Team Lead handling a team of Database Developers and Reporters.

Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise preparing report specifications and database designs to support reporting requirements.

Have excellent working knowledge of SALES, PRODUCTION, PURCHASE, QUALITY and FINANCE modules of ELAN/6 ERP System and gERP.

Have worked in fast paced AGILE scrum environment .

Knowledge of DOTNET(C#, VB.NET), Visual Studio 2008.

Strong commitment, dedicated and efficient in problem solving along with strong debugging skills.

Multitasking ability, ability to provide results under pressure.

Highly motivated, excellent team player, enthusiastic and strong initiative.

Have the capability easy to learn and understand new technologies and skills in short time.

ADDRESS

Bhagavathyparambil

Cheranellore P O

Cochin - 682034

Kerala

India

PHONE

+91-994**-*****

E-MAIL

ac7st0@r.postjobfree.com

LINKEDIN

https://www.linkedin.com/in/anishgopi

PROFESSIONAL SKILLS

RDBMS

Microsoft SQL Server T-SQL

Oracle PL-SQL

Data Modeling

System analysis and Design

OLTP

ETL, OLAP

ERP : gERP, Elan6

SSIS

Bigdata

XML, JSON

Python

NoSQL : MongoDB

Crystal Reports

Power BI, SSRS

OS: Microsoft Windows

Microsoft Excel Spread Sheet

Microsoft Visual Studio 2008

C#, .NET Framework 3.0

Centura Framework

Agile Scrum

Leadership Skills

EXPERIENCE

GRANDTRUST INFOTECH (P) LTD, COCHIN

Sep 2018 – till date Role : Database Architect

Technology : Microsoft SQL Server 2014

Client : Rubek, India

Project : gERP - Purchase, Sales, Finance, Production and HRMS

Handled team for the ERP development, implementation and support.

Database designing for new changes.

Configuration of work flow mechanism.

Created and modified database objects like tables, views, stored procedures, functions.

ETL and data warehousing for reporting and master data management.

Nov 2017 – Aug 2018 Role : Database Architect

Technology : Microsoft SQL Server 2014

Client : JTEPL, UAE

Project : gERP - Purchase, Sales, Finance and HRMS

Configuration of work flow mechanism.

Created and modified database objects like tables, views, stored procedures, functions.

ETL and data warehousing for reporting and master data management.

Nov 2016 – Oct 2017 Role : Database Architect

Technology : Microsoft SQL Server 2014

Client : Mercator Medical Ltd., Thailand

Project : gERP - Sales, Finance and Production

Handled team for the ERP development, implementation and support.

Database designing for new changes.

ETL and data warehousing for reporting and master data management.

Created and modified database objects like tables, views, stored procedures, functions.

Production support.

Apr 2016 – Oct 2016 Role : Sr. Database Developer

Technology : Oracle 11g R2

Project : gBudget Phase II

Database migration from SQL Server 2005 to oracle 11gR2

Involved Database Designing and table designing.

Created database views, procedures, functions, packages.

Jan 2016 – Mar 2016 Role : Sr. Database Developer

Technology : Microsoft SQL Server 2014

Client : Mercator Medical Ltd., Thailand

Project : gERP - Purchase and Inventory

Involved Database Designing and table designing.

ETL and data warehousing for reporting

Created and modified database objects like tables, views, stored procedures, functions.

Production support.

Jul 2015 – Dec 2015 Role : Sr. Database Developer

Technology : Microsoft SQL Server 2008 R2

Client : MAM Baby, Thailand

Project : gERP - Purchase, Sales, Inventory, Finance and Production

Involved Database Designing and table designing.

ETL and data warehousing for reporting and master data management.

Created and modified database objects like tables, views, stored procedures, functions.

ETL Data migration for master data from existing database to SQL Server.

Dec 2014 – Jun 2015 Role : Sr. Database Developer

Technology : Microsoft SQL Server 2008 R2

Client : Brightway Holdings, Malaysia

Project : gERP - Purchase, Sales, Inventory, Finance and Production

Involved Database Designing and table designing.

Implemented advanced work flow mechanism.

Mar 2014 – Nov 2014 Role : Sr. Database Developer

Technology : Microsoft SQL Server 2008 R2

Client : Innovative Gloves Co., Ltd., Thailand

Project : gERP – Sales and Finance

Involved Database Designing and data modeling for ERP sales and purchase modules.

Configuration of work flow mechanism for ERP transactions.

Created and modified database objects like tables, views, stored procedures, functions.

Production support.

Jul 2013 – Feb 2014 Role : Database Developer

Technology : Microsoft SQL Server 2008 R2, SSIS

Client : Spicejet Ltd

Project : gAero Suit

Involved Database Designing and table designing.

Created and modified database objects like tables, views, stored procedures, functions.

Worked with data warehousing system for advanced reports.

Feb 2013 – Jun 2013 Role : Database Developer

Technology : Oracle 11gR2

Client : CBS, Botswana

Project : MTIMIS – PHASE III

Understanding the functional requirements of the program as per functional specifications received.

Collected User Requirements by participating in meetings and studying existing System.

Created database objects like tables, views, Sequences, stored procedures, function, packages, Cursor and Triggers.

Feb 2012 – Jan 2013 Role : Database Developer

Technology : Microsoft SQL Server 2008 R2

Client : Beta Healthcare (P) Ltd, Cochin

Project : gERP - Purchase, Sales, Inventory and Production

Involved Database Designing and data modeling for ERP Purchase, Sales, Inventory and Production modules.

Configuration of work flow mechanism for ERP transactions.

Created and modified database objects like tables, views, stored procedures, functions.

Oct 2011 – Jan 2012 Role : Database Developer

Technology : Oracle 11gR2

Client : CBS, Botswana

Project : MTIMIS – PHASE II

Understanding the functional requirements of the program as per functional specifications received.

Collected User Requirements by participating in meetings and studying existing System.

Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs.

Jul 2011 – Sep 2011 Role : Database Developer

Technology : Oracle 10g

Project : PFL-Print For Less

Collected User Requirements by participating in meetings and studying existing System.

Created and modified database objects like tables, views, procedures, functions, cursors, packages

Mar 2011 – Jun 2011 Role : Database Developer

Technology : SQL Server 2005

Project : gBudget – PHASE I

Involved Database Designing and table designing.

Created database objects like tables, views, stored procedures, functions.

ACORN INFO SOLUTION, COCHIN

Oct 2010 – Feb 2011 Role : Software Engineer

Technology : Microsoft SQL Server 2008, C#.NET 2008, Crystal Reports 10.0

Client : Nettikadan Corporation, Cochin

Project : ERP – Purchase and Inventory

Designed and created reports using Crystal Reports based on technical specifications provided.

Object development and review of the development requests assigned.

Ensuring a high quality solution for all the delivered objects to the client within the schedule.

Apr 2010 – Sep 2010 Role : Software Engineer

Technology : Oracle 10g, PL/SQL, ASP.NET, Crystal Reports 9.0

Client : Lakshmi Hospitals, Cochin

Project : ERP – Purchase, Sales and Inventory

Ensuring a high quality solution for all the delivered objects to the client within the schedule.

Database migration from existing MS SQL Server database to Oracle database.

Created a module Card print with Barcode in existing software.

Jan 2009 – Mar 2010 Role : Junior Software Engineer

Technology : Oracle 10g, PL/SQL, ASP.NET, Centura Framework, Crystal Reports

Client : Saraf Trading Corporation Pvt (Ltd)

Project : ELAN6

Involved in analysis, design, coding and Testing.

Collected User Requirements by participating in meetings and studying existing System.

Apr 2008 – Dec 2008 Role : Junior Software Engineer

Technology : Oracle 10g, PL/SQL, ASP.NET, Centura Framework, Crystal Reports

Client : Lock And Keys, Cochin

Project : ELAN6

Involved in analysis, design, coding and Testing.

Collected User Requirements by participating in meetings and studying existing System.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

ACADEMIC PROFILE

B.TECH IN COMPUTER SCIENCE & ENGINEERING

Jul 2004 – Jul 2007 RCET, Thrissur, Kerala

Under University of Calicut with an aggregate of 72.08 %

DIPLOMA IN COMPUTER ENGINEERING

Jun 2001 – Jun 2004 Govt. Polytechnic, Kalamassery, Kochi, Kerala

Under Department of Technical Education, Kerala with 77.11 %.

HSC

Jul 1999 – Mar 2001 Sacred Heart Higher Secondary School, Thevara, Kochi, Kerala.

Under Board of Higher Secondary Education with 68.22 %.

SSLC

Jun 1998 – Mar 1999 G.V.H.S.S North Edappally, Kochi, Kerala.

Under board of General Educational Department 89.5%

ACHIEVEMENTS

President’s Scout Certificate Holder.

Best Student award in 1995 from L.F.U.P.S, Cheranellore.

Top Scorer in S.S.L.C. exam-1999 at G.V.H.S.S North Edappally.

Class Representative of CSE, RCET, Thrissur in 2005-06

Active participant of various cultural activities in School and College levels.

HOBBIES AND INTERESTS

Drawing, Word Art

Listening to Music

Travelling

PERSONAL PROFILE

Date of Birth 22-03-1984

Gender Male

Father’s Name B K Gopi

DECLARATION

I, Anish Gopi B. G., hereby declare that the information presented above is correct to the best of my knowledge and belief.

Place : Cochin Anish Gopi B. G.

Date :

Contact this candidate