ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 160
Resume Example ETL Developer #0160 ประมาณ 2327 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง BI Developer / Panjiva - Virtual, WV ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 7 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 5 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 7 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI, Tableau ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา ETL ให้ความสำคัญ
- ประสบการณ์ 5 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 12+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
I am a SQL/BI developer (SSIS | SSAS | SSRS | Power BI) with over 7 years of extensive IT experience in querying, designing, and maintaining databases, as well as developing Business Intelligence solutions on MS SQL Server. I possess strong knowledge and a wide range of working experience in implementing robust and scalable BI solutions, and creating ETL packages using SSIS to automate data migrations from various sources to SQL Server, both on-premises and in the cloud, and vice versa. I am skilled in developing reports and dashboards using different reporting and visualization tools, such as Power BI, SSRS, and Tableau. Highly experienced in Azure Cloud Services (ADF, Synapse, Azure SQL, etc.) and with strong programming skills (SQL, Python) for data analysis, I have demonstrated success in utilizing a diverse range of technologies and tools to drive data-driven decision-making and optimize business performance. I am adept at collaborating with cross-functional teams, managing multiple projects simultaneously, and delivering high-quality results within tight deadlines..
Experience
BI Developer / Panjiva - Virtual, WV04/2020 - Current
- Analysis and reporting services: SSAS, SSRS, SSAS, Microsoft Power BI, MS Excel
- Cloud technology: AZURE Data Lake, Azure Data Factory, Azure Data Warehouse, AZURE SQL Database, Azure Synapse, Azure Logic Apps.
- SQL server Tools: SQL server management studio, Database engine, Import and export wizard
- Architecture: Relational DBMS, Client-server architecture, OLTP, OLAP
- Version Control: GIT
- Other Tools: Autosys CA Workload Automation Tool
- Languages; TSQL, ORACLE PL SQL, MySQL,, VB, POWERSHELL, DAX, MDX, Python
- Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse
- Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse
- Designed and implemented ETL processes using SSIS and SQL to collect, clean, and transform data from multiple sources, resulting in a 25% improvement in data accuracy
- Developed and maintained scalable data pipelines in SSIS, allowing for efficient processing and analysis of large datasets
- Designed and implemented data pipelines using Azure Data Factory to extract data from various data sources, transform and load it into Azure SQL Database for analytical reporting.
- Create fully Automated Azure Data Factory Pipelines and configured appropriate Error Handling with Azure Logic Apps.
- Collaborated with cross-functional teams, including data analysts and data scientists, to ensure data integrity and improve the quality of business insights
- Actively participated in gathering Business Requirements and System Specification
- Participated in implementing the logical design to the physical design by creating tables
- Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands - Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
- Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database
- Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation
- Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environments
- Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task
- Created database objects like tables, view, store procedures, functions, triggers using SQL server
- Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required
- Created reports on both cascading and standard parameters
- Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors
- Worked on Power BI in creating dashboards and reports and visualizing data
- Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database
- Used Power Query to acquire data, developed calculated columns and measures using DAX in Power BI desktop for designing rich visuals using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map
- Shared with user groups, scheduled and maintained the Power BI reports published to the Power BI Service
- Sourced data from SQL Azure database, SQL Azure Data warehouse, AWS RDS solutions such as MySQL Aurora and Redshift for my Power BI reports
- Created SSIS Packages by using advance transformations (i.e
- Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and used Custom components such as Audit on Pre-Execute, Audit on Post-Execute and Statistics Logging Component
- Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis
- Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily
- Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
Senior ETL Developer Epam Systems Inc - PA, State03/2018 - 03/2020
- Manage daily operations, including database backups and restores, maintenance jobs, and developers' requests - Optimizing data pipelines and applications for performance by tuning Spark configurations, optimizing SQL queries, and implementing caching strategies
- Designed, developed, and maintained data pipelines using ADF and Azure SQL for a large e-commerce organization with over 100TB of data
- Designed and developed data ingestion pipelines using SSIS and Azure Data Factory, processing large-scale
- datasets from various sources and formats including structured, semi-structured and unstructured data, and enabling real-time and batch processing workflows.
- Utilized Azure Data Factory Mapping Data Flows for advanced data transformations and integration with Azure Databricks for advanced data processing.
- Developed data storage solutions using Azure Blob Storage and Azure Data Lake Storage, enabling scalable, distributed data storage and retrieval with advanced features such as Azure Data Lake Storage Gen2 tiering and Azure Blob Storage lifecycle management.
- Designed and implemented data models using Azure Synapse Analytics, enabling efficient querying and analysis of large datasets. Optimized the performance of queries by tuning partitioning and indexing strategies, and implementing Azure Synapse Analytics SQL pool to provide high-performance analytics capabilities for large datasets.
- Created T-SQL scripts, which generated tables and relationships, based on the customer's request
- Identified source, destination and staging area per ETL strategy and performed data cleansing and data profiling
- Creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures
- Created new database objects such as procedures, functions, indexes and views utilized T-SQL
- Used System as well as User-Defined functions to enhance the functionality of my T-SQL code
- Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server
- Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment
- Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling
- Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, and Execute Package Task
- Optimization of queries by looking at Execution Plan for better tuning of the database
- Created Dynamic SSIS packages using complex expressions, variables and control flow components such as for each Loop Container to loop over a Directory to load inbound files coming daily
- Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure
- Moving data from on premise to Azure storage accounts (Blob, Data Lake) for staging purposes, transforming data
- and moving to destination tables Azure SQL DW (Dedicated SQL Pool) or Azure SQL
- Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.
- Developed numerous ad-hoc reports using SSRS for day-to-day financial reporting generated custom and parameterized reports using SSRS
- Used SQL Server Agent for scheduling jobs and alerts
- Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc
BI Developer03/2017 - 03/2018
Panjiva - Boulder, CO
- Gathered, analyzed and documented the business requirements and business rules by directly working with end users/clients
- Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan
- Developed and deployed database objects such as stored procedures, triggers, indexes, views, and UDFs in SQL Server
- Modified temporary tables, indexes, and lookup techniques to optimize stored procedures
- Developed database objects like tables, stored procedures, triggers, user defined data types and functions
- Created and updated clustered and non-clustered indexes to keep up the SQL Server performance
- Implemented Error handling through TRY-CATCH method and used CTES
- Created SSIS packages for data loading utilizing various task and transformations (such as execute SQL task, script task, execute package task, data flow task, fuzzy lookup, lookup, OLEDB command, derived column etc.)
- Extracted and loaded data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging area
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users
- Worked with Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning
- Repaired SSIS packages with checkpoints, breakpoints, and data viewers
- Created SSIS packages utilizing different transformations in SSIS toolbox such as aggregate, Merge, and Merge join
- Incorporated package configurations such as XML files and environment variables to improve compatibility
- Designed ad hoc SSRS reports in the test environment for data validation utilized SQL Server 2012
- Optimized reports by optimizing the embedded queries or improved the stored procedures that generate them
- Formatted the reports by applying parameters, assigned parameter defaults and data types and extended reports.
Power BI Developer02/2016 - 02/2017
First International Bank & Trust
- Utilized Power BI's mapping capabilities to create geographic visualizations and perform location-based analysis.
- Developed drill-through and drill-down capabilities in reports to enable end-users to explore data in more detail.
- Used conditional formatting and data bars to highlight important data points and trends in reports.
- Created visually appealing and interactive dashboards and reports using various chart types, such as column charts, line charts, scatter charts, and funnel charts.
- Ensure data security and compliance with company policies and regulations
- Optimize data models for performance and scalability
- Provide training and support to end-users on how to use Power BI reports and dashboards effectively
- Work closely with business stakeholders to understand their data requirements and develop solutions to meet their needs
- Develop and maintain interactive dashboards and reports using Power BI Desktop and Power BI Service
- Collaborated with IT and data engineering teams to integrate data sources into Power BI reports and dashboards
- Used DAX to crea time-intelligence calculations, such calcula period-over-period growth and year-to-date values.
- Optimized DAX queries for performance and efficiency by using techniques such as table partitioning and query folding.
- Utilized DAX to create dynamic visualizations and drill-down hierarchies in reports and dashboards.
- Developed custom measures and calculated columns to support complex business logic and calculations.
- Created complex DAX expressions to calculate KPIs and perform data analysis, such as calculating running totals, year-to-date values, and moving averages.
- Designed and implemented data models and queries using Power Query and DAX
- Developed and maintained Power BI reports and dashboards for various business units
- Built a recommendation engine for an e-commerce platform using collaborative filtering and matrix factorization techniques, resulting in a 20% increase in click-through rates and sales
- Wrote T-SQL queries, Store Procedures and used them to build packages and reports
- Developing several behavioral reports and data points creating complex SQL queries and stored procedures using
- Improved Stored Procedures and SQL Queries performance by analyzing execution plans and creating proper
Indexes using SQL Profiler and Database Tuning Advisor
- Designed various SSRS reports as requested by the client
- Developed several SSIS packages and data flow tasks by using SSIS
- Extracted data from different sources and stored into SQL Staging tables in BI Staging database
- Developed SSIS Packages and Stored Procedures to load/transform/cleanse data from SQL Server, Oracle and Excel Files to Facts and Dimension Tables in the Data Warehouse
- Created SSRS reports such as tabular, matrix, charts, dashboard and sub-reports using SSRS 2012
- Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
Education
- Bachelor of Science: Computer Science
- University of Technology Ganja - Azerbaijan
Skills
ViewsConstraintsIndexesJoins.stored procedurestriggersUser Defined functions.Creating IndexesLinuxDTSSQL server Management Studio (SSMS)SQL server integration services (SSIS).
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง BI Developer / Panjiva - Virtual, WV ประสบการณ์ 7 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 5 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ