Sr System Analyst Resume

SUMMARY:

10 years and 3 months of experience in the IT industry in Software Design & Development in data warehousing
8 + Years of Experience in ETL Design/Development/Testing using Teradata, Datastage and Sunopsis (Oracle data integrator),informatica and Ab - nitio
Strong analytical, design skills and problem solving abilities.
Played Team lead/Technical Lead Roles in Multiple Projects.
Excellent interpersonal skills and a track record of absolute success as a team lead on innovative, challenging assignments.
Ability to quickly adapt to new environments and learn new technologies
Good Knowledge in manual testing and etl testing
Managing the Defect Tracking process, which included prioritizing bugs, assigning bugs, and verifying bug-fixes, using Test Director/Quality Center
Onsite experience

TECHNICAL SKILLS:

Operating System: Unix, Windows NT/2000, XP, MAC

Tools: Teradata Utilities(Mload, Fload, Fexport, Bteq), Datastage 8.X, Oracle data Integrator, Work Load Manager, Sos Berlin,Svn, Clear case, Snow, TSRM, Erwin, Informatica,Mercury Quality Center

Languages: Sql,C, HTML

Databases: Teradata,Oracle

PROFESSIONAL EXPERIENCE:

Confidential

Sr System Analyst

Responsibilities:

Played as a Team Lead for a 10 member team.
Also involved in analyzing system specifications and identification of data warehouse functionalities for design, development and testing.
Providing production support - data warehousing activities, such as data mining, report creation that assist in business decision, monitoring day-today processes, timely fixing production problems encountered, performing data fixes, executing Month/Quarter/Year End batch processes & troubleshooting issues for business users and business analysts
Coordinating with business clients, supporting the data warehouse and implementing the process as per specifications provided.
Discussing business solutions with Client business team, resolving existing problems and improving the data warehouse stability and integrity.
Development for the Confidential ( Confidential -for the enhancement and existing issues) which includes coding, Testing .
Preparing the test cases based on the business functionality for the Confidential .

Confidential

Developer and Module lead

Responsibilities:

Understanding the requirement and prepare the design document and
Develop the code in Teradata using Macros and Views and bteq.
Developed Test Cases for Functional, Integration and Regression Testing.
Coordinate with offshore team for developing the code and preparing the test cases.

Confidential

Technical Environment: Teradata, Informatica, UNIX, WLM

Test Lead

Responsibilities:

Lead the team to analyse the requirements.
Lead the team to create the test cases using Teradata based on the requirements
Reviewing the test cases and test scenario.
Co-ordination with the Onsite POC to understand the requirements.
Develop Test plans, Test Strategy, Test Cases

Confidential

Technical Environment: Teradata, Informatica, UNIX, WLM

Technical Lead

Responsibilities:

Lead the team to analyse the requirements, design, code, test, debug and deliver the new components.
Impact Analysis for the new files added.
Co-ordination with the Onsite POC to understand the requirements.
Coordinating with DBA team and Support team for setting up grounds for development and coordinating migration process and support
Preparation of Approach documents.

Confidential

Technical Environment: Teradata, Informatica,WLM

Technical Lead

Responsibilities:

Lead the team to analyse the requirements, design, code, test, debug and deliver the new components.
Co-ordination with the Onsite POC to understand the requirements.
Coordinating with DBA team and Support team for setting up grounds for and development and coordinating migration process and support

Confidential

Module Lead

Responsibilities:

Discussions with Client Managers for Capturing business requirements and making design decision
Designing the ETL logic and develop the code in Ab-nitio.
Code Migration Data loading and arranging presentations.
Preparation of TDD and BSD.

Technical Environment: Ab-nitio

Confidential

Module Lead

Responsibilities:

Lead the team to Design and Code ETL design using Teradata Utilities.
Preparing Technical Specification Documentation.
Have worked on performance tuning of Teradata queries and utilities
Preparation of TDD and BSD.

Technical Environment: Teradata Utilities (BTEQ, Mload, Fast export), UNIX

Confidential

Developer

Responsibilities:

Design and Development of job for field validation in Datastage
Executing the test cases to find the defect in the developed code
Responsible for overseeing the Quality procedures related to the project

Technical Environment: Teradata, Datastage 7.5 PX, Teradata Utilities (BTEQ, Mload, Fast export), Mercury Quality Center, UNIX

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship