Professional Summary:

Total 9 years of professional IT experience in the fields of Application Design, Development, Implementation and Migrations in Data Warehousing specifically in the areas of Informatica, Oracle and UNIX.

Professional Expertise:

• Extensively worked in various areas of Oracle, UNIX, and Informatica Power center.
• Good experience in key functions including designing, developing, testing, debugging, supporting and documenting ETL processes for enterprise-wide Data Warehouse implementations.
• Involved in the analysis, design, and development of data warehousing and business intelligence components so as to ensure end-to-end solutions quality and a high level of customer satisfaction.
• Provided technical and functional troubleshooting of software bugs and performance issues related to data warehousing and business intelligence applications.
• Met with customers to gather and/or clarify requirements associated with a data warehousing or business intelligence deliverables.
• Perform detailed analysis and documentation and assist in determining the best solution for meeting the needs of the customer.
• Cooperatively shared technical and functional knowledge with other staff in the department or on a project team.
• Followed department policies on the software development lifecycle, source code control, and change management. Interface directly with users, developers and other IT staff.
• Experience with all aspects of Project Development life cycle from Analysis, Modeling, Design, Implementation and Testing.
• Proficient in Data warehousing concepts including Datamart, Data mining using dimensional modeling star schema, snowflake schema design
• Strong understanding of Relational Database concepts.
• Excellent analytical trouble shooting abilities.
• Highly familiar with Onsite-Offshore model and Team based development.
• Coordinated and mentored offshore for various design reviews and Production issues.
• Experience with SQL and PL/SQL for testing Database integrity/Data validation.
• Excellent knowledge of Quality assurance and SDLC Process.
• Extensively worked on Informatica Tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively worked on Migration of Mappings/workflows.
• Solid experience in ETL and Data Warehousing methods and technologies.
• Highly familiar with monitoring activities viz, session monitoring and memory usage.
• Good debugging abilities of Informatica mappings, workflows/sessions.
• Extensive experience in creating the Mapping Specification Documents to develop complex Mappings.
• Good Exposure on AML and BSA compliances..
• Extensively worked on UNIX and shell scripting.
• Involved in Unit and Integration testing of the mappings.
• Extensive support provided during UAT Testing of application.
• Good experience in HP-Quality Center tool.
• Schedule, Run, Load processes and monitor sessions by using Informatica workflow manager and workflow monitor.
• Extensively worked with XMLs as source and Target.
• Very good exposure on Informatica Admin activities.
• Good Knowledge on XML Parser and XML Generator transformation.
• Sound knowledge on Web Services transformation and Web URL as source.
• Worked with Flat files and different source systems

Technical Expertise:

• ETL Tools : Informatica Power Center 7.x/8.6.1/9.0
• OLAP Tools : Business Objects
• Database : Oracle 9i/10.0, Teradata, DB2
• Batch Scheduling Tool : TWS Tivoli
• Programming Languages : C, C , VB 6.0, SQL /PL SQL
• Operating Systems : Windows NT/XP/2000, UNIX Shell Scripting.
• Tools : SQL Developer, TOAD, Citrix,
• Erwin Data Modeler

Project Details:

Confidential

• Create and Run Jobs according to the requirement.
• Good experience in gathering the requirements and data analysis.
• Provided Performance Tuning methods in Informatica with large volumes of data load.
• Extracted data from different data sources like DB2, Oracle and Flat files.
• Experience in the design and development of ETL processes involving multiple sources, including validation and transformation routines using industry standard tools.
• Used the various transformations like Source Qualifier, Looks up Dynamic Look up and Static lookups , Aggregator, Union etc... To transform the data.
• Created Mapping parameters and mapping variables to automate the mappings.
• Diagnosed and resolved ETL performance issues using the debugger tool.
• Develop strategic testing plans to achieve performance quality by coordinating with the project manager.
• In Workflow Manager, have created dev. Oracle connections and created parallel execution of workflows for different releases.
• Created workflow parameters, session parameters and reusable email task notifications.
• Workflow Monitor used to monitor load and check stats.
• Created UNIX shell scripts to get the files form FTP server and to process through Informatica jobs.
• Review testing documentation to ensure it met software development and testing standards.
• Provide recommendations to improve testing process for supporting quality assurance initiatives.
• Develop software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance.
• Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.

Environment: Oracle 11, SQLserver, DB2, UNIX, TWS Tivoli's Job Scheduling tool , Informatica power center 9.0.

Confidential

Responsibilities:

• Understanding the existing Business Process.

• Good understanding of logical and physical database design / modeling.
• Extracted data requirements from SMEs subject matter experts and implemented through workflows and code.
• Performed ETL Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.
• Maintained existing data warehousing and business intelligence applications and processes using software development products.
• Coordinate with Business Analysts to understand the Business and Scope of work.
• Interaction with client on weekly basis or as required.
• Development of new mappings using Oracle Warehouse Builder.
• Assign tasks to team and follow it up till completion.
• Design and Development of data warehouse solutions with BIDS.
• Resolving technical issues when situation demands
• Using CA TOOL to do defect tracking and to ensure quality in all phases of project deliveries.
• Using ASSENT in project activities for coding and code review.
• Unit testing, System Testing, and Performance Testing of the Interfaces, tracking and defect fixing.
• Provide Post Production Support and monitoring jobs.

Environment: OWB, Oracle, UNIX.

Confidential

Responsibilities:

• Understanding the existing Business Process.

• Good understanding of logical and physical database design / modeling.
• Extracted data requirements from SMEs subject matter experts and implemented through workflows and code.
• Performed ETL Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.
• Maintained existing data warehousing and business intelligence applications and processes using software development products.
• Tested and implemented new application components and processes for data warehousing and business intelligence environments while adhering to industry standard methodologies and processes.
• Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.
• Involved in PL-SQL development to support ETL Informatica design and analysis.
• Found and fixed problems to stored procedures.
• Experience in the design and development of ETL processes involving multiple sources, including validation and transformation routines using industry standard tools.
• Experience demonstrated in ETL best practices lineage tracking, transformation, data validation, audit reporting .
• Diagnosed and resolved ETL performance issues.
• Designed and developed ETL processes to meet requirements.
• Debugged Data Stage ETL processes and tune performance, as needed.
• Provided assistance with ETL standards and design for future supportability and ease of enhancements.
• Developed and applied design patterns for reusable ETL components.
• Demonstrated knowledge of dimensional data models.
• Demonstrated knowledge of dealing with slowly changing dimensions.
• Demonstrated knowledge of security implementation in BI solutions, including user access security.
• Have the ability to read previous execution plans and tailor new requirements for ETL.
• Have the ability to work / query across many databases / servers.
• Possess the ability to successfully interact with all levels of internal and external clients.

• Debug and analyze various issues and apply appropriate fixes. This involves extensively working on Informatica mappings, workflows, session logs and fetching the data from Oracle/Teradata.

• Had Strong SQL skills for ETL flows and code for new integrations.
• Debugged/Analyzed the PL/SQL Scripts to find out the solution for fixes.
• Experience conducting unit testing of ETL code as well as experience with Oracle and Flat Files.
• Checking the Error log files through UNIX for different jobs and solve the issues.
• Analyzing the root cause for failure of jobs and fix it if it is temporary.

Environment: Informatica Powercenter 7.1.3, Power Designer 11.5, Oracle, Sybase UNIX.

Confidential

Responsibilities:

• Understanding the existing Business Process.

• Good understanding of logical and physical database design / modeling.
• Performed ETL Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.
• Involved in PL-SQL development to support ETL Informatica design and analysis.
• Found and fixed problems to stored procedures.
• Provided Performance Tuning methods in Informatica with large volumes of data load.
• Demonstrated in-depth understanding of Data migration and ETL concepts, ETL loading strategy, Data archiving, and Data reconciliation, using Informatica tools.
• Developed and enforced systems design/coding standards.
• Assigned and reviewed the work of other developers.
• Consulted with SME's Subject Matter Experts and technical experts to review and finalize solution design.
• Developed data migration strategies and procedures for production deployment. Designed and configured stored procedures, constraints, indexes, cursors using established PL/SQL Server coding conventions.
• Experienced with Mapping design, Mapplet design, Workflow, Process Monitoring, Configuration settings, Performance tuning and Optimization.
• Experienced with variousXML Schema.
• Have the ability to read previous execution plans and tailor new requirements for ETL.
• Designed and configured stored procedures, constraints, indexes, and cursors using established SQL Server coding conventions.
• Have the ability to work / query across many databases / servers.
• Possess the ability to successfully interact with all levels of internal and external clients.
• Debug and analyze various issues and apply appropriate fixes. This involves extensively working on Informatica mappings, workflows, session logs and fetching the data from Teradata.
• Had Strong SQL skills for ETL flows and code for new integrations.
• Experience conducting unit testing of ETL .
• Review Informatica mappings, workflows.
• Debug Informatica workflows and fix the issues.
• Running workflows through workflow monitor and checking the status.
• Worked on performance tuning to increase performance using advanced mapping and workflow techniques.
• Checking the Error log files through UNIX for different jobs and solve the issues.
• Running Fastload, Multiload, and TPUMP Scripts to recover failed loads.
• Analyzing the root cause for failure of jobs and fix it if it is temporary.
• Monitoring, scheduling the jobs and bug fixing in QA using WCC Workload Control Centre .
• Reviews and Deployment of code from Dev to QA environment and from QA to Production environment.
• Performed administration activities such as user access accounts, roles, setting standards, etc.
• Familiar with code/folder migration from one environment to another as part of release management process.
• Extensively worked on creating transformations XML, unconnected lookup, Normalizer and mappings using Informatica PowerCenter and processing tasks using Workflow Manager to move data from multiple sources into targets.

Environment: Informatica Powercenter 7.1.3, Teradata, Windows NT, UNIX.

Confidential

Responsibilities:

• Understanding the existing Business Process.

• Good understanding of logical and physical database design / modeling.
• Performed ETL Error Handling, Error logging mechanism by going through Error Log files from Informatica Workflow Monitor.
• Tested and implemented new application components and processes for data warehousing and business intelligence environments while adhering to industry standard methodologies and processes.
• Developed software components and solutions that adhere to development standards and are accurate, efficient, and maintainable.
• Experience in the design and development of ETL processes involving multiple sources, including validation and transformation routines using industry standard tools.
• Experience demonstrated in ETL best practices lineage tracking, transformation, data validation, audit reporting .
• Designed and developed ETL processes to meet requirements.
• Debugged Data Stage ETL processes and tune performance, as needed.
• Provided assistance with ETL standards and design for future supportability and ease of enhancements.
• Demonstrated knowledge of dealing with slowly changing dimensions.
• Demonstrated knowledge of security implementation in BI solutions, including user access security.
• Have the ability to read previous execution plans and tailor new requirements for ETL.
• Have the ability to work / query across many databases / servers.
• Possess the ability to successfully interact with all levels of internal and external clients.

• Debug and analyze various issues and apply appropriate fixes. This involves extensively working on Informatica mappings, workflows, session logs and fetching the data from Oracle/Teradata.

• Had Strong SQL skills for ETL flows and code for new integrations.
• Debugged/Analyzed the PL/SQL Scripts to find out the solution for fixes.
• Experience conducting unit testing of ETL code as well as experience with Oracle and Flat Files.

Environment: Informatica Powercenter, Power Designer 11.5, Oracle, Sybase UNIX.

Confidential

Responsibilities:

• Involved in analysis of Factual Migration
• Involved in Documentation
• Preparing the blue print documents and Estimation
• Design and Development of data warehouse solutions with BIDS.
• Coding and code review using ASSENT.
• Involved in defect tracking using CA TOOL to ensure quality in all phases of project deliveries.
• Prepared release documents.
• Running workflows through workflow monitor and checking the status.
• Checking the Error log files through UNIX for different jobs and solve the issues.

Environment: Informatica Powercenter 7.1, Oracle.

Confidential

Responsibilities:

• Understanding the existing Business Process. Studying the existing system and review it.
• Check the existing SQL DTS Packages.
• Running workflows through workflow monitor and checking the status.
• Checking the Error log files through UNIX for different jobs and solve the issues.
• Analyzing the root cause for failure of jobs and fix it if it is temporary.
• Escalating to different teams like SQL Server DBA with whomever the issue is related for a permanent fix.
• Monitoring, scheduling the jobs and bug fixing in QA .
• Review and Deployment of code
• Uploading all the Release related documents into DocSpace.
• Ensuring the completion of jobs and communicating with the users in case of delays and failures.

Environment: Informatica Powercenter 7.1, SQL Server, SQL Developer, UNIX.