| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
https://LINKEDIN LINK AVAILABLEEMAIL AVAILABLEPHONE NUMBER AVAILABLECharlotte, NCWith more than three decades of technical software development experience, I am currently seeking employment opportunities both within and without the Information Technology domain focusing on modelling, analytics, analysis and design. I hope to discuss the possibilities in detail with you soon.Sincerely,Candidate's Name
May 12, 2024Expertise:Extensive SQL Server experience.Expertise in Microsoft, Oracle, DB2, Informix, Sybase, Hadoop, Mongo, etc.Data access expert presentation, integration, migration, and transformation.Database Design, Modeling, Analysis, Operations, Deployment, and Support.Ensuring supportability, scalability, performance, security, and availabilityExpert T-SQL skills, stored procedures, materialized views, column store indexes.Diagnosis and resolution of Performance, Concurrency and Scalability issues.OLTP/OLAP/Stream, Performance monitoring and query tuning.ASP, WPF, Webform, Winform, 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.Azure DevOps, TFS, Git SharePoint, Rational ClearCase/ClearQuest, Functional Test.Internet/Intranet Web Server, and SharePoint Administration.Certifications:Microsoft Certified Professional: ID 1127030 MCP 1998Microsoft Certified Solution Developer: Visual Studio 6.0 MCSD 1998Microsoft Certified Database Administrator: SQL Server 2000 MCDBA 2001Microsoft Certified Application Developer: Microsoft .Net MSAD 2004Microsoft Certified Solution Developer: Microsoft .Net MCSD 2004Education:Microsoft Learn 1990 + onlineStrayer University 2008-2010 Charlotte, NC MIS *75%Winthrop College 1985-1989 Rock Hill, SC BS CSC/MAT/PHILancaster High School 1982-1985 Lancaster, SC HSDProfessional ExperienceCoca-Cola Consolidated, Inc. (Hybrid) Charlotte, NC Oct 2023 April 2024Data Integration EngineerBuild and enhance enterprise data services for use in enterprise integration scenarios.Actively participate in the technical design and development of APIs, data pipelines, etc.Leverage integration knowledge to develop efficient data movement across all solutions.Enable new APIs and enhances and configures existing APIs. Console, Web, WPF, scripts,C#, .Net, SQL, SSIS, JavaScript, Visual Studio, VS Code, SSIS, SSRS, Swagger, Azure, ServiceNowPostman, sFTP, Cassandra, Filezilla, Snowflake, ActiveBatch, UIPath, PowerBi PowerAppsProactive monitoring of system/integrations for long running jobsIdentify bottle necks and propose solutions to optimize queries/jobs.Technical documentation of systems and software programs for audit and support purposesBank of America, (Remote) Charlotte, NC Nov 2022 - Jun 2023Application Programmer VGlobal Consumer and Small Business -Anti-Money Laundering Remediation Tools Know Your Customer, OFACOperational Datastore. Metrics, Dashboard, Analytics and Central Reporting, Data Governance, Modernization.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.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.Resolved reporting latency with CQRS, snapshot isolation, SSRS/SSIS integrations and orchestration.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 connection strings 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. PC#/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, ETLPostman, Insomnia, LinqPad 6, Bitbucket, git, Jenkins, MSBuild, jFrog, Artifactory, Splunk, Insomnia, NugetAzure Key Vault, Azure CLI, ARM, Powershell, SQLCMD, Power Automate/QueryUnderwriters Laboratories, FL (Remote) Jul 2022 to Sep 2022Senior .Net DeveloperMaterials Data Collection Management - Wercsmart Product Studio - Azure Cognitive SearchMVC WebAPI Faceted Navigation Data Factory Web Apps Serverless FunctionsSolutions Re-Engineering - .Net Modernization, Development, API/ETL IntegrationsVS 2017-22/Code .Net 3.5, 4.6 --> 4.8 SQLlite 2014/16/Azure Microservices APIGatewayC# 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 TeamsReact Typescript jScript HTML WebPack Postman/Fiddler Redis nUnit, xUnit, MSTest, SerilogLPL Financial (Remote) Nov 2021 to Mar 2022Senior Integrations EngineerClientWorks - LPLs 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, eliminate third-party dependencies Kingswaysoft.Promote Low-Code solutions to empower clients and reduce development cycles. Leadership. Governance.Refactor workflows and processes to iteratively decouple report models from implementations.Consolidate interfaces, namespaces, and logical models publish and govern shared resources.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, O365Atlassian Artifactory TeamCity DynaTrace ServiceNowMaintain 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 HostedParticipate 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, CosmosDBBank of America (Remote) Apr 2020 to Nov 2021Applications Programmer IVGlobal Technology & Operations -- DAIT Data Analytics and Insight Technologies.Technical Leadership, Oversight. Project, Product and Delivery Management Architecture and Share Capabilities.Data Analytics and Insight Technologies department. Senior Developer. Mentoring, Code Reviews ArchitectureReplaced 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 VaultSQL 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.Pratt & Miller Engineering, Huntersville, NC Aug 2019 to Mar 2020Web DeveloperExposure to CI/CD and TDD methodologies including DI/IoC and mocking. Maintenance and Modernization of Several cloud-hosted workflow management, operations and reporting applications built on .Net Framework technologies supporting Retread operations for Continental Tires. C#, VB IIS EF SQL SSRS NPM Bitbucket.Healthstat Inc., Charlotte, NC May 2018 to May 2019Full Stack .Net DeveloperDelivered .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. SwaggerImplemented 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.CCCommunications, Charlotte, NC Jan 2018 to Apr 2018Full-Stack Web DeveloperCustom Web Development and Hosting ISV. Modernization of legacy ASP Webforms C# VB SQL 2014 Azure.Food Lion, Salisbury, NC Oct 2017 to Jan 2018Systems AnalystLoss Prevention Applications. Vendor Relationship Management and Integrations.Analyzed and documented technical architecture of departmental applications portfolio.Delivered technical support for corporate merger. Coordinate offshore development efforts and resources.Bank of America, Charlotte, NC Oct 2015 to Jul 2016SQL Developer/DBAAs part of a platform decommissioning project, remapped and resourced data from existing source (Oracle) to a new source (DB2).Developed a single complex query using Common Table Expressions to extract source data from DB2 to SQL Server 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.Lending Tree, Charlotte, NC Jul 2014 to May 2015SQL Developer DBADelivered 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 websites. SQL SSIS/SSRS 2012, 2008R2, C#, SDLC.Hewlett Packard, Charlotte, NC Jul 2013 to Feb 2014Systems AdministratorLead 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 integration 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# VBSQL Server administration Visual Studio 2005/2008/2010Web Services (REST) CVS, TFS 2008/2010 Microsoft Sharepoint Classic ASPIIS Administration Feature development Operational supportBank of America, Charlotte, NC Dec 2012 to Jul 2013Database EngineerImplemented a custom supportability framework for complex SSIS integrations.SQL development for new and existing web and ETL processes and interfaces.Mentoring and developing complex SQL queries, procedures, and dataflows.Facilitating the implementation of software solutions throughout the SDLCCreate, Organize and Manage Work Requests to DBAs, etc for such deployments.Low- Level Design/Architecture Code Reviews Mentoring Performance TuningTechnical Subject Matter Expert for specific applications supporting Home MortgageMicrosoft SQL Server 2008/R2 DB2 Oracle .Net 3.5 C#, VB SOAP RESTSSIS Visual Studio 2008,2010 TFS Sharepoint Visio Splunk 4.3.5Bank of America, Charlotte, NC Sep 2012 to Nov 2012Website Developer - ContractAs 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.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 codebase 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 from 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 data sources for the new and legacy reports.Wells Fargo, Charlotte, NC Jan 2011 to Jun 2012Apps Systems Engineer VMaintained operational data stores 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.Bank of America, Charlotte, NC Mar 2010 to Jul 2010SQL DBADeveloped custom metrics and analytical reporting for call center operations.Supported and maintained corporate data warehouse integrations.Designed corporate SQL data repository with custom sharing algorithms.Vendor Integrations, departmental datamarts, centralized reporting.Duke Energy, Charlotte, NC Oct 2008 to Sep 2009Software EngineerArchitectural design, configuration, extension, and implementation of a vendor solution.Systems analysis, requirement management, quality assurance process.Compass Group, Charlotte, NC Jul 2001 to Sep 2008Software EngineerLead development of custom application for inventory and accounting operations.Database management and enterprise reporting.Architectural Oversight. SDLC implementation.Washington Mutual, Charlotte, NC Aug 2001 to Dec 2001Software EngineerLead development of custom application for inventory and accounting operations.Database management and enterprise reporting.Architectural Oversight. SDLC implementation.Renaissance Interactive, Columbia, SC Mar 1998 to Jul 2001Web/SQL DeveloperSystem, Application, Database Management, Desktop and Network AdministrationDevelopment and Operations of custom web applications and hosting solutions.Administered, Monitored and Maintained scheduled batch jobs.Independently achieved both MCSD and MCDBA twice! Comptias 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, DCOMOther Experience: On requestCompetencies:Agile Evangelist Project, Product and Delivery Management.Empowering Users Embracing New Technologies and Perpetual Process Optimization.Sprint Planning, Backlog Refinement, Code Reviews, Retrospectives.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. |
