Data Developer
Resume:
Tilahun Hieni [************@*****.***, 641-***-****]
Summary
Mr. Tilahun Hieni is a skilled professional with over 17 years of experience in Data Warehouse, Business Intelligence tools, Software Design, Development, SQL Azure, Power BI, Analysis and Testing. Tilahun has extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing and proficient in ETL (Extract Transform Load) using SQL Server Integration Services 2017/2016/2014/2012/2008R2/2008/2005 (SSIS). He is expertise in OLTP/OLAP/Tabular Model and developed database schemas like star schema and snowflake schema used in relational and multidimensional modeling. He is experienced in analysis, design and construction of data warehouses and data marts. He has excellent technical and analytical skills with clear understanding of design goals of ER (Entity Relationship) modeling for OLTP and Multi dimension modeling for OLAP. He is expertise in developing and delivering dynamic reporting solutions and Dashboard using SQL Server Reporting Services (SSRS) and Power BI. He is experienced in Performance tuning of Queries, indexing to improve Performance of the views and stored procedures as well as Data Migration, Database Backup and Recovery/Disaster Recovery, Database Upgrades/Patches, Troubleshooting, Security, High Availability Solutions. He has ability to code and implement complex business rules in SQL, Triggers and Stored Procedures.
Not only is he a solid BI developer but he has expertise with .NET and BizTalk Application development. With experience in a wide variety of systems and companies from large to small, Tilahun is seeking a new challenge to call upon his technical skill set. He fosters a level of excellence and delivers high-quality, well-planned, effective solutions that meet or exceed expectations. He is dynamic, agile, resilient and flexible and builds strong relationships that contribute to highly successful outcomes.
Tilahun operates in a professional office environment and routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.
Technical Skills
Microsoft Specific Skills
• BI System:
SQL Server 2017/2016/2014/2012/2008R2/2008/2005/2000[SSIS (ETL), SSAS (OLAP, Cube), SSAS (Tabular Model), SSRS, Data Warehouse, Data Mining, Data Modeling (Logical & Physical), Cube, Data Mart, MDX, DAX, SQL Azure, Power BI and KPI
• Database Programming:
T-SQL, Stored procedures, Trigger, Common Table Expression (CTE)
•Client Application Programming:
C#, VB.Net, C, C++, Java, Visual Basic
• BizTalk:
2006/R2, BizTalk 2009, BizTalk 2010 Beta, XSLT, BizTalk Map, Orchestration, Schema, WCF adapter, SQL WCF Adapter, SQL adapter, AS2 Adapter, BAM view
•Data Access Technology:
LINQ, ADO.NET, ADO, RDO, DAO, JDBC, ODBC, OLE DB, Entity Framework
• Server-side Web Scripting:
ASP.NET, ASP
• Client-side Web Scripting:
HTML, JavaScript, VB Script, CSS
• Web Service:
WCF, XML Web Services, WSDL, SOAP, UDDI and IIS
•Big-Data:
Hadoop (HDFS, Map Reduce), Hive, Sqoop, HBase
• Installer:
Windows Installer XML (WiX), Windows Installer/Microsoft Installer (MSI), Install Shield
• Development Tools:
Visual Studio 2015/2013/2010/2008/2005, Visual Studio.NET, Visual Studio 6.0, Visual Studio,Team System2008 and Foundation server 2008
• Testing tool:
WTT, Test Runner
• Operating System:
Windows7/Vista/XP/95/98/DOS, Windows Server 2008/2003/2000
• Collaboration and Content Management System:
Windows SharePoint Services (WSS), Microsoft Office SharePoint Server (MOSS), MS office (365/2010/2007/2003)
Other Skills
• Microsoft Office
Word, Excel, Access, Power Point, Visio, Outlook, Publisher, Power BI
• Adobe, Acrobat Reader
• WPF(XAML), Silver light, Product Studio XSLT, and Batch file
• Access Programming
Oracle PL/SQL, MySQL
•Databases
Oracle
•Data Molder: Erwin, Visio
Certifications
• Cisco Certified Network Associate (CCNA)
Experiences
Microsoft (AIM Consulting):-April 2016 to July 2018
Relevant Technologies: - TSQL, SQL (2017/2016/2014), OLAP, OLTP, SSIS, Tabular Model SSAS, DAX, SQL Azure, Power BI and MDX
Tilahun was working as Senior BI Analytics /Developer (SSIS, SSRS, SSAS and Tabular), Power BI developer (Dashboard, Report and M Language and MDX) and BI Architect
Roles and Responsibilities
* Designed and architected Relational and Multidimensional database from scratch,
* Wrote complex SQL queries for Data Mining,
* Developed SSIS Package in order to import data from different data source to store to staging and used in target database that was used for the OLAP cube to create dimensions and fact tables,
* Developed stored procedures as well as Views,
* Provided support on Data Migration, Database Backup and Recovery/Disaster Recovery, Database Upgrades/Patches, Performance Tuning/Troubleshooting, Security, High Availability Solutions
* Designed, Architected and developed OLAP Cube with 12 fact tables and more than 35 dimensional tables,
* Used Microsoft Team Suite (TFS) for Checking in and checking out Tabular Model project, Stored procedures related codes as well as built and published code for the auto deployment with respect to different environment (Dev, Preproduction and production),
* Prepared deployment script for the work that was validated in test environment that also need to pushed to production
* Deployed and managed applications in Datacenter, Virtual environment and Azure platform as well.
* Deployed, Configured, Maintained Compute on Azure Cloud.
* Troubleshoot Azure related issues and engage internal teams and Vendor for issue resolutions.
* Proactively identified, managed, and corrected data quality issues with reports provided to CR managers.
* Developed ETL scripts to enable weekly processing of 2-4 GB data sets into data warehouse.
* Optimized ETL performance to provide quickest response time possible.
* Automated and executed operational processes and procedures to ensure uptime and performance in a high-availability web-based environment.
* Built Database that Tabular Model SSAS database was used as data source,
* Used DAX in Tabular Model and Power BI for more than 1000 calculated measures, calculated columns and custom calculated measures.
* Optimized DAX performance in Tabular Model to provide quickest response time possible.
* Led efforts to analyze data for source/target mappings, created T-SQL scripts for data processing and automations,
* Migrated existing self-service reports and ad hoc reports to Power BI
* Developed Dashboard, KPI and Report from scratch using Power BI.
Microsoft (Collabra):-Dec 2015 – April 2016
Relevant Technologies: - TSQL, SQL (2014/2012/), OLAP, OLTP, SSIS, SSRS, Tabular Model SSAS, DAX, SQL Azure, Power BI
Tilahun was working as Senior BI Developer and BI Archtect
Roles and Responsibilities
* Used CA Erwin and Microsoft Visio for designing the Relational and Multidimensional database
* Designed and architected Relational and Multidimensional database from scratch
* Developed Relational and Multidimensional database from scratch
* Wrote complex SQL queries for Data Mining.
* Wrote triggers and stored procedures
* Optimized T-SQL code for best performance.
* Designed, Architected, and developed ETL using SSIS to extract data from different data source (Excel, Notepad, Web service as well as CSV)
* Worked on Azure for highly available customer facing B2B and B2C applications.
* Designed, Architected and developed OLAP Cube with 4 fact tables and more than 16 dimensional tables
* Used Microsoft Team Suite (TFS) for Checking in and checking out all project related codes as well as built the and published code for the auto deployment with respect to different environment (Dev, Preproduction production)
* Developed and published a number of Reports, Dashboard unsing Power BI for more than 10 team which were client to the team I was working for
* Used Power BI Desktop and Microsoft excel for slicing and dicing the database.
* Built also Tabular Model SSAS database,
* Used DAX in Tabular Model as well as report in Power BI
* Worked closely to support and advise the business; provide supporting data to aid in decision making
* Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
Microsoft (Winigent):-Feb 2015 to Dec 2015
Relevant Technologies: - TSQL, SQL (2014/2012/), OLAP, OLTP, SSIS, SSRS, Tabular Model SSAS, DAX C#, Power BI, Dynamic Excel Template Development using C#.
Tilahun was working as Senior BI Developer and Solution Delivery Manager
Roles and Responsibilities
* Used CA Erwin and Microsoft Visio for designing the Relational and Multidimensional database
* Designed and architected Relational and Multidimensional database from scratch
* Developed Relational and Multidimensional database from scratch
* Wrote complex SQL queries for Data Mining.
* Wrote triggers and stored procedures
* Optimized T-SQL code for best performance.
* Designed, Architected, and developed ETL using SSIS to extract data from different data source (Excel, Notepad, Web service as well as Oracle)
* Designed, Architected and developed OLAP Cube with 5 fact tables and more than 25 dimensional tables
* Used Microsoft Team Suite (TFS) for Checking in and checking out all project related codes as well as built the and published code for the auto deployment with respect to different environment (Dev, Preproduction, production)
* Used Power BI Desktop and Microsoft excel for slicing and dicing the database.
* Built Tabular Model SSAS database,
* Developed Measures using DAX in Tabular Model
* Created on-demand reporting functions through a web based interface
* Worked closely to support and advise the business; provide supporting data to aid in decision making
Godaddy
Project Length: - [November 2013 –January 2015
Relevant Technologies: - TSQL, SQL (2014/2012/2008R2/2008), Tableau, OLTP, C#, JSON, MYSQL, Casandra, NodeJS, Strong Loop, HDFS, MapReduce, Sqoop, Hive, HBase
Tilahun was working as Software developer since he joined Godaddy. While he was working as SQL Developer, he was dealing with different kind of production issues that he able to resolve and made the company provide the right solution towards its client.
Roles and Responsibilities:-
* Worked with developers and project managers to solve new and existing technical challenges.
* Implemented integrations with all manners of backend systems, both proprietary and third party.
* Provided administration tools and documentation for specific projects.
* Designed for performance and scalability.
* Wrote, debug, and optimize complex queries and stored procedures in T-SQL
* Tuned and optimized production SQL Server 2012+ Production Data Warehouses
* Created, maintained, and optimized data objects like indices and schemata
* Designed and wrote SSIS ETL systems for data from many disparate sources, structured and semi-structured
* Worked with Business Intelligence, Product and Research groups to define the future of automotive data science
* Created standard data documentation, such as ERD, Flow Diagram, etc.
* Worked in a collaborative team environment
* Designed and Develop Databases,
* Developed complex stored procedures, functions
* Designed and Developed OLTP
* Developed REST FULL API using NODEJS and Strong Loop.
* Developed Dashboard as well as report using Tableau
Logic 2020
Project Length: - [October 2013 –November 2013]
Relevant Technologies: - TSQL, Multidimentional SSAS (2012/2008R2/2008), SSIS (2012/2008R2/2008) ETL, SSAS (SQL2012/2008R2/2008) (OLAP Cube), SSRS (2012/2008R2/2008), CTE, VBA, C#, Tabular mode SSAS (SQL 2012), VB.net, Excel, Oracle 11g (PL/SQL), Clarity NSQL, TOAD, SQL Dynamic Script.
Tilahun was working as Lead BI developer since he joined Logic 2020. While he was working as BI Lead Developer, he designed and developed complex ETL to load data and he wrote dynamic SQL script that minimizes the design and efforts for developing complete ETL. Not only had this but also worked on performance tuning on existing dynamic SQL script as well as data integrity. Tilahun also did not limit himself on development of ETL, OLAP Cube and Dynamic SQL Script; he also came with a lot of innovative idea to the best of his knowledge for the success of this project.
Tilahun aslo worked on AWS (Amazon web service ) for proof of concept to show the possibility of minimizing the complex design of ETL using Dynamic SQL script by consuming the Metadata.
Roles and Responsibilities:-
* Designed, developed, implemented, and supported all aspects of a scalable BI platform.
* Lead multiple development projects and initiatives.
* Complete BI development activities and resolve defects; develops and unit tests repositories and multidimensional databases and, monitors and remediates system integration and business user testing software issues in a collaborative effort.
* Developed dynamic SQL script form metadata so as to minimize the complexity of ETL in order to build OLAP cube from metadata.
* Worked with business analysts and business users to translate complex requirements into technical and functional design specifications for reporting solutions.
* Assisted and mentored more junior development team members.
* Work within prescribed change control processes and procedures to produce deliverables that meet external compliance requirements.
* Helped to set and continued to evaluate enhancements to the SDLC along with the tools and frameworks
* Designed and Developed Complex ETL using SSIS
* Designed and Develop Databases,
* Developed complex stored procedures, functions
* Build and deployed SSAS project to create Multi-Dimensional Data base
* Designed and Developed OLAP cubes using SSAS
* Designed and Developed web service that is used in script component of the ETL to Extract Data from client Web service.
* Recommend, develop, and enforce IT and database standards, guidelines, and procedures in order to facilitate quality assurance.
EXPEDIA
Project Length: - [April 2012- September 2013)
Relevant Technologies: - TSQL, Multidimentional SSAS (2008R2/2008), SSIS (2008R2/2008) ETL, SSAS (SQL2008R2/2008) (OLAP Cube), SSRS (2008R2/2008), CTE, VBA, C#, Tabular mode SSAS (SQL 2012), VB.net, Excel, Oracle 11g (PL/SQL), Clarity NSQL, TOAD, MYSQL, Tableau, Power BI, Hadoop (HDFS, Map Reduce), Hive, HBase, Sqoop
Tilahun was working as senior BI developer as well as BI Architect since he joined Expedia. While he was working as BI developer\Architect, he designed and developed complex ETL to load data to Port Mart Data Mart from different Data source (MS SQL 2008/2005, Oracle 11g, My SQL, Web service and differnt types of files), and also he developed OLAP Cubes, complex Stored procedures, Functions. He developed Reports (SSRS, Excel) as well as SSIS packages (For dynamic file creation, Dynamic archiving) using SQL 2008R2/2008, VB, Web Service using C#, MDX, AXML, DAX etc. He designed the Port Mart Data warehouse so as to build OLAP cube on top of this Data Warehouse. Not only had this but also worked on performance tuning as well as data integrity. Tilahun also did not limit himself on development of ETL, OLAP Cube; he also came with a lot of innovative idea to the best of his knowledge for the success of this project.
Tilahun aslo worked on proff of concept to show the possibility of getting data from hadoop dynamically to build Tabular mode cube using SQL 2012 and Hive ODBC connector. The POC was done succsfully on manifesting all the limitation that the Hive ODBC was having. He also devleped reports and Daheboard unsing Tableau and more over he transferd his sclae to the new hire on how to admin Tableau reports and the dashboard he developed.
Roles and Responsibilities:-
* Architect End to End Expedia Prtofolio Data warehouse
* Designed and Developed Complex ETL using SSIS
* Designed and Develop Databases,
* Developed complex stored procedures, functions
* Build and deployed SSAS project to create Multi-Dimensional Data base
* Designed and Developed OLAP cubes using SSAS
* Design and Develop web service that is used in script component of the ETL to Extract Data from client Web service to the Expedia Data warehouse
* Developed reports and dasheboard usng Tableau
* Documents data requirements for database design
* Recommend, develop, and enforce IT and database standards, guidelines, and procedures in order to facilitate quality assurance
* Import Data from Data warehouse to Hadoop using Sqoop.
HIPCRIKET
Project Length: - [September 2011- April 2012)
Relevant Technologies: - TSQL, SSAS (2008R2/2008), SSIS (2008R2/2008) ETL, SSRS (2008R2/2008), CTE, VBA, C#, VB.net, Excel, MDX, AXML, DMX, Hadoop, Hive, Power BI
Tilahun was working as senior BI developer since he joined Hipcricket. While he was working as BI developer, he developed Analytics Dashboard, Ops Dashboard, Stored procedures, Functions and Performance tuning Database, Reports (SSRS, Excel) as well as SSIS packages( For dynamic file creation, Dynamic archiving, Dynamic Zipping, FTP,FTPS, ETL) using SQL 2008R2/2008, VB, VAB, XML splitter using C#, Excel Pivot Table, CSV etc.
Roles and Responsibilities:-
* Designed and Developed ETL using SSIS
* Designed and Develop Databases,
* Developed complex stored procedures, functions
* Database performance tuning
* Database back-ups and sizing
* Developed Dashboards, Reports
* Build and deployed SSAS project to create Multi-Dimensional Data base
* Developed OLAP cubes using SSAS
* Developed System Database Growth
AVANADE Inc.
Project Length: - [April 2010-September 2011]
1.Design Analytics (MCB / IEB) Project-Microsoft
Relevant Technologies: - TSQL, SSAS (2012/2008R2/2008), SSIS (2008R2/2008), XMLA, Erwin, VISIO, EXCEL, Visual Studio 2008, Visual Studio 2010, OLAP Cube
C#, ASP, NET, LINQ, Share point Server 2010
Tilahun was working as Design Analyst, Data Molder and Developer for Edison Team. While Tilahun was working as Data Analyst, Data Molder and developer he developed LDM, PDM and OLAP.
Roles and Responsibilities:-
* Designed and Developed ETL using SSIS
* Designed LDM and PDM using Visio and Erwin
* Built and deployed SSAS project to create Multi-Dimensional Data base
* Developed OLAP cubes using SSAS
* Created functional and technical specification for LDDM (Logical Dimensional Data Model)
* Developed tools used to merge files checked in to the share point site using ASP.NET, C#, LINQ
2.MSCIS SCSM Project-Microsoft
Relevant Technologies: - TSQL, SSRS, SSIS (2008/2008R2), VB, C#, ASP, NET, LINQ, Share point Server 2010, Visual studio 2008/10
Tilahun was working as Report Developer for MSCIS SCSM Team. While Tilahun was working as Report developer he developed KPI (Key Performance Indicator) and SLA (Service Level Agreement) report within the given time using SSRS. Tilahun used SSRS, Custom Code (VB), TSQL, as well as Execution plan to optimize the TSQL used to create views.
Roles and Responsibilities:-
* Developed TSQL to create views and Datasets used as data source
* Developed KPI and SLA SSRS reports
* Built and deployed the report to different environment
* Developed tools to track the errors occurred on production servers
* Installed and Configured of SharePoint, creation of Collection site
* Extracted, Transformed and loaded data from different data source to SQL Database using SSIS
3.MS Pharos Project-Microsoft
Relevant Technologies: - TSQL, SSRS (2008/2008R2), SSIS, ETL, C#, ASP, NET, LINQ, Share point Server 2010, Visual studio 2008/10
Tilahun was working as Report Developer for MS Pharos Team. While Tilahun was working as Report developer he wrote technical specification for SSRS report and developed dynamic as well as complex report within the given time using SSRS.
Roles and Responsibilities:-
* Wrote Technical Specification
* Developed TSQL to create views and Datasets used as data source
* Developed SSRS reports
* Build and deployed the report to different environment
4.EAS ICOE MS Retail Store- Microsoft
Relevant Technologies:- BizTalk 2006/2006R2/ 2009/2010, XSLT, XML, BizTalk Map, Orchestration, Schema WCF adapter, SQL WCF Adapter, SQL adapter, AS2 Adapter, Business Activity Monitoring (BAM) view, C#, ASP.Net, T-SQL, SSAS, Stored Procedures, SQL 2008/2008R2, IIS
Tilahun was working as a BizTalk developer and tester for the EAS ICOE MS Retail team. He was 100% responsible for work as tester in ITE, SIT, UAT, PPE environments from end to end. While working as a BizTalk tester, he developed an automated tool that was used to test the systems in all environments (ITE, SIT, UAT and PPE). The tool he developed did provide highly accurate log and error validation to aid in the analysis of end-to-end BizTalk failures.
Roles and Responsibilities:-
* Built and developed a BizTalk solution
* Tested a BizTalk solution
* Prepared a number of VMs for researching BizTalk2010 Beta
* Installed and configured BizTalk servers
* Configured IIS for the use of BAM views
* Developed a tool used for testing BizTalk applications
* Wrote technical documents
INDOD
Project Length: - [6/2009-4/2010]
Relevant Technologies:- SQL2008 (SSIS ETL, SSRS, SSAS, OLAP, CUBE,Data Modeling, Business Modeling, Data warehouse, Data Mart, C#, ASP.Net, LINQ, Entity Framework
Tilahun worked in this engagement as a BI developer.
Roles and Responsibilities:-
* Built, developed, and managed a SQL Server relational database using data warehousing techniques
* Provided development including responsibility for the day-to-day performance, maintenance, and monitoring of the Data Warehouse system and its technical interfaces
* Designed architecture, map business rules and processes into technical solutions.
* Performed analysis, development, and evaluation of data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation.
* Reviewed ETL load jobs coded by others for consistency and quality.
* Designed Data Mart solutions including star schema and cube.
* Implemented Data Management strategies which include validation of source data and the use of data in management reporting system.
* Validated the data that was transformed correctly from OLTP to data warehouse using ETL Testing
* Developed design specifications, unit test plans, and troubleshoot client issues.
* Worked with a mission critical and diverse project team with an emphasis on EDW excellence, repeatable processes and advanced technical development.
* Developed test tool which used to test the functionality, performance and check Dead lock in T-SQL of the ETL package
Delivery Engine Operation -MICROSOFT
Project Length: - 12 months [02/2008-4/2009]
Relevant Technologies:- SQL Server 2005/2008 SSIS, ETL, SSAS, OLAP, SSRS, C#, ASP.NET, JavaScript, XML, HTML, Web service, WCF, LINQ, T-SQL, Stored Procedures, Windows server 2003/2008 and Windows Vista, Visual Studio 2008/2005,Batch files, power shell, and IIS 6/7, and Product Studio
Tilahun worked as an SDE3 in the Delivery Engine Operation Team.
Roles and Responsibilities:-
* Developed tool such as Event Log trace system, User Audit System etc. using C#, ASP.NET, VB. Net and JavaScript for Delivery Engine operation team. Developed screens using ASP.net
* Developed web Services using .Net WCF to provide content service of production servers
* Developed OLAP, Cube, Dimension and facts using SSAS, Stored procedure, Trigger
* Developed ETL (SSIS) package which merges different formats and type of data source in to consolidated report
* Developed Report using SSRS and report builder and maintain existing report, used Dashboard
* Developed BI solution and be involved in the deployment of new reports
* Monitored the system using Performance test and prepare report using SSRS.
* Wrote unit test for the tools developed in the team.
* Tested the reloading tool using functional, performance and stress test
* Provided technical support on base of 24/7 day for issues related to SQL
* Participated on full deployment of system upgrade, reloading clusters, verification of configuration before deployment.
* Created SSIS packages to clean and load data to data warehouse.
* Created package to transfer data between OLTP and OLAP databases.
* Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and executed Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
* Created a table to save dirty records.
* Extracted data from XML to SQL server.
* Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated
* Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
* Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
Maharishi University of Management
Project Length: - 4 months [02/2007-6/2007]
Relevant Technologies:- DNS, SMTP, Microsoft Exchange Server, NIS, NFS, HTTP, IIS, Apache, Ethernet, Token-Ring, FDDI, Firewall, Personal Firewall, Semantic Suite, Windows Server 2003/XP/Vista, TCP/IP, IPX, RIPv1, RIPv2, IGRP, EIGRP, OSPF, ISIS, BGP, PPP, HDLC, ISDN, T1/E1, V35, RS-232, Frame Relay, X.25, ATM, VLAN, NAT, ISL.
Tilahun was working as a System and Network administrator. The administration of the entire network, computer laboratories and cloning of all computers used by the students in each laboratory every month was his day to day responsibility. He was using the Symantec suite solution for cloning purposes, which took approximately four hours to clone 300 laptops. His primary duty was to maintain and supervise instructional computer in the laboratory Configured computer workstations for educational training. Installed applications, diagnose/troubleshoot and repair workstations.
Roles and Responsibilities:-
* Assisted students in the use of the computer and associated applications
* Made recommendations as to the kind of units to purchase for the next school year
* Conducted orientations to new users as to Laboratory policies and rules
* Facilitated users who wish to take laboratory make-up classes
* Ensured that the computer laboratory software is up to date and virus free
* Participated on windows server 2003 and Active directory configuration
* Configured the mail exchange server of the university
* Created users account and source depot on windows server 2008
* Cloned all computers monthly based using semantic suite solution
* Developed report using SSRS 2005, stored procedure
* Developed ETL package which used to change XML files, CVS files, and Excel files etc. that come from different departments of the university and have one report with uniform format
Ethiopian Electric Power Corporation
Project Length: - Five Years [08/2002-01/2007]
Relevant Technologies:- SQL Server 2005 SSIS, ETL, SSAS, OLAP, SSRS, SSMS and SSBIDS,C#, ASP.NET, JavaScript, XML, HTML, Web service, T-SQL, Stored Procedures, Windows server 2003/2000, Visual Studio 2005,XSD, DTD, Web Service, DHTML, IIS6.0, HTML, CSS, XML, XSL, XSLT, SOAP, WSDL, UDDI, Design patterns Proxy, COR, Factory, State, Facade, Observer, Template, Strategy, Iterator, Ethernet, Fast Ethernet, Token Ring, ADO.NET, Web Forms, Win Forms, SQL Server 2000, MS Access, JavaScript
Tilahun was working in the Ethiopian Electric Power Corporation as software developer, BI developer and Project Manager for a project called Decentralization of Billing and Accounting System.
He designed and implemented file system and database backup procedure with onsite and offsite storage. Designed and implemented archival storage procedures. He documented operational procedures for loading and posting data to the Client Registry database. He coded and maintained Visual Basic application to load data and additional utilities.
Roles and Responsibilities:-
* Developed the full Accounting and Billing System which had modules such as Fixed Asset, Fleet Management, and Human Resource. Modules were developed using C#, ASP.Net
* Wrote unit tests for the Accounting and Billing System
* Tested the functionality of Accounting and Billing System
* Analyzed, tested and implemented database designs supporting various business applications.
* Wrote complex stored procedures/functions from the design document.
* Monitored/tuned database resources using Profiler, logs, Spot Lite, custom designed SSIS packages and jobs
* Created backup and maintained jobs using SSIS and Lite Speed for compressed backups
* Facilitated application development and customer problem resolution with optimum speed and efficiency.
* Participated as a team member in all phases of project development lifecycle.
* Developed Company’s BI solution using SQL 2005 (SSAS, SSIS and SSRS)
* Developed a new customer management system for the company using C# and ASP.Net
* Performed Data transfer (Import & Export) using BCP.
* Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
* Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
* Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
* Designed and created views for security purposes, implemented rules, defaults, and User defined data types.
* Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
BIZSoft PLC
Project Length: - 12 months [06/2001-07/2002]
Relevant
Contact this candidate