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