ตัวอย่าง Resume นักพัฒนา ETL (ETL Developer) ฉบับที่ 161
Resume Example ETL Developer #0161 ประมาณ 1766 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Logging, Real-time / MSBI Developer ระดับมืออาชีพ มีประสบการณ์รวมประมาณ 5 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 3 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 5 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- มีการกล่าวถึง Power BI, power BI, MBA ซึ่งเป็นสิ่งที่ HR สายนักพัฒนา ETL ให้ความสำคัญ
- ประสบการณ์ 3 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 40+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
- Over 5 years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2014, 2012, 2008 in Production, Testing and Development. - Experience with software development life cycle (SDLC), Agile/Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. - Proficient in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries. - Well versed in Data Modeling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries. - Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages. - Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings). - Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS. - Hands on experience with performing various SSIS data transformation tasks like Look-up, Fuzzy Look-up, Conditional Splits and Event Handlers. - Strong knowledge in designing Extraction, Transforming and Loading (ETL) data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS. - Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services). - Expert in creating various types of reports like complex drill down reports & drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. - Solid experience working on offshore-onshore model. - Good knowledge on SSAS to create cubes using data from data marts/data warehouse for deeper and faster data analysis. - Experience in cubes construction based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Fact and Dimension Tables. - Hands on experience on publishing Power BI reports of dashboards in Power BI server and scheduling the dataset to refresh for upcoming data in power BI server. - Excellent communication skills with capability to form and maintain positive and productive working environment as an individual or a team player.
Experience
Logging, Real-time / MSBI Developer10/2018 - Current
Cognizant Technology Solutions
- Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
- Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
- Involved in Performance tuning and Query Optimization by using SQL profiler.
- Resolved deadlocks issues with the databases and servers on a real-time basis.
- Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
- Migrated SQL Server databases to latest version 2014 from SQL server 2005.
- Integrated data from homogeneous, heterogeneous sources and legacy systems (SQL, DB2, Excel sources) to SQL server database.
- Generated performance-based reports using SSRS for the managers to show holdings against various measures like time, area, and price- range.
- Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
- Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
- Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
- Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third-party data source to transfer data.
- Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases.
- Designed, developed, modified, and enhanced the database structures and database objects.
- Worked as point of contact for the offshore team in India.
- Updated the existing Business Objects Universes as requested by the users with the new requirements to add new universe classes and objects for new database entities and attributes.
- Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), Power BI, Microsoft Visual studio 2010, SharePoint, C.
SSIS Developer02/2017 - 10/2018
Cognizant Technology Solutions
- Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
- Worked as an SQL developer to write complex queries like Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL joins for applications.
- Creating table indexes and constraints to ensure data integrity and enhance query processing.
- Actively involved in requirements gathering/analysis, meetings with Business and provide description about the analysis and approach.
- Created Request for Change (RFC) for Change Management Request (CMR) for moving database/ tech changes from Development to Testing and to Production during sprints.
- Created and developed SQL server jobs on SQL Server Integration Services (SSIS) packages to automate the execution of the packages at a time depending on requirements.
- Also, used SSIS to move data from text files to SQL Server.
- Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
- Exclusively used SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
- Worked extensively with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
- Created SSIS packages for transforming data from warehouse to mart, to import data from source systems, or transfer data from one server to another.
- Designed daily/weekly/monthly SSRS reports utilizing multiple types of reports including sub reports, Drill Through/Drill Down, and Cascading Parameterized Reports.
- Created cube structure for the analysis of business condition and for creation of report using SSAS.
- Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
- Used Power View and Power Map to visualize reports in Power BI.
- Used Microsoft Power BI 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.
- Coordinated and attended every day standup's/scrum/agile meetings and weekly sprint meetings to evaluate completed work.
- Worked efficiently on Agile Methodology and Microsoft Team Foundation Server (TFS).
- Environment: SQL Server 2014, Visual Studio-2010, SSAS, SSIS, T- SQL, Power BI, TFS, MS SQL Server 2005/2008, MS-Office, MS
Excel. / SQL/ETL Developer05/2015 - 01/2017
Apex Systems
- Involved in Preparation of documentation for all the requirements and enhancements to reports.
- Design and develop SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
- Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
- Hands on experience working on Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
- Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
- Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Test and Production Environments.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
- Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
- Created cross validation rules to ensure mapping accuracy.
- Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
- Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
- Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc. - Implemented Triggers for checking complex business conditions, providing security for the tables.
- Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database. - Ability to handle Multiple tasks, Initiative and Adaptable.
- Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
- Environment: SQL Server 2008R2/2012, SSIS, ETL, SSRS, SSAS, DTS, OLAP, MS Access, Trello, Windows, SharePoint, MS Visio.
Education
- MBA: 2008
- Tribhuvan University
Skills
Operating SystemsOracleMYSQLMS-Access.Reporting ToolsSQL Server Reporting Services (SSRS)Power BICrystalReportsSQL Server Analysis Services (SSAS)ETL/Database ToolsT-SQLSQL Server Management Studio (SSMS)SQL ServerIntegration Services (SSIS)Web TechnologiesHTMLXMLJavaScriptVBScriptCSSOther Software ToolsSQL ProfilerMS Office/ExcelMS ProjectSharePointMS VisioC#AdMS AccessSDLCAgileSelf-motivatedAnalytical skillsMS-ExcelServersApproachExcelScriptsAutomate
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Logging, Real-time / MSBI Developer ประสบการณ์ 5 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 3 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ