CAREER PROFILE:

• Application development team lead.
• Experience in leading complex projects.
• Extensive programming experience with Visual Studio .Net .
• Plan, install, configure and upgrade databases for transaction processing and data warehousing.
• Experience in database design and development to include developing conceptual, logical and physical database ERD diagrams.
• Implement database replication and database mirror to provide high availability of the SQL Server databases.
• Implement and maintain database security for users, roles and privileges.
• Develop SSIS packages to load data warehouse and capture server and database statistics.
• Develop and maintain database documentation.
• Strong working knowledge of accounting principles and practices.
• Effective communication skills - include the ability to listen to the needs of others, research and comprehend complex matters, and present findings in both oral and written presentations.
• Project Planning and Management skills - ability to work well with all levels of an organization.
• Budget and Resource Planning - ability to schedule projects to ensure that enough resources are available to deliver the customer’s request.
• Team Building and leadership.

TECHNICAL SKILLS:

Tools: C#, ASP.Net, HTML, CSS, Bootstrap, JavaScript, UNIX Scripting, SQL, PL/SQL, C, C++.

Database: SQL Server 2017, SQL Server 2012, 2008 R2, 2005, 2000, Oracle 9i, MS Access, Sybase and PostgreSQL.

Reporting tools: Crystal Report 9, Power BI and SS Reporting Services.

Software Application: Visual Studio .Net, Microsoft Office Suite

Operating Systems: Windows Server 2012, Windows Server 2008, Windows 10, and Windows 7.

PROFESSIONAL EXPERIENCE:

Confidential

APPLICATION DEVELOPER & DATA MANAGER

Responsibilities:

• Designed and implemented proprietary .Net solutions using object - oriented design principles throughout the software development lifecycle, including design, modeling, coding, testing, and documentation.
• Developed test plans, test cases, and test scripts for all testing events such as system integration testing, user acceptance testing and unit integration testing.
• Performed unit testing at various stages of the software development life cycle.
• Implemented either the waterfall or agile approach depending on the project needs and client goals.
• Provided technical support for the incident reporting application by troubleshooting and deploying code fixes as required.
• Improved data quality for the State of Maryland Fire Marshal by monitoring and correcting data elements in the Fire Incident Reporting Application.
• Adapted the System Development Life Cycle (SDLC) as a technology guide to ensure the successful implementation of complex projects.
• Lead efforts to design and build data warehouse.
• Analyzed data and data relationships and translate business requirements and technical details.
• Developed mapping documents indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Created dimensional modeling to design and develop star schema by identifying the facts and dimensions tables for data warehouse development.
• Extracted data from Flat files, SQL Server, Access and Oracle and loaded them into SQL Server data warehouse.
• Developed stored procedures, triggers and functions to support data warehouse loading.
• Develop SSIS packages to load data warehouse and capture server and database statistics.
• Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data.
• Experienced in database design and development to include developing conceptual, logical and physical database ERD diagrams.
• Plan, install, configure and upgrade SQL Server databases for transaction processing and data warehousing.
• Designed and implemented physical data partitioning on database systems to improve user response time.
• Deployed database monitoring tools to collect statistics on the performance of the online transactional databases and the data warehouse.
• Developed and implemented database recovery plan to include daily database and log backups, database mirroring and failover.
• Implemented and maintained database security for users, roles and privileges.
• Monitored database performance and implemented the required changes to indexes, queries, and triggers based on the query execution plan.
• Developed and maintained advanced stored procedures within MS SQL Server.
• Designed and implemented advanced ad - hoc queries and views.
• Developed and maintain database documentation.
• Troubleshoot technical database issues and provide guidance to other application and report developers.
• Created SQL queries to perform Data Validation and Data Integrity testing.
• Review Records Management System business requirements and provide recommendations.
• Act as Confidential liaison with other Public Safety agencies that share the RMS data warehouse.
• Act as Confidential liaison with other State and Federal agencies on incident reporting.

Confidential

SOFTWARE ENGINEER

Responsibilities:

• Installed and maintained Oracle production and test databases.
• Implemented performance monitoring and fine-tuning for existing databases.
• Converted over 45 million telephone numbers and addresses from three mainframe environments to a client-server environment.
• Developed reports for upper management using SQL and Microsoft Office Suite.
• Developed project plans using MS Project to track milestones, critical path and resources for monthly database releases.
• Saved millions of dollars in FCC fines by defining, planning, and implementing advanced technology solutions to meet the short and long-terms needs of the organization.
• Migrated over 200GB of data from Sun Solaris/Oracle 8.0.5 to IBM/Oracle 8.1.7.2 using custom made triggers and chunks to capture long data type. This data migration reduced average CPU utilization and memory consumption by over 70%.
• Created and produced high-impact multimedia presentations to communicate the value and benefits of emerging technologies to senior management.
• Performed risk analysis and feasibility of new projects.
• Assisted in the training and orientation of new management employees.
• Compiled technical and user documentation to ensure business continuity.

Systems Analyst, and Accounting

Confidential

Responsibilities:

• Managed the computerization of payroll and payroll deductions for over 3000 government employees.
• Developed revenue and expenditure reports using MS Excel and MS Access for management decision support staff.
• Taught the following courses MS Word, MS Excel, MS Access and Database Management, and financial accounting.