ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 153
Resume Example ETL Developer #0153 ประมาณ 1311 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Senior BI Developer ระดับอาวุโส มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI, Tableau, SAP ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา ETL ให้ความสำคัญ
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 9+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Well-qualified Business Intelligence Developer with a history of working in diverse industries like Banking and Finance, Food and Beverages, Logistic and Supply chain rentals, Consumer Products, Retail and Distribution, Telecommunications, and Gaming. Demonstrated success in taking complex requirements and building efficient, successful reporting solutions. Knowledgeable about requirements gathering. data analysis, visual analytics (reporting & dashboards) development, project management, agile/waterfall methodology, QA/UA testing. SQL.
Experience
Senior BI Developer03/2022 - Current
Apex Systems
- Technical: SQL, Data Management, Data Warehouse Architecture, Power BI, Tableau, Python and R.
- Migrated existing reports from Tableau platform to Power BI service and embedded the same in the organization webpage
- Collaborated with different teams to gather requirements and understand the business/logic behind the reports/ dashboards that are being developed to cater to the reporting needs of various clients/stakeholders
- Provide support to already existing reports in production workspace and handling enhancements as when requested
- Managed the data models in Power BI by pulling data from different sources like Teradata, SQL DB, OData, Excel Workbook etc. and handling the relationships, cardinality, and cross filter direction across all tables
- Created calculated columns, calculated tables and measures using DAX (Data Analysis Expression) language to manage rankings of the dimensions
- Designed Inclusion, Diversity & Equity report for the HR leadership team considering gender, race/ethnicity, retirement, hire, promotion, and separation dimensions based on different org functions, regions, and grade levels by loading data from SAP system into SQL DB
- Designed an interactive Aiming Point report for the HR leadership team to understand where they stand in terms of the percentage of salaried employees at different grades, races, and gender against the organizations aiming point target percentage
- Leveraged heavily on bookmark features with Power BI to give the user a look and feel of an app while toggling or navigating to different reports or subset of reports
- Worked on publishing the reports on different workspace, adding required AD groups, and handling the schedule refresh of the datasets for different reports
- Responsible to co-ordinate with offshore team on daily basis and discuss the issues/clarifications
- Developed Power BI reports for the sales team based on the store allocation and region and restricted the data to specific users using DAX, row level security (RLS) which helped the sales team to increase the compliance score of the deployed activities from 98.5% to 99.4%
- Designed and developed Net-Net Sales dashboard to report NNS figures to Sales team based on factors like converted and validated status of the opportunity received from the on-field sales representative feedback
- Designed Executive dashboard which acted as a driving factor in leadership decision to on average double the number of activities deployed for the sales team each week thereby increasing revenue by 36.5%
- Led a team of 3 to achieve reporting requirements of the clients by delivering reports in a timely fashion
- Responsible to drive the demo/Q&A session for client post each delivery to gather user feedback on the reports
- Designed DDL, DML, Stored Procedures and views in SQL DB to cater to the reporting needs
- Designed pipelines in ADF to load files from ADLS/BLOB to SQL DB
- Developed, tested and deployed standard reports and dashboards based on business requirement document specifications
- Developed Financial reports for the Office of the CIO providing key metrics (eg. Capex, Opex, Variance etc.) to measure the success of the project
SDET/ETL QA02/2020 - 02/2021
Cisco Systems, Inc.
- Involved in participating in the full software life cycle for testing (STLC) activities from test planning, test execution to test monitoring and status reporting
- Attend the Sprint planning meetings to plan the testing activities and provide test estimation
- Attend the Sprint review meetings to review the tasks and get the user stories accepted in Jira
- Attend the backlog grooming and Sprint planning meetings and work with scrum master/product owner to prioritize the tasks
- Responsible to co-ordinate with offshore team on daily basis and discuss the issues/clarifications
- Involved in Test Plan, Test Case and Text Exit review meetings with project team and application support
- Responsible to set up the QA environment in Teradata
- Responsible to deploy the Teradata jobs/scripts in QA environment through Jenkins
- Design the test cases based on S2TM documents to validate ETL transformations between source and target systems
- Responsible to run Teradata jobs in QA environment through Control-M or Manually
- Execute the Test cases & Scripts for Functional, System, Regression, and Integration
- Involved in writing Complex SQL queries using Joins, Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Teradata for Data Validation between source and target systems
- Validating the data in various stages of data movement from Source file Ingestion to Teradata Staging, Teradata Staging to Teradata Core and from Teradata Core to Semantic views (used by business for reporting purpose)
- Execute all the Test Cases in the Test Environment and maintained and documented the test queries and result for future references
- Generate and validate the data in the reports using Power BI reporting tool
- Closely working with Dev and DA teams to triage the open defects/issues in Q-test
- Responsible to retest the defects and dependent functionality after fixing the defects
- Responsible for analyzing the production defects and provide the root cause analysis and solution
- Responsible to support UAT team with data loads in the required target tables
- Participated in project review meetings and daily scrum calls
- Developed presentation and testing implementation learning to other testing resources for cross functional training
- Actively participated in project specification reviews, writing, and maintaining QA technical documentation
Business Operations Analyst / Wayfair - City, STATE01/2019 - 06/2019
- Co-ordinated with various suppliers to understand and test inventory integration on EDI, FTP or API to ensure go- live transition is smooth and hassle-free
- Developed and maintained a framework for reporting supplier inventory performance on a daily, weekly, and monthly basis
- Developed an Out-of-Stock Back Order dashboard using SQL, Power BI for Inventory Quality team to trace, report and analyze supplier backorders information at SKU, warehouse, and category level Designed and built SQL- enabled Power BI dashboards for Operations team to help visualize and report daily/monthly figures regarding supplier performance thereby cutting down manual work by ~30%, from 210 minutes a week to 150 mins
- 04/2013 to 05/2017 Business UAT Analyst - Team Leader JP Morgan Investor Services - City, STATE
- Managed projects to automate various functions of the SWIFT payment system to simplify high-risk manual exceptions with lengthy operations process by 7%
- Logged, tracked, and escalated defects using ALM/JIRA and reported to stakeholders in a timely manner
- Led a team of 4 to achieve Operations efficiency project for Corporate and Investment banking team to reduce operating cost by 8%
- Trained new hires, operations team and stakeholders on new requirements or changes implemented in the systems Delivered up to 98% scope coverage for end-to-end testing in waterfall and agile methodology
- Managed client implementation by being a part of the Production Verification Testing (PVT) team
- Performed triage, troubleshooting and analysis of issues and failures to determine if an issue is a defect, enhancement, or user-error
- Generated weekly status report, defect report, test execution metrics and test summary report using MS-Excel and SQL
Education
- Master of Professional Studies: Analytics
- Northeastern University - Boston
- Bachelor of Engineering: Electronics and Telecommunications
- Mumbai University
- Microsoft Power BI Data Analyst Associate (03/28/2021-03/28/2023) · Microsoft Azure Data Fundamentals (06/28/2021)
Skills
Functional: Data AnalysisStatistical AnalysisPredictive ModelingProject ManagementResearch and ExplorationProblem SolvingStrategic/Tactical PlanningBusiness AnalysisCommunications.
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Senior BI Developer ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ