Amanuel Berhane Email & Phone Number

Washington, Dc, Us

Washington, District Of Columbia, United States

• Entrusted to serve as an Application Developer to automate several processes, build tools for eDiscovery team, and build integration between systems which reside on the cloud and on-premise.• Tasked to serve as a DBA to install, configure, design, migrate, monitor, secure, troubleshoot, backup and recover.• Entrusted to support viEvaluation and viLMS applications. Key Achievements:• Integrated Datawatch and Maptician for back to work contact tracing.• Maintaining Elite finance interfaces like Uber charges, Chrome River expenses and custom reports.• Rewriting the finance interfaces to link to Aderant.• Integrated the on-cloud Dayforce HR system to on- premise application by consuming an API.• Integrated the on-cloud CPI Docketing system to on- premise database by consuming an API.• Upgraded HR MS Access database application to a web based Angular 8 application.• Integrated the OnSolve communication system to use contacts from on-premise database by consuming an API.• Integrated the USPTO trademarks to on-premise docketing database to update data through the API.• Allow share point calendar integration to vendor LMS (Learning Management System) calendar• Built SSIS packages to synchronize data between vendor hosted data and on-premise databases.• Write several Angular applications/tools to supplement processes

Herndon, Virginia, United States

• Entrusted to serve as a SQL Database developer creating and maintaining reports for the Office of Comptroller Currency • Tasked to develop an MVC application for Bank examination contractor requests Key Achievements:• Examined requirements and created Tables, Indexes, Views, Functions and Stored Procedures on SQL Server 2014.• Created an MVC application which replaced an IBM Lotus Notes application which allowed bank supervisors to request bank examiners.• Developed and maintained OCC reports using SSRS.• One of my major accomplishments in the OCC is increasing performance in almost all reports notably 3 reports which took about 90 minutes. The execution time for those reports is now reduced to 20-25 seconds by redesigning, indexing and avoiding type casting.

Silver Spring, Md

Review client tickets, determine work scope and assign to developers. Complete scheduling of tickets to patches. Monitor developers progress on weekly basis. Collaborate with teams to find solutions for designs and issues. Key Achievements: Successfully trained newly hired and global developers the structure of the products and ensured organizational rules and procedures were adhered to.  Determined reporting and coding standards which greatly reduced risk on product updates. Ensure patches are delivered to production team prior to deadlines.

United States

Entrusted to serve as lead developer for $10M City of Chicago contract. Led team through requirement collection to design, implementation, data conversion, rollout, and maintenance for departments of Human Services, Mayor’s Office People with Disabilities, and Housing and Economic Development. Key Achievements: Tasked with the successful integration of Chicago’s 311 and Geocode web services.  Led the integration of State of Illinois CSBG web services.  Restructured and maintained Homeless Management Information System Program for nonprofit agencies in California, Colorado, Ohio, and New York. Diligently customized and maintained LIHEAP, CSBG, and Weatherization modules for various nonprofit agencies. Developed a tool to convert Windows forms to Silverlight forms, resulting in several months of saved labor hours.DBA Activities,Orchestrated production staff in implementing maintenance plans for index rebuild/reorganize, update statistics and backups. Introduced replication to stabilize and scale-out data entry by offloading report queries to replicated databases. Regularly review and rewrite poorly performing queries and share the knowledge with developers.Key Achievements: Tasked with troubleshooting SQL Server service outages as needed. Identified benchmarks for server memory, CPU, disk IO, and network throughput to be continually monitored by production staff for any noticeable variances. Assisted clients in going live by performing ETL on various databases.  Created scripts for structure consistency, data consistency, and data clean up.

United States

Successfully designed, implemented, deployed and maintained database systems for nonprofit agencies located in Missouri, Ohio and California. Developed and maintained state and federal reports using SSRS.Key Achievements: Automated software installs and upgrades reducing time from days to less than five minutes.  Successfully integrated State of Missouri’s LIHEAP and Weatherization web services.  Created an Adhoc report interface and templates which reduced client tickets for new reports.

United States

• Integrated Arc View GIS and Microsoft Map Point to Adsystech platform for routing and other map functionalities.• Helped in design of interface and business logic for Pest Control company in upstate New York.• Integrated Small Business Manager accounting software sending account receivables and payables and making sure every penny is accounted for.• Helped Senior Application Designers with writing VB6 business logic code for Economic Opportunity Board of Nevada.• Integrated Crystal Reports.• Created and Maintained In-Context & Management style Crystal Reports.

United States

• Wrote flow chart scripts.• Helped Senior Application Designers with writing VB6 business logic code.

Bachelor'S Degree, Mathematics, 3.5

Mcitp, Sql Server Development, Certificate

Bachelor'S Degree, Computer Science, 3.5

Activities and Societies: Intermural Soccer