SUMMARY

Data architect/analyst with business/systems analysis and programming experience, MBA, and PMP certification. Self-directed, dedicated professional with over 20 years of information systems and business experience, from software development to marketing to project management in the healthcare, insurance, mortgage, financial, retail, manufacturing, and energy industries. Talented at understanding technical complexities and then communicating issues and potential solutions simply and concisely to internal and external project stakeholders at all levels, demonstrating a combination of business savvy and technical abilities. Results-oriented leader with vision to implement projects successfully through the software development life cycle within time and budget constraints.

SKILLS

Data analysis, business analysis, systems analysis, database development, database design, project management, Agileand Scrum methodology, program management, teambuilding, scope management, change management, project control, project estimating, project leadership, project planning, project scheduling, project risk management, project resource management, PMP, software development, strategic planning, product management, product marketing, market analysis, requirements definition, business product requirements, quality assurance, new product development, client management, software design, graphical user interface GUI design

TECHNOLOGY

SQL Server, Oracle, Teradata, DB2, MySQL, data warehouse, e-commerce, ActiveX, ActiveX for Healthcare, HL7, smart cards, digital imaging, web-based applications, client/server applications, desktop applications, information technology

SOFTWARE

Microsoft Office Word, Excel, Access, PowerPoint, Outlook , SQL Developer, SQL Server Management Studio, Teradata SQL Assistant, Toad for MySQL, TestTrack, iSeries Navigator, Lotus Notes, MS Project, Visio, DataDefractor, Visual SourceSafe VSS , MKS, Paint Shop Pro, Documentum, SharePoint, PassPort

DATABASES

SQL Server, Oracle, Teradata, DB2, MySQL, Access

LANGUAGES

SQL, T-SQL, HTML, DHTML, JavaScript, Visual Basic VB , C, PHP, Pascal, awk

OPERATING

Windows, XENIX, MS-DOS, Aegis

SYSTEMS

EXPERIENCE

Confidential

Business Intelligence Consultant

• Wrote user stories and mapped source data from Integrated Data Warehouse IDW to outbound filesrequired by Centers for Medicare Medicaid Services CMS in order to support risk adjustment regulatoryrequirements of Patient Protection and Affordable Care Act PPACA . Stayed ahead of development and QA teams for 8-10 sprints. Developed tests that verified data within and across files before sending to Edge Server Teradata .
• Defined business rules with business oversight and pioneered method to associate interim claims that were not otherwise associated in IDW allowed claims to be aggregated for reporting to CMS.
• Analyzed enrollments that were imported to the IDW at two different levels of granularity. Made them consistent so that premiums could be aggregated for any selected day, and premium maintenance history could be derived and reported to CMS.
• Developed data-driven approach to classify plans for different business units' reporting needs proved decades old system-specific classifications could be replaced and improved so that existing system could someday be retired.

Confidential

Data/Systems Analysis and Business Analysis Consultant

• Documented business rules, logical data model, business requirements, and functional specifications for ProviderPoint 6.0, the company's flagship system that validates, corrects, and augments clients' provider listings MySQL .
• Created a template for current and future business rules that could be used by business users for reviewing system functionality and by Development and QA for easily identifying changes and dependencies on those changes.

Confidential

Data/Systems Analysis and Business Analysis Consultant

• Mapped data from internal data sources SQL Server and third party workflow system eMason to an operational data store ODS to support loss mitigation operational and regulatory reporting. Scrubbed data, inferred duplicate workflow events, created views that served as a pseudo-data mart for reporting specialists, and wrote validation scripts to test the solution.
• Solved complex problem of correctly assigning counts, balances, revenue, and expenses from one system and set of portfolio definitions to Investor Reporting portfolios defined in separate system.
• Automated investor performance reporting by untangling interdependent spreadsheets, using DataDefractor to automatically import data from semi-structured data sources, and reconciling data across reporting databases Oracle and SQL Server .

Confidential

Client: Lawson Software Customer Master Data

Data/Systems Analysis and Business Analysis Consultant

• Documented process flows, use cases, screen mockups, and requirements for web-based customer master data management MDM application that replaced 10 screens with a single point of entry, allowed customer relationship definition, and synchronized data across systems.
• Wrote test cases, created test data files required for comprehensive testing, and executed tests.

Confidential

Client: Deluxe Corporation Business Intelligence

Data/Systems Analysis and Business Analysis Consultant

• Developed over 200 source-to-target mappings, including source queries, for extract, transform, and load ETL processes that moved customer and order information for 13 brands from flat files and Oracle, SQL Server, and DB2 databases to the enterprise operational data store ODS , enterprise data warehouse EDW and data marts to support list extract and call center reporting.
• Delivered mappings and provided support to 10-15 ETL Informatica developers, both onshore and offshore India .
• Worked as liaison to the business and with data architects to creatively overcome several source data issues in order to get complete, accurate, and business-relevant data to the ODS.
• Created test cases, identified rich set of test data, and wrote verification queries to test solution as data moved from source to ODS to EDW to data marts.

Business Analysis and Project Management Consultant

• Documented role-based access, non-public information, and privacy impact assessment PIA for reports and associated processes being outsourced to India as part of business process outsourcing BPO initiative.
• Created matrix of role-based access vs. inputs, outputs, and tools that is used by both the business and IT security.

Project Management Consultant

• Coordinated and planned all activities associated with transfer of fleet applications from managing company to buyers of two nuclear power plants.
• Served as central contact for virtual team of technical experts, responding to requests for code and data, negotiating priorities with Application Services Manager, scrubbing data before transfer, and working with Network Services Manager to transfer third party software licenses and account for fleet hardware.
• Coordinated 8-12 member product teams and 2-8 member engineering teams on multiple forms/scanning projects with budgets of 200,000- 500,000.
• Used earned value analysis to support progress reporting for senior management.
• Led product/project roadmap development that aided planning and budget processes.
• Recommended process changes to phase review system PRS and managed successful pilot project.
• Process changes resulted in increasingly predictable schedules and budgets