Business Intelligence Developer

Objective: To obtain a position as an ETL and/or a Business Intelligence Developer.

SUMMARY OF QUALIFICATIONS

Over 18 years of experience in IT in all phases of development life cycle.
Solid data warehouse development life cycle experiences, from gathering requirements to developing, testing, implementation, and support complex data warehouses.
Over 12 years of experience with Informatica Power Center.
Over 6 years of experience with Business Intelligence tool using Congos Framework Manager, Cognos Report Studio, Cognos Analysis Studio, Cognos Query Studio, and Cognos Cubes.
Strong SQL knowledge in Oracle 9/10, Netezza, Sybase, Informix, and DB2.
Excellent problem-solving and analytical skills.
Ability to communicate with non-technical end-users.
Fast learner and a team player.

TECHNICAL SKILLS

Programming:

Languages: PL/SQL, Unix scripting, C/C , PowerBuilder, Visual Basic, Java, HTML, Pascal, Cobol, RPG, JCL, CICS, APS, XML, Web services.
Framework: J2EE
APIs: JSP, Java Beans, EJB
Databases: Oracle 9/10/11g, Netezza, Sybase, Informix, DB2, SQL Server
Methodologies: Agil, Waterfall, SDLC
Project Management: Sharepoint, Version One, MS Project.

PROFESSIONAL EXPERIENCE

ETL Consultant

Confidential

Gather and analyze requirements.
Develope complex Informatica mappings from various sources using Filter, Router, Expression, Lookup connected and unconnected , Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter, and Union.
Use commands like Select, Create, Delete, Truncate, Insert, Join for data load and manipulation.
Create unit test plans.
Perform unit and system testing.
Use Worflow Manager to create workflows and session tasks.
Use Workflow Monitor to monitor jobs.
Create deployment packages to development, test, and production environments.

ETL/Business Intelligence Developer

Confidential

Worked with Solution Analysts to gather requirements for Functional and Technical documents.
Developed complex mappings to extract, transform, and load data from different sources flat files, XML, etc. into Oracle database.
Worked with DBA to design Oracle tables.
Used Workflow Manager to create workflow and session task to load data.
Used Workflow Monitor to monitor jobs.
Used transformations such as Joiner, Expression, Lookups, Filter, Aggregator, Update Strategy, Router, Sequence Generator, etc.
Developed database connection strings for development, test, stage.
Involved in writing Unix shell scripts to run Informatica Workflows.
Created unit test cases and involved in unit and system testing.
Debugged the sessions by using the session logs.
Migrated ETL mappings between environments.
Created Cognos reports such as List, Master-Detailed, Crosstab using Cognos Framework, Report Studio, Query Studio
Created Cognos cubes using Transformer.
Wrote queries in SQL to test Informatica mappings and Cognos reports.

ETL/Business Intelligence Developer

Confidential

Designed, developed Cognos frameworks, reports for all business areas such as Sales and Inventory.
Designed, developed MircroStrategy projects and reports.
Provided requirements analysis for Cognos frameworks and MicroStrategy reports.
Designed the physical and logical database models for each project.
Built the first Circuit City data warehouse using Informatica tool.
Extracted, transformed, and loaded data into DB2 and Netezza databases from various sources.
Created UNIX shell scripts to extract data from various sources.
Conducted peer design and code reviews.

Data Warehouse Engineer/Web Developer

Confidential

Developed and supported Web applications.
Analyzed, developed, and supported the data warehouse using Informatica tool.
Extracted, transformed, and loaded data into an Oracle database from DB2 sources.
Provided requirements analysis for business objects reports.

Programmer Analyst

Confidential

Programmer

Confidential