Manage data migrations resulting from acquisitions into a single existing Salesforce instance utilizing Extract, Transform, and Load (ETL). Have assumed the role of Technical Project Manager and Data Architect. Built and maintained strong relationships with subject matter experts in the acquired companies, members of Operations teams, and consultants. Data migration projects average six months in length and are broken into phases. Following an agile methodology, work within each phase consisting of: identifying source systems and objects; defining the scope of records to migrate from each object; mapping source system fields to target system fields; specifying transformation rules to perform on data from the source system; creating new custom fields in the target system as needed; and writing scripts to perform the migration. Each phase includes at least three User Acceptance Testing sessions where migration scripts are executed in a sandbox environment and validated for adherence to requirements.Facilitate scope definition and field mapping from multiple source systems including Salesforce, MS Dynamics, and Zendesk. Use SQL to conduct complex analysis of results throughout the project lifecycle to identify patterns and locate issues not easily detected by traditional user testing, which results in faster progress, greater accuracy, and lower project costs. To date, have successfully completed five migration projects with the most recent ending 35% under budget.Key Accomplishments and Achievements• The source system for one data migration was a highly-customized Microsoft Dynamics system with no documentation and no available resources with knowledge of the database. Through reviewing the schema, using SQL to query the data and understand the relationships, and referencing documentation for standard Dynamics implementations, was able to reverse-engineer the database.

Participated in the creation of the Project Management Office (PMO), a department that defined and maintained standards for project management within the company. Engaged in frequent interactions facilitating coordination between all areas of the internal organization, external clients, and partners. Concentrated on analyzing and refining processes for software implementation projects including new installations, product upgrades, and add-on sales as well as migrations between multi-tenant cloud, dedicated servers and hybrid environments with a focus on continuous improvement and enhanced outcomes. Collaborated with different Project Managers and teams of installers in order to understand current processes and then made recommendations to im

Reporting to the Software Development Manager, led a team of thirteen software developers with varying levels of experience to correct defects in the Student Information System software. Set team and individual goals, monitored team and individual metrics, conducted quarterly and annual performance reviews. Built and maintained relationships with internal clients, external clients and partners. Internal clients included Product Management, Support Help Desk, Software Installers, and other teams of developers that worked on new development, customizations, and state reporting/regulatory modules. External clients included the members of school district staff that provided support to their users.Collaborated with team members working towards the resolution of support tickets for problems resulting from software defects. Maintained a workload of defect tickets in addition to team lead responsibilities.Key Accomplishments/Achievements• Analyzed, designed, and implemented SQL views for 32 third party software interfaces.• As Merge Master, merged changesets to multiple branches across software versions in Team Foundation Server.• Had all developers’ systems upgraded to solid state hard drives for operating system and programs, 1TB data drives, and 16GB of memory. Since the developers ran resource-intensive applications on their local systems, the improved system performance reduced the amount of time spent waiting for queries to execute and software to compile. Due to the improved efficiency, this became the company standard for developers’ systems.• Eliminated approximately 30% of backlog over a year old by contacting clients to review aging tickets.• Led an initiative to provide hypercare to clients that had been identified as at-risk of leaving. In all instances, the backlog of open issues for these clients were reduced and customer satisfaction levels rose. • Received Leadership Excellence Award from the company CEO twice, in August 2014 & September 2015.

Employed multiple troubleshooting techniques to identify and correct the root cause of reported software problems in Student Information System software that was used by school districts for functions such as student registration, attendance, scheduling, report cards and transcripts. Issues ranged from small bugfixes to large defects requiring extensive analysis and design across software subsystems. Used SQL Server, Visual Studio, and Team Foundation Server to maintain web-based software applications written in HTML, Classic ASP, Visual Basic, ASP.NET, VB.NET and JavaScript. Interacted with Support, QA Testers, Product Management, other Software Developers on the same and different teams, along with external clients and partners to identify, correct and verify resolution. Versed in Software Development Life Cycle (SDLC).Key Accomplishments/Achievements• The Student Information System software included subsystems for processing Interim Progress Reports, Report Cards, and Transcripts. Reviewed the functions within these subsystems, identified inconsistencies across similar features, and made modifications to standardize the user interface (UI), underlying database table structure, and reporting options. • Worked closely with Quality Assurance (QA) to ensure changes functioned as designed and passed regression testing to ensure other features were not unintentionally impacted. • Received Exceptional Customer Service Awards in February & June 2013.

Founded and built a business from the ground up to an annual revenue of $500K, maintaining consistent expansion even through economic downturn with annual growth of 40-200%. Expanded from a home office to a 4K sq. ft. office with an integrated service center and sold the business after 7 years.• Actively participated in all aspects of running the business including planning, financial management, human resources, customer service strategy, marketing, and sales. Documented processes and trained employees.• Initial focus was on residential services, which included new equipment (computer, printer, scanner, modem, router) setup and configuration, hardware upgrades and software installations.• Over time, expanded to serve businesses, offering services which included designing, implementing, and supporting networks, servers, and workstations; researching, procuring, installing, and configuring third-party applications to meet business needs; evaluating and advising on adherence to Microsoft licensing requirements.• Became a Managed Service Provider (MSP), offering subscription plans from $99-$3.5K per month, which produced reliable recurring revenue. Options such as proactive Remote Monitoring and Management (RMM) and Backup and Disaster Recovery (BDR) solutions resulted in greater system stability for clients, increased perceived value, and improved retention. • Achieved Microsoft Small Business Specialist Certification• In 2010, received the Bronze Sales Achievement Award. In 2011, received both the Silver Sales Achievement Award and was nominated for Franchisee of the Year. Key Accomplishments/Achievements• Saved a local small business from losing years of historical CRM and accounting data when their ERP database became corrupt. Utilized low-level recovery tools, accessed data in text format at the disk level. Analyzed the text data, identified patterns, and searched the hard drive for data fragments.

Managed projects for a team of nine programmers, which included frequent customer contact, coordination with consultants, balancing priorities, monitoring scope and deadlines. Gathered requirements, estimated, analyzed and wrote detailed design specifications for new development projects and upgrade releases for existing applications.Used SQL Server and Visual Studio to support existing web applications written in Flash, HTML, ASP, C#, ASP.NET, XML. Acted as SQL Server Database Administrator.

Led a team of programmers to support software written in Java, JSP, HTML, XML, Magic and Stored Procedures to maintain data stored in a large-scale Oracle database. Acted as a liaison between Project Managers and Analysts within the organization and offshore developers employed by an outsourcing organization located in India.

Developed new and customized existing Informix-4GL programs on a UNIX platform in a system of software designed for use by insurance companies and agencies. Led initiative to expand service offerings to include web-based software using HTML, PERL/CGI, Java, JSP, JavaScript and Tomcat in Windows and Linux environments.

Managed long-term initiatives for client-driven product development and enhancements in Informix-4GL and SQL. This included frequent contact with customers, requirements gathering, analysis, design, specifications, managing scope, coordinating testing, writing documentation, performing installations and providing follow-up support.

Developed, customized and supported web-based, database-driven applications using SQL Server, ASP, HTML, and Visual Basic. Managed budget, timeline and scope of projects in the client portfolio.