We provide IT Staff Augmentation Services!

Dwh / Bi Consultant Resume

Objective:

  • A position in Software Professional providing opportunity to make a strong contribution to Organizational Goals through continued development of professional skills.

SUMMARY

  • Total 9+ years exp, in dat around 6+ years of experience in development of Data warehousing solutions using Informatica 9.1/8.x/ 7.x and Qlikview 8.20/9.0.
  • Knowledge of different Schemas ( Star, Snow Flake and Extended Star Schemas) for query and business analysis requirements
  • Extensive working experience in Data Warehousing technologies and client/server applications in Healthcare/Finance/Retail Domain.
  • Has worked on different phases of project development life cycle. Has done: Analysis of requirements, Creation of sub - project estimates, Creation of work order, Creation of detail design document, Coding, Unit testing & Integration testing.
  • Involved in Design, Development, and testing phases of Data warehousing projects.
  • Created complex mappings using Lookup, Joiner, Aggregator, Stored procedure transformations.
  • Good understanding in Change Data Capture (CDC) techniques like slowly changing dimensions, slowly growing target, and simple pass through.
  • Possess excellent communication and interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS

ETL: Informatica power centre 9.1/8.x/7.x

DBMS / RDBMS: Oracle 9i/10g, Sybase

Programming Languages: PL/SQL, Unix Scripting

Tools: SQL*Plus, DBArtician

OLAP: Business Object

Alanlytical Tool: Qlikview 8.20/9.0

PROFESSIONAL EXPERIENCE

DWH / BI Consultant

Confidential

Responsibilities:

  • Designed and developed Claims and pharmacy data mart ETLs
  • Provided performance improvement and system stability solutions.
  • Analyzing and evaluating new changes as per production system guidelines as well as providing approvals for deployment.
  • Analysis, development and implementation of system enhancement, bug fixes etc.
  • Proactive monitoring and analysis of production system statistics; to ensure system availability and continuity in coordination wif system administrators and DBAs.
Consultant

Confidential

Responsibilities:

  • Performed problem assessment and solution analysis of business and application requirements.
  • Analyzed technology solutions and designed and developed in coordination wif Datacenter.
  • Designed data sharing and security for reporting applications.
  • Designed and developed ETL and reporting solution utilizing Informatica, Shell Script, Perl Scripts and Qlikview intelligence reports.
  • Documented system specifications and conducted walk through sessions for Data Centers.
DWH/BI Consultant

Confidential

Responsibilities:

  • Performed requirement analysis and research in coordination wif Business users, Business analysts and system analysts.
  • Designed integration process wif IBD database and enterprise wide data feeds (flat files and XMLs) from various applications.
  • Defined development, deployment and support best practices as per enterprise guidelines.
  • Managed wif ETL deliverables and coordinated wif project leads on project timelines and software delivery plan.
  • Conducted cost estimation, role based task allocation and gap analysis.
  • Documented system specifications and conducted walk through sessions for stakeholders.
DWH / BI Consultant

Confidential

Responsibilities:

  • Redesigned existing ETL process to improve total runtime and maintainability.
  • Migrated 7 Informatica ETL applications from 7.x version to 8.x wifout impacting upstream and downstream system in 3 months, only.
  • Designed and developed business intelligence reports using Microsoft SQL Server; as well as optimizing multidimensional data retrieval.
  • Documented system specifications and conducted walk through sessions for business users.
  • Educated business user on new applications/platforms for analysis and reporting.
  • Trained new team member on functional as well as technical aspects of project as well as managed their task allocations.
Technical Support Executive

Confidential

Responsibilities:

  • I was associated wif Aetna Healthcare, are responsible for processing the claims to accurate payment to the provider based on service agreement and diagnosis.
  • Educate team member of healthcare domain.

Hire Now