Experience

• 

  Tata consultancy services

  • Baltimore, Maryland, United States

  • Production Operations Support Specialist at Exelon and Constellation

    • Jan 2021 - Present
    • Baltimore, Maryland, United States

    Supporting Microsoft Dynamics 365 CRM and Microsoft Dynamics Great Plains CRM, Power Platform, Power BI, Power Target, Power Apps, BizTalk Integration, MS SQL Server databases, Microsoft SSIS, Microsoft SSRS, Oracle SQL Databases, .NET, eSmartConnect, Cincom CPQ, SQL Azure, and other related applications. Incident Troubleshooting, Minor Enhancements, Agile SCRUM processes, Integration troubleshooting, User Management.

• 

  Tata Consultancy Services

  • Lead Customer Onboarding Specialist Vendor for Freshworks

    • Jan 2020 - Sep 2020

    Lead IT Consultant from TCS asLead Customer Onboarding Specialist 1/20 – 9/20Freshworks [Freshworks CRM, Freshsales, Freshworks 360, Freshsuccess]Post: Freshworks Remote Worker from Edmonds, WA Onboarding customers into the products, primarily Freshsales• Worked with customers to help them choose what aspects of Freshworks applications are best to suit their needs. • Helped and trained customers in how to configure their Freshsales, Freshworks CRM, and/or Freshworks 360 instances to best fulfill their business requirements.• Gave demonstrations to customers about aspects of their Freshsales or Freshworks CRM instances in order to help them choose.• Offered up Best Practices for optimal use of Freshsales, Freshworks CRM, or Freshsuccess.• Worked as integral part of a team for larger implementations of Freshsales and Freshworks 360.• Freshworks apps follow a MVC pattern, which gives me more MVC experience. • Integrations using REST APIs and using built in apps.

  • Lead Concierge Support Specialist Vendor for Microsoft

    • Jul 2019 - Dec 2019

    Lead IT Consultant from TCS as Lead Concierge Support Specialist Tata Consultancy Services training for Microsoft [Microsoft Dynamics 365 CRM, Microsoft Dynamics 365 Power Platform]Post: TCS Washington State Office (Bellevue, WA) PowerApps and Flow Support; PowerApps and Flow Development; Mentor to Support Analysts.• Training up to join project as Mentor and Support Specialist in Microsoft’s Concierge Support Team.o Canvas Apps, including more than one data input sourceo Model Driven Apps, including connecting a Canvas App into a Model Driven Appo My data background in MS SQL Server administration helped me to quickly learn and understand how to create connections and set up reports in Power Platforms Reporting (before it was renamed to Power BI)o Model Driven App integration with Microsoft Teams, Outlook, Excel, Word, MS Forms, and several data connectors including SharePoint List. o The bulk of our automation training was in using Power Platform Model Driven Apps to trigger MS Flow and other automations with an intake form, processing based on choices, and sending out notifications via email that were set up to personalize based on the target audience, the form, the app and the intake data points. o Worked with tables, charts, dashboards, and attaching any of those to notifications.• Model Driven apps use a MVC pattern, so I have used and trained in MVC pattern development styles.• Mentor to India team in Power Platform.• Helped troubleshoot coworkers’ apps• Certificate in Dynamics 365 Power Platform Applications• Certificate in Dynamics 365 Power Platform Automation.

  • Operations Systems Engineer Tier 2 Vendor at Microsoft

    • Nov 2018 - Jun 2019

    Tata Consultancy Services (TCS)Operations Systems Engineer Tier 2 4/18 – 6/19Microsoft [Microsoft Dynamics 365 CRM]Post: Microsoft Dynamics Operations Center (Bellevue, WA) Operations Technician Level 2; Systems Engineer; MS SQL Server Specialist.• Customer Reported Investigations and Tier 2 Support of Dynamics CRM. Working with databases in SQL 2012, 2016, 2017 and Azure. Backups, restores, Organization moves and copies. Upgrades to more current versions. Organizations and customers all over the world. Working with 15,000+ databases and all of the supporting servers.• Subject Matter Expert in SQL Server Administration; SQL Backups, Mirroring, Transact-SQL code, performance.• CJIS GCC Security clearance achieved for government server and database access.• Liaison to CSS and Development teams. • Helping to update and change how-to guides for processes using TSG Wiki.

• 

  IDC Technologies, Inc.

  • Bellevue, Washington USA

  • Operations Systems Engineer Tier 2

    • Apr 2018 - Nov 2018
    • Bellevue, Washington USA

    IDC Technologies through TCS, posted at MicrosoftOperations Technician Level 2; Systems Engineer; MS SQL Server Specialist.• Customer Reported Investigations and Tier 2 Support of Dynamics CRM. Working with databases in SQL 2012, 2016, 2017 and Azure. Backups, restores, Organization moves and copies. Upgrades to more current versions. Organizations and customers all over the world. Working with 15,000+ databases and all of the supporting servers.• Subject Matter Expert in SQL Server Administration; SQL Backups, Mirroring, Transact-SQL code, performance.• Liaison to CSS and Development teams. • Helping to update and change how-to guides for processes using TSG Wiki.

• 

  Self-Employed

  • Greater Seattle Area

  • Freelance IT Consultant

    • Apr 2016 - Apr 2018
    • Greater Seattle Area

    Took a sabbatical from employment to help my then 86 year old mother move into assisted living.

• 

  Flatiron Health

  • Worked as a Remote Employee from home for New York company

  • Senior Database Administrator and Systems Engineer

    • May 2014 - Apr 2016
    • Worked as a Remote Employee from home for New York company

    MS SQL Server Specialist; MS SQL Server Database Administrator; Systems Specialist. SQL 2008 R2, Windows Server 2008 R2, SQL 2012, Windows Server 2013, SQL 2014, Windows Server 2013 R2• Documented all of the legacy processes, including scripting that I created• Trained and mentored new Systems Operations teammates• Implemented and Maintained the Disaster Recovery solution• Encouraged, designed and implemented migrations to new hardware and software, including a new SAN• Scripted, applied, troubleshot and updated SQL Transactional Replication • Added websites using IIS, pairing them with SQL databases• Deployed SQL changes to our application• Managed the firewalls, DNS servers and IPs for our website front ends. • 21 years of MS SQL Server Database Administration experience, with Windows Server, IIS, systems, and networking.• Managed all user accounts and security through our migration to Active Directory in Windows Server 2013 R2• Kept the wheels on through the transition to Flatiron after acquisition, staying on top of all issues SQL and server related

• 

  Altos Solutions

  • Worked as a Remote Employee from home for Los Altos California company

  • Senior Database Administrator and Systems Engineer

    • Aug 2009 - May 2014
    • Worked as a Remote Employee from home for Los Altos California company

    MS SQL Server Specialist; MS SQL Server Database Administrator; Systems Specialist.SQL 2005, Windows Server 2003, SQL 2008 R2, Windows Server 2008 R2, SQL 2012• MS SQL Server Administration Specialist and Systems Specialist, I was the Database IT Department of this startup.• Set up and maintained the Disaster Recovery solution, saving data during a catastrophic hardware failure• Innovated, designed, implemented and maintained SQL Transactional Replication to a reporting system using SSRS, to help overall performance of both OLTP and reporting. • Encouraged, designed and implemented migrations to new hardware and software, including a SAN solution, speeding up the I/O• Spun up new servers, new databases, and split up databases by practice, to load balance for performance and manage growth• Brought performance solutions and Best Practices to the table through index management and • design, SQL file management and SAN innovation.• Managed the firewalls, domains, DNS and IPs for our website front ends, FTP/SFTP servers, and helped design VPN tunnels.• Mentored the QA and testing teams on best practices• Employed third party tools (Solarwinds Database Performance Manager, Red Gate Toolbelt) to work on performance issues and backup solutions• Primary liaison to Rackspace Hosting—Dallas and Chicago data centers, including troubleshooting all server and SQL issues.• Managed all accounts in Windows and SQL for all team members, including client VPN accounts.• Set up and managed our Exchange server.

• 

  Microsoft

  • IT Service Release Engineer, SQL DBA focus

    • Dec 2008 - Jul 2009

    SQL 2005, SQL 2008, ITIL, Octopus, MOF, TFS• Managed customers' expectations to schedule maintenance windows for deployment, communicating and enforcing those schedules and performing the deployment of software updates, hardware upgrades, projects, and post-production bug fixes and changes to the Business Group Center of Excellence production SQL systems. • Integral part of the creation of the Business Group IT Service Transition Change & Release team’s initial groundbreaking process documentation.• All projects and changes deployed to Business Group Center of Excellence production environment on time and with no post-production issues as a result of the deployments. • Led discussions and drove creation of Release Validation section of Change and Release Runbook (the process definition document) for BGIT Service Transition Team. • Added value to BGIT Service Transition Team’s Runbook creation by offering expertise based on over 10 years of experience to complete other four sections of the Runbook’s overall process definition and best practices. • Facilitated adoption of Octopus deployment tool for two applications, bringing them to a one-button deployment from many manual steps. • Collaborated with development engineers on automation techniques within the tool to maximize deployment optimization.

  • IT Operations Engineer, SQL Focus

    • Aug 2008 - Dec 2008

    WTT 2.6, SQL 2005• Brought on to the Windows Testing Technologies (WTT) team (part of Business Group IT) for my expertise and best practices in change and release processes which incorporated SQL. • Deployed WTT upgrade to version 2.6 to three Enterprises’ installations of the tool set, using a SQL database in the automation. • Managed change, release and deployment activities and schedule from IT perspective for four Enterprises. • Liaison to WTT Development team. • Integral part of successful transition of change, release and deployment activities from BGIT to Windows product team.• Managed and implemented two Quarterly Fix Engagements (QFEs) of the Automated System Install (ASI) tool into five Enterprises. Coordinated the simultaneous deployment into all systems internationally, overcame unforeseen complications, and finished well within the maintenance window. This effort contributed significantly to Windows 7 meeting its testing schedule milestones. • Drove release management process adoption to improve deployment automation strategies using SQL databases, reducing deployment times for WTT QFE by 30%.

  • IT Database Operations Support Specialist

    • Jun 1999 - Aug 2008

    • DBA from SQL Server version 4.21a to version 2008R2, Database MVP.• Active Directory certification in Windows 2000 Server. Trained in Microsoft SQL Clusters• Tier 2 SQL Database incident support and issue management, post-production bug & change ticket creation and submittal, follow-through with Developers and Testers on post production bugs and changes, and deployment of fixes and changes to Business Group Center of Excellence production environment for several in house applications based in SQL Server. • Primary world-wide escalation point for complex SQL issues and problems for more than 20 tools.• Imagined, Implemented and enforced a monthly release cycle for post-production bug fixes, moving away from an ad-hoc release strategy. This resulted in a 60% reduction of reported incidents within one month of this policy change.• Innovated and optimized cross-continental SQL replication re-initialization process, re-writing scripts and reducing variables resulting in an 80% reduction in process time. Reduced need to re-initialize from weekly to once in six months.• Caused influential Program Manager to believe in Support team for the first time.• Created post-production bug fix change and release process from the ground up using SQL databases, implementing automation, quality assurance and checks and balances into the process, resulting in 40% reduction in post-deployment bug count.

• 

  BEST Consulting

  • IT Database Operations Consultant at Microsoft

    • Aug 1995 - May 1999

    IT Operations Database Consultant at MicrosoftPosted at Microsoft on Operations IT team--which became Business Group Center of Excellence• Responsible for incident support and issue management, post-production bug & change ticket creation and submittal, and deployment of fixes and changes to production environment. Escalation point for issues and problems from the business team. • First Support Analyst to participate in major project from Pre-Baseline throughout the project life cycle to production deployment, bringing operations, configuration and support perspective to the table. • Responsible for support of the two most problematic and complex tools in the system. Increased customer confidence in data quality and stability for both systems through submittal and follow-through of bug reports, turning around the reputation of Database Operations Support to make the Support team a featured highlight of the Management Reports for two consecutive quarters.Database Operations Administrator 1995-1997Posted at Microsoft on IT Database Operations team• Responsible for troubleshooting and fixing server-side back end issues with the more than 2200 SQL Server databases in the SQL data center used by all of Microsoft. • Installed SQL Server onto new servers. • Upgraded to new versions of SQL Server. Installed Service Packs. • Troubleshot configuration and operational issues. • Managed and maintained SQL backups. Managed and maintained data flow between servers using Transaction Server Backup and SQL Replication. Offered expertise on initial configurations for new or upgraded SQL installations.• Created and maintained pre-SQL-Replication data flow strategy between Redmond, Dublin Ireland and Sydney Australia using transaction backup tool.• Averted data loss in Microsoft Product Definition tool set during flooding emergency in the server room by cutting over to backup server set and powering down rack of servers until AC system repaired and water removed.

• 

  Skylight Software

  • Program Manager

    • Jun 1994 - Jul 1995

    Helped to significantly increase the number of projects completed. Interfaced with customers like Microsoft to set the scope and workflow for projects. Managed the projects at Skylight, working with the Development Manager and team to apply appropriate resources. Delivered finished projects to customers.

• 

  Autodesk

  • Senior Technical Support Technician

    • Apr 1989 - May 1994

    Telephone support of all CAD applications from Generic CADD line, including printing, vector graphics and font creation for both DOS and Apple Macintosh (System 7.5) version.