Data Architect Resume
GA
SUMMARY:
- Over 7 years of IT experience on Client - Server architecture, Business applications in various phases of IT projects such as analysis, design, development, implementation and testing of Data warehousing using Informatica (ETL), SQL, PL/SQL, and Oracle on OLAP and OLTP environment and also implementation of Database Management Systems for Health care and Insurance clients.
- Involved in design of Dimension Models, Star Schemas and Snowflake schemas.
- Experience in mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
- Experience with Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager.
- Experience with all components of mapping designer such as Source Analyzer, Warehouse Designer, Transformation Developer, Maplet designer.
- Experience in Performance Tuning of Sources, Mappings, Targets and Sessions.
- Strong skills in development of mappings, documentation, implementation and enhancement of ETL strategies.
- Experience in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
- Experience with Informatica Power Exchange 9.x/8.x for change data capture (CDC) and mainframe data.
- Extensively worked with Informatica Data Quality for data analysis, cleansing, and data matching.
- Extensively worked on Integration of Informatica MDM in order to show End to End Lineage of Data elements and provide BI answers
- Extensive experience in Oracle Development in table design, writing stored procedure, Database Triggers, Functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
- Extensive experience in performance Tuning SQL and PL/SQL code by using Explain Plan Table, Trace and TKPROF to significant improvement in system response time and efficiency.
- Used pmcmd, mailx command to execute jobs from UNIX platform.
- Programming skills using PL/SQL and Shell Scripts. Creation of scripts for collection of statistics, reorganization of tables and indexes and creation of indexes for enhancing performance.
- Coordinated with business users and team members to resolve data quality related issues.
- Experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
- Experience of application study, systems analysis, design, development, testing, implementation, maintenance and business analysis.
- Clear understanding of Business Intelligence and Data Warehousing Concepts.
TECHNICAL SKILLS:
CASE Tools: ERwin
ETL: Informatica (Power Center, Power Exchange, MDM)
Database: Oracle, Teradata, DB2, UDB, MS SQL Server, MS Access
Tools: TOAD, Unix Shell Scripting
Operating Systems: UNIX, Windows
PROFESSIONAL EXPERIENCE:
Confidential, GA
Data Architect
Technical Environment: Erwin, Informatica PowerCenter 9.5, Oracle 11g, Windows Vista
Responsibilities:
- Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL, PL/SQL programming.
- Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
- Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
- Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
- Participated in Design team brainstorm and user requirement gathering meetings.
- Converted the Business rules into Technical Specifications for ETL process.
- Involved in all phases of SDLC from requirement, design, development, testing, pilot, and rollout to the field users and support for production environment.
- Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
- Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.
- Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
- Worked on Informatica Power center 9.5 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Involved in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
- Extensively used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
- Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
- Extensively used Explain Plan Table, Trace and TKPROF in performance Tuning SQL and PL/SQL code to significantly improve system response time and efficiency.
- Used awk, sed, tar, grep commands, sql plus for connecting and loading data through UNIX.
- Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
- Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
- The design document was finalized through conduct of design walkthroughs, and independent review by the user. Prepared Technical Specifications for all the utilities, as per the company's standards.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
- Prepared Technical documents for all the modules developed by our team.
Confidential, GA
Data Architect
Technical Environment: Erwin, Informatica PowerCenter 9.0.1, SQL server 2008, Seaquest, Yotta (HP Internal tools), Windows Vista
Responsibilities:
- Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL, PL/SQL programming.
- Created mapping between the databases and identified the possibilities of incorporating the new business rules with the existing design.
- Created prototype reporting models, specifications, diagrams and charts to provide direction to system programmers.
- Prepared High level design (HLD), LLD, Project functional Specification Document and Business Requirement documentation (BRD).
- Participated in Design team brainstorm and user requirement gathering meetings.
- Played the lead role in Designing and implementing Pricing Analytics, Best Customer and Finance Master Data Alignment Services (MDAS) Data marts.
- Involved in managing the delivery of data extracts from the data sources to the warehouse and downstream applications.
- Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using Erwin.
- Played the role of a Data warehouse architect in the Business Intelligence Enterprise Architecture group for providing data architectural strategies.
- Involved in Architecture and design of Data extraction, transformation, cleaning and loading.
- Involved in Requirement gathering and source data analysis for the Data warehousing projects.
- Involved in the Logical and Physical design and creation of the ODS and data marts.
- Converted the Business rules into Technical Specifications for ETL process.
- Involved in all phases of SDLC from requirement, design, development, testing, pilot, and rollout to the field users and support for production environment.
- Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
- Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.
- Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
- Worked on Informatica Power center 9.0.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Wrote scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
- Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
- Involved in Data Quality Assurance, created validation routines, unit test cases and test plan.
- The design document was finalized through conduct of design walkthroughs, and independent review by the user. Prepared Technical Specifications for all the utilities, as per the company's standards.
- Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings.
- Prepared Technical documents for all the modules developed by our team.
Confidential, MA
Team Lead / ETL Developer
Technical Environment: Informatica PowerCenter 9.0.1, Informatica Power Exchange, COGNOS 8.3, SQL server 2005, Windows Vista
Responsibilities:
- Experience in Data Warehouse/Data Mart design, System analysis, Database design, ETL design and development, SQL, PL/SQL programming.
- Converted the Business rules into Technical Specifications for ETL process.
- Implemented mapping techniques for Type 1, Type 2 and Type 3 slowly changing dimensions.
- Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerCenter.
- Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
- Worked on Informatica Power center 9.0.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Involved in designing and developing complex mappings applying various transformations such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected Lookups, Sequence Generator, Rank, Update Strategy and Stored Procedure.
- Worked with Informatica Power Exchange 9.0.1 for change data capture (CDC) and mainframe data.
- Extensively used Explain Plan Table, Trace and TKPROF in performance Tuning SQL and PL/SQL code to significantly improve system response time and efficiency.
- Used awk, sed, tar, grep commands, sql plus for connecting and loading data through UNIX.
- Prepared Technical documents for all the modules developed by our team.
Confidential, MI
ETL Developer
Technical Environment: Informatica PowerCenter 8.6 & 7.1, Informatica Power Exchange, COGNOS 8.3, SQL server 2005, Windows Vista
Responsibilities:
- Involved in data analysis and development to understand attribute definitions for migration.
- Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
- Prepared mapping documents for loading the data from legacy system, flat files to staging area.
- Prepared mapping documents for loading the data from staging area to IDS.
- Defined Target Load Order Plan for loading data into different Target Tables.
- Worked on Informatica Power center 8.5.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
- Involved in the design and development of mappings from legacy system to target database.
- Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
- Used SQL tools like TOAD to run SQL queries and validate the data.
Confidential, MI
ETL Developer
Technical Environment: Informatica PowerCenter 8.6, Informatica Power Exchange, Teradata, COGNOS8.3, SQL server 2005, Windows Vista
Responsibilities:
- Involved in data analysis and development.
- Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
- Prepared mapping documents for loading the data from legacy system, flat files to staging area.
- Prepared mapping documents for loading the data from staging area to ODS.
- Defined Target Load Order Plan for loading data into different Target Tables.
- Worked on Informatica Power center 8.5.1 Tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation.
- Extensively used Router, Lookup, Aggregator, Expression and Update Strategy transformation.
- Involved in the design and development of mappings from legacy system to target data base.
- Involved in performance tuning of the mappings by doing necessary modification to reduce the load time.
- Defined test cases and prepared test plan for testing ODS jobs.
- Optimized Query Performance, Session Performance and Reliability.
- Used pmcmd, mailx command to execute jobs from UNIX platform.
- Coordinated with DBA team to resolve issues pertaining to load timings and any other database related issues which are hindering performance of loads.
- Supported UAT testing and production testing by identifying the bugs and also helped to resolve various Data issues, Load Issues.