Information Domain Architect / Project Lead Resume

SUMMARY:

PMI Certified Data Warehouse / BI Professional with 8+ years of experience in Owning & Managing BI / ETL / DQ / MDM projects, Architecting solutions, Profiling & Defining Data Cleansing Rules, Tableau report development, Data Mapping, Developing, and Planning Test & Deployments.Leadership skills demonstrated through successfully managing upward and downward expectations, owning Waterfall and Agile/SCRUM projects, project Planning, briefing Status Updates / Issues / Risks, driving Cross - functional and On-shore/Off-shore teams through entire SDLC while meeting / exceeding project timelines.

TECHNICAL SKILLS:

ETL / DQ Tools: Informatica (Power Center, Cloud Services), Informatica Data Quality (trained), IBM Data Profiling (DataStage, QualityStage), IBM Information Analyzer (trained), SQL Server Integration Services (SSIS), JIRA

BIG Data Tools: HIVE (beginner), HQL, Hue (beginner)

BI Tools: Tableau (2015 trained), Cognos 10 (trained), Crystal Reports, SQL Server Reporting Services (SSRS), TOAD, Data Warehouse Administrative Console (DAC), TIDAL 6.0

Databases: SQL Server 2008, Oracle, Teradata (trained)

MDM Tools: Informatica MDM 9.0 (trained), IBM Initiate MDM (trained)

CRM: Salesforce (trained), Veeva (trained)

PROFESSIONAL EXPERIENCE:

Confidential

Information Domain Architect / Project Lead

Responsibilities:

Spearheaded HADOOP ETL projects inclusive of Data Mapping (STM) and Cleansing rules, Data Analysis, Data Modeling decisions & design, and Architectural Blueprint
SME to identify solution interdependencies and requirements, validate data quality and design reviews / walk-thrus
Formulated client’s AGILE Delivery: Weekly SCRUM, Sprint Planning & Retrospective meetings, Status Updates
Owned Project Plans & Execution through Scope Management, Re-prioritizing project timelines, resource allocations, RACI, and collaboration with cross-functional teams
Restored strained relationships with vendor, and other external team members

Confidential

Project Lead

Responsibilities:

Developed in Informatica PowerCenter 8.6 and Informatica Cloud Services, IBM DataStage / QualityStage, Microsoft SQL Server (SSIS / SSRS) 2008, scripted SQL for Unit Testing, investigated ETL bugs and implemented fixes
Defined detailed ETL / DQ Development Standards, Data Modeling Standards, ETL / DQ Architecture and Blueprints, Testing and Deployment Strategies and Plans for Extracting & Transforming data through ODS / EDW into MDM
Accountable for execution and planning of a $600k IBM MDM Initiate implementation engagement
Spearheaded $300k Data Quality (DQ) tool evaluation project to win $1.5M DQ Implementation phase
Accountable for Test & Deployment strategies, Technical Design & Strategy documents, Data source/Business Glossary, reviewing deliverables and coaching/mentoring junior on technical/soft skills
Performed SQL based source data analysis to formulate appropriate Integration Strategies / Data Process Flows and advice client on Data Quality enhancements

Confidential

Product / Project Manager

Responsibilities:

Liaised with business stakeholders to define Product Requirements and Reporting KPIs, and create Wireframes (Salesforce / Veeva), Data Integration/Migration & Business Rules
Maintained 40% Profit Margin via resource and budget re-allocations on a $600k KOL Salesforce/Veeva project
Managed, Co-ordinated and Planned projects by managing dependencies and risks, re-scoping and re-planning, task re-prioritization, and collaborating with cross-functional teams
Facilitated workshops to conduct Gap Analysis, propose Current vs. Future state, gathered Requirements, and proposed Streamlined Process and Data Quality Improvement.
Accountable for People Leadership and Client Relationship management while helping drive client’s PMO compliance needs

Confidential

Data-Warehouse / BI Systems Analyst

Responsibilities:

Designed, Developed and documented SQL Server SSIS ETL and SSRS Reports based on requirements
Supported SSIS development, solution configuration and troubleshooting for DW systems/solutions

Confidential

ETL Developer

Responsibilities:

Mentored juniors, Developed and Documented ETLs (Simple to Complex) in Informatica PowerCenter 8.6 / ORACLE
Planned and coordinated End to End Testing, and Scripted detailed SQL Test Scripts for ETL for on-time deployment

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship