Senior BI Consultant Resume

SUMMARY

Engineering graduate wif 7 years of experience in Architecting and Modeling large - scale enterprise Data warehouse, OLTP, OLAP, and ETL solutions.
Implementation experience for E2E solutions (including business analysis, development, testing, deployment and warranty support).
Well-rounded experience in the data life cycle management and hands-on experience in dimensional data modeling, data quality, data profiling, SQL programming and ETL development.
Strong development expertise in ETL tools like Informatica PowerCenter.
Knowledge of distributed data system concepts, Big Data Framework Hadoop (Hive, HDFS, SQOOP, MapReduce).
Focused on growth and deep expertise in Big Data Analytics (Data Engineering, Data Science).

TECHNICAL SKILLS

Concepts: Data warehousing, ETL, Dimension modeling, Agile/Waterfall Methodologies

ETL Tool: Informatica Power Center

Programming Languages: Unix Shell Scripting

Database Technologies: Oracle, PL/SQL, MS SQL Server, Teradata, TSQL, SAP HANA

Platforms: Windows Server 2003/2008, Linux.

Defect and Incident Management: HPQC, JIRA, BMC Remedy, Service Now

Scheduling tools: Autosys

Version Control Tool: GitHub, RTC (Rational Team Concert)

PROFESSIONAL EXPERIENCE

Senior BI Consultant

Confidential

Responsibilities:

Led and delivered critical scope on the Agile Scrum team, accountable for ETL, database and reporting solutions to support the “Stock plan administration self-service analytics” product.
Helped successfully managing customer equity compensation plans.
Created Technical Designs, defined strategies and developed core code components.
Architected complex Workflows in Informatica 10.2 for pulling data from various sources and loading into Oracle/ Exadata Warehouse.
Designed analytical SQL queries in PLSQL for data transformation.
Built reports using the Oracle Business Intelligence suite (OBIEE).

Solution Designer and Lead ETL Specialist

Confidential

Responsibilities:

Implemented critical batch components on Canada’s largest Retail Loyalty program (PC Plus).
Established self as key point of contact for client for translating business requirements into Data models, Functional and Technical Documents.
Developed ETL Informatica mappings for source data into Derived Masters schema using various PowerCenter transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, SQL, Normalizer and update strategy etc.
Developed deep expertise in implementing all types of loading mechanism (SCD1, SCD2, delta, full/ incremental load).
Built reusable transformations, Mapplets/ Worklets wherever redundancy was necessary.
Performance tuned Informatica code and database to increase data throughput.
Performed and supported testing in various environments across the lifecycle of the project.
Resolved defects associated wif ETL jobs in PROD and non-PROD environments.
Coordinated wif Production Support teams, performing initial triage, identifying root causes, recovering data and implementing change/ enhancements in production.

ETL Support Practitioner

Confidential

Responsibilities:

Monitored Informatica ETL data loads and reported on SLAs and data availability.
Planned and communicated outages and repository downtime.
Investigated data discrepancies and identified missing data issues wif mapping failures.
Fixed ETL load failures, missing data/ files, bugs and infrastructural component-issues
Coordinated between teams during Performance degradations and ongoing maintenance involving OS, FTP Servers, Network, Database, Job Scheduler.
Managed Incidents (failures/ missing or invalid data, delayed data), Problems (repeat incidents) and Change management (bug/ break-fixes, enhancements) tickets in Production.
Performed RCAs and documented all issues related to Informatica job failures.