SUMMARY

• 7+ years of IT industry experience in Data Warehousingprojects.
• Have extensive project experience in INFORMATICA.
• Experience in designing and Developing complex Mappings using InformaticaPower Center with Transformations such as Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Working experience using InformaticaWorkflow Manager to create Sessions, Batches and schedule workflows and Worklets, Re - usable Tasks, Monitoring Sessions, Export & Import of Source, Target, Mappings, Mapplets, Sessions, Worklets and Workflows
• Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, and data Specifications for ETL process into Technical design documents.
• Experience in handling initial/full and incremental loads.
• Practical understanding of Data modeling(Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables data.
• Defect tracking using HP Quality center and Uploading all necessary information related to it.
• Well versed with SQL and PL/SQL and flexible enough to blend into any technology and environment with minimal effort.
• Played a key role in the areas of Development, (Unit/Integration) Testing, Implementation post production Support for various project releases.

TECHNICAL SKILLS

Data Warehouse/ETL Tool: InformaticaPowerCenter/PowerMart(7x, 8x, 9x),Informatica PowerConnect, SQL Developer, Toad, MS VSS 6.0, PVCS, SSH Tectia, Kintana, Hp Quality Center.

Databases: Oracle 9i, 10g, 11g, MS SQL Server 2000, MS Access.

Business Intelligence Tool: Business Objects XiR2

Job Function: Maintenance, Analysis, Programming, Designing, Testing, Documentation, Defects resolution.

Languages: SQL,PL/SQL, C and C++

Scripting: UNIX Shell Scripting

Tools: SQL*Loader, TOAD

Operating Systems: Microsoft 95/98/2000/XP/NT, UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Jose,CA

IT Engineer/ ETLConsultant

Responsibilities:

• Development and enhancement for new release and closing defects which involves technologies such as Informatica (8.6.1 & 9.1) and BO XI/R2, Oracle PLSQL.
• Analyze requirements; verify dependencies and Data validations.
• Job monitoring using Informatica Workflow Monitor (checking session logs for failure analysis).
• Used SSH Tectia for loading source files (.dat) and parameter files in to UNIX box.
• Preparation of test cases/scenarios and execution of the same.
• Evaluation of full release activities through Integration Testing.
• To make sure the code meets both functional and technical aspects with minimal defects.
• Post-Production/Go Live support.
• Peer reviews and provide technical assistance to team members.
• Created mapping that stores historical data which is further used for reporting.
• Worked on web intelligence to edit the reports and to create user required prompts.
• Used debugger to test the mapping and fixed the bugs.
• Experienced in developing mapping using various transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, and Joiner.
• Migration of code between various environments (Dev, Stage/Test, Prod) which involves test runs and data validations.
• Wrote SQL queries for data validation of ETL jobs using TOAD.
• Created triggers and modified existing procedures.
• Worked on Change management system (PVCS) and KINTANA-code deployment tools.
• Preparation of technical documents based on the functional specification/business requirements.
• Used Hp Quality Center in tracking defects and closures.
• Well versed withunit and Integration testing.

Environment: Oracle 10g/11g, Informatica Power center 8.6.1 & 9.1, BO XI/R2,Toad 10x, PVCS, Hp project & Portfolio management (Kintana), Hp quality Center and SSH tectia.

Confidential, Richmond, VA

Sr.Developer

Responsibilities:

• Design and development of Data Warehouse.
• Translation of Business Processes into Informatica mappings for building Data Marts.
• Creating Physical, Logical models of the data warehouse which includes adding tables, fields and creating relationships.
• Coordinating with Business Analyst and Client Managers to resolve gaps.
• Monitoring, schedulingand running Informatica jobs in workflow monitor.
• Minimal defect encounter and quick response to any available defects.
• Developed Informatica mappings and also tuned them for better performance.
• Created event waits and failure emails tasks.
• Resolved failed jobs by identifying the root cause.
• Designed mapplets in Informatica to promote reusability and eliminate coding redundancy.
• Extensively used ETL to load data from relational and flat files to Oracle.
• Documentation of the ETL process with information about various mappings, order of execution and theirinter dependencies.
• Code testing/validation for Data Integrity and Consistency.
• Implemented Aggregate, Filter, Joiner, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.
• Extensively used SQL for data analysis and data validation.
• Acquired knowledge for root cause analysis.

Environment: Oracle 9i/10g, Informatica Power center 7.1/8.6, UNIX, $Universe, Toad 9x, MS VSS 6.0

Confidential, Denver, CO

Developer

Responsibilities:

• Create Logical and Physical design of SIOP data model.
• Working with Business Analyst to understand the business requirements and to design data flow.
• Extensive usage of Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Understanding requirements and customizing the system to meet the requirements.
• Troubleshooting Informatica Mappings.
• Developed mappings and reusable objects.
• Designed and delivered Informatica mappings, mapplets, reusable sessions and workflows.
• Implemented JM’s complex business logic into Informatica mappings for UPC Code and Stock Transfer ratio.
• Worked with Customer Master Team to get the customer data for better functional understanding.
• Documented technical specifications, complete load process and application support guide.
• Developed new mappings to handle incremental load and full loads.
• Performed Data Validationsusing SQL.
• Unit test cases/scenarios, test documentation and execution of the same.
• Closed defects based on the priority/severity and performed data validation during QA phase.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL Server, Toad, UNIX, MS VSS 6.0.

Confidential, Overland Park, KS

Trainee/Engineer

Responsibilities:

• Through understanding of functional specification provided by analysts.
• Involve in end user requirements gathering and analysis for the reports.
• Provide weekly status reports to the lead.
• Data validation using sequel queries.
• Created mapplets and reusable transformations.
• Configured session properties and target options.
• Created universes using Business Objects Designer.
• Created Hierarchies in the Universes to provide drill down options for the end-user.
• Generated different types of reports using Business Objects Web Intelligence tool.

Environment: Informatica Power Center 6.1, UNIX, Oracle 8i, PL/SQL, Business Objects.