SUMMARY:

• Detail oriented, intuitive, curious and enthusiastic IT professional currently holding an active public trust clearance with extensive experience in information management, software development and third - party software integration projects. Excellent ability to vi­sualize complex business solutions and translate ideas into technical specifications. Greatly enjoy working with individuals and groups across the organizational hierarchy to improve processes and develop business ideas into business successes.
• Agile & Waterfall development; Application wireframe design; Business Analysis; Content management; Data analysis; Data quality management; Data modeling; Data warehouse development; Database Administration; ETL process development; Information archi­tecture design and development SME; Mentoring; Meta-data management; Project coordination; Quality assurance testing; Report development; Requirements gathering; Risk analysis; SCRUM master; SPRINT management; Team leadership; Test plan creation and implementation; UML design; User acceptance testing; Vendor relations management
• Business Intelligence Development Studio (BIDS); Eclipse; Erwin; GIT; Jenkins; JIRA; MS Office Suite; MS Project; Omnigraffle; Ora­cle Developer; SQL Server Integration Services (SSIS); SQL Server Management Studio (SSMS); SQL Server Reporting Services (SSRS); Subversion; Toad; Visio; Visual Studio 2016; X-Code

TECHNICAL SKILLS:

Programming Languages: .Net; Java script; PL/SQL; SQL; T-SQL; VB

Systems / Environments: Linux; Mac OS; Microsoft Dynamics CRM; MS Access; MySQL; NetSuite; Oracle 11; SalesForce; Sharepoint; Sitecore 7; SQL Server 2016; Tableau Server; Unix; Windows

PROFESSIONAL EXPERIENCE:

Systems Analyst IV

Confidential, Arlington, VA

Responsibilities:

Develop and maintain departmental reports and reporting dashboards (SSRS, SQL Server, Oracle) for federal client; Provide recom­mendations regarding the use and implementation of reporting and data storage solutions as well as best practices.

Information Architect

Confidential, Reston, VA

Responsibilities:

Identify, design and lead in the deployment of the long-term strategic vision for enabling efficient and cost-effective information pro­cessing technologies for continuing medical education company; Modernize/ redesign data warehouse (SQL Server); Improve web­site traffic analysis and provide enhanced reporting capabilities; Act as project manager, SCRUM master and SPRINT coordinator for IT projects and information management SME; Provide training on data management and database best practices; Provide project leadership with regard to new development initiatives; Coordinate software development with external vendors; Develop product workflows; Generate application wireframes; Create UML designs; Create data dictionary; Design and maintain data model; Develop ETL processes for internal and external use; Design, develop and maintain business reports; Assist marketing with gap analysis re­porting; Create and maintain email marketing data lists; Set up and maintain SQL Server environments; Perform QA testing of Web and IOS applications; Audit site content and layout.

Database Architect

Confidential, Reston, VA

Responsibilities:

Assist in the development of customized resource planning product (Linux, MySQL) for a local think-tank; Develop product data­base and ETL processes; Perform database tuning and maintenance (MySQL).

Database/Programming Analyst

Confidential, Rockville, MD

Responsibilities:

Provide database development support for healthcare/pharmacy company; Migrate SQL Server DTS packages to SSIS packages; Create automated database solutions (SQL Server, SSIS, .Net); Develop report delivery system; Create logical and physical database models; Create custom reports in Crystal Reports; Support VB 6.0 applications.

Data-warehouse ETL Developer

Confidential, Bethesda, MD

Responsibilities:

SQL Server (2000/ 2005) database design and development for financial software IT firm; Create and maintain ETL processes; Per­form legacy system data migrations ; Migrate DTS packages to SSIS packages ; Normalize database table structures; Maintain data models and data dictionaries; Provide database support for front-end developers; VB 6.0 application support; Evaluated 3rd party reporting software; Review and edit software requirements.

Database Admin/Web developer

Confidential

Responsibilities:

Provide internal database support for government IT support company; SQL Server database administration; database security monitoring; DB backup management; Implement DB risk prevention plan; Streamline database processes; Improve stored proce­dure and query performance; Optimize custom java based web-applications.

Database/App Developer

Confidential

Responsibilities:

Develop custom asset tracking system (MS Access, SQL Server) for federal client; Develop customized logistical reports.

IT/ Customer Support

Confidential, Washington DC

Responsibilities:

Freelance consulting for legal IT, non-profit, federal civil service support and data management companies.

Business Product Consultant

Confidential, Bloomington, IL

Responsibilities:

Manage external vendor relations with GIS data providers for insurance industry leader; Act as GIS SME; Manage large GIS dataset updates for MapInfo; Create test plans; Provide product release risk assessments; Provide internal product support for GIS prod­ucts; Provide escalated support for Microsoft Office and Intuit product help-desk requests; Develop interdepartmental project status tracking reporting system.

Data-Warehouse Analyst

Confidential, Herndon, VA

Responsibilities:

Assess 3rd party address cleansing software; Act as technical liaison between external contractor development team and internal senior management; Create ERD and data dictionaries (Erwin); Develop logical and physical data warehouse model; Create applica­tion test plans; Provide data quality analysis; Perform QA testing and report development for MicroStrategy DSS reporting system; Mentor and train new domain registrar assistants; Create staffing productivity reports; Provide workflow and process improvement suggestions; Provide expert technical support for escalated product issues.