ตัวอย่าง Resume ยานยนต์ (Automobile) ฉบับที่ 146
Resume Example Automobile #0146 ประมาณ 1677 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง ETL Solution Architect Project Honeywell - Saginaw, MI ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 5 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 5 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง SAP ซึ่งเป็นสิ่งที่ HR สายยานยนต์ ให้ความสำคัญ
- ประสบการณ์ 6 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 31+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Highly motivated Sales Associate with extensive customer service and sales experience. Outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market.
Experience
Position
- Worked on ETL migration project from Ab-initio to Informatica mappings and integration projects like Avaya systems to CMS systems.
ETL Solution Architect Project Honeywell - Saginaw, MI01/2016 - Current
- The objective of this initiative is to build a Business Intelligence with analytical and reporting capabilities to facilitate the needs for SNAP/TANF reports
- Design, development, testing of data warehousing solutions using ETL tools - Informatica 10.4
- Data design and analysis, data transformations, data cleansing, Web Service integration, database relationships, source systems analysis and reporting analysis
- Code migration/deployment to test and production environments
- Developed Hive queries for the analysts
- Design the data modelling and relation b/w entities/relationships
- Involved in Scrum meetings and have good knowledge of Agile methodologies
- Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecks and tuned the complex Informatica mappings for better Performance
- Designed and developed several Unix scripts to execute Informatica jobs
- Worked on informatica scheduling and modified the scripts to test the new Control-M job cycles
- Created pre-SQL and post SQL scripts which need to be run at Informatica level
- Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
- Have a good knowledge on RTC and Remedy
- Optimized SQL queries for better performance
- Worked on the loading of Facts and Dimensions to maintain the history records at any point in time
- Environment: Informatica PowerCenter 10.4,10.2, Teradata, Oracle, UNIX, Control-M
ETL Lead Developer10/2015 - 12/2015
American Homes 4 Rent - Denver, CO
- Project: Pricing Modernization
- Gathered customer requirements and involved in business meetings with analysts, architects, and business users
- Designed the data warehousing solutions from end to end of the project
- Worked in Agile development environment and have good knowledge of the Agile methodologies
- Involved in iteration planning meetings, epic, stories, tasks and retrospective meetings
- Documentation of the ETL design process
- Code Deployment to QA, Production environments
- Good knowledge on optimization of sessions and mappings
- Developed Batch Processing, Source, and Target Reconciliation process
- Tuning Informatica Mappings and Sessions for optimum performance
- Performance tuned Mappings/Sessions, developed complex database SQL and PL/SQL to validate ETL & Report testing
- Worked on incident management tools
- Environment: Informatica PowerCenter 10.2,9.6, Teradata, Oracle, UNIX, Toad, Control-M
Sr. ETL Developer06/2014 - 09/2015
United Services Automobile Association
- FINPAL
- Financial profits and losses of the Auto Mobile & Property insurance and other lines of business for each member of USAA
- Helped to analyse the internal profits and losses of the organization
- Involved in the business discussions and implementing the business dataflow and data relation
- Prepared high-level design documents
- Created STM (source to target mapping), Conceptual data models and SRS (software requirement specification) documents
- Worked on different transformations, slowly changing dimensions
- Worked with Connected and Unconnected Lookups
- Performed integrated testing for various mappings and tested the data and data integrity among various sources and targets
- Designed and developed mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy
- Monitored transformation processes using Informatica Workflow Monitor
- Designed the data modelling
- Environment: Informatica PowerCenter 9.1, Netezza, SQL Server, UNIX, Control-M
- Project: PAR (Performance Analytics Reporting)
- Extraction, Transformation and Loading (ETL) of data by using Informatica PowerCenter
- Developed mappings for Call quality, Sales metrics data
- Created many PL/SQL batches and executed them through UNIX Shell scripts
- Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer
- Extensively worked with Joiner functions like normal join, full outer joins, master outer joins, and detail outer join in the Joiner transformation
- Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment
- Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy
- Environment: Informatica PowerCenter 9.1, Oracle, DB2, UNIX, Control-M
ETL Developer12/2010 - 05/2014
JPMC
- Project: RC3 (Report Contact Centre)
- Integrated Avaya source system with upgraded Cisco source system
- With the help of integrated source system, we will generate reports to the Business manager for every 30 mins interval
- Implemented SCD-Type2 to keep track of history
- Integrated Avaya CMS and Cisco data
- Developed Informatica Mappings to Extract Data from Stage to ODS
- Designed and developed mapping, transformation logic and processes in Informatica for implementing business
- rules and standardization of source data from multiple systems into the data warehouse
- Developed new Informatica mappings and workflows based on specifications
- Designed and developed various Informatica mappings using transformations Like Expression, Aggregator
- External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy
- Developed various Ad-hoc mappings for various business needs
- Performed extraction, transformation and loading of data from RDBMS tables
- Flat Files into Teradata in accordance with requirements and specifications
- Developed and tested all the backend programs, Error Handling Strategies and update processes
- Created Sessions and Workflows
- Environment: Informatica PowerCenter 9.1, Oracle, SQL Server, UNIX, Control-M
- Project: Wave 3 Semantic: Migrated the Ab-Initio code to Informatica
- Developed the code in Informatica using PDO from integration layer to semantic layer in the form of physicalized mappings or views using Ab-Initio logics
- Code development from Ab-Initio logics
- Analysed business requirements and worked closely with the various application teams and business teams to understand business requirements and the source data
- Involved in designing logical models for staging, production warehouses using Erwin
- Designed and developed several ETL scripts using Informatica, UNIX Shell scripts
- Extensively used all the features of Informatica including Designer, Workflow Manager, Repository Manager, Workflow Monitor
- Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations
- Partitioned sources to improve session performance
- Created users in Informatica, assigned them various permissions
- Backup/Restoration of repositories
- Worked on defect fix
- Code Deployment to QA
- Created the jobs in Control-M
- Involved in Analysis phase and Data modelling
- Environment: Informatica PowerCenter 9.1, Ab-Initio, Teradata, UNIX, Control-M
- Project 3: Digital Marketing: SOR: Factory model:
- Met with analysts, architects, and business users and prepared design documents as per business logic
- Extensively worked on extract, transform and load the data from different source systems like Oracle, Teradata and flat files using Informatica PowerCenter tool
- Worked on slowly changing dimensions (SCD) type I and II using lookup, filter, and update and expression transformations
- Involved in unit testing, regression and system testing
- Worked on performance tuning by increasing cache, override the SQL
- Involved in peer review of the developed mappings by team members
- Coordinated with testing team to make them understand Business and transformation rules being used throughout
ETL process
- Created Shell scripts to automate the production job runs
- Environment: Informatica PowerCenter 9.1, Oracle 11g, PL/SQL, Teradata, UNIX
Skills
Ab-Initio.Databases: NetezzaTeradataOracleSQL serverOperating Systems: UNIXUNIX Scripting.Programming: PythonSparkAb- Initio.business dataflow and data relation.OLAPXML filesTransformationsdevelop complex database SQLNetworkIDQIDEUATPre-PRODdatabase designdevelopmentIMSIDMSTransformationData TransformationsData CleansingWeb Service IntegrationDatabase RelationshipsDaily stand up'sHuddle's.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง ETL Solution Architect Project Honeywell - Saginaw, MI ประสบการณ์ 5 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ