Staff Consultant, Resume

SUMMARY

An incisive professional with more than 5 years of total experience in IT industry,
5 years of ETL Testing and development experience with PL - SQL, Unix in Banking and Telecom Domain,
1.6 years of experience on Confidential Technology,
Trained on Technologies like Data warehousing, SQL, RDBMS and UNIX on Capgemini L&D Program,
Well acquainted with software development life cycle and agile methodology,
Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL,
Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views,
Expertise in Client-Server application development using Oracle 11g/10g/PL/SQL, Created Tables, Views, Constraints, Index,
Experience in DWH skills (ETL concepts), Data modeling & RDBMS concepts,
Experience in SQL performance tuning,
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes,

TECHNICAL SKILLS

Programming Languages: Oracle PL/SQL, NZSQLDatabases: Oracle 11gDomain: Telecomm, BankingTools/Software: SQL Developer, Aginity Workbench for Netezza, Tortoise SVN,Jira, Quality CentreOperating System: Window 7, UnixPROFESSIONAL EXPERIENCE

Staff Consultant,

Confidential,

Responsibilities:

Analyze the business requirement.
Estimation of block items
Involved in production fixes.
Developed views, stored procedures, and functions in order to provide IT solutions to the State Street’s Decision Support System for effective decision making.

Senior Software Engineer,

Confidential,

Responsibilities:

Analyze the business requirements & understanding the FRD.
Designed and developed views for reports as per functional requirement.
Tuned views in order to make report generation faster.
Tested reports using Micro strategy tool.

Software Engineer

Confidential,

Responsibilities:

Analyze the business requirements & understand the Functional Specification Design (FSD)
Technical documentation (includes FSS-Functional Specification Requirements, TSD -Technical Specification Requirements) for the application
Implementation of Sql & PL-Sql code
Test data preparation against the IS document using Sybase Power Designer
Involve in preparing/reviewing Test Documents (Unit & System test plan & test cases)
Execution of Unit test cases as per the Unit test plan
Execution of System test cases as per the System test plan
Involved in preparing/reviewing Installation package for the application
Creating/reviewing Installation Plan documents (Includes Installation handbook, Growth-Plansheet etc)
Support during acceptance & production (GO-LIVE) phase
Involved in Hot-Fix phase.
Handover to support team

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship