TECHNICAL SKILLS:

Operating Systems/ERP: Informatica IDQ Developer, Informatica Data Governance Axon, Informatica EDC Enterprise Data Catalog, Confidential Initiate Master Data Service / Confidential InfoSphere MDM Enterprise, Confidential Netezza datawarehouse Software v6.0, PeopleSoft (GL, A/R, A/P modules), Oracle Hyperion Interactive Reporting Studio, Business Object, Nuix Forensic eDiscovery Workstation

Relational Databases: Oracle SQL Plus, PL/SQL, AWS Cloud RDS, AWS Glue, Redshift, Microsoft SQL Server.

Tools: /Languages: TOAD, R, Tableau, ErWin, Nuix Forensic eDiscovery, Business Object Crystal Report, Troux Architecture

MicroSoft Office:: Excel, Access, Visio, Word, Power Point.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Governance Analyst

Responsibilities:

• Support the business needs of an enterprise - owned metadata repository through providing standard data definitions, accurate business rules/ calculations, and complete traceability and lineage of governed data.
• Provide ad hoc and standard reports to the user community as well as develop and maintain user community interaction models and facilitate organizational alignment through pre-determined channels.
• Provide standard and ad hoc reports to facilitate the analysis of the Metadata. Develop and maintain user community interaction models in support of the Metadata Repository.
• Maintain a business-oriented Metadata Tool User Guide. Provide navigation assistance to new metadata end users.
• Establish Metadata Guidelines and Standards to assist with the process of capturing and recording business metadata. Coordinate the publishing of metadata into the repository.
• Write business definitions of tables, entities, files, columns, attributes and fields. An understanding of business and technical metadata, data lineage and data models and methods to document this metadata for both technical and business users.

Confidential

Senior Data Engineer

Responsibilities:

• Perform data discovery and data engineering activities to include data acquisition, data profiling, schema analysis and metadata collection. Engage with data owners and subject matter experts to perform data adjudication activities, negotiate data sharing requirements, frequency and methodology for data extraction and delivery.
• Perform analytical exploration and examination of data from multiple sources of record, including discovering patterns and identifying potential business rules.
• Collaborate with metadata management initiatives to supply and integrate business metadata, technical metadata, business rules, data access rules, authoritative data source designations and other metadata as required.
• Following THE OPEN GOVERNMENT DATA ACT, prepare Air Force data available and accessible to the public. Establish and maintain a single Air-Force-wide data catalog.
• Support, track and review Federal IT and e-Government requirements, especially for OMB M13-13 Open Data.

Confidential

Financial Data Analyst

Responsibilities:

• Research, compile and analyze data related to IT capital planning, IT portfolio investments, and adherence to Federal IT regulations.
• Leverage skills in SQL to satisfy statistical analysis and reporting data requests. Develop, maintain data quality, metadata, and business rule documentation
• Design reporting processes, systems, and procedures.
• Analyze work flow and create work simplification and measurement studies.
• Coordinating with the customer, leadership, and technical teams to modify existing reports and develop new reporting products.
• Communicate data results verbally and through analytics visualizations.
• Coordinate with stakeholders and team members to provide enhancements to current report, analysis, and dashboard formats and/or to develop new reporting products.

Confidential

Data Architect

Client: Confidential

Responsibilities:

• Work with technical team members and ICE business customers to define requirements for complex data quality rule operations, and develop data products, quality policy and standard operating procedures to ensure data quality objectives are met
• Perform detailed data analysis, profiling, and Extract, Transform, and Load (ETL) process using Informatica IDQ Developer, Microsoft SQL Server, and Oracle
• Develop, maintain data quality, metadata, and business rule documentation
• Present data quality metrics and trends to internal and external stakeholders facilitating discussion of data issues, root causes, and action plans
• Define requirements for complex data quality rule operations and reports and work with development team to implement and test complex data quality processing

Confidential

Data Modeler/Financial Analyst

Responsibilities:

• Develop and Extract, Transform, and Load (ETL) routines, develop Data modeling (conceptual, logical, physical) for an enterprise data warehouse, Map data warehouse tables/columns to source systems, Define transformations
• Working with the functional and technical teams to understand and model the data requirements for interfacing current and emerging systems with the current and future financial management systems.
• Develop strategies for identifying needed granularity, acquiring new information, and aligning disparate systems for analysis.
• Assist with business development activities, such as proposals, capture, account teams, whitepapers, conferences, and/or other thought leadership materials.

Confidential

Intelligence Data Management Team Analyst

Responsibilities:

• Coordinate to develop and maintain Extract, Transform, and Load (ETL) process from multiple data sources in Oracle to produce recurring weekly/monthly deliverables.
• Work on DHS TSA Pre-screen project with Tableau.
• Reconcile ETL process results against legacy manual process results for data consistence, ingesting a variety of document formats into screen process for encounter and watch-listing.
• Identify and investigate data quality/integrity problems (variances), determine the impact of solutions to problems, support the production of regular and ad-hoc reports, develop/monitor automated loading scripts, and provide service support for these processes.
• Collaborates with IT Development applying logic rules and data schema from new releases to support existing data exports.
• Acts as a liaison with business clients to facilitate the implementation of new and improved business process requirements critical to data interoperability needs.
• Develops business specifications and data specifications, maintains data dictionaries and detail requirements.

Confidential

Senior Database Analyst/Reports Developer

Responsibilities:

• Responsible for the full life cycle of very large databases and/or data warehouses including requirements analysis, design, architecture, development and deployment of database applications, new features, and correction of defects.
• Responsible for ongoing data loading and reconciliation, customer support, technical troubleshooting and maintenance of developed databases.
• Designs, develops and maintains a multitude of relational database reports in Microstrategy. Performs quality assurance role. Prepares appropriate design and deployment artifacts per the standard development methodology. Leads and mentors others in the creation and use of standards for very large database development.

Confidential

Senior Application Architect Consultant

Responsibilities:

• Develop and maintain Initiate Database and Extract, Transform, and Load (ETL) process, diagnose data anomaly.
• Analyzing requirements, implementing Confidential InfoSphere MDM Enterprise, and supporting overall integration and testing.
• Propose and implement configuration/tuning to improve performance and reliability of the system.
• Participate in the full software life cycle to include analysis, design, deployment, and operational support.
• Support Initiate 9.7.0 deliverables for development, testing and production.
• Support operation of the Initiate environments during the ongoing development life cycle,
• Maintain the Initiate environments to coincide with development and maintenance releases.

Confidential

Data Management Team Analyst

Responsibilities:

• Coordinate to develop and maintain Extract, Transform, and Load (ETL) process from multiple data sources to produce recurring weekly/monthly deliverables.
• Reconcile ETL process results against legacy manual process results for data consistence, ingesting a variety of document formats (e.g. PDF, Office, HTML, XML, JSON, text, etc.) into screen process for encounter and watch-listing
• Identify and investigate data quality/integrity problems (variances), determine the impact of solutions to problems, support the production of regular and ad-hoc reports, develop/monitor automated loading scripts, and provide service support for these processes.
• Collaborates with IT Development applying logic rules and data schema from new releases to support existing data exports.
• Acts as a liaison with business clients to facilitate the implementation of new and improved business process requirements critical to data interoperability needs.
• Develops business specifications and data specifications, maintains data dictionaries and detail requirements.

Confidential

Data DW Analyst

Responsibilities:

• Analyze and document data mapping, modeling and business rules in Source Operation data bases, data warehouse staging & target data bases, and repository data bases in Confidential Integrated Decisions Support Data Warehouse Architecture.
• Analyze and document candidate data sources for future data sources to be migrated into ICE Decisions Support Data Warehouse Architecture.
• Extract and profile complex data to generate Hyperion Interactive Reporting Studio reports on performance dashboard and matrix.
• Analyze current and future, Transform, and Load (ETL) process flows.
• Monitor, identify, troubleshoot, and make suggestion to DHS to resolve operation risks and issues.

Confidential

Senior Business Analyst/Data Architect

Responsibilities:

• Analyze as-is data architecture systems and support to-be logistics life cycle logistics data warehouse and Business Intelligence for Confidential .
• Maintain and develop US Confidential Total Lifecycle Management Data warehouse or data mart.
• Perform process/system/database analysis through Confidential Enterprise Architecture.
• Perform data profiling, cleansing, and governance on major data flows.
• Interview business stakeholders to collect business rules, and draft business requirements.
• Confer with business partners, technical partners, and other stakeholders to draft function requirements, technical design specification, and UAT documents.
• Draft Use Case, Data flow, Swimlane diagrams.
• Recommend and design Confidential -Wide process and data management improvements intended to accelerate the Confidential ’s “time to value” for the improved TLCM.

Confidential

Senior Transportation Financial Data Analysis Support

Responsibilities:

• Provided weekly Budget Execution Report for Logistics Distribution by monitoring the Transportation Working Capital Fund (TWCF) billing and dispute process.
• Developed and maintained MC Logistics financial and billing database.
• Performed transportation financial data reconciliations, tracking and cleansing.
• Performed other transportation financial data analysis duties as assigned.
• Responsible for responding to queries from field activities and other DoD, OSD, Joint Staff, Federal/external agencies and commercial parties.

Washington Group International

Sr. Financial System Analyst

Responsibilities:

• Worked with Outlook Soft Team to implement OutlookSoft Financial planning and reporting architecture from underlying Oracle Financial Hyperion.
• Migrated, reconciled and consolidated historical data to OutlookSoft.
• Served as OutlookSoft Sherpa Admin and Hyperion SME and maintained both systems.
• Created 2008 financial plan and forecast.
• Created new reporting packages and procedures for month-end closing.
• Provided Outlook Soft for financial team.

Confidential

Sr. Financial Analyst

Responsibilities:

• Served as IT Finance liaison to project managers and discussed project phasing status and head count hours for monthly reporting to I/T Finance management.
• Assisted with generating monthly financial review of the project status.
• Reported via different financial tools including OutlookSoft and Hyperion.
• Acted on behalf of financial controller in approving IT employee workstation, software updates and purchases.

Confidential

Sr. Business Analyst

Responsibilities:

• Analyzed Confidential Restatement’s monthly implementation for Amortization Tool and Database Management.
• Analyzed financial and business impact of business requirements driven testing plans.
• Drafted testing plans (detailing “BEFORE-IMPLEMENTATION” and “AFTER-IMPLEMENTATION” results), performed SIT (before and after) and UAT (before and after) tests, and signed off on implementations.
• Coordinated with project management, IT, and operations to address issues arisen from monthly implementation releases and ad-hoc problems.
• Drafted all detailed releases’ documentation for auditing.
• Reconciled and explained variances between production run databases against G/L product accounts.
• Used SQL to consolidate, analyze Test Run and Production Run from different data sources.

Confidential

Sr. Operations System Analyst

Responsibilities:

• Used TQSQL and Access queries to collect, report and analyze trouble-shooting and network outage for Confidential National Networks.
• Reporting in Business Object
• Drafted Ad-hoc reports via different applications and databases.
• Drafted requirements for Business Object Data Warehouse of network ticketing system.
• Facilitated project management for EBTS cell sites renaming project.
• Analyzed network alarms for iDen system.
• Conducted weekly network performance evaluation for Confidential sponsored Nascar races.