Data Analyst - Onsite Team Lead, Oracle SQL/ETL Developer Lead Resume - Hire IT People

SUMMARY:

Data Analyst with SIX years of IT experience, including THREE years as a Team lead. Experienced in Oracle SQL and ETL - IBM Datastage development with exposure of UNIX, Autosys, PL/SQL and COGNOS (Query Studio and Report Studio). Experienced in Data Analysis. Developed ADHOC Reports with critical timelines. Experienced in leading and managing offshore/onshore team. Ability to work independently and in team.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Mainframe operating system- z/OS.

Databases: Oracle 10g, 11g and DB2.

Software Used: TOAD for SQL, PL/SQL development, IBM Datastage Server 8.5, 8.7 and 9.1 for ETL development putty for UNIX Shell Script development.

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst - Onsite Team Lead, Oracle SQL/ETL Developer Lead

Responsibilities:

Manage ADHOC report requests which received through emails and HP QC Portal from business/legal/other teams
Analyse and understand the report requirement and work with requestor/Data Governance/Solution Architect team to clarify any concerns
Assign and involve responsible teams to develop ADHOC reports and manage them to complete the request
Develop SQL/ETL code and deliver the report in critical timeline
Work as Team lead and manage the onshore and offshore team by assigning work and solving their technical and business issues
Present report to requestor/Data Governance teams through meeting/email
Solve technical, business or data related issues raised by Data Governance teams
Enhance ADHOC reporting process to make reporting easier for the requestor and teams involved in the process
Create and manage documentation for each ADHOC request and Knowledge Transfer documents
Provide and maintain weekly/on-demand status reports to management team
Developing non-funded critical projects which involves design and development of database table/index, SQL/ETL Code and COGNOS reporting as a value add for the team

Environment: Oracle SQL, IBM Datastage, UNIX commands, IBM COGNOS (Query Studio and Report Studio), Microsoft Excel, Microsoft Access and Autosys job.

Confidential

Data Analyst - Offshore/Onsite Team Member, Oracle SQL/ETL Developer

Responsibilities:

Understand project requirement and develop Low level Design
Design and develop database table/index, ETL, SQL, COGNOS and Autosys job as per project requirement
Unit testing of the code
Work with testing team and fix defect in the code
Provide support to solve production issues on the projects whenever needed
Optimize code and performance improvements of Oracle - SQL and ETL
ness issues
Present report to requestor/Data Governance teams through meeting/email

Environment: Oracle SQL, IBM Datastage, UNIX commands, IBM COGNOS (Query Studio and Report Studio),Microsoft Excel and Autosys job.

We provide IT Staff Augmentation Services!

Data Analyst - Onsite Team Lead, Oracle Sql/etl Developer Lead Resume

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship