More Related Content
What's hot (20)
Similar to ETL Developer Resume (20)
ETL Developer Resume
- 1. TEFERI HEYE tefUtam@gmail.com Cell # (214)-779-7479 Professional Experience ï‚· Over 3+ years of IT Professional experience in Development, Database Design, and Presentation using SQL Server 2012/2008R2/2008/2005/2000. ï‚· Experience of the entire Software Development Life Cycle (SDLC), IT systems and processes, methodologies and their direct implementation to projects. ï‚· Experienced in routine Database Backup/Recovery procedures & 3rd party tools. ï‚· Experience in dealing with Constraints,Querying, Joins, Keys, and Indexes. ï‚· Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration. ï‚· Experience in Microsoft stacks of BI solutions - SSRS, SSIS with MS SQL 2012/ 2008R2/2008/2005/2000. ï‚· Created User Defined functions to simplify code with in stored procedures as well as utilized data sources in complex ETL packages. ï‚· Used DML triggers as well as DDL triggers as constraints,Complex queries, stored procedures,Views and Functions. ï‚· Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications. ï‚· Created complex SQL Server 2012 SSIS packages for data manipulation, data validation purpose using Scripts. ï‚· Created SSIS package configurations using XML configuration, SQL Server, parent package variable, registry entry and environment variable. ï‚· Deployed the SQL Server 2005/2008/2008 R2/2012 SSIS packages. ï‚· Expertise in building and migration of various DTS packages using MSDB, File system,File system storage methods. ï‚· Scheduled SQL Server 2005/2008/2008 R2/2012 SSIS packages using SQL Server Agent. ï‚· Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data ï‚· Created Sub-reports, Linked reports, Ad-hoc reports, Map reports, Charts, Gauges, and Report Builder 3.0 in SQL Server 2008/2008 R2/2012. ï‚· Configured, administered Report Manager and created item level securities, group permissions in SQL Server Reporting services. ï‚· Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS). ï‚· Proficient in design of ETL and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text ,XML, Access,Oracle, DB2, SQL) by using multiple transformations provided by SSIS such as Aggregate,Data Conversion, Conditional Split, Bulk Insert, Fuzzy Grouping, Fuzzy Lookup and Merge). ï‚· Proficient in designing OLAP (Online Analytical Processing), OLTP (Online Transaction Processing) systems. ï‚· Experience in creating Packages, scheduling Jobs and sending Alerts using DB Mail. ï‚· Created Documentation, ER Diagrams using MS Visio and Erwin for ER modeling. ï‚· Expertise in Database Consistency Checks using DBCC Utilities, DMVs and DMFs. ï‚· Design, Re-organize and implement network structure. ï‚· Maintenance and troubleshooting software and Hardware problems and improving the performance of the device. ï‚· Organizing the Record and Library management system structure and making them functional to customer and giving training on the automated system.
- 2.  Network support and troubleshooting  Excellent problem solving skills for delivering useful and compact solutions. Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in development Environment.  Ability and willingness to learn new technology and deliver results in a timely manner.  A well-organized, goal-oriented, highly motivated effective team member. EDUCATION / CERTIFICATIONS Bachelor of Computer Science – Hawassa University, Ethiopia Microsoft SQL Server 2012 Business Intelligence Training Certification Enterprise Level Networking Training Certification Technical Summary Operating Systems Windows Server 2003, Windows 2000 Server, Windows 98/XP/Vista/7/windows 8/Linux Database Tools Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS,SQL Profiler Web Technologies HTML5,CSS3,JavaScript,XML Tools Visual Studio 2010 ,Eclips,Netbeans Languages C#, T-SQL, Java Databases SQL Server 2012/2008 R2/2008/2005/2000,MS Access OLAP Tools SQL Server Reporting Services 2012/2008/2005, SSIS (as ETL) Third Party Tools Red gate, Lite speed,MS Visio, Erwin Framework Spring framework,.Net Framework REFERENCES  Nick pettite-Web Designer and Teacher at Treehouse www.teamtreehouse.com www.twitter.com/@nickrp  Guil Hernandez-Front-End designer and Teacher at Treehouse.www.twitter.com/@guilh  Haileyesus Teshome -Software Developer 614-256-0243 hailat2009@gmail.com  Andargachew- MSSQL SERVER BI Expert 469-348-5228