We provide IT Staff Augmentation Services!

Data Architect Resume

Coppell, TX

SUMMARY:

  • Data Warehouse Specialist with 11 years of progressive IT experience in Banking, Financial, Insurance and Telecom domains. In depth knowledge about various phases of IT projects which include planning and designing, gathering business requirements, analysis, development, testing, data modeling, data governance and implementation encompassing both WATERFALL and AGILE methodologies.
  • In depth knowledge in Data Warehousing. Strong Experience working in DW/EDW/DM Systems build on Teradata
  • Strong Experience in Teradata performance tuning and in reengineering the system applications and processes
  • Teradata 12 Certified Professional with strong working experience in Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT
  • Experience in implementation of data Warehouse applications involving ETL process using Mainframe and other ETL tools. Ability to design, build, deploy and support end to end ETL processes
  • Experience in ETL Mapping, design and development using Informatica. Proficient in using Mapping Designer, Workflow Manager, Workflow monitor to create, schedule and control Workflows, Tasks, and Sessions.
  • Strong expertise in data modeling involving logical and physical data model. experience in designing process involving Star/Snowflake schema and creating source to target data mapping based on the project needs
  • Extensive knowledge and good experience in Mainframes (Cobol, DB2, JCL, CICS) and on other tools like File - Aid, Changeman, SAR, Expeditor, CA7, NDM, SPUFI
  • Good understanding of Business Intelligence Concepts .Exposure to BI tools like Business objects and knowledge on Netezza and Oracle database development
  • Excellent interpersonal and analytical skills. Self-motivated, quick learner and team player. Active listening skills and assertiveness in negotiating the requirements based on project needs.
  • Strong experience in estimating effort based on requirements.
  • Experience with testing tools like the QC to develop test plans and test scripts in supporting and performing Unit testing, System Integration testing,
  • Experience in conducting trainings and handling meetings with users, project managers, analysts. Excellent orator and presenter with strong communication skills.

TECHNICAL SKILLS:

Databases: Teradata, DB2, Oracle, IBM Netezza, SQL server

Tools: Teradata SQL assistant, Teradata Viewpoint, Informatica Power Center 8.x/9.x, Aginity for Netezza, SQL Server Management Studio, TSOISPF, SAR, File-Aid, ChangeMan, SharePoint, QC, Business Objects, CA7Microsoft Suite, NDM, JIRA

Languages: SQL, JCL, COBOL, Easytrieve, VBScript

OS: ZOS, Windows 9x/2000/XP/7/8

Data Modeling: ERWIN, IBM InfoSphere Data Architect

Utilities: BTEQ, MLOAD, FASTLOAD, TPUMP, TPT

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

Data Architect

Responsibilities:

  • Develop data strategies for creating new data warehouse in Netezza
  • Identify gaps in data modeling and data mapping in the current Netezza system
  • Provide architectural knowledge to Different ETL teams to create new ETL processes for the feed from Core Logic and Assurant
  • Create internal tool for automation of Compliance test
  • Work with different LOB’s to understand the current process and automate the FLOD and SLOD test for compliance with CFPB regulations.
  • Closely Interact with key business users for evaluating the requirements on the new Model for Assurant, CoreLogic and Letters Data
  • Closely work with data stewards for identifying metadata information for the new Models built in Netezza
  • Develop strategies for performance tuning and implement tuning methodologies and do integrity check on tuned queries used for Automation

Tools: /Utilities: Aginity Workbench for Netezza, SQL server Management studio, IBM InfoSphere suite with Data Architect tool, ACL tool for Risk and Compliance Audit, LSAMS, ISIGHT, JIRA

Confidential, Coppell, TX

Teradata Lead/Architect

Responsibilities:

  • Develop data strategies for migration from Db2 database to Teradata
  • Provide architectural knowledge on remodeling the Data warehouse for new Teradata system to Different teams
  • Create internal automation tool for the migration of user SQL’s
  • Designed the ETL processes using Informatica Power Center to load data from Oracle OLTP system and files to target Teradata database.
  • Closely Interact with key business users for evaluating the new business report requirements on the ICDW model
  • Closely work with data stewards for identifying metadata information for the new ICDW environment
  • Work with DBA to identify gaps in data modeling, data mapping between Db2 and Teradata and provide Teradata performance knowledge to users
  • Develop strategies for performance tuning and implement tuning methodologies and do integrity check on tuned queries

Tools: /Utilities: Teradata SQL Assistant, Informatica Power Center, BTEQ, MultiLoad, FastLoad, HP Quality Center, VB Script for automation tool, Teradata Viewpoint, Visio, ERWIN

Confidential, Mclean, VA

Data Warehouse /BI Analyst

Responsibilities:

  • Identify the feeds to DW, prepare use cases based on business needs
  • Write complex SQL to pull data from the card warehouse and create Ad Hoc reports for key business purpose
  • Closely Interact with key business users for executing, monitoring, and evaluating the business requirements. Provide sign off on production release after evaluation
  • Test the data with all conceivable conditions in the SIT and UAT cycles so that errors can be solved out before the production
  • Closely work with data stewards for creating and publishing metadata
  • Work with architects to identify gaps in data modeling based on source-target data mapping
  • Develop strategies for business and testing team to perform data validation and data integrity check.
  • Handle teradata set up testing that includes testing teradata Tools & Utilities, Teradata connectivity

Tools: /Utilities: Teradata SQL Assistant/Administrator, COBOL, File Aid, NDM/FTP BTEQ, MultiLoad, FastLoad, HP Quality Center, Business Objects WEBI reports

Confidential, San Antonio, TX

Data Warehouse Lead (Enterprise Data Warehouse)

Responsibilities:

  • Identify the feeds to EDW, prepare requirements specification for new Model
  • Understand the requirements and prepare the design document with the listing of various sources and targets
  • Perform gap analysis to identify missing functionalities between AS-IS and TO-BE models
  • Conduct meetings, sessions with user to identify their needs and provide insight on technical limitations
  • Identify the process to extract the data from various sources and provide solutions to construct a program and other enhancements
  • Power ETL process knowledge to the teams using Informatica Power center
  • Document the processes from business and functional perspective
  • Test the data with all conceivable conditions in the SIT and UAT cycles so that errors can be solved out before the production.
  • Estimate efforts and prepare revenue budgets

Tools: /Utilities: IBM Requisite Pro, COBOL, DB2, File Aid, NDM/FTP, Ezytrieve, ETL tools, Business object crystal reporting, IBM OPTIM, Informatica Power Center

Confidential, Windsor, CT

IT Analyst (Data Warehouse)

Responsibilities:

  • Identify the different data sources into the W and do analysis for various business needs demanding technical changes to the Warehouse
  • As SME (Subject matter Expert) participate and assist in JAD sessions
  • Build code that involves complex and highly-optimized SQLs based on data mart requirements
  • Extract, transform and load data from source to target encompassing Bteq, FastLoad and MultiLoad utilities of Teradata using JCL and Informatica Power Center
  • Understand the business requirements and prepare the technical Specs document, data mapping document with the listing of various sources and targets
  • Do error handling and performance tuning in Teradata queries and utilities
  • Prepare test plan and test the data with all conceivable conditions in the SIT, UAT and production.
  • Work closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements
  • Mentor fresh team members
  • Establish “Best Practices” and plans for continuous improvement of processes

Tools: /Utilities: BTEQ, MultiLoad, FastLoad, Z/OS, JCL, COBOL, Teradata SQL Assistant, File Aid, NDM/FTP, Change man, CA7, HP Quality Center, DB2, Informatica Power Center, ERWIN

Confidential

Technical Analyst

Responsibilities:

  • Identify the process to extract the data from legacy database and construct programs to load it into WCC
  • Understand the master data and data management processes to build code for data consolidation
  • Identify the data synchronization (consistency across BU's, Geo's and Systems)
  • Create technical design document and identify gaps in physical design
  • Test the data with all conceivable conditions in the SIT and UAT accuracy and reliability
  • Design a production process for extracting the final data and forwarding it to a third party vendor on an as-needed basis for fraud monitoring

Tools: /Utilities: Z/OS, JCL, COBOL, File Aid, NDM/FTP, Change man, CA7

Confidential

Programmer Analyst

Responsibilities:

  • Understand the requirements to build code for development and enhancement requests
  • Work on deployment of the different components, compile and bind programs, run jobs on demand, monitor the production jobs.
  • Create technical design document and identify gaps in physical design
  • Test the data with all conceivable conditions in the SIT and UAT for data accuracy and reliability
  • Work on tickets and provide solutions on the problems

Tools: /Utilities: JCL, COBOL, CICS, File Aid, NDM/FTP, Change man, CA7

Confidential

Programmer Analyst

Responsibilities:

  • Understand the requirements to build code for development and enhancement requests
  • Work on deployment of the different components, compile and bind programs, run jobs on demand, monitor the production jobs.
  • Create technical design document and identify gaps in physical design
  • Test the data with all conceivable conditions in the SIT and UAT for data accuracy and reliability
  • Work on tickets and provide solutions on the problems

Tools: /Utilities: JCL, COBOL, File Aid, NDM/FTP, Teradata SQL Assistant, Change man, Teradata, DB2

Hire Now