Mary Ann Selander

Charlotte, NC ***** 704-***-****

adyc6m@r.postjobfree.com

Linked In Microsoft github

Motivation

Professional Software Engineer seeks new challenges and interesting opportunities.

Experience

11/15/2022 – 6/7/2023 Bank of America Application Programmer V Contract

Global Consumer and Small Business -Anti-Money Laundering Remediation Tools – Know Your Customer, OFAC

Operational Datastore. Metrics, Dashboard, Analytics and Central Reporting.

Regulatory Compliance, Enterprise Governance.

Applied technical knowledge in determining end to end design requirements for large projects involving line of business, software/hardware developers and vendors. Worked closely with business partners to define strategies for technical solutions, determine requirements, and develop functional designs based on the analysis of line of business needs, objectives and existing systems infrastructure. Drove and participates in design, development and implementation phases of large and complex enterprise-wide applications, often using new technologies. Worked closely with developers and testers to ensure requirements and functional designs were translated accurately into working technical designs and that test plans and scripts served customer needs. Worked under minimal supervision on enterprise- wide projects requiring creative solutions. Performance Analysis, Monitoring and Tuning Web Applications . Project, Product and Delivery Management

Migration of C#/VB .Net Framework and Core 3.1 WebApps and APIs to .Net 6 Core Minimal API architecture. Expanded unit tests projects to achieve 80%+ code coverage standards enforced by Sonarscan in Jenkins pipeline.

Enhanced unit testing framework for automation with in-memory datastores, cumulative metrics and KPI s for QC.

Extended existing ASP.Net Webforms/MVC/API Applications and linked to new ASP.Net Core WebApps and APIs.

Upgrade and refactor existing test artifacts. Create new test services, templates, reference implementations, wiki.

Enhance CI/CD for minimal 80% test coverage per SonarScan.

Upgrade SSRS projects and reports to target SQL 2016. Refactored Embedded DataSets for reuse.

Performance tuning to minimize workload impact on OLTP . Query Hints, Indexing, Materialized Views.

Created new DataSources with ApplicationIntent=ReadOnly to facilitate auto-reRouting to secondary replica.

Created new reports to meet new and emerging business requirements – both functional and non-functional.

Upgrade SSIS packages to target SQL 2016 . Convert to Project Deployment Model. Global Event Handlers.

Shared Control Flows.Parts. Refactor existing dtsx packages to remove connectionstrings and standardize error handling, logging and audit functionality. Created new Operational reports for monitoring and managing operational alerts and notifications. Empower Citizen Developers. Promote Governed Self-Service. Participate in Community - .net COE.

C#/VB/Java IIS/WAS SQL Server 2016 SSRS SSIS REST SOAP Oracle Office 365 Visio Jira Confluence Sharepoint Visual Studio 2019, 2022 SSDT SQL 2008, 2016 SSMS SSIS SSRS ASP.Net 4.5-8, Core 3.1, 6 ETL

Postman, Insomnia, LinqPad 6 Bitbucket, git, Jenkins, MSBuild, jFrog, Artifactory, Splunk, Insomnia, Nuget

Azure Key Vault, Azure CLI, ARM, Powershell, SQLCMD, Power Automate/Query

7/2022 - 9/2022 Underwriters Laboratories Senior .Net Developer Contract

Materials Data Collection Management - Wercsmart Product Studio - Azure Cognitive Search

MVC WebAPI Faceted Navigation Data Factory Web Apps Serverless Functions

Solutions Re-Engineering - .Net Modernization, Development, API/ETL Integrations

VS 2017-22/Code .Net 3.5, 4.6 --> 4.8 SQLlite 2014/16/Azure Microservices APIGateway

C# Microservices REST SOAP WebAPI Asp.Net MVC Minimal APIs .Net 3.5 - 4.8 Core 3.1 .Net 6

Agile/Scrum Azure DevOps/TFS/Git SSDT, SSMS, ADF, Azure SQL Swagger Swsahbuckle, Microsoft Teams

React Typescript jScript HTML WebPack Postman/Fiddler Redis nUnit xUnit msTest Serilog

4/2022 – 5/2022 Bank of America Applications Programmer V Contract

Global Markets - Risk and Finance Technology.

CREST – Consolidation and Reporting for Enterprise Stress Testing. Shared Capabilities. Platform Services.

Configurable Risk Models, Scenarios, Workflows and Portfolio Segmentation. Centralized Orchestration.

Consolidated Model Management and Governance. Regulatory Compliance and Reporting.

Horizon – Jira, Confluence, Jenkins, Artifactory, Git. Bitbucket, Ansible, qTest, etc

C# .Net Core, Blazor. VS2019 VS2022 SQL2016 Office365, Mattermost, SharePoint. Swagger

SQL Server 2016. Entity Framework. XUnit. .Net COE MSTest SSDT, SSMS, ADF

Azure Key Vault, CLI, Powershell

11/2021 - 3/2022 LPL Financial Senior Integrations Engineer Contract

ClientWorks - LPL’s ISV built on Dynamics 365 CE/CRM with custom SDK extensions. C#, SQL, API, Azure.

Modernization of Clientworks Data Migration Tool – SSIS ETL supporting onboarding CRM Excel data.

Reduced total cost of ownership – minimize complexity, eliminated third-party licensing – Kingswaysoft.

Promote Low-Code solutions to empower clients and reduce development cycles.

Refactor workflows and processes to iteratively decouple business models from implementation

Consolidate interfaces, namespaces and logical models – publish and govern shared libraries

Enhance custom APIs and shared microservices – including Mulesoft integrations with Salesforce.

Modernization for custom solutions written in C# and built on .Net 4.5.

Participate in evolving SDLC. Github, Azure DevOps, TFS. SSDT, SSMS, ADF, O365

Atlassian Artifactory TeamCity DynaTrace ServiceNow

Maintain and extend custom Form, Workflow and Outlook extensions for Dynamics CE/CRM.

Modernize integrations with Azure, Salesforce. Redtail. Mulesoft evolving APIs.

Leverage existing frameworks and abstractions for efficiency, responsiveness, agility, and resilience.

Embracing the Dataverse. Common Data Services, Model-Driven and Progressive Web Apps.

Enabling Citizen Developers with Low Code solutions designed for external configuration.

Contribute to common libraries and shared service pipelines both On-Prem and Cloud Hosted

Participate in architectural oversight and enterprise data governance for disparate cloud ecosystems.

Analysis of existing and future strategies to meet unique regulatory compliance and reporting needs.

Azure Key Vault, App Services, CosmosDB

4/2022 – 11/2021 Bank of America Applications Programmer IV Contract

Global Technology & Operations -- DAIT – Data Analytics and Insight Technologies.

Project, Product and Delivery Management Architecture and Share Capabilities.

Data Analytics and Insight Technologies department. Senior Developer. Tech Lead.

Replaced Java/Struts webapp – workflow automation for departmental intake requests.

Migrated most recent two years of operational data – from a poorly-designed Sql2016 db

Proposed a development plan for an MVC 4.7.2 WebApp with minimal complexity.

Integrated VS 2017 with BitBucket. Published detailed documentation on Confluence.

Created and maintained core reference documentation. Database SQLC, Oversight.

Regularly sent team emails with timely information relevant to their roles.

Creative solutions. Conduct POCs. Propose Design and Reference Implementations.

Evaluate technical requirements. Summarize design alternatives. Prototypes.

Mentored Product Owner and team on All Things SQL. Publish and Preach ERDs.

Standardized Views/Procs/UDFs/UDTTs - consistent with sister team.

Participated and actively promoted the Enterprise .Net Center of Excellence.

Champion of empowered users and governed self-service.

Merged with Shared Services Team. Port existing MVC and Webforms to .Net Core 3.1.

Proof of Concept – Progressive Web Applications – Razor, Blazon, Angular.

Implemented Reporting Portal and Work Management OLTP, ODS. SSDT. ADF. ARM. Azure Key Vault

SQL 2016 SSIS SSRS. API Integrations with SharePoint and Jira. VS 2017, 2019.

MSTest xUnit, Bitbucket, TFS, ALM, Jenkins, Jira, Confluence, SharePoint, Bitbucket, Git. Swagger.

Designed/Developed Prototypes, Minimal Viable Products. Authored and Published share Project Templates.

8/2019 - 3/2020 Pratt & Miller Engineering Web Developer Huntersville, NC Contract

Exposure to CI/CD and TDD methodologies including DI/IoC and mocking.

5/2018 - 5/2019 Healthstat Inc. Full Stack .Net Developer Charlotte, NC Contract

Delivered .Net ASP/MVC intranet to facilitate DevOps and Management Reporting.

Refactored custom Outreach solution to optimize operations and data management.

Developed corporate Data Exchange applications and integrations.

Published detailed application specifications and documentation on Confluence.

Managed SDLC for several SQL Server data servers and a dozen databases.

Supported and enhanced web applications and APIs for corporate products and services. Swagger

Implemented custom encryption processes for client, partner, and vendor data integration.

Managed core libraries for webhook integrations with Twilio, Sendgrid and SurveyMonkey.

Developed extensive data structures and sql procedures for complex requirements.

Championed compliance initiatives, including data masking and encryption.

Partnered with Data, Reporting and Support teams to evolve Data Governance practices.

Provided operational support including troubleshooting, query profiling and tuning.

Created data marts and metrics for management reporting and monitoring.

1/2018 – 4/2018 CCCommunications Full-Stack Web Developer Charlotte, NC Contract

Custom Web Development and Hosting ISV. Modernization of legacy ASP Webforms C# VB SQL 2014

https://cccommunications.com/

10/2017 – 1/2018 Food Lion Systems Analyst Salisbury, NC Contract

Loss Prevention Applications. Vendor Relationship Management and Integrations.

Analyzed and documented technical architecture of departmental applications portfolio.

Delivered technical support for corporate merger. Coordinate of offshore development efforts and resources.

10/2015 – 7/2016 Bank of America SQL Developer/DBA Charlotte, NC Contract

Senior SQL Developer. As part of a platform decommissioning project, remapped and resourced data from existing source (Oracle) to a new source (DB2). Developed a single complex queries using Common Table Expressions to extract source data from DB2 to SQL Seraver for federal compliance and reporting purposes. Implemented a monthly scheduled job in SQL Server to import the new data feed using an SSIS package with extensive data validation, logging and quality controls. Refactored existing SSIS packages for data source decommission/migration efforts. Supported .and extended solutions for evolving business and compliance requirements. Contributed to architecture /design specifications for Hadoop implementation.

7/2014 – 5/2015 Lending Tree SQL Developer DBA Charlotte, NC FTE

Delivered enhancements and provided operational support for SSIS data integrations.

Participated in the development of new data and web applications and system interfaces.

Coordinated offshore development efforts and logistical collaborations.

Senior DBA. As a member of the DBA team, responsibilities were evenly split between administration/operations and new design/development to support both transactional and reporting databases for corporate website. SQL SSIS/SSRS 2012, 2008R2, C#, SDLC.

7/2013 – 2/2014 Hewlett Packard Systems Administrator Charlotte, NC Contract

Lead efforts to upgrade and remediate web solutions and vendor integrations.

Maintained SQL databases, stored procedures, triggers, functions, and views.

Performed troubleshooting and code modifications to reduce database contention.

Provided technical support to internal delivery teams for optimized service scheduling.

Modernization of extended data integrations with clients and vendors.

Promote best-practices and formal SDLC processes. Implemented TFS.

Architect, design and develop next-gen POST solution on SQL 2008R2, .net 3.5+

Microsoft SQL Server 2005 – 2010 + SSIS ASP .Net 2.0 - 3.5 C# VB

SQL Server administration Visual Studio 2005/2008/2010

Web Services (REST) CVS, TFS 2008/2010 Microsoft Sharepoint Classic ASP

IIS Administration Feature development Operational support

12/2012 – 7/2013 Bank of America Database Engineer Charlotte, NC Contract

Implemented a custom supportability framework for complex SSIS integrations.

SQL development for new and existing web and ETL processes and interfaces.

Mentoring and developed complex SQL queries, procedures, and dataflows.

Facilitating the implementation of software solutions throughout the SDLC

Create, Organize and Manage Work Requests to DBAs, etc for such deployments

Low- Level Design/Architecture Code Reviews Mentoring Performance Tuning

Technical Subject Matter Expert for specific applications supporting Home Mortgage

Microsoft SQL Server 2008/R2 DB2 Oracle .Net 3.5 C#, VB SOAP REST

SSIS Visual Studio 2008,2010 TFS Sharepoint Visio Splunk 4.3.5

9/2012 - 11/2012 Bank Of America Website Developer Charlotte, NC Contract

As a Senior Consultant to the BART team (Bank of America Networked Device Reporting Tool), I was a major contributor to the development of a new release of a core enterprise solution. Specifically, I was tasked with:

Auditing all levels of user access to specific database resources. I automated this function and documented standard procedures for the reporting. Identifying unused, redundant and unnecessary database objects and related “dead code”. This entailed reviewing the code-base in the Subversion repository - both web, ETL and Workflow OLTP applications. Analyzing database deadlocks in the production environment.

Analyzing and resolving documented application issues. Traced the root-cause of the issue to a stored procedure in the database. I moved a column from the child to the parent table to correct a data modeling error. I also remediated the existing, dependent objects, isolated to a few stored procedures. Additionally, I communicated with members of the offshore team responsible for maintaining the Web interface for the BART workflow application - as they had hard-coded SQL in the Presentation-Tier code.

Implement / Rewrite SSIS ETL Import for Corporate Directory - (RDR). Replace existing flat file (push) interface with dynamic real-time query directly against the Oracle database. Document gap-analysis between old and new schemas. Implement new datasources for the new and legacy reports.

1/2011 – 6/2012 Wells Fargo Apps Systems Engineer V Charlotte, NC FTE

Maintained operational datastores and related processes for monthly data integration.

Facilitated centralized analytics and operational reporting for regulatory compliance.

Developed custom frameworks for the management and maintenance of SSIS packages.

Promoted SDLC processes, tools, and metrics to ensure quality solution delivery.

3/2010 - 7/2010 Bank of America SQL DBA Charlotte, NC Contract

Developed custom metrics and analytical reporting for call center operations.

Supported and maintained corporate data warehouse integrations.

Designed corporate SQL data repository with custom sharding algorithms.

Vendor Integrations, departmental datamarts, centralized reporting.

10/2008 – 9/2009 Duke Energy Software Engineer Charlotte, NC Contract

Architectural design, configuration, extension, and implementation of a vendor solution.

Systems analysis, requirement management, quality assurance process.

7/2001 - 9/2008 Compass Group .Net Developer Charlotte, NC FTE

Lead development of custom application for inventory and accounting operations.

Database management and enterprise reporting.

Architectural Oversight. SDLC implementation.

8/2001 - 12/2001 Washington Mutual .Net Developer Charlotte, NC FTE

Lead development of custom application for inventory and accounting operations.

Database management and enterprise reporting.

Architectural Oversight. SDLC implementation.

3/1998 - 7/2001 Renaissance Interactive Web/SQL Developer Columbia, SC FTE

System, Application, Database Management, Desktop and Network Administration

Development and Operations of custom web applications and hosting solutions.

Administered, Monitored and Maintained scheduled batch jobs.

Independently achieved both MCSD and MCDBA twice! Comptia’s iNet+ Certification (web fundamentals)

DNS Administration and Support I held many roles at this Pre-IPO.com – Multi-tenant hosting, CDN implementation and custom development. Visual Studio, Biztalk, SQL Server, MMC, MSMQ, IIS, DNS, AD, Classic ASP, Ajax, ADO, MDI, MS Access, OLE, COM, DCOM

8/1997 - 3/1998 Affinity Technologies Group Sybase Server 11 DBA Columbia, SC FTE

As a junior DBA, I was responsible for implementing and supporting several LOB-specific Sybase Server 11 database silos. I developed complex database stored procedures to implement complex, evolving business requirements. Responsible for replication, monitoring, operations and 24X7 support. The operating environment included Windows NT 4, Sybase SQL Server, OS/2, DB2, IIS 3.0.

1/1995 - 3/1997 Technology Solutions, Inc. Software Engineer Columbia, SC FTE

Consultant for clients such as SC Department of Revenue, SC Department of Child Support Enforcement, SC Department of Mental Health, Square D Corporation and SC Electric & Gas Company

Powerbuilder (3.0?) MicroFocus COBOL PL/1 Unix SVR4 Informix RDBMS Lotus Notes

1/1994 - 12/1994 Policy Management Systems Corporation Systems Analyst Blythewood, SC Contract

Microfocus COBOL, OS/2, MVS/CICS/DB2. Series III Life and Reinsurance were the primary business domains. Served concurrent roles – every role defined for Agile sdlc.

8/1989 - 9/1993 Duke Power Company Applications Programmer Charlotte, NC FTE

Production Operations, development and facilitation of full SDLC. Applications included IBM mainframe PL/1, MVS/JCL/CICS/IMS and DB2, Knowledgeware ADW, Microfocus COBOL, OS/2, Lotus Notes, Novell Netware. Primary business domains were omaterials management and asset accounting.

Implemented POC for WFH with take-home laptops with an external, musical modem.

Desktop development. Embarcadero. Erwin. Borland Pascal. Smalltalk.

Application Development Workbench (ADW) it is an integrated CASE-based application development system that runs under OS/2 originally from Sterling Software. It includes a variety of tools for designing and developing client/server, AS/400 and IBM mainframe applications.

6/1985 - 5/1989 Winthrop College Systems Manager Rock Hill, SC FTE

Education

Microsoft Learn 1990 + online

Strayer University 2008-2010 Charlotte, NC MIS *75%

Winthrop College 1985-1989 Rock Hill, SC BS CSC/MAT/PHI

Lancaster High School 1982-1985 Lancaster, SC HSD

Certification

Microsoft Certified Professional Transcript

Microsoft Certified Professional : ID 1127030

MCP

1998

Microsoft Certified Solution Developer : Visual Studio 6.0

MCSD

1998

Microsoft Certified Database Administrator : SQL Server 2000

MCDBA

2001

Microsoft Certified Application Developer : Microsoft .Net

MSAD

2004

Microsoft Certified Solution Developer : Microsoft .Net

MCSD

2004

Skills

Agile Evangelism. Centers of Excellence. Sprint Planning, Backlog Refinement, Code Reviews, Retrospectives

Project, Product and Delivery Management

User Advocate. Empowering Business Users, Citizen Developers, Product Owners, Testers and Analysts

Continuous Improvement.Embracing New Technologies and Perpetual Process Optimization

Team Player – building cohesive, cross-functional, high-performance delivery pipelines

Dedicated to delivering quantifiable value and defining meaningful metrics

Champion of Citizen Developers and Governed Self-Service

Highly Effective Communicator and Collaborator with Continuous Process Refinement

Champion of Quality Initiatives Requirements Management and Traceability

Requirements Traceability, Code Reviews, Source Control and Versioning, CI/CD

OOA/OOD Agile SDLC, Instrumentation and Monitoring, Metrics and Reporting

Labeled and Repeatable Builds, Pipeline Automation, Performance Profiling

Implement integrated DevOps and Administration Portals, Instrumentation, Metrics

Leverage Entity Framework WebApi CRUD project, Generate Test Stubs

Define, Measure and Manage meaningful Metrics and KPIs ITIL

Data Expertise

Extensive SQL Server experience – since Sybase Server 11 On OS/2 circa 1990

Expertise in Microsoft, Oracle, DB2, Informix, Sybase, Hadoop, Mongo, et al

Data access expert – presentation, integration, migration, and transformation

Database Design, Modeling, Analysis, Operations, Deployment, and Support

Ensuring supportability, scalability, performance, security, and availability

Expert T-SQL skills, stored procedures, materialized views, columnstore indexes

Diagnosis and resolution of Performance, Concurrency and Scalability issues

OLTP/OLAP/Stream Performance monitoring and query tuning.

ADO OLEDB LINQ Entity Framework

Custom Reporting Solutions SSRS, MicroStrategy, Business Objects

Extensive experience with SSIS/DTS, SSDT, SSMS, Visual Studio

Creative custom data ingestion, presentation, integration, and exchange

DevOps and Administration

Azure DevOps, TFS, Git SharePoint, Rational ClearCase/ClearQuest Functional Test

Internet/Intranet Web Server, and SharePoint Administration

Contact this candidate