We provide IT Staff Augmentation Services!

Principal Consultant Resume

New, YorK

SUMMARY:

  • A computer science graduate having more than 11 years of professional experience on Database Driven Application Development, Enhancement & Production Support Projects for Telecom, General Insurance, Supply Chain Management & domain; having expertise in Oracle 11G Release2, PL/SQL, Unix shell scripting, Business Objects, VB6 (Visual Basic), VB Script.
  • Oracle certified expert, with more than 11 years of programming experience as an Oracle PL/SQL Developer and Data Warehouse Architect in Analysis, Design and Implementation of Business Applications and Data warehouses using the Oracle Relational Database Management System (RDBMS).
  • Expertise in creation of efficient Stored Procedures, Packages, Functions, Triggers, Views and Materialized Views.
  • Experience based competence on Data Modeling, Database Performance Tuning (SQL, PL/SQL Tuning), and Data Warehouse Management using custom ETL tools. Using RAT (Real time Application Testing) tools like SQL Performance Analyzer and SQL Access Advisor. Analyzing Execution plan and Autotrace logs.
  • Applying Hints in SQL.
  • Performed detailed application code reviews and tuned databases and applications by identifying bottlenecks.
  • Used ASH, AWR (10g), Stats pack (9i and below), tkprof, Trace analyzer, Wait analysis and extended trace extensively for application tuning.
  • Optimized batch programs and processes in PL/SQL and custom programs and tuned them to meet the SLA’s.
  • Using Analytical functions like Rank, Dense Rank, Pivot, ListAgg etc. for creating complex analytical reports. Using Parallel execution functionality in SQL for database objects.
  • Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
  • Loading Bulk data in database quickly various methods like SQL Loader, DB Link and Data Pump.
  • Using Snowflake and Star Schemas, Dimensional data modeling.
  • Using best practices for OTLP and OLAP systems. Expertise in Materialized views, Complex views, Composite and Reference Partitioning, Interval Partitioning, Bitmap and BTree indexes, Star Transformation, packages, triggers and clustering techniques.
  • ITIL V3 Foundation certified professional with expertise in IT Service Management.
  • Extensive Experience in Incident Management, Problem Management (RCA), Change Management, Release Management and Business Continuity Planning.
  • Travelled to Japan on Business Visa in Jan 2015 for Requirement gathering and meeting clients.
  • Travelled to USA on Business Visa (B1) in May 2012 for Requirement gathering and meeting clients.

TECHNICAL SKILLS INCLUDE:

Operating Systems: WIN 9X/2000/XP/2003/2007/7, Unix, AIX.

Languages: SQL, VB Script, Visual Basic VB 6.0, COM, DCOM, ActiveX

Databases: Oracle 11G Release 2 (PL/SQL)

Web Tools: HTML, Classic ASP 3.0, Maximo, ManageNow, Clearquest

Reporting Tools: Crystal Reports, Business Objects XIR3 (BO)

Methodologies: SSAD

Version Control: VSS, Serena PVCS VM, Rational ClearCase, TFS 2010

PROFESSIONAL EXPERIENCE:

Confidential, New York

Principal Consultant

Responsibilities:

  • Interact with clients for functional analysis to develop the requirement specifications.
  • Defining the scope of work from requirements specifications and preparing CBR document.
  • Analyzing and estimating the effort & time required for solution
  • Developing modules following structured development method.
  • Unit testing and Client approval of application till all requirements are met.
  • System Testing
  • Releasing Final Version on Production servers and preparing the Final Documentation.

Confidential

Technical Architect

Responsibilities:

  • Interact with clients for functional analysis to develop the requirement specifications.
  • Defining the scope of work from requirements specifications and preparing CBR document.
  • Analyzing and estimating the effort & time required for solution
  • Developing modules following structured development method.
  • Unit testing and Client approval of application till all requirements are met.
  • Releasing Final Version on Production servers and preparing the Final Documentation.
  • Handling application service delivery and production support
  • Providing functional training to users of this application.

Confidential

Team Leader

Responsibilities:

  • Interact with clients for functional analysis to develop the requirement specifications.
  • Defining the scope of work from requirements specifications and preparing SOW document.
  • Analyzing and estimating the effort & time required for solution development and logging it in an SCF form (Software Change Form).
  • Developing modules following structured development method.
  • Unit testing and Client approval of application till all requirements are met.
  • Releasing Final Version on Production servers and preparing the Final Documentation.
  • Handling application service delivery and production support for two applications. Generating Metrics Report for Production Support.
  • Providing functional training to users of this application.

Confidential

Senior Software Engineer

Responsibilities:

  • Interact with client for functional analysis to develop the requirement specifications.
  • Defining the scope of work from requirements specifications.
  • Analyzing and estimating the effort & time required for solution development.
  • Developing modules following structured development method.
  • Unit testing and Client approval of application till all requirements are met.
  • Releasing Final Version on Live servers and preparing the Final Documentation.
  • Handling application service delivery for multiple applications

Confidential

Software Engineer

Responsibilities:

  • Interact with client for functional analysis to develop the requirement specifications.
  • Defining the scope of work from requirements specifications.
  • Analyzing and estimating the effort & time required for solution development.
  • Developing modules following structured development method.
  • Unit testing and Client approval of application till all requirements are met.
  • Releasing Final Version on Live servers and preparing the Final Documentation.
  • Configuration of various products of Client.

Confidential

Application Support Engineer

Responsibilities:

  • Studied functional requirements from the Legacy applications
  • Converted the requirements in to requirement specifications & scope of work.
  • Developed various modules preparing the flowchart first.
  • Performed Unit Test and Functional Test till the client approval of the final version.
  • Released final version & documented the same.

Confidential

Web Programmer

Responsibilities:

  • Interacted with International client for functional analysis to develop the requirement specifications
  • Prepared design & technical specifications for the solution.
  • Developed the Front - end GUI as well as the Back-end Database for various Market Survey requirements
  • Provided Service Support to various Online Survey applications.

Hire Now