SUMMARY:

Confidential is an IT professional with more than 10 years of experience in designing developing and implementing software applications. Over 2 years of experience in leading technical teams. Solid experience in Health care, Procurement, Sales and Retail domain. Strong analytical and debugging skills, with proven ability to understand business problems and apply technology to propose and formulate workable solutions. Excellent customer facing skills and a good team player.

CORE COMPETENCIES AND STRENGTHS:

• Worked as Informatica Developer with special emphasis on design development of Data Warehousing, Data Modeling and Relational Database Systems using Business Intelligence, DW and ETL tools. Has been involved in major Data warehousing projects as Designer which involves millions of transactions every day.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Excellent working experience with Informatica Power Center transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with various sources and targets like relational tables, flat files, XML Editor Etc.
• Extensively used and developed shared sessions, mapplets and transformations.
• Strong in using workflow tasks like Session, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session and Pre/Post commands.
• Strong Experience working with Snowflake schema, Star schema architectures.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions and Relational Databases.
• Experience in all levels of performance tuning of Informatica Sources, Targets, Mappings, Transformations, Sessions Workflows and SQL queries.
• Experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Experience in creation of UNIX AIX scripts for automation of Data warehouse specific tasks like file movement and file watching scripts.
• Experience in integration of various data sources like Oracle, DB2, SQL server and MS access into staging area.
• Worked on SCD Type1, SCD Type 2, and SCD Type 3 and their implementations to keep track of historical data.
• Experience in providing troubleshooting and Postproduction support.
• Experience in design, construction, testing, and administration of Enterprise Data Warehouses, Data Marts and Data integration.
• Good experience installing and configuring Informatica Server, creating Repositories, Folders, Groups, and Users and assigning privileges etc.
• Scheduling tools include ControlM/Autosys.
• Strong analytical and debugging skills, with proven ability to understand business problems and apply technology to propose and formulate workable solutions. Excellent customer facing skills and a good team player.
• Experience working in an Agile environment to account for daily tasks. Ability to work independently.
• Microsoft Certified Professional MCP in Windows 2000 Professional.
• Microsoft Certified Professional MCP in Windows 2000 Server.
• Certified Lotus Professional CLP R5, R6, R7 Development.

TECHNICAL SKILLS

Databases: Oracle 8/8i/9i/10g/11g , Sybase, Teradata, MS SQL Server 2000/2003/2005/2008,MS Access, Flat files, Ms Excel, DB2,MySQL

ETL/BI Tools: Informatica Power Center 9.0.1, 8.6, 8.1, 7.1.2, 6.2.2 Repository Manager, Designer, Workflow Monitor, Workflow Manager , COGNOS

Languages: SQL, PL/SQL, Unix Shell Script, HTML, JavaScript, VB, Lotus script, Formula Language

Tools: TOAD, VSS, MS Share Point,RapidSQL,WinSQL, soapUI 4.5.1,

Operating Systems: Windows 98/NT/2000/XP, UNIX, AIX

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Understanding the Business requirements from the ETL point of view.
• Prepared strategy, scoped, collected business requirements, analyzed the process to be modeled.
• Mainly involved in the implementation of Web Services developed by CAS.
• Created mappings which involves complex logic using transformations Web Services Consumer transformation, lookups, joiners etc,.
• Extensive working knowledge and troubleshooting Web Services with respect to Informatica.
• Extensive knowledge on WSDL architecture, SOAP concepts.
• Extensively worked on XML source and Targets.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL queries optimization.
• Worked on creating SQL queries, stored procedures.
• Worked on Teradata SQL assistant and Teradata utilities BTEQ, Fastload, Multiload.
• Automated the jobs through scheduling using built in Informatica scheduler, which runs every day by maintaining the data validations.
• Responsible for performing the unit test at various levels of the ETL.
• Fair knowledge in Informatica Data Quality.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Post-production support..

Environment: Informatica Power center 9.1, soapUI 4.5.1, UNIX, DB2, Teradata 13, Microsoft SQL 2008, Oracle 11g, Informatica MDM 9.5,Crystal Reports.

Confidential

Informatica Developer

Responsibilities:

• Gathered user requirements, created design documents, test cases and Installation procedure documentation for the applications I worked on.
• Preparing the documentations for the ETL process.
• Loading data to staging table.
• Creating the dimension tables and fact table working along with the DB developer.
• Provided Performance tuning of workflows using materialized views, post and pre scripts, performing session level tuning of lookups, performance tuning of SQL queries in lookups and source
• Developing technical designs, Informatica mappings, workflows, concurrent workflows and stored procedures based on ETL Specification.
• Created complex materialized views, stored procedures to increase the performance on the database side
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.
• Created Informatica mappings to load from several sources like flat files, DB/2, Oracle, SQL Server to Oracle database.

Environment: Informatica Power Center 9.0.1, IBM DB2, SQL, PL/SQL, Windows 2000/XP

Confidential

Informatica Developer

Responsibilities:

• Analyzed and designed Informatica workflows to extract data from multiple sources like Oracle, Flat files .dat and SQL Server to generate feeds, data load files.
• Used Stored procedures, Filter, Connected lookup, Source Qualifier, Aggregator, Sorter transformations to efficiently populate Target tables.
• Created scripts to load balance between several Informatica Servers.
• Wrote SQL, PL/SQL codes, stored procedures and packages.
• Provided performance tuning for Informatica mappings and SQL queries.
• Assisted Testing team in designing test cases and also provided support during the Testing Phase.

Environment: Informatica Power Center 8.1, MS SQL,Oracle ,Sybase, COGNOS 8.0, SQL,Windows XP,Windows 2000 server,UNIX.

Confidential

Software Engineer / Informatica Developer

Responsibilities:

• Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Analyze and design Informatica workflows to extract data from multiple sources like DB2 and MS SQL to generate feeds, data load files.
• Used session partitions, dynamic cache memory, and index cache to improve the performance
• Moving workflows between environments using XML export/import feature.
• Involved in developing requirements document, and ETL specifications.
• Documented the mappings used in ETL processes.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Environment: Informatica Power Center 7.1.2, MS SQL,Sybase, SQL, PL/SQL, Windows 2000

Confidential

Software Engineer / Informatica Developer

Responsibilities:

• Analyze and design Informatica workflows to extract data from multiple sources like DB2 and MS SQL to generate feeds, data load files.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Moving workflows between environments using XML export/import feature.
• Involved in developing requirements document, and ETL specifications.
• Documented the mappings used in ETL processes.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance.

Environment: Informatica Power Center 6.2.2, Toad, , SQL Server,MySQL, MS Visio, Teradata, Windows 2000

Confidential

Software Engineer/ Lotus Notes Application Developer

Responsibilities:

• Working closely with the customer to understand the requirements thoroughly.
• Making the requirements document
• Developing test plans test scenarios and test cases based on functional requirements.
• Project Document reviews and rework.
• Managing version controls using the IBM Rational Portfolio Manager as part of IBM quality process.
• The application development, unit testing.
• Report, fix, log and verify incidents/bugs.
• Assisting the business users in UAT.
• Assisting the Build Manager in Move to production.

Confidential

Software Engineer

Responsibilities:

• Production support for DWH and lotus notes applications.
• Customer interaction.
• SPOC for the lotus notes application issues.
• Project Document reviews and rework.

Confidential

Software Engineer/ Lotus Notes Application Developer

Responsibilities:

• Working closely with the customer to understand the requirements thoroughly.
• Making the requirements document
• Developing test plans test scenarios and test cases based on functional requirements.
• Project Document reviews and rework.
• Managing version controls using the IBM Rational Portfolio Manager as part of IBM quality process.
• The application development, unit testing.
• Report, fix, log and verify incidents/bugs.
• Assisting the business users in UAT.
• Assisting the Build Manager in Move to production.

Environment: Lotus Script, Formula, IBM DB2, LEI 7.1, IBM DB2, SQL, Windows 2000, AIX.

Confidential

IT Trainee/Desktop Support Analyst Trainee.

Responsibilities:

• Assisting internal customers to resolve OS and network related issues.
• Installation, Configuration and Troubleshooting of Operating Systems, Windows NT, Windows 2000
• Installation, of Lotus Domino Servers.
• Implementation of Remote Installation Server Windows 2000
• Installation and Troubleshooting of Lotus Notes Client.
• Installation, Configuration and Trouble shooting of Applications on Windows NT, Windows 2000.
• Mass installations of Operating systems with imaging utilities Ghost Power Quest