SUMMARY

• Highly motivated, goal - oriented data warehousing and ETL professional with 10 years of experience in ICT with special expertise in design, development, analysis, administration and implementation of Business Intelligence and data warehousing/data migration projects.
• Well experienced in working Securities, Banking, Insurance DW and Data Migration projects.
• Extensive ETL experience using Informatica Power Centre (9.6/8.6/8.1/8.0 ), Informatica IDQ, SSIS and DataStage Administration and Autosys, Maestro scheduling tools.
• Good Knowledge in MDM, B2B, IDQ Informatica Product tools.
• Worked as Informatica Administrator and migrated from Version 8.6 to 9.6
• Hands on experience in ETL Design and Architect.
• Experienced in Repository configuration and using transformations, creating informatica mappings, mapplets, sessions, Workflows, worklets, processing tasks using Informatica Workflow manager to move data from multiple sources into targets.
• Experience in performance tuning of Informatica (sources, mappings, targets and sessions) and tunning the SQL queries.
• Hands on experience with dimensional modelling, star schema and snowflakes Schema methodologies.
• Responsible for defining the complete data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW).
• Expertise in writing SQL Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Design, development and coding with oracle 11g/10g/9i, SQL Server 2000/2005/2012.
• Assisting Build & Support, ITSMO teams to deploy code to SIT, UAT, PRE-PRODUCTION and PROD environments.
• Worked on DataStage/QualityStage Administration, setting up new DS, WAS, IIS, Servers (DEV, TEST, UAT AND PROD) Systems.
• Strong Knowledge in Creating Unix/Linux shell Scripts.
• An enthusiastic and project-oriented team player with excellent communication skills. Fast learner with a desire to grow skills and expertise.
• Good understanding of business processes / requirements and translating them into technical requirements.
• Attended SAS Memex, i2, ANB, SSIS trainings from authorised training partners.
• Holds Australian Citizen and E3 Work Visa.

TECHNICAL SKILLS

ETL Tools: Informatica Power Centre (9.6/8.6), Informatica Data Quality (IDQ), SAS DI, SSIS, IBM WebSphere DataStage 8.1, BO DS, DI

Languages: C/C++, SQL, PL / SQL, HTML, Java, VB 6.0, XML

Databases: Oracle 9i/10 g/11g, SQL Server 2014/2015/2005 , Teradata

Reporting Tools: OBIEE, BO Universe, COGNOS

Operating Systems: Windows 7.0/NT/2003/XP, UNIX, AIX 6.1, AIX 7.1, SOLARIS 10.0

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Involved in requirements gathering, analysis and attend workshops to finalise requirements scope of various business users for quarterly releases.
• Engage with Business Users and key stakeholders to perform impact analysis of requirements and feasibility study.
• Create, Design/update existing mappings to fit business requirements.
• Create High level and Low- Level Design documents to outline the ETL load process.
• Data Analysis on Source System Data to understand the nature of data loading into EDW and Data Marts layer.
• Design ETL Informatica mappings to pull data from heterogeneous source systems data and load into Data marts and DW.
• Create Mappings, Worklets, sessions and workflows as per requirements to implement logic.
• Perform Tests and validate Workflows to meet requirements and prepare scripts to migrate to higher environments.
• Monitor Daily Production ETL Jobs which source from flat files, xml and DB into DWH.
• Run SQL Queries against Oracle DB & DB2 to verify data load process, if any issues debug and investigate data.
• Debug failed Jobs and resume the load process.
• Unit test and Migrate mappings to TST, UAT and Production environments.
• Prepare and Document Technical DD and onto Share point.
• Manage and co-ordinate CRQ to deploy code in Higher environments.
• Identify and resolve Production issues.
• Work on Remedy tickets

Environment: Informatica 9.6, Oracle11g, DB2, SQL, PL/SQL, SHARE POINT, REMEDY, COGNOS, SOLARIS 10.0

Confidential

Informatica Administrator

Responsibilities:

• Gather Installable and work with INF Consultants to set-up 9.6 INF Server
• Perform pre-requisite checking for Installation
• Install and configure Repository Services, set-up Folders for different applications used in Project.
• Create Domain, Node, and configure repositories for DEV, TEST, UAT and PROD
• Set-up Users, permissions and Privileges on Admin Console.
• Migrate code from old repository to New server.
• Test and Run WF, Sessions on new server.
• Work with testing team to run INF ETL Jobs.
• Co-ordinate and raise CRQ (Change Request) in Remedy tool liaise with different teams on Change.
• Attend Stand up/Scrum meetings and discuss issues of Installation and Upgrade status.
• Run Unix Commands to check the installation status, memory validation, process status, and directory set-up.
• Monitor daily usage space on SOLARIS Servers and housekeeping and archiving the old files.
• Support existing INF 8.6 ETL Jobs.
• Identify and resolve Production issues.

Environment: Informatica 9.6/8.6, INF Admin Console, Oracle11g, DB2, SQL, PL/SQL, SHARE POINT, REMEDY, COGNOS, SOLARIS 10.0

Confidential

ETL & Informatica Developer

Responsibilities:

• Analyse, design, develop, implement and maintain the applications in accordance with Confidential 's systems development methodology.
• Create Low Level and High-level design documents for Quarterly releases.
• Data Analysis on loading new systems data into EDW.
• Work closely with Business users to understand the nature of entities loading into DM.
• Monitor Daily DWH Loads, if any Session fails debug and execute manually and facilitate load.
• Provide Back-end Short Selling report submissions support.
• Develop working code and unit test cases based on functional requirements and technical design to deliver planned scope for the releases.
• Deployment of new code to TST, UAT and Production environments.
• Document new Implementations and Post production support.
• BAU Support of existing Data feeds.
• Provide level 2/3 production support and system maintenance, including analysis and resolution of system problems.
• Bulk data extract support to different Federal and State government agencies.

Environment: Informatica 8.6, Oracle11g, DB2, SQL, PL/SQL, SHARE POINT, REMEDY, COGNOS, SOLARIS 10

Confidential

DataStage/QualityStage Administrator

Responsibilities:

• Plan LPAR for IIS Suite installation
• Collect IIS Installation Suite from IBM Passport
• Install and configure WebSphere and DS Server and Client tools
• Created DS/QS Projects on new server
• Migrate code from old servers to New Server
• Support all migration activities and Report to Project committee.
• Deploy Jobs in IIS console
• Deploy SQL validation scripts and worked on SQL for enhancing the performance of Batch load jobs.
• Verify and validate batch load jobs on Oracle database.
• Document Functional Design specifications and Technical design specifications for migration.
• Schedule Jobs using AUTOSYS Scheduling tool.
• Support E2E, TC testing activities
• Co-ordinate and work with Business Analysts to accommodate changes to requirements.
• Work with ITSMO team to promote code into STG, PROD environments.

Environment: DataStage/QualityStage 11.3, IIS, Windows 7.0, Oracle11g, Autosys, SQL, PL/SQL, Internal Wiki, HPQC/ALM, AIX 6.1

Confidential

Build & Support Deployment Consultant

Responsibilities:

• Execute DLMA Batch Jobs using Autosys Scheduling in Test environments.
• De-bug Jobs fix and support DLMA Interface activities.
• Build and Support Deployment activities
• Release management and co-ordination
• Record count verification DWH backend/reporting queries against source and target as an initial check.
• Schedule Jobs using AUTOSYS Scheduling tool.
• Support E2E, TC testing activities
• Co-ordinate and work with Business Analysts to accommodate changes to requirements.
• Work with ITSMO team to promote code into STG, PROD environments.

Environment: DataStage8.1, IIS, Windows 7.0, Oracle11g, Autosys, SQL, PL/SQL, Internal Wiki, HPQC/ALM, AIX 6.1

Confidential

DataStage/QualityStage Administrator

Responsibilities:

• Verify and perform pre-installation DS/QS installation tasks on AIX servers.
• Install and configure IIS Suite and its components (DS/QS Designer, Director)
• Create and configure DLMA, QS projects folder/directory structures on AIX Server.
• Grant access to DS, QS client components from Administrator tool.
• Deploy and monitor QS online services in IIS Console and configure QS online/real time jobs.
• Configure Java heap size on IIS web console.
• Housekeeping and cleaning log and archive files for DS batch and online jobs.
• Health check batch and online services running on AIX servers.
• Deploy and migrate code on to TEST, UAT, PROFILE environments.
• Work closely with Developers, Architects, Business users and stakeholders on various tasks related to Confidential project execution.
• Extensively worked on UNIX commands to check health of servers and services.

Environment: DataStage8.1, IIS, Windows 7.0, Oracle11g, Autosys, SQL, PL/SQL, Internal Wiki, HPQC/ALM, AIX 6.1

Confidential

ETL Specialist

Responsibilities:

• Participated in discussions with Team leader, Team Members and Data Modeller regarding any Technical and Business Requirement issues.
• Work closely with Report developers and architects to understand E-R Schema designs.
• Perform data analysis on source HOMES Systems and suggest if any anomalies are detected on source data.
• Design and develop DI ETL Jobs involving business rules and data quality from Source (HOMES) to STAGING to EDW then to data marts.
• Developed DI ETL Jobs to extract source data from HOMES System to load target EDW.
• Wrote User-Defined SQL queries for extracting the data from source systems.
• Extensively worked on Error Handling and data reconciliation process.
• Involved in unit, performance and Integration testing of ETL jobs.
• Responsible for documentation of all the ETL jobs.
• Support ETL Jobs to migrate to Production, Execute in ETL in Prod and Post production support.

Environment: BODI 3.1, Windows 7.0, Oracle10g, SQL, PL/SQL, Internal Wiki, HPQC, UNIX, Webi, BO, BO UNIVERSE

Confidential

ETL Consultant

Responsibilities:

• End to End Design and Development Data conversion entities.
• Build TDD/FDD documents.
• Created Informatica ETL mappings, Sessions, Workflows to load Source System files to Siebel CRM system.
• Unit testing and Preparing UT Cases for respective entities.
• Data /UI testing.
• Mock Run executions.
• Working closely with testing team to environment setups and defect resolution.
• Actively involved in finalizing build checklist and execution plan.
• Loading Data into Production System and Post production support.
• Document all process and handover AMS team.

Environment: Informatica 8.1, Windows 2003, Oracle10g, SQL, PL/SQL, HPQC, Siebel 8.0, EIM.

Confidential

Data Migration/ETL Consultant

Responsibilities:

• Designed and developed DTS Jobs to load legacy system data onto Siebel CRM System
• Write SQL Statements to de-duplicate source data and other Migration SQL statements
• Build and create Mock execution and Run statements for load
• Validate and verify load.
• Run EIM Jobs and IFB files to load into Siebel CRM System.
• Front end Siebel UNIT Testing load and working with Testing team to verify the load process
• Work on DataMigration defects and resolution.
• Worked on Onsite-Offshore model supporting the CRM data load.

Environment: DTS 2000, SQL SERVER 2000, Siebel Tools 8.1, Siebel Call Center CRM Application, HPQC, MS Visio

Confidential

Consultant

Responsibilities:

• Monitoring the production load through BWI/EES Interfaces.
• Fixing & Enhancing existing Informatica mappings to load into Siebel CRM System.
• Work with onsite team to work on enhancements and support existing system loads
• Received KT From Onsite and Offshore team
• Debug existing INF Mappings to enhance and load into DEV, TEST ENV
• Post load support and resolving data load tickets.

Environment: Informatica 8.1, Oracle9i, SQL, PL/SQL, MS Access

Confidential

Consultant

Responsibilities:

• FDD/TDD/Design document preparation and developing code for implementing functionality.
• Developed SQL procedures/functions and packages to load Account/contact and its child entities into Siebel database.
• Executing jobs in DIF Framework (for this we need to write .xml files which serves input for DIF Frame work).
• Worked on Informatica expression, Router, Source qualifier, aggregator, and lookup and Normalizer transformations.
• Executing Informatica workflows/sessions.
• Debugging Informatica mappings and Sessions.
• Installing Interfaces in SBLTD, CRMTST, EMEAQA, APJQA, AMSQA, Instances.
• Preparing test case scripts to run EIM Jobs.

Environment: Informatica 8.1, Oracle 9i, PL/SQL, DIF, SQL Developer, Siebel 8.1, HPQC