SUMMARY

• An agile data analyst, data modeler SQL developer, ETL developer, DBA, system and data architect and software developer with extensive experience and training, who models, designs, develops, and hands on manages effective and creative business solutions.
• Database and software development experience has both depth and breadth regarding reverse engineering, forward engineering, business intelligence, database design and analysis, data modeling using tools, administration, Capability Maturity Model (CMM), use cases, system requirements, architecture, planning, migration, testing, data quality assurance, implementation, configuration management and security and risk management: successfully analyzed developed and implemented data models, web - based forms, performance management metric reports relational database modeler and DBA logical and physical for data warehouse, data mart and data mining, cloud based online transaction processing (OLTP), relational online analytical processing (ROLAP), and Multidimensional online analytical processing (MOLAP) databases; OLAP cubes, ad hoc reports, business rules, business processes and legacy system re-engineering business process automation, and workflow application architecture for government and large corporations; worked with teams and independently on all portions of the full software life cycle, from feasibility to requirements, through implementation, for large and small projects.
• Experienced working multi-tasks and simultaneously with multiple project teams; meeting with clients; and, acting as a team lead, mentor and tutor to all team members.
• Platform agnostic emphasis on cross platform business intelligence interface engineering, middle tier services, messaging, workflow and integration; excellent verbal and written communication skills, good listener, able to explain technical concepts to non-technical stakeholders, quickly learns and applies knowledge.

TECHNICAL SKILLS

Data Modeling: Design and Embarcadero ERStudio, Erwin, Visual Studio .Net Enterprise

Development Tools: Architect, Rational Rose, Objecteering, Team Developer (SQLWIndows), Jbuilder, Weblogic, Boundschecker, Toad for MySQL and Oracle

Databases: MS SQL Server 2008-2017, Oracle, DB2, POSTGRESQL, MYSQL, Informix, Teradata, Access

Business Intelligence: ETL, MS SQL Server Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Informatica

Performance Management: MicroStrategy

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

Senior Business Intelligence Developer

Responsibilities:

• Design and Develop reports and SharePoint Report Web Portal for mission critical information for all jurisdictions and divisions of AOC. Reports developed, tested, and deployed for Budget, Help Desk, InfoSec, Training, Construction, Payroll, AOC Leadership, data integrity, auditing, automated report generation and delivery. Maintain and administer web portal. Reports developed in SSRS, SSAS and MS SQL Server, Oracle used data from SharePoint Lists (SOAP, REST API, XML), TFS, Kerberos, Service Manager, System Center Manager (SCOM), Cireson Support Portal, Web Services and Document Management using Data Warehouses and Tabular Data Models and Dashboards.
• Model, design and, developed reporting databases to stage data needed across many systems and to improve report performance for OLTP databases. Assisted in the configuration of Kerberos, key contributor to building of Data Warehouses for GL, Budget, Operations, Order, Payroll and Assets and related Tabular Models, and to AOC’s certificate based two factor authentication efforts, and debugged Microsoft SharePoint and database issues. Updated and migrated Microsoft web farm, Microsoft SQL Server and Share Point systems to most current versions. Worked to migrate training system to Open Source Learning Management System. Integrated reports with SharePoint forms. Created widgets and Dashboards in the Cireson Support Portal. Developed reports for tracking of remote access via VPN and Citrix.
• Created solutions that facilitated the implementation of Tableau. Consolidated reporting solutions and decommissioned Cognos and Hyperion, and QlikView. Reduced the number of Financial Management reports from over 175 to 35 reports by migrating and/or re-engineering reports to leverage Microsoft SSRS platform. Provided information that the client did not have readily available. Developed innovative approaches to meeting requirement and provided enhanced capabilities. Helped the customer re-think some of their requirements to take advantage of alternative (easy to code and easier to use functions instead of developing more complex and harder to maintain custom solutions).

Confidential

Data Architect, Data Migration, Data Modeler

Responsibilities:

• Created data architecture for entire organization; Reverse engineer non-relational Lotus Notes grants management system and develop logical and physical models to migrate data from Lotus Notes to MySQL via MS SQL Server 2008. Design and build the server and selected and installed DOD approved software necessary to complete the project.
• Reviewed logical model with data governance group to ensure all required enterprise attributes and entities were included; developed data strategy to ensure all data relevance and usage across all of DOD. Work with the client, the cloud application development team, Business Analyst, Lotus Notes production support team to migrate data to new production architecture and database.
• Develop a data migration plan that includes process for merging duplicate records, creating new records, identifying data irregularities, standardizing data values, and cleansing data.
• Migrate data from several legacy databases into an enterprise database.
• Verify and reconcile record totals.
• Design and developed the creation, testing, and execution of extract, transform and load activities.
• Create scripts or process to perform the data migration in a predictable and easily repeatable manner and perform the data migration.
• Ensure that all data imported into the system results in valid records and with proper integration.
• Responsible for meta - tagging attachments as part of the migration.
• Generated reports in Microsoft SQL Server and Excel to support defining the database dimensions; used reports to generate the list of attributes for each dimension within the database to support all report efforts.
• Worked with cross functional teams to define interfaces with large DOD 11g Oracle database to new cloud based system; Developed specifications for data integration effort that ensured flexible response to changes in requirements and priorities of the production team and of the cot cloud application team.
• Created LAMP Stack server with Drupal in AWS to support Web Portal and created process to migrate the test portal to secure AWS DoD server for security audit testing. Reviewed remediation reports and provided solutions to high and medium issues.