PROFESSIONAL SUMMARY:

• Over 9 years of experience in IT industry with thorough knowledge of data - integration, ETL design and data-architecture,business-intelligence-applications,data governance,ETL-testing and quality assurance.
• Extensive hands-on experience in development of ETL program using Informatica Power Center applications and achieving performance optimization.
• Good knowledge of Enterprise-Data-Architecture and its design-methodologies including Dimensional and Relational Data-Modelling.
• Excellent exposure to business-requirement-analysis,designing and documentation of Functional-specification and Technical-architecture artifacts.
• Extensive experience in Informatica Powercenter 9.X/8.X/7.X application,Oracle 10g/11g,PL/SQL,Facets,TOAD application and have good expertise in SQL programming.
• Extensive hands-on experience in design and development of ETL architecture with strong leadership ability and technical knowledge.
• Extensive experience in ETL testing using Quality Center (ALM) application. Efficient in writing and executing test cases and performing data validation
• Detailed knowledge of Conceptual, Logical and Physical data models and their related best practice and standards.
• Responsible for preparation of project documentation such as Project Charter, Business Requirement Document Technical Architecture Document and Functional Specification Documents.
• In-depth understanding of Enterprise Data Architecture methodologies using Industry standard tools like ER/Studio Data Architect and ERWin.
• Efficient in creating Use Cases using Unified Modeling Language (UML) diagram, Activity diagrams, Class diagrams and Sequence diagrams.
• Good expertise in Teradata utilities ( Fast Load, Multi Load, BTEQ etc.) and certain tools like Embarcadero DBArtisan, Toad, Rapid SQL 7.4 and Facets 4.7
• Excellent exposure to Operating Systems like Windows 7/XP/2000 Server/NT and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Orlando, Florida

Senior Informatica-Development Analyst

Responsibilities:

• Requirement elicitation and feasibility study with client’s stake-holders and Subject-Matter-Experts to understand the business and analytical-content needs. Assist in analysis and documentation of these requirements, resolving ambiguities and conflicts and ensuring requirements are signed-off in a given ETL scope.
• Impact analysis of exisitng systems and client-applications.
• Analyze functional specifications and translate them into technical design document.
• Design and review ETL Data Mapping-specification with the SME’s, Data Architects and Technology Specialists.
• Responsible for designing ETL architecture using Informatica Power Center applications in Unix and Windows environments.
• Development of complex ETL program using Informatica Power Center,performance-optimatization of Informatica program and organizing implementation-planning and workflow-scheduling.
• Extensive hands-on exposure to most of the Informatica Power Center Transformations including LDAP-application qualifiers, mapplet, SQL transformation, Stored Procedure, XML transformation, CDC and other regular transformations.
• Thorough knowledge and hands-on experience of handling Power Center workflow/mapping parameters and variables.
• Conduct and support Change Control process during production-roll-out phase and responsible for production support and enhancements.
• Development and optimization of PL/SQL program.
• Perform data validation and defect management as part of QA exercise by writing test cases, executing those test cases and supporting User-acceptance-testing.
• Design and Review relational and dimensional data models, document metadata process and details relevant to technical specifications.
• Research, analyze and recommend ‘Information-Integration’ strategies across hospital-management systems and integrated-health-care systems.

Confidential, Orlando, Florida

Senior ETL-Data Architect

Responsibilities:

• Requirement elicitation and feasibility study with client’s stake-holders and Subject-Matter-Experts to understand the business and analytical-content needs. Assist in analysis and documentation of these requirements, resolving ambiguities and conflicts and ensuring requirements are signed-off in a given ETL scope.
• Analyze functional specifications and translate them into technical design document.
• Design and review ETL Data Mapping-specification with the SME’s, Data Architects, Development team and Technology Specialists.
• Responsible for designing ETL architecture using Informatica Power Center applications in Unix and Windows environments.
• Development of complex ETL program using Informatica Power Center,performance-optimatization of Informatica program and organizing implementation-planning and workflow-scheduling.
• Extensive hands-on exposure to most of the Informatica Power Center Transformations including LDAP-application qualifiers, mapplet, SQL transformation, Stored Procedure, XML transformation, CDC and other regular transformations.
• Thorough knowledge and hands-on experience of handling Power Center workflow/mapping parameters and variables.
• Organize implementation-planning,Change control process and workflow-scheduling as per business-requirement.
• Development and optimization of PL/SQL program.
• Design and publish relational and dimensional data models by conducting data-model-review sessions with Data-Architects and Database-Administrators
• Perform data validation and defect management as part of QA exercise by writing test cases,test-execution-steps and executing the test cases using Quality Center application.
• Responsible for driving code-deployment effort by coordinating configuration-control process during the implementation phase.
• Responsible for Post-Production-support and supporting new enhancements.

Confidential, Milwaukee, Wisconsin

Senior ETL Architect

Responsibilities:

• Requirement elicitation and feasibility study with client’s stake-holders and Subject-Matter-Experts to understand the business and analytical content needs. Assist in documenting business requirements and ensuring requirements are signed off in a given ETL scope.
• Design logical and physical data models, document metadata process and detail relevant technical specifications.
• Analyze functional specifications and translate them into technical design document.
• Define and Review ETL Data-Mapping-specification with the SME’s and Data Architects.
• Responsible for ETL-program development using Informatica Power Center applications and organizing workflow scheduling.
• Development of complex ETL program using Informatica Power Center,performance-optimatization of Informatica program and organizing implementation-planning and workflow-scheduling.
• Extensive hands-on exposure to most of the Informatica Power Center Transformations including LDAP-application qualifiers, mapplet, SQL transformation, Stored Procedure, XML transformation, CDC and other regular transformations.
• Thorough knowledge and hands-on experience of handling Power Center workflow/mapping parameters and variables.
• Responsible for installation and upgradation of ER/Studio Data Architect 9.5.
• Responsible for designing ETL architecture to implement Informatica workflows in Unix and Windows environments.
• Development and optimization of SQL program.
• Leading team members in development, execution and documentation of system and integration test plans.
• Perform defect management and data validation using Quality Center application.
• Responsible for writing test cases, designing test scenarios and executing the test cases to facilitate ETL testing.
• Practice and monitor appropriate nomenclature for technical granularities such as
• Naming standard for ETL program
• Informatica Power Center objects and parameters
• Data-Modelling Method ( Relational and Dimensional data modeling )
• Database-Object naming standards
• Data-Type standards

Confidential, Miami

ETL-Data Architect

Responsibilities:

• Analyze and study existing system by consulting with Business analyst/SME’s to understand and capture the requirements.
• Detailed understating of existing functionality to evaluate the impact of new changes on the existing system.
• Responsible for preparing Functional Specification document and translating it to Technical Specification document.
• Design the data architecture and modeling business entities
• Insure consistency of attribute/column naming and defining them across the enterprise.
• Responsible for design and development of ETL architecture
• Development of complex ETL program using Informatica Power Center,performance-optimatization of Informatica program and organizing implementation-planning and workflow-scheduling.
• Extensive hands-on exposure to most of the Informatica Power Center Transformations including LDAP-application qualifiers, mapplet, SQL transformation, Stored Procedure, XML transformation, CDC and other regular transformations.
• Thorough knowledge and hands-on experience of handling Power Center workflow/mapping parameters and variables.
• Review logical and physical data model with the Application development/delivery team, data architects and the assigned Database Administrators
• Design and development of ETL program complying to best-practice standdars.
• Perform Informatica code-optimization and develop SQL program.
• Responsible for Informatica code-migration and designing Production/QA deployment plans and as per client’s standards and policies.
• Perform defect management and data validation using Quality Center application.
• Responsible for writing test cases, designing test scenarios and executing the test cases to facilitate ETL testing.
• Preparation of Knowledge-Transfer documents to transition new members and help others understand the functionality.
• Leading offshore members during development anf testing ETL program, addressing critical issues, reviewing the code and conducting performance optimization.

Confidential

ETL Data-Architect

Responsibilities:

• Requirement elicitation and study existing system and applications to understand and capture the requirements.
• Detailed understating of existing functionality to evaluate the impact of new changes on the existing system.
• Responsible for preparing Functional Specification document and translating it to Technical Specification document.
• Design the data architecture and modeling business entities
• Insure consistency of attribute/column naming and defining them across the enterprise.
• Responsible for design and development of ETL architecture
• Review logical and physical data model with the Application development/delivery team, data architects and the assigned Database Administrators
• Design and development of ETL program complying to best-practice standdars.
• Perform Informatica code-optimization and develop SQL program.
• Responsible for Informatica code-migration and designing Production/QA deployment plans and as per client’s standards and policies.
• Perform defect management and data validation using Quality Center application.
• Responsible for writing test cases, designing test scenarios and executing the test cases to facilitate ETL testing.
• Preparation of Knowledge-Transfer documents to transition new members and help others understand the functionality.
• Leading offshore members during development anf testing ETL program, addressing critical issues, reviewing the code and conducting performance optimization.
• Perform Effort Estimation and generation of project plan.

Confidential, Atlanta,Georgia

Senior ETL Developer

Responsibilities:

• Elicitation of business requirements through discussion-sessions with business analysts.
• Responsible for Requirement Analysis and Feasibility Study
• Conducting requirements-review sessions with the business-users, system-analysts and other stakeholders.
• Designing data architecture and publishing logical and physical data models along with the DDL’s for the Development team.
• Design and development of ETL Architecture and preparation of data-mapping specification document.
• Desgin and development of ETL program using Informatica Power Center application.
• Perform Informatica code-optimization and develop SQL program.
• Responsible for leading ETL-testing effort by reviewing test cases and test plans.
• Key facilitator within an organization, between the client, stakeholders, Business, IT and the solution architecture team.
• Maintaining a positive working environment where all team members were encouraged to communicate in an open manner and make active contribution to help resolve conflicts, problems and business challenges.
• Development of strong relations with existing and prospective customers and external vendors.
• Responsible for analyzing and evaluating the criticality of issues and making decisions as to the appropriate level of escalation.
• Risk management and Software Configuration Management
• Coordination and Support System testing, UAT and post production activities
• Onsite- Offshore coordination to ensure the quality of the deliverables

Confidential, Schenectady,New York

ETL Designer

Responsibilities:

• Requirement elicitation and study existing system and applications to understand and capture the requirements.
• Detailed understating of existing functionality to evaluate the impact of new changes on the existing system.
• Responsible for preparing Functional Specification document and translating it to Technical Specification document.
• Design the data architecture and modeling business entities
• Insure consistency of attribute/column naming and defining them across the enterprise.
• Responsible for design and development of ETL architecture
• Review logical and physical data model with the Application development/delivery team, data architects and the assigned Database Administrators
• Design and development of ETL program complying to best-practice standdars.
• Perform Informatica code-optimization and develop SQL program.
• Responsible for Informatica code-migration and designing Production/QA deployment plans and as per client’s standards and policies.
• Perform defect management and data validation using Quality Center application.
• Responsible for writing test cases, designing test scenarios and executing the test cases to facilitate ETL testing.
• Preparation of Knowledge-Transfer documents to transition new members and help others understand the functionality.
• Leading offshore members during development anf testing ETL program, addressing critical issues, reviewing the code and conducting performance optimization.
• Perform Effort Estimation and generation of project plan

Confidential

ETL Developer

Responsibilities:

• Detailed understating of existing functionality to evaluate the impact of new changes on the existing system.
• Responsible for understanding Functional Specifications and translating them into Technical Specification document.
• Responsible for design and development of ETL architecture
• Review logical and physical data model with the Application development/delivery team, data architects and the assigned Database Administrators
• Design and development of ETL program complying to best-practice standdars.
• Perform Informatica code-optimization and develop SQL program.
• Development of complex ETL program using Informatica Power Center,performance-optimatization of Informatica program and organizing implementation-planning and workflow-scheduling.
• Extensive hands-on exposure to most of the Informatica Power Center Transformations including LDAP-application qualifiers, mapplet, SQL transformation, Stored Procedure, XML transformation, CDC and other regular transformations.
• Thorough knowledge and hands-on experience of handling Power Center workflow/mapping parameters and variables.
• Responsible for Informatica code-development,code-migration and designing Production/QA deployment plans and as per client’s standards and policies.
• Responsible for writing test cases, designing test scenarios and executing the test cases to facilitate ETL testing.
• Preparation of Knowledge-Transfer documents to transition new members and help others understand the functionality.
• Leading offshore members during development anf testing ETL program, addressing critical issues, reviewing the code and conducting performance optimization.
• Perform Effort Estimation and generation of project plan
• Development of BTEQ, MLOAD, FAST EXPORT scripts based on the user requirements.
• Performing data-extraction and data-validation by applying transformation-rules in the data-flow from source to target.
• Leading the Offshore team for code development, unit testing and integration testing of new data marts.
• Performance tuning and System optimization
• QA-migration and Production Deployment.