TECHNICAL SKILLS

• Expert level SQL Server: - table, view, stored procedure, function, SSRS, maintenance plans, jobs, replication, log shipping, security, TDE encryption, SQL Profiler
• Language: - VB6, VB.NET, C#, C++
• Recently learned DB2, SSMA (SQL Server Migration Assistant), SSIS (SQL Server Integration Service), SSAS (SQL Server Analysis Service), MDX, DAX, Tableau

PROFESSIONAL EXPERIENCE

Development Manager / Senior Application Designer / DBA

Confidential, Silver Spring, MD

Responsibilities:

• Directed production staff in how to setup maintenance plan for backups. Weekly full back up, Daily differential back up, and log back up.
• Directed production staff in how to setup maintenance plan for weekly index rebuild/reorganize depending on fragmentation
• Directed production staff in how to setup maintenance plan for daily update statistics on heavily used tables
• Production staff monitors the servers and databases daily and if performance issues are encountered they are reported to me which I then look at and create scripts to remedy the problem across all instances.
• Performed ETL on several types of databases in assisting clients go live
• Wrote several stored procedures, functions, triggers for several purposes like data clean up, data consistenc.
• Estimate efforts for client tickets and assign appropriate developers
• Schedule tickets to patches and monitor weekly progress of developers
• Discuss and review designs, problems and solutions
• Monitor on time delivery of patches to production team
• Train new developers in USA and Ethiopia the structures of the product and make sure they adhere to the rules and procedures of how to develop and deploy in the Confidential environment
• Erected a sister company in Ethiopia which has 20 employees for assisting in test, tool building and report creation/maintenance. This team still supports Confidential and can grow if they can be helpful for your organization for just $600 per developer per month.\
• Setup Reporting and Coding standards
• Designed and implemented data structure, user interface, and business logic for city of Chicago HSD (Human Services Department), MOPD (Mayor’s Office People with Disabilities), and HED (Housing and Economic Development)
• Integrated city of Chicago’s 311 and Geocode web services
• Integrated State of Illinois CSBG web services
• Maintained and restructured HMIS (Homeless Management Information System) program module for nonprofit agencies in California, Colorado, Ohio & New York
• Created/Maintained Local, Federal and State reports

Programmer

Confidential, Silver Spring, MD

Responsibilities:

• Designed and implemented interface and business logic for a nonprofit agency in Youngstown, Ohio, & San Bernardino, California LIHEAP, Weatherization & CSBG departments
• Integrated Great plains accounting software using dynamics gp
• Trained and Supported nonprofit agency users
• Created/Maintained In-Context / Management style SSRS Reports
• Created/Maintained Federal and State Reports
• Built ADHOC SSRS Report interface and templates
• Built an installation tool which reduced a client instance install/upgrade from a week down to a single click which now takes less than 5 minutes
• egrated state of Missouri’s Liheap and weatherization web services

Temporary Programmer

Confidential, Silver Spring, MD

Responsibilities:

• My First Solo Project was to integrate Arc View GIS to Confidential platform for routing and other map functionalities which at that time I found was not supported and Arc View was very expensive. Nonetheless I was able to send addresses from Confidential platform and pin point them on the map. I wasn’t satisfied with the outcome so I did a little bit of research and found out that Microsoft Map Point had the capabilities we were looking for and was $200 per license. I used Map Point and was able to satisfy all the functionalities required.
• Helped in the 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/Maintained In-Context / Management style Crystal Reports

Volunteer

Confidential, Silver Spring, MD

Responsibilities:

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