Business Intelligence Resume

Summary

7 plus years of extensive experience in Designing, Developing, Testing and Maintaining Business Intelligence and ETL applications using tools and technologies such as InformaticaPowerCenter 9.1/8.6/8.0/7.1, Metadata Manager, Qlikview, Business Objects, Cognos, etc.
Experience with basic informatica administration such as creating users, folders, privileges, configuring repository, optimizing server settings, etc.
Used parameters and variables to design ETL solutions.
Used informatica to extract data from disparate sources such as Oracle, Sqlserver, Sybase, Teradata, SAP, XML file, Mainframe, Cobol files, Flat files, etc.
Expert level experience with SQL, PL/SQL and databases such as Oracle, Sqlserver, Teradata, DB2, Sybase, etc.
Expertise in Relational and Dimensional modeling techniques (Star Schema and Snow Flake Schema).
Expert level knowledge in Databases and experience in SQL tuning, creating stored Procedures, Functions. Indexes, views, materialized views, database partitioning and table partitioning, etc.
Expertise in Data Warehousing, Data Migration, Data Quality, and Data Cleansing.
Involved in the Data Analysis and profiling for source and target systems and good understanding of Data Warehousing concepts, Staging Tables, Dimensions, Facts and Star Schema.
Expertise in performance tuning ETL code, SQL, PL/SQL, mappings, sessions and database.
Experience in Unix and Shell scripting.
Experience in scheduling jobs using tools such as Autosys, Cron tab, Tidal, etc.
Performed Testing at various levels including Unit Testing, SIT, UAT
Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
Resourceful and self confident; get the job done and do it well.
Effective working alone and as a team-player.
Focused and persistent, a go-getter who doesn’t quit until the job is done right.

Technical Skills

Data warehousing:InformaticaPowercenter 8.6/8.5/8.1/8.0/7.1.4/7.1.3/7.1.2/7.1.1/7.0Repository Manager, Designer,Work Flow Manager, Work Flow Monitor,Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Worklet Designer, Mapplets, Mappings, Workflows, Sessions

Data Modeling:Ralph Kimball Methodology, Bill Inmon Methodology, Snow-Flake, FACT Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases:Oracle 10g/9i/8i, T-SQL, MS SQL Server 2000/7.0/6.5, Sybase SQL Server 12.0/11.x, Teradata, MS Access 7.0/2000, SQL, PL/SQL

Environment:Windows 2003/2000/XP/98, UNIX (Sun Solaris, HP-UX, AIX)

Job Scheduling:Informatica Scheduler, Control M, CA Autosys.

Others:Microsoft Word, Microsoft Excel, Outlook, XML, and HTML

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship