ตัวอย่าง Resume นักพัฒนา SQL (SQL Developer) ฉบับที่ 232
Resume Example SQL Developer #0232 ประมาณ 1389 คำ
เรซูเม่ฉบับนี้เป็นตัวอย่างสำหรับตำแหน่ง Senior SQL Server Database Application Developer ระดับอาวุโส มีประสบการณ์รวมประมาณ 10 ปี เรานำมาวิเคราะห์เพื่อให้เห็นว่า โครงสร้างมีจุดเด่นอย่างไร และส่วนใดนำไปปรับใช้กับข้อมูลของคุณได้
จุดเด่นของฉบับนี้ แสดงประสบการณ์ทำงาน 6 ตำแหน่ง พร้อมหน้าที่และผลงานของแต่ละช่วงอย่างเป็นลำดับ
สิ่งที่ควรสังเกตในตัวอย่างนี้
- ประวัติงานต่อเนื่อง 10 ปี เห็นการเติบโตของตำแหน่งได้ชัด
- ประสบการณ์ 6 ตำแหน่ง ไล่ระดับจาก Junior ขึ้นไปจนถึงตำแหน่งปัจจุบัน
- Professional Summary กระชับ ใช้คำที่สื่อความสามารถได้จริง
- มีทักษะแยกเป็นหมวด 38+ รายการ ให้ HR เห็นสเปกครบถ้วน
Professional Summary
Seeking Senior SQL Server and .NET Development position Progressive and varied experience in SDLC (software development life cycle) for database applications in diversified industries such as IT Services, telecommunications, and retail companies. Possess excellent communication skills, strong customer support and troubleshooting skills. Recognized as a highly motivated, proactive team player, and problem solver. Other strengths include: *Strong Verbal and Written Skills *Highly Analytical and Well Organized *Data Normalization for OLTP *OLAP Star and Snowflake Schema *DTS and SSIS for ETL *Report Design and Development *Object Oriented Analysis and Design *.NET Development
Experience
Senior SQL Server Database Application Developer02/2009 - Present
Hcl Technologies Ltd.
- As a core developer in a small team within a fast-paced environment, provided solutions according to user requirements in a timely and efficient manner.
- Involved in full life cycle of software development including requirement analysis, system design, implementation, testing, deployment and production support.
- Environment: SQL Server 2005/2008, SSIS, SSRS, Windows Server 2003/2008, Visual Studio 2008/2010, .NET 3.5/4.0, C#, ADO.NET, batch file scripting, FTP/Secured FTP.
- Interacted with wireless network design engineers for business requirements, designed back-end database tables, indexes, created stored procedures, implemented Gold Standard Audit System using C#, ADO.NET, automated the manual audit process for array value parameters, single value parameters, range value parameters, greatly improved productivity.
- The Audit System is now providing daily audit of the ATT nation wide wireless network configurations;.
- Created complex stored procedures, functions, views, SSIS and C#.net programs to extract, transform and load data from different data sources, including Excel, XML files and database servers;.
- Utilized Common Table Expression (CTE), dynamic column Pivot tables, ranking functions, outer joins and sub- queries for complicated data extraction and report generation;.
- Experienced with stored procedure performance tuning using Execution Plan, DMVs and SQL Profiler..
- Provided performance analysis and identified index fragmentation, missing index; implemented nightly maintenance process to de-fragment index pages when necessary and notify.
- Created ETL packages using SSIS to download files from SFTP server (utilized Winscp through Execute Process task), extract data from CSV files, and load it to SQL Server database, included error handling and data integrity constraints enforcement;.
- Developed reports using SSRS, Telerik, FarPoint, and C#, ASP.NET, ADO.NET,;.
- Installed and Configured SQL Server 2008 R2 database servers, migrated databases from SQL Server 2005 to SQL Server 2008 R2;.
- Configured and administrated SQL Server 2008R2 Reporting Services server users;.
- Implemented procedures for database backup, restoration and optimization;.
- Designed intranet Web applications to upload and format check user input files with online update and validation, and to generate PDF/Excel reports with data extracted from databases, using ASP.NET, C#, ADO.NET, Visual Studio 2008;.
- Designed and implemented a component used in web applications to populate data from large user input excel files(more than 20M) with C#, SQL Bulk Copy, ADO.NET and GemBox, extracting 10,000+ records from excel file within seconds;.
- Evaluated and recommended software/ 3rd party tool to extract large amount of data from excel files with macros and graphs;.
- Provided back-end data collection and mid-layer (web services) to access databases using C#, ASP.NET and ADO.NET;.
- Participated in development of procedures and processes;.
- Mentored other team members, provided consultation and advice, contributed to Code-Review.
Senior Software Developer (Consultant)03/2008 - 10/2008
- Designed ER diagrams and developed database on SQL Server 2005.
- Involved in database upgrade from SQL Server 7.0 to SQL Server 2005.
- Participated in requirement analysis, technical design for database server upgrade.
- Implemented and tested stored procedure modifications according to SQL Server 2005 Upgrade Advisor Report.
- Provided solutions to eliminate xpcmdshell usages by using SSIS packages, SQL Agent Jobs and stored procedures.
- Experienced with data modeling and database design, data normalization.
- Designed and implemented credit card account number encryption/decryption application using ASP.NET Web Services, C# and .NET 2.0.
- Redesigned, developed and tested Salon Schedule Book Broadcaster - a windows service application, provided technical design documentations, implementation and unit testing using UML, C#, .NET 2.0, TCP/IP sockets, asynchronous and multi-threading technology.
Software Engineer04/2005 - 02/2008
Hcl Technologies Ltd.
- Participated in system design, development, modifications, enhancements, and ongoing production support for an enterprise Data Warehouse system (Enterprise Information System).
- The system extracts data from DB2 database, text files and mainframe hosts and loads them to SQL Server data warehouse using different Data Transformation Service (DTS) packages, ADO.NET, C# and provides reports using SSRS from both relational OLTP model and multi-dimensional OLAP SSAS cubes.
- Our team is also responsible for scheduling the packages using Batch files and SQL Agent jobs.
- Redesigned, implemented, unit tested database schema, stored procedures and DTS packages for CaseMix module
- applied multi-dimensional Snowflake schema, reduced system runtime by more than 30%
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
- Designed and created different ETL packages to migrate data from DB2 database and flat data files;.
- Implemented scheduled polling for proactive incremental data extraction in SQL Server 2000 environment using SQL Agent;.
- Configured SQL mail Agent for sending Automatic emails on Errors.
- Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
- Created schema, views, stored procedures, Triggers and functions for Data Migration.
- Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
- Designed and developed reports through SSRS;.
- Provided solutions for customer requested automation and feeds using ASP.NET, .NET development for Microsoft Office, C#, greatly improved productivity and efficiency;.
- Implemented and documented major changes for Labor Adjustments modules using C#.NET, ADO.NET, OLEDB;. - Interacted with client and application teams, coordinated monthly production release schedules, implemented production deployments;.
Application Developer / Pennymac - Raleigh, NC01/2002 - 01/2004
- Lead designer and developer for Enterprise Information Support System, a company-wide operational data integration and report generation system that is capable of extracting corporate data from different systems and providing the single version of the truth reports in a timely and cost-effective manner (ER Diagram, T-SQL, SQL Server DTS package, Stored Procedure, Trigger, OLAP, Crystal Reports, Excel).
- Conducted data modeling and database design using ER diagram;.
- Automated the enforcement of data integrity by utilizing triggers and constrains, reduced maintenance cost by over 50%
- Streamlined and automated the report generation processes for improved efficiency using SQL Agent job scheduler, batch files, and DTS packages.
Software Engineer01/2000 - 01/2002
MCI WorldCom
- contractor) Core Designer for FDBAudit, a remote database synchronization subsystem used in Redirect Server of WorldCom's next generation product Voice over IP (C/C++, IDL, CORBA, Oracle, Rational Purify, UML, Rational Rose, UNIX, Perl, Korn shell scripting, ClearCase).
- Designed interface between FDBRemote and upper level subsystem using CORBA IDL, and prototyped the interface with C++ code.
- Utilized Rational Purify to debug run-time memory leak/corruption and took appropriate action to ensure availability of resources, reaching a new milestone one and half months earlier.
Application Developer01/1996 - 01/2000
AEGIS COMMUNICATIONS GROUP
- Designed and implemented backend data communication applications between Aegis' DG system and Fortune 500 American Express' system using C/C++, IBM-HLLAPI, SNA3270 and Client/Server programming.
- Increased the reliability of the backend communication server by over 30%.
- Developed Customer Relation Management projects for the company's major client.
- Responsible for the whole development life cycle including business analysis, application design and implementation (used C/C++, ESQL, Informix-4GL), testing and maintenance.
- Received recognition Award from American Express for top quality application delivery.
Education
- University of North Texas - Denton, Texas · Computer Science · BS: Computer Science
- Hunan University - Changsha · Computer Science
Skills
DTS PackageSSISSSRSSSASSQL Server Management StudioSQL Server ProfilerInformixOracleC/ESQLdBASE IVLanguages: C#C/C++PerlXMLHTMLJavaScriptCGIShell ScriptJavaVBScriptExcel VBAADO.NETASP.NETUMLVisioVSSCrystal ReportsODBCRational RoseUNIX(Sun Solaris)LinuxProtocols: CORBATCP/IPIPCSIPVOIPSSL
สรุปว่าจะได้อะไรจากตัวอย่างนี้
ตัวอย่างนี้ช่วยให้เห็นแนวทางการเขียนเรซูเม่สำหรับตำแหน่ง Senior SQL Server Database Application Developer ประสบการณ์ 10 ปี โดยเปิดด้วยบทสรุปที่บอกจุดเด่นของผู้สมัคร ตามด้วยประสบการณ์ทำงาน 6 ตำแหน่ง และข้อมูลการศึกษาที่จำเป็น พร้อมทักษะที่เกี่ยวข้องกับงาน คุณสามารถนำลำดับและวิธีนำเสนอไปปรับใช้ โดยเปลี่ยนรายละเอียดให้ตรงกับประสบการณ์จริงของคุณ
อย่างไรก็ตาม เรซูเม่ที่ชนะต้องเขียนให้ตรงตำแหน่งที่คุณสมัครโดยเฉพาะ ตัวอย่างนี้คือต้นแบบ ไม่ใช่สำเนา ทีมเรซูเม่ของเรารับเขียน Resume และ Cover Letter ภาษาอังกฤษให้โดดเด่นจากคู่แข่ง ส่งงานใน 2 วัน รับประกันความพึงพอใจ