SUMMARY:

• 10+ of experience in Information Management end - to-end Data Warehousing, Business Intelligence, Data Profiling, Data Integration & Data Migration. Developing Data Warehouse roadmap, strategy and architecture, enterprise data warehouse, ODS, dimensional data marts and end user reports.
• Extensive Experience in data warehousing applications using Informatica Power Center 9.X, OBIEE, Oracle 10g/9i/8i,UNIX, Natezza, Oracle Data integrator(ODI) & CR Erwin.
• Playing the role of technical architect in the current project and Provides technical consulting and guidance to development teams for the design and development of highly complex or critical BI Data Warehouse Architecture.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design, slowly changing dimensions surrogate keys, FACT & Dimensions tables, Logical & Physical data modeling, ER Studio 7 and Erwin 4.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Business Management. Having more knowledge on the inbound/outbound interfaces data exchange between the source and target systems.
• Strong skills in Requirement Study, Analysis, Scope Definition, Recommendations to Business Process Improvements, Development of Procedures, Forms & Documentation, Effort Estimation, Project Tracking, UAT, and Change Control Management.
• Business Analysis Experience in conducting sessions/workshops for Functional and Non-functional requirements gathering for Data Warehousing projects, proof of concept, developed test cases, Traceability Matrix, estimation, Documenting BRD, LLD and HLD
• Very strong in designing, developing & tuning Informatica Mappings using various Transformations (Filter, Expressions, Router, Aggregative, Lookup, Router, Update Strategy) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Strong ability to understand, document and communicate technical architectures, best practices, toolsets and solutions. Also have experience with production support
• Expertise in Performance Tuning, Debugging, and Optimizing Analytics Dashboards / Reports and Data Warehouse database.
• Good in Oracle PL/SQL (Packages, Procedures, Functions, Triggers, etc).
• Extensive knowledge in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
• Hands-on experience with XML (inbound and outbound file processing).Managed projects in a timely manner, ensuring accuracy and that deliverables were met.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.0.1/8.1.1/7.1.2

ELT Tool: Oracle Data Integrator (ODI)

Reporting Tools: OBIEE, Business Objects XI R2

Data Bases: Oracle 8i/9i/10g/11g, DB2, SQL Server 2000, Natezza & Informix.

Data Modeling Tools: Dimensional Data Modeling, Relational Data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling, ER Studio 7, ERwin 4

Supporting Tools: Toad, Putty, WinScp, FileZilla

Operating System: UNIX, Windows 2000, Windows NT

Schedulers: DAC, Redwood Chronicle, Informatica scheduler

SDLC Process: AQUA, MS-Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential,Plano

ETL Technical Architect

• Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Evaluates new tools and techniques and makes recommendations to improve real-time and batch data access, transformation and movement across heterogeneous technologies and platforms.
• Determines organizational strategies for data integrity validation processes. Establishes policies and best practices for optimizing ETL data throughput/accessibility.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Experience in design/development of data models (Logical and Physical) based on the Business requirement
• Feasibility study of the requirement, Finalizing the Approach and Design of the system using ETL tools like informatica and co-coordinating with team in entire SDLC life cycle.

Technical Environment: Informatica 9.1, ODI, OBIEE, Oracle 9i, UNIX, TOAD, DAC & Informix.

Confidential, Groton

ETL Technical Architect

• Provides technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture.
• Identifies opportunities for new architectural initiatives; makes recommendations on the increasing scalability and robustness of ETL platforms and solutions.
• Evaluates new tools and techniques and makes recommendations to improve real-time and batch data access, transformation and movement across heterogeneous technologies and platforms.
• Determines organizational strategies for data integrity validation processes. Establishes policies and best practices for optimizing ETL data throughput/accessibility.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Experience in design/development of data models (Logical and Physical) based on the Business requirement
• Feasibility study of the requirement, Finalizing the Approach and Design of the system using ETL tools like informatica and co-coordinating with team in entire SDLC life cycle.
• Performed data profiling and source system data analysis as per the requirements
• Preparing Review, Design, Code & Testing (UTC, SIT and UAT) artifacts.
• Performed Source System Data analysis as per the Business Requirement.
• Headed the project management like planning, design, development and testing.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes in Repository & ETL.
• Responsible for monitoring jobs, handling tickets and new development of the project.
• Headed the entire Reporting Warehouse project end to end which involves Data Model creation, ETL design, ETL development & BO Design & Development.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Hands-on experience with XML (inbound and outbound file processing).

Technical Environment: Informatica 9.1,OBIEE, Oracle 9i, UNIX, TOAD

Confidential

Technical Architect

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a GRS Database
• Tested the Informatica mappings with manual testing and assisted QA team.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Monitored transformation processes using Informatica Workflow monitor.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables

Technical Environment: Informatica 9.1, Oracle 9i, UNIX, TOAD

Confidential

Technical Lead

• Understand the Requirements and analytics the system
• Design Reports
• Develop the Reports.
• Functional Testing on the Reports.
• Peer reviews of LLDs, Reports.

Technical Environment: Business Objects, Oracle 9i, UNIX, TOAD

Confidential

Technical Lead

• Designed the Mapping Technical Specifications on the basis of Functional Requirements.
• Deployed Informatica Objects from Dev to IMPL and PROD.
• Created ETL mappings using to move Data from multiple sources like Flat files, Oracle into a common Informatica Power Center target area such as Staging, Data Warehouse and Data Marts.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, update Strategy, Joiner, Router etc to load the data into staging tables and then to target. Aggregator, Lookup, Expression, update Strategy, Joiner, Router, processes, test cases, and error control routines Sequence generator etc transformations in the mappings.
• Monitored transformation processes using Informatica Workflow monitor.
• Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables.
• Used data profiling for the faltfiles to check the null values in the file.

Technical Environment: Informatica 8.1, Oracle 9i, UNIX, TOAD

Confidential

• Mainly involved in ETL developing.
• Experience in Development the mappings using needed Transformations in Informatica tool
• Mainly Involved in preparing the Documentation for the mappings based on the Business Requirement
• Review the documentation and coding created by other team members.
• Maintained all quality related documents in the VSS.

Technical Environment: Informatica 8.1, Oracle 9i, UNIX, TOAD

Confidential

• Mainly involved in ETL developing.
• Experience in Development the mappings using needed Transformations in Informatica tool
• Mainly Involved in preparing the Documentation for the mappings based on the Business Requirement
• Review the documentation and coding created by other team members.
• Report Validation of Phase1 and Phase 2 data by using Micro strategy tool.

Technical Environment: Informatica 8.1, Oracle 9i, UNIX, TOAD, Micro Strategy

Confidential

• Monitoring jobs and scheduling the jobs and bug fixing in production using Cronacle.
• Involved in Administration activities using Informatica.
• Involved in creating and managing users and folders using Repository Manager in Informatica.
• Solved clarify and support central cases from users.
• Ensuring the completion of jobs and communicating with the users in case of delays and failures.
• Starting and shutting down the different schedulers in production and QA and Development environments.
• Attended the Quarter close global sync calls and updating the status of jobs

Technical Environment: Informatica 7.1, Oracle 9i, UNIX, TOAD