Team Lead/Detail Designer Resume

Professional Summary:

Has around 5 years of IT experience in Implementation of Data Warehousing projects with Teradata, Oracle and BI Publisher.
Worked with Teradata Tools/Utilities - BTEQ, FastLoad, MultiLoad, FastExport, and Tpump.
Worked with SQL and PL/SQL extensively by using Joins, Sub Queries, Set Operations, Functions, Procedures and Packages.
Developed Reports using ORACLE BI (Business Intelligence) Publisher.
Worked with Mainframe and UNIX.
Have knowledge on QTP (Quick Test Professional).
Experienced in writing Test Scenarios, Defining Test Cases, Developing and Maintain test scripts, analyzing bugs.
Well-versed in Data warehousing Concepts and Methodologies.
Good knowledge in Core Banking Domain as well as in Flexcube (Banking Product).
Good knowledge of Software Development Life Cycle (SDLC).

Professional Experience:

Currently Working as an Associate in Cognizant, Hyderabad from Apr 2012.
Worked as a Software Engineer in Mahindra Satyam, Hyderabad from Jul 2010 to Apr 2012.
Worked as an Associate Consultant in Polaris, Mumbai from Feb 2010 to Jun 2010.
Worked as an Associate Consultant in Flexcel International Pvt. Ltd. (Currently takeover by Oracle Financial Services Software Limited [OFSS]) from May 2008 to Feb 2010.
Worked as an Associate System Engineer in IBM India Pvt. Ltd. from Sep 2007 to Mar 2008.

Qualification:

Bachelor of Technology (EEE)

Skill Set:

Operating Systems : Windows, Mainframes and UNIX
Databases : Oracle and Teardata
Languages : SQL, PL/SQL and C
Web Technologies : XML, HTML
Tools : ORACLE BI Publisher (OBIEE)
Application Servers : OC4J Application Server
Editors : PL/SQL Developer and SQL Assistant

Professional Profile:

Project #1 : Mortgage Preferential Pricing (MPP).
Client : Confidential,UK.
Environment :Teradata and Mainframes.
Current Position : Team Lead/Detail Designer

Roles and Responsibilities:

Worked closely with HLD (High Level Designer) and E2E (End to End Designer) to understand the functional and technical part of the application needed to prepare the DLD (Detail Level Design) document.
Involved in database size estimations for production and all testing environments.
Developed Teradata SQL scripts as per functional requirements.
Developed Fast Export scripts to generation the mainframe flat files.
Developed Multi Load scripts to load the source files from other applications.
Created appropriate indexes depend on the tables as per the requirement.
Prepared CIT test plan, test cases and test case matrix with Business/Functional requirements.
Prepared application job schedule flow as per dependency on upstream and downstream systems/applications in production environment.
Reviewed and added various possible functional scenarios to SIT Test Plan.
Involved in SIT test data preparation based on the SIT functional scenarios.
Handled code fixations in all SDLC phases like SIT, UAT, OAT and Post Production (Live).
Prepared standard documents required for the project like- Implementation Plan, KT document, and Live Support document.
Involved in resolving the issues related to product certification as per customer requirements.
Involved in Project handover and knowledge sharing sessions with Application support team.

Project #2 : Flexcube.
Client : Confidential, UK.
Environment :Teradata and Oracle.
Current Position : Team member.
Duration : Apr 2009 to Jun 2010.

Roles and Responsibilities:

Participated in the Migration activities, conversion of existing customer data from Oracle to Teradata.
Performed Test and Live runs with huge data.
Fresh data loads through Teradata Utilities.

Project #3 : Flexcube Retail.
Client :Confidential,India.
Environment :Oracle.
Current Position : Team member.
Duration : Jun 2008 to Mar 2009.

Roles and Responsibilities:

Done Development and Enhancements of the Reports as per client requirement by using the ORACLE BI Publisher.
Developing and modifying PL/SQL procedures, functions, triggers, packages etc.
Providing resolution on issues faced by the users on FC application.
EOD batch support for all branches.
Simulation of production issues on UAT and testing the released fixes on UAT for future production deployment.
Raising relevant RFC\'s and getting those approvals by relevant stakeholders.
Driving the calls with the branches for their issues and tracking them to closure.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship