EXPERIENCE SUMMARY:

• I possess 10 Years of IT experience, 9 Years of diverse experience in ETL methodology for data transformation using Informatica or Data stage.
• Technical expertise with specialization in the Data Warehouse and system development life cycle and support.
• Ability to do requirement study, analyze high - level business requirements and identify the relevant functional and technical requirements.
• Create test plan and test cases based on BRD or RRD or User Specifications.
• Creating the Teradata Scripts for data load and transformations.
• Creating the Data Stage jobs for CDC, SK generating and Field validation jobs.
• Experience with Informatica tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica.
• Involving Guidewire application changes during releases, based on these changes modifies the ETL jobs.
• Debugging the issues during month end process, if any issues related to Guidewire policycenter to billingcenter integrations report to the application team.
• Debugging the issue for Guidewire ODS messaging issues.
• Working with Guidewire data conversion like renewal conversions.
• Onsite/Offshore Status Reporting.
• Client Interaction and participate in all client calls.
• I have experience on Agile, V model, Waterfall
• Mobile Payment System testing.

TECHNICAL SKILLS:

Operating System: Windows 98/2k/XP, Mac OS OSX 10.4 (Tiger), UNIX

Programming Languages: Java, HTML

Databases & Tools: Teradata, Oracle, Netezza

ETL Tools: Data Stage, Informatica

Reporting Tools: Microstrategy, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Environment: Languages: GW tool, Informatica 9.1.0.

Database: Neteeza, SQL, Oracle.

Server: SQL Server

Tools: Microstrategy, Guidewire

OS: UNIX, Windows

Responsibilities:

• Created analysis of source systems, business requirements and identification of business rules. Working with user to get the requirements.
• Responsible for testing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter
• Support team members, if any problems during testing or production. Act like Team Lead.
• Create test cases and test plan and test strategy documents.
• Onsite and Offshore coordination, review offshore work and helping the testing process and requirement explanations.
• Test the accuracy of the data and ETL code on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable test cases for regression testing for feature releases.
• Extracting xmls and load data into the ODS table by using Informatica work flow.
• Involving Guidewire application changes during releases, based on these changes modifies the ETL jobs.
• Debugging the issues during month end process, if any issues related to Guidewire policycenter to billingcenter integrations report to the application team.
• Debugging the issue for Guidewire ODS messaging issues.
• Guidewire policy center and billing center integration, we build some reports do identify issues daily bases.
• Working with Guidewire data conversion like renewal conversions.
• Creating SQL to system testing for Flexi month end.
• Creating the view’s by using the requirements.
• Prepared Systems Test Plan and the test cases for the developed mappings.
• Responsible for team members’ work assignment and tracking.
• Data analysis for month end issues and reporting to the user at monthly basis.
• Worked letter bit time for claim data mart creation like Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Involving Informatica upgrade testing.
• 24/7 on call support for production issues.
• Data analysis, debugging the issue and providing the solutions.
• Good with SQL queries, store procedures.

Confidential

Team member

Environment: Languages: .DataStage 7.52

Database: TeradataV2R5, ORACLE 9i

Server: Teradata Server, ORACLE 9i

Tools: ETL,QC, OBIEE reporting.

OS: UNIX

Responsibilities:

• Writing SQL queries and BTEQ Scripts in Teradata database.
• Verifying of data migration from the source to target in various events
• This is OLAP application; I need to verify the data after business transformation.
• Supporting for OBIEE development to identify the key’s at table level.
• Working with OBIEE team to get the requirement and implement in data mart creation.
• Fixing bug to onsite system, providing detailed report and status reports.
• Creating the Data Stage jobs and modifying existing jobs.
• Production support actives as Data verification and incident verifications
• On Site co-ordinations.
• Creation and reviewing of Use Cases (LDM/PDM) and Facts.
• According CR 2634 requirements, I had modified the exiting code for Finance billing fact.
• Data verification and Data Validation by using SQL queries.
• This is OLAP application; I need to verify the data after business transformation.
• BO Testing
• Involved in work estimation process and MPP creation.
• Modify the Mapping document for Finance billing Facet according to CR 2634 requirements.
• See the job monitoring, logs for jobs by using the UNIX commands

Confidential

Team member

Environment: Languages: .DataStage 7.52

Database: TeradataV2R5

Server: Teradata Server

Tools: ETL,QC, Business Objects

OS: UNIX

Responsibilities:

• Writing SQL queries and BTEQ Scripts in Teradata database.
• Verifying of data migration from the source to target in various events
• This is OLAP application; I need to verify the data after business transformation.
• Fixing bug to onsite system, providing detailed report and status reports.
• Creating the Data Stage jobs and modifying existing jobs.
• Production support actives as Data verification and incident verifications
• Designing Mapping document for Finance billing Facet and Geo Facet.
• On Site co-ordinations.
• Direct client communication and attending the war meetings for requirements.
• Perform backup and recovery operations
• Support of production processes
• Support of end user queries
• Identifying Requirements for the change requests.

Confidential

Team member

Environment: Languages: .C++, Java.

Database: SQL Server 2000, Oracle

Server: Web logic

Tools: Soap Tool, QC 8.2

OS: UNIX

Responsibilities:

• Requirement analysis
• Designing test cases based on the requirements.
• Good at oops and AJAX code, and testing experience.
• Onsite co-ordination.
• Put the Log files from Web logic Server corresponding defect.