Data Warehouse Specialist Resume New Jersey - Hire IT People

SUMMARY

Data warehousing expert with 8 years' experience in Retail Domain. An expert and adaptable professional with specialization in modeling, interpreting and analyzing data in a fast - paced environment with large data warehouse.A collaborative team player with a track record of delivering multiple, concurrent projects on Teradata, Unix and Microstrategy reporting analytics.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Data Warehouse Specialist

Confidential, New Jersey

Responsibilities:

Driving business performance through recommending strategic action plans
Transitioning of Dotcom digital reporting out of non-reporting databases and into the EDW which includes end to end review of business process and implementation of visually stunning automated reports
Improving business decision by identifying KPI discrepancies and designing logical data warehouse model for intraday reporting for extended visibility
Wealth of experience in creating complex mappings and custom queries using various transformations and optimized strategies for Extraction, Transformation and Loading (ETL) mechanism. Highly versatile in writing numerous SQL Queries and performing ADHOC analysis
Query optimization and performance tuning of high usage and slow performing jobs and reports

Technical Lead

Confidential, New Jersey

Responsibilities:

Working complete SDLC phases in both Waterfall and Agile type of project. Experienced in driving scrum meeting, handling all domain and technical interaction with various stakeholders and conducting conference meetings whenever necessary
Performing design analysis and developing design specifications as well as physical modelling with knowledge to use Primary, Secondary, PPI and join Index
Very well versed in leading an offshore team as well conducting quarterly induction and training on Teradata and data warehousing

Senior Data Warehouse Developer

Confidential

Responsibilities:

Extensively used Teradata utilities such as MLoad, BTeq, FastExport, FastLoad to design and develop data flow paths for loading, transforming and maintaining data warehouse. Strong expertise in building Enterprise Data Warehouse from wide variety of source systems and Data Mart feeds
Profound knowledge in creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts etc.), Dashboards and Generic cubes

Data Warehouse Developer

Confidential

Responsibilities:

Skilled in writing UNIX Korn shell script to call Teradata utility scripts and file handling operations
Acquired knowledge on finding root cause of data discrepancy between various Microstrtaegy Reports and report builder by analyzing report query, Cube SQL and analytical engine steps
Autosys job management such as scheduling and on hold/on ice/force start/off-hold/off- ice of production Teradata jobs