We provide IT Staff Augmentation Services!

Etl/data Architect Resume

Baton Rouge, LA

PROFESSIONAL PROFILE:

Highly skilled professional over 20+ years of experience in Data Warehousing/Business Intelligence, Data Modeling, Data Integration, Master Data Management, Solution Architecture and Big Data Architecture. Well Versed with the Strategy, Design and Development of Enterprise Architecture using various tools. Industry experience includes Insurance, Financial, Banking, Healthcare, Retail and Telecomm. A self - motivated performer with experience as Lead Architect/Solution Architect/Enterprise Architect working for various Clients

EXPERIENCE SUMMARY:

  • Highly Experience in leading Data Warehouse Projects including Platform Migrations, SOA Models, Data Modeling, Big Data Architecture, design through implementation of large/complex data ware house/ integration projects for various Clients
  • Highly Experienced in handling end-to-end implementation of Data ware House /Big Data projects including defining the scope, planning, requirement gathering, blueprint creation, roadmap and Architecture.
  • Highly Experienced Professions in Designing Master Data Management, Data Quality and Data Integration.
  • Hands on Experience in Project Management.
  • Highly experienced in handling onshore and offshore model projects.
  • Excellent problem-solving skills with strong technical background and good interpersonal and communication skills.
  • Hands on Experience using Data Modeling tools like Erwin, ER Studio, Power Designer, Oracle Data Modeler and other modeling tools.
  • Demonstrate ability to lead multiple projects of varying degrees of complexity.
  • Hands on experience in Data Modeling Physical and Logical Data Modeling.
  • Hands on experience with Teradata 14.0, Netezza Appliance, Oracle 12x, SQL Server 2014, DB2 10.1.
  • Hands on Experience in Designing Relational, Dimensional data models
  • Highly Experienced with IBM IAA and IIW Model, Teradata data Model.
  • Extensively worked on Party Model for various Insurance Clients.
  • Expert knowledge and hands-on experience with ETL Tools like Informatica Power Center, Informatica Data Quality, Informatica Master Data Management, SSIS, SSRS, Talend Data Integration and Talend Cloud etc.

TECHNICAL SKILLS:

RDBMS: Teradata14.10, Oracle 12.x and lower versions (SQL, PL/SQL, Stored Procedures), DB2 10.1, Netezza (Appliance), SQL Server 12.0

ETL Tools: Informatica Power Center 10.1.1 HF1, Power Exchange, Informatica Data Quality 10.1 Hotfix 2, SSIS, SSRS, Talend Real-Time Big Data, Talend Cloud and Talend Data Integration, Informatica B2B, Informatica Data Integration Hub, Informatica Big Data Management

Operating Systems: UNIX (Sun Solaris, HP Unix, LINUX), Windows NT/98/95, WIN 2000

Data Modeling: CA Erwin 9.1/7.3/4.1/4.0/3.5.5 , ER/studio 9.1.1, Power Designer, and Oracle Data Modeler

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Cobol and C, C++, Python

Other Tools: Query Man 5.0, Toad 9.5, AQT, Teradata SQL Assist

Functional Areas: Insurance, Confidential, Banking, Healthcare, Retail and Telecomm

Hadoop Ecosystems: HDFS, Hive, Cassandra, OoZie, Kafka, Sqoop, Spark, MapReduce, Scala, Solr, HBASE, MongoDB and Zoo Keeper, Parquet, AVRO, Impala, Protegrity, Kudu

PROFESSIONAL EXPERIENCE:

Confidential

ETL/Data Architect, Baton Rouge, LA

Responsibilities:

  • Participate in functional and business requirements and prepare Blue Print, High Level Design Documents, Low Level Design Document for various source systems.
  • Data Profiling including Column Level Profiling, Table Level Profiling, Enterprise Level Profiling using Informatica Developer/Informatica Analyst.
  • Design and crate various re-usable mapplets for email validation, zip code validation, name parsing, SSN Validation etc using Parser, Standardizer, Labeler Transformations.
  • Design Address Validation Rules for Address Validation using Address Validator Transformation.
  • Design ETL Jobs using Informatica Power Center to move the data from Legacy systems to SQL Server and Teradata
  • Designed and implemented SOAP/REST on web services/ESB using Java, HTTP, Data Processor Transformations
  • Real time data integration using Informatica B2B
  • Design Conceptual, Logical and Physical Data Model for Claims, Billing, Provider and various other source systems using Erwin.
  • Design Data Integration Hub for Reporting needs.

Technologies Used: Erwin 9.7, SQL Server 2014, Teradata 1.0, informatica Power Center 10.1 HF1, Informatica Developer 10.1 HF2, Informatica B2B 10.1 HF2, Informatica DIH 10.2, TOAD, Autosys

Confidential

ETL/Data Architect, Richardson, TX

Responsibilities:

  • Participate in functional and business requirements and prepare Blue Print, High Level Design Documents, Low Level Design Document for various source systems.
  • Design Conceptual, Logical and Physical Data Model for various data marts like FRM, VFO, C2C, C&E etc
  • Design Conceptual, Logical and Physical Data Model for Enterprise Data ware House.
  • Data Profiling including Column Level Profiling, Table Level Profiling, Enterprise Level Profiling using Informatica Developer/Informatica Analyst.
  • Design and crate various re-usable mapplets for email validation, zip code validation, name parsing, SSN Validation etc using Parser, Standardizer, Labeler Transformations.
  • Design Address Validation Rules for Address Validation using Address Validator Transformation.
  • Design ETL Jobs using Informatica Power Center to move the data Teradata to Oracle

Technologies Used: ER win 9.1, Teradata 14.1, Informatica 9.6.1HF2, UNIX, Informatica Data Quality 9.5 Hotfix 4, Oracle, Teradata SQL Assist, Unix, Autosys

Confidential

Sr. Solution Architect, Seattle, WA

Responsibilities:

  • Source system analysis, Data Quality analysis
  • Understand and define the requirements post discussions with the business/Subject matter experts (SMEs) for the EDW
  • Interact with Business users and project stakeholders and translate the requirements into functional and then technical specifications
  • Data Profiling.
  • Source to Target Mapping Document Preparation
  • Work with Subject Matter Experts (SMEs) to come up with a Conceptual and Logical data model that considers all the features required for the current functional requirements.

Technologies Used: ER/Studio Data Architect, Informatica 9.5.1, Oracle 11.6, Teradata 13.0, Unix, Teradata SQL Assist

Confidential

Sr. Solution/ETL Architect, Chicago, IL

Responsibilities:

  • Analysis of the existing Informatica Mappings.
  • High-level design for Migration.
  • Mentor Onsite and Offshore resources.
  • Testing Support.
  • Performance tuning of Informatica Mappings.

Technologies Used: Informatica 9.0.1, Oracle 11.6, Netezza TF24, Unix, Erwin, Aginity Workbench for Netezza

Confidential

Data Architect, Buffalo, NY

Responsibilities:

  • Source system analysis, Data Quality analysis
  • Business requirements Analysis
  • Design a dimensional model using Dimensional Modeling techniques
  • LDM, PDM and S2TM Preparation
  • Works closely with the user community, technical staff and team members to develop reporting and analysis specifications
  • Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures
  • Works closely with Reporting/Analysis teams to educate end-users on the proper usage of Data Marts
  • Provide input and recommendations on design/technical issues to project manager/senior managers

Technologies Used: Informatica 9.0.1, Oracle 11.6, TOAD for Oracle 11.6, Unix, Power Designer

Confidential

Sr. Solution Architect, Boston, MA

Responsibilities:

  • Source system analysis, Data Quality analysis
  • Gather Business requirements
  • Design a dimensional model using Dimensional Modeling techniques
  • LDM, PDM and S2TM Preparation
  • Works closely with the user community, technical staff and team members to develop reporting and analysis specifications
  • Create the ETL Design document
  • Assists the Systems Architecture and DBA teams in developing approaches to maintaining optimized Data Warehouse solutions, including strategies for aggregation and other derived structures
  • Works closely with Reporting/Analysis teams to educate end-users on the proper usage of Data Marts
  • Provide input and recommendations on design/technical issues to director/senior managers

Technologies Used: Oracle 11.6, Talend, Oracle Data Modeler, TOAD

Confidential

Lead Architect, Los Angeles, CA

Responsibilities:

  • Defining Scope, Planning and Estimation.
  • High Level Design Preparation
  • Technical solution and mentoring the team.
  • Delivery and Implementation.
  • Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 9.0.1, DB2, TOAD 4.7, Unix, Teradata 13x

Confidential

Enterprise Solution Architect, Schaumburg, IL

Responsibilities:

  • Source system analysis, Data Quality analysis
  • Defining Scope, Planning and Estimation.
  • Creation Logical, Physical Data Model, Source to Target Mapping
  • Creation of Data Marts for Downstream Application for reporting needs
  • High Level Design, Low Level Design Review.
  • Technical solution and mentoring the team.
  • Delivery and Implementation.
  • Work with Offshore and Onsite Architects, Tech Leads, Sr. Developers and mentor them.

Technologies Used: Informatica 8.6.1, Netezza, AQT, Unix, Erwin, DB2, Autosys, SAP

Confidential

Sr. Solution Architect, Columbus, OH

Responsibilities:

  • Defining Scope, Planning and Estimation.
  • Defining Technical Architecture
  • High Level Design Preparation
  • Technical solution and mentoring the team.
  • Delivery and Implementation.
  • Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica 8.6.1, Teradata, Teradata SQL Assist, Unix

Confidential

Sr. EDW Architect

Responsibilities:

  • Source system analysis, Data Quality analysis
  • High Level Design Preparation
  • Low Level Design Preparation
  • Mapping Development.
  • Test case Preparation
  • System testing, Regression testing and UAT Support.
  • Performance Tuning.
  • Traceability from Business Requirements to the System Requirements.

Technologies Used: Informatica, Oracle, AQT, Unix

Confidential

Offshore Technical Lead

Responsibilities:

  • Designing and developing ETL mapping, designing developing Reports, Developing Database Design, Preparing Test Plans, Preparing Test Cases and Conducting Unit, Performance, Volume and stress testing

Technologies Used: Informatica, Oracle, AQT, UNIX

Confidential

Offshore Technical Lead

Responsibilities:

  • Designing and developing ETL mapping, designing developing Reports, Developing Database Design, Preparing Test Plans, Preparing Test Cases and Conducting Unit, Performance, Volume and stress testing

Technologies Used: Informatica, Oracle, AQT, UNIX

Hire Now