Sidbewindin Hermann Ouedraogo

***** ******** ***** *** ***, Oklahoma City OK 73120

w702qy@r.postjobfree.com

405-***-****

Education: Bachelor Degree in Computer Sciences

SUMMARY

• Knowledge of OLTP, OLAP and business intelligence applications with participation in entire software development life cycle (SDLC) Process.

• Knowledge of Informatica power center (Designer, Workflow Manager, Workflow Monitor, and Repository Manager).

• Knowledge of RDBMS such as ORACLE 10g/9i/8i, MS SQL Server 2005/2000, SQL, T-SQL, PL/SQL, Teradata.

• Knowledge of data warehouse concepts and Dimensional Data Modeling such as Star schema and Snowflake schema using Data Modeling tools like Erwin and Microsoft Visio.

• Knowledge of Extraction, Transformation and Loading (ETL) processes for data Integration, data mapping and data conversion.

• Knowledge in implementing complex business rules by creating optimized and efficient mappings.

• Knowledge in mappings and sessions in Informatica by identifying and eliminating bottlenecks to increase Performance.

• Knowledge in Unit Test Cases and performed unit testing for mappings. Also conducted code reviews for Quality Assurance.

• Good team player with excellent oral, written and Communication skills.

• Experience in system of Booking, Control and Management of the flights (SITA).

• Experience in system of DCS (Departure Control System).

• Experience in ET (Electronic Ticket).

TECHNICAL SKILLS AND KNOWLEDGE

• Data Warehousing Informatica Power Center 7.1/8.1/8.6(Source Analyzer, Data Warehouse Designer, Mapping Designer, Transformations, Workflow Manager, Workflow Monitor)

• Data cleansing, OLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus.

• Data Modeling Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, SQL Developer 3.0, and Oracle SQL Developer Data Modeler3.0.0.665

• BI & Reporting (OBIEE10g), MS Access, MS Excel, FrontPage 97/98/2000, Visio.

Programming SQL, PL/SQL

• Operating systems: MS Windows 2000, Windows XP, Windows Vista, Linux, Unix

• Others : Web design, Data networks Computing Maintenance

PROFESSIONAL EXPERIENCE

System and Information Corporation – Vienna, VA (October 2011 – Until date)

ETL Informatica Developer

Responsibilities:

• Identified business user requirements and prepared ETL strategies for data extraction, transformation and Loading into the data warehouse.

• Involved in the design of physical models and logical models for the database.

• Informatica Designer tools were used to design the source definition, target definition and transformations to build the mappings.

• Created Informatica Mappings with different transformations including Source Qualifier, Lookup, Filter, Expression, Aggregator, Stored Procedure, Lookup Transformations and more.

• Developed mappings, mapplets, reusable transformations and configured sessions using Informatica Designer and workflow manager tool.

• Created and monitored workflows and tasks using Informatica Workflow Manager.

• Worked Efficiently with Informatica Designer tools including Source Analyzer, Warehouse designer, Mapping and Mapplet Designer and Transformation developer.

• Extracted data from different sources like Oracle tables and Flat files, implemented business logic and loaded into the target Warehouse (Oracle).

• Created materialized view for optimal Oracle data warehousing performance enhancement.

• Created reusable transformations and mapplets and used them in mappings.

• Extensively used PL/SQL Procedures, Functions to build and implement business process.

• Fine tuned Transformations and mappings for better performance.

• Involved in debugging of Mapping and fixed the bugs.

Technical Environment: Oracle SQL Developer Modeler 3.0,Informatica Power Center 8.X,9.X ,Oracle 10g, Microsoft Applications-Work, Outlook, Excel

Air Burkina (2J) – Ouagadougou, BF (April 2005 - October 2009)

Mathematical and Computer specialist

Responsibilities:

• In charge of Statistics ( Passenger, provisional budget and realized)

• Control and Management of the flights

• Computers management

• User assistance

Technical Environment: SITA-DCS-SRES, E-SMASH, Microsoft Applications-Work, Outlook, Excel

Languages spoken: French and English

Contact this candidate