We provide IT Staff Augmentation Services!

Dw & Big Data Consultant Resume

Wilmington, DE

CARRER OBJECTIVE:

To be efficient, capable and leading software professional working on cutting edge technologies in thriving on excellence and challenges. To seek a Competitive edge and a challenging work environment in the field of Business Intelligence of Information Technology.

PROFILE SUMMARY:

  • 16+ years of IT experience with 12+ years of strong experience in designing and developing Business Intelligence solutions in Domains like Finance, Investment Banking, Retail,.
  • Project Management Professional PMP
  • Strong experience in Data Warehouse & Big Data Environment.
  • Gone through complete implementation cycle of Data marts multiple times.
  • The activities include Business Requirement Analysis, Logical design / Data Modeling, Physical Database Design, ETL Build & Reporting, Integration Testing, User Accepting Testing, Production Deployment & Maintenance Transition.
  • Good experience in developing Logical and Physical Data Models.
  • Experience in Data warehouse Technical Architect for ETL (Informatica Power Center (5.1,6.2,7.x,8.x), PL - SQL
  • Worked extensively in Data Cleansing, data Mining, ETL Performance Tuning of Informatica mappings and sessions.
  • Experience in Hadoop BIG Data Environment . Worked in PIG scripting, HIVE, JAVA Tools, Map reduce and SPARK
  • Good Experience in developing UNIX shell scripting and automation of ETL processes and loading data in Hadoop Lake environment.
  • Well conversant with Amazon AWS Cloud environment .
  • Excellent communication and interpersonal skills, excellent team organizing skills.
  • Strong problem solving and analytical capabilities
  • Ability to understand customer needs and manage expectations.
  • Demonstrated ability to work effectively in a fast-paced, high volume, deadline-driven environment
  • Ability to balance multiple demands and work both independently and as part of a team to develop solutions

TECHNICAL SKILLS:

BIG Data: PIG, HIVE, SPARK, Map Reduce

RDBMS: Oracle 11g/10g/9i/8i,7.x, Sybase, DB2, SQL server

Reporting Tools/Technology: Business Objects

Programming Languages: JAVA, PL/SQL, Unix Shell scripts, AWK

ETL Tools: Informatica PowerCenter (5.x,6.x,7.x, 8.x) (Informatica Certified designer ver 6.x)

Operating Systems: Unix (SUN Solaris, HP), Linux, MS Windows NT, 2000/2003 server

Querying tools: SQL Plus, TOAD, DB Artisan

Data modeling: Erwin 4.x, oracle designer

Project Management Tools: MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

DW & BIG DATA Consultant

Responsibilities:

  • ETL Tech lead, Requirements gathering
  • Working with data stewards to gather and update the Meta data
  • Following Agile Scrum ceremonies
  • Informatica, Oracle & Unix development and deployments
  • ETL Performance tuning
  • Setting up Hadoop Feeds to fill the Lake from source systems
  • PIG scripting, HIVE tables and views creation
  • JAVA Tools coding and deployments with tools GitHub & Jenkins

Confidential, New York

DW Consultant

Responsibilities:

  • Data analysis for the external systems. Develop data cleansing rules & data quality checks.
  • Conforming the data definitions for reference data and hierarchies.
  • Redesign the Stage and ODS layers
  • ETL architect, extract specifications, mapping documents for Informatica mapping build.
  • ETL Performance tuning.
  • Design efficient data storages for historical data by snapshotting the tables
  • Informatica upgrade of 6 and 7 version workflows to 8.6.1 environment.
  • Unix shell scripting .
  • Unit testing, Integration testing

Environment: Oracle 11g /Unix, Sybase, Informatica Power center 8.6 .1

Confidential, Charlotte, North Carolina

DW Consultant

Responsibilities:

  • Data Profiling for the external systems data . decide data cleansing rules & data quality checks.
  • Identify the non confirming data, hierarchies & domains & decide the logic to correct it for overall integration.
  • Master data management: Consolidation of all reference data, Fixing of hierarchies across sub-business & newly acquired systems.
  • Creation of functional requirements documents, data dictionary & gap analysis .
  • Data architect, dimensional Modeling, designing logical models & physical db structures
  • DB space estimations, setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Design of History loading strategy & archival strategy
  • ETL architect, extract specifications, mapping documents for Informatica mapping build

Environment: Oracle 10g /Unix, Informatica Power center 8.6

Confidential New York City

DW data analyst / Architect

Responsibilities:

  • Data Architect & design: Data analysis from various heterogeneous source systems, preparation of extraction specification,
  • Data gap analysis, creation of data dictionary, mapping documents & functional documents.
  • Master data management > Consolidation of all reference data
  • Dimensional Modeling (Star schema, Facts, dimensions, Slowly changing dimensions, snowflek), designing logical models & physical db structures
  • ETL architecture, Loading strategy design
  • Business Objects ad-hoc reports as per user specification.
  • Source Data Integration across various heterogeneous systems into one Enterprise wise data warehouse.

Environment: Erwin, Sybase, Oracle 10g /Unix, DB2, Informatica Powercenter 8.6,, PL/SQLBusiness Objects(xi)Project #5: ODW Applications Development for Private Banking Domain

Confidential, New York City

DW Architect

Responsibilities:

  • Data analysis & design: Data analysis from various heterogeneous source systems, preparation of extraction specification, data Profiling.
  • Data validations & cleansing rules logic design
  • Master data management about Customers, Accounts, Investment Product hierarchies, Geographical sales hierarchies, Employee hierarchies & so on .
  • Data gap analysis, creation of data dictionary, mapping documents & functional documents
  • Designing data change detection strategy (CDC), Data cleansing rules.
  • Designing of data staging layer & ODS layer .
  • Dimensional Modeling, designing logical models & physical db structures
  • Logical data Model design & setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Design of History loading strategy & archival strategy
  • Integration of all project components, User Acceptance Testing & deployment.
  • Meta data management starting from source to reporting Layer.
  • Source Data Integration across various heterogeneous systems into one Enterprise wise data warehouse.

Environment: Erwin 4.0, Oracle 10g /Unix, Sybase, Informatica Powercenter 8.6,, PL/SQL, Packages, Stored Procedures, Functions, SQL*Loader, Sybase, UNIX Shell Scripting, Business Objects(xi),Flatfiles

Confidential, New York City

DW-ETL Consultant

Responsibilities:

  • Understand the End users reporting requirement & their existing SOX non complaint applications
  • Collect and document the functional business requirements .Analyze the existing MS Access Silo applications
  • & prepare the ETL development specs for the same.
  • Identify the data mappings & Gaps from the EDW tables .Identify all required fields for the users Computations & reports.
  • Logical data Model design & setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Decide ETL load strategies, Staging loads, ODS Loads, Historical loads, Type 2 dimension loading Change Data Capture (CDC) .
  • Build the ETL process using Informatica Power center(7.x)
  • Development of Complex Informatica Mappings .Oracle (PL/SQL, Packages, Stored Procedures, Functions, Triggers, SQL*Loader, External Tables)
  • Informatica mappings & sessions Performance Tuning
  • Unix / AWK Scripting for batch job automation.
  • Maintain ETL Mapping Documents, Data Dictionary & the version control for the mappings
  • Unit Testing, Integration Testing, Regression testing
  • QA Activities, Code reviews, Maintain best coding practices.
  • Front end user administration interface using Java UAT & migration between dev - QA to Prod environments

Environment: Erwin 4.0, Informatica Power Center 8.1,Oracle 10g, Unix, PL/SQL Store procedure, SQL*Loader, UNIX Shell Scripting, Java, Business Objects

Confidential, Danbury /Norwalk, CT

ETL Technical Lead Analyst

Responsibilities:

  • User requirement analysis, Design & Development of Analytical Environments for various departments
  • Logical-Physical data Models. dimensional Modeling. setting up of physical database structures (Schema, Tables, Indexes, Materialized Views, Synonyms, Grants, Referential integrity, constraints )
  • Meta data management starting from source to reporting Layer
  • ETL design: data Profiling, Data extraction from various heterogeneous source systems, data change detection, Data cleansing & data staging into ODS layer.
  • ETL build with in corporation of all business logic & rules . Data load into all dimensions & Facts of the Data Mart using Informatica, Oracle 9i PL/SQL Packages, Stored Procedures, Functions, SQL*Loader, external tables .
  • Complex Informatica mappings development & tuning .
  • Informatica repository administration
  • Unix scripting, Batch job Automation
  • Testing: Integration, User Acceptance & deployment.
  • Automation of the data refresh cycle on a regular basis.
  • BO Universe creation & Reports development. According to user requirements.
  • Continuous Data mart maintenance for Batch jobs . Maintenance for Daily/weekly & fiscal monthly data refresh cycles.
  • User support & response to user queries.
  • Regular DB Back ups . Import/Export of DB between various environments.

Environment: Oracle 9i, PL/SQL, Pro*C, UNIX Shell Scripting, Business Object(6.x),Informatica PowerCenter (7.x), SAP R/3

Confidential, Louisville, KY

DW Tech Lead, ETL developer (ETL & Reports)

Responsibilities:

  • Requirement Analysis
  • Source system analysis, Extract Specs preparation
  • Logical Design & Data Modeling in STAR Schema .
  • Physical Database design (Tables, Indexes, Materialized Views & Summary Tables, Space estimations. Customization of data by adding calculations, summaries and functions.
  • Complete ETL design including Oracle, PL-SQL, SQL*Loader, stored procedures, functions
  • ETL development, enhancements & continuous development
  • Developed report generation use cases
  • Digital Cockpit generation using J2EE Technology
  • Maintenance & enhancement to the Data Mart

Environment: UNIX shell scripts, Oracle 8i,PL-SQL, SQL*Loader,Informatica5.1 Power Mart, Erwin 3.5, J2EE for report generation

Hire Now