Data Analyst Resume

SUMMARY

Over 7 years of experience in analysis, design, development, testing and deployment of mission critical software applications using Oracle, PL/SQL, SQL, Informatica 9/8.x/7.x, Cognos 7.x, OBIEE 11g/10g.x.
Strong business understanding of Financial, Manufacturing, Banking and Service oriented industries.
Extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
Very good experience in Relational and Dimensional Data Modeling using tools like ER/Studio and CA Erwin for both forward and reverse engineering.
Strong experience with star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimensions.
Experience in integration of various data sources like Oracle, SQL Server, Teradata, MS Excel and Flat Files into staging area, ODS.
Extensively worked on mappings, mapplets, sessions (reusable and non - reusable), workflows and worklets.
Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.,
Proficient in using Workflow Manager Tools like Task Developer, Workflow, Designer and Worklet Designer.
Worked extensively with Data migration, Data Cleansing, ETL Processes and Web reporting.
Extensively worked on developing, monitoring and Jobs Scheduling using UNIX Shell Scripting.
Excellent knowledge in PL/SQL, Stored Procedures, Database Triggers, Views, Functions, Packages, Triggers, performance tuning and optimization.
Experience in Writing Technical Design Document and converting Functional Specs to Technical Specs.
Used DAC (Data Warehouse Administration Console) to configure, administer, load and monitor modular data warehouse applications.
Efficiently carried out Agile (XP, Scrum), Waterfall, FSDM and SDLC (Software Development Life Cycle) methodologies.
Active team player with excellent communication, organization and Interpersonal skills, self-motivated and quick learner.
Ability to work independently as well as in a team, fun-filled and challenging environment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0.1/8.x/7.x (Repository manager, Mapping Designer, Workflow Manager) and DAC.

OLAP Tools: OBIEE 11.1.1.x, 10.1.3.x, Crystal Reports, Cognos 7.x

Databases: Oracle 11x/10x/9x, SQL Server, Teradata

DB Analysis Tools: SQL Developer, TOAD 10.0.1/9.0.1 , SQL*Plus, ODBC

Data Modeling Tools: Erwin 7.x/4.x, Oracle Designer, ER/Studio 7.x, MS Visio 2003/2007.

Revision Control Tools: IBM Rational ClearCase, VSS.

Languages: SQL, PL/SQL, C, UNIX Shell Scripting, Perl.

Web Technologies: HTML, JavaScript, XML.

Operating Systems: Windows 7, Vista, 2000, XP, NT, 98, 95 and UNIX.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship