Dennis Manning

Dennis Manning Email and Phone Number

Senior Data Analyst at Core BTS @ Core BTS
Dennis Manning's Location
Cobleskill, New York, United States, United States
Dennis Manning's Contact Details
About Dennis Manning

• Extensive experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000, 2008, 2012 and 2014 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2000/2005/2008/2014.• Install and manage DB2, PostgreSQL and MySQL servers.• Data Migration Management.• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.• Create maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.• Create ETL Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.• Extensive skills in writing Distributed Queries between SQL Servers by creating link servers.• Implement different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.• Perform integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.• Experience in applying patches and service packs to keep the database at current patch level.

Dennis Manning's Current Company Details
Core BTS

Core Bts

View
Senior Data Analyst at Core BTS
Dennis Manning Work Experience Details
  • Core Bts
    Senior Data Analyst
    Core Bts May 2020 - Present
    Indianapolis, In, Us
    - Convert data into actionable insights by predicting and modeling future outcomes.- Present tools and recommendations to directors and executive staff.- Work with Data Warehousing and Microsoft Reporting Services.
  • The Sage Colleges
    Adjunct Professor
    The Sage Colleges Mar 2006 - Present
    Troy, Ny, Us
    Teach courses that are designed to cover the spectrum of organizational information needs. Provide understanding of the uses of information by operational subsystems such as production, finance, marketing, and personnel. Show students how to analyze the information needs of middle and top-level management and the use of information systems to aid managers in the decision-making process. Aid students in reaching an understanding of the use of information systems to gain a competitive advantage on how to manage information as an organizational resource.
  • Davis Vision
    Database Administrator
    Davis Vision Feb 2015 - Feb 2020
    San Antonio, Tx, Us
    Provide IT support for the review, analysis, troubleshoot and repair of database issues for: Microsoft SQL Server, DB2, MySQL and PostgreSQL. In addition, build and monitor SSIS and SSRS - Reporting solutions. Daily activities include working with various business departments examining needed changes in technology based on health care and insurance industry trends.
  • The Ayco Company, L.P., A Goldman Sachs Company
    Senior Database Administrator
    The Ayco Company, L.P., A Goldman Sachs Company Apr 2011 - Feb 2015
    Cohoes, New York, Us
    Direct and perform all activities related to maintaining the database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. Administer the maintenance of 22 Microsoft SQL Servers 2008. This work is my sole responsibility in the Albany, New York region. While in this role I have deployed and monitored Change Data Capture (CDC) monitoring daily activities by employees to insure compliance and regulatory needs are met. In addition, have successfully migrated several SQL servers from earlier versions of Microsoft SQL Server to SQL Server 2008.
  • Startech Total Data Solutions
    President And Owner
    Startech Total Data Solutions Feb 2006 - Apr 2011
     Develop and teach Advanced SQL querying techniques for government agencies and private companies. Create of data migration solutions from legacy software and Non-Microsoft products involved introducing XML technology utilizing XML and batch processing. This work was completed by using SQL programming and SSIS assemblies. Devised IT Infrastructure Library (ITIL) training with a strong focus on IT service management (ITSM) for companies in three states. Designed six training modules covering service support, service delivery, service management implementation planning, ICT infrastructure management, and applications management.  Successfully planned, organized, and managed outsourced IT projects in Uruguay, China, and India. Efficiently completed projects on time and within budget, including e-commerce solutions, Web site development, and software development. Utilized service-oriented architecture (SOA) standards to modularize the business logic of applications, improving the ability to build applications. Established a Structured Query Language (SQL) class to cover the concepts of relational databases and the SQL programming language and provided students an opportunity to practice what they learned using the online SQL interpreter.  Successfully planned, organized, and managed outsourced IT projects in Uruguay, China, and India. Efficiently completed projects on time and within budget, including e-commerce solutions, Web site development, and software development. Utilized service-oriented architecture (SOA) standards to modularize the business logic of applications, improving the ability to build applications.
  • Worldwide Learning Services
    Vice President
    Worldwide Learning Services Feb 2003 - Feb 2006
    Successfully managed IT staff and several network projects, directing database, LAN/WAN technology, training, support, telephony, e-mail, and security. Led all phases of IT projects, including needs analysis, requirements definition, vendor selection, implementation, and training. Designed infrastructure and implemented technology to support large user groups. Translated business needs into technology requirements that effectively supported customer business objectives. Controlled budgets.• Up gradation of Database from SQL Server 2000 to 2005. • Installed & configured database software, associated database tools and performance monitoring software. • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. • Performed acceptance testing to verify that database changes perform without adverse consequences. • Estimated disk storage requirements for database software, database files & database administration needs. • Provided optimal database file layout for utilization of storage and performance acceptable to client. • Participated in meetings impacting databases physical design.

Dennis Manning Skills

Databases Microsoft Office Microsoft Sql Server Sql Customer Service Troubleshooting Project Management Microsoft Excel Leadership Data Analysis Networking Team Building Access Management Public Speaking Microsoft Access Security Microsoft Word Servers Team Leadership Software Development

Dennis Manning Education Details

  • Norwich University
    Norwich University
    Management
  • Empire State University
    Empire State University
    Labor Studies
  • Southern Vermont College
    Southern Vermont College
    Business Management
  • State University Of New York College Of Agriculture And Technology At Cobleskill
    State University Of New York College Of Agriculture And Technology At Cobleskill
    General

Frequently Asked Questions about Dennis Manning

What company does Dennis Manning work for?

Dennis Manning works for Core Bts

What is Dennis Manning's role at the current company?

Dennis Manning's current role is Senior Data Analyst at Core BTS.

What is Dennis Manning's email address?

Dennis Manning's email address is dm****@****ion.com

What is Dennis Manning's direct phone number?

Dennis Manning's direct phone number is +151827*****

What schools did Dennis Manning attend?

Dennis Manning attended Norwich University, Empire State University, Southern Vermont College, State University Of New York College Of Agriculture And Technology At Cobleskill.

What are some of Dennis Manning's interests?

Dennis Manning has interest in Civil Rights And Social Action, Science And Technology, Children.

What skills is Dennis Manning known for?

Dennis Manning has skills like Databases, Microsoft Office, Microsoft Sql Server, Sql, Customer Service, Troubleshooting, Project Management, Microsoft Excel, Leadership, Data Analysis, Networking, Team Building.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.