SUMMARY:

• Results - driven professional with experience performing analytics, documenting process and workflows, conducting data exploration, modeling and analysis, and expediting the assurance of key metrics. Energetic and confident communicator with the ability to circulate information in a way that is clear, efficient, and beneficial for end-users. Experienced analyst with the ability to research and generate queries/reports with limited guidance, and presenting data findings and their impact on organizational growth. Organized and timely in collaborating with cross-functional teams, and executive management. Hold an active secret security clearance.
• Data Analysis and Reporting| Extraction | Mining and Cleansing | Requirements Elicitation | Software Support | Business Analysis | Project Management | Process Re-Engineering | Agile Development | IT Support | Relationship Builder | Effective Communicator | Data Modeling | Event Monitoring Systems | Synthesizing and Analyzing Data | Attention to Detail | Disseminate Large Amounts of Information | Testing | Maintain/Improve Data Sets
• Office 365 | Access | Advanced Excel | PowerPoint | Project | Visio | SharePoint | Teams | Salesforce | SQL | DB2 | Oracle | Apache Hive / Impala | Cloudera HUE | Hadoop Big Data Lake | MYSQL Server | Informatica | Business Objects | Cognos Analytics | Tableau Desktop and Prep | MicroStrategy | Version One| JIRA | SAS Enterprise Guide | SAP FI / SD | ABAP/4 | SAP-BW Database | Mainframe TSO ISPF and z/OS | MRI software | DST Brokerage Systems | Monarch Pro | Boston Workstation Scripting | Project Kickstart | HP ALM/Quality Center | IBM Blue Works | BMC Remedy

PROFESSIONAL EXPERIENCE:

Data Analyst Lead

Confidential | Reston, VA

Responsibilities:

• Served as a resource supporting data inquiries from internal and external stakeholders. Assess current data and assist in appropriate resolution of data anomalies.
• Perform data analysis and modeling to create source to target mappings consistent with FEPOC standards.
• Engaged in exploration, collection, analysis and interpretation of data to glean insights from complex Big Data ecosystem.
• In a development environment, worked closely with the Agile team product owners, developers, testers and source data experts to develop and fulfil stakeholder data requirements for claim systems.

Business. Process Manager

Confidential | Fairfax, VA

Responsibilities:

• Engaged with the Enterprise System Services team to implement a new incident management system. Reviewed current-state documents, help establish baseline needs, mock-up user manual, guides and forms.Utilize Cognos to create data connections from multiple data systems to build a data framework for self-service reporting requirements. Execute regression test plans during upgrade, run SQL to review and combine dataset sources and test reports.
• Assist HR business data acquisition, integration, warehouse teams to populate tables for civilian specific SAPR prevention and response activities sourced from TWMS database. Use interface control artifacts to determine data origins and targets.
• Maintained active secret security clearance.

Data Analytics Senior

Confidential | McLean, VA

Responsibilities:

• Tracked and reported on strategic initiatives to achieve market growth in 2 years by 15%. Built market share analysis model based on internal and external data sources.
• Decreased timeframe to produce monthly management report deck by 70%, revealed and removed data redundancy issues, optimized data extractions, and employed BI tools.
• Coached 4 analysts in data discovery, interpretation of results, and development of reports and dashboard visualization solutions utilizing Tableau.
• Managed data analytic projects from planning to deployment; resources, requirements elicitation, risks, status reports, road maps, and demos. Ensured deadlines were met and reporting was accurate.
• Extracted and transformed big data into actionable insights; identified key metrics, trends, and performed root cause analysisof anomalies / outliers, or systems performance issues.
• Perform source to target data mapping utilizing Informatica Metadata Manager lineage, XML, and physical and logical schemas.
• Leveraged data lake Hadoop, Hive, used SQL for data exploration in data warehouse, and internal and external 3rd party disparate repositories.
• Published data sources, logic, reports, dashboards, and scheduled refreshes on Tableau Server.
• Participated in scrum and retrospective meetings to ensure development aligned with business requirements.

Senior Data Analyst

Confidential | McLean, VA

Responsibilities:

• Interpreted credit report risk assessment transactions, created a statistical analysis model on large data sets to discover and document corrective actions in rule logic and outliers.
• Assisted with executing a $20MM licensing agreement with a technology vendor representing 30% of the loan origination market, developed business workflow process, data analytics, and internal/external reporting.
• Recipient of 11 company “Spot s” (nominated by peers and management for contributions on projects).
• Documented requirements of critical data elements, resolved data and/or systematic challenges impacting reporting, as well as user acceptance testing for new data Approved Provisioning Points (APPs).
• Increased adoption rate of company’s technology products by 20%, by developing reports and detailed data analyses used by sales, marketing, and technology integration teams engaged with pilot partners.
• Used SQL and BI tools to compile analyses from large data sources for product owners and external customers to assist integration efforts to pricing and contracting systems.
• SharePoint and Salesforce site developer / administrator for the strategy and integration teams.
• Gained solid mortgage industry knowledge through Confidential ’s of Excellence Program, completed 1-year program in 6 months. Ongoing attendance at symposiums conducted by industry experts.

Business Analyst / Consultant

Confidential

Responsibilities:

• Used BMC Remedy to resolve daily incident tickets from business partners and created knowledge-based articles, change management process flows for mainframe and software systems.
• Supported production environments to ensure service level agreements were met with 3rd party vendors.
• Provided 24/7 rotational on-call support, and managed major incidents to resolve tier-3 level escalated issues.
• Collaborated with internal IT resources, off-shore partners, and 3rd party vendors to explore opportunities to improve business processes and methods of application support.
• Elicited reporting requirements, performed gap analysis, created dictionaries, and enhanced COTS reports.
• Utilized Business Objects SQL functionality to generate reports and data analysis. Performed source to target data mapping, built extractions to create data sets.
• Developed automated test cases in HP ALM, documented defects, regression testing and traceability matrix.
• Created and maintained PPM quick guides on SharePoint for end-user .

Senior Business Systems Data Analyst

Confidential

Responsibilities:

• Led team developing a data mart and stakeholder requirement meetings.
• Built and managed Access databases, use SQL to query production and external 3rd party databases.
• Streamlined manual efforts to move data between EHR/EMR and revenue systems. Created Boston Workstation VBA scripts to automate data migration. reduced days in A/R, and saved 1,000s of FTE hours.
• Coached 3 analysts to ensure that reporting requirements aligned with business needs.
• Managed the company’s MRI accounting and property management system, successfully integrated ancillary modules, completed version upgrades, patches, back-ups, updated system configuration and user access.
• Selected and managed implementation, roll-out and UAT of a new Electronic Invoicing system that reduced accounts payable processing by 50%.
• Led roll-out, customization, and end-user of a COTS incident management ticketing system.
• Collaborated with business partners to identify process deficiencies and opportunities to automate.
• Built custom MySQL based reports. Maintained technical, change management and SOX documentation.
• Member of a shared services group responsible for creation and support of automated reporting solutions.
• Created financial report models, and sales/marketing ad hoc reports using SAP Business Objects, SQL and Hyperion.
• Assisted with implementing Cognos/Concur travel and expense application. Built custom dashboards / reports, workflows, used SQL to create analyses, conducted sessions, and supported end-users.
• Primary report developer enterprise-wide of Cognos BI Impromptu and Powerplay cubes.
• Developed and maintained Access databases; SQL extracts, Crystal Reports, and data set refreshes.
• IT business liaison and systems administrator for online direct-link with a national leading bank.