Software Engineer Resume
PhoeniX
OBJECTIVE:
- To work in a challenging and dynamic environment, to contribute to the growth and success of the organization and simultaneously adding value to myself.
SUMMARY:
- Having 5.3 years of experience in information technology in using Informatica and Data stage.Excellent skills in exploring new tools/languages.Looking for an innovative and challenging software development environment in a reputed software company, where my knowledge and talent can be utilized at full potential.
- Experience in the implementation of Data Warehouse applications mainly Extraction,Transformation and Loading process using ETL tools Informatica,DataStage.
- Involved in project coordination.
- Good Knowledge on Data Warehousing concepts like Star Schema, Dimensionsand Fact tables.Involved in generating reports using cognos.
- Invovlved in metadata analysis and reporting by using Information Analyser Tool.
- Involved in the analysis of source system.
- Experienced in Testing, Implementation and Maintenance.
- A good team player with strong analytic skills, meticulous nature and a preserving attitude a fast learner with good communication skills.
- Proficiency in database developer tool like Toad.
- Have experience in preparing job flow or work flow diagrams in Visio.
TECHNICAL SKILLS:
ETL Tools: Informatica 7.1,Data Stage 7.1,7.5/8.0/8.5
RDBMS: Oracle 8i/9i,10g
Operating System: Windows 9x/2000 Prof and XP,Unix
Languages: C, C++,and SQL.
Reporting Tool: Cognos 8.0/10.1
GUI Tool: Visual Basic 6.0.
Data Profiling Tool: Information Analyzer 8.1
PROFESSIONAL EXPERIENCE:
Confidential
Environment: Data Stage 8.5,Windows XP,Oracle 10g
Responsibilities:
- Involved in providing support to datastage jobs monitoring in shift systems.
- Involved in updating the existing sql queries as per the requirement.
- Involved in sending MOM and in other shift handover activities.
- Resolved the received tickets based on the requirement.
Confidential
Environment: Data Stage 8.1,Windows XP,Oracle 10g
Responsibilities:
- Involved in creating the datastage jobs as per the requirement.
- Involved in updating the existing sql queries as per the requirement.
- Involved in preparing required documentation which is required by the client.
Confidential
Environment: Data Stage 8.0,Windows 2000,Oracle 10g
Responsibilities:
- Involved in updating the existing pl/sql procedures as per the user request.
- Involved in preparing documentation which is required by the client.
Confidential
Environment: Data Stage 7.5,Windows 2000,Teradata 12.0
Responsibilities:
- Involved in doing PCS Testing of datastage jobs through unix.
- Involved in preparing documentation which is required by the client.
- Involved in giving datastage to freshers.
Confidential
Environment: Data Stage 7.1,Windows 2000,Oracle 10g
Responsibilities:
- Involved in the support project activities by providing 1st and 2nd level of support.
- Team member of the Data Warehousing module. Involved in designing, developing of the ETL (Extract, Transformation and Load) strategy.
- Understanding the requirement specifications and creating mappingsheets.
- Used hash files for look ups while ETL development.
Confidential, Phoenix
Environment: Data Stage 7.5,Windows 2000,Oracle 10g,Cognos 8.0
Responsibilities:
- Team member of the Data Warehousing module. Involved in designing, developing of the ETL (Extract, Transformation and Load) strategy.
- Understanding the requirement specifications and creating mappingsheets.
- Created SDD’s and implemented update strategies using Datastage Designer
- Monitored the jobs and using the datastage director.
- Involved in production and support.
- Involved in data profiling by using a specific tool called ‘Information Analyser’
- Involved in reporting to generate various list,crosstab and chart reports in cognos.
Confidential
Environment: Data Stage 7.5,Windows 2000,Teradata,Cognos 8.0
Responsibilities:
- Team member of the Data Warehousing module. Involved in designing, developing of the ETL (Extract, Transformation and Load) strategy.
- Understanding the requirement specifications and creating mapping reports.
- Created Design documents and various simple jobs using Datastage Designer
- Extensively used SAP,Teradata source and targe stages.
- Monitored the jobs and using the datastage director.
- Involved in migration of datastage jobs from 7.5 to the version 8.0.
- Involved in reporting to generate various list and chart reports in cognos.