SUMMARY:

• 6+ years of Information Technology experience covering phases of the System Development and Testing.
• Involved in Development of Data Warehouse, Business intelligence applications such as Informatica with strong business understanding knowledge of Retail Services Domain and Health Care Domain.
• Experience in Data Warehousing Using Informatica 9.1.1/ 8.6.1/8.1.1/7. 1.
• Strong Data Warehousing and Data Integration experience in using Informatica Power Center different versions (Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Solid expertise in using ETL Scheduling tools.
• Working with Informatica Power Exchange to extract data from AS/400 Application.
• Implemented Informatica Change Data Capture on Oracle database.
• Good Experience in Informatica upgrades and installations.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good understanding of RDBMS concepts and experience in writing queries, procedures & scripts using Oracle, SQL Server, MY SQL and DB2.
• Excellent Client handling ability with good presentation skills.
• Experience in Installation and configuration, Creation of repositories with user groups and security implementation.
• Excellent soft skills such as leadership, communication, organization, time management, crisis management, multi - tasking, and people-management.
• An excellent team player with a track record for meeting strict deadlines.
• Extensive experience in data warehousing testing like SIT, UAT and PAT.
• Keen understanding of Data warehousing concepts and dimensional modeling.
• Excellent Analytical and Problem Solving Skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x.x/ 8.6.1/8.1.1/7. x

Operating Systems: Windows 98, NT/2000, UNIX

Databases: Oracle10g, SQL Server, MySql

Query Tools: TOAD

Languages: SQL, PL/SQL, UNIX Shell Scripting

Source Control: Sub version (SVN)

Scheduling Tools: Job Scheduler

PROFESSIONAL EXPERIENCE:

Confidential

Sr Informatica Developer

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Analyzed the issues and providing the solutions to dev and test teams.
• Involved in optimization to identify the bottlenecks for the existing jobs.
• Complex Business Rules are implemented to identify error records.
• Develop debugging and testing mechanism for the data flow mappings.
• Developing complex SCD-2 dimension processes.
• Prepared test scripts and reviewed the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.
• Good experience running the workflows by using PMCMD commands.
• Good experience to work with different task such as Session, Command, Event wait, Event Raise, Timer, Assignment etc.
• Performed Unit testing and Performance Tuning testing.

Environment: Informatica 9.1, Oracle 10g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Confidential, Jacksonville, FL

Informatica Developer

Responsibilities:

• Extracted data as flat file from GSI and DB2 database, applied business logic to load them in the Standardization area, Central Repository and all the way to data marts and flat files.
• Interacted with the Business users Data architects in gathering the requirements and finding the data needs.
• Participate in the discussions with the business solutions team in creating and implementing the plans for the designs like Flow Chart diagrams, Conceptual and Logical Diagrams, and defining the terms on the needs of the project.
• Create the data results through techniques and tools such as basic SQL queries, data mining, and multidimensional analysis.
• Designed the mappings and workflows and implemented the logic using the transformations.
• Created Packages and triggers in PL/SQL
• Created mappings using PL/SQL package to implement business rules while loading the data from staging to warehouse.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update Strategy, and Joiner
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Maintained Sequential load through ROBOT job scheduler.
• Tuning the SQL queries as required. Created the PL/SQL Stored procedures, Indexes, Views.
• Performed unit testing and documented the results.
• Worked closely with QA team during the testing phase and fixed bugs that were reported
• Designed the Build Docs of the entire release/ project for the production support.

Environment: Informatica 9.1.1/8.6.1, Oracle 10g, UNIX.

Confidential

Informatica developer

Responsibilities:

• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Designed Informatica mappings by translating the business requirements.
• Studied Session Log files to correct errors in mappings and sessions.
• Wrote pre session and post session scripts in mappings.
• Performed data manipulation using basic functions and Informatica Transformation.
• Understanding the Functional Team requirements & specifications.
• Complex Business Rules are implemented to identify error records.
• Develop debugging and testing mechanism for the data flow mappings.
• Need to respond to user’s request and clarifying their doubts Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.

Environment: Informatica 8.6, Oracle 10g, Toad, PL/SQL, Flat Files, XML Files, Putty, Windows NT, UNIX.

Confidential

Bioinformatics Research Scientist

Responsibilities:

• Planned and completed complex research procedures using bioinformatics, data analysis and ontology development techniques
• Co-ordinated multi-disciplinary research teams and oversees daily operations of projects.
• Oversee organization, synthesis and analysis of findings.
• Reviewed research methodologies, planned developed and composed protocols for implementation, assessment, testing, cost effectiveness, and quality.
• Prepared scientific reports, outcome findings and scientific manuscripts. Assisted in outcome interpretation and composition of the results sections of manuscripts and reports.
• Participated in meetings with various project groups and research staff and evaluated/interpreted the validity of technology and intellectual property
• Presented innovation/technology to target audience at various conferences