Business Analyst Resume Profile

PROFFESIONAL SUMMARY:

6 years of IT experience in database development using Oracle PL/SQL and SQL,ETL using SSIS, SQL Server, MS ACCESS 2003, VB, Unix Shell Scripting.
Expert in Oracle PL/SQL- Packages, Stored Procedures, Functions and Triggers, Collections, Bulk Collect, Cursor, Dynamic SQL, Hints etc.
Experience in ETL between homogeneous and heterogeneous systems using MS SQL tools DTS, SSIS and Oracle SQL loader etc.
Experience in Oracle query performance tuning and query optimization techniques.
Beginner level knowledge of NOSQL databases such as MongoDB, Cassandra and Amazon Redshift and PostgreSQL.
Experience of working in Waterfall and Agile software development environments.
Passionate Toastmaster-Certified as Competent Leader by Toastmaster International.
Hands on experience of JDA Intactix suite of application including- IKB, Space planning in SCM domain.
Hands on knowledge of IBM Maximo enterprise asset management EAM - Maximo integration framework and object structure for data migration related tasks.

KEY SKILLS:

Relational Databases-Design and coding using SQL

Toad 9.5,

Oracle SQL Developer

Unix Shell Scripting, PostgreSQL Intermediate level

Waterfall, Agile Software development, Retail -JDA Intactix, IBM Maximo

PL/SQL, ORACLE 9i/ 10g/11g.

Data warehouse and ETL using SSIS and Oracle.

MS -SQL SERVER 2005, SSIS, MS ACCESS reports.

Amazon Redshift, MongoDB, Cassandra.

Beginner level