Technology Lead Resume

SUMMARY

Experienced Software professional with 8.7 Years of experience in Data & Analysis, Service Supply Chain and Billing & CRM Domain.
Proficient in Oracle SQL and PL/SQL using Toad for Oracle 9.0.1, SQL Developer and MYSQL using Toad for MySQL 4.5.
Good in Informatica PowerCenter Tool.
Good in Snowflakes.
Good in UNIX Shell Scripting using SSH Tectica.
Acquainted well in environments requiring direct customer interaction during specification and development. Extensive work experience in complete software development life cycle (SDLC) with both Waterfall & Agile SCRUM Model.
Flexible and versatile to adapt to any new environment and work on any project.
Having ability to work in teams or Individually.
Having excellent communication, analytical, relationship management and problem - solving skills.

TECHNICAL SKILLS

Technology: Informatica, Snowflake, Oracle SQL, PL/SQL, Performance Tuning, Oracle R12 Functional (Order Management, Planning), MySQL, UNIX Shell Scripting, Python, XML, JSON

Database: Snowflake, Oracle 10g, 12c, MySQL

Domain: Enterprise Data & Analytics (eDnA), Customer Relationship Management (CRM), Service Supply Chain (SSC)

Tools: Informatica, Snowflake, Toad, SQL Developer, Excel, SSH Tectica, Tidal, Rally, Enterprise Service Now (ESP), APPDB, WEBEX

Operating System: Windows XP, Windows 7, Windows 10

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Responsibilities:

Designing, Creating & Managing ETL Mappings, Workflows using Informatica Power Centers
Developing New Job Groups & Jobs using Tidal Tool to Automate the ETL Jobs.
Designing, Creating & Managing Database Objects like Tables, Views, Indexes, Synonyms, P ackages, Procedures, Triggers, Functions and Sequences .
Worked on Oracle R12 in Order Management Module.
Hands on with Excel, Good understanding of Formulae, PIVOT Table & VLOOKUP.
Responsible for all Code merging, Code packaging and Deployment process.
Offshore team coordination.
Day to day client interaction, business requirement clarification, Production Support handling.
Work with team members to identify project tasks, estimated work effort and timelines, escalate any changes to project scope
Doing RCA of Problem Occurred and implementing LTF.
Performance Tuning of Key Processes time to time using oracle built in utilities like EXPLAIN PLAN and Optimizer Hints.
Working on Unix Shell Script for creating Daily Jobs which calls the Oracle Packages.
Using Tidal Job Scheduler for Monitoring Daily, Weekly Jobs. These Jobs are Batch Jobs which Run at a Certain point of time and may be standalone Jobs or Dependent on other Jobs.
Responsible for all Prod support, Maintenance & Enhancement related work.
Done successful migration of Planning Module to R12. Planning is a Custom Module for CISCO which depends on the Third-Party Application Xelus.

Senior Software Developer

Confidential

Responsibilities:

Requirement Analysis, involving in Solution Architecture & preparing TDD related to the Provisioning Module.
Creating/Managing database objects like Tables, Views, Indexes, Synonyms, Procedures, Triggers, Functions and Sequences .
Working on packages, stored procedures, user defined functions, exception handling and triggers.
Done RCA of Problem Occurred. Good experience with oracle built in utilities like EXPLAIN PLAN and Optimizer Hints which are useful in Performance Tuning.
Developing various Utilities Batch Jobs, Uploads and Web Services using C# and Enhancing the UIs.
Interacted with clients to understand their requirements to solve Issues.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship